POVACOMMIX – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PVX
Primary key
PROCURE-GROUP, VEN-AGRMT-REF, LINE-NBR, SYSTEM, LINE-SEQ, SPREAD-DATE, SPT-OBJ-ID
Fields
21
Updated by
220 programs
Referenced by
0 programs

POVACOMMIX is a Lawson Purchase Order table (prefix PVX); no description in the lawson data dictionary. It is indexed by PROCURE-GROUP, VEN-AGRMT-REF, LINE-NBR, SYSTEM, LINE-SEQ, SPREAD-DATE, SPT-OBJ-ID (PVXSET1); alternate indexes: PVXSET2. It is related 1:1 to POLINE, PORETURNLN and REQLINE. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 212 more. The table has 21 fields, 2 indexes and 3 documented relations.

About POVACOMMIX

No description in the Lawson data dictionary.

Fields (21)

Column = COBOL field name without the PVX- 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
#PVX-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-VEN-AGRMT-REF PK
VEN_AGRMT_REF		Alpha 30—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-LINE-NBR PK
LINE_NBR		Numeric 6—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-SYSTEM PK
SYSTEM		Alpha 2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-LINE-SEQ PK
LINE_SEQ		Numeric 3—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-FISCAL-YEAR
FISCAL_YEAR		Numeric 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-PERIOD
PERIOD		Numeric 2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-COMMITMENT-DTE
COMMITMENT_DTE		Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-COMPANY
COMPANY		Numeric 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-PO-CODE
PO_CODE		Alpha 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-PO-NUMBER
PO_NUMBER		Alpha 14 (Right Justified)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-PO-RELEASE
PO_RELEASE		Numeric 4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-PO-LINE-NBR
PO_LINE_NBR		Numeric 6—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-REQ-NUMBER
REQ_NUMBER		Numeric 7—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-REQ-LINE-NBR
REQ_LINE_NBR		Numeric 6—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-SPT-OBJ-ID PK
SPT_OBJ_ID		Numeric 12—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-TRAN-AMOUNT
TRAN_AMOUNT		Signed 18.2—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-CURRENCY-CODE
CURRENCY_CODE		Alpha 5—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-SPREAD-DATE PK
SPREAD_DATE		Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-RETURN-NUMBER
RETURN_NUMBER		Numeric 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#PVX-RET-LINE-NBR
RET_LINE_NBR		Numeric 6—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)

Indexes (2)

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
PVXSET1
  1. PROCURE-GROUP
  2. VEN-AGRMT-REF
  3. LINE-NBR
  4. SYSTEM
  5. LINE-SEQ
  6. SPREAD-DATE
  7. SPT-OBJ-ID
Primary—
PVXSET2
  1. SPT-OBJ-ID
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
POLINEPORETURNLNREQLINEPOVACOMMIX

One to one (3) — lookups and parents

RelationTableRulesConditionField map
PolinePOLINERequiredWhen (PVX-PO-NUMBER != Spaces)
PVX-COMPANY→PLI-COMPANY
PVX-PO-NUMBER→PLI-PO-NUMBER
PVX-PO-RELEASE→PLI-PO-RELEASE
PVX-PO-CODE→PLI-PO-CODE
PVX-PO-LINE-NBR→PLI-LINE-NBR
PoreturnlnPORETURNLNRequiredWhen (PVX-RETURN-NUMBER != Zeroes)
PVX-COMPANY→PTL-COMPANY
PVX-RETURN-NUMBER→PTL-RETURN-NUMBER
PVX-RET-LINE-NBR→PTL-RET-LINE-NBR
ReqlineREQLINERequiredWhen (PVX-REQ-NUMBER != Zeroes)
PVX-COMPANY→RLN-COMPANY
PVX-REQ-NUMBER→RLN-REQ-NUMBER
PVX-REQ-LINE-NBR→RLN-LINE-NBR

Programs

Updated by (220)