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.

Field / columnTypeDescription & valuesUpdated by
PX3-PCARD-PROGRAM PK
PCARD_PROGRAM
Alpha 10PD57.2, PD570
PX3-STATEMENT PK
STATEMENT
Alpha 22PD57.2, PD570
PX3-COMPANY PK
COMPANY
Numeric 4PD57.2, PD570
PX3-TXN-NBR PK
TXN_NBR
Alpha 22PD57.2, PD570
PX3-SEQ-NBR PK
SEQ_NBR
Numeric 4PD57.2, PD570
PX3-DIST-TYPE
DIST_TYPE
Alpha 1
  • G Goods
  • T Tax
PD57.2, PD570
PX3-DIST-AMOUNT
DIST_AMOUNT
Signed 18.2PD57.2, PD570
PX3-ACCT-UNIT
ACCT_UNIT
Alpha 15PD57.2, PD570
PX3-ACCOUNT
ACCOUNT
Numeric 6PD57.2, PD570
PX3-SUB-ACCT
SUB_ACCT
Numeric 4PD57.2, PD570
PX3-DIST-COMPANY
DIST_COMPANY
Numeric 4PD57.2, PD570
PX3-ACTIVITY
ACTIVITY
Alpha 15PD57.2, PD570
PX3-ACCT-CATEGORY
ACCT_CATEGORY
Alpha 5PD57.2, PD570
PX3-BILL-CATEGORY
BILL_CATEGORY
Alpha 32PD57.2, PD570
PX3-SEGMENT-BLOCK
SEGMENT_BLOCK
Alpha 103PD57.2, PD570

Indexes (1)

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

IndexKeysFlagsConditionUsed in
PX3SET1PCARD-PROGRAM, STATEMENT, COMPANY, TXN-NBR, SEQ-NBRPrimaryPD57.1, PD57.2, PD57.3, PD570

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PdcchrgdtlPDCCHRGDTLRequiredPX3-PCARD-PROGRAMPX2-PCARD-PROGRAM, PX3-STATEMENTPX2-STATEMENT, PX3-COMPANYPX2-COMPANY, PX3-TXN-NBRPX2-TXN-NBR

One to many (1) — child tables

RelationTableRulesConditionField map
PdcchrgerrPDCCHRGERRPX3-PCARD-PROGRAMPXE-PCARD-PROGRAM, PX3-STATEMENTPXE-STATEMENT, PX3-COMPANYPXE-COMPANY, PX3-TXN-NBRPXE-TXN-NBR, PX3-SEQ-NBRPXE-SEQ-NBR, PXE-ERROR-SEQ

Programs

Updated by (3)