Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRDISTRIB


                             PRDISTRIB FILE

                     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

PA495     PR131     PR195     HR170     HR70.1    PR295
PR285     PR55.1    HR00.1    HR01.1    PA82.1

UPDATED BY

ET530     PR197     PR198     PR300     PR70.1    PR82.1
PR82.2    PR85.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PRD-COMPANY            Numeric 4                                 ET530   PR197
Element: Company Hr                                              PR70.1  PR82.1
                                                                 PR82.2  PR85.1

PRD-EMPLOYEE           Numeric 9                                 ET530   PR197
Element: Employee      Contains the employee number. Each        PR70.1  PR82.1
                       person employed by the company is         PR82.2  PR85.1
                       assigned a unique number. The system
                       uses the employee number to correlate
                       all of the information related to that
                       person.

PRD-CHECK-ID           Numeric 12                                ET530   PR197
Element: Check Id      Contains the payment identification       PR70.1  PR82.1
                       number. When the system creates a         PR82.2  PR85.1
                       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.

PRD-OBJ-ID             Numeric 12                                ET530   PR197
Element: Obj Id        This is the object identifier. It is      PR70.1  PR82.1
                       used to relate commitments or posted      PR82.2  PR85.1
                       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-STATUS             Numeric 1                                 ET530   PR198
Element: Status        Contains the distribution status. The     PR85.1
                       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
                       9 = Closed

PRD-PROCESS-LEVEL      Alpha 5                                   ET530   PR197
Element: Process Lev HrContains the process level to which the   PR82.1  PR82.2
                       amount is posted.                         PR85.1

PRD-DEPARTMENT         Alpha 5                                   ET530   PR197
Element: Department    Contains the department to which the      PR82.1  PR82.2
                       amount is posted.                         PR85.1

PRD-RECORD-TYPE        Alpha 1                                   ET530   PR197
Element: Record Type   This field identifies the type of         PR82.1  PR82.2
                       record defined.                           PR85.1

                       Valid values are:
                       S = Summary
                       D = Detail
                       1 = Error suspense
                       A = Deduction Accrual
                       C = Cash Accrual
                       E = Expense Accrual

PRD-CHECK-TYPE         Alpha 1                                   ET530   PR197
Element: Check Type    Contains the payment type.                PR70.1  PR82.1
                       A = ACH                                   PR82.2  PR85.1
                       P = Partial ACH
                       S = System
                       J = Adjustment
                       R = Void Reversal
                       M = Manual

PRD-DST-ACCT-UNIT      Alpha 15                                  ET530   PR197
Element: Acct Unit     Contains the general ledger accounting    PR70.1  PR82.1
                       unit to which the amount is posted.       PR82.2  PR85.1

PRD-DST-ACCOUNT        Numeric 6                                 ET530   PR197
Element: Account       Contains the general ledger account to    PR70.1  PR82.1
                       which the amount is posted.               PR82.2  PR85.1

PRD-DST-SUB-ACCT       Numeric 4                                 ET530   PR197
Element: Sub Acct      Contains the general ledger subaccount    PR70.1  PR82.1
                       to which the amount is posted.            PR82.2  PR85.1

PRD-DIST-COMPANY       Numeric 4                                 ET530   PR197
Element: Company       Contains the company number to which a    PR70.1  PR82.1
                       transaction is posted. A valid            PR82.2  PR85.1
                       intercompany relationship must be
                       defined in the General Ledger system.

PRD-PCD-SEQ-NBR        Numeric 4                                 ET530   PR197
Element: Pcd Seq Nbr   Contains the sequence number for the      PR82.1  PR82.2
                       distribution relative to the pay code.    PR85.1

PRD-DED-CODE           Alpha 4                                   ET530   PR197
Element: Ded Code      Contains the deduction associated with    PR82.1  PR82.2
                       the distribution. The system uses this    PR85.1
                       field to identify employee deduction
                       distributions and company-paid deduction
                       distributions.

PRD-HOURS              Signed 7.2                                ET530   PR197
Element: Hours         Contains the hours associated with the    PR82.1  PR82.2
                       distribution.                             PR85.1

PRD-DIST-AMT           Signed 13.2                               ET530   PR197
Element: Dist Amt      Contains the amount to be posted.         PR82.1  PR82.2
                                                                 PR85.1

PRD-GL-DATE            Numeric 8  (yyyymmdd)                     ET530   PR197
Element: Gl Date       Contains the general ledger posting       PR82.1  PR82.2
                       date.                                     PR85.1

PRD-JOB-CODE           Alpha 9                                   ET530   PR197
Element: Job Code      Contains the user-defined job code.       PR82.1  PR82.2
                                                                 PR85.1

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

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

PRD-ACTIVITY           Alpha 15                                  ET530   PR197
Element: Activity      Activities are the processes or           PR82.1  PR82.2
                       procedures that produce work. Cost        PR85.1
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


PRD-GLT-OBJ-ID         Numeric 12                                PR197   PR198
Element: Obj Id        This is the object identifier. It is      PR85.1
                       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-ATN-OBJ-ID         Numeric 12                                PR197   PR198
Element: Obj Id        This is the object identifier. It is      PR82.1
                       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-POSITION           Alpha 12                                  ET530   PR197
Element: Position      Contains the user-defined code that       PR82.1  PR82.2
                       represents a position in the company.     PR85.1

PRD-ACCT-CATEGORY      Alpha 5                                   ET530   PR197
Element: Acct Category Account categories are groupings of       PR82.1  PR82.2
                       costs, revenues, or a combination of      PR85.1
                       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

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

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

PRD-FULL-ACCT          Derived
Element: Full Acct

