Table: dbo.Tax_Code_N_Ultra_Tax_Tax_Code
Connects a client's tax code to the Ultra Tax tax code info for a specific year and entity type.
Columns
NameTypeConstraintsDescription
tax_code_n_ultra_tax_tax_code_KEYint (4)NOT NULLPrimary Key.
tax_code_KEYint (4)NOT NULLKey to the Tax_Code table
ultra_tax_tax_code_KEYint (4)NOT NULLKey to the Ultra_Tax_Tax_Code table
tax_subcode_descriptionnvarchar (100)NOT NULLUser entered descriptive text for the user entered custom tax code
Primary key
NameColumnsDescription
PK_Tax_Code_N_Ultra_Tax_Tax_Codetax_code_n_ultra_tax_tax_code_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Code_N_Ultra_Tax_Tax_Code$tax_code_KEY$ultra_tax_tax_code_KEYtax_code_KEY, ultra_tax_tax_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Code_N_Ultra_Tax_Tax_Code__Tax_Code__tax_code_KEYtax_code_KEYTax_Code (tax_code_KEY)
FK_Tax_Code_N_Ultra_Tax_Tax_Code__Ultra_Tax_Tax_Code__ultra_tax_tax_code_KEYultra_tax_tax_code_KEYUltra_Tax_Tax_Code (ultra_tax_tax_code_KEY)

Schema diagram