POPIVUF – No description in the Lawson data dictionary

System
Purchase Order (PO)
Prefix
UFI
Primary key
PROCURE-GROUP, ITEM, VENDOR, VEN-ITEM
Fields
9
Updated by
2 programs
Referenced by
0 programs

POPIVUF is a Lawson Purchase Order table (prefix UFI); no description in the lawson data dictionary. It is indexed by PROCURE-GROUP, ITEM, VENDOR, VEN-ITEM (UFISET1). It is related 1:1 to POITEMVEN and 1:M to POPIVAUDIT. It is updated by PO13.1 and PO13.3. The table has 9 fields, 1 index and 2 documented relations.

About POPIVUF

No description in the Lawson data dictionary.

Fields (9)

Column = COBOL field name without the UFI- 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
#UFI-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.PO13.1, PO13.3
#UFI-ITEM PK
ITEM		Alpha 32This field contains the item identifier.PO13.1, PO13.3
#UFI-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.PO13.1, PO13.3
#UFI-VEN-ITEM PK
VEN_ITEM		Alpha 32—PO13.1, PO13.3
#UFI-PIV-USR-FLD-01
PIV_USR_FLD_01		Alpha 20—PO13.1, PO13.3
#UFI-PIV-USR-FLD-02
PIV_USR_FLD_02		Alpha 20—PO13.1, PO13.3
#UFI-PIV-USR-FLD-03
PIV_USR_FLD_03		Alpha 20—PO13.1, PO13.3
#UFI-PIV-USR-FLD-04
PIV_USR_FLD_04		Alpha 20—PO13.1, PO13.3
#UFI-PIV-USR-FLD-05
PIV_USR_FLD_05		Alpha 20—PO13.1, PO13.3

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
UFISET1
  1. PROCURE-GROUP
  2. ITEM
  3. VENDOR
  4. VEN-ITEM
PrimaryPO13.1, PO13.3

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PoitemvenPOITEMVENRequired
UFI-PROCURE-GROUP→PIV-PROCURE-GROUP
UFI-ITEM→PIV-ITEM
UFI-VENDOR→PIV-VENDOR
UFI-VEN-ITEM→PIV-VEN-ITEM

One to many (1) — child tables

RelationTableRulesConditionField map
PopivauditPOPIVAUDIT
UFI-PROCURE-GROUP→PIU-PROCURE-GROUP
UFI-ITEM→PIU-ITEM
UFI-VENDOR→PIU-VENDOR
UFI-VEN-ITEM→PIU-VENDOR-ITEM
—→PIU-DATE
—→PIU-TIME
—→PIU-FLD-NBR

Programs

Updated by (2)