Table: dbo.Tax_Code
Complete set of Ultra Tax and Custom Tax codes for a client
Columns
NameTypeConstraintsDescription
tax_code_KEYint (4)NOT NULLPrimary Key
client_KEYint (4)Client these tax codes are for. Null value indicates a global template used when creating a new client
tax_codenvarchar (10)NOT NULLUltra Tax tax code
tax_subcodenvarchar (4)NOT NULLUser entered custom tax code
tax_code_guiduniqueidentifier (16)NOT NULLA unique GUID key for this row.
Primary key
NameColumnsDescription
PK_Tax_Codetax_code_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Code$client_KEY$tax_code$tax_subcodeclient_KEY, tax_code, tax_subcode
UK_Tax_Code$tax_code_guidtax_code_guid
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Code__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Code_N_Ultra_Tax_Tax_Code__Tax_Code__tax_code_KEYtax_code_KEYTax_Code_N_Ultra_Tax_Tax_Code
FK_GL_Account_Classification_N_Tax_Code__Tax_Code__tax_code_KEYtax_code_KEYGL_Account_Classification_N_Tax_Code
FK_GL_Account_Classification_N_Tax_Code_M3__Tax_Code__tax_code_KEYtax_code_KEYGL_Account_Classification_N_Tax_Code_M3
FK_Tax_Code_N_GL_Account__Tax_Code__tax_code_KEYtax_code_KEYTax_Code_N_GL_Account
FK_Tax_Code_M3_N_GL_Account__Tax_Code__tax_code_KEYtax_code_KEYTax_Code_M3_N_GL_Account
FK_Tax_Reconciliation_N_Journal_Entry_Distribution__Tax_Code__tax_code_KEYtax_code_KEYTax_Reconciliation_N_Journal_Entry_Distribution

Schema diagram