PR514 – Employee Deduction Master Load
- System
- Payroll (PR)
- Type
- Batch program
- Updates
- 39 tables
- References
- 69 tables
PR514 (Employee Deduction Master Load) is a Lawson Payroll batch program. It updates ADDRDATA, APAPPROVAL, APAUDIT, APCOMMENTS, APCONTACT, APCPYVND, APHLDINV, APINVOICE and 31 more and references APACCRCODE, APAPIHIST, APAPPROVAL, APAUTHOR, APCOMMENTS, APCOMPANY, APCONTACT, APCPYVND and 61 more.
About PR514
Run Employee Deduction Master Load (PR514) to import non-benefit, non-tax employee deduction data from a non-Lawson system into PR14.1 (EmployeeDeduction) and PR26.1 (Employee Garnishment) in the Lawson Payroll system. **Processing Effect This program takes fields from a comma-separated value (CSV) file and updates the associated deduction files as if the deductions were added on PR14.1 or PR26.1. The program performs all the edits of PR14.1 and PR26.1. The program also updates declining balances, limit balances, ascending balances, and additional tax amounts. If the record has errors, an errormessage prints on the report. Use the Add function only for initial deduction creation. Use the Change function to update existing deduction data. Refer to the Human Resources Conversion Technical Guide for additional data regarding file layout.
Updated files (39)
| Table | Description | System |
|---|---|---|
| ADDRDATA | Address Code | IF |
| APAPPROVAL | Invoice Approval | AP |
| APAUDIT | Vendor Invoice Audit | AP |
| APCOMMENTS | Comments | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APHLDINV | Hold | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APVENADDR | AP Vendor Address | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENGROUP | Vendor Group | AP |
| APVENLOC | Vendor Location | AP |
| APVENMAST | Vendor Master Record | AP |
| APVENPAY | No description in the Lawson data dictionary | AP |
| C6EMDDMSTR | No description in the Lawson data dictionary | C6 |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CKPOINT | No description in the Lawson data dictionary | — |
| CUSTDESC | AR Group Customer | AR |
| EMDEDMASTR | Employee Deduction | PR |
| EMPLOYEE | Employee | HR |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| HRHISTORY | HR History | HR |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| PAYDEDUCTN | Employee Payment Deductions | PR |
| POPOVUF | No description in the Lawson data dictionary | PO |
| POVENDLOC | Vendor Location Master | PO |
| POVENDOR | PO Vendor Master | PO |
| PREMPGARN | Used to store information to identify a particular garnishment per employee per company. | PR |
| PRGARNRULE | The Garnishment Rules files contains garnishment rules by governing tax authority and category for wage formulas… | PR |
| PRREGPARM | No description in the Lawson data dictionary | PR |
| TERMS | Payment Terms Maintenance | TE |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
Referenced files (69)
| Table | Description | System |
|---|---|---|
| APACCRCODE | Invoice Accrual Code | AP |
| APAPIHIST | Vendor Invoice History | AP |
| APAPPROVAL | Invoice Approval | AP |
| APAUTHOR | Authority Code | AP |
| APCOMMENTS | Comments | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APDISCCODE | Discount Code | AP |
| APDISTHDR | Distribution Code Header | AP |
| APHLDINV | Hold | AP |
| APHOLDCODE | Hold Code | AP |
| APINCCODE | Income Code | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APPAYMENT | Invoice Payment | AP |
| APPROCGRP | Process Group | AP |
| APUSRFLDEF | AP User Field Definition | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENCLASS | Vendor Class | AP |
| APVNMXVAL | No description in the Lawson data dictionary | AP |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| DEDCODE | Deduction | PR |
| EEADVANCE | Employee Advance | AP |
| EEAPPROVAL | Expense Advance Approval Code | AP |
| EEEXPENSE | Employee Expense | AP |
| GLADDRESS | General Ledger Company Address | IF |
| GLCHART | General Ledger Chart | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| GLSYSTEM | General Ledger Company | IF |
| HRHISTORY | HR History | HR |
| HRSECLEV | Employee Security Level | HR |
| INSTCTRYCD | Intrastat Country Codes | TX |
| INSTREGN | Intrastat Region Code | TX |
| MAINVHAND | Invoice Handling Code | MA |
| MAMATCHTBL | Match Table | MA |
| MAMSGTOL | No description in the Lawson data dictionary | MA |
| MAMTCHRULE | Matching Rules | MA |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| ONETMDED | Payroll One-time Deduction | PR |
| PADICT | HR Systems Data Dictionary | HR |
| PASCRTY | Data Item Attribute Parameters | HR |
| PAYDEDUCTN | Employee Payment Deductions | PR |
| PLAN | PL Group Detail | BN |
| POAOCDTL | Add On Cost Detail | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POVAGRMTHD | Vendor Agreement | PO |
| PREMDEDHST | Employee Deduction History | PR |
| PRGARNRULX | No description in the Lawson data dictionary | PR |
| PRGARNTYPE | Contains the type of garnishments and categories to which they are linked. | PR |
| PROCUREGRP | Procurement Group | PO |
| PRPAYCODE | Pay Code | PR |
| PRSYSTEM | HR Company and Process Levels | HR |
| PRTAXAUTH | Tax Authority | PR |
| PRTAXLEVY | Payroll Tax Levy | PR |
| PRTAXLOC | No description in the Lawson data dictionary | PR |
| PRVENDOR | This file contains AP vendors defined for a deduction code and process level. | PR |
| PURCHORDER | Purchase Order Master | PO |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
Program calls
Invoked programs (12)
ACAC, ACTA, API4, HRLO, IFAC, IFCU, IFLU, IFOB, IFSG, IFUP, SLSE, SLSU