PDCCHRGERR – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PXE
Primary key
PCARD-PROGRAM, STATEMENT, COMPANY, TXN-NBR, SEQ-NBR, ERROR-SEQ
Fields
7
Updated by
1 program
Referenced by
222 programs

PDCCHRGERR is a Lawson Purchase Order table (prefix PXE); no description in the lawson data dictionary. It is indexed by PCARD-PROGRAM, STATEMENT, COMPANY, TXN-NBR, SEQ-NBR, ERROR-SEQ (PXESET1). It is related 1:1 to PDCCHRGDST, PDCCHRGDTL and PDCCHRGHDR. It is updated by PD570 and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 214 more. The table has 7 fields, 1 index and 3 documented relations.

About PDCCHRGERR

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the PXE- 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
#PXE-PCARD-PROGRAM PK
PCARD_PROGRAM
Alpha 10—PD570
#PXE-STATEMENT PK
STATEMENT
Alpha 22—PD570
#PXE-COMPANY PK
COMPANY
Numeric 4—PD570
#PXE-TXN-NBR PK
TXN_NBR
Alpha 22—PD570
#PXE-SEQ-NBR PK
SEQ_NBR
Numeric 4—PD570
#PXE-ERROR-SEQ PK
ERROR_SEQ
Numeric 4—PD570
#PXE-ERR-MESSAGE
ERR_MESSAGE
Alpha 60—PD570

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
PXESET1
  1. PCARD-PROGRAM
  2. STATEMENT
  3. COMPANY
  4. TXN-NBR
  5. SEQ-NBR
  6. ERROR-SEQ
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
PdcchrgdstPDCCHRGDSTNot Required
PXE-PCARD-PROGRAM→PX3-PCARD-PROGRAM
PXE-STATEMENT→PX3-STATEMENT
PXE-COMPANY→PX3-COMPANY
PXE-TXN-NBR→PX3-TXN-NBR
PXE-SEQ-NBR→PX3-SEQ-NBR
PdcchrgdtlPDCCHRGDTLNot Required
PXE-PCARD-PROGRAM→PX2-PCARD-PROGRAM
PXE-STATEMENT→PX2-STATEMENT
PXE-COMPANY→PX2-COMPANY
PXE-TXN-NBR→PX2-TXN-NBR
PdcchrghdrPDCCHRGHDRNot Required
PXE-PCARD-PROGRAM→PX1-PCARD-PROGRAM
PXE-STATEMENT→PX1-STATEMENT

Programs

Updated by (1)

Referenced by (222)