Lawson Insight Technical Documentation

                              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     ICI8.1    RQIC.1    RQID.1
RQIG.1    RQIH.1

UPDATED BY

ICI7.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ISK-ITEM-GROUP       Alpha 5                                     ICI7.1  ICI8.1
Item Group           This field contains the identifier for      RQID.1  RQIH.1
                     a group of items that can be shared by
                     one or more companies.

ISK-ITEM             Alpha 32                                    ICI7.1  ICI8.1
Item Number          This field contains the item                RQID.1  RQIH.1
                     identifier.

ISK-SKU              Alpha 15                                    ICI7.1  ICI8.1
SKU Identifier       SKU identifier.                             RQID.1  RQIH.1

ISK-UOM              Alpha 4                                     ICI7.1  ICI8.1
Unit of Measure      This field contains the valid stock         RQID.1  RQIH.1
                     unit of measure for this item.


ISK-UOM-COST         Signed 13.5                                 ICI7.1  ICI8.1
Unit of Measure Cost Unit of measure cost.                       RQID.1  RQIH.1

ISK-SALE-BY-MFG      Alpha 1                                     ICI7.1  ICI8.1
Sale by Manufacturer Sale by manufacturer flag.                  RQID.1  RQIH.1
                     N = No
                     Y = Yes

ISK-SALE-BY-DISTR    Alpha 1                                     ICI7.1  ICI8.1
Sale by Distributor  Sale by distributor flag.                   RQID.1  RQIH.1
                     N = No
                     Y = Yes

ISK-DESCRIPTOR       Alpha 12                                    ICI7.1  ICI8.1
Descriptor                                                       RQID.1  RQIH.1

ISK-VEN-CASE-CD      Alpha 11                                    ICI7.1  ICI8.1
Vendor Case Code     Vendor case code.                           RQID.1  RQIH.1

ISK-PRODUCT-CD       Alpha 2                                     ICI7.1  ICI8.1
Product Code         Product code.                               RQID.1  RQIH.1

ISK-INVOICE-BREAK    Alpha 1                                     ICI7.1  ICI8.1
Invoice Break        Invoice break flag.                         RQID.1  RQIH.1

ISK-SHELF-LBL-CD     Alpha 1                                     ICI7.1  ICI8.1
Shelf Label Code     Shelf label code.                           RQID.1  RQIH.1

ISK-COLOR-CD         Alpha 10                                    ICI7.1  ICI8.1
Color Cd                                                         RQID.1  RQIH.1

ISK-SIZE-CD          Alpha 10                                    ICI7.1  ICI8.1
Size Cd                                                          RQID.1  RQIH.1

ISK-STYLE-CD         Alpha 10                                    ICI7.1  ICI8.1
Style Cd                                                         RQID.1  RQIH.1

                         ITEMSKU FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ISKSET1   ITEM-GROUP                                             IC11.1  IC11.5
          ITEM                                                   IC598   ICI7.1
          SKU                                                    ICI8.1  RQIC.1
                                                                 RQID.1  RQIG.1
                                                                 RQIH.1

ISKSET2   SKU                                                    ICI7.1  ICI8.1
                                                                 RQID.1  RQIH.1

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

ISKSET6   ITEM-GROUP                                             ICI7.1  ICI8.1
          ITEM                                                   RQID.1  RQIH.1
          UOM
          SKU

                         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