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
Name | Type | Constraints | Description
gl_fiscal_year_KEY | int (4) | NOT NULL | The 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_KEY | int (4) | NOT NULL | The foreign key refering to the account from which the distribution occured.
to__gl_account_KEY | int (4) | NOT NULL | The foreign key refering to the account to which the distribution occured.
percentage | decimal (5, 4) | NOT NULL | The percentage of the balance sheet account that was distributed.
year_end_close_balance_sheet_account_distribution_KEY | int (4) | NOT NULL | Primary key.
gl_account_segment_code_KEY | int (4) |  | The segment code key associated with GLAccount when closing by segments. Null when not closing by segments.

Primary key
Name | Columns | Description
PK_Year_End_Close_Balance_Sheet_Account_Distribution | year_end_close_balance_sheet_account_distribution_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Year_End_Close_Balance_Sheet_Account_Distribution__GL_Account__from__gl_account_KEY | from__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Year_End_Close_Balance_Sheet_Account_Distribution__GL_Account__to__gl_account_KEY | to__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Year_End_Close_Balance_Sheet_Account_Distribution__GL_Account_Segment_Code__gl_account_segment_code_KEY | gl_account_segment_code_KEY | GL_Account_Segment_Code (gl_account_segment_code_KEY) |
FK_Year_End_Close_Balance_Sheet_Account_Distribution__Year_End_Close_Option__gl_fiscal_year_KEY | gl_fiscal_year_KEY | Year_End_Close_Option (gl_fiscal_year_KEY) |