POHDRPVT – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PHP
Primary key
COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE
Fields
11
Updated by
232 programs
Referenced by
0 programs

POHDRPVT is a Lawson Purchase Order table (prefix PHP); no description in the lawson data dictionary. It is indexed by COMPANY, PO-CODE, PO-NUMBER, PO-RELEASE (PHPSET1); alternate indexes: PHPSET2, PHPSET3, PHPSET4 and PHPSET5. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 224 more. The table has 11 fields, 5 indexes and 0 documented relations.

About POHDRPVT

No description in the Lawson data dictionary.

Fields (11)

Column = COBOL field name without the PHP- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
PHP-COMPANY PK
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.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PHP-PO-NUMBER PK
PO_NUMBER		Alpha 14 (Right Justified)This field contains the number representing the purchase order.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PHP-PO-RELEASE PK
PO_RELEASE		Numeric 4Used to identify a purchase order release (created from a Blanket or Standing order).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PHP-PO-CODE PK
PO_CODE		Alpha 4This is the purchase order code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PHP-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PHP-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PHP-BUYER-CODE
BUYER_CODE		Alpha 3—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PHP-PO-DATE
PO_DATE		Numeric 8 (yyyymmdd)This field displays the system date when this was created.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PHP-STATUS
STATUS		Numeric 1This field displays the status of the transaction. It is a conversion of flags (released, closed ...)
  • 1 Unreleased
  • 2 Released
  • 3 Issued
  • 7 Closed
  • 9 Cancelled
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PHP-TOT-ORDER-AMT
TOT_ORDER_AMT		Signed 18.2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
PHP-NBR-LINES
NBR_LINES		Numeric 6This is the number of detail lines.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (5)

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

IndexKeysFlagsConditionUsed in
PHPSET1COMPANY, PO-CODE, PO-NUMBER, PO-RELEASEPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PHPSET2COMPANY, STATUS, VENDOR, PURCH-FR-LOC, PO-DATE*, PO-CODE, PO-NUMBER, PO-RELEASEKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PHPSET3COMPANY, STATUS, BUYER-CODE, PO-DATE*, PO-CODE, PO-NUMBER, PO-RELEASEKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PHPSET4COMPANY, STATUS, PO-CODE, PO-DATE*, PO-NUMBER, PO-RELEASEKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PHPSET5COMPANY, STATUS, PO-DATE*, PO-CODE, PO-NUMBER, PO-RELEASEKeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (232)