Table: dbo.Cch_Tax_Code_Map_To_Acs_Tax_Code
Lists the different types of Cch codes.
Columns
NameTypeConstraintsDescription
cch_tax_code_map_to_acs_tax_code_KEYint (4)NOT NULLPrimary key for this table.
code_yearint (4)NOT NULLRepresents the year for which the mappings belong to
client_typenvarchar (2)NOT NULLRepresents the type of client
codenvarchar (10)NOT NULLCorresponding Cch code for the acs tax code
descriptionnvarchar (100)NOT NULLDescroptio for the Cch Code
is_detail_enabledbit (1)NOT NULLSpecifies if the correponding code can be exported in detail format
factorint (4)NOT NULLfactor to be multiplied with the balance amount
record_formatnvarchar (6)NOT NULLSpecifies the format of the record in which the data has to be written
acs_tax_codenvarchar (10)NOT NULLAcs tax code
Primary key
NameColumnsDescription
PK_Cch_Tax_Code_Map_To_Acs_Tax_Codecch_tax_code_map_to_acs_tax_code_KEY
Unique constraints
NameColumnsDescription
UK_Cch_Tax_Code_Map_To_Acs_Tax_Code$code_year$client_type$acs_tax_codecode_year, client_type, acs_tax_code

Schema diagram