Table: dbo.Custom_Excel_Grid
This table will hold data for custom excel grid
Columns
NameTypeConstraintsDescription
trial_balance_grid_KEYint (4)NOT NULLPrimary key. Foreign key to Trial Balance Grid table
workpaper_KEYint (4)Foreign key to workpaper table
custom_excel_grid_guiduniqueidentifier (16)NOT NULLStores a guid for the custom excel grid
sheet_namenvarchar (62)NOT NULLName for excel sheet
page_orientationbit (1)NOT NULLLandscape or Portrait
include_inactivebit (1)NOT NULLBoolean that tells us whether we want to include inactive accounts
client_consolidation_grouping_type_KEYint (4)NOT NULLForeign key to client consolidation grouping type table
include_account_detailsbit (1)NOT NULLWhether or not to include account details for a tax code based custom Excel grid.
Primary key
NameColumnsDescription
PK_Custom_Excel_Grid$trial_balance_grid_KEYtrial_balance_grid_KEY
Unique constraints
NameColumnsDescription
UK_Custom_Excel_Grid$custom_excel_grid_guidcustom_excel_grid_guid
UK_Custom_Excel_Grid$workpaper_KEY$sheet_nameworkpaper_KEY, sheet_name
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Excel_Grid__Client_Consolidation_Grouping_Type__client_consolidation_grouping_type_KEYclient_consolidation_grouping_type_KEYClient_Consolidation_Grouping_Type (client_consolidation_grouping_type_KEY)
FK_Custom_Excel_Grid__Trial_Balance_Grid__trial_balance_grid_KEYtrial_balance_grid_KEYTrial_Balance_Grid (trial_balance_grid_KEY)
FK_Custom_Excel_Grid__Workpaper__workpaper_KEYworkpaper_KEYWorkpaper (workpaper_KEY)

Schema diagram