PRD-CURRENCY-CODE      Alpha 5                                   ET530   PR197
Element: Currency Code This field contains the company base      PR82.1  PR85.1
                       currency code established in Company
                       (GL10.1 ).

PRD-CURR-ND            Numeric 1                                 ET530   PR197
Element: Acct Nd       The number of decimals assigned to a      PR82.1  PR85.1
                       particular account as determined by the
                       account currency.


PRD-ERROR-TYPE         Numeric 1                                 ET530   PR197
Element: Error Type    1 = Currency Error Exists                 PR70.1  PR85.1
                       0 = No Error Exists

PRD-CO-CURR-CD         Alpha 5                                   ET530   PR197
Element: Co Curr Cd                                              PR70.1  PR82.1
                                                                 PR85.1

PRD-DST-CO-CURR-CD     Alpha 5                                   ET530   PR197
Element: Dst Co Curr Cd                                          PR70.1  PR82.1
                                                                 PR85.1

PRD-CO-EXCH-RATE       Signed 14.7                               ET530   PR197
Element: Co Exch Rate                                            PR70.1  PR82.1
                                                                 PR85.1

PRD-DIST-EXCH-RATE     Signed 14.7                               ET530   PR197
Element: Dist Exch Rate                                          PR70.1  PR82.1
                                                                 PR85.1

PRD-MSG-NBR            Numeric 3 Occurs 10 Times                 ET530   PR197
Element: Msg Nbr                                                 PR70.1  PR82.1
                                                                 PR85.1

PRD-HM-PROC-LEVEL      Alpha 5                                   ET530   PR197
Element: Process Lev Hr                                          PR70.1  PR82.1
                                                                 PR82.2  PR85.1

PRD-ATTEND-CODE        Alpha 2                                   PR197
Element: Attend Code   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.

PRD-AC-UPDATED         Alpha 1                                   ET530   PR197
Element: Ac191 Updated                                           PR82.1  PR85.1

PRD-GARN-OBJ-ID        Numeric 12                                ET530   PR197
Element: Garn Obj Id                                             PR82.1  PR85.1

PRD-SEGMENT-SEQ        Numeric 12                                ET530   PR197
Element: Segment Seq                                             PR82.1  PR85.1

PRD-TR-DATE            Numeric 8  (yyyymmdd)                     ET530   PR197
Element: Tr Date                                                 PR82.1  PR85.1

PRD-PER-END-DATE       Numeric 8  (yyyymmdd)                     PR197   PR82.1
Element: Per End Date  Identifies period end date in
                       distribution record; used during PR198
                       to relieve salary encumbrance
                       commitments for pay period (updated from
                       TIMERECORD.PER-END-DATE).

PRD-PAY-UNITS          Signed 7.2                                PR197   PR82.1
Element: Pay Units                                               PR82.2

PRD-UNIT-MEASURE       Alpha 12                                  PR197   PR82.1
Element: Unit Measure                                            PR82.2

PRD-OT-PLAN-CODE       Alpha 4                                   PR197
Element: Ot Plan Code  Identifies pay plan in effect for
                       employee when PRDISTRIB record was
                       created from PR197 (PRPRD).

PRD-GM-ADJ-TYPE        Alpha 1
Element: Gm Adj Type   Identifies labor cost transfer
                       adjustment type for PRDISTRIB adjustment
                       records created by GM170.
                       R = Reversing Entry
                       A = Adjusting Entry

PRD-GMI-OBJ-ID-1       Numeric 12
Element: Obj Id        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       Numeric 12
Element: Obj Id        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         Numeric 12                                PR197
Element: Obj Id        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.

                         PRDISTRIB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRDSET1   COMPANY                                                ET530   PA495
          EMPLOYEE                                               PR131   PR195
          CHECK-ID                                               PR197   PR198
          OBJ-ID                                                 PR300   PR70.1
                                                                 PR82.1  PR82.2
                                                                 PR85.1

PRDSET2   COMPANY       KeyChange                                HR170   HR70.1
          EMPLOYEE                                               PR295   PR300
          GL-DATE
          CHECK-ID
          OBJ-ID

PRDSET3   DIST-COMPANY  KeyChange
          GLT-OBJ-ID
          DST-ACCT-UNIT
          DST-ACCOUNT
          DST-SUB-ACCT
          OBJ-ID

PRDSET4   COMPANY       KeyChange                                PR198   PR70.1
          STATUS
          ERROR-TYPE
          HM-PROC-LEVEL
          DIST-COMPANY
          DST-ACCT-UNIT
          DST-ACCOUNT
          DST-SUB-ACCT
          GL-DATE
          EMPLOYEE
          CHECK-ID
          OBJ-ID

PRDSET5   COMPANY       KeyChange, Subset                        PR285   PR55.1
          ACTIVITY      Where ACTIVITY != Spaces
          ATN-OBJ-ID
          EMPLOYEE
          OBJ-ID

PRDSET6   COMPANY       KeyChange, Subset                        HR00.1  HR01.1
          PROCESS-LEVEL Where STATUS = 9                         PA82.1  PR198
          EMPLOYEE
          GL-DATE
          CHECK-ID
          OBJ-ID

PRDSET7   COMPANY       KeyChange, Subset                        PA82.1
          POSITION      Where POSITION != Spaces
          GL-DATE
          EMPLOYEE
          CHECK-ID
          OBJ-ID

PRDSET8   COMPANY       KeyChange
          HM-PROC-LEVEL
          EMPLOYEE
          CHECK-ID
          OBJ-ID

                         PRDISTRIB FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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

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

                         PRDISTRIB FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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