Table: dbo.Trial_Balance_Grid_Column_Account_Number_Option
This table stores more column defintion information for trial balance data entry grid columns. For Account Number columns they need more specifical informaiton
Columns
NameTypeConstraintsDescription
trial_balance_grid_column_KEYint (4)NOT NULLPrimary key. it is also a foreign key to Trial_Balance_Grid_Column table
display_core_accounts_onlybit (1)NOT NULLA boolean value to indicate whether this column should display core accounts only
Primary key
NameColumnsDescription
PK_Trial_Balance_Grid_Column_Account_Number_Option$trial_balance_grid_column_KEYtrial_balance_grid_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Trial_Balance_Grid_Column_Account_Number_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEYtrial_balance_grid_column_KEYTrial_Balance_Grid_Column (trial_balance_grid_column_KEY)

Schema diagram