POINTAUDIT – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PII
Primary key
AUDIT-TYPE, AUDIT-ACTION, PROCURE-GROUP, COMPANY, ORIGIN-CD, SOURCE-DOC-A, SOURCE-DOC-N, OPER-COMPANY, LINE-NBR, FLD-NBR, UPDATE-DATE, UPDATE-TIME
Fields
17
Updated by
220 programs
Referenced by
0 programs

POINTAUDIT is a Lawson Purchase Order table (prefix PII); no description in the lawson data dictionary. It is indexed by AUDIT-TYPE, AUDIT-ACTION, PROCURE-GROUP, COMPANY, ORIGIN-CD, SOURCE-DOC-A, SOURCE-DOC-N, OPER-COMPANY, LINE-NBR, FLD-NBR, UPDATE-DATE, UPDATE-TIME (PIISET1); alternate indexes: PIISET2. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 212 more. The table has 17 fields, 2 indexes and 0 documented relations.

About POINTAUDIT

No description in the Lawson data dictionary.

Fields (17)

Column = COBOL field name without the PII- 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
#PII-AUDIT-TYPE PK
AUDIT_TYPE
Alpha 2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-AUDIT-ACTION PK
AUDIT_ACTION
Alpha 1—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-PROCURE-GROUP PK
PROCURE_GROUP
Alpha 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-COMPANY PK
COMPANY
Numeric 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-ORIGIN-CD PK
ORIGIN_CD
Alpha 2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-SOURCE-DOC-A PK
SOURCE_DOC_A
Alpha 10 (Right Justified)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-SOURCE-DOC-N PK
SOURCE_DOC_N
Numeric 8—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-OPER-COMPANY PK
OPER_COMPANY
Numeric 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-LINE-NBR PK
LINE_NBR
Numeric 6—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-FLD-NBR PK
FLD_NBR
Numeric 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-UPDATE-DATE PK
UPDATE_DATE
Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-UPDATE-TIME PK
UPDATE_TIME
Numeric 6—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-BEFORE-IMAGE
BEFORE_IMAGE
Alpha 35—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-AFTER-IMAGE
AFTER_IMAGE
Alpha 35—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-USER-ID
USER_ID
Alpha 10 (Lower Case)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-PRINT-REV
PRINT_REV
Alpha 1—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PII-DESC
DESC
Alpha 30 (Lower Case)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (2)

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
PIISET1
  1. AUDIT-TYPE
  2. AUDIT-ACTION
  3. PROCURE-GROUP
  4. COMPANY
  5. ORIGIN-CD
  6. SOURCE-DOC-A
  7. SOURCE-DOC-N
  8. OPER-COMPANY
  9. LINE-NBR
  10. FLD-NBR
  11. UPDATE-DATE
  12. UPDATE-TIME
Primary—
PIISET2
  1. PROCURE-GROUP
  2. OPER-COMPANY
  3. ORIGIN-CD
  4. SOURCE-DOC-A
  5. SOURCE-DOC-N
  6. LINE-NBR
  7. UPDATE-DATE ↓
  8. UPDATE-TIME ↓
  9. FLD-NBR
  10. AUDIT-TYPE
  11. AUDIT-ACTION
—

Programs

Updated by (220)