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.

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

IndexKeysFlagsConditionUsed in
ISKSET1ITEM-GROUP, ITEM, SKUPrimaryIC11.1, IC11.5, IC511, IC598, IC800, ICI7.1, ICI8.1, PO150 +11 more
ISKSET2SKU, ITEM-GROUPICI7.1, ICI8.1, PO150, PO25.6, PO25.7, PO26.4, PO26.5, PO26.8 +7 more
ISKSET5ITEM-GROUP, SKUSubsetWhere SKU != SpacesICI7.1, ICI8.1, RQID.1, RQIF.1, RQIH.1, RQIJ.1
ISKSET6ITEM-GROUP, ITEM, UOM, SKUIC11.1, ICI7.1, ICI8.1, RQIC.1, RQID.1, RQIF.1, RQIG.1, RQIH.1 +5 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
ItemskutoitemITEMMASTRequiredISK-ITEM-GROUP → ITE-ITEM-GROUP, ISK-ITEM → ITE-ITEM

Programs

Updated by (10)

Referenced by (16)