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
NameTypeConstraintsDescription
gl_period_KEYint (4)NOT NULLA foreign key to the gl period table. This column will represent the gl_periods in which the payroll transactions will not post
Primary key
NameColumnsDescription
PK_Non_Posting_Payroll_Transaction_GL_Period$gl_period_KEYgl_period_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Non_Posting_Payroll_Transaction_GL_Period__GL_Period__gl_period_KEYgl_period_KEYGL_Period (gl_period_KEY)

Schema diagram