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    IC598     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 Number   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 IdentifierSKU 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: Unit of MeasurThis 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     Unit of measure cost.                     RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

ISK-SALE-BY-MFG        Alpha 1                                   ICI7.1  ICI8.1
Element: Sale by ManufaSale 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 DistriSale 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: Vendor Case CoVendor case code.                         RQID.1  RQIF.1
                                                                 RQIH.1  RQIJ.1

ISK-PRODUCT-CD         Alpha 2                                   ICI7.1  ICI8.1
Element: Product Code  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 Label CoShelf 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                                                   IC598   IC800
          SKU                                                    ICI7.1  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                      RQIC.1  RQID.1
                                                                 RQIF.1  RQIG.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