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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
UFI-PROCURE-GROUP PKPROCURE_GROUP | Alpha 4 | This 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 PKITEM | Alpha 32 | This field contains the item identifier. | PO13.1, PO13.3 |
UFI-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | PO13.1, PO13.3 |
UFI-VEN-ITEM PKVEN_ITEM | Alpha 32 | — | PO13.1, PO13.3 |
UFI-PIV-USR-FLD-01PIV_USR_FLD_01 | Alpha 20 | — | PO13.1, PO13.3 |
UFI-PIV-USR-FLD-02PIV_USR_FLD_02 | Alpha 20 | — | PO13.1, PO13.3 |
UFI-PIV-USR-FLD-03PIV_USR_FLD_03 | Alpha 20 | — | PO13.1, PO13.3 |
UFI-PIV-USR-FLD-04PIV_USR_FLD_04 | Alpha 20 | — | PO13.1, PO13.3 |
UFI-PIV-USR-FLD-05PIV_USR_FLD_05 | Alpha 20 | — | PO13.1, PO13.3 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
UFISET1 | PROCURE-GROUP, ITEM, VENDOR, VEN-ITEM | Primary | PO13.1, PO13.3 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Poitemven | POITEMVEN | Required | 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
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Popivaudit | POPIVAUDIT | 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 |