Table: dbo.Ultra_Tax_Tax_Code
Ultra Tax tax code map file contents
Columns
NameTypeConstraintsDescription
ultra_tax_tax_code_KEYint (4)NOT NULLPrimary Key
code_yearint (4)NOT NULLYear this tax code is for
tax_codenvarchar (10)NOT NULLUltra Tax tax code
ultra_tax_entity_type_KEYint (4)NOT NULLEntity type this tax code is for
ultra_tax_category_type_KEYint (4)NOT NULLTax code category; Standard, Puerto Rico, M3A, M3B, M3C, ALL
descriptionnvarchar (100)NOT NULLUltra Tax tax code form line and description concatenated
gl_account_type_KEYint (4)Account type; A, L, E, R for entity types 1120, 1120S and 1065, otherwise NULL
Primary key
NameColumnsDescription
PK_Ultra_Tax_Tax_Codeultra_tax_tax_code_KEY
Unique constraints
NameColumnsDescription
UK_Ultra_Tax_Tax_Code$code_year$tax_code$ultra_tax_entity_type_KEYcode_year, tax_code, ultra_tax_entity_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Ultra_Tax_Tax_Code__GL_Account_Type__gl_account_type_KEYgl_account_type_KEYGL_Account_Type (gl_account_type_KEY)
FK_Ultra_Tax_Tax_Code__Ultra_Tax_Category_Type__ultra_tax_category_type_KEYultra_tax_category_type_KEYUltra_Tax_Category_Type (ultra_tax_category_type_KEY)
FK_Ultra_Tax_Tax_Code__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEYultra_tax_entity_type_KEYUltra_Tax_Entity_Type (ultra_tax_entity_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Code_N_Ultra_Tax_Tax_Code__Ultra_Tax_Tax_Code__ultra_tax_tax_code_KEYultra_tax_tax_code_KEYTax_Code_N_Ultra_Tax_Tax_Code

Schema diagram