PROCTMPAUD – No description in the Lawson data dictionary

System: Purchase Order (PO)
Prefix: PTU
Primary key: PROCURE-GROUP, TEMPLATE-REF, LINE-NBR, COMPANY, REQ-LOCATION, REQUESTER, BUYER-GRP, BUYER, DATE, TIME, FLD-NBR
Fields: 16
Updated by: 7 programs
Referenced by: 0 programs

PROCTMPAUD is a Lawson Purchase Order table (prefix PTU); no description in the lawson data dictionary. It is indexed by PROCURE-GROUP, TEMPLATE-REF, LINE-NBR, COMPANY, REQ-LOCATION, REQUESTER, BUYER-GRP, BUYER, DATE, TIME, FLD-NBR (PTUSET1). It is updated by PO115, PO15.1, PO15.2, PO15.3, PO165, PO65.3 and PO65.4. The table has 16 fields, 1 index and 0 documented relations.

About PROCTMPAUD

No description in the Lawson data dictionary.

Fields (16)

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

Field / column	Type	Description & values	Updated by
`PTU-PROCURE-GROUP` PK PROCURE_GROUP	Alpha 4	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-TEMPLATE-REF` PK TEMPLATE_REF	Alpha 30	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-LINE-NBR` PK LINE_NBR	Numeric 6	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-COMPANY` PK COMPANY	Numeric 4	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-REQ-LOCATION` PK REQ_LOCATION	Alpha 5	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-REQUESTER` PK REQUESTER	Alpha 10 (Lower Case)	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-BUYER-GRP` PK BUYER_GRP	Alpha 5	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-BUYER` PK BUYER	Alpha 3	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-DATE` PK DATE	Numeric 8 (yyyymmdd)	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-TIME` PK TIME	Numeric 8	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-FLD-NBR` PK FLD_NBR	Numeric 4	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-BEFORE-IMAGE` BEFORE_IMAGE	Alpha 60 (Lower Case)	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-AFTER-IMAGE` AFTER_IMAGE	Alpha 60 (Lower Case)	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-OPERATOR` OPERATOR	Alpha 10	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	—	PO115, PO15.1, PO15.2, PO15.3
`PTU-AUDIT-ACTION` AUDIT_ACTION	Alpha 1	—	PO115, PO15.1, PO15.2, PO15.3

Indexes (1)

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
`PTUSET1`	`PROCURE-GROUP`, `TEMPLATE-REF`, `LINE-NBR`, `COMPANY`, `REQ-LOCATION`, `REQUESTER`, `BUYER-GRP`, `BUYER`, `DATE`, `TIME`, `FLD-NBR`	Primary		PO115, PO15.1, PO15.2, PO15.3, PO165, PO65.3, PO65.4

Programs

Updated by (7)

PO115 Procurement Template Mass Changes
PO15.1 Procurement Templates
PO15.2 Procurement Template Participants
PO15.3 Procurement Templates Locking
PO165 Procure Template Audit Report
PO65.3 Procurement Template Audit
PO65.4 Procurement Template Participants Audit