Table: dbo.Custom_Office_Grid_Column_Relation_Option
This table stores custom Office workpaper relation option for columns that are relation type. This table is used for custom Excel workpapers only and does not apply to trial balance.
Columns
NameTypeConstraintsDescription
trial_balance_grid_column_KEYint (4)NOT NULLPrimary key. Foreign key to the trial balance grid column table
column_one__trial_balance_grid_column_KEYint (4)NOT NULLForeign key to trial balance grid column table
column_two__trial_balance_grid_column_KEYint (4)NOT NULLForeign key to trial balance grid column table
custom_office_grid_column_relation_operator_type_KEYint (4)NOT NULLForeign key to custom office grid column relation operator type table
Primary key
NameColumnsDescription
PK_Custom_Office_Grid_Column_Relation_Option$trial_balance_grid_column_KEYtrial_balance_grid_column_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Office_Grid_Column_Relation_Option__Custom_Office_Grid_Column_Relation_Operator_Type__custom_office_grid_column_relaticustom_office_grid_column_relation_operator_type_KEYCustom_Office_Grid_Column_Relation_Operator_Type (custom_office_grid_column_relation_operator_type_KEY)
FK_Custom_Office_Grid_Column_Relation_Option__Trial_Balance_Grid_Column__column_one__trial_balance_grid_column_KEYcolumn_one__trial_balance_grid_column_KEYTrial_Balance_Grid_Column (trial_balance_grid_column_KEY)
FK_Custom_Office_Grid_Column_Relation_Option__Trial_Balance_Grid_Column__column_two__trial_balance_grid_column_KEYcolumn_two__trial_balance_grid_column_KEYTrial_Balance_Grid_Column (trial_balance_grid_column_KEY)
FK_Custom_Office_Grid_Column_Relation_Option__Trial_Balance_Grid_Column__trial_balance_grid_column_KEYtrial_balance_grid_column_KEYTrial_Balance_Grid_Column (trial_balance_grid_column_KEY)

Schema diagram