GP Tables

Payroll

22 tables in this module

Payroll tables store employee pay records, deductions, benefits, tax withholdings, and check history. These tables are critical for payroll reporting, W-2 generation, and labor cost analysis.

Table Description
APR_APR30000 APR_Accrual_History
APR_APR30300 APR Pay Run History
APR_BLM42100 Future Effective Payroll Benefit Setup
APR_BLM42101 Future Effective Payroll Benefit Setup (Backup)
APR_DIA30100 Deductions in Arrears History
DD00100 Direct Deposit Employee Master
DD00200 Direct Deposit Employee Account Master
DD10100 Direct Deposit Employee Deposits Work
DD10200 Direct Deposit ACH Copy
DD10300 Direct Deposit ACH Cross Reference
DD10400 Direct Deposit ACH Header
DD10500 Direct Deposit ACH Items
DD10600 Direct Deposit Prenotes Completed
DD10700 Direct Deposit Exceptions
DD30100 Direct Deposit Transaction History Header
DD30101 Direct Deposit Transaction History Detail
DD40100 Direct Deposit Setup
DD40200 Direct Deposit Check Messages Setup
DD40400 Direct Deposit ACH Header Setup
DD40500 Direct Deposit ACH Prenotes Setup
UPR00402 Payroll Post Dated Pay Code Master
UPR41400 Payroll Local Tax Setup