Table: dbo.GL_Account_Workpaper_Reference
This table contains the connection between a GL account and workpaper reference.
Columns
NameTypeConstraintsDescription
gl_account_workpaper_reference_KEYint (4)NOT NULLThe primary key.
gl_period_KEYint (4)NOT NULLThis points to a specific GL period.
gl_account_KEYint (4)NOT NULLThis points to a specific GL account.
workpaper_referencenvarchar (50)NOT NULLThe specific workpaper reference that belongs to a GL account.
workpaper_KEYint (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
NameColumnsDescription
PK_GL_Account_Workpaper_Referencegl_account_workpaper_reference_KEY
Unique constraints
NameColumnsDescription
UK_GL_Account_Workpaper_Reference$gl_period_KEY$gl_account_KEYgl_period_KEY, gl_account_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Account_Workpaper_Reference__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_GL_Account_Workpaper_Reference__GL_Period__gl_period_KEYgl_period_KEYGL_Period (gl_period_KEY)
FK_GL_Account_Workpaper_Reference__workpaper_KEYworkpaper_KEYWorkpaper (workpaper_KEY)

Schema diagram