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 |