POAPPCODE – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
POG
Primary key
PROCURE-GROUP, APPROVE-CD
Fields
8
Updated by
1 program
Referenced by
222 programs

POAPPCODE is a Lawson Purchase Order table (prefix POG); no description in the lawson data dictionary. It is indexed by PROCURE-GROUP, APPROVE-CD (POGSET1). It is updated by PO08.1 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 214 more. The table has 8 fields, 1 index and 0 documented relations.

About POAPPCODE

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the POG- 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
#POG-PROCURE-GROUP PK
PROCURE_GROUP
Alpha 4—PO08.1
#POG-APPROVE-CD PK
APPROVE_CD
Alpha 5—PO08.1
#POG-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)—PO08.1, PO514
#POG-SKIP-LVLS-FL
SKIP_LVLS_FL
Alpha 1—
  • N No
  • Y Yes
PO08.1
#POG-AUTH-PRT-FL
AUTH_PRT_FL
Alpha 1—
  • N No
  • Y Yes
PO08.1
#POG-AUTH-ID
AUTH_ID
Alpha 10 Occurs 6 Times ×6—PO08.1
#POG-AUTH-NAME
AUTH_NAME
Alpha 30 Occurs 6 Times ×6—PO08.1
#POG-AUTH-LIMIT
AUTH_LIMIT
Numeric 9 Occurs 6 Times ×6—PO08.1

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
POGSET1
  1. PROCURE-GROUP
  2. APPROVE-CD
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (1)

Referenced by (222)