Table: dbo.GL_Account_Classification_N_Tax_Code_M3
Connects a gl account classification subcode to an M3-A tax code.
Columns
NameTypeConstraintsDescription
gl_account_classification_n_tax_code_M3_KEYint (4)NOT NULLPrimary Key.
tax_code_KEYint (4)NOT NULLKey to the Tax_Code table
classification__gl_account_grouping_subcode_KEYint (4)NOT NULLKey to the GL_Account_grouping subcode 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_Code_M3gl_account_classification_n_tax_code_M3_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Classification_N_Tax_Code_M3$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_M3__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_M3__Tax_Code__tax_code_KEYtax_code_KEYTax_Code (tax_code_KEY)
FK_GL_Account_Classification_N_Tax_Code_M3__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEYultra_tax_entity_type_KEYUltra_Tax_Entity_Type (ultra_tax_entity_type_KEY)

Schema diagram