COUNTRY_TAX_POLICY

Definition


The COUNTRY_TAX_POLICY table sets the tax policy to apply for each country

Description


The COUNTRY_TAX_POLICY table sets the tax policy to apply for each country. It also defines if a country belongs to a supra-national group that imposes any taxation rules (ex: EU, ALENA, ...).

Technical Data


Schema Version 5.0.6
Filegroup CATALOG_DATA
Partitioned No

Summary


The COUNTRY_TAX_POLICY table is defined by the following columns in your back-end database. See the column details for more information.

Name PK FK IX Uses Used by Definition
COUNTRY_CODE PK_COUNTRY_TAX_POLICY       

    The country code as defined in ISO 3166
    COUNTRY        

      The name of the country
      SUPRA_TAX_ZONE        

        The Supra-national zone with its proper rules of taxation

        More...

        TAX_POLICY        

          The tax policy to apply for the country

          More...

          Column Details

          The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

          COUNTRY_CODE

          Definition The country code as defined in ISO 3166
          Type NVARCHAR(2), NOT NULL
          Primary Key PK_COUNTRY_TAX_POLICY

          COUNTRY

          Definition The name of the country
          Type NVARCHAR(256), NOT NULL

          SUPRA_TAX_ZONE

          Definition The Supra-national zone with its proper rules of taxation
          Format

          The possible values are:

          • -1: no supra-national zone
          • 0: European Union

          Type DECIMAL(1), NOT NULL

          TAX_POLICY

          Definition The tax policy to apply for the country
          Format

          The possible values are:

          • -1: no tax policy defined
          • 0: VAT mode
          • 1: resale mode (ex: USA)

          Type DECIMAL(1), NOT NULL

          Primary Key Details

          See the primary key information:

          PK_COUNTRY_TAX_POLICY

          Column(s) COUNTRY_CODE
          Filegroup CATALOG_DATA