Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ITEMSKU


                              ITEMSKU FILE

                                Item SKU

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

REFERENCED BY

IC11.1    IC11.5    IC800     ICI8.1    RQID.1    RQIF.1
RQIH.1    RQIJ.1    RQIC.1    RQIG.1

UPDATED BY

ICI7.1    PO150     PO25.6    PO25.7    PO36.2    PO536


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ISK-ITEM-GROUP         Alpha 5                                   ICI7.1  ICI8.1
Element: Item Group    This field contains the identifier for    PO150   PO25.6
                       a group of items that can be shared by    PO25.7  PO36.2
                       one or more companies.                    PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

ISK-ITEM               Alpha 32                                  ICI7.1  ICI8.1
Element: Item          This field contains the item              PO150   PO25.6
                       identifier.                               PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

ISK-SKU                Alpha 15                                  ICI7.1  ICI8.1
Element: Sku           SKU identifier.                           PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

ISK-UOM                Alpha 4                                   ICI7.1  ICI8.1
Element: Uom           This field contains the valid stock       PO150   PO25.6
                       unit of measure for this item.            PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

ISK-UOM-COST           Signed 18.5                               ICI7.1  ICI8.1
Element: Intl Cost                                               RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

ISK-SALE-BY-MFG        Alpha 1                                   ICI7.1  ICI8.1
Element: Sale By Mfg   Sale by manufacturer flag.                PO150   PO25.6
                       N = No                                    PO25.7  PO36.2
                       Y = Yes                                   PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

ISK-SALE-BY-DISTR      Alpha 1                                   ICI7.1  ICI8.1
Element: Sale By Distr Sale by distributor flag.                 PO150   PO25.6
                       N = No                                    PO25.7  PO36.2
                       Y = Yes                                   PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

ISK-DESCRIPTOR         Alpha 12                                  ICI7.1  ICI8.1
Element: Descriptor                                              RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

ISK-VEN-CASE-CD        Alpha 11                                  ICI7.1  ICI8.1
Element: Ven Case Cd   Vendor case code.                         RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

ISK-PRODUCT-CD         Alpha 2                                   ICI7.1  ICI8.1
Element: Product Cd    Product code.                             RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

ISK-INVOICE-BREAK      Alpha 1                                   ICI7.1  ICI8.1
Element: Invoice Break Invoice break flag.                       RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

ISK-SHELF-LBL-CD       Alpha 1                                   ICI7.1  ICI8.1
Element: Shelf Lbl Cd  Shelf label code.                         RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

ISK-COLOR-CD           Alpha 10                                  ICI7.1  ICI8.1
Element: Color Cd                                                RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

ISK-SIZE-CD            Alpha 10                                  ICI7.1  ICI8.1
Element: Size Cd                                                 RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

ISK-STYLE-CD           Alpha 10                                  ICI7.1  ICI8.1
Element: Style Cd                                                RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

ISK-ITEM-TYPE-SKU      Derived
Element: Item Type Sku

                         ITEMSKU FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ISKSET1   ITEM-GROUP                                             IC11.1  IC11.5
          ITEM                                                   IC800   ICI7.1
          SKU                                                    ICI8.1  PO150
                                                                 PO25.6  PO25.7
                                                                 PO36.2  PO536
                                                                 RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

ISKSET2   SKU                                                    ICI7.1  ICI8.1
          ITEM-GROUP                                             PO150   PO25.6
                                                                 PO25.7  PO36.2
                                                                 PO536   RQID.1
                                                                 RQIF.1  RQIH.1
                                                                 RQIJ.1

ISKSET5   ITEM-GROUP    Subset                                   ICI7.1  ICI8.1
          SKU           Where SKU != Spaces                      RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

ISKSET6   ITEM-GROUP                                             ICI7.1  ICI8.1
          ITEM                                                   RQIC.1  RQID.1
          UOM                                                    RQIF.1  RQIG.1
          SKU                                                    RQIH.1  RQIJ.1

                         ITEMSKU FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemskutoitem  ITEMMAST     Required

                            ISK-ITEM-GROUP    -> ITE-ITEM-GROUP
                            ISK-ITEM          -> ITE-ITEM