ITEMUPN2 – Item UPN2
- System
- Inventory Control (IC)
- Prefix
IP2- Primary key
ITEM-GROUP,ITEM,UPN2-NBR- Fields
- 13
- Updated by
- 10 programs
- Referenced by
- 12 programs
ITEMUPN2 is the Item UPN2 table in Lawson Inventory Control (prefix IP2). It is indexed by ITEM-GROUP, ITEM, UPN2-NBR (IP2SET1); alternate indexes: IP2SET2, IP2SET5 and IP2SET6. It is related 1:1 to ITEMMAST. It is updated by ICI6.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 and 2 more and referenced by IC11.1, IC11.4, IC511, IC598, IC800, ICI8.1, RQIC.1, RQID.1 and 4 more. The table has 13 fields, 4 indexes and 2 documented relations.
About ITEMUPN2
The Item UPN2 file contains the Universal Product Number information related related to an item in the Item Master file.
Fields (13)
Column = COBOL field name without the IP2- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
IP2-ITEM-GROUP PKITEM_GROUP | Alpha 5 | This field contains the identifier for a group of items that can be shared by one or more companies. | ICI6.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more |
IP2-ITEM PKITEM | Alpha 32 | This field contains the item identifier. | ICI6.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more |
IP2-UPN2-NBR PKUPN2_NBR | Alpha 25 (Right Justified) | Universal Product Number. | ICI6.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more |
IP2-REPL-UPN2REPL_UPN2 | Alpha 25 (Right Justified) | Replacement UPN2. | ICI6.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1 |
IP2-MFG-PD-DESCMFG_PD_DESC | Alpha 80 | Manufacturer's product description. | ICI6.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1 |
IP2-SALE-BY-DISTRSALE_BY_DISTR | Alpha 1 | Sale by distributor flag.
| ICI6.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more |
IP2-SALE-BY-MFGSALE_BY_MFG | Alpha 1 | Sale by manufacturer flag.
| ICI6.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more |
IP2-TRADE-NAMETRADE_NAME | Alpha 30 | Trade name for the product. | ICI6.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1 |
IP2-UOMUOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | ICI6.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more |
IP2-UOM-COSTUOM_COST | Signed 18.5 | — | ICI6.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1 |
IP2-MFG-NAMEMFG_NAME | Alpha 35 (Lower Case) | — | ICI6.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1 |
IP2-MFG-DIVISIONMFG_DIVISION | Alpha 35 (Lower Case) | — | ICI6.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1 |
IP2-ITEM-TYPE-UPN2ITEM_TYPE_UPN2 | Derived | — | — |
Indexes (4)
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 |
|---|---|---|---|---|
IP2SET1 | ITEM-GROUP, ITEM, UPN2-NBR | Primary | IC11.1, IC11.4, IC511, IC598, IC800, ICI6.1, ICI8.1, PO150 +11 more | |
IP2SET2 | UPN2-NBR, ITEM-GROUP | ICI6.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +9 more | ||
IP2SET5 | ITEM-GROUP, ITEM, UOM, UPN2-NBR | IC11.1, ICI6.1, ICI8.1, RQIC.1, RQID.1, RQIF.1, RQIG.1, RQIH.1 +1 more | ||
IP2SET6 | ITEM-GROUP, UPN2-NBR | KeyChange | — |
Relations
One to one (2) — lookups and parents
Programs
Updated by (10)
- ICI6.1 ITEMUPN2 Invoked Object
- PO150 Bid Load to Contract or Catalog
- PO25.6 Vendor Agreement Line
- PO25.7 Service Agreement Line
- PO26.4 Vendor Agreement Line Price Breaks
- PO26.5 Vendor Agreement Line Price Breaks
- PO26.8 Update Vendor Agreement Line for Special Item
- PO28.2 Vendor Agreement Line Detail List
- PO36.2 Vendor Agreement Import Manual Input
- PO536 Vendor Price Agreement Load
Referenced by (12)
- IC11.1 Item Master
- IC11.4 Item Universal Product Number 2
- IC511 Item Master-Item Location Extr
- IC598 Bin Label Export
- IC800 Keyword Search Load
- ICI8.1 ITEMUPC Invoked Object
- RQIC.1 Get Item List Invoke Object
- RQID.1 RQRQHUPD Invoke Object
- RQIF.1 RQRLNUPD Invoke Object
- RQIG.1 Get Shopping List Invoke Object
- RQIH.1 Invoke Determine Express Data
- RQIJ.1 Requisition Copy