This table contains the connection between a GL account and workpaper reference. |
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. |