Zone Cost Definitions

Internal Table Name: AdvancedCosting_ZoneCostDefinitions

Use this table to define the high level zone to zone definition. You identify the group that is used as a zone, such as a State or Zip Code. Once you have defined the Zone Cost Definitions, and the related Zone Assignments and Zone Costs, you can use this Zone Cost Definition for the Variable Transportation Cost on the Modes table.

If a lookup cannot be found for the zone, a cost of 9999 will be incurred. This is the case if the zone cost is used for Fixed Shipment Cost or Variable Transportation Cost.

Name

Technology: NO

Table: AdvancedCosting_ZoneCostDefinitions

Internal Name: ZoneCostName

Type: Short Text (100)

Enter the name for the zone cost definition.

Zone Definition

Technology: NO

Table: AdvancedCosting_ZoneCostDefinitions

Internal Name: ZoneGroupReferenceField

Type: Short Text (100)

Select the level that is used to define the zone cost. This is one of:

  • Organization
  • Country
  • State
  • City
  • Postal Code
  • 3 Digit Zip
  • Custom 1
  • Custom 2

Default: State

Step Basis

Technology: NO

Table: AdvancedCosting_ZoneCostDefinitions

Internal Name: ThroughputBasis

Type: Short Text (100)

Choose the unit of measure basis on which zone costs are based:

  • Quantity
  • Weight
  • Volume

Default: Weight

Step Period

Technology: NO

Table: AdvancedCosting_ZoneCostDefinitions

Internal Name: ThroughputPeriod

Type: Short Text (100)

One of Period Length, Day, Week, Month (30 day), Quarter (91 day), Year, Shipment

Choose the period (Day, Week, Month (30 day), Quarter (91 day), or Year) or Shipment over which the Zone Cost is applied.

Default: Shipment

Step Type

Technology: NO

Table: AdvancedCosting_ZoneCostDefinitions

Internal Name: StepTreatment

Type: Short Text (100)

One of All Item, Incremental.

  • Incremental – Piecewise costs are calculated based on the break points you create with Step Size. For example, assume you have set up the Steps and Costs as:
    0246
    1.51.31.251.1

and the size is 9, the total cost will be:

(2 - 0) * 1.5 + (4 - 2) * 1.3 + (6 - 4) * 1.25 + (9 - 6) * 1.1 = 11.4

  • All Item – The cost will be based on the break in which the total occurs. Given the same example from above, for a size of 9, the total cost will be:

9 * 1.1 = 9.9

Default: All Item

Notes

Technology: NO

Table: AdvancedCosting_ZoneCostDefinitions

Internal Name: ZoneDefinitionsNotes

Type: Memo

Enter optional descriptive notes about the zone cost definition.

Last modified: Friday May 12, 2023

Is this useful?