Table: dbo.Custom_Office_Account_Grouping | |||
This table will store all the grouping and grouping codes for the custom excel grid if the grid is grouped by account grouping | |||
Columns | |||
Name | Type | Constraints | Description |
custom_office_account_grouping_KEY | int (4) | NOT NULL | Primary key |
trial_balance_grid_KEY | int (4) | NOT NULL | Foreign key to custom excel grid table |
gl_account_grouping_KEY | int (4) | NOT NULL | Foreign key to the gl account grouping table |
gl_account_grouping_code_KEY | int (4) | NOT NULL | Foreign key to the gl account grouping code table |
include_subcode | bit (1) | NOT NULL | Boolean that tells us whether to include subcode for the given account grouping code |
include_accounts | bit (1) | NOT NULL | Boolean that tells us whether to include accounts for the given account grouping code |
sequence_number | int (4) | NOT NULL | To order the codes in a specific order |
Primary key | |||
Name | Columns | Description | |
PK_Custom_Office_Account_Grouping | custom_office_account_grouping_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Custom_Office_Account_Grouping$trial_balance_grid_KEY$gl_account_grouping_KEY$gl_account_grouping_code_KEY | trial_balance_grid_KEY, gl_account_grouping_KEY, gl_account_grouping_code_KEY |