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
Name | Type | Constraints | Description
trial_balance_grid_column_KEY | int (4) | NOT NULL | Primary key.
trial_balance_grid_KEY | int (4) | NOT NULL | The foreign key to a trial balance data entry grid to which this column belongs
trial_balance_grid_column_name | nvarchar (200) | NOT NULL | The name to this column. it will be the column header appears in associated data entry grid
trial_balance_grid_column_type_KEY | int (4) | NOT NULL | Foreign key to the Trial Balance Grid Column Type.
sequence_number | int (4) | NOT NULL | Sequence number that determines the order in which the columns display in a data entry grid
heading_one | nvarchar (250) | NOT NULL | Heading One.
heading_two | nvarchar (250) | NOT NULL | Heading Two.

Primary key
Name | Columns | Description
PK_Trial_Balance_Grid_Column | trial_balance_grid_column_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Trial_Balance_Grid_Column__Trial_Balance_Grid__trial_balance_grid_KEY | trial_balance_grid_KEY | Trial_Balance_Grid (trial_balance_grid_KEY) |
FK_Trial_Balance_Grid_Column__Trial_Balance_Grid_Column_Type__trial_balance_grid_column_type_KEY | trial_balance_grid_column_type_KEY | Trial_Balance_Grid_Column_Type (trial_balance_grid_column_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Custom_Office_Grid_Column_Relation_Option__Trial_Balance_Grid_Column__column_one__trial_balance_grid_column_KEY | column_one__trial_balance_grid_column_KEY | Custom_Office_Grid_Column_Relation_Option |
FK_Custom_Office_Grid_Column_Relation_Option__Trial_Balance_Grid_Column__column_two__trial_balance_grid_column_KEY | column_two__trial_balance_grid_column_KEY | Custom_Office_Grid_Column_Relation_Option |
FK_Custom_Office_Grid_Column_Relation_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEY | trial_balance_grid_column_KEY | Custom_Office_Grid_Column_Relation_Option |
FK_Custom_Office_Grid_Column_Segment__Trial_Balance_Grid_Column__trial_balance_grid_column_KEY | trial_balance_grid_column_KEY | Custom_Office_Grid_Column_Segment |
FK_Trial_Balance_Grid_Column_Tickmark_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEY | trial_balance_grid_column_KEY | Trial_Balance_Grid_Column_Tickmark_Option |
FK_Trial_Balance_Grid_Column_Amount_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEY | trial_balance_grid_column_KEY | Trial_Balance_Grid_Column_Amount_Option |
FK_Trial_Balance_Grid_Column_Account_Grouping_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEY | trial_balance_grid_column_KEY | Trial_Balance_Grid_Column_Account_Grouping_Option |
FK_Trial_Balance_Grid_Column_Account_Number_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEY | trial_balance_grid_column_KEY | Trial_Balance_Grid_Column_Account_Number_Option |
FK_Trial_Balance_Grid_Column_Workpaper_Reference_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEY | trial_balance_grid_column_KEY | Trial_Balance_Grid_Column_Workpaper_Reference_Option |
FK_Trial_Balance_Grid_Column_Account_Tax_Code_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEY | trial_balance_grid_column_KEY | Trial_Balance_Grid_Column_Account_Tax_Code_Option |