Tax & Duty Summary

Internal Table Name: OptimizationOutputTaxDutySummary

Use the Tax & Duty Summary to review the tax credits, debits and balances for each tax region per period.

Scenario

Table: OptimizationOutputTaxDutySummary

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

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

Tax Region Name

Table: OptimizationOutputTaxDutySummary

Internal Name: TaxRegionName

Displays the tax region name from the Tax And Duty Regions table.

Period Number

Table: OptimizationOutputTaxDutySummary

Internal Name: PeriodNumber

Displays the period number for which the tax summary results apply.

Period

Table: OptimizationOutputTaxDutySummary

Internal Name: Period

Displays the period name for which the tax summary results apply.

Organization Name

Table: OptimizationOutputTaxDutySummary

Internal Name: OrganizationName

The Organization to which the tax duty is allocated. When taxes and duties are incurred by Sites and Customers that belong to the Organization, these are attributed to the Organization as required.

Refundable Tax Credit

Table: OptimizationOutputTaxDutySummary

Internal Name: RefundableTaxCredit

Displays the refundable tax credit based on the product imported into the region (where the region is the destination). This is calculated as:

Refundable Tax Credit = Flow Units * Refundable Tax Base Percentage * Refundable Tax Rate Percentage * Unit Price

Refundable Tax Debit

Table: OptimizationOutputTaxDutySummary

Internal Name: RefundableTaxDebit

Displays the refundable tax debit based on the product exported into the region (where the region is the source). This is calculated as:

Refundable Tax Credit = Flow Units * Refundable Tax Base Percentage * Refundable Tax Rate Percentage * Unit Price

Period Start Refundable Tax Balance

Table: OptimizationOutputTaxDutySummary

Internal Name: PeriodStartRefundableTaxBalance

Displays the refundable tax balance (credit - debit) at the start of the period.

Refundable Tax

Table: OptimizationOutputTaxDutySummary

Internal Name: RefundableTax

Displays the net payable refundable tax. This will be positive for records with a Refundable Tax Credit and negative for records with a Refundable Tax Debit.

Period End Refundable Tax Balance

Table: OptimizationOutputTaxDutySummary

Internal Name: PeriodEndRefundableTaxBalance

Displays the refundable tax balance (credit - debit) at the end of the period.

Refundable Balance

Table: OptimizationOutputTaxDutySummary

Internal Name: RefundableBalance

Displays the refundable tax balance that can be carried forward.

Non-Refundable Tax Credit

Table: OptimizationOutputTaxDutySummary

Internal Name: NonRefundableTaxCredit

Displays the non-refundable tax credit based on the product imported into the region (where the region is the destination). This is calculated as:

Non-Refundable Tax Credit = Flow Units * Non-Refundable Tax Base Percentage * Non-Refundable Tax Rate Percentage * Unit Price

Non-Refundable Tax Debit

Table: OptimizationOutputTaxDutySummary

Internal Name: NonRefundableTaxDebit

Displays the non-refundable tax debit based on the product exported into the region (where the region is the source). This is calculated as:

Non-Refundable Tax Debit = Flow Units * Non-Refundable Tax Base Percentage * Non-Refundable Tax Rate Percentage * Unit Price

Scenario ID

Table: OptimizationOutputTaxDutySummary

Internal Name: ScenarioID

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

Sub-Scenario ID

Table: OptimizationOutputTaxDutySummary

Internal Name: StepNumber

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