Table: dbo.Trial_Balance_Grid
This table stores a number of Trial Balance Data Entry Grid for each client with write-up and/or trial balance functionality enabled
Columns
NameTypeConstraintsDescription
trial_balance_grid_KEYint (4)NOT NULLPrimary key.
client_KEYint (4)The associated client. the foreign key to client table
descriptionnvarchar (60)NOT NULLA description/name for the Trial Balance Data Entry Grid.
trial_balance_grid_type_KEYint (4)NOT NULLTrial Balance Grid Type key.
grid_account_selection_type_KEYint (4)NOT NULLThe selected account type to be displayed.
Primary key
NameColumnsDescription
PK_Trial_Balance_Gridtrial_balance_grid_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Trial_Balance_Grid__Client__client_KEYclient_KEYClient (client_KEY)
FK_Trial_Balance_Grid__Grid_Account_Selection_Type__grid_account_selection_type_KEYgrid_account_selection_type_KEYGrid_Account_Selection_Type (grid_account_selection_type_KEY)
FK_Trial_Balance_Grid__Trial_Balance_Grid_Type__trial_balance_grid_type_KEYtrial_balance_grid_type_KEYTrial_Balance_Grid_Type (trial_balance_grid_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Trial_Balance_Grid_Column__Trial_Balance_Grid__trial_balance_grid_KEYtrial_balance_grid_KEYTrial_Balance_Grid_Column
FK_Custom_Office_Grid_Column_Segment__Trial_Balance_Grid__trial_balance_grid_KEYtrial_balance_grid_KEYCustom_Office_Grid_Column_Segment
FK_Custom_Office_Account_Grouping__Trial_Balance_Grid__trial_balance_grid_KEYtrial_balance_grid_KEYCustom_Office_Account_Grouping
FK_Custom_Excel_Grid__Trial_Balance_Grid__trial_balance_grid_KEYtrial_balance_grid_KEYCustom_Excel_Grid

Schema diagram