When building or customizing reports in Intelligent Logistics, you can enhance data visibility by adding various table columns. These columns align with the available filter options in the filter bar and typically share the same definitions. The list below defines all billing application columns and filters you may encounter.
Billing Filter and Column Options
Here’s a list of all the available table columns/filters and what each one represents:
-
Acquisition Method – Indicates how the shipment information was obtained.
-
Bill of Lading – A legal document issued by the carrier, detailing the shipment of goods.
-
Billed Account – The account charged for shipping costs.
-
Billed Account Type – Specifies the type of account being billed.
-
Billing Type – Defines the method or criteria used for billing shipments.
-
Carrier – The shipping company responsible for transporting the package.
-
Carrier Account Group (Billed) – Groups carrier accounts based on billing arrangements.
-
Carrier Billing Plan – Specifies the carrier's billing structure and pricing model.
-
Carrier Delivery Zone – Defines the geographic zone where shipments are delivered.
-
Currency – Specifies the currency used for billing and invoicing.
-
Custom Reference – A user-defined reference used for tracking shipments or invoices.
-
Declared Value – The monetary value assigned to a shipment for insurance or customs purposes.
-
Exclude "Display Only" $0 Charge Items – Filters out line items that are displayed only and have a zero-dollar charge.
-
Freight Class – A standardized classification system used to determine shipping rates based on weight, density, and handling requirements.
-
Invoice Date – The date the invoice was issued.
-
Invoice Number – A unique identifier assigned to each invoice for tracking purposes.
-
Invoice Type – Specifies the category of an invoice, such as standard, credit, or adjustment.
-
Line Description – Details the contents or purpose of each line item on an invoice.
-
Line Item Billing Type – Specifies how individual line items on an invoice are billed.
-
Mode – The method of transportation used for shipping, such as air, ground, or ocean.
-
Movement Type – Indicates whether the shipment is inbound, outbound, or returned.
-
Packaging Type – Defines the type of packaging used for shipping, such as boxes, pallets, or envelopes.
-
Pick-Up Date – The scheduled date for a shipment to be collected by the carrier.
-
Quantity – The number of items included in a shipment or invoice.
-
Requestor – The person or entity requesting the shipment or service.
-
Returned From – Identifies the origin of a returned shipment or package.
-
Shipper Reference / Package Reference – Identifiers used to track shipments, numbered sequentially when multiple references exist.
-
Ship To / Ship From – Specifies sender and recipient details without breaking into subcategories like State or GeoZip.
-
Size Unit – Specifies the unit of measurement for package dimensions, such as inches or centimeters.
-
Tracking Number – A unique number assigned to a shipment that allows tracking of its progress.
-
Weight Unit – Defines the unit of measurement for package weight, such as pounds or kilograms.
Note: Delivery dates do not appear in billing data because UPS does not pass this information through. For visibility into delivery information, refer to the Tracking Summary report.
Helpful Articles
If you have questions or need help customizing your report, please reach out to your Customer Success Manager.