Table: dbo.Non_Posting_Payroll_Transaction_GL_Period
Payroll transactions will not post for periods stored in this table. When the client selects an effective period, if the post_payroll_transactions is set to true, every gl period from the effective period and beyond will be removed from this table. When the flag is set to false, every period from the effective period through the latest fiscal year will be added to this table. When new fiscal years are created the post_payroll_transactions flag will be used to determine whether or not to add the gl periods of the new fiscal year to this table. Payroll transactions with posting periods that are present in this table will not post to the general ledger.
Columns
Name | Type | Constraints | Description
gl_period_KEY | int (4) | NOT NULL | A foreign key to the gl period table. This column will represent the gl_periods in which the payroll transactions will not post

Primary key
Name | Columns | Description
PK_Non_Posting_Payroll_Transaction_GL_Period$gl_period_KEY | gl_period_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Non_Posting_Payroll_Transaction_GL_Period__GL_Period__gl_period_KEY | gl_period_KEY | GL_Period (gl_period_KEY) |