POAUDIT – Audit Records

System
Purchase Order (PO)
Prefix
PAU
Primary key
AUDIT-TYPE, AUDIT-ACTION, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, PO-REVISION, PO-LINE-NBR, AOC-CODE, LINE-SEQ, FLD-NBR, UPDATE-DATE, UPDATE-TIME
Fields
18
Updated by
248 programs
Referenced by
0 programs

POAUDIT is the Audit Records table in Lawson Purchase Order (prefix PAU). It is indexed by AUDIT-TYPE, AUDIT-ACTION, COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, PO-REVISION, PO-LINE-NBR, AOC-CODE, LINE-SEQ, FLD-NBR, UPDATE-DATE, UPDATE-TIME (PAUSET1); alternate indexes: PAUSET2, PAUSET3 and PAUSET4. It is related 1:1 to MMDIST, POLINE, POREVISION and PURCHORDER. It is updated by AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 and 240 more. The table has 18 fields, 4 indexes and 4 documented relations.

About POAUDIT

No description in the Lawson data dictionary.

Fields (18)

Column = COBOL field name without the PAU- 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
#PAU-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
AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-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
AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-COMPANY PK
COMPANY		Numeric 4The company number.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-PO-NUMBER PK
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-PO-RELEASE PK
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-PO-LINE-NBR PK
PO_LINE_NBR		Numeric 6The purchase order line number this record is associated with.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-FLD-NBR PK
FLD_NBR		Numeric 4This field contains the purchase order dictionary field number.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-AOC-CODE PK
AOC_CODE		Alpha 2This field contains the identifier for the add-on cost associated with this line item.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-UPDATE-DATE PK
UPDATE_DATE		Numeric 8 (yyyymmdd)This field contains the date the record was updated.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-UPDATE-TIME PK
UPDATE_TIME		Numeric 6This field contains the system time when the record was updated.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-PO-REVISION PK
PO_REVISION		Numeric 3The purchase order revision number. Assigned sequentially by the system when the purchase order is revised.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-BEFORE-IMAGE
BEFORE_IMAGE		Alpha 60This field contains the field image before the change.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-AFTER-IMAGE
AFTER_IMAGE		Alpha 60This field contains the field image before the change.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-USER-ID
USER_ID		Alpha 10 (Lower Case)Contains the user ID of the person who revised the purchase order.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-PRINT-REV
PRINT_REV		Alpha 1—
  • Y Yes
  • N No
AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-DESC
DESC		Alpha 30 (Lower Case)The description of the field that has changed.AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)
#PAU-LINE-SEQ PK
LINE_SEQ		Numeric 3—AM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +52 more (list truncated in source)

Indexes (4)

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
PAUSET1
  1. AUDIT-TYPE
  2. AUDIT-ACTION
  3. COMPANY
  4. PO-NUMBER
  5. PO-RELEASE
  6. PO-CODE
  7. PO-REVISION
  8. PO-LINE-NBR
  9. AOC-CODE
  10. LINE-SEQ
  11. FLD-NBR
  12. UPDATE-DATE
  13. UPDATE-TIME
PrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
PAUSET2
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. PO-REVISION ↓
  6. UPDATE-DATE ↓
  7. UPDATE-TIME ↓
  8. PO-LINE-NBR
  9. AOC-CODE
  10. LINE-SEQ
  11. FLD-NBR
  12. AUDIT-TYPE
  13. AUDIT-ACTION
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PAUSET3
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. PO-LINE-NBR
  6. PO-REVISION ↓
  7. AOC-CODE
  8. LINE-SEQ
  9. UPDATE-DATE ↓
  10. UPDATE-TIME ↓
  11. FLD-NBR
  12. AUDIT-TYPE
  13. AUDIT-ACTION
KeyChangeAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
PAUSET4
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. PO-LINE-NBR
  6. AOC-CODE
  7. LINE-SEQ
  8. PO-REVISION ↓
  9. UPDATE-DATE ↓
  10. UPDATE-TIME ↓
  11. FLD-NBR
  12. AUDIT-TYPE
  13. AUDIT-ACTION
KeyChangeAM19.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)
MMDISTPOLINEPOREVISIONPURCHORDERPOAUDIT

One to one (4) — lookups and parents

RelationTableRulesConditionField map
MmdistMMDISTNot RequiredValid When PAU-LINE-SEQ != Zeroes
PAU-COMPANY→MMD-COMPANY
PAU-PO-NUMBER→MMD-DOC-NUMBER
PAU-PO-RELEASE→MMD-DOC-NBR-NUM
PAU-PO-CODE→MMD-PO-CODE
PAU-LINE-SEQ→MMD-LINE-NBR
PAU-AOC-CODE→MMD-AOC-CODE
PAU-LINE-SEQ→MMD-LINE-SEQ
PolinePOLINERequiredWhen PAU-PO-LINE-NBR != Zeroes And PAU-LINE-SEQ = Zeroes
PAU-COMPANY→PLI-COMPANY
PAU-PO-NUMBER→PLI-PO-NUMBER
PAU-PO-RELEASE→PLI-PO-RELEASE
PAU-PO-CODE→PLI-PO-CODE
PAU-PO-LINE-NBR→PLI-LINE-NBR
PorevisionPOREVISIONRequired
PAU-COMPANY→PVS-COMPANY
PAU-PO-NUMBER→PVS-PO-NUMBER
PAU-PO-RELEASE→PVS-PO-RELEASE
PAU-PO-CODE→PVS-PO-CODE
PAU-PO-REVISION→PVS-PO-REVISION
PurchorderPURCHORDERRequiredWhen PAU-PO-LINE-NBR = Zeroes And PAU-LINE-SEQ = Zeroes
PAU-COMPANY→PCR-COMPANY
PAU-PO-CODE→PCR-PO-CODE
PAU-PO-NUMBER→PCR-PO-NUMBER
PAU-PO-RELEASE→PCR-PO-RELEASE

Programs

Updated by (248)