Loop Intelligence Data Dictionary: Fields

Carrier

Vendor Name, Parent Vendor Name

Loop says vendor because not every provider is a carrier. Warehouses, brokers, and platform providers are vendors too. Parent Vendor Name groups variations, such as all FedEx entities.

Shipper, Shipper Name

Payor Name

The organization responsible for paying the invoice.

Mode (LTL, FTL, Parcel)

Vendor Service Name

Part of the service hierarchy. See Services below.

Service level, service type

Loop Service Level Display

Loop's standardized level, such as Express - 2 Day - End of Day.

Carrier's service name

Carrier Service Level Display, Carrier Service Level Raw

Display is standardized (for example, UPS Ground). Raw is the name exactly as the carrier sent it.

Tracking number

Shipment Number

For parcel, Shipment Number is the tracking number.

Master tracking number

Parent Shipment Number

Groups multi-package or multi-part shipments.

PRO, BOL, PO, and other reference numbers

Reference Numbers

All reference numbers on a shipment, in one field.

Ship date

Vendor Service Date

For transportation, this is the pickup date.

Ship-from, ship-to, consignee

Origin and Destination fields

Name, address, city, state, postal code, country, and region.

Rated or billable weight

Billed Weight

Can differ from Actual Weight because of dimensional weight rules.

Linehaul, base rate, freight charge

Charge Classification = Rate

Freight metrics (such as Freight Cost Per Shipment) cover Rate charges.

Customs brokerage

Charge Classification = IMEX

Import/export vendor fees. Government duties and taxes are separate.

Duties and taxes

Charge Classification = Duty, Tax, VAT

Total spend, total charges

Total Terminal Amount

Spend at each charge's current payment stage.

Shipment count

Shipment Count

Freight movements only. Use Service Count for all vendor activity.

Cost per pound or kilogram

Cost Per Weight

Uses the weight unit you select in the report.

Cost per mile

Cost Per Distance

Uses the distance unit you select in the report.

Days in transit

Transit Duration Days, Transit Duration Business Days

GL code, cost center

Cost Codes

Your own cost allocation codes.

Invoice total

Invoice Amount

The total for the whole invoice, not one charge.

Check or payment number

Payment Display Id

Exchange rate

Conversion Rate

Workplace Name

Your Loop workplace

Tenant Name

Your company's account name in Loop

Vendor Name

The vendor or carrier that billed the charge

Parent Vendor Name

Groups vendor name variations, for example all Federal Express entities under FedEx

Payor Name

The organization responsible for paying the invoice (Shipper Name in older reports)

Payee Name

The organization the payment goes to. Usually the vendor, but can differ, for example when a subcontractor is paid

Invoice Number

The vendor's invoice number as it appears on the bill

Shipment Number

The shipment number for this service. For parcel, the tracking number

Parent Shipment Number

The shipment number of the parent service in a multi-part shipment. For parcel, the master tracking number

Reference Numbers

All reference numbers on the shipment, grouped in one field (see below)

Service Url, Parent Service Url

Links to the service record (or its parent) in Loop

Vendor Service Classification

The broad supply chain function, such as Transportation or Warehousing

Vendor Service Category

The service family within the classification, such as Freight or Small Package

Vendor Service Name

The specific service or mode, such as LTL, FTL, Parcel, or Courier

Vendor Service Mode

Separates physical movements from fee-only services within a mode, for example Parcel Transportation Fees vs. Parcel Service Fees. Service Fees are not counted as shipments

Loop Service Level Classification

Top tier of Loop's standardized service level, such as Ground, Express, or Post

Loop Service Level Category

Middle tier, such as Standard, 2 Day, or International Priority

Loop Service Level Name

Most detailed tier, such as End of Day or AM Early

Loop Service Level Display

All three tiers combined, for example Express - 2 Day - End of Day

Carrier Service Level Display

The carrier's service level, standardized, for example UPS Ground

Carrier Service Level Raw

The carrier's service level exactly as it was received

Charge Classification

The top-level bucket: Rate, Fuel, Accessorial, IMEX, Duty/Tax/VAT, or Other. Spend-by-type metrics use it

Charge Category

Groups similar charges within a classification

Charge Name

The specific charge, standardized across carriers, such as Liftgate Fee or Fuel Surcharge

Currency Code

The currency the charge was billed in

Published Amount

