Freight Invoice Columns
Accessorials:
Subtotal of Non-Freight, Non-Discount, Non-Fuel, Non-Duty/Tax charges non-freight charges on an invoice.
Account #:
Billing account which the invoice was billed under by the carrier.
Actual Weight (Normalized):
Actual (not billed) weight of a shipment-Normalized. (See Page-“Normalized Fields”)
Adjustment Reason:
If an invoicing error is found during Körber's audit, the reason for the short pay will be noted in the “Adjustment Reason” column.
Adjustments:
Sum of total adjustments made to an invoice as a result of Körber's audit.
Aged Days:
Number of days which have passed since the Invoice Date of the shipment.
Approved/Denied By:
The MSI username of the person who approved/denied an invoice in the customer task list.
Approved/Denied Date:
Date an invoice was approved or denied in the task list.
Auditor Comments:
Comments made by the freight auditor which pertain to the audit of the invoice.
Bill Option:
Terms of an invoice (Collect, Prepaid, Third Party, etc.)
Bill Weight (Normalized):
Normalized version of the weight that the carrier rated/billed the shipment at. (See Page-“Normalized Fields”)
Closed Date:
Date which the invoice completed Körber's audit and became eligible for the next available weekly pay run.
Consol Parent ID:
If multiple shipments were invoiced under a common “Bulk Invoice,” this ID ties all sub-records together under a single identifier.
Cost Avoidance:
This field is specific to the freight audit processes in the EMEA and APAC regions. It show any original overcharges to an invoice to measure the impact of the Körber audit. Invoices are later approved in full with a credit or resolved with backup documentation, but the cost avoidance field tracks the initial overcharge amount.
Create Date:
Date an invoice was created in Körber's system
Credit Memo #:
Körber internal identifier for credit memos issued by carriers.
Customer Code:
4-character alphanumeric code created by Körber to identify each customer; This code will always be the same for a given customer.
Customer Comments:
Any comments provided by the customer when reviewing invoices in the task list.
Customer ID:
Körber internal customer ID number.
Customer Name:
Name of the Körber customer to which the invoice belongs.
Discount:
Contracted discount off of base rates invoiced by the carrier
.
Discount Carrier Rate:
Discount rate for a given invoice as specified in the carrier contract.
Discount Rating Method:
Method for applying “Discount Carrier Rate.” (Percent, Per CWT, Flat Rate, etc.)
Duty/Tax:
Subtotal of duty/tax charges on an invoice.
Freight Class:
The freight class which LTL shipments were billed at as provided by the carrier.
Fuel Surcharge:
Subtotal of fuel surcharges charges on an invoice.
Funds Received Date:
Only for clients using Körber bill pay services. This represents the date that Körber received funds from the client to pay a given invoice.
Invoice Method:
Method used to submit an invoice to Körber by the carrier (EDI, PAPER, Online Data Entry-ODE, etc.)
Invoice Status:
Current progress of an invoice through Körber's audit process. (See “Invoice Status Terms” page for definitions of each status.)
Invoice Type:
The version of a given invoice. (OR-Original Invoice, DU-Duplicate Invoice, BD- Balance Due Invoice, CI-Corrected Invoice, CM-Credit Memo)
Line Haul:
Subtotal of the freight charges on an invoice—Non-Discount, Non-Fuel, Non-Accessorial, Non-Duty/Tax charges.
Match Status:
Only for clients using a Körber order match. This designates whether the invoice has been order matched or not.
Mode (Invoiced):
The method by which a shipment was sent (LTL, TL, AIR, OCEAN, COURIER, etc.)
NSP Invoice Details ID:
Primary key within Körber's database. This can be used as a unique identifier when performing various types of analysis.
Payment #:
Only for clients using Körber bill pay services. This represents the check # that Körber used to pay this invoice.
Payment Amount:
Only for clients using Körber bill pay services. This represents the amount of the check which paid this invoice. It is important to note that a given check will pay many invoices. This column represents the amount of the ENTIRE check.
Payment Date:
Only for clients using Körber bill pay services. This represents the date that the invoice was paid to the carrier.
PO #:
Reference data column provided by the carrier. This is typically a mutually defined data element between the carrier, client and Körber.
Rated Miles:
Number of miles the shipment traveled as calculated by Körber's rating engine.
Receiver Latitude/Longitude:
Latitude/Longitude of the address to which the shipment was delivered.
Remit Comments:
Comments which explain why an invoice was adjusted/short paid. This can be provided to carriers as an automated explanation of a short pay.
Run #:
Each invoice is received, audited, closed, and added to a weekly Pay Run. A pay run is a batch of audited/closed invoices which are finalized and ready to be paid. Pay run numbers always follow the same naming convention CUSTOMER CODE + YEAR + WEEK # + # OF PAY RUNS WITHIN THAT WEEK (Typically 1).
SCAC Code:
Industry standard 4 character alphanumeric code which uniquely identifies each carrier.
Service Level (Normalized):
The method by which a shipment was sent (LTL, TL, AIR, OCEAN, COURIER, etc.)
Shipment Count (Normalized):
Invoices are assigned either a 1 or 0 based on the “Invoice Type.” OR-Original Invoices are assigned a 1. All other invoice types are assigned a 0. This allows the user to sum the “Shipment Count (Normalized)” column to find the number of unique invoices. This prevents double counting invoices which were invoiced a second time for any reason.
Shipper Latitude/Longitude:
Latitude/Longitude of the address which the shipment shipped from.
Shipment Month:
Month which a shipment occurred in.
Spot Quoted:
Designates whether or not the shipment was entered in Körber’s spot quote tool.
Total Charges:
The total amount of an invoice as billed by the carrier. This will NOT reflect any short pays advised after audit, but rather the original amount billed.
Total Due Amount:
Total amount due to the carrier after the audit has been complete. This column reflects any short pays advised by Körber.
Total Ship Units:
Total number of units included on the invoiced shipment.
Total Ship UOM:
Unit of measure of the “Total Ship Units” column (Pieces, Pallets, etc.)
Weight UOM:
Unit of measure of the “Actual Weight” and “Billed Weight”