HCHPPAUDIT – No description in the Lawson data dictionary

System
Inventory Control (IC)
Prefix
HPA
Primary key
COMPANY, REQ-NUMBER, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, DATE, TIME, FLD-NBR
Fields
15
Updated by
223 programs
Referenced by
0 programs

HCHPPAUDIT is a Lawson Inventory Control table (prefix HPA); no description in the lawson data dictionary. It is indexed by COMPANY, REQ-NUMBER, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR, DATE, TIME, FLD-NBR (HPASET1). It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 215 more. The table has 15 fields, 1 index and 0 documented relations.

About HCHPPAUDIT

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the HPA- 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
#HPA-COMPANY PK
COMPANY		Numeric 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPA-REQ-NUMBER PK
REQ_NUMBER		Numeric 7—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPA-PO-NUMBER PK
PO_NUMBER		Alpha 14 (Right Justified)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPA-PO-RELEASE PK
PO_RELEASE		Numeric 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPA-PO-CODE PK
PO_CODE		Alpha 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPA-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)
#HPA-DATE PK
DATE		Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPA-TIME PK
TIME		Numeric 8—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPA-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)
#HPA-BEFORE-IMAGE
BEFORE_IMAGE		Alpha 60—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPA-AFTER-IMAGE
AFTER_IMAGE		Alpha 60—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPA-OPERATOR
OPERATOR		Alpha 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPA-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPA-AUDIT-ACTION
AUDIT_ACTION		Alpha 1—
  • A Add
  • C Change
  • D Delete
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#HPA-OBJ-ID
OBJ_ID		Numeric 12—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

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
HPASET1
  1. COMPANY
  2. REQ-NUMBER
  3. PO-NUMBER
  4. PO-RELEASE
  5. PO-CODE
  6. LINE-NBR
  7. DATE ↓
  8. TIME ↓
  9. FLD-NBR
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (223)