Lawson - Lawson Software Technical Library - Data File Text for PRDISTRIB

PRDISTRIB

Employee Payment Distribution

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.

REFERENCED BY

PR295 PR285 PA82.1

UPDATED BY

HR00.1 HR01.1 HR170 HR70.1 PA495 PR131

PR195 PR197 PR198 PR300 PR55.1 PR582

PR70.1 PR82.1 PR82.2 PR85.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY

PRD-COMPANY
Element: Company Hr Numeric 4

PR197 PR582

PR70.1 PR82.1

PR82.2 PR85.1

PRD-EMPLOYEE
Element: 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
Element: 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
Element: 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
Element: 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
Element: Process Lev Hr Alpha 5
Contains the process level to which the amount is posted.

PR197 PR582

PR82.1 PR82.2

PR85.1

PRD-DEPARTMENT
Element: Department Alpha 5
Contains the department to which the amount is posted.

PR197 PR582

PR82.1 PR82.2

PR85.1

PRD-RECORD-TYPE
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Pcd Seq Nbr Numeric 4
Contains the sequence number for the distribution relative to the pay code.

PR197 PR582

PR82.1 PR82.2

PR85.1

PRD-DED-CODE
Element: 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
Element: Hours Signed 7.2
Contains the hours associated with the distribution.

PR197 PR582

PR82.1 PR82.2

PR85.1

PRD-DIST-AMT
Element: Dist Amt Signed 13.2
Contains the amount to be posted.

PR197 PR582

PR82.1 PR82.2

PR85.1

PRD-GL-DATE
Element: Gl Date Numeric 8 (yyyymmdd)
Contains the general ledger posting date.

PR197 PR582

PR82.1 PR82.2

PR85.1

PRD-JOB-CODE
Element: Job Code Alpha 9
Contains the user-defined job code.

PR197 PR582

PR82.1 PR82.2

PR85.1

PRD-RUN-DATE
Element: Run Date Numeric 8 (yyyymmdd)
Contains the date the transaction is posted to the general ledger.

PR197 PR198

PRD-RUN-TIME
Element: Sys Time Numeric 6 (hhmmss)
Contains the time the transaction is posted to the general ledger.

PR197 PR198

PRD-ACTIVITY
Element: 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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Full Acct 1 Derived

PRD-FULL-ACCT-2
Element: Full Acct 2 Derived

PRD-FULL-ACCT
Element: Full Acct Derived

PRD-CURRENCY-CODE
Element: 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
Element: Acct 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
Element: Error Type Numeric 1

1 = Currency Error Exists
0 = No Error Exists

PR197 PR70.1

PR85.1

PRD-CO-CURR-CD
Element: Co Curr Cd Alpha 5

PR197 PR582

PR70.1 PR82.1

PR85.1

PRD-DST-CO-CURR-CD
Element: Dst Co Curr Cd Alpha 5

PR197 PR582

PR70.1 PR82.1

PR85.1

PRD-CO-EXCH-RATE
Element: Co Exch Rate Signed 14.7

PR197 PR582

PR70.1 PR82.1

PR85.1

PRD-DIST-EXCH-RATE
Element: Dist Exch Rate Signed 14.7

PR197 PR582

PR70.1 PR82.1

PR85.1

PRD-MSG-NBR
Element: Msg Nbr Numeric 3 Occurs 10 Times

PR197 PR582

PR70.1 PR82.1

PR85.1

PRD-HM-PROC-LEVEL
Element: Process Lev Hr Alpha 5

PR197 PR582

PR70.1 PR82.1

PR82.2 PR85.1

PRD-ATTEND-CODE
Element: 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
Element: Ac191 Updated Alpha 1

PR197 PR582

PR82.1 PR85.1

PRD-GARN-OBJ-ID
Element: Garn Obj Id Numeric 12

PR197 PR582

PR82.1 PR85.1

PRD-SEGMENT-SEQ
Element: Segment Seq Numeric 12

PR197 PR582

PR82.1 PR85.1

PRD-TR-DATE
Element: Tr Date Numeric 8 (yyyymmdd)

PR197 PR582

PR82.1 PR85.1

PRD-PER-END-DATE
Element: 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
Element: Pay Units Signed 7.2

PR197 PR82.1

PR82.2

PRD-UNIT-MEASURE
Element: Unit Measure Alpha 12

PR197 PR82.1

PR82.2

PRD-OT-PLAN-CODE
Element: 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
Element: 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
Element: 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.

PRD-GMI-OBJ-ID-2
Element: 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.

PRD-GML-OBJ-ID
Element: 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