Duty Rate Details

Internal Table Name: OptimizationOutputDutyRate

Use the Duty Rate Details table to review the duty applied for each lane on a path from initial origin to final destination.

Scenario

Table: OptimizationOutputDutyRate

Internal Name: Not Applicable (Scenario column not in table)

The scenario for which the tax and duty summary data was generated.

Path ID

Table: OptimizationOutputDutyRate

Internal Name: PathID

The unique identifier for the network path.

Lane ID

Table: OptimizationOutputDutyRate

Internal Name: LaneID

The unique identifier of the lane.

Path Source

Table: OptimizationOutputDutyRate

Internal Name: PathOrigin

Displays the initial source for the network path.

Path Destination

Table: OptimizationOutputDutyRate

Internal Name: PathDestination

Displays the final destination for the network path.

Product

Table: OptimizationOutputDutyRate

Internal Name: ProductName

The name of the product that the customer is served on this network path.

Lane Start Location

Table: OptimizationOutputDutyRate

Internal Name: StartLocationName

The source location for the lane.

Lane End Location

Table: OptimizationOutputDutyRate

Internal Name: End Location Name

The destination location for the lane.

Flow Unit

Table: OptimizationOutputDutyRate

Internal Name: FlowUnit

Displays the number of units of the product transported on this lane.

Duty Amount

Table: OptimizationOutputDutyRate

Internal Name: DutyValue

Displays the value of the product for which the duty is incurred on this lane. This is the Flow Unit * product value. The product value is determined in the following order of priority:

Table Column Notes
Duty Rate Product Value Override  
Inventory Policies Product Inventory Value Requires that you have a record defined in the Taxes And Duties table for this product.
Product Unit Value  

Duty Rate Percentage

Table: OptimizationOutputDutyRate

Internal Name: DutyRate

Displays the rate for duty applied to this product on the lane.

Duty Cost

Table: OptimizationOutputDutyRate

Internal Name: DutyCost

Displays the cost incurred for duty on this product on the lane, when that lane is part of a taxed path. If the path is not taxed, then no duty cost will be incurred on the lane. This is the Duty Amount * Duty Rate Percentage.

Scenario ID

Table: OptimizationOutputDutyRate

Internal Name: ScenarioID

The identifier of the scenario for which the summary data was generated.

Sub-Scenario ID

Table: OptimizationOutputDutyRate

Internal Name: StepNumber

The identifier of the sub-scenario, if applicable, for which the summary data was generated.

Last modified: Wednesday May 15, 2024

Is this useful?