| Table: dbo.Client_Consolidation_Option | |||
| This table will hold all the options for the consolidating master client | |||
| Columns | |||
| Name | Type | Constraints | Description |
| client_KEY | int (4) | NOT NULL | Primary key and foreign key to parent Client table |
| include_subcode_detail | bit (1) | NOT NULL | Flag indicating if we include the subcode detail. |
| retain_existing_accounts | bit (1) | NOT NULL | Flag indicating if we need to retain existing accoutns when we reconsolidate. |
| include_budget_balances | bit (1) | NOT NULL | Flag indicating if we include budget balances. |
| balance_type_KEY | int (4) | NOT NULL | The balance type we use for calculating the balance for the subsidiary and foreign key to parent Balance Type table. |
| client_consolidation_grouping_type_KEY | int (4) | NOT NULL | The grouping type we use for the account creation for each subsidiary. |
| gl_account_grouping_description | nvarchar (100) | NOT NULL | The grouping type description when we have the grouping type selected as account grouping. |
| consolidation_period_start__gl_period_KEY | int (4) | NOT NULL | Consolidation Period begin date key for the process. |
| consolidation_period_end__gl_period_KEY | int (4) | NOT NULL | Consolidation Period end date period key for the process. |
| used_previously__balance_type_KEY | int (4) | This foreign key indicates the balance type used during the last successful consolidation for this master client. | |
| used_previously__client_consolidation_grouping_type_KEY | int (4) | This foreign key indicates the grouping type used during the last successful consolidation for this master client. | |
| Primary key | |||
| Name | Columns | Description | |
| PK_Client_Consolidation_Option$client_KEY | client_KEY | ||