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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IPCSET1ITEM-GROUP, ITEM, UPCPrimaryIC11.1, IC11.2, IC511, IC598, IC800, ICI4.1, ICI8.1, PO150 +22 more (list truncated in source)
IPCSET2UPC, ITEM-GROUPICI4.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
IPCSET5ITEM-GROUP, UPCSubsetWhere UPC != SpacesICI4.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1, WH20.2, WH20.7
IPCSET6ITEM-GROUP, ITEM, UOM, UPCIC11.1, ICI4.1, ICI8.1, POI7.1, RQIC.1, RQID.1, RQIF.1, RQIG.1 +6 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ItemupctoitemITEMMASTRequiredIPC-ITEM-GROUP → ITE-ITEM-GROUP, IPC-ITEM → ITE-ITEM

Programs

Updated by (10)

Referenced by (47)