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.

Field / column	Type	Description & values	Updated 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` 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PX2SET1`	`PCARD-PROGRAM`, `STATEMENT`, `COMPANY`, `TXN-NBR`	Primary		PD57.1, PD57.2, PD57.3, PD570
`PX2SET2`	`PCARD-PROGRAM`, `STATEMENT`, `TRAN-DATE`, `COMPANY`, `TXN-NBR`	KeyChange		—

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Pdcchrghdr	PDCCHRGHDR	Required		`PX2-PCARD-PROGRAM` → `PX1-PCARD-PROGRAM (PX1SET1)`, `PX2-STATEMENT` → `PX1-STATEMENT`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Pdcchrgdst	PDCCHRGDST			`PX2-PCARD-PROGRAM` → `PX3-PCARD-PROGRAM`, `PX2-STATEMENT` → `PX3-STATEMENT`, `PX2-COMPANY` → `PX3-COMPANY`, `PX2-TXN-NBR` → `PX3-TXN-NBR`, → `PX3-SEQ-NBR`
Pdcchrgerr	PDCCHRGERR			`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)

PD57.1 P-Card Charge Import Maintenance
PD57.2 P-Card Charge Import Distributions
PD570 P-Card Charge Import