PDCCHRGDTL – No description in the Lawson data dictionary

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

PDCCHRGDTL is a Lawson Purchase Order table (prefix PX2); no description in the lawson data dictionary. It is indexed by PCARD-PROGRAM, STATEMENT, COMPANY, TXN-NBR (PX2SET1); alternate indexes: PX2SET2. It is related 1:1 to PDCCHRGHDR and 1:M to PDCCHRGDST and PDCCHRGERR. It is updated by PD57.1, PD57.2 and PD570. The table has 39 fields, 2 indexes and 3 documented relations.

About PDCCHRGDTL

No description in the Lawson data dictionary.

Fields (39)

Column = COBOL field name without the PX2- 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
#PX2-PCARD-PROGRAM PK
PCARD_PROGRAM		Alpha 10—PD57.1, PD570
#PX2-STATEMENT PK
STATEMENT		Alpha 22—PD57.1, PD570
#PX2-COMPANY PK
COMPANY		Numeric 4—PD57.1, PD570
#PX2-STMT-FR-DATE
STMT_FR_DATE		Numeric 8 (yyyymmdd)——
#PX2-STMT-TO-DATE
STMT_TO_DATE		Numeric 8 (yyyymmdd)——
#PX2-TXN-NBR PK
TXN_NBR		Alpha 22—PD57.1, PD570
#PX2-PCARD-NBR
PCARD_NBR		Alpha 16—PD57.1, PD570
#PX2-VENDOR
VENDOR		Alpha 9 (Right Justified)——
#PX2-MCC-CODE
MCC_CODE		Alpha 4—PD57.1, PD570
#PX2-MERCHANT
MERCHANT		Alpha 32—PD57.1, PD570
#PX2-TRAN-DATE SET2
TRAN_DATE		Numeric 8 (yyyymmdd)—PD57.1, PD570
#PX2-POST-DATE
POST_DATE		Numeric 8 (yyyymmdd)—PD57.1, PD570
#PX2-CARD-USER-ID
CARD_USER_ID		Alpha 10 (Lower Case)——
#PX2-CARD-USER-NAME
CARD_USER_NAME		Alpha 30—PD570
#PX2-PO-NUMBER
PO_NUMBER		Alpha 14 (Right Justified)—PD57.1, PD570
#PX2-PO-RELEASE
PO_RELEASE		Numeric 4—PD57.1, PD570
#PX2-PO-CODE
PO_CODE		Alpha 4—PD57.1, PD570
#PX2-PO-LINE-NBR
PO_LINE_NBR		Numeric 6—PD57.1, PD570
#PX2-ITEM
ITEM		Alpha 32—PD57.1, PD570
#PX2-VEN-ITEM
VEN_ITEM		Alpha 32—PD57.1, PD570
#PX2-ITEM-DESC
ITEM_DESC		Alpha 30 (Lower Case)—PD570
#PX2-VEN-ITEM-DESC
VEN_ITEM_DESC		Alpha 30 (Lower Case)——
#PX2-QUANTITY
QUANTITY		Signed 13.4—PD57.1, PD570
#PX2-VBUY-UOM
VBUY_UOM		Alpha 4—PD57.1, PD570
#PX2-VPRI-UOM
VPRI_UOM		Alpha 4—PD570
#PX2-ITEM-CHARGE
ITEM_CHARGE		Signed 18.2—PD57.1, PD570
#PX2-TAX-AMT
TAX_AMT		Signed 18.2—PD57.1, PD57.2, PD570
#PX2-TOT-AOC-COST
TOT_AOC_COST		Signed 18.2—PD57.1, PD570
#PX2-LAST-DIST-SEQ
LAST_DIST_SEQ		Numeric 4—PD57.2
#PX2-TAX-INDICATOR
TAX_INDICATOR		Numeric 1—
  • 0 Exempt
  • 1 Taxable
PD570
#PX2-TAX-CODE
TAX_CODE		Alpha 10——
#PX2-STATUS
STATUS		Numeric 1—
  • 0 Unreleased
  • 1 Released
PD570
#PX2-REASON-CODE
REASON_CODE		Alpha 4——
#PX2-COM-CODE
COM_CODE		Alpha 35——
#PX2-USER-FIELD1
USER_FIELD1		Alpha 20——
#PX2-USER-FIELD2
USER_FIELD2		Alpha 20——
#PX2-USER-FIELD3
USER_FIELD3		Alpha 20——
#PX2-USER-FIELD4
USER_FIELD4		Alpha 20——
#PX2-USER-FIELD5
USER_FIELD5		Alpha 20——

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
PX2SET1
  1. PCARD-PROGRAM
  2. STATEMENT
  3. COMPANY
  4. TXN-NBR
PrimaryPD57.1, PD57.2, PD57.3, PD570
PX2SET2
  1. PCARD-PROGRAM
  2. STATEMENT
  3. TRAN-DATE
  4. COMPANY
  5. TXN-NBR
KeyChange—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PdcchrghdrPDCCHRGHDRRequired
PX2-PCARD-PROGRAM→PX1-PCARD-PROGRAM (PX1SET1)
PX2-STATEMENT→PX1-STATEMENT

One to many (2) — child tables

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

Programs

Updated by (3)