ITEMUPC – Item Universal Product Code

System
Inventory Control (IC)
Prefix
IPC
Primary key
ITEM-GROUP, ITEM, UPC
Fields
11
Updated by
10 programs
Referenced by
47 programs

ITEMUPC is the Item Universal Product Code table in Lawson Inventory Control (prefix IPC). It is indexed by ITEM-GROUP, ITEM, UPC (IPCSET1); alternate indexes: IPCSET2, IPCSET5 and IPCSET6. It is related 1:1 to ITEMMAST. It is updated by ICI4.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 and 2 more and referenced by IC11.1, IC11.2, IC511, IC598, IC800, ICI8.1, POI7.1, RQIC.1 and 39 more. The table has 11 fields, 4 indexes and 1 documented relation.

About ITEMUPC

The Item UPC file contains all the Universal Product Codes related to an item on the Item Master file.

Fields (11)

Column = COBOL field name without the IPC- 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
#IPC-ITEM-GROUP PK
ITEM_GROUP		Alpha 5This field contains the identifier for a group of items that can be shared by one or more companies.ICI4.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
#IPC-ITEM PK
ITEM		Alpha 32This field contains the item identifier.ICI4.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
#IPC-UPC PK
UPC		Alpha 15Universal Product Code.ICI4.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
#IPC-UOM SET6
UOM		Alpha 4This field contains the valid stock unit of measure for this item.ICI4.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
#IPC-UOM-COST
UOM_COST		Signed 18.5—ICI4.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
#IPC-UPC-TYPE
UPC_TYPE		Alpha 1Unverversal Product Code type.
  • P Primary
ICI4.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
#IPC-ZERO-SUPP-FL
ZERO_SUPP_FL		Alpha 6Indicates whether leading zeros on the UPC need to be suppressed.ICI4.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
#IPC-USE-SALE-UOM
USE_SALE_UOM		Alpha 1Use sale unit of measure flag.
  • N No
  • Y Yes
ICI4.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
#IPC-SALE-BY-MFG
SALE_BY_MFG		Alpha 1Sale by manufacturer flag.
  • N No
  • Y Yes
ICI4.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
#IPC-SALE-BY-DISTR
SALE_BY_DISTR		Alpha 1Sale by distributor flag.
  • N No
  • Y Yes
ICI4.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
#IPC-ITEM-TYPE-UPC
ITEM_TYPE_UPC		Derived——

Indexes (4)

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
IPCSET1
  1. ITEM-GROUP
  2. ITEM
  3. UPC
PrimaryIC11.1, IC11.2, IC511, IC598, IC800, ICI4.1, ICI8.1, PO150 +22 more (list truncated in source)
IPCSET2
  1. UPC
  2. ITEM-GROUP
ICI4.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
IPCSET5
  1. ITEM-GROUP
  2. UPC
SubsetWhere UPC != SpacesICI4.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1, WH20.2, WH20.7
IPCSET6
  1. ITEM-GROUP
  2. ITEM
  3. UOM
  4. UPC
IC11.1, ICI4.1, ICI8.1, POI7.1, RQIC.1, RQID.1, RQIF.1, RQIG.1 +6 more

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ItemupctoitemITEMMASTRequired
IPC-ITEM-GROUP→ITE-ITEM-GROUP
IPC-ITEM→ITE-ITEM

Programs

Updated by (10)

Referenced by (47)