LTL Rate

Internal Table Name: LTLRate

You use the LTL Rate table to define specific carrier-based costs for origin-destination and optionally product combinations. The Origin and Destination values you populate depend on the Origin Definition and Destination Definition (such as State, Country and Postal Code). Least cost valid rates per shipment are populated in the LTL Costing Summary table for use in costing routes for Transportation Optimization.

Carrier Name

Technology: TO

Table: LTLRate

Internal Name: CarrierName

Type: Short Text (100)

Enter the carrier to which the LTL rate applies.

Origin

Technology: TO

Table: LTLRate

Internal Name: Origin

Type: Short Text (100)

Enter the origin location to which the LTL rate applies. Use the Origin Definition to determine the type of origin location.

Origin Definition

Technology: TO

Table: LTLRate

Internal Name: OriginDefinition

Type: Short Text (100)

Select the type of location for the Origin of the LTL Rate. This is one of:

• Name – The Name value of the Customer or Site.
• City – The City value from the Customer or Site record.
• State – The State value from the Customer or Site record.
• Postal Code – The Postal Code value from the Customer or Site record.
• 3 Digit Zip – The first 3 digits of the Postal Code from the Customer or Site record.
• Country – The Country value from the Customer or Site record.
• Organization – The Organization value from the Customer or Site record.
• Custom 1 – The Custom 1 value from the Customer or Site record.
• Custom 2 – The Custom 2 value from the Customer or Site record.

Destination

Technology: TO

Table: LTLRate

Internal Name: Destination

Type: Short Text (100)

Enter the destination location to which the LTL rate applies. Use the Destination Definition to determine the type of origin location.

Destination Definition

Technology: TO

Table: LTLRate

Internal Name: DestinationDefinition

Type: Short Text (100)

Select the type of location for the Destination of the LTL Rate. This is one of:

• Name – The Name value of the Customer or Site.
• City – The City value from the Customer or Site record.
• State – The State value from the Customer or Site record.
• Postal Code – The Postal Code value from the Customer or Site record.
• 3 Digit Zip – The first 3 digits of the Postal Code from the Customer or Site record.
• Country – The Country value from the Customer or Site record.
• Organization – The Organization value from the Customer or Site record.
• Custom 1 – The Custom 1 value from the Customer or Site record.
• Custom 2 – The Custom 2 value from the Customer or Site record.

Product

Technology: TO

Table: LTLRate

Internal Name: ProductName

Type: Short Text (100)

Enter the product name to which the LTL Rate applies. This value is used to identify the Freight Class.

Base Cost

Technology: TO

Table: LTLRate

Internal Name: BaseCost

Type: Short Text (100)

Enter the base cost for the LTL rate, or select a Rate Source from the Shipping Rates table to populate the Base Cost. The Discount Rate and Fuel Surcharge are applied to the Base Cost.

Discount Rate

Technology: TO

Table: LTLRate

Internal Name: DiscountRate

Type: Short Text (100)

Enter the discount factor that is applied to the Base Cost. This is applied as:

Base Cost * (1 - Discount Rate / 100)

Minimum Charge

Technology: TO

Table: LTLRate

Internal Name: MinimumCharge

Type: Short Text (100)

Enter the minimum charge that must be incurred. 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: LTLRate

Internal Name: FuelSurcharge

Type: Short Text (255)

Enter the fuel surcharge that is applied to the Base Cost. This is applied as:

Base Cost * (1 + Fuel Surcharge / 100)

Transit Time

Technology: TO

Table: LTLRate

Internal Name: TransitTime

Type: Short Text (100)

Enter the time incurred to transport the shipment from the Origin to the Destination.

Minimum Weight

Technology: TO

Table: LTLRate

Internal Name: MinimumWeight

Type: Short Text (100)

Enter the minimum weight required in order to use this LTL Rate.

Maximum Weight

Technology: TO

Table: LTLRate

Internal Name: MaximumWeight

Type: Short Text (255)

Enter the maximum weight allowed in order to use this LTL Rate.