Cardinal Health
Cardinal provides Third Party Logistics (3PL) data for life science companies. This data includes information such as sales, inventory, and returns.
cardinal_customer_master__v
| charge_to__v |
varchar(10) |
Parent Company Account Number - could be same as customer number |
| charge_to_name__v |
varchar(40) |
Parent Company Account Name |
| charge_to_address_1__v |
varchar(40) |
Parent Company Address 1 |
| charge_to_address_2__v |
varchar(40) |
Parent Company Address 2 |
| charge_to_city__v |
varchar(20) |
Parent Company City |
| charge_to_state__v |
varchar(20) |
Parent Company State |
| charge_to_country__v |
varchar(10) |
Parent Company Country |
| charge_to_postal_code__v |
varchar(10) |
Parent Company Postal Code |
| customer_number__v |
varchar(10) |
Customer Account Number - could be same as Parent/ChargeTo number |
| customer_name__v |
varchar(40) |
Billing Location Account Name |
| customer_address_1__v |
varchar(40) |
Billing Location Address 1 |
| customer_address_2__v |
varchar(40) |
Billing Location Address 2 |
| customer_city__v |
varchar(20) |
Billing Location City |
| customer_state__v |
varchar(20) |
Billing Location State |
| customer_country__v |
varchar(10) |
Billing Location Country |
| customer_postal_code__v |
varchar(10) |
Billing Location Postal Code |
| customer_phone__v |
varchar(20) |
Billing Location Phone |
| customer_fax_number__v |
varchar(20) |
Billing Location Fax Number |
| customer_ship_via_code__v |
varchar(4) |
Code Identifying Shipping Method |
| customer_credit_limit__v |
numeric(12,2) |
Billing Location Credit Limit |
| customer_term_code__v |
varchar(2) |
Billing Location Term Code |
| customer_cot__v |
varchar(40) |
Billing Location Class of Trade |
| customer_pricing_group__v |
varchar(40) |
Billing Location Pricing Group |
| customer_territory_code__v |
varchar(4) |
Billing Location State Abbreviation |
| customer_hold_code__v |
varchar(4) |
Billing Location Hold Code |
| customer_810__v |
varchar(4) |
Flag to show if the Billing customer is setup to receive 810 |
| customer_856__v |
varchar(4) |
Flag to show if the Billing customer is setup to receive 856 |
| customer_warehouse_code__v |
varchar(12) |
Warehouse in which inventory is received. CORD100 is refer and Control, else CORD400 |
| file_name__v |
varchar(200) |
Name of file where record came from |
| file_load_time__v |
timestamp |
Timestamp of when file was loaded into Nitro |
cardinal_ship_to__v
| charge_to__v |
varchar(10) |
Parent Company Account Number - could be same as customer number |
| ship_to_number__v |
varchar(10) |
Shipping Location Account Number |
| ship_to_cot__v |
varchar(40) |
Class of Trade |
| ship_to_name__v |
varchar(40) |
Shipping Location Account Name |
| address_1__v |
varchar(40) |
Shipping Address 1 |
| address_2__v |
varchar(40) |
Shipping Address 2 |
| city__v |
varchar(20) |
Shipping City |
| state__v |
varchar(20) |
Shipping State |
| country__v |
varchar(10) |
Shipping Country |
| postal_code__v |
varchar(10) |
Shipping Postal Code |
| phone__v |
varchar(20) |
Phone Number |
| fax__v |
varchar(20) |
Fax Number |
| ship_via_code__v |
varchar(4) |
Code identifying shipping method |
| ship_to_dea_number__v |
varchar(30) |
Unique ID Identifying the Ship To (DEA/HIN/DUNS etc.) |
| warehouse_code__v |
varchar(12) |
Warehouse in which inventory is received. CORD100 is refer and Control, else CORD400 |
| territory__v |
varchar(4) |
State in which the Ship To is located |
| file_name__v |
varchar(200) |
Name of file where record came from |
| file_load_time__v |
timestamp |
Timestamp of when file was loaded into Nitro |
cardinal_shipments__v
| unique_id__v |
varchar(100) |
Ship Line ID + PPS+ item Number+ Lot Code+ Container Number + Tracking number |
| charge_to__v |
varchar(10) |
Parent Company Account Number - could be same as customer number |
| customer_number__v |
varchar(10) |
Customer Account Number - could be same as Parent/ChargeTo number |
| customer_name__v |
varchar(40) |
Billing Location Account Name |
| ship_to_number__v |
varchar(10) |
Shipping Location Account Number |
| ship_to_name__v |
varchar(40) |
Shipping Location Account Name |
| address_1__v |
varchar(40) |
Shipping Address 1 |
| address_2__v |
varchar(40) |
Shipping Address 2 |
| city__v |
varchar(20) |
Shipping City |
| state__v |
varchar(20) |
Shipping State |
| postal_code__v |
varchar(10) |
Shipping Postal Code |
| order_number__v |
numeric(38) |
System Generated Order Number |
| order_date__v |
date |
Date order is created |
| request_receipt_date__v |
date |
Request Receipt Date |
| customer_po_number__v |
varchar(25) |
Customer Purchase Order Number |
| ndc__v |
varchar(15) |
National Drug Code |
| item_description__v |
varchar(40) |
Item Description -From Item Setup Form |
| lot_code__v |
varchar(20) |
Batch Number |
| product_expiration_date__v |
date |
Date Product Expires |
| pps_number__v |
numeric(38) |
Cardinal System Generated Shipping Number |
| ship_line_id__v |
numeric(38) |
Cardinal System Generated line ID |
| shipped_quantity__v |
numeric(12,3) |
Actual Quantity Shipped |
| shipped_date__v |
date |
Date Product Shipped |
| warehouse_code__v |
varchar(12) |
Warehouse in which inventory is received. CORD100 is refer and Control, else CORD400 |
| carrier__v |
varchar(40) |
Carrier |
| ship_via_code__v |
varchar(4) |
Code identifying shipping method |
| tracking_number__v |
varchar(40) |
Shipment Tracking Number, e.g Fedex tracking number |
| container_weight__v |
numeric(17,5) |
Shipment Container Weight |
| invoice_number__v |
numeric(38) |
Cardinal System Generated Invoice number |
| invoice_amount__v |
numeric(12,2) |
Total Amount of Invoice/Transaction |
| total_net_amount__v |
numeric(12,2) |
Total Amount Less Discounts |
| edi_810__v |
varchar(3) |
Flay to show if the Billing customer is setup to receive 856 |
| customer_group__v |
varchar(4) |
Customer Group |
| container_number__v |
varchar(20) |
Shipment Container number |
| file_name__v |
varchar(200) |
Name of file where record came from |
| file_load_time__v |
timestamp |
Timestamp of when file was loaded into Nitro |
cardinal_inventory_snapshot__v
| item_number__v |
varchar(30) |
Number to identify item - from Item Setup Form |
| item_description__v |
varchar(40) |
Item Description -From Item Setup Form |
| date_received__v |
date |
Date Received |
| lot_code__v |
varchar(20) |
Batch Number |
| shelf_life_date__v |
date |
Product Shelf life Date |
| product_exp_date__v |
date |
Date Product Expires |
| lead_time__v |
numeric(38) |
Lead Time |
| on_hand__v |
numeric(38) |
On Hand Quantity as of Today |
| on_hold__v |
numeric(38) |
On Hold Quantity as of Today |
| expired__v |
numeric(38) |
Expired Quantity as of Today |
| allocated_quantity__v |
numeric(38) |
Allocated Quantity |
| avaliable_to_allocate__v |
numeric(38) |
Available to Allocate |
| committed_quantity__v |
numeric(38) |
Committed. Quantity |
| available_to_commit__v |
numeric(38) |
Available to Commit |
| ndc__v |
varchar(15) |
National Drug Code |
| file_name__v |
varchar(200) |
Name of file where record came from |
| file_load_time__v |
timestamp |
Timestamp of when file was loaded into Nitro |
cardinal_daily_lot_movement__v
| unique_id__v |
varchar(40) |
Move Sequence |
| warehouse_code__v |
varchar(12) |
Warehouse in which inventory is received. CORD100 is refer and Control, else CORD400 |
| item_number__v |
varchar(30) |
Number to identify item - from Item Setup Form |
| item_description__v |
varchar(40) |
Item Description -From Item Setup Form |
| lot_code__v |
varchar(20) |
Batch Number |
| source_code__v |
varchar(3) |
Source Code |
| transaction_date__v |
date |
Date Transaction Finalized |
| movement_code__v |
varchar(2) |
Movement Code |
| transaction_number__v |
varchar(10) |
System Generated |
| reference__v |
varchar(20) |
Reference |
| movement_quantity__v |
numeric(12,3) |
Movement Quantity |
| customer_vendor__v |
varchar(40) |
Customer Vendor |
| ndc__v |
varchar(15) |
National Drug Code |
| last_modified_date__v |
datetime |
Last Modified Date |
| start_date__v (ODS ONLY) |
timestamp |
Start Date of record |
| end_date__v (ODS ONLY) |
timestamp |
End Date of record |
cardinal_invoices__v
| unique_id__v |
varchar(100) |
Invoice Number + Item number+Lot Code |
| charge_to__v |
varchar(10) |
Parent Company Account Number - could be same as customer number |
| charge_to_name__v |
varchar(40) |
Parent Company Account Number - could be same as customer name |
| customer_number__v |
varchar(10) |
Parent Company Account Number - could be same as customer number |
| customer_name__v |
varchar(40) |
Parent Company Account Number - could be same as customer name |
| customer_group__v |
varchar(4) |
COT for shipping location |
| ship_to_number__v |
varchar(40) |
Shipping Location Account Number |
| ship_to_name__v |
varchar(40) |
Shipping Location Account Name |
| address_1__v |
varchar(40) |
Shipping Address 1 |
| address_2__v |
varchar(40) |
Shipping Address 2 |
| city__v |
varchar(20) |
Shipping City |
| state__v |
varchar(20) |
Shipping State |
| postal_code__v |
varchar(10) |
Shipping Postal Code |
| phone__v |
varchar(20) |
Shipping Phone |
| customer_po_number__v |
varchar(25) |
Customer Purchase Order Number |
| order_date__v |
date |
Date Order is Created |
| order_number__v |
numeric(38) |
System Generated Order Number |
| pps_number__v |
numeric(38) |
System Generated Shipping Number |
| order_type_code__v |
varchar(4) |
Code Qualifying the Transaction |
| order_price__v |
numeric(15,5) |
Order Price |
| wac_price__v |
numeric(15,5) |
Wholesale Acquisition Price |
| discount_amount__v |
numeric(15,5) |
Amount of Discount Applicable (if any) |
| discount_type__v |
varchar(1) |
Type of Price Discount ($ or %) |
| shipped_quantity__v |
numeric(12,3) |
Actual Quantity Shipped |
| additional_charges__v |
numeric(12,2) |
Additional invoice/shipping charges (if any) |
| total_net_amount__v |
numeric(12,2) |
Total Amount Less Discounts |
| line_number__v |
numeric(38) |
Line Number as Received on PO |
| warehouse_code__v |
varchar(12) |
Warehouse in which inventory is received. CORD100 is refer and Control, else CORD400 |
| item_number__v |
varchar(15) |
Number to identify item - from Item Setup Form |
| item_description__v |
varchar(40) |
Item Description -From Item Setup Form |
| uom__v |
varchar(10) |
Unit of Measure - From Item Setup Form |
| lot_code__v |
varchar(20) |
Batch Number |
| product_expiration_date__v |
date |
Date Product Expires |
| shipped_date__v |
date |
Date Product Shipped |
| invoice_number__v |
numeric(38) |
System Generated |
| transaction_date__v |
date |
Date Transaction Finalized |
| transaction_type__v |
varchar(2) |
Identifies the Purpose of this Data Entry (See Codes Tab) |
| reason_code__v |
varchar(10) |
Qualifies/Identifies the Purpose of the Transaction (see Order Types Tab) |
| invoice_amount__v |
numeric(12,2) |
Total Amount of Invoice/Transaction |
| ndc__v |
varchar(15) |
National Drug Code |
| file_name__v |
varchar(200) |
Name of file where record came from |
| last_modified_date__v |
timestamp |
Timestamp of when file was loaded into Nitro |
cardinal_daily_orders__v
| unique_id__v |
varchar(100) |
Order number+ PPS number+ Item number |
| customer_number__v |
varchar(10) |
Parent Company Account Number - could be same as customer number |
| name__v |
varchar(40) |
Billing Location Account Name |
| ship_to_number__v |
varchar(10) |
Shipping Location Account Number |
| ship_to_name__v |
varchar(40) |
Shipping Location Account Name |
| address_1__v |
varchar(40) |
Shipping Address 1 |
| address_2__v |
varchar(40) |
Shipping Address 2 |
| city__v |
varchar(20) |
Shipping City |
| state_or_province__v |
varchar(20) |
Shipping Account State |
| country__v |
varchar(10) |
Shipping Country |
| postal_code__v |
varchar(10) |
Shipping Postal Code |
| order_number__v |
numeric(38) |
System Generated Order Number |
| pps_number__v |
numeric(38) |
System Generated Order Number |
| line_number__v |
numeric(38) |
Line Number as Received on PO |
| item_number__v |
varchar(30) |
Number to identify item - from Item Setup Form |
| order_type_code__v |
varchar(4) |
Code Qualifying the Transaction |
| order_date__v |
date |
Date order is created |
| customer_po_num__v |
varchar(25) |
Customer Purchase Order Number |
| original_order_qty__v |
numeric(12,3) |
Original line order quantity |
| order_qty__v |
numeric(12,3) |
Order Order quantity |
| net_price__v |
numeric(12,3) |
Net Price |
| shipped_date__v |
date |
Date Product Shipped |
| line_status__v |
varchar(38) |
Order line status |
| order_value__v |
numeric(12,3) |
Order amount Value |
| ndc__v |
varchar(15) |
National Drug Code |
| last_modified_date__v |
timestamp |
Timestamp of when file was loaded into Nitro |
| start_date__v (ODS ONLY) |
timestamp |
Start Date of record |
| end_date__v (ODS ONLY) |
timestamp |
End Date of record |
cardinal_cash_receipt__v
| unique_id__v |
varchar(50) |
Jrnl number + Jrnl Seq |
| payer_number__v |
varchar(10) |
Billing Location Number |
| payer_name__v |
varchar(40) |
Billing Location Name |
| cash_date__v |
date |
Date cash was applied in system |
| trans_number__v |
numeric(38) |
System Generated |
| check_number__v |
varchar(15) |
Customer check number |
| check_amount__v |
numeric(12,2) |
Customer check amount |
| document_number__v |
numeric(38) |
Document number paid |
| cash_applied__v |
numeric(12,2) |
Cash Applied |
| discount__v |
numeric(12,2) |
Term Discount |
| transaction_type__v |
varchar(2) |
Document Transaction Type DI=Invoice CM = Credit Memo DM = Debit Memo CP = Cash Payment |
| reference__v |
varchar(20) |
Reference / Customer PO / Reference number |
| original_transaction_date__v |
date |
Date of original transaction created |
| last_modified_date__v |
timestamp |
Timestamp of when file was loaded into Nitro |
| start_date__v (ODS ONLY) |
timestamp |
Start Date of record |
| end_date__v (ODS ONLY) |
timestamp |
End Date of record |
cardinal_returns__v
| unique_id__v |
varchar(100) |
PID + Lot_Number + Received_Quantity + Return_Reason_Code + Product_Barcode |
| customer_number__v |
varchar(100) |
Parent Company Account Number - could be same as customer number |
| cutomer_name__v |
varchar(100) |
Billing Location Account Name |
| ship_to_number__v |
varchar(100) |
Shipping Location Account Number |
| ship_to_name__v |
varchar(100) |
Shipping Location Account Name |
| indirect_customer_name__v |
varchar(100) |
Drop Ship Account(if Applicable) |
| city__v |
varchar(100) |
Shipping City |
| state__v |
varchar(100) |
Shipping State |
| po_number__v |
varchar(50) |
PO Number |
| debit_memo_number__v |
varchar(50) |
Customer assigned debit memo number |
| returns_authorization_number__v |
numeric(38) |
Authorization number provided to allow product return |
| return_authorization_date__v |
date |
Date RA issued |
| pid__v |
numeric(38) |
Package identifier-system assigned |
| return_number__v |
numeric(38) |
Return Number - system assigned |
| return_order_type__v |
varchar(50) |
Default order type by client |
| received_date__v |
date |
Date product received |
| processed_date__v |
date |
Date return processed in system |
| approval_date__v |
date |
Date return approved/finalized |
| credit_create_date__v |
date |
Date credit created |
| item_number__v |
varchar(100) |
Number to identify item |
| item_description__v |
varchar(100) |
Item Description _Assay information |
| product_barcode__v |
varchar(100) |
System assigned number for physical product received |
| expiration_date__v |
date |
Product Expiration Date |
| lot_number__v |
varchar(100) |
Lot Number |
| received_quantity__v |
numeric(38) |
Actual Quantity of item received |
| uom__v |
varchar(100) |
Unit of Measure |
| return_reason_code__v |
varchar(100) |
Reason for return |
| product_condition__v |
varchar(100) |
Condition of product returned |
| returnable_for_credit__v |
varchar(100) |
Returnable NonReturnable |
| credit_quantity__v |
numeric(38) |
Quantity received for credit |
| credit_price__v |
numeric(38) |
Unit price given for returned product |
| credit_amount__v |
numeric(38) |
Amount of credit given |
| transaction_number__v |
numeric(38) |
System assigned number for return credit |
| third_party_received_date__v |
date |
Date product received by Third Party |
| ndc__v |
varchar(15) |
National Drug Code |
| last_modified_date__v |
timestamp |
Timestamp of when file was loaded into Nitro |
| start_date__v (ODS ONLY) |
timestamp |
Start Date of record |
| end_date__v (ODS ONLY) |
timestamp |
End Date of record |
cardinal_chargebacks__v
| unique_id__v |
varchar(100) |
Debit memo Number + debit memo Line Number+ Chargeback processing date |
| org_code__c |
varchar(2) |
Client two character Elite identifier |
| wholesaler_dea_number__c |
varchar(9) |
Wholesaler DEA number |
| baccs_indentifier__c |
numeric(38) |
Client two character BACCS identifier |
| wholesaler_customer_number__c |
numeric(38) |
Wholesaler customer number. Excludes two character org_code identifier from Elite |
| wholesaler_ship_to_number__c |
numeric(38) |
Wholesaler ship-to number. Excludes two character org_code identifier from Elite |
| wholesaler_name__c |
varchar(25) |
Wholesaler name |
| wholesaler_city__c |
varchar(25) |
Wholesaler city |
| wholesaler_hin_number__c |
varchar(25) |
Wholesaler HIN number |
| debit_memo_number__c |
numeric(38) |
Debit memo number |
| debit_memo_line_number__c |
numeric(38) |
Debit memo line number |
| create_date__c |
date |
create date |
| member_dea_number__c |
varchar(9) |
Member DEA number |
| contract_number__c |
varchar(10) |
Contract number |
| wholesaler_invoice_number__c |
varchar(15) |
Wholesaler Invoice Number |
| wholesaler_ndc_number__c |
varchar(11) |
Wholesaler NDC Number |
| item_number__c |
varchar(15) |
Item number |
| extended_contract_number__c |
varchar(10) |
Extended contract number |
| actual_quantity__c |
varchar(10) |
Actual Quantity |
| chargeback_quantity__c |
numeric(38) |
Chargeback quantity |
| unit_of_measure__c |
varchar(2) |
Unit of Measure |
| actual_price__c |
numeric(11,6) |
Actual Price |
| contract_price_per_unit__c |
numeric(11,6) |
Contract price per unit |
| chargeback_amount__c |
numeric(12,6) |
Chargeback amount (extended value for the chargeback line) |
| chargeback_status_flag__c |
varchar(1) |
Chargeback Status Flag = A |
| stat_date__c |
date |
Stat Date |
| chargeback_processed_flag__c |
varchar(1) |
Chargeback Processed Flag = P |
| chargeback_processing_date__c |
date |
Chargeback processing date |
| chargeback_pending_flag__c |
varchar(1) |
Chargeback Pending Flag = C |
| member_hin_number__c |
varchar(9) |
Member HIN number |
| wholesaler_invoice_date__c |
date |
Wholesaler invoice date |
| wholesaler_debit_memo_number__c |
varchar(15) |
Wholesaler debit memo number |
| member_type_id__c |
varchar(7) |
Member Type ID |
| member_type_description__c |
varchar(30) |
Member Type Description |
| member_name__c |
varchar(40) |
Member name |
| member_address_line_1__c |
varchar(40) |
Member address line 1 |
| member_address_line_2__c |
varchar(40) |
Member address line 2 |
| member_city__c |
varchar(40) |
Member city |
| member_state__c |
varchar(40) |
Member State |
| member_postal_code__v |
varchar(10) |
Member Postal Code |
| group_state__c |
numeric(38) |
Group State |
| group_number__c |
numeric(38) |
Group Number |
| company_division__c |
numeric(38) |
Company division |
| contract_name__c |
varchar(25) |
Contract Name |
| bid_contract_number__c |
varchar(10) |
Bid contract number |
| bid_contract_type__c |
numeric(38) |
Bid contract type |
| status_code__c |
varchar(1) |
Status Code |
| contract_reference_number__c |
numeric(38) |
Contract reference number |
| customer_contract_number__c |
varchar(15) |
Customer contract number |
| sales_type__c |
varchar(1) |
Sales type |
| preparation_date__c |
date |
Preparation date |
| due_date__c |
date |
Due date |
| notification_date__c |
date |
Notification date |
| effective_from_date__c |
date |
Effective from date |
| effective_to_date__c |
date |
Effective to date |
| extension_date__c |
date |
Extension Date |
| sales_volume__c |
numeric(38) |
Sales volume report frequency |
| item_description__c |
varchar(40) |
Item Description |
| ndc__v |
varchar(15) |
National Drug Code |
| last_modified_date__v |
timestamp |
Timestamp of when file was loaded into Nitro |
| start_date__v (ODS ONLY) |
timestamp |
Start Date of record |
| end_date__v (ODS ONLY) |
timestamp |
End Date of record |
cardinal_codes__v
| code_type__v |
varchar(100) |
Column Name in source data |
| value__v |
varchar(100) |
Value in source data |
| description__v |
varchar(200) |
Description of code |
| file_name__v |
varchar(200) |
Name of file where record came from |
| load_date__v |
timestamp |
Timestamp of when file was loaded into Nitro |
