ITEMUPN1 – Item UPN1
- System
- Inventory Control (IC)
- Prefix
IPN- Primary key
ITEM-GROUP,ITEM,UPN-NBR- Fields
- 13
- Updated by
- 10 programs
- Referenced by
- 13 programs
ITEMUPN1 is the Item UPN1 table in Lawson Inventory Control (prefix IPN). It is indexed by ITEM-GROUP, ITEM, UPN-NBR (IPNSET1); alternate indexes: IPNSET2, IPNSET5 and IPNSET6. It is related 1:1 to ITEMMAST. It is updated by ICI5.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 and 2 more and referenced by IC11.1, IC11.3, IC511, IC524, IC598, IC800, ICI8.1, RQIC.1 and 5 more. The table has 13 fields, 4 indexes and 2 documented relations.
About ITEMUPN1
The Item UPN1 file contains the Universal Product Number information related to an item in the Item Master file.
Fields (13)
Column = COBOL field name without the IPN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
IPN-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. | ICI5.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more |
IPN-ITEM PKITEM | Alpha 32 | This field contains the item identifier. | ICI5.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more |
IPN-UPN-NBR PKUPN_NBR | Alpha 20 | Universal Product Number. | ICI5.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more |
IPN-REPL-UPN1REPL_UPN1 | Alpha 20 | Replacement UPN. | ICI5.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1 |
IPN-MFG-PD-DESCMFG_PD_DESC | Alpha 80 | Manufacturer's product description. | ICI5.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1 |
IPN-SALE-BY-DISTRSALE_BY_DISTR | Alpha 1 | Sale by distributor flag. | ICI5.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more |
IPN-SALE-BY-MFGSALE_BY_MFG | Alpha 1 | Sale by manufacturer flag. | ICI5.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more |
IPN-TRADE-NAMETRADE_NAME | Alpha 30 | Trade name for the product. | ICI5.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1 |
IPN-UOMUOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | ICI5.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more |
IPN-UOM-COSTUOM_COST | Signed 18.5 | — | ICI5.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1 |
IPN-MFG-NAMEMFG_NAME | Alpha 35 (Lower Case) | — | ICI5.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1 |
IPN-MFG-DIVISIONMFG_DIVISION | Alpha 35 (Lower Case) | — | ICI5.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1 |
IPN-ITEM-TYPE-UPN1ITEM_TYPE_UPN1 | 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 |
|---|---|---|---|---|
IPNSET1 | ITEM-GROUP, ITEM, UPN-NBR | Primary | IC11.1, IC11.3, IC511, IC598, IC800, ICI5.1, ICI8.1, PO150 +11 more | |
IPNSET2 | UPN-NBR, ITEM-GROUP | ICI5.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more | ||
IPNSET5 | ITEM-GROUP, ITEM, UOM, UPN-NBR | IC11.1, IC524, ICI5.1, ICI8.1, RQIC.1, RQID.1, RQIF.1, RQIG.1 +2 more | ||
IPNSET6 | ITEM-GROUP, UPN-NBR | KeyChange | — |
Relations
One to one (2) — lookups and parents
Programs
Updated by (10)
- ICI5.1 ITEMUPN1 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 (13)
- IC11.1 Item Master
- IC11.3 Item Universal Product Number 1
- IC511 Item Master-Item Location Extr
- IC524 CSV Item Master
- 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