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 / column | Type | Description & values | Updated by |
|---|---|---|---|
PX3-PCARD-PROGRAM PKPCARD_PROGRAM | Alpha 10 | — | PD57.2, PD570 |
PX3-STATEMENT PKSTATEMENT | Alpha 22 | — | PD57.2, PD570 |
PX3-COMPANY PKCOMPANY | Numeric 4 | — | PD57.2, PD570 |
PX3-TXN-NBR PKTXN_NBR | Alpha 22 | — | PD57.2, PD570 |
PX3-SEQ-NBR PKSEQ_NBR | Numeric 4 | — | PD57.2, PD570 |
PX3-DIST-TYPEDIST_TYPE | Alpha 1 | —
| PD57.2, PD570 |
PX3-DIST-AMOUNTDIST_AMOUNT | Signed 18.2 | — | PD57.2, PD570 |
PX3-ACCT-UNITACCT_UNIT | Alpha 15 | — | PD57.2, PD570 |
PX3-ACCOUNTACCOUNT | Numeric 6 | — | PD57.2, PD570 |
PX3-SUB-ACCTSUB_ACCT | Numeric 4 | — | PD57.2, PD570 |
PX3-DIST-COMPANYDIST_COMPANY | Numeric 4 | — | PD57.2, PD570 |
PX3-ACTIVITYACTIVITY | Alpha 15 | — | PD57.2, PD570 |
PX3-ACCT-CATEGORYACCT_CATEGORY | Alpha 5 | — | PD57.2, PD570 |
PX3-BILL-CATEGORYBILL_CATEGORY | Alpha 32 | — | PD57.2, PD570 |
PX3-SEGMENT-BLOCKSEGMENT_BLOCK | Alpha 103 | — | PD57.2, PD570 |
Indexes (1)
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 |
|---|---|---|---|---|
PX3SET1 | PCARD-PROGRAM, STATEMENT, COMPANY, TXN-NBR, SEQ-NBR | Primary | PD57.1, PD57.2, PD57.3, PD570 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Pdcchrgdtl | PDCCHRGDTL | Required | 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
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Pdcchrgerr | PDCCHRGERR | 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 |