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 |