Table: dbo.Cch_Tax_Code_Map_To_Acs_Tax_Code
Lists the different types of Cch codes.
Columns
Name | Type | Constraints | Description
cch_tax_code_map_to_acs_tax_code_KEY | int (4) | NOT NULL | Primary key for this table.
code_year | int (4) | NOT NULL | Represents the year for which the mappings belong to
client_type | nvarchar (2) | NOT NULL | Represents the type of client
code | nvarchar (10) | NOT NULL | Corresponding Cch code for the acs tax code
description | nvarchar (100) | NOT NULL | Descroptio for the Cch Code
is_detail_enabled | bit (1) | NOT NULL | Specifies if the correponding code can be exported in detail format
factor | int (4) | NOT NULL | factor to be multiplied with the balance amount
record_format | nvarchar (6) | NOT NULL | Specifies the format of the record in which the data has to be written
acs_tax_code | nvarchar (10) | NOT NULL | Acs tax code

Primary key
Name | Columns | Description
PK_Cch_Tax_Code_Map_To_Acs_Tax_Code | cch_tax_code_map_to_acs_tax_code_KEY |
Unique constraints
Name | Columns | Description
UK_Cch_Tax_Code_Map_To_Acs_Tax_Code$code_year$client_type$acs_tax_code | code_year, client_type, acs_tax_code |