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

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