Table: dbo.Year_End_Close_Balance_Sheet_Account_Distribution
The table contains the accounts that had ballance sheet account amounts distributed to them during a year end close event.
Columns
NameTypeConstraintsDescription
gl_fiscal_year_KEYint (4)NOT NULLThe foreign key refering to the options used to close to a new year. Also the fiscal year that this distribution belongs to.
from__gl_account_KEYint (4)NOT NULLThe foreign key refering to the account from which the distribution occured.
to__gl_account_KEYint (4)NOT NULLThe foreign key refering to the account to which the distribution occured.
percentagedecimal (5, 4)NOT NULLThe percentage of the balance sheet account that was distributed.
year_end_close_balance_sheet_account_distribution_KEYint (4)NOT NULLPrimary key.
gl_account_segment_code_KEYint (4)The segment code key associated with GLAccount when closing by segments. Null when not closing by segments.
Primary key
NameColumnsDescription
PK_Year_End_Close_Balance_Sheet_Account_Distributionyear_end_close_balance_sheet_account_distribution_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Year_End_Close_Balance_Sheet_Account_Distribution__GL_Account__from__gl_account_KEYfrom__gl_account_KEYGL_Account (gl_account_KEY)
FK_Year_End_Close_Balance_Sheet_Account_Distribution__GL_Account__to__gl_account_KEYto__gl_account_KEYGL_Account (gl_account_KEY)
FK_Year_End_Close_Balance_Sheet_Account_Distribution__GL_Account_Segment_Code__gl_account_segment_code_KEYgl_account_segment_code_KEYGL_Account_Segment_Code (gl_account_segment_code_KEY)
FK_Year_End_Close_Balance_Sheet_Account_Distribution__Year_End_Close_Option__gl_fiscal_year_KEYgl_fiscal_year_KEYYear_End_Close_Option (gl_fiscal_year_KEY)

Schema diagram