POAUDTYPE – Audit Types

System
Purchase Order (PO)
Prefix
PTY
Primary key
COMPANY, AUDIT-TYPE
Fields
3
Updated by
3 programs
Referenced by
245 programs

POAUDTYPE is the Audit Types table in Lawson Purchase Order (prefix PTY). It is indexed by COMPANY, AUDIT-TYPE (PTYSET1). It is related 1:1 to POCOMPANY and 1:M to POAUDRULES. 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 3 fields, 1 index and 2 documented relations.

About POAUDTYPE

This is the main file for purchase order audit rules. There is a unique record for each audit source record (purchase order, purchase order line, etc.). An element on this file indicates whether revision messages may be created for any of the audited fields in the source record. The detailed rules for each audited field are contained in the POAUDRULES file, which is subordinate to the POAUDTYPE file.

Fields (3)

Column = COBOL field name without the PTY- 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
#PTY-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
#PTY-AUDIT-TYPE PK
AUDIT_TYPE
Alpha 2The type of source record that is being audited.
  • HD PO Header
  • HA Spread Add on Costs
  • LN PO Line
  • LA PO Misc and Line Add on Costs
  • DS PO Distribution
PO01.1, PO01.2, PO181
#PTY-PRINT-REV
PRINT_REV
Alpha 1—
  • Y Yes
  • N No
PO01.1, PO01.2, PO181

Indexes (1)

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
PTYSET1
  1. COMPANY
  2. AUDIT-TYPE
PrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PocompanyPOCOMPANYRequired
PTY-COMPANY→PCY-COMPANY

One to many (1) — child tables

RelationTableRulesConditionField map
PoaudrulesPOAUDRULES
PTY-COMPANY→PAL-COMPANY
PTY-AUDIT-TYPE→PAL-AUDIT-TYPE
—→PAL-AUDIT-ACTION
—→PAL-FLD-NBR

Programs

Updated by (3)

Referenced by (245)