Table: dbo.GL_Account_Workpaper_Reference
This table contains the connection between a GL account and workpaper reference.
Columns
Name | Type | Constraints | Description
gl_account_workpaper_reference_KEY | int (4) | NOT NULL | The primary key.
gl_period_KEY | int (4) | NOT NULL | This points to a specific GL period.
gl_account_KEY | int (4) | NOT NULL | This points to a specific GL account.
workpaper_reference | nvarchar (50) | NOT NULL | The specific workpaper reference that belongs to a GL account.
workpaper_KEY | int (4) |  | Column that specifies the referenced workpaper key in the workpaper_reference column of the same table. ["BR"] Since, there can be workpapers with the same reference value in different binders.We use the key value to eliminate the redundancy.

Primary key
Name | Columns | Description
PK_GL_Account_Workpaper_Reference | gl_account_workpaper_reference_KEY |
Unique constraints
Name | Columns | Description
UK_GL_Account_Workpaper_Reference$gl_period_KEY$gl_account_KEY | gl_period_KEY, gl_account_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_GL_Account_Workpaper_Reference__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) |
FK_GL_Account_Workpaper_Reference__GL_Period__gl_period_KEY | gl_period_KEY | GL_Period (gl_period_KEY) |
FK_GL_Account_Workpaper_Reference__workpaper_KEY | workpaper_KEY | Workpaper (workpaper_KEY) |