Table: dbo.Trial_Balance_Grid_Column_Account_Grouping_Option
This table stores more column defintion information for trial balance data entry grid columns. For Account_Grouping columns they need more specific informaiton
Columns
NameTypeConstraintsDescription
trial_balance_grid_column_KEYint (4)NOT NULLPrimary key. it is also a foreign key to Trial_Balance_Grid_Column table
gl_account_grouping_KEYint (4)NOT NULLA foreign key to GL_Account_Grouping table
include_subcode_columnbit (1)NOT NULLA boolean value indicates if it is needed to include subcode column
Primary key
NameColumnsDescription
PK_Trial_Balance_Grid_Column_Account_Grouping_Option$trial_balance_grid_column_KEYtrial_balance_grid_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Trial_Balance_Grid_Column_Account_Grouping_Option__GL_Account_Grouping__gl_account_grouping_KEYgl_account_grouping_KEYGL_Account_Grouping (gl_account_grouping_KEY)
FK_Trial_Balance_Grid_Column_Account_Grouping_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEYtrial_balance_grid_column_KEYTrial_Balance_Grid_Column (trial_balance_grid_column_KEY)

Schema diagram