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.

Field / columnTypeDescription & valuesUpdated by
PXH-PCARD-PROGRAM PK
PCARD_PROGRAM
Alpha 10PD570
PXH-STATEMENT PK
STATEMENT
Alpha 22Used to identify the invoice.PD570
PXH-INVOICE
INVOICE
Alpha 22Used to identify the invoice.PD130
PXH-COMPANY
COMPANY
Numeric 4Identifies 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-DATE
STMT_DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.PD570
PXH-BANK-ENTITY
BANK_ENTITY
Alpha 15Represents a bank institution location.
PXH-STMT-FR-DATE
STMT_FR_DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.PD570
PXH-STMT-TO-DATE
STMT_TO_DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.PD570
PXH-TOT-CHRG-CNT
TOT_CHRG_CNT
Signed 13.4This field contains the desired quantity.PD570
PXH-TOT-CHRG-AMT
TOT_CHRG_AMT
Signed 18.2PD570
PXH-TOT-CREDIT-CNT
TOT_CREDIT_CNT
Signed 13.4This field contains the desired quantity.PD570
PXH-TOT-CREDIT-AMT
TOT_CREDIT_AMT
Signed 18.2PD570
PXH-STMT-TOTAL
STMT_TOTAL
Signed 18.2PD570
PXH-HANDLING-CODE
HANDLING_CODE
Alpha 4
PXH-CANCEL-FL
CANCEL_FL
Alpha 1
PXH-CANCEL-DATE
CANCEL_DATE
Numeric 8 (yyyymmdd)The cancellation date.
PXH-SHP-TO-POST-CD
SHP_TO_POST_CD
Alpha 10 (Lower Case)PD570
PXH-SHP-FR-POST-CD
SHP_FR_POST_CD
Alpha 10 (Lower Case)PD570
PXH-DEST-CTRY-CODE
DEST_CTRY_CODE
Numeric 5PD570
PXH-DISCOUNT-AMT
DISCOUNT_AMT
Signed 18.2PD570
PXH-FREIGHT-AMT
FREIGHT_AMT
Signed 18.2PD570
PXH-DUTY-AMT
DUTY_AMT
Signed 18.2PD570
PXH-VAT-REF-NBR
VAT_REF_NBR
Alpha 16PD570
PXH-VAT-TAX-AMT
VAT_TAX_AMT
Signed 18.2PD570
PXH-VAT-TAX-RATE
VAT_TAX_RATE
Percent 7.5 (Percent)PD570
PXH-ORDER-DATE
ORDER_DATE
Numeric 8 (yyyymmdd)PD570

Indexes (1)

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

IndexKeysFlagsConditionUsed in
PXHSET1PCARD-PROGRAM, STATEMENTPrimaryPD130, PD20.1, PD20.2, PD20.3, PD230, PD570

Relations

One to many (1) — child tables

RelationTableRulesConditionField map
PdchrgdtlPDCHRGDTLPXH-PCARD-PROGRAMPXD-PCARD-PROGRAM, PXH-STATEMENTPXD-STATEMENT, PXD-COMPANY, PXD-TXN-NBR

Programs

Updated by (2)

Referenced by (4)