UPS Hundredweight Service® shipments are represented on multiple rows in the Flat File Bill. The first row of a UPS Hundredweight Service shipment is considered the Shipment Row and contains a summary of the entire shipment, including the total net cost and total net incentive for the shipment. The Tracking Number field will be blank, the Quantity field will show the total number of packages in the shipment, and sender and receiver information will be populated on the summary row only.
The Transaction Code field will display CWT or CW2 if the shipment was received by a Hundredweight Pickup Book or Hundredweight Shipping Document, respectively. However, if the shipment was received through a manifest shipping system, the Transaction Code field will show MAN and the Service Description will display Hundredweight and the service.
The subsequent rows of the shipment display the individual packages in the shipment, including: tracking numbers, any reference numbers, etc.
To connect the shipment line with its respective child packages, a sort can be performed on Miscellaneous Column 3, which will establish the association between the shipment line and its child packages. A secondary, descending sort on the Quantity field will place the summary shipment row as the first row for each shipment.