Table: dbo.Custom_Office_Grid_Column_Segment
This table stores gl account segment and gl account segment code keys for a custom office grid column. This table is used for custom Excel workpapers only and does not apply to trial balance.
Columns
NameTypeConstraintsDescription
custom_office_grid_column_segment_KEYint (4)NOT NULLPrimary key
trial_balance_grid_column_KEYint (4)Foreign key to the trial balance grid column table
trial_balance_grid_KEYint (4)Stores the trial balance gird key when the segment selection is for the grid and not for the column.
gl_account_segment_selectionnvarchar (-1)NOT NULLThis column saves the segment selection from the segment dialog and stores it as a string
Primary key
NameColumnsDescription
PK_Custom_Office_Grid_Column_Segmentcustom_office_grid_column_segment_KEY
Unique constraints
NameColumnsDescription
UK_Custom_Office_Grid_Column_Segment$trial_balance_grid_column_KEY$trial_balance_grid_KEYtrial_balance_grid_column_KEY, trial_balance_grid_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Office_Grid_Column_Segment__Trial_Balance_Grid__trial_balance_grid_KEYtrial_balance_grid_KEYTrial_Balance_Grid (trial_balance_grid_KEY)
FK_Custom_Office_Grid_Column_Segment__Trial_Balance_Grid_Column__trial_balance_grid_column_KEYtrial_balance_grid_column_KEYTrial_Balance_Grid_Column (trial_balance_grid_column_KEY)

Schema diagram