Appendix_6.10 _Shipment_Detail_Report_Required_Data_Elements.pdf

Appendix 6.10 Shipment Detail Report Required Data Elements

Field Description

* Denotes requirement exceptions

Shipper_Account_Number Account number matching back to the individual shipper; Contractor will provide customer details (e.g.

POC, address, phone number, etc.) upon request by Program Management Office (PMO) or Contracting Officer (CO)

National_Account_Parent_Number Account number matching back to the parent agency of the shipper

National_Account_Sub_Group_Number Account number matching back to the sub-agency of the shipper

Air_Bill_Number The number printed on each shipping document that identifies a shipment; this number is used to track each shipment from its origin to destination

Transportation_Control_Number A 17 digit alphanumeric designator used by the DoD applied to each package or shipment to identify a shipment, generally recorded in the reference numbers if provided by shipper

Tracking_Number Contractor generated unique tracking number Invoice_Number The number assigned to the invoice by the Contractor Invoice_Date The date the invoice was issued NGDS_Program_Flag* Indicator denoting the use of the NGDS program

* Only required if reports will contain data not from the NGDS program

Domestic_International_Flag* Indicator denoting whether the package is being shipped domestically or internationally

* Only required from carriers that ship both domestically and internationally

Service_Category Denotes the category of service (e.g. Ground, Express) Service_Type_Code Field denoting the level of service performed (e.g. E2

- Express 2-Day) Shipment_Amount Amount charged for the shipment (not including discounts, duties/tax or surcharges) Discount_Amount* Amount discounted for the shipment

* Only required from carriers that use Discounts / Rebates / Incentives (if not used in commercial practice, field will be assumed to always be $0)

Duties_and_Taxes_Amount Amount charged for duties and taxes associated with the shipment

DRAFT

Surcharge_Amount Total amount for all surcharges associated with the shipment in USD.

Surcharge_Code Code used to identify the surcharge codes

Total_Invoice_Amount The net amount of the shipment (Shipment Cost – Discount + Duties/Taxes + Surcharge) in USD

Pickup_Date Date when the packaged was picked up by the Contractor from the shipper

Delivery_Date Date when the package was successfully delivered to the recipient

Delivery_Time Time when the package was successfully delivered to the recipient

Delay_Code Contractor code identifying the reason for the delivery of shipment being late

Package_Type The type of package utilized by the shipment (e.g.

letter, package)

Package_Quantity The number of pieces contained in the shipment Package_Dim_Length The dimensional length of the shipment Package_Dim_Width The dimensional width of the shipment Package_Dim_Height The dimensional height of the shipment Actual_Weight Actual weight of the shipment Billed_Weight Actual or dimensional weight, whichever is greater Shipper_Company The agency or company of the shipper Shipper_Name Name of the shipper Shipper_Address The street address from which the package was shipped Shipper_City The city from which the package was shipped Shipper_State The state from which the package was shipped Shipper_Zip_Postal_Code The postal code from which the package was shipped Shipper_Country The 2- digit ISO 3166-1-alpha-2 country code from which the package was shipped

Proof_of_Delivery_Recipient The name of the recipient who signed for the package Recipient_Company The agency or company of the recipient Recipient_Name The name of the recipient Recipient_Address The address where the shipment was delivered to Recipient_City The city where the shipment was delivered to Recipient_State The state where the shipment was delivered to Recipient_Zip_Postal_Code The postal code where the shipment was delivered to Recipient_Country The 2-digit ISO 3166-1-alpha-2 country code where the shipment was delivered to