LTL Costing Summary

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

LTL Costing Summary

Internal Table Name: LTLCostingSummary

The LTL Costing Summary provides per shipment cost information, based on carrier-based costing defined in the LTL Rate table. It is populated using Calculate LTL Cost from the LTL Rate table.

Shipment ID

Technology: TO

Table: LTLCostingSummary

Internal Name: ShipmentID

Type: Number (Integer)

The unique identifier of the shipment.

Shipment Name

Technology: TO

Table: LTLCostingSummary

Internal Name: ShipmentName

Type: Short Text (100)

The name of the shipment from the Shipments table.

Source

Technology: TO

Table: LTLCostingSummary

Internal Name: SourceSite

Type: Short Text (100)

The source location for the current shipment from the Shipments table.

Destination

Technology: TO

Table: LTLCostingSummary

Internal Name: DestinationSite

Type: Short Text (100)

The destination location for the current shipment from the Shipments table.

Product

Technology: TO

Table: LTLCostingSummary

Internal Name: ProductName

Type: Short Text (100)

The name of the product for the current shipment from the Shipments table.

Quantity

Technology: TO

Table: LTLCostingSummary

Internal Name: Quantity

Type: Short Text (50)

The quantity of the current shipment from the Shipments table. If no quantity unit is specified, the default quantity unit of measure from Model Settings is used.

Shipment Weight

Technology: TO

Table: LTLCostingSummary

Internal Name: ShipmentWeight

Type: Short Text (50)

The weight of the current shipment from the Shipments table. If the Shipments table does not have Weight populated, the Quantity from Shipments is multiplied by the Unit Weight in the Products table. If no weight unit is specified, the default weight unit of measure from Model Settings is used.

Service Time Window

Technology: TO

Table: LTLCostingSummary

Internal Name: ServiceTimeWindow

Type: Short Text (100)

The time duration in which the shipment must be moved from the source to the destination. This is based on the Shipment Due Date minus the Earliest Pickup Date.

Carrier Name

Technology: TO

Table: LTLCostingSummary

Internal Name: CarrierName

Type: Short Text (100)

The carrier to which the LTL cost applies.

Base Cost

Technology: TO

Table: LTLCostingSummary

Internal Name: BaseCost

Type: Short Text (100)

The carrier’s base cost applied to the shipment based on source, destination, product, weight. This will be the value entered in the Base Cost in the LTL Rate table, or the value pulled from the Shipping Rates table if the Rate Source is populated in the Base Cost.

Discount Rate

Technology: TO

Table: LTLCostingSummary

Internal Name: DiscountRate

Type: Short Text (100)

The discount factor applied to the Base Cost.

Minimum Charge

Technology: TO

Table: LTLCostingSummary

Internal Name: MinimumCharge

Type: Short Text (100)

The minimum charge that must be incurred for the shipment. If the calculated LTL Rate (using Base Cost, Discount Rate, and Fuel Surcharge) is less than the Minimum Charge, the Minimum Charge is applied.

Fuel Surcharge

Technology: TO

Table: LTLCostingSummary

Internal Name: FuelSurcharge

Type: Short Text (255)

The fuel surcharge applied to the LTL Rate.

Transit Time

Technology: TO

Table: LTLCostingSummary

Internal Name: TransitTime

Type: Short Text (100)

The actual transit time from source to destination.

Minimum Weight

Technology: TO

Table: LTLCostingSummary

Internal Name: MinimumWeight

Type: Short Text (100)

The minimum weight for a shipment required by the LTL Rate.

Maximum Weight

Technology: TO

Table: LTLCostingSummary

Internal Name: MaximumWeight

Type: Short Text (255)

The maximum weight for a shipment allowed by the LTL Rate.

LTL Cost

Technology: TO

Table: LTLCostingSummary

Internal Name: LTLCost

Type: Short Text (100)

Provides the LTL Cost based on the carrier, source-destination and shipment attributes. This is calculated as:

MAX(BaseCost * (1 - DiscountRate / 100) x (1 + FuelSurcharge / 100), MinimumCharge)

Is Cheapest Feasible

Technology: TO

Table: LTLCostingSummary

Internal Name: IsCheapestFeasible

Type: Bit

One of Yes, No. (Actual database values are 1,0.)

This field indicates if the LTL rate is the cheapest of those feasible rates given constraints such as the Service Time Window and Minimum/Maximum Weight.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No