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.

Field / columnTypeDescription & valuesUpdated by
POH-COMPANY PK
COMPANY
Numeric 4AP125, 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 10AP125, 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 5AP125, 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
APRV_LEVEL
Numeric 1AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
POHSET1COMPANY, AUTH-ID, APPROVE-CD, PO-NUMBER, PO-RELEASE, PO-CODEPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
POHSET2COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, APRV-LEVELPO17.1, PO18.1

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
Ic CompanyICCOMPANYRequiredPOH-COMPANYICC-COMPANY
PurchorderPURCHORDERRequiredPOH-COMPANYPCR-COMPANY, POH-PO-CODEPCR-PO-CODE, POH-PO-NUMBERPCR-PO-NUMBER, POH-PO-RELEASEPCR-PO-RELEASE

One to many (1) — child tables

RelationTableRulesConditionField map
Po LinesPOLINEPOH-COMPANYPLI-COMPANY, POH-PO-NUMBERPLI-PO-NUMBER, POH-PO-RELEASEPLI-PO-RELEASE, POH-PO-CODEPLI-PO-CODE, PLI-LINE-NBR

Programs

Updated by (222)