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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated 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 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
PTUSET1
  1. PROCURE-GROUP
  2. TEMPLATE-REF
  3. LINE-NBR
  4. COMPANY
  5. REQ-LOCATION
  6. REQUESTER
  7. BUYER-GRP
  8. BUYER
  9. DATE
  10. TIME
  11. FLD-NBR
PrimaryPO115, PO15.1, PO15.2, PO15.3, PO165, PO65.3, PO65.4

Programs

Updated by (7)