POLINEPVT – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PLP
Primary key
COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR
Fields
16
Updated by
232 programs
Referenced by
0 programs

POLINEPVT is a Lawson Purchase Order table (prefix PLP); no description in the lawson data dictionary. It is indexed by COMPANY, PO-NUMBER, PO-RELEASE, PO-CODE, LINE-NBR (PLPSET1); alternate indexes: PLPSET2, PLPSET3, PLPSET4, PLPSET5, PLPSET6 and PLPSET7. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 224 more. The table has 16 fields, 7 indexes and 0 documented relations.

About POLINEPVT

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the PLP- 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 / columnTypeDescription & valuesUpdated by
#PLP-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)
#PLP-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)
#PLP-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)
#PLP-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)
#PLP-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the line number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PLP-VENDOR SET2 SET3 SET4 SET5 SET6
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)
#PLP-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)
#PLP-BUYER-CODE SET2 SET3 SET4 SET6
BUYER_CODE		Alpha 3—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PLP-EARLY-DL-DATE SET3 SET5 SET6
EARLY_DL_DATE		Numeric 8 (yyyymmdd)This field contains the early delivery date.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PLP-LOCATION SET2 SET3 SET4 SET6
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PLP-ITEM SET2 SET3 SET6
ITEM		Alpha 32This field contains the item identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PLP-PURCH-MAJCL SET2 SET3 SET4 SET6
PURCH_MAJCL		Alpha 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PLP-PURCH-MINCL SET2 SET3 SET4 SET6
PURCH_MINCL		Alpha 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PLP-STATUS SET6
STATUS		Numeric 1This field displays the status of the transaction. It is a conversion of flags (released, closed ...)
  • 1 Unreleased
  • 2 Released
  • 3 Issued
  • 5 Open Receivings
  • 7 Closed
  • 9 Cancelled
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PLP-EXTENDED-AMT
EXTENDED_AMT		Signed 18.2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PLP-ORIG-LINE-NBR SET7
ORIG_LINE_NBR		Numeric 6——

Indexes (7)

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.

IndexKeysFlagsConditionUsed in
PLPSET1
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. LINE-NBR
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PLPSET2
  1. COMPANY
  2. ITEM
  3. LOCATION
  4. BUYER-CODE
  5. VENDOR
  6. PURCH-MAJCL
  7. PURCH-MINCL
  8. PO-NUMBER
  9. PO-RELEASE
  10. PO-CODE
  11. LINE-NBR
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PLPSET3
  1. COMPANY
  2. ITEM
  3. EARLY-DL-DATE ↓
  4. LOCATION
  5. BUYER-CODE
  6. VENDOR
  7. PURCH-MAJCL
  8. PURCH-MINCL
  9. PO-NUMBER
  10. PO-RELEASE
  11. PO-CODE
  12. LINE-NBR
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PLPSET4
  1. COMPANY
  2. PURCH-MAJCL
  3. PURCH-MINCL
  4. LOCATION
  5. BUYER-CODE
  6. VENDOR
  7. PO-NUMBER
  8. PO-RELEASE
  9. PO-CODE
  10. LINE-NBR
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PLPSET5
  1. COMPANY
  2. EARLY-DL-DATE ↓
  3. VENDOR
  4. PO-NUMBER
  5. PO-RELEASE
  6. PO-CODE
  7. LINE-NBR
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PLPSET6
  1. COMPANY
  2. STATUS
  3. ITEM
  4. EARLY-DL-DATE ↓
  5. LOCATION
  6. BUYER-CODE
  7. VENDOR
  8. PURCH-MAJCL
  9. PURCH-MINCL
  10. PO-NUMBER
  11. PO-RELEASE
  12. PO-CODE
  13. LINE-NBR
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
PLPSET7
  1. COMPANY
  2. PO-NUMBER
  3. PO-RELEASE
  4. PO-CODE
  5. ORIG-LINE-NBR
  6. LINE-NBR
—

Programs

Updated by (232)