Table: dbo.Trial_Balance_Grid_Column_Account_Tax_Code_Option
This table stores more column definition information for trial balance data entry grid columns. For Tax Code columns they need more specific information
Columns
NameTypeConstraintsDescription
trial_balance_grid_column_KEYint (4)NOT NULLPrimary key. it is also a foreign key to Trial_Balance_Grid_Column table
include_unit_columnbit (1)NOT NULLA boolean value to indicate whether a unit column will be included along with Tax_Code Column
Primary key
NameColumnsDescription
PK_Trial_Balance_Grid_Column_Account_Tax_Code_Option$trial_balance_grid_column_KEYtrial_balance_grid_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Trial_Balance_Grid_Column_Account_Tax_Code_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEYtrial_balance_grid_column_KEYTrial_Balance_Grid_Column (trial_balance_grid_column_KEY)

Schema diagram