Taxes And Duties

Internal Table Name: TaxesAndDuties

Use the Taxes And Duties table to define tax and duty values for source-destination-product-period combinations.

Name

Technology: NO

Table: TaxesAndDuties

Internal Name: TaxName

Type: Short Text (100)

Enter the name for the tax and duty definition.

Source

Technology: NO

Table: TaxesAndDuties

Internal Name: Source

Type: Short Text (100)

Select the site that is the source for the product. This can be an individual site or a Tax and Duty Region.

Destination

Technology: NO

Table: TaxesAndDuties

Internal Name: Destination

Type: Short Text (100)

Select the site or customer that is the destination for the product. This can be an individual site or customer, or a Tax and Duty Region.

Product

Technology: NO

Table: TaxesAndDuties

Internal Name: Product

Type: Short Text (100)

Select the product or product group to which the taxes and duties apply.

Period

Technology: NO

Table: TaxesAndDuties

Internal Name: Period

Type: Short Text (100)

Select the period in which the taxes and duties apply. This can be one of:

• Period name – Use this when the taxes and duties apply in a specific period only.
• (ALL_Periods) – The taxes and duties are applied to each individual period in the model.

Value Location Reference

Technology: NO

Table: TaxesAndDuties

Internal Name: ValueLocationReference

Type: Short Text (50)

Select whether the tax value of the product is based on the Source or the Destination. Depending on which of these is selected, the product value will be determined based on what type of location is populated for the Source or Destination:

• If the location is a site (not a customer), use the Product Taxable Value from the Inventory Policies table.
• If the location is a region, then the value is calculated based on the Taxable Value Overrides table. If there are no associated records in the Taxable Value Overrides table, a straight average across locations is used (default).
  • If the region includes a mix of customers and sites, the Product Unit Value is used for the customers and the taxable value (as described above) is used for the sites.
  • If the region includes only sites, the taxable value (as described above) is used.
  • If the region includes only customers, use Unit Value values from Products.

Non Refundable Tax Base Percentage

Technology: NO

Table: TaxesAndDuties

Internal Name: NonRefundableTaxBasePercentage

Type: Number (Float)

Enter the percentage of the product value subject to the tax when calculating the taxable value. This is a base percentage (0 to 100) of tax that are not returned from the collecting party. These become an expense.

For example, assume a product with a Unit Value of 10:

• If the base percentage is 20, the taxable value is 10 * (20/100) = 2

• Then, if the rate percentage is 10, the tax per unit is 2 * (10/100) = 0.2

Non Refundable Tax Rate Percentage

Technology: NO

Table: TaxesAndDuties

Internal Name: NonRefundableTaxRatePercentage

Type: Number (Float)

Enter the tax rate (0 to 100) for taxes that you will not be able to have returned from the collecting party. These become an expense.

Refundable Tax Base Percentage

Technology: NO

Table: TaxesAndDuties

Internal Name: RefundableTaxBasePercentage

Type: Number (Float)

Enter the percentage of the product value subject to the tax when calculating the taxable value. This is a base percentage (0 to 100) of tax that will be refunded from the collecting party. As such, these taxes are not an expense.

For example, assume a product with a Unit Value of 10:

• If the base percentage is 20, the taxable value is 10 * (20/100) = 2

• Then, if the rate percentage is 10, the tax per unit is 2 * (10/100) = 0.2

Refundable Tax Rate Percentage

Technology: NO

Table: TaxesAndDuties

Internal Name: RefundableTaxRatePercentage

Type: Number (Float)

Enter the tax rate (0 to 100) for taxes that will be refunded from the collecting party. As such, these taxes are not an expense.

Status

Technology: NO

Table: TaxesAndDuties

Internal Name: Status

Type: Short Text (25)

One of Include, Exclude.

This field determines whether or not the taxes and duties record will be included when you run the model.

Default: Include

Notes

Technology: NO

Table: TaxesAndDuties

Internal Name: Notes

Type: Memo

Enter optional descriptive notes about the tax and duty rates.