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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
PRU-COMPANY PKCOMPANY | Numeric 4 | — | PRAU.1 |
PRU-BNK-ACCT-NBR PKBNK_ACCT_NBR | Alpha 17 | Contains the bank account on which the manual payment is drawn. | PRAU.1 |
PRU-CHECK-NBR PKCHECK_NBR | Numeric 8 | Contains the payment number. This is the number that appears on the printed payment. | PRAU.1 |
PRU-CHECK-ID PKCHECK_ID | Numeric 12 | Contains the payment identification number (unique payment identifier used in tracking payment information). | PRAU.1 |
PRU-SEQ-NBR PKSEQ_NBR | Numeric 4 | An automatically assigned sequence number. | PRAU.1 |
PRU-STATUSSTATUS | Numeric 1 | Contains the payment status.
| PRAU.1 |
PRU-GROSS-PAYGROSS_PAY | Signed 13.2 | Contains the gross pay associated with the manual payment. | PRAU.1 |
PRU-NET-PAY-AMTNET_PAY_AMT | Signed 13.2 | Contains the net amount of the manual payment. | PRAU.1 |
PRU-USER-NAMEUSER_NAME | Alpha 10 (Lower Case) | Contains the sign on name of the person who created the manual payment. | PRAU.1 |
PRU-DATEDATE | Numeric 8 (yyyymmdd) | Contains the system date the payment was created, updated, printed or deleted. | PRAU.1 |
PRU-TIMETIME | Numeric 8 | Contains the system-assigned time the payment was created, updated, printed, or deleted. | PRAU.1 |
PRU-EMPLOYEEEMPLOYEE | 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. | PRAU.1 |
PRU-CHECK-DATECHECK_DATE | Numeric 8 (yyyymmdd) | Contains the payment date of the payment that was changed, printed, or deleted. | PRAU.1 |
Indexes (3)
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 |
|---|---|---|---|---|
PRUSET1 | COMPANY, BNK-ACCT-NBR, CHECK-NBR, CHECK-ID, SEQ-NBR | Primary | PR281, PR300, PRAU.1 | |
PRUSET2 | COMPANY, BNK-ACCT-NBR, CHECK-NBR, CHECK-ID, STATUS, SEQ-NBR | KeyChange | PR80.1, PR80.4, PRAU.1 | |
PRUSET3 | COMPANY, DATE*, CHECK-DATE*, BNK-ACCT-NBR, CHECK-NBR, CHECK-ID, SEQ-NBR | KeyChange | — |
Relations
One to one (4) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Bnk Acct Nbr | BANKACCT | Required | PRU-BNK-ACCT-NBR → BAC-BNK-ACCT-NBR (BACSET1) | |
| Company | PRSYSTEM | Required | PRU-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Employee | EMPLOYEE | Required | PRU-COMPANY → EMP-COMPANY, PRU-EMPLOYEE → EMP-EMPLOYEE | |
| Prcheck | PRCHECK | Not 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 |