PRAUDIT – Payroll Payment Audit File

System
Payroll (PR)
Prefix
PRU
Primary key
COMPANY, BNK-ACCT-NBR, CHECK-NBR, CHECK-ID, SEQ-NBR
Fields
13
Updated by
2 programs
Referenced by
3 programs

PRAUDIT is the Payroll Payment Audit File table in Lawson Payroll (prefix PRU). It is indexed by COMPANY, BNK-ACCT-NBR, CHECK-NBR, CHECK-ID, SEQ-NBR (PRUSET1); alternate indexes: PRUSET2 and PRUSET3. It is related 1:1 to BANKACCT, PRSYSTEM, EMPLOYEE and PRCHECK. It is updated by PR300 and PRAU.1 and referenced by PR281, PR80.1 and PR80.4. The table has 13 fields, 3 indexes and 4 documented relations.

About PRAUDIT

Contains information associated with manual payments. The information in this file is used to create an audit record showing that a manual payment was created, printed, changed, or deleted.

Fields (13)

Column = COBOL field name without the PRU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PRU-COMPANY PK
COMPANY		Numeric 4—PRAU.1
#PRU-BNK-ACCT-NBR PK
BNK_ACCT_NBR		Alpha 17Contains the bank account on which the manual payment is drawn.PRAU.1
#PRU-CHECK-NBR PK
CHECK_NBR		Numeric 8Contains the payment number. This is the number that appears on the printed payment.PRAU.1
#PRU-CHECK-ID PK
CHECK_ID		Numeric 12Contains the payment identification number (unique payment identifier used in tracking payment information).PRAU.1
#PRU-SEQ-NBR PK
SEQ_NBR		Numeric 4An automatically assigned sequence number.PRAU.1
#PRU-STATUS SET2
STATUS		Numeric 1Contains the payment status.
  • 0 Created
  • 1 Changed
  • 2 Printed
  • 3 Deleted
PRAU.1
#PRU-GROSS-PAY
GROSS_PAY		Signed 13.2Contains the gross pay associated with the manual payment.PRAU.1
#PRU-NET-PAY-AMT
NET_PAY_AMT		Signed 13.2Contains the net amount of the manual payment.PRAU.1
#PRU-USER-NAME
USER_NAME		Alpha 10 (Lower Case)Contains the sign on name of the person who created the manual payment.PRAU.1
#PRU-DATE SET3
DATE		Numeric 8 (yyyymmdd)Contains the system date the payment was created, updated, printed or deleted.PRAU.1
#PRU-TIME
TIME		Numeric 8Contains the system-assigned time the payment was created, updated, printed, or deleted.PRAU.1
#PRU-EMPLOYEE
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.PRAU.1
#PRU-CHECK-DATE SET3
CHECK_DATE		Numeric 8 (yyyymmdd)Contains the payment date of the payment that was changed, printed, or deleted.PRAU.1

Indexes (3)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PRUSET1
  1. COMPANY
  2. BNK-ACCT-NBR
  3. CHECK-NBR
  4. CHECK-ID
  5. SEQ-NBR
PrimaryPR281, PR300, PRAU.1
PRUSET2
  1. COMPANY
  2. BNK-ACCT-NBR
  3. CHECK-NBR
  4. CHECK-ID
  5. STATUS
  6. SEQ-NBR
KeyChangePR80.1, PR80.4, PRAU.1
PRUSET3
  1. COMPANY
  2. DATE ↓
  3. CHECK-DATE ↓
  4. BNK-ACCT-NBR
  5. CHECK-NBR
  6. CHECK-ID
  7. SEQ-NBR
KeyChange—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BANKACCTPRSYSTEMEMPLOYEEPRCHECKPRAUDIT

One to one (4) — lookups and parents

RelationTableRulesConditionField map
Bnk Acct NbrBANKACCTRequired
PRU-BNK-ACCT-NBR→BAC-BNK-ACCT-NBR (BACSET1)
CompanyPRSYSTEMRequired
PRU-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
PRU-COMPANY→EMP-COMPANY
PRU-EMPLOYEE→EMP-EMPLOYEE
PrcheckPRCHECKNot Required
PRU-BNK-ACCT-NBR→PCH-BNK-ACCT-NBR
"C"→PCH-PRINT-TYPE
PRU-CHECK-NBR→PCH-CHECK-NBR
PRU-CHECK-ID→PCH-CHECK-ID

Programs

Updated by (2)

Referenced by (3)