POAUDRULES – Audit Rules

System
Purchase Order (PO)
Prefix
PAL
Primary key
COMPANY, AUDIT-TYPE, AUDIT-ACTION, FLD-NBR
Fields
7
Updated by
3 programs
Referenced by
245 programs

POAUDRULES is the Audit Rules table in Lawson Purchase Order (prefix PAL). It is indexed by COMPANY, AUDIT-TYPE, AUDIT-ACTION, FLD-NBR (PALSET1). It is related 1:1 to POAUDTYPE. It is updated by PO01.1, PO01.2 and PO181 and referenced by AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 and 237 more. The table has 7 fields, 1 index and 1 documented relation.

About POAUDRULES

This file contains rules for auditing PO source records. The descriptions for each field are contained in the following message categories under the associated field number: PO Header - POAHD PO Line - POALN PO AOC - POALA PO Spread - POAHA

Fields (7)

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

Field / columnTypeDescription & valuesUpdated by
PAL-COMPANY PK
COMPANY
Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.PO01.1, PO01.2, PO181
PAL-AUDIT-TYPE PK
AUDIT_TYPE
Alpha 2The type of source record that is being audited.
  • HD PO Header
  • HA Spread AOC
  • LN PO Line
  • LA Misc/Line AOC
  • DS PO Distribution
PO01.1, PO01.2, PO181
PAL-AUDIT-ACTION PK
AUDIT_ACTION
Alpha 1The action (add, change, etc.) that is being audited.
  • A Add
  • C Change
  • L Cancel
  • B B/O Cancel
  • P Approve
  • E Reject
  • U Unrelease
PO01.1, PO01.2, PO181
PAL-FLD-NBR PK
FLD_NBR
Numeric 4This field contains the PO dictionary field number.PO01.1, PO01.2, PO181
PAL-AUDIT-FL
AUDIT_FL
Alpha 1
  • Y Yes
  • N No
PO01.1, PO01.2, PO181
PAL-UPDATE-AUDIT
UPDATE_AUDIT
Alpha 1
  • Y Yes
  • N No
PO01.1, PO181
PAL-PRINT-REV
PRINT_REV
Alpha 1
  • Y Yes
  • N No
PO01.1, PO01.2, PO181

Indexes (1)

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

IndexKeysFlagsConditionUsed in
PALSET1COMPANY, AUDIT-TYPE, AUDIT-ACTION, FLD-NBRPrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PoaudtypePOAUDTYPERequiredPAL-COMPANYPTY-COMPANY, PAL-AUDIT-TYPEPTY-AUDIT-TYPE

Programs

Updated by (3)

Referenced by (245)