PDCHRGAPI – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PDO
Primary key
PCARD-PROGRAM, STATEMENT, API-OBJ-ID
Fields
3
Updated by
1 program
Referenced by
0 programs

PDCHRGAPI is a Lawson Purchase Order table (prefix PDO); no description in the lawson data dictionary. It is indexed by PCARD-PROGRAM, STATEMENT, API-OBJ-ID (PDOSET1); alternate indexes: PDOSET2. It is related 1:1 to PDCHRGHDR and 1:M to APDISTRIB. It is updated by PD130. The table has 3 fields, 2 indexes and 2 documented relations.

About PDCHRGAPI

No description in the Lawson data dictionary.

Fields (3)

Column = COBOL field name without the PDO- 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
#PDO-PCARD-PROGRAM PK
PCARD_PROGRAM		Alpha 10—PD130
#PDO-STATEMENT PK
STATEMENT		Alpha 22—PD130
#PDO-API-OBJ-ID PK
API_OBJ_ID		Numeric 12—PD130

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
PDOSET1
  1. PCARD-PROGRAM
  2. STATEMENT
  3. API-OBJ-ID
PrimaryPD130
PDOSET2
  1. API-OBJ-ID
  2. STATEMENT
KeyChange—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PdchrghdrPDCHRGHDRRequired
PDO-PCARD-PROGRAM→PXH-PCARD-PROGRAM (PXHSET1)
PDO-STATEMENT→PXH-STATEMENT

One to many (1) — child tables

RelationTableRulesConditionField map
ApdistribAPDISTRIB
PDO-API-OBJ-ID→APD-API-OBJ-ID
—→APD-DIST-SEQ-NBR

Programs

Updated by (1)