POIVACOMMT – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
PVK
Primary key
PROCURE-GROUP, VEN-AGRMT-REF, LINE-NBR, SYSTEM, LINE-SEQ, COMMIT-DATE
Fields
7
Updated by
0 programs
Referenced by
0 programs

POIVACOMMT is a Lawson Purchase Order table (prefix PVK); no description in the lawson data dictionary. It is indexed by PROCURE-GROUP, VEN-AGRMT-REF, LINE-NBR, SYSTEM, LINE-SEQ, COMMIT-DATE (PVKSET1). The table has 7 fields, 1 index and 0 documented relations.

About POIVACOMMT

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the PVK- 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
#PVK-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4——
#PVK-VEN-AGRMT-REF PK
VEN_AGRMT_REF		Alpha 30——
#PVK-LINE-NBR PK
LINE_NBR		Numeric 6——
#PVK-SYSTEM PK
SYSTEM		Alpha 2——
#PVK-LINE-SEQ PK
LINE_SEQ		Numeric 3——
#PVK-COMMIT-DATE PK
COMMIT_DATE		Numeric 8 (yyyymmdd)——
#PVK-SPREAD-AMOUNT
SPREAD_AMOUNT		Signed 18.2——

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.

IndexKeysFlagsConditionUsed in
PVKSET1
  1. PROCURE-GROUP
  2. VEN-AGRMT-REF
  3. LINE-NBR
  4. SYSTEM
  5. LINE-SEQ
  6. COMMIT-DATE
PrimaryPOIK.1

Programs

No Lawson programs are documented as updating or referencing this table.