.png)
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 the Infios FAP Portal.
Adjustment Reason:
If an invoicing error is found during an Infios 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 the Infios FAP Portal.
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 an Infios 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 the Infios system.
Currency Code (Native):
Code of currency the invoice is charged in (USD, EUR, GBP, etc.)
Customer Code:
4-character alphanumeric code created by Infios to identify each customer.
Customer Name:
Name of the Infios 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 Infios 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 Infios by the carrier (EDI, PAPER, Online Data Entry-ODE, etc.)
Invoice Status:
Current progress of an invoice through the Infios audit process.
Invoice To Create:
Number of days which have passed since the shipment was invoiced to when the shipment was created in the Infios 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 the Infios 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 Infios 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 Infios.
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 Infios rating engine.
Received Date:
This represents the date that Infios 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
Infios.
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
LY(Ship) Avg Days in Transit:
Last years average days in transit by ship date
-
avg(transit_days) TRANSFORM ship_date = PreviousPeriod('years',1)
Lbs/Shipment (Actual):
Average actual pound per shipment of the data set
-
(sum(actual_weight_lbs) where normalized_package_count > 0) / SUM(normalized_package_count)
Lbs/Shipment (Billed):
Average billed pound per shipment of the data set
-
(sum(total_weight_lbs) where normalized_package_count > 0)/sum(normalized_package_count)
Normalized Miles (Billed):
Total billed miles not including zero package count shipments for a data set
-
sum(billed_miles) where normalized_package_count > 0
Normalized Weight (Actual, KG):
Total actual kilograms not including zero package count shipments for a data set
-
sum(actual_weight_kgs) where normalized_package_count > 0
Normalized Weight (Actual, LB) :
Total actual pounds not including zero package count shipments for a data set
-
sum(actual_weight_lbs) where normalized_package_count > 0
Normalized Weight (Billed, KG):
Total billed kilograms not including zero package count shipments for a data set
-
sum(total_weight_kgs) where normalized_package_count > 0
Normalized Weight (Billed, LB):
Total billed pounds not including zero package count shipments for a data set
-
sum(total_weight_lbs) where normalized_package_count > 0
Rated vs Billed Charges:
Total charges amount minus total rated amount for a data set
-
SUM(total_charges_usd)-SUM(total_rated_amount_usd)
Service Charge:
Alternate total spend on weekly service charges per shipment for a data set
-
(SUM(total_due_amount_usd) WHERE service_level='WEEKLY SERVICE CHARGE') / SUM(normalized_package_count)
Service Charge Spend Per Shipment:
Total spend on weekly service charges per shipment for a data set
-
(SUM(total_due_amount_usd) WHERE service_level='WEEKLY SERVICE CHARGE') / SUM(normalized_package_count)
Total Service Level Optimization Savings:
Total savings opportunity available by utilizing the smallest average cost per shipment service level for a 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'))) * (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 ('3 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 ('3 DAY'))+((SUM(total_due_amount_usd)/SUM(normalized_package_count) where service_level IN ('GROUND RESIDENTIAL'))-(SUM(total_due_amount_usd)/SUM(normalized_package_count) where service_level IN ('UPS SUREPOST - 1 LB OR GREATER'))) * (SUM(normalized_package_count) where service_level IN ('GROUND RESIDENTIAL'))+((SUM(total_due_amount_usd)/SUM(normalized_package_count) where normalized_service_level IN ('NEXT DAY'))-(SUM(total_due_amount_usd)/SUM(normalized_package_count) where normalized_service_level IN ('NEXT DAY SAVER'))) * (SUM(normalized_package_count) where normalized_service_level IN ('NEXT DAY SAVER')))
Total Shipments:
Total shipments associated with a data set
-
SUM(normalized_package_count)
Total Spend not on a Pay run:
Total spend amount not associated with a pay run for a data set
-
sum(total_due_amount_usd) where run_no = '[Empty]'
Weekly Service Charge Spend:
Total spend on weekly service charges for shipments of a data set
-
SUM(total_due_amount_usd) WHERE service_level='WEEKLY SERVICE CHARGE'
Weight Variance (Billed - Actual Weight) Normalized:
Total weight difference between billed and actual weight for a data set
-
((sum(total_weight_lbs) where normalized_package_count > 0)-(sum(actual_weight_lbs) where normalized_package_count > 0))/SUM(normalized_package_count)