PAYMASTR – Employee Payment Master

System
Payroll (PR)
Prefix
PYM
Primary key
COMPANY, EMPLOYEE, CHECK-ID
Fields
29
Updated by
58 programs
Referenced by
111 programs

PAYMASTR is the Employee Payment Master table in Lawson Payroll (prefix PYM). It is indexed by COMPANY, EMPLOYEE, CHECK-ID (PYMSET1); alternate indexes: PYMSET10, PYMSET11, PYMSET12, PYMSET2, PYMSET3, PYMSET4, PYMSET5, PYMSET6 and 3 more. It is related 1:1 to BANKACCT, BANKFILE, PRSYSTEM, CUCODES, DEPTCODE, EMPLOYEE, PR1099RHST, PRCHECK and 1 more and 1:M to EMPACHDIST, PRTRDADJ, PAYDEDUCTN, PRDISTRIB, TIMERECORD and PRTIME. It is updated by BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 and 50 more and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN150, BN232 and 103 more. The table has 29 fields, 12 indexes and 16 documented relations.

About PAYMASTR

This file is the driving file of the payroll cycle programs. PR140 (Earnings and Deductions Calculation) creates one system Employee Payment Master file record for all Employee Time Cards file records with like check groups. PR80.1 (Manual Payment) creates manual Employee Payment Master file records. The other PR80 series programs create other types of Employee Payment Master file records. PR160 (Payment Print) creates one Employee Payment file record for every Employee Payment Master file record produced by PR140 (Earnings and Deductions Calculation). When you close a payroll cycle, the system rolls the information from the Employee Payment Master file record into the Quarterly Wage file.

Fields (29)

Column = COBOL field name without the PYM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PYM-COMPANY PK
COMPANY		Numeric 4—BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
PYM-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
PYM-CHECK-ID PK
CHECK_ID		Numeric 12Contains the payment identification number. The value of this field is determined by the Last Check ID field in the HR Company and Process Levels file for the bank account on which this payment is drawn. This field, along with the bank account number, serves as the link to the Employee Payment Hours/Wages file, Employee Payment Deductions file, Employee ACH Distribution file, Employee Payment file, and Employee Payment Distribution file records associated with this payment.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +4 more
PYM-STATUS
STATUS		Numeric 1Contains the payment status. Records are created with a status of zero and are updated to a status of "9" by PR199 (Payroll Close).
  • 0 Created
  • 9 Closed
PR197, PR560, PR85.1
PYM-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5Contains the employee's home process level at the time of payment. The employee's home process level, at the time the payment is created, is moved to this field. If you change an employee's home process level on HR11.1 (Employee) or by a personnel action, all open payments are updated to reflect the new home process level.BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +35 more
PYM-DEPARTMENT
DEPARTMENT		Alpha 5Contains the employee's home department at the time of payment creation. The employee's home department, at the time of payment creation, is moved to this field. If you change the home department on HR11.1 (Employee) or by a personnel action, all open payments and processed time records are updated to reflect the new home department.BN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +35 more
PYM-BANK-CODE
BANK_CODE		Alpha 4Contains the bank code associated with the payment or adjustment.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
PYM-GROSS-PAY
GROSS_PAY		Signed 13.2Contains the gross payment amount.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +4 more
PYM-NET-PAY-AMT
NET_PAY_AMT		Signed 13.2Contains the net pay for the payment. Net Pay is gross pay reduced by all S (Employee Paid) deductions and increased by any A (Add-to-Net) deductions.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +4 more
PYM-DED-CYCLE-NBR
DED_CYCLE_NBR		Numeric 1Contains the deduction cycle that was used when processing this payment. The Benefits system uses this field to track the number of cycles left in a flex year for an employee. The number of cycles left is tracked in the Employee Flexible Dollars file record with the calculation taking place in PR199 (Payroll Close).BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR89.1 +1 more
PYM-CHECK-DATE
CHECK_DATE		Numeric 8 (yyyymmdd)Contains the payment date.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +5 more
PYM-PER-END-DATE
PER_END_DATE		Numeric 8 (yyyymmdd)Contains the payroll period ending date.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
PYM-CHECK-TYPE
CHECK_TYPE		Alpha 1Contains the payment type. When you void a payment in PR85.1 (Bank Account Reconciliation) the original payment type is changed to R (Reversal).
  • A ACH
  • J Adjustment
  • M Manual
  • P Partial ACH
  • R Reversal
  • S System
  • V Partial Void
  • G Gross Up
  • D Gross Up Direct Deposit
  • B Gross Up Both System and DD
  • C Contract
  • H Manual Direct Deposit
BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +5 more
PYM-CHECK-NET
CHECK_NET		Signed 13.2Contains the actual amount for which a payment is created. ACH amounts are not included.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +5 more
PYM-CHECK-NBR
CHECK_NBR		Numeric 8Contains the payment number. When an Employee Payment file record is created for a payment, the payment number is stored in this field. The system maintains history associated with the payment number even if the Employee Payment file record is deleted.PR197, PR560, PR80.1, PR80.4, PR86.1
PYM-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PR197, PR560, PR85.1
PYM-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.PR197, PR560, PR85.1
PYM-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
PYM-SECCLASS
SECCLASS		Derived——
PYM-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
PYM-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
PYM-PENS-SEQ-NBR
PENS_SEQ_NBR		Numeric 4—BN66.1, PR140, PR189, PR195, PR560, PR582, PR80.1, PR80.4 +3 more
PYM-NON-TXBL-REMUN
NON_TXBL_REMUN		Signed 13.2—BN66.1, PR140, PR189, PR195, PR560, PR80.1, PR80.4, PR82.1 +3 more
PYM-OT-PLAN-CODE
OT_PLAN_CODE		Alpha 4Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD).BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
PYM-PERIOD-NBR
PERIOD_NBR		Numeric 3For Future Development Use—
PYM-PAYROLL-YEAR
PAYROLL_YEAR		Numeric 4For Future Development UseBN66.1, PR140, PR189, PR195, PR582, PR80.1, PR80.4, PR82.1 +2 more
PYM-GM-ADJ-FLAG
GM_ADJ_FLAG		Numeric 1Indicates if adjustment records were created by GM170.
  • 0 Not Created by GM
  • 1 Created by GM
—
PYM-PRINT-RCPT
PRINT_RCPT		Alpha 1—BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
PYM-INTERFACE-FLAG
INTERFACE_FLAG		Numeric 1—PR197

Indexes (12)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PYMSET1COMPANY, EMPLOYEE, CHECK-IDPrimaryBN305, BN66.1, HR11.1, HR11.2, HR11.4, HR170, HR28.1, HR511 +22 more (list truncated in source)
PYMSET10COMPANY, PROCESS-LEVEL, EMPLOYEE, CHECK-IDKeyChange—
PYMSET11COMPANY, EMPLOYEE, CHECK-DATE*, CHECK-NBR*, CHECK-IDKeyChange, SubsetWhere CHECK-NBR != ZeroesPR50.2, ZP296
PYMSET12COMPANY, PAYROLL-YEAR, OT-PLAN-CODE, PER-END-DATE, EMPLOYEE, CHECK-IDPR141
PYMSET2COMPANY, BANK-CODE, PROCESS-LEVEL, CHECK-TYPE, EMPLOYEE, CHECK-IDKeyChange, SubsetWhere STATUS = ZeroesBN150, HR00.1, HR01.1, PR521, EXI2.1, EXI4.1, LP130, PR01.2 +22 more (list truncated in source)
PYMSET3COMPANY, INTERFACE-FLAG, PROCESS-LEVEL, EMPLOYEE, CHECK-IDKeyChange, SubsetWhere STATUS = 9—
PYMSET4COMPANY, EMPLOYEE, CHECK-DATE, CHECK-NBR, CHECK-IDKeyChangeBN100, BN101, BN102, BN103, BN105, BN145, BN232, BN245 +22 more (list truncated in source)
PYMSET5COMPANY, PROCESS-LEVEL, EMPLOYEE, CHECK-TYPE, CHECK-IDKeyChange, SubsetWhere STATUS = ZeroesBN305, BN66.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101 +22 more (list truncated in source)
PYMSET6COMPANY, DATE-STAMP, TIME-STAMP, PROCESS-LEVEL, EMPLOYEE, CHECK-TYPE, CHECK-IDKeyChangeBN66.1, PR139, PR140, PR189, PR195, PR197, PR80.1, PR80.4 +6 more
PYMSET7COMPANY, COUNTRY-CODE, PROCESS-LEVEL, EMPLOYEE, CHECK-TYPE, CHECK-IDKeyChangeBN66.1, HR00.1, HR01.1, PR139, PR140, PR189, PR195, PR418 +4 more
PYMSET8COMPANY, EMPLOYEE, PENS-SEQ-NBR, CHECK-IDKeyChange, SubsetWhere PENS-SEQ-NBR != ZeroesPR29.1, PR529, PR560, PR582, PR82.1
PYMSET9COMPANY, EMPLOYEE, PAYROLL-YEAR, OT-PLAN-CODE, PERIOD-NBR, CHECK-IDKeyChange, SubsetWhere COUNTRY-CODE = "UK" Or COUNTRY-CODE = "GB" Or COUNTRY-CODE = "IN"—

Relations

One to one (10) — lookups and parents

RelationTableRulesConditionField map
Bank AccountBANKACCTRequiredBFL-BNK-ACCT-NBR → BAC-BNK-ACCT-NBR (BACSET1)
Bank CodeBANKFILERequiredPYM-COMPANY → BFL-COMPANY, PYM-BANK-CODE → BFL-BANK-CODE
CompanyPRSYSTEMRequiredPYM-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CucodesCUCODESNot RequiredPYM-CURRENCY-CODE → CUC-CURRENCY-CODE
DepartmentDEPTCODERequiredWhen PYM-DEPARTMENT != SpacesPYM-COMPANY → DPT-COMPANY, PYM-PROCESS-LEVEL → DPT-PROCESS-LEVEL, PYM-DEPARTMENT → DPT-DEPARTMENT
EmployeeEMPLOYEERequiredPYM-COMPANY → EMP-COMPANY, PYM-EMPLOYEE → EMP-EMPLOYEE
Pr1099rhstPR1099RHSTNot RequiredPYM-COMPANY → PHR-COMPANY, PYM-EMPLOYEE → PHR-EMPLOYEE, PYM-CHECK-ID → PHR-CHECK-ID, PYM-PENS-SEQ-NBR → PHR-PENS-SEQ-NBR
PrcheckPRCHECKNot RequiredPYM-COMPANY → PCH-COMPANY, PYM-CHECK-ID → PCH-CHECK-ID
Process LevelPRSYSTEMRequiredPYM-COMPANY → PRS-COMPANY, PYM-PROCESS-LEVEL → PRS-PROCESS-LEVEL
PrpenpayPRPENPAYNot RequiredPYM-COMPANY → PNP-COMPANY, PYM-EMPLOYEE → PNP-EMPLOYEE, PYM-PENS-SEQ-NBR → PNP-PENS-SEQ-NBR

One to many (6) — child tables

RelationTableRulesConditionField map
Ach DistribsEMPACHDISTDelete CascadesPYM-COMPANY → ACD-COMPANY, PYM-EMPLOYEE → ACD-EMPLOYEE, PYM-CHECK-ID → ACD-CHECK-ID, → ACD-ACH-DIST-NBR
AdjustmentsPRTRDADJPYM-COMPANY → PTA-COMPANY, PYM-EMPLOYEE → PTA-EMPLOYEE, PYM-CHECK-ID → PTA-ORIG-CHECK-ID, → PTA-TIME-SEQ
DeductionsPAYDEDUCTNPYM-COMPANY → PYD-COMPANY, PYM-EMPLOYEE → PYD-EMPLOYEE, PYM-CHECK-ID → PYD-CHECK-ID, → PYD-DED-CODE, → PYD-EDM-SEQ-NBR, → PYD-REPORT-ENTITY, → PYD-BUS-NBR-GRP, → PYD-QC-ENT-NBR-GRP, → PYD-PROCESS-LEVEL, → PYD-WORK-STATE
PrdistribPRDISTRIBDelete CascadesPYM-COMPANY → PRD-COMPANY, PYM-EMPLOYEE → PRD-EMPLOYEE, PYM-CHECK-ID → PRD-CHECK-ID, → PRD-OBJ-ID
Time RecordsTIMERECORDPYM-COMPANY → TRD-COMPANY, PYM-EMPLOYEE → TRD-EMPLOYEE, PYM-CHECK-ID → TRD-CHECK-ID, → TRD-PAY-SUM-GRP, → TRD-TIME-SEQ
WagePRTIMEDelete CascadesPYM-COMPANY → PRT-COMPANY, PYM-EMPLOYEE → PRT-EMPLOYEE, PYM-CHECK-ID → PRT-CHECK-ID, → PRT-PAY-SUM-GRP, → PRT-TIME-SEQ

Programs

Updated by (58)

Referenced by (111)