The published tariff or rate, before discounts or invoice adjustments

Discount Amount

The vendor discount off the Published Amount

Invoiced Amount

What the vendor billed. Can differ from Published Amount if a pre-discounted or non-standard rate applied

Approved Amount

What Loop's audit approved as owed, after any audit adjustments

Funded Amount

What you funded to Loop to pay the vendor (accounts where Loop pays vendors)

Paid Amount

What was paid to the vendor. Equals Approved Amount once paid

Terminal State

The furthest payment stage the charge has reached: Invoiced, Approved, Funded, or Paid

Terminal Amount

The amount at the charge's current Terminal State. Spend metrics are built from this field

Conversion Rate

The exchange rate used to convert the charge into your reporting currency

Target Currency Code

The reporting currency your converted spend metrics are shown in

Actual Weight, Actual Weight Unit

Scale weight and the unit it was recorded in

Billed Weight, Billed Weight Unit

The weight used for billing and its unit. Can differ from Actual Weight because of dimensional weight rules

Shipment Distance Miles

Distance between origin and destination, in miles. Distance metrics convert to your selected unit

Transit Duration Days

Calendar days from Pickup Date to Delivery Date, when a delivery date exists and is after pickup

Transit Duration Business Days

The carrier's operating days from pickup to delivery, excluding carrier holidays. For carriers without a transit calendar, Monday through Friday

Origin and Destination Name and Address

Facility name, street address, city, state or province, and postal code

Origin and Destination Country

Country as a full name and as a 2-letter code

Origin and Destination Region

Regional grouping

Origin and Destination Latitude and Longitude

Coordinates, for maps

Destination Type

Residential or Commercial, where the carrier reports it

Shipment City, State, Country, and Region Lane

Origin and destination combined, to compare spend and volume by lane

Vendor Shipment Zone

The zone as reported by the carrier

Loop Shipment Zone Label, Loop Shipment Zone Type

Loop's standardized zone and how it was determined

Loop Shipment Zone Number

US domestic zone as a number (2-8). Blank for other shipments

Cargo Type

The type of unit, such as Package or Container

Cargo Count

The number of units on the service

Cargo Dimensions, Cargo Dimensions Unit

Length, width, and height, and their unit

Freight Classes, Freight Codes

NMFC freight class and freight codes, where applicable

Is Dimensional Weight

Whether billed weight was based on dimensional weight instead of scale weight

Dimensional Weight Source

Whether the dimensional weight determination was audited or deduced

Invoice Amount

The total for the whole invoice, not an individual charge

Invoice Currency Code

The currency the invoice was issued in

Bill To Account, Bill To Account Number

The billing account the invoice was issued to, and its account number

Invoice Status

Where the invoice is in Loop's processing

Audit Status

Where the invoice is in Loop's audit

Review Status

Whether the invoice is under review, reviewed, or not applicable

Review Outcome

The result of any manual review

Normalization Status

Whether Loop has finished standardizing the invoice data

Payment Run Display Id

The payment run ID you see in Loop

Payment Run Type

Custodial (Loop pays the vendor) or Offline (you pay the vendor directly)

Payment Run Status

The current status of the payment run

Payment Display Id

The ID of the individual payment within the run, such as a check or electronic payment number

Reporting Date

A flexible date you can set to service date, invoice date, or payment run date in reports that offer a date-type option

Vendor Service Date

When the vendor performed the service. For transportation, the pickup date

Pickup Date, Delivery Date

When the shipment was picked up and delivered

Invoice Date

The issue date on the invoice. If none was provided, the date Loop received it

Invoice Created Date

When the invoice record was created in Loop

Payment Due Date

When payment on the invoice is due

Approval Deadline

The date of the last scheduled payment run that can still pay the invoice by its due date

Payment Run Date

The date of the payment run

Payment Initiated Date, Payment Completed Date

When payment to the vendor started and finished

Cost Code Updated At

When the cost codes on the record last changed

Cost Codes

Your cost allocation for each charge, such as GL code, cost center, or company code. Code types are your own, so they differ by account

Vendor Service Attributes

Your own data for a service, if you send it to Loop. When your value duplicates one Loop already has, it is labeled with a CLIENT_ prefix so you can compare the two

Is Primary Allocation Row

Marks one row per charge when a charge is split across several cost codes. Use it to avoid double counting

Record Source

The system the row came from