Table: dbo.GL_Fiscal_Year | |||
Columns | |||
Name | Type | Constraints | Description |
gl_fiscal_year_KEY | int (4) | NOT NULL | Primary key |
client_KEY | int (4) | NOT NULL | The foreign key to the client table |
start_date | smalldatetime (4) | NOT NULL | The start date of the fiscal year |
end_date | smalldatetime (4) | NOT NULL | The end date of the fiscal year |
gl_period_count | int (4) | NOT NULL | The number of periods in the fiscal year. |
gl_period_type_KEY | int (4) | NOT NULL | The General Ledger period frequency type of the fiscal year. |
Primary key | |||
Name | Columns | Description | |
PK_GL_Fiscal_Year | gl_fiscal_year_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_GL_Fiscal_Year__Client__client_KEY | client_KEY | Client (client_KEY) | |
FK_GL_Fiscal_Year__GL_Period_Type__gl_period_type_KEY | gl_period_type_KEY | GL_Period_Type (gl_period_type_KEY) |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_GL_Period__GL_Fiscal_Year__gl_fiscal_year_KEY | gl_fiscal_year_KEY | GL_Period | |
FK_Year_End_Close_Option__GL_Fiscal_Year__gl_fiscal_year_KEY | gl_fiscal_year_KEY | Year_End_Close_Option |