Parcel Invoice Columns
Account Address/Account City/Account Country/Account Name/Account Postal Code/Account State:
Address associated with the account # that the carrier billed the shipment under.
Actual Weight (Normalized):
Actual (not billed) weight of a shipment-Normalized. (See Page-“Normalized Fields”)
Add’d Handling:
Subtotal of Additional Handling Charges on a given shipment. Only populated for FedEx shipments (for UPS accessorial charges, use the Analysis Details (UPS) report).
Adjusted Amount:
Sum of total adjustments made to an invoice as a result of Körber's audit. UPS will always show $0 in this column as UPS invoices are paid as billed and any credits are issued as unique transactions on future invoices.
Aged Days:
Number of days which have passed since the Invoice Date of the shipment.
Audited Amount:
Total amount due to the carrier after the audit has been complete. This column reflects any short pays advised by Körber.
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”)
Code:
Carrier provided billing code which broadly identifies the charge type (ADC-Address Correction; GSR- Guaranteed Service Refund; SCC-Shipping Charge Correction)
Control #:
FedEx only. On a weekly basis, any FedEx invoices which have completed the audit are “closed” onto a control #. The control # uniquely identifies that batch of audited invoices.
Create Date:
Date an invoice was created in Körber's system
Credit Reason:
Reason that a short pay was made as a result of the audit.
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 Dept. #/Customer Invoice #/Customer PO #:
FedEx only. Reference fields provided directly by the carrier ONLY IF AVAILABLE.
Customs Value:
Value assigned to the shipment for customs purposes.
Cwt ID:
ID number provided by the carrier to identify related groups of hundred weight shipments.
DAS:
Subtotal of Delivery Area Surcharges on a given shipment. Only populated for FedEx shipments (for UPS accessorial charges, use the Analysis Details (UPS) report).
Days in Transit:
Days in Transit is a true calendar day calculation. If a package ships ground on Monday, 12/23 and arrives on Monday, 12/30, the Days in Transit would read “7”, even though the holiday and weekend occurred in that period.
Declared Value:
Subtotal of Declared Value Charges on a given shipment. Only populated for FedEx shipments (for UPS accessorial charges, use the Analysis Details (UPS) report.
Delivery Date:
Date a shipment was delivered as provided by the carrier.
Delivery Time:
Time a shipment was delivered as provided by the carrier.
Detail Keyed Dim:
Audited dimensions provided by the carrier for shipments which were assessed a shipping charge correction, dim weighting, etc. Only available for weight/rate adjusted shipments.
Dim Divisor:
Dim divisor which the carrier used to calculate the shipment’s billed weight.
Discounted Amount:
Discount off of base rate for a shipment, as invoiced by the carrier. Discounts are negotiated as part of the carrier contract.
Fuel:
Subtotal of Fuel Surcharges on a given shipment.
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.
Height:
Height of a package, provided by the carrier for shipments which were assessed a shipping charge correction, dim weighting, etc. Only available for weight/rate adjusted shipments.
Internal Key 1:
Primary key within Körber's database. This can be used as a unique identifier when performing various types of analysis.
Invoice Amount:
Parcel invoices contain multiple shipments. “Invoice Amount” provides the total amount of an invoice for ALL shipments combined.
Invoice Amount to Pay:
Parcel invoices contain multiple shipments. “Invoice Amount to Pay” provides the total amount due to the carrier for ALL shipments combined, after the Körber audit has been completed. This reflects any short payments which Körber has advised.
Invoice Status:
FedEx Only. Current progress of an invoice through Körber's audit process. Open = In Process; Closed = Audit Complete
Length:
Length of a package, provided by the carrier for shipments which were assessed a shipping charge correction, dim weighting, etc. Only available for weight/rate adjusted shipments.
Load Match Date:
Only for clients using an Körber order match. This designates the date a shipment was order matched.
Misc. Charges:
Subtotal of charges which do not fall into the other breakout columns shown (Fuel, Declared Value, DAS, etc.) on a given shipment. Only populated for FedEx shipments (for UPS accessorial charges, use the Analysis Details (UPS) report).
Multi Weight ID:
ID number provided by the carrier to identify related groups of hundred weight shipments.
Package Type:
Type of packing a shipment used. (Package, Letter, Envelope, etc.)
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).
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.
Payment Number: Only for clients using Körber bill pay services. This represents the check # that Körber used to pay this invoice.
Piece Count:
Number of pieces on a shipment.
Plan Number:
UPS Only. If an account # is part of a Consolidated Payment Plan (CPP), the CPP # will show up here.
Published Amount:
Total charges for a shipment before the contracted discount is applied.
Receiver Latitude/Longitude:
Latitude/Longitude of the address to which the shipment was delivered.
Reference/Reference 2/Reference 3/Reference 4/Reference 5:
Reference information provided directly by the carrier. Only available if provided to the carrier upon shipment manifest.
Residential:
Subtotal of Residential Charges on a given shipment. Only populated for FedEx shipments (for UPS accessorial charges, use the Analysis Details (UPS) report).
Saturday Delivery:
Subtotal of Saturday Delivery Charges on a given shipment. Only populated for FedEx shipments (for UPS accessorial charges, use the Analysis Details (UPS) report).
SCAC Code:
Industry standard 4 character alphanumeric code which uniquely identifies each carrier.
Service Level (Invoiced):
Service by which a package was sent (Ground, Next Day, 2 Day) as invoiced by the carrier. In the case of UPS, this may show accessorial charges such as “Shipping Charge Correction, Residential Adjustment, Delivery Area Surcharge, etc.”
Service Level (Normalized):
Normalized service by which a package was sent (Ground, Next Day, 2 Day). See Page-“Normalized Fields”
Service Packaging:
FedEx Only. Type of packing a shipment used. (Package, Letter, Envelope, etc.)
Shipment Count (Normalized):
Invoices are assigned either a 1 or 0 based on whether or not the record represents a package or a non-package charge. This allows the user to sum the “Shipment Count (Normalized)” column to find the number of unique shipments. This prevents double counting shipments which were invoiced a second time for any reason. See Page-“Normalized Fields”
Shipment Month:
Month which a shipment occurred in.
Shipment Reference 1/Shipment Reference 2:
Reference information provided directly by the carrier. Only available if provided to the carrier upon shipment manifest.
Shipper #:
Billing account which the invoice was billed under by the carrier.
Shipper Group:
If a client’s carrier account #s have been placed into standardized groups by Körber, this column will show which group the account # belongs to. (i.e.- DC, Store, Vendor, etc.)
Shipper Latitude/Longitude:
Receiver Latitude/Longitude: Latitude/Longitude of the address where a shipment originated.
Tax:
Subtotal of Tax charges on a given shipment. Only populated for FedEx shipments (for UPS accessorial charges, use the Analysis Details (UPS) report).
Total Charges:
The total amount of a shipment as billed by the carrier. This will NOT reflect any short pays advised after audit, but rather the original amount billed.
Unit of Actual Weight:
Unit of measure of the “Actual Weight” of a shipment.
Unit of Bill Weight:
Unit of measure of the “Bill Weight” of a shipment.
Unit of Dim:
Unit of measure of the dimensions of a shipment.
Width:
Width of a package, provided by the carrier for shipments which were assessed a shipping charge correction, dim weighting, etc. Only available for weight/rate adjusted shipments.
Zone (Invoiced):
Standardized billing zone which a shipment was billed at.
Zone (Normalized):
Zone (Invoiced) normalized to a either zone 2,3,4,5,6,7, or 8 for easier analysis. See Page-“Normalized Fields”