Table: dbo.Lacerte_Tax_Code_Map_To_Acs_Tax_Code
Lists the different types of Lacerte codes.
Columns
NameTypeConstraintsDescription
lacerte_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
pcodenvarchar (10)NOT NULLPrior year code for the correponding code
dcodenvarchar (10)NOT NULLDetail code for the corresponding code
descriptionnvarchar (100)NOT NULLDescription of the Lacerte code
is_detail_enabledbit (1)NOT NULLSpecifies if the correponding code can be exported in detail format
input_sheetint (4)NOT NULLSeries number for the lacerte
factorint (4)NOT NULLfactor to be multiplied with the balance amount
acs_tax_codenvarchar (10)NOT NULLAcs tax code
Primary key
NameColumnsDescription
PK_Lacerte_Tax_Code_Map_To_Acs_Tax_Codelacerte_tax_code_map_to_acs_tax_code_KEY
Unique constraints
NameColumnsDescription
UK_Lacerte_Tax_Code_Map_To_Acs_Tax_Code$code_year$client_type$acs_tax_codecode_year, client_type, acs_tax_code

Schema diagram