ITEMSKU – Item SKU

System
Inventory Control (IC)
Prefix
ISK
Primary key
ITEM-GROUP, ITEM, SKU
Fields
16
Updated by
10 programs
Referenced by
16 programs

ITEMSKU is the Item SKU table in Lawson Inventory Control (prefix ISK). It is indexed by ITEM-GROUP, ITEM, SKU (ISKSET1); alternate indexes: ISKSET2, ISKSET5 and ISKSET6. It is related 1:1 to ITEMMAST. It is updated by ICI7.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8, PO28.2 and 2 more and referenced by IC11.1, IC11.5, IC511, IC598, IC800, ICI8.1, RQIC.1, RQID.1 and 8 more. The table has 16 fields, 4 indexes and 1 documented relation.

About ITEMSKU

The Item SKU file contains the SKU information related to an item in the Item Master file.

Fields (16)

Column = COBOL field name without the ISK- 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
#ISK-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.ICI7.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
#ISK-ITEM PK
ITEM		Alpha 32This field contains the item identifier.ICI7.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
#ISK-SKU PK
SKU		Alpha 15SKU identifier.ICI7.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
#ISK-UOM SET6
UOM		Alpha 4This field contains the valid stock unit of measure for this item.ICI7.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
#ISK-UOM-COST
UOM_COST		Signed 18.5—ICI7.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
#ISK-SALE-BY-MFG
SALE_BY_MFG		Alpha 1Sale by manufacturer flag.
  • N No
  • Y Yes
ICI7.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
#ISK-SALE-BY-DISTR
SALE_BY_DISTR		Alpha 1Sale by distributor flag.
  • N No
  • Y Yes
ICI7.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
#ISK-DESCRIPTOR
DESCRIPTOR		Alpha 12—ICI7.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
#ISK-VEN-CASE-CD
VEN_CASE_CD		Alpha 11Vendor case code.ICI7.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
#ISK-PRODUCT-CD
PRODUCT_CD		Alpha 2Product code.ICI7.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
#ISK-INVOICE-BREAK
INVOICE_BREAK		Alpha 1Invoice break flag.ICI7.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
#ISK-SHELF-LBL-CD
SHELF_LBL_CD		Alpha 1Shelf label code.ICI7.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
#ISK-COLOR-CD
COLOR_CD		Alpha 10—ICI7.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
#ISK-SIZE-CD
SIZE_CD		Alpha 10—ICI7.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
#ISK-STYLE-CD
STYLE_CD		Alpha 10—ICI7.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
#ISK-ITEM-TYPE-SKU
ITEM_TYPE_SKU		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
ISKSET1
  1. ITEM-GROUP
  2. ITEM
  3. SKU
PrimaryIC11.1, IC11.5, IC511, IC598, IC800, ICI7.1, ICI8.1, PO150 +11 more
ISKSET2
  1. SKU
  2. ITEM-GROUP
ICI7.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
ISKSET5
  1. ITEM-GROUP
  2. SKU
SubsetWhere SKU != SpacesICI7.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
ISKSET6
  1. ITEM-GROUP
  2. ITEM
  3. UOM
  4. SKU
IC11.1, ICI7.1, ICI8.1, RQIC.1, RQID.1, RQIF.1, RQIG.1, RQIH.1 +5 more

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ItemskutoitemITEMMASTRequired
ISK-ITEM-GROUP→ITE-ITEM-GROUP
ISK-ITEM→ITE-ITEM

Programs

Updated by (10)

Referenced by (16)