Table: dbo.Trial_Balance_Grid_Column
This table stores column information for trial balance data entry grid. Each entry in this table represents one column in grid. A grid can have variable number of columns
Columns
NameTypeConstraintsDescription
trial_balance_grid_column_KEYint (4)NOT NULLPrimary key.
trial_balance_grid_KEYint (4)NOT NULLThe foreign key to a trial balance data entry grid to which this column belongs
trial_balance_grid_column_namenvarchar (200)NOT NULLThe name to this column. it will be the column header appears in associated data entry grid
trial_balance_grid_column_type_KEYint (4)NOT NULLForeign key to the Trial Balance Grid Column Type.
sequence_numberint (4)NOT NULLSequence number that determines the order in which the columns display in a data entry grid
heading_onenvarchar (250)NOT NULLHeading One.
heading_twonvarchar (250)NOT NULLHeading Two.
Primary key
NameColumnsDescription
PK_Trial_Balance_Grid_Columntrial_balance_grid_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Trial_Balance_Grid_Column__Trial_Balance_Grid__trial_balance_grid_KEYtrial_balance_grid_KEYTrial_Balance_Grid (trial_balance_grid_KEY)
FK_Trial_Balance_Grid_Column__Trial_Balance_Grid_Column_Type__trial_balance_grid_column_type_KEYtrial_balance_grid_column_type_KEYTrial_Balance_Grid_Column_Type (trial_balance_grid_column_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Custom_Office_Grid_Column_Relation_Option__Trial_Balance_Grid_Column__column_one__trial_balance_grid_column_KEYcolumn_one__trial_balance_grid_column_KEYCustom_Office_Grid_Column_Relation_Option
FK_Custom_Office_Grid_Column_Relation_Option__Trial_Balance_Grid_Column__column_two__trial_balance_grid_column_KEYcolumn_two__trial_balance_grid_column_KEYCustom_Office_Grid_Column_Relation_Option
FK_Custom_Office_Grid_Column_Relation_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEYtrial_balance_grid_column_KEYCustom_Office_Grid_Column_Relation_Option
FK_Custom_Office_Grid_Column_Segment__Trial_Balance_Grid_Column__trial_balance_grid_column_KEYtrial_balance_grid_column_KEYCustom_Office_Grid_Column_Segment
FK_Trial_Balance_Grid_Column_Tickmark_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEYtrial_balance_grid_column_KEYTrial_Balance_Grid_Column_Tickmark_Option
FK_Trial_Balance_Grid_Column_Amount_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEYtrial_balance_grid_column_KEYTrial_Balance_Grid_Column_Amount_Option
FK_Trial_Balance_Grid_Column_Account_Grouping_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEYtrial_balance_grid_column_KEYTrial_Balance_Grid_Column_Account_Grouping_Option
FK_Trial_Balance_Grid_Column_Account_Number_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEYtrial_balance_grid_column_KEYTrial_Balance_Grid_Column_Account_Number_Option
FK_Trial_Balance_Grid_Column_Workpaper_Reference_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEYtrial_balance_grid_column_KEYTrial_Balance_Grid_Column_Workpaper_Reference_Option
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_Account_Tax_Code_Option

Schema diagram