| Table: dbo.Custom_Excel_Grid | |||
| This table will hold data for custom excel grid | |||
| Columns | |||
| Name | Type | Constraints | Description |
| trial_balance_grid_KEY | int (4) | NOT NULL | Primary key. Foreign key to Trial Balance Grid table |
| workpaper_KEY | int (4) | Foreign key to workpaper table | |
| custom_excel_grid_guid | uniqueidentifier (16) | NOT NULL | Stores a guid for the custom excel grid |
| sheet_name | nvarchar (62) | NOT NULL | Name for excel sheet |
| page_orientation | bit (1) | NOT NULL | Landscape or Portrait |
| include_inactive | bit (1) | NOT NULL | Boolean that tells us whether we want to include inactive accounts |
| client_consolidation_grouping_type_KEY | int (4) | NOT NULL | Foreign key to client consolidation grouping type table |
| include_account_details | bit (1) | NOT NULL | Whether or not to include account details for a tax code based custom Excel grid. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Custom_Excel_Grid$trial_balance_grid_KEY | trial_balance_grid_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Custom_Excel_Grid$custom_excel_grid_guid | custom_excel_grid_guid | ||
| UK_Custom_Excel_Grid$workpaper_KEY$sheet_name | workpaper_KEY, sheet_name | ||