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 |

Foreign keys
Name | Columns | Referenced table | Description
FK_Client_Consolidation_Option__Balance_Type__balance_type_KEY | balance_type_KEY | Balance_Type (balance_type_KEY) |
FK_Client_Consolidation_Option__Balance_Type__used_previously__balance_type_KEY | used_previously__balance_type_KEY | Balance_Type (balance_type_KEY) |
FK_Client_Consolidation_Option__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Client_Consolidation_Option__Client_Consolidation_Grouping_Type__client_consolidation_grouping_type_KEY | client_consolidation_grouping_type_KEY | Client_Consolidation_Grouping_Type (client_consolidation_grouping_type_KEY) |
FK_Client_Consolidation_Option__Client_Consolidation_Grouping_Type__used_previously__client_consolidation_grouping_type_KEY | used_previously__client_consolidation_grouping_type_KEY | Client_Consolidation_Grouping_Type (client_consolidation_grouping_type_KEY) |
FK_Client_Consolidation_Option__GL_Period__consolidation_period_end__gl_period_KEY | consolidation_period_end__gl_period_KEY | GL_Period (gl_period_KEY) |
FK_Client_Consolidation_Option__GL_Period__consolidation_period_start__gl_period_KEY | consolidation_period_start__gl_period_KEY | GL_Period (gl_period_KEY) |