Table: dbo.Ultra_Tax_Staged_Tax_Code
This table is used to stage incoming Ultra Tax tax codes before they are merged into the global and client Ultra Tax tax codes.
Columns
NameTypeConstraintsDescription
ultra_tax_staged_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_Staged_Tax_Codeultra_tax_staged_tax_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Ultra_Tax_Staged_Tax_Code__GL_Account_Type__gl_account_type_KEYgl_account_type_KEYGL_Account_Type (gl_account_type_KEY)
FK_Ultra_Tax_Staged_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_Staged_Tax_Code__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEYultra_tax_entity_type_KEYUltra_Tax_Entity_Type (ultra_tax_entity_type_KEY)

Schema diagram