PDCCHRGDST – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PX3
Primary key
PCARD-PROGRAM, STATEMENT, COMPANY, TXN-NBR, SEQ-NBR
Fields
15
Updated by
3 programs
Referenced by
0 programs

PDCCHRGDST is a Lawson Purchase Order table (prefix PX3); no description in the lawson data dictionary. It is indexed by PCARD-PROGRAM, STATEMENT, COMPANY, TXN-NBR, SEQ-NBR (PX3SET1). It is related 1:1 to PDCCHRGDTL and 1:M to PDCCHRGERR. It is updated by PD57.1, PD57.2 and PD570. The table has 15 fields, 1 index and 2 documented relations.

About PDCCHRGDST

No description in the Lawson data dictionary.

Fields (15)

Column = COBOL field name without the PX3- 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
#PX3-PCARD-PROGRAM PK
PCARD_PROGRAM		Alpha 10—PD57.2, PD570
#PX3-STATEMENT PK
STATEMENT		Alpha 22—PD57.2, PD570
#PX3-COMPANY PK
COMPANY		Numeric 4—PD57.2, PD570
#PX3-TXN-NBR PK
TXN_NBR		Alpha 22—PD57.2, PD570
#PX3-SEQ-NBR PK
SEQ_NBR		Numeric 4—PD57.2, PD570
#PX3-DIST-TYPE
DIST_TYPE		Alpha 1—
  • G Goods
  • T Tax
PD57.2, PD570
#PX3-DIST-AMOUNT
DIST_AMOUNT		Signed 18.2—PD57.2, PD570
#PX3-ACCT-UNIT
ACCT_UNIT		Alpha 15—PD57.2, PD570
#PX3-ACCOUNT
ACCOUNT		Numeric 6—PD57.2, PD570
#PX3-SUB-ACCT
SUB_ACCT		Numeric 4—PD57.2, PD570
#PX3-DIST-COMPANY
DIST_COMPANY		Numeric 4—PD57.2, PD570
#PX3-ACTIVITY
ACTIVITY		Alpha 15—PD57.2, PD570
#PX3-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5—PD57.2, PD570
#PX3-BILL-CATEGORY
BILL_CATEGORY		Alpha 32—PD57.2, PD570
#PX3-SEGMENT-BLOCK
SEGMENT_BLOCK		Alpha 103—PD57.2, 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
PX3SET1
  1. PCARD-PROGRAM
  2. STATEMENT
  3. COMPANY
  4. TXN-NBR
  5. SEQ-NBR
PrimaryPD57.1, PD57.2, PD57.3, PD570

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PdcchrgdtlPDCCHRGDTLRequired
PX3-PCARD-PROGRAM→PX2-PCARD-PROGRAM
PX3-STATEMENT→PX2-STATEMENT
PX3-COMPANY→PX2-COMPANY
PX3-TXN-NBR→PX2-TXN-NBR

One to many (1) — child tables

RelationTableRulesConditionField map
PdcchrgerrPDCCHRGERR
PX3-PCARD-PROGRAM→PXE-PCARD-PROGRAM
PX3-STATEMENT→PXE-STATEMENT
PX3-COMPANY→PXE-COMPANY
PX3-TXN-NBR→PXE-TXN-NBR
PX3-SEQ-NBR→PXE-SEQ-NBR
—→PXE-ERROR-SEQ

Programs

Updated by (3)