Extract of billing account and accessorial information.This is a historical report. This report is formatted for extractto an Excel spreadsheet.

The Billing Extract containsthe following fields:

Parameters

Date Choice:

• Most Accurate Departure Date
• Planned Departure Date
• Most Accurate Arrival Date

From Date:

• CurrentDate: Must be in mm/dd/yy format
• From Date Offset: -90 to 90

To Date:

• CurrentDate: Must be in mm/dd/yy format
• To Date Offset: -90 to 90

Origin City:

• Shipment Origin City (All or starts with a wildcard)

Destination City:

• Shipment Destination City (All or starts with a wildcard)

Shipment Mode: Select one from the list:

• All Air Any Customer Intermodal LTL Ocean Parcel RailTL Unassigned

Carrier Choice:

• Carrier Name
• Carrier SCAC

Carrier Name or SCAC Value:

• All or starts with a wildcard

Detail Fields

The following detail fields are provided:

• SID
• Order Number
• Continuous Move ID
• Trailer Number
• Carrier Pro Number
• Origin Loc Code
• Origin Name
• Origin City
• Origin State
• Origin Zip Code
• Destination Loc Code
• Destination Name
• Destination City
• Destination State
• Destination Zip Code
• User Name (Created By User)
• Bill To Number
• Bill To City
• Pickup Date
• Delivery Date
• Carrier SCAC
• Carrier Name
• Transport Mode
• Service Type
• Equipment Type
• Shipment Status (Active Status)
• Last Reported Status (Current Status)
• Shipment Plan Status
• Payment Method
• Weight
• Loaded Miles
• Empty Miles
• Actual Cost
• Base Charges
• Rate per Mile
• Linehaul Charge
• Currency
• Discount
• Carrier Stop Charge
• Base Stop Charge
• Delivery Delay (Driver delay)
• Base Delay
• VNU VDU
• Base VNU VDU
• Driver Assist OT (Driver Assist Overtime)
• Unloading Charges
• Fuel Charges (Fuel Surcharges)
• Base Fuel Charges
• Deadhead Charge
• Base Deadhead Charge
• Other Accessorials
• Other Base Accessorials
• Download Date (Date the shipment status was changed to Completesuch as the arrival date or unloading date)
• Created Date (Shipment created date)
• Shipment Order Count (Count of orders on shipment)
• Delivery Stops (number of stops on shipment)
• Ship Quantity Amount
• UOM (unit of measure for Ship Quantity Amount)