Table: dbo.GL_Account_Classification_N_Tax_Code
Connects a gl account grouping subcode to the tax code
Columns
NameTypeConstraintsDescription
gl_account_classification_n_tax_code_KEYint (4)NOT NULLPrimary Key.
classification__gl_account_grouping_subcode_KEYint (4)NOT NULLKey to the subcode_Code table
tax_code_KEYint (4)NOT NULLKey to the taxcode table
ultra_tax_entity_type_KEYint (4)NOT NULLEntity Key that determines the classification subcode and taxcode assigned to this entity in the tax code grid
Primary key
NameColumnsDescription
PK_GL_Account_Classification_N_Tax_Codegl_account_classification_n_tax_code_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Classification_N_Tax_Code$classification__gl_account_grouping_subcode_KEY$ultra_tax_entity_type_KEYclassification__gl_account_grouping_subcode_KEY, ultra_tax_entity_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Classification_N_Tax_Code__GL_Account_Grouping_Subcode__classification__gl_account_grouping_subcode_KEYclassification__gl_account_grouping_subcode_KEYGL_Account_Grouping_Subcode (gl_account_grouping_subcode_KEY)
FK_GL_Account_Classification_N_Tax_Code__Tax_Code__tax_code_KEYtax_code_KEYTax_Code (tax_code_KEY)
FK_GL_Account_Classification_N_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