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