Table: dbo.Client_Consolidation_Option
This table will hold all the options for the consolidating master client
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLPrimary key and foreign key to parent Client table
include_subcode_detailbit (1)NOT NULLFlag indicating if we include the subcode detail.
retain_existing_accountsbit (1)NOT NULLFlag indicating if we need to retain existing accoutns when we reconsolidate.
include_budget_balancesbit (1)NOT NULLFlag indicating if we include budget balances.
balance_type_KEYint (4)NOT NULLThe balance type we use for calculating the balance for the subsidiary and foreign key to parent Balance Type table.
client_consolidation_grouping_type_KEYint (4)NOT NULLThe grouping type we use for the account creation for each subsidiary.
gl_account_grouping_descriptionnvarchar (100)NOT NULLThe grouping type description when we have the grouping type selected as account grouping.
consolidation_period_start__gl_period_KEYint (4)NOT NULLConsolidation Period begin date key for the process.
consolidation_period_end__gl_period_KEYint (4)NOT NULLConsolidation Period end date period key for the process.
used_previously__balance_type_KEYint (4)This foreign key indicates the balance type used during the last successful consolidation for this master client.
used_previously__client_consolidation_grouping_type_KEYint (4)This foreign key indicates the grouping type used during the last successful consolidation for this master client.
Primary key
NameColumnsDescription
PK_Client_Consolidation_Option$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Consolidation_Option__Balance_Type__balance_type_KEYbalance_type_KEYBalance_Type (balance_type_KEY)
FK_Client_Consolidation_Option__Balance_Type__used_previously__balance_type_KEYused_previously__balance_type_KEYBalance_Type (balance_type_KEY)
FK_Client_Consolidation_Option__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_Consolidation_Option__Client_Consolidation_Grouping_Type__client_consolidation_grouping_type_KEYclient_consolidation_grouping_type_KEYClient_Consolidation_Grouping_Type (client_consolidation_grouping_type_KEY)
FK_Client_Consolidation_Option__Client_Consolidation_Grouping_Type__used_previously__client_consolidation_grouping_type_KEYused_previously__client_consolidation_grouping_type_KEYClient_Consolidation_Grouping_Type (client_consolidation_grouping_type_KEY)
FK_Client_Consolidation_Option__GL_Period__consolidation_period_end__gl_period_KEYconsolidation_period_end__gl_period_KEYGL_Period (gl_period_KEY)
FK_Client_Consolidation_Option__GL_Period__consolidation_period_start__gl_period_KEYconsolidation_period_start__gl_period_KEYGL_Period (gl_period_KEY)

Schema diagram