Business Intelligence Field Names

​

Default Field Descriptions

​

# of Shipments: 

Total shipments for the range given

​

Accessorials:          

Subtotal of accessorial charges on an invoice.

​

Account #:           

Billing account which the invoice was billed under by the carrier.

​

Account Name: 

Name of billing account which the invoice was billed under by the carrier.

​

Actual Weight (KG):

Actual (not billed) weight of a shipment in Kilograms.

​

Actual Weight (LBS):       

Actual (not billed) weight of a shipment in Pounds.

​

Actual Weight (Normalized):       

Actual (not billed) weight of a shipment-normalized. This field populates either the invoiced actual weight or “0” depending on whether a shipment has multiple records in myShipINFO.

​

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 (USD):        

Total adjustments for the shipment.

​

Bill Option:          

Terms of an invoice (Collect, Prepaid, Third Party, etc.)

​

Bill Weight (KG):

Weight that the carrier rated/billed the shipment at in Kilograms.

​

Bill Weight (LBS):              

Weight that the carrier rated/billed the shipment at in Pounds.

​

Bill Weight (Native):        

Original weight units that the carrier rated/billed the shipment at.

​

Bill Weight (Normalized):              

Normalized version of the weight that the carrier rated/billed the shipment at. This field populates either the invoiced billed weight or “0” depending on whether a shipment has multiple records in myShipINFO. 

​

Billed Miles:        

Total miled billed for a shipment by the carrier.

​

BOL #:    

Bill of lading # for the shipment.

​

Business Days In Transit:               

Days in transit for the package to be delivered after shipment, accounting for only business days.

​

Carrier Name:    

Name of the carrier provided.

​

Carrier Name Normalized:            

Grouped similar names of carriers into buckets for quick analysis.

​

Check #:

For billpay customers only. Check number associated with payment of an invoice.

​

Closed Date:       

Date which the invoice completed Körber's audit and became eligible for the next available weekly pay run.

​

Closed To Run:   

The amount of time it takes for the invoice to be put on a weekly pay run after completing audit.

​

Create Date:       

Date an invoice was created in Körber's system.

​

Currency Code (Native):

Code of currency the invoice is charged in (USD, EUR, GBP, etc.)

​

Customer Code:

4-character alphanumeric code created by Körber to identify each customer.

​

Customer Name:              

Name of the Körber customer to which the invoice belongs.

​

Days Since Invoiced:        

Number of days which have passed since the invoice date of the shipment.

​

Days Since Received:     

Number of days which have passed since the receival date of the shipment.

​

Days Since Shipped:        

Number of days which have passed since the ship date of the shipment.

​

Days To Due:      

Amount of days until the invoice is due.

​

Delivery Date:    

Date a shipment was delivered as provided by the carrier.

​

Discount (USD):

Contracted discount off of base rates invoiced by the carrier.

​

Duty Taxes (USD):            

Subtotal of duty/tax charges on an invoice.

​

Fuel Surcharge (USD):    

Subtotal of fuel surcharges charges on an invoice.

​

GL Code:              

Code coming from the customer and is updated in the system by Körber on a weekly basis.

 

Invoice #:             

Reference data provided by the carrier to identify the invoice.

 

Invoice Date:      

Date of the associated invoice.

​

Invoice Due Category:    

Bucketed identifiers of due dates for invoices which are overdue or due for quick analysis.

 

Invoice Due Date:             

Designates the due date of the invoice for the amount listed.

​

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.

 

Invoice To Create:

Number of days which have passed since the shipment was invoiced to when the shipment was created in Körber's system.

 

Invoice Type:      

The version of a given invoice. (OR-Original Invoice, DU-Duplicate Invoice, BD- Balance Due Invoice, CI-Corrected Invoice, CM-Credit Memo)

 

Invoiced Since Category:

Bucketed identifiers of time since invoiced for quick analysis.

 

Invoicing Accuracy Category:       

Bucketed identifiers of accuracy of billing for invoices for quick analysis.

 

Lane City To City:              

Designated shipper city to receiver city for the given shipment.

 

Lane Country To Country:             

Designated shipper country to receiver country for the given shipment.

 

Lane Port To Port:            

Designated shipper port to receiver port for given shipment (Ocean, Air, Freight only)

 

Lane State To State:        

Designated shipper state to receiver state for the given shipment.

 

Line Haul (USD):

Subtotal of the freight charges on an invoice—Non-Discount, Non-Fuel, Non-Accessorial, Non-Duty/Tax charges.

 

Line Haul Rating Method:             

Method for applying line haul rate.

 

Move Type:        

Move type of freight, air, or ocean shipment. (Port to port, Port to door)

​

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.

​

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 Date:  

Only for clients using Körber bill pay services. This represents the date that the invoice was paid to the carrier.

​

Plan #:   

UPS Only. If an account # is part of a Consolidated Payment Plan (CPP), the CPP # will show up here.

​

PO #:     

Reference data column provided by the carrier. This is typically a mutually defined data element between the carrier, client and Körber.

​

Port Of Destination Code:             

Port code associated with the receiving port of a shipment. 

​

Port Of Discharge:            

Port destination associated with the discharging port of a shipment.

​

Port Of Loading:

Port destination associated with the loading port of a shipment.

​

Port Of Origin Code:        

Port Code associated with the origin port of a shipment

​

PRO #:   

Reference data column provided by the carrier.

​

Processing Days:

Days elapsed since the invoice has been in the audit process?

​

Rated Miles:       

Number of miles the shipment traveled as calculated by Körber's rating engine.

​

Received Date:  

This represents the date that Körber received the invoice.

​

Received Since Category:              

Bucketed identifiers of time since receiving the invoice for quick analysis

​

Receiver Address:            

Address to which the shipment was delivered.

​

Receiver City:     

City of the address to which the shipment was delivered.

​

Receiver Company:         

Company of the address to which the shipment was delivered.

​

Receiver Country:            

Country of the address to which the shipment was delivered.

​

Receiver County Name: 

County of the address to which the shipment was delivered.

​

Receiver Name:

Name associated with the address to which the shipment was delivered.

​

Receiver Postal Code:     

Postal Code of the address to which the shipment was delivered.

​

Receiver State:  

State of the address to which the shipment was delivered.

​

Reference/Reference 2/Reference 3/Reference 4:             

Reference information provided directly by the carrier. Only available if provided to the carrier upon shipment manifest.

​

Responsible Party:           

Party associated with responsibility of payment for an invoice.

​

Run Date:            

Date which the invoice was put on a weekly pay run.

​

Run To Payment:              

Time elapsed between the invoice was put on a run to the point at which the invoice was paid.

​

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.

​

Service Level (Normalized):          

This field groups similar service levels into categories (buckets) that allow for quick analysis

​

Ship Date:            

Date at which shipment occurred.

​

Ship To Invoice: 

Number of days which have passed since the shipment was shipped to when the shipment was invoiced.

​

Shipped Since Category:

Bucketed identifiers of time since shipped for quick analysis.

​

Shipper Address:              

Address which the shipment was shipped from.

​

Shipper City:       

City of the address which the shipment was shipped from.

​

Shipper Company:           

Company of the address which the shipment was shipped from.

​

Shipper Country:              

Country of the address which the shipment was shipped from.

​

Shipper County Name:   

County of the address which the shipment was shipped from.

​

Shipper Name:  

Name associated with the address which the shipment was shipped from.

​

Shipper Postal Code:       

Postal Code of the address which the shipment was shipped from.

​

Shipper Region: 

Region of the address which the shipment was shipped from

​

Shipper State:    

State of the address which the shipment was shipped from.

​

Total Charges (USD):       

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.

​

Total Rated Amount (USD):          

The total rated amount of a shipment as billed by the carrier.

​

Total Spend (USD):          

Total amount due to the carrier after the audit has been complete. This column reflects any short pays advised by

Körber.

​

Total Spend Normalized (USD):  

Total amount due to the carrier after the audit has been complete that has been normalized.

​

Transit Days:       

Transit days is a true calendar day calculation.  If a package ships ground on Monday, 12/23 and arrives on Monday, 12/30, the Transit days would read “7”, even though the holiday and weekend occurred in that period.

 

Transit Days Bucket:        

Bucketed identifier of days in transit which goes up to 10.

​

Transportation Mode:    

The method by which a shipment was sent (LTL, TL, AIR, OCEAN, COURIER, PARCEL, etc.)

​

Zone (Invoiced):

Standardized billing zone which a shipment was billed at.

​

Zone (Normalized):         

This field groups similar zones into buckets (2,3,4,5,6,7, or 8) that allow for quick analysis.

​

Custom Calculation Descriptions

​

# of Non-Expedited Service Level Shipments:       

Calculation of the # of non expedited shipments for a given time range.

• Formula: SUM(normalized_package_count) - (SUM(normalized_package_count) where normalized_service_level in ('2 DAY','2 DAY AM','3 DAY','NEXT DAY','NEXT DAY AM','NEXT DAY SAVER','STANDARD OVERNIGHT','PRIORITY OVERNIGHT','EXPRESS SAVER','FIRST OVERNIGHT','SAME DAY'))

​

# of Expedited Service Level Shipments: 

Calculation of the #  expedited shipments for a given time range.

• Formula: (SUM(normalized_package_count) where normalized_service_level in ('2 DAY','2 DAY AM','3 DAY','NEXT DAY','NEXT DAY AM','NEXT DAY SAVER','STANDARD OVERNIGHT','PRIORITY OVERNIGHT','EXPRESS SAVER','FIRST OVERNIGHT','SAME DAY'))

​

# of Shipments < 10,000 lbs:    

Amount of shipments that are less than 10,000 lbs for a given time range.

• sum(normalized_package_count) where total_weight_lbs between 0 and 10000

​

# of Shipments > 10,000 Lbs:

Amount of shipments that are more than 10,000 lbs for a given time range.

• sum(normalized_package_count) where total_weight_lbs > 100

 

# of Shipments under 150 lbs:    

Amount of shipments that are less than 150 lbs for a given time range.

• sum(normalized_package_count) where total_weight_lbs between 0 and 150

 

$ Due:

Total amount of the invoices left due after paid and payment processing are taken out.

• (SUM(total_charges_usd) - (SUM(total_charges_usd) where invoice_status = 'PAID') - (SUM(total_charges_usd) where invoice_status = 'PAYMENT PROCESSING'))

 

$ Paid: 

Total amount of the invoices paid or payment is processing.        

• ((SUM(total_due_amount_usd) where invoice_status = 'PAID') + (SUM(total_due_amount_usd) where invoice_status = 'PAYMENT PROCESSING'))

 

$ Pending Carrier:           

Total amount of the invoices that are to be reviewed by the carrier.         

• (SUM(total_charges_usd) where invoice_status = 'PENDING CARRIER REVIEW')

 

$ Pending Customer:

Total amount of the invoices that are to be reviewed by the customer.               

• (SUM(total_charges_usd) where invoice_status = 'PENDING CUSTOMER REVIEW') + (SUM(total_charges_usd) where invoice_status = 'PENDING CUSTOMER FUNDING')

 

$ Pending Körber:         

Total amount of the invoices that are to be reviewed by the Körber.       

• (SUM(total_charges_usd)-(SUM(total_charges_usd) where invoice_status = 'PENDING CUSTOMER REVIEW')-(SUM(total_charges_usd) where invoice_status = 'PENDING CARRIER REVIEW')-(SUM(total_charges_usd) where invoice_status = 'PENDING CUSTOMER FUNDING')-(SUM(total_charges_usd) where invoice_status = 'ZERO PAID')-(SUM(total_charges_usd) where invoice_status = 'PAYMENT PROCESSING')-(SUM(total_charges_usd) where invoice_status = 'PAID'))

 

$ True Charges:

Total amount of the shipments that are true charges.     

• (SUM(total_charges_usd) - (SUM(total_charges_usd) where invoice_status = 'PAID') + (SUM(total_due_amount_usd) where invoice_status = 'PAID') - (SUM(total_charges_usd) where invoice_status = 'PAYMENT PROCESSING') + (SUM(total_due_amount_usd) where invoice_status = 'PAYMENT PROCESSING') - (SUM(total_charges_usd) where invoice_status = 'PENDING CUSTOMER FUNDING') + (SUM(total_due_amount_usd) where invoice_status = 'PENDING CUSTOMER FUNDING') - (SUM(total_charges_usd) where invoice_status = 'ZERO PAID') + (SUM(total_due_amount_usd) where invoice_status = 'ZERO PAID'))

 

% Chargeable Weight (Normalized)

 (sum(total_weight_lbs) where normalized_package_count > 0)/(sum(actual_weight_lbs) where normalized_package_count > 0)

 

% Expedited Service Level:          

Percentage of expedited service level shipments for the data set.              

• ((SUM(total_due_amount_usd) where normalized_service_level in ('2 DAY','2 DAY AM','3 DAY','NEXT DAY','NEXT DAY AM','NEXT DAY SAVER','STANDARD OVERNIGHT','PRIORITY OVERNIGHT','EXPRESS SAVER','FIRST OVERNIGHT','SAME DAY'))/SUM(total_due_amount_usd) * 100)

 

% Out of Network Shipments:   

Percentage of shipments that utilize zone 6, 7, and 8 for the data set.     

• ((SUM(normalized_package_count) where normalized_zone = '6') + (SUM(normalized_package_count) where normalized_zone = '7') + (SUM(normalized_package_count) where normalized_zone = '8')) /SUM(normalized_package_count) * 100

 

% Perfect Billing:              

• Percentage of shipments that require no adjustments for the data set.    (SUM(normalized_package_count) where invoicing_accuracy_category = 'PERFECT BILLING')/SUM(normalized_package_count)

 

% Pkgs Delivered-1 Bus. Day:      

Percentage of packages delivered in 1` business day for the data set.       

• (SUM(normalized_package_count) where business_days_in_transit <= 1)/(SUM(normalized_package_count))

 

% of Truck Capacity Used (Lbs):

% of the trucks full capacity used for freight shipments.

• (sum(total_weight_lbs) where normalized_package_count > 0)/(44000)

 

Average Zone:  

Average zone used for shipments of the data set.             

• ((((SUM(normalized_package_count) where normalized_zone = '2')/SUM(normalized_package_count))*2) + (((SUM(normalized_package_count) where normalized_zone = '3')/SUM(normalized_package_count))*3) + (((SUM(normalized_package_count) where normalized_zone = '4')/SUM(normalized_package_count))*4) + (((SUM(normalized_package_count) where normalized_zone = '5')/SUM(normalized_package_count))*5) + (((SUM(normalized_package_count) where normalized_zone = '6')/SUM(normalized_package_count))*6) + (((SUM(normalized_package_count) where normalized_zone = '7')/SUM(normalized_package_count))*7) + (((SUM(normalized_package_count) where normalized_zone = '8')/SUM(normalized_package_count))*8))/1

​

Avg Billed Miles :

Average miles billed for shipments of the data set.           

• (sum(billed_miles) where normalized_package_count > 0) / sum(normalized_package_count)

​

Cost Savings (2 Day to Ground):

Total savings opportunity available by comparing average cost per shipment of 2 day service to average cost/shipment of ground service for the data set. Calculation shows savings if using ground instead of 2 day service.       

• ((SUM(total_due_amount_usd)/SUM(normalized_package_count) where normalized_service_level IN ('2 DAY'))-(SUM(total_due_amount_usd)/SUM(normalized_package_count) where normalized_service_level IN ('GROUND'))) * (SUM(normalized_package_count) where normalized_service_level IN ('2 DAY'))

 

Cost/Lb (Billed):

Cost per billed pound of shipments for a data set.            

• SUM(total_due_amount_usd)/(sum(total_weight_lbs) where normalized_package_count > 0)

 

Cost/Shipment:

Cost per shipment for a data set.              

• SUM(total_due_amount_usd)/SUM(normalized_package_count)

 

Cost/Shipment Savings (2 Day to Ground):           

Cost/shipment savings by comparing cost/shipment of 2 day service to cost/shipment of ground service for the data set.        

• (SUM(total_due_amount_usd)/SUM(normalized_package_count) where normalized_service_level IN ('2 DAY'))-(SUM(total_due_amount_usd)/SUM(normalized_package_count) where normalized_service_level IN ('GROUND '))

 

Expedited Service Level Spend: 

Total spend associated with expedited service level shipments for the data set.  

• ((SUM(total_due_amount_usd) where normalized_service_level = '2 DAY') + (SUM(normalized_package_count) where normalized_service_level = '2 DAY AM') + (SUM(normalized_package_count) where normalized_service_level = '3 DAY') + (SUM(normalized_package_count) where normalized_service_level = 'NEXT DAY') + (SUM(normalized_package_count) where normalized_service_level = 'NEXT DAY AM') + (SUM(normalized_package_count) where normalized_service_level = 'NEXT DAY SAVER') + (SUM(normalized_package_count) where normalized_service_level = 'STANDARD OVERNIGHT') + (SUM(normalized_package_count) where normalized_service_level = 'PRIORITY OVERNIGHT') + (SUM(normalized_package_count) where normalized_service_level = 'EXPRESS SAVER') + (SUM(normalized_package_count) where normalized_service_level = 'FIRST OVERNIGHT') + (SUM(normalized_package_count) where normalized_service_level = 'SAME DAY'))

 

LM # of Non-Expedited Service Level Shipments:

Last months # of non expedited shipments          

• SUM(normalized_package_count) - (SUM(normalized_package_count) where normalized_service_level in ('2 DAY','2 DAY AM','3 DAY','NEXT DAY','NEXT DAY AM','NEXT DAY SAVER','STANDARD OVERNIGHT','PRIORITY OVERNIGHT','EXPRESS SAVER','FIRST OVERNIGHT','SAME DAY')) TRANSFORM ship_date = PreviousPeriod('months',1)

 

LM # of Expedited Service Level Shipments:        

Last months # of expedited shipments  

• (SUM(normalized_package_count) where normalized_service_level in ('2 DAY','2 DAY AM','3 DAY','NEXT DAY','NEXT DAY AM','NEXT DAY SAVER','STANDARD OVERNIGHT','PRIORITY OVERNIGHT','EXPRESS SAVER','FIRST OVERNIGHT','SAME DAY'))TRANSFORM ship_date = PreviousPeriod('months',1)

 

LM % of Expedited Service Level:

Last months percentage use of expedited service level shipments               

• ((SUM(total_due_amount_usd) where normalized_service_level in ('2 DAY','2 DAY AM','3 DAY','NEXT DAY','NEXT DAY AM','NEXT DAY SAVER','STANDARD OVERNIGHT','PRIORITY OVERNIGHT','EXPRESS SAVER','FIRST OVERNIGHT','SAME DAY'))/SUM(total_due_amount_usd) * 100)TRANSFORM ship_date = PreviousPeriod('months',1)

 

LM (Ship) Cost/Shipment:           

Last months cost per shipment by ship date        

• SUM(total_due_amount_usd)/SUM(normalized_package_count) TRANSFORM ship_date = PreviousPeriod('months',1)

 

LM (Ship) Cost/lb:           

Last months cost per billed pound by ship date 

• SUM(total_due_amount_usd)/(sum(total_weight_lbs) where normalized_package_count > 0) TRANSFORM ship_date = PreviousPeriod('months',1)

 

LM (Ship) Lbs/Shipment (Billed):

Average pound per shipment of the data set by ship date             

• (sum(total_weight_lbs) where normalized_package_count > 0)/(sum(normalized_package_count) transform ship_date = PreviousPeriod('months',1))

 

LM (Ship) Total Spend (USD):     

Last months total spend by ship date     

• sum(total_due_amount_usd) TRANSFORM ship_date = PreviousPeriod('years',1)

 

LY % Chargeable Weight (Normalized):

• (sum(total_weight_lbs) where normalized_package_count > 0)/(sum(actual_weight_lbs) where normalized_package_count > 0) TRANSFORM ship_date = PreviousPeriod('years',1)

 

 

LY % Chargeable Weight (Normalized):

• (sum(total_weight_lbs) where normalized_package_count > 0)/(sum(actual_weight_lbs) where normalized_package_count > 0) TRANSFORM ship_date = PreviousPeriod('years',1)

 

LY (Inv) Total Spend:      

Last years total spend by invoice date    

• sum(total_due_amount_usd) TRANSFORM bill_date = PreviousPeriod('years',1)

 

LY (Ship) # of Shipments:

Last years total # of shipments by ship date         

• sum(normalized_package_count) TRANSFORM ship_date = PreviousPeriod('years',1)

 

LY (Ship) Average Zone:

Last year’s average zone by ship date     

• ((((sum(normalized_package_count) where normalized_zone = '2')/SUM(normalized_package_count))*2) + (((SUM(normalized_package_count) where normalized_zone = '3')/SUM(normalized_package_count))*3) + (((SUM(normalized_package_count) where normalized_zone = '4')/SUM(normalized_package_count))*4) + (((SUM(normalized_package_count) where normalized_zone = '5')/SUM(normalized_package_count))*5) + (((SUM(normalized_package_count) where normalized_zone = '6')/SUM(normalized_package_count))*6) + (((SUM(normalized_package_count) where normalized_zone = '7')/SUM(normalized_package_count))*7) + (((SUM(normalized_package_count) where normalized_zone = '8')/SUM(normalized_package_count))*8))/1 TRANSFORM ship_date = PreviousPeriod('years',1)

 

LY (Ship) Cost/Shipment:

Last years cost per shipment by ship date

• SUM(total_due_amount_usd)/SUM(normalized_package_count) TRANSFORM ship_date = PreviousPeriod('years',1)

 

LY (Ship) Total Spend:   

Last years total spend by ship date          

• sum(total_due_amount_usd) TRANSFORM ship_date = PreviousPeriod('years',1)

 

LY Cost/LB (Billed):         

Last years cost per billed pound                

• SUM(total_due_amount_usd)/(sum(total_weight_lbs) where normalized_package_count > 0) TRANSFORM ship_date = PreviousPeriod('years',1)

 

LY Lbs/Shipment (Actual):           

Last years actual pound per shipment    

• ((sum(actual_weight_lbs) where normalized_package_count > 0)/sum(normalized_package_count)) transform ship_date = PreviousPeriod('years',1)

 

LY Lbs/Shipment (Billed):             

Last years billed pounds per shipment   

• ((sum(total_weight_lbs) where normalized_package_count > 0)/sum(normalized_package_count)) transform ship_date = PreviousPeriod('years',1)

 

​