| 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 | |