PDCHRGHDR – No description in the Lawson data dictionary
- System
- Purchase Order (PO)
- Prefix
PXH- Primary key
PCARD-PROGRAM,STATEMENT- Fields
- 26
- Updated by
- 2 programs
- Referenced by
- 4 programs
PDCHRGHDR is a Lawson Purchase Order table (prefix PXH); no description in the lawson data dictionary. It is indexed by PCARD-PROGRAM, STATEMENT (PXHSET1). It is related 1:M to PDCHRGDTL. It is updated by PD130 and PD570 and referenced by PD20.1, PD20.2, PD20.3 and PD230. The table has 26 fields, 1 index and 1 documented relation.
About PDCHRGHDR
No description in the Lawson data dictionary.
Fields (26)
Column = COBOL field name without the PXH- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#PXH-PCARD-PROGRAM PKPCARD_PROGRAM | Alpha 10 | — | PD570 |
#PXH-STATEMENT PKSTATEMENT | Alpha 22 | Used to identify the invoice. | PD570 |
#PXH-INVOICEINVOICE | Alpha 22 | Used to identify the invoice. | PD130 |
#PXH-COMPANYCOMPANY | Numeric 4 | Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources. | PD570 |
#PXH-STMT-DATESTMT_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | PD570 |
#PXH-BANK-ENTITYBANK_ENTITY | Alpha 15 | Represents a bank institution location. | — |
#PXH-STMT-FR-DATESTMT_FR_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | PD570 |
#PXH-STMT-TO-DATESTMT_TO_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | PD570 |
#PXH-TOT-CHRG-CNTTOT_CHRG_CNT | Signed 13.4 | This field contains the desired quantity. | PD570 |
#PXH-TOT-CHRG-AMTTOT_CHRG_AMT | Signed 18.2 | — | PD570 |
#PXH-TOT-CREDIT-CNTTOT_CREDIT_CNT | Signed 13.4 | This field contains the desired quantity. | PD570 |
#PXH-TOT-CREDIT-AMTTOT_CREDIT_AMT | Signed 18.2 | — | PD570 |
#PXH-STMT-TOTALSTMT_TOTAL | Signed 18.2 | — | PD570 |
#PXH-HANDLING-CODEHANDLING_CODE | Alpha 4 | — | — |
#PXH-CANCEL-FLCANCEL_FL | Alpha 1 | — | — |
#PXH-CANCEL-DATECANCEL_DATE | Numeric 8 (yyyymmdd) | The cancellation date. | — |
#PXH-SHP-TO-POST-CDSHP_TO_POST_CD | Alpha 10 (Lower Case) | — | PD570 |
#PXH-SHP-FR-POST-CDSHP_FR_POST_CD | Alpha 10 (Lower Case) | — | PD570 |
#PXH-DEST-CTRY-CODEDEST_CTRY_CODE | Numeric 5 | — | PD570 |
#PXH-DISCOUNT-AMTDISCOUNT_AMT | Signed 18.2 | — | PD570 |
#PXH-FREIGHT-AMTFREIGHT_AMT | Signed 18.2 | — | PD570 |
#PXH-DUTY-AMTDUTY_AMT | Signed 18.2 | — | PD570 |
#PXH-VAT-REF-NBRVAT_REF_NBR | Alpha 16 | — | PD570 |
#PXH-VAT-TAX-AMTVAT_TAX_AMT | Signed 18.2 | — | PD570 |
#PXH-VAT-TAX-RATEVAT_TAX_RATE | Percent 7.5 (Percent) | — | PD570 |
#PXH-ORDER-DATEORDER_DATE | Numeric 8 (yyyymmdd) | — | 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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PXHSET1 |
| Primary | PD130, PD20.1, PD20.2, PD20.3, PD230, PD570 |
Relations
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Pdchrgdtl | PDCHRGDTL |
|