Table: dbo.Lacerte_Tax_Code_Map_To_Acs_Tax_Code
Lists the different types of Lacerte codes.
Columns
Name | Type | Constraints | Description
lacerte_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
pcode | nvarchar (10) | NOT NULL | Prior year code for the correponding code
dcode | nvarchar (10) | NOT NULL | Detail code for the corresponding code
description | nvarchar (100) | NOT NULL | Description of the Lacerte code
is_detail_enabled | bit (1) | NOT NULL | Specifies if the correponding code can be exported in detail format
input_sheet | int (4) | NOT NULL | Series number for the lacerte
factor | int (4) | NOT NULL | factor to be multiplied with the balance amount
acs_tax_code | nvarchar (10) | NOT NULL | Acs tax code

Primary key
Name | Columns | Description
PK_Lacerte_Tax_Code_Map_To_Acs_Tax_Code | lacerte_tax_code_map_to_acs_tax_code_KEY |
Unique constraints
Name | Columns | Description
UK_Lacerte_Tax_Code_Map_To_Acs_Tax_Code$code_year$client_type$acs_tax_code | code_year, client_type, acs_tax_code |