POAPPROVE – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
POH
Primary key
COMPANY, AUTH-ID, APPROVE-CD, PO-NUMBER, PO-RELEASE, PO-CODE
Fields
7
Updated by
222 programs
Referenced by
0 programs

POAPPROVE is a Lawson Purchase Order table (prefix POH); no description in the lawson data dictionary. It is indexed by COMPANY, AUTH-ID, APPROVE-CD, PO-NUMBER, PO-RELEASE, PO-CODE (POHSET1); alternate indexes: POHSET2. It is related 1:1 to ICCOMPANY and PURCHORDER and 1:M to POLINE. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 214 more. The table has 7 fields, 2 indexes and 3 documented relations.

About POAPPROVE

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the POH- 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
#POH-COMPANY PK
COMPANY		Numeric 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#POH-AUTH-ID PK
AUTH_ID		Alpha 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#POH-APPROVE-CD PK
APPROVE_CD		Alpha 5—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#POH-PO-CODE PK
PO_CODE		Alpha 4——
#POH-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)
#POH-PO-RELEASE PK
PO_RELEASE		Numeric 4——
#POH-APRV-LEVEL SET2
APRV_LEVEL		Numeric 1—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
POHSET1
  1. COMPANY
  2. AUTH-ID
  3. APPROVE-CD
  4. PO-NUMBER
  5. PO-RELEASE
  6. PO-CODE
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
POHSET2
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. APRV-LEVEL
PO17.1, PO18.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ICCOMPANYPURCHORDERPOLINEPOAPPROVE

One to one (2) — lookups and parents

RelationTableRulesConditionField map
Ic CompanyICCOMPANYRequired
POH-COMPANY→ICC-COMPANY
PurchorderPURCHORDERRequired
POH-COMPANY→PCR-COMPANY
POH-PO-CODE→PCR-PO-CODE
POH-PO-NUMBER→PCR-PO-NUMBER
POH-PO-RELEASE→PCR-PO-RELEASE

One to many (1) — child tables

RelationTableRulesConditionField map
Po LinesPOLINE
POH-COMPANY→PLI-COMPANY
POH-PO-NUMBER→PLI-PO-NUMBER
POH-PO-RELEASE→PLI-PO-RELEASE
POH-PO-CODE→PLI-PO-CODE
—→PLI-LINE-NBR

Programs

Updated by (222)