PRDISTRIB – Employee Payment Distribution

System: Payroll (PR)
Prefix: PRD
Primary key: COMPANY, EMPLOYEE, CHECK-ID, OBJ-ID
Fields: 53
Updated by: 10 programs
Referenced by: 9 programs

PRDISTRIB is the Employee Payment Distribution table in Lawson Payroll (prefix PRD). It is indexed by COMPANY, EMPLOYEE, CHECK-ID, OBJ-ID (PRDSET1); alternate indexes: PRDSET2, PRDSET3, PRDSET4, PRDSET5, PRDSET6, PRDSET7 and PRDSET8. It is related 1:1 to ACACCTCAT, ACACTIVITY, ACTRANS, PRSYSTEM, DEDCODE, DEPTCODE, GLSYSTEM, GLMASTER and 8 more and 1:M to PAPOSITION and SLTRANS. It is updated by PA82.1, PR197, PR198, PR295, PR300, PR582, PR70.1, PR82.1 and 2 more and referenced by HR00.1, HR01.1, HR170, HR70.1, PA495, PR131, PR195, PR285 and 1 more. The table has 53 fields, 8 indexes and 20 documented relations.

About PRDISTRIB

This file tracks the general ledger account information in more detail than the GL Transaction File because it creates the account distributions for each employee payment, whereas the GL Transaction File creates records by account for all payments in a cycle. Creation of records in this file is optional based on the selection you make in HR00.1 (Company). The system creates two kinds of payroll distribution records, company distributions and employee distributions. Company distributions include one company clearing account record for each general ledger date (even if the amount is zero), and an error suspense account record. The system creates employee distributions for employee deductions, company deductions, and pay. PR199 (Payroll Close) is the primary program that updates this file.

Fields (53)

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

Field / column	Type	Description & values	Updated by
`PRD-COMPANY` PK COMPANY	Numeric 4	—	PR197, PR582, PR70.1, PR82.1, PR82.2, PR85.1
`PRD-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains 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.	PR197, PR582, PR70.1, PR82.1, PR82.2, PR85.1
`PRD-CHECK-ID` PK CHECK_ID	Numeric 12	Contains the payment identification number. When the system creates a distribution, the Employee Payment Master payment identification number moves to this field to serve as the link between the Employee Payment Master file record and the Employee Payment Distribution file record.	PR197, PR582, PR70.1, PR82.1, PR82.2, PR85.1
`PRD-OBJ-ID` PK OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	PR197, PR582, PR70.1, PR82.1, PR82.2, PR85.1
`PRD-STATUS` STATUS	Numeric 1	Contains the distribution status. The system creates adjustments and reversals with a status of zero. When you run PR199 (Payroll Close), the status changes to nine. Records created by PR199 are created with a status of nine. `0` Open `1` Updated `9` Closed	PR197, PR198, PR85.1
`PRD-PROCESS-LEVEL` PROCESS_LEVEL	Alpha 5	Contains the process level to which the amount is posted.	PR197, PR582, PR82.1, PR82.2, PR85.1
`PRD-DEPARTMENT` DEPARTMENT	Alpha 5	Contains the department to which the amount is posted.	PR197, PR582, PR82.1, PR82.2, PR85.1
`PRD-RECORD-TYPE` RECORD_TYPE	Alpha 1	This field identifies the type of record defined. Valid values are: `S` Summary `D` Detail `1` Error suspense `A` Deduction Accrual `C` Cash Accrual `E` Expense Accrual	PR197, PR582, PR82.1, PR82.2, PR85.1
`PRD-CHECK-TYPE` CHECK_TYPE	Alpha 1	Contains the payment type. `A` ACH `P` Partial ACH `S` System `J` Adjustment `R` Void Reversal `M` Manual `C` Contract	PR197, PR582, PR70.1, PR82.1, PR82.2, PR85.1
`PRD-DST-ACCT-UNIT` DST_ACCT_UNIT	Alpha 15	Contains the general ledger accounting unit to which the amount is posted.	PR197, PR582, PR70.1, PR82.1, PR82.2, PR85.1
`PRD-DST-ACCOUNT` DST_ACCOUNT	Numeric 6	Contains the general ledger account to which the amount is posted.	PR197, PR582, PR70.1, PR82.1, PR82.2, PR85.1
`PRD-DST-SUB-ACCT` DST_SUB_ACCT	Numeric 4	Contains the general ledger subaccount to which the amount is posted.	PR197, PR582, PR70.1, PR82.1, PR82.2, PR85.1
`PRD-DIST-COMPANY` DIST_COMPANY	Numeric 4	Contains the company number to which a transaction is posted. A valid intercompany relationship must be defined in the General Ledger system.	PR197, PR582, PR70.1, PR82.1, PR82.2, PR85.1
`PRD-PCD-SEQ-NBR` PCD_SEQ_NBR	Numeric 8	Contains the sequence number for the distribution relative to the pay code.	PR197, PR582, PR82.1, PR82.2, PR85.1
`PRD-DED-CODE` DED_CODE	Alpha 4	Contains the deduction associated with the distribution. The system uses this field to identify employee deduction distributions and company-paid deduction distributions.	PR197, PR582, PR82.1, PR82.2, PR85.1
`PRD-HOURS` HOURS	Signed 7.2	Contains the hours associated with the distribution.	PR197, PR582, PR82.1, PR82.2, PR85.1
`PRD-DIST-AMT` DIST_AMT	Signed 13.2	Contains the amount to be posted.	PR197, PR582, PR82.1, PR82.2, PR85.1
`PRD-GL-DATE` GL_DATE	Numeric 8 (yyyymmdd)	Contains the general ledger posting date.	PR197, PR582, PR82.1, PR82.2, PR85.1
`PRD-JOB-CODE` JOB_CODE	Alpha 9	Contains the user-defined job code.	PR197, PR582, PR82.1, PR82.2, PR85.1
`PRD-RUN-DATE` RUN_DATE	Numeric 8 (yyyymmdd)	Contains the date the transaction is posted to the general ledger.	PR197, PR198
`PRD-RUN-TIME` RUN_TIME	Numeric 6 (hhmmss)	Contains the time the transaction is posted to the general ledger.	PR197, PR198
`PRD-ACTIVITY` ACTIVITY	Alpha 15	Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	PR197, PR582, PR82.1, PR82.2, PR85.1
`PRD-GLT-OBJ-ID` GLT_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	PR197, PR198, PR82.1, PR85.1
`PRD-ATN-OBJ-ID` ATN_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	PR197, PR198, PR582, PR82.1
`PRD-POSITION` POSITION	Alpha 12	Contains the user-defined code that represents a position in the company.	PR197, PR582, PR82.1, PR82.2, PR85.1
`PRD-ACCT-CATEGORY` ACCT_CATEGORY	Alpha 5	Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity Management system. All transactions are posted to an account category within an activity. You can assign a specific General Ledger account or range of accounts (company, accounting unit, account, and subaccount) that make up the transactions posted to an account category using AC07.1 (Account Assignment). Period-to-date, year-to-date, and life-to-date balances are maintained by account category for activities. Account categories must be assigned to activities before you do any budgeting or transaction processing. Valid account category types are: cost revenue accrual pass thru	PR197, PR582, PR82.1, PR82.2, PR85.1
`PRD-FULL-ACCT-1` FULL_ACCT_1	Derived	—	—
`PRD-FULL-ACCT-2` FULL_ACCT_2	Derived	—	—
`PRD-FULL-ACCT` FULL_ACCT	Derived	—	—
`PRD-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	This field contains the company base currency code established in Company (GL10.1 ).	PR197, PR582, PR82.1, PR85.1
`PRD-CURR-ND` CURR_ND	Numeric 1	The number of decimals assigned to a particular account as determined by the account currency.	PR197, PR582, PR82.1, PR85.1
`PRD-ERROR-TYPE` ERROR_TYPE	Numeric 1	— `1` Currency Error Exists `0` No Error Exists	PR197, PR70.1, PR85.1
`PRD-CO-CURR-CD` CO_CURR_CD	Alpha 5	—	PR197, PR582, PR70.1, PR82.1, PR85.1
`PRD-DST-CO-CURR-CD` DST_CO_CURR_CD	Alpha 5	—	PR197, PR582, PR70.1, PR82.1, PR85.1
`PRD-CO-EXCH-RATE` CO_EXCH_RATE	Signed 14.7	—	PR197, PR582, PR70.1, PR82.1, PR85.1
`PRD-DIST-EXCH-RATE` DIST_EXCH_RATE	Signed 14.7	—	PR197, PR582, PR70.1, PR82.1, PR85.1
`PRD-MSG-NBR` MSG_NBR	Numeric 3 Occurs 10 Times ×10	—	PR197, PR582, PR70.1, PR82.1, PR85.1
`PRD-HM-PROC-LEVEL` HM_PROC_LEVEL	Alpha 5	—	PR197, PR582, PR70.1, PR82.1, PR82.2, PR85.1
`PRD-ATTEND-CODE` ATTEND_CODE	Alpha 2	A user-defined alphanumeric code that represents a reason for an employee's absence or hours worked. Examples of attendance codes are, sick, vacation, overtime, on the job injury, snow day, tardy, left early, and so on. Validated in the Attendance Code file.	PR197
`PRD-AC-UPDATED` AC_UPDATED	Alpha 1	—	PR197, PR582, PR82.1, PR85.1
`PRD-GARN-OBJ-ID` GARN_OBJ_ID	Numeric 12	—	PR197, PR582, PR82.1, PR85.1
`PRD-SEGMENT-SEQ` SEGMENT_SEQ	Numeric 12	—	PR197, PR582, PR82.1, PR85.1
`PRD-TR-DATE` TR_DATE	Numeric 8 (yyyymmdd)	—	PR197, PR582, PR82.1, PR85.1
`PRD-PER-END-DATE` PER_END_DATE	Numeric 8 (yyyymmdd)	Identifies period end date in distribution record; used during PR198 to relieve salary encumbrance commitments for pay period (updated from TIMERECORD.PER-END-DATE).	PR197, PR82.1
`PRD-PAY-UNITS` PAY_UNITS	Signed 7.2	—	PR197, PR82.1, PR82.2
`PRD-UNIT-MEASURE` UNIT_MEASURE	Alpha 12	—	PR197, PR82.1, PR82.2
`PRD-OT-PLAN-CODE` OT_PLAN_CODE	Alpha 4	Identifies pay plan in effect for employee when PRDISTRIB record was created from PR197 (PRPRD).	PR197
`PRD-GM-ADJ-TYPE` GM_ADJ_TYPE	Alpha 1	Identifies labor cost transfer adjustment type for PRDISTRIB adjustment records created by GM170. `R` Reversing Entry `A` Adjusting Entry	—
`PRD-GMI-OBJ-ID-1` GMI_OBJ_ID_1	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	—
`PRD-GMI-OBJ-ID-2` GMI_OBJ_ID_2	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	—
`PRD-GML-OBJ-ID` GML_OBJ_ID	Numeric 12	This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.	PR197
`PRD-EXP-RPT-NBR` EXP_RPT_NBR	Alpha 22	—	PR197
`PRD-REC-TYPE` REC_TYPE	Numeric 4	—	PR197

Indexes (8)

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

Index	Keys	Flags	Condition	Used in
`PRDSET1`	`COMPANY`, `EMPLOYEE`, `CHECK-ID`, `OBJ-ID`	Primary		PA495, PR131, PR195, PR197, PR198, PR295, PR582, PR70.1 +3 more
`PRDSET2`	`COMPANY`, `EMPLOYEE`, `GL-DATE`, `CHECK-ID`, `OBJ-ID`	KeyChange		HR170, HR70.1, PR300
`PRDSET3`	`DIST-COMPANY`, `GLT-OBJ-ID`, `DST-ACCT-UNIT`, `DST-ACCOUNT`, `DST-SUB-ACCT`, `OBJ-ID`	KeyChange		—
`PRDSET4`	`COMPANY`, `STATUS`, `ERROR-TYPE`, `HM-PROC-LEVEL`, `DIST-COMPANY`, `DST-ACCT-UNIT`, `DST-ACCOUNT`, `DST-SUB-ACCT`, `GL-DATE`, `EMPLOYEE`, `CHECK-ID`, `OBJ-ID`	KeyChange		PR198, PR70.1
`PRDSET5`	`COMPANY`, `ACTIVITY`, `ATN-OBJ-ID`, `EMPLOYEE`, `OBJ-ID`	KeyChange, Subset	Where ACTIVITY != Spaces	PR285, PR55.1
`PRDSET6`	`COMPANY`, `PROCESS-LEVEL`, `EMPLOYEE`, `GL-DATE`, `CHECK-ID`, `OBJ-ID`	KeyChange, Subset	Where STATUS = 9	HR00.1, HR01.1, PA82.1, PR198, PR295
`PRDSET7`	`COMPANY`, `POSITION`, `GL-DATE`, `EMPLOYEE`, `CHECK-ID`, `OBJ-ID`	KeyChange, Subset	Where POSITION != Spaces	PA82.1
`PRDSET8`	`COMPANY`, `HM-PROC-LEVEL`, `EMPLOYEE`, `CHECK-ID`, `OBJ-ID`	KeyChange		—

Relations

One to one (18) — lookups and parents

Relation	Table	Rules	Condition	Field map
Acct Category	ACACCTCAT	Required	When PRD-ACCT-CATEGORY != Spaces	`PRD-ACCT-CATEGORY` → `AAX-ACCT-CATEGORY`
Activity	ACACTIVITY	Required	When PRD-ACTIVITY != Spaces	`PRD-ACTIVITY` → `ACV-ACTIVITY`
Actrans	ACTRANS	Not Required		`PRD-ATN-OBJ-ID` → `ATN-OBJ-ID`
Company	PRSYSTEM	Required		`PRD-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Ded Code	DEDCODE	Required	When PRD-DED-CODE != Spaces	`PRD-COMPANY` → `DDC-COMPANY`, `PRD-DED-CODE` → `DDC-DED-CODE`
Department	DEPTCODE	Required	When PRD-DEPARTMENT != Spaces	`PRD-COMPANY` → `DPT-COMPANY`, `PRD-PROCESS-LEVEL` → `DPT-PROCESS-LEVEL`, `PRD-DEPARTMENT` → `DPT-DEPARTMENT`
Dist Company	GLSYSTEM	Required	When PRD-DIST-COMPANY != Zeroes	`PRD-DIST-COMPANY` → `GLS-COMPANY`
Dst Account	GLMASTER	Required		`PRD-DIST-COMPANY` → `GLM-COMPANY`, `PRD-DST-ACCT-UNIT` → `GLM-ACCT-UNIT`, `PRD-DST-ACCOUNT` → `GLM-ACCOUNT`, `PRD-DST-SUB-ACCT` → `GLM-SUB-ACCOUNT`
Employee	EMPLOYEE	Required	When PRD-EMPLOYEE != Zeroes	`PRD-COMPANY` → `EMP-COMPANY`, `PRD-EMPLOYEE` → `EMP-EMPLOYEE`
Glnames	GLNAMES	Required		`PRD-DIST-COMPANY` → `GLN-COMPANY`, `PRD-DST-ACCT-UNIT` → `GLN-ACCT-UNIT`
Gltrans	GLTRANS	Required	When PRD-GLT-OBJ-ID != Zeroes	`PRD-GLT-OBJ-ID` → `GLT-OBJ-ID`
Gmlabdist	GMLABDIST	Not Required		`PRD-GML-OBJ-ID` → `GML-OBJ-ID`
Gmretdist1	GMRETDIST	Not Required		`PRD-GMI-OBJ-ID-1` → `GMI-OBJ-ID`
Gmretdist2	GMRETDIST	Not Required		`PRD-GMI-OBJ-ID-2` → `GMI-OBJ-ID`
Job Code	JOBCODE	Required	When PRD-JOB-CODE != Spaces	`PRD-COMPANY` → `JBC-COMPANY`, `PRD-JOB-CODE` → `JBC-JOB-CODE`
Pay Code	PRPAYCODE	Required	When PRD-PCD-SEQ-NBR != Zeroes	`PRD-COMPANY` → `PCD-COMPANY`, `PRD-PCD-SEQ-NBR` → `PCD-SEQ-NBR`
Paymastr	PAYMASTR	Required		`PRD-COMPANY` → `PYM-COMPANY`, `PRD-EMPLOYEE` → `PYM-EMPLOYEE`, `PRD-CHECK-ID` → `PYM-CHECK-ID`
Process Level	PRSYSTEM	Required		`PRD-COMPANY` → `PRS-COMPANY`, `PRD-PROCESS-LEVEL` → `PRS-PROCESS-LEVEL`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Position	PAPOSITION		Valid When PRD-POSITION != Spaces	`PRD-COMPANY` → `POS-COMPANY`, `PRD-POSITION` → `POS-POSITION`, → `POS-EFFECT-DATE`
Sltrans	SLTRANS			`PRD-GLT-OBJ-ID` → `SLT-GLT-OBJ-ID`, → `SLT-OBJ-ID`

Programs

Updated by (10)

PA82.1 Salary Encumbrance Inquiry
PR197 Payroll Close
PR198 General Ledger Posting
PR295 Distribution History Report
PR300 History Purge
PR582 Mass Adjustment Load
PR70.1 Payroll GL Distribution - Currency Errors
PR82.1 Adjustment
PR82.2 Adjustment Distributions
PR85.1 Bank Account Reconciliation

Referenced by (9)

HR00.1 Company
HR01.1 Process Level
HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
PA495 IPEDS Report
PR131 Retroactive Pay Calculation
PR195 Accrual Program
PR285 Payroll Activity Report
PR55.1 Activity Inquiry