Lawson Insight Technical Documentation

                              ITEMSUB FILE

                            Item Substitute

The Item Substitute file stores valid substitutes for an item.

REFERENCED BY

BL120     BL122     BL130     BL20.1    BL20.3    BL21.2
BL21.5    BL29.1    BL29.2    BL520     BL820     BL92.1
IC11.1    IC213     RQ10.1    RQ10.3    RQ11.1    RQ35.1
RQ500     RQIC.1    RQID.1    RQIF.1    RQIG.1    RQIH.1
RQIJ.1    WH110     WH20.2    WH20.7

UPDATED BY

IC13.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ITS-ITEM-GROUP         Alpha 5                                   IC13.1
Element: Item Group    This field contains the identifier for
                       a group of items that can be shared by
                       one or more companies.

ITS-ITEM               Alpha 32                                  IC13.1
Element: Item          This field contains the item
                       identifier.

ITS-SUBTYPE            Alpha 1                                   IC13.1
Element: Subtype       C = Companion
                       S = Substitute

ITS-SUB-ITEM           Alpha 32                                  IC13.1
Element: Item          This field contains a valid item number
                       designated as a substitute item for the
                       key item.

ITS-ITEM-CODE-USED     Derived
Element: Item Code Used

                         ITEMSUB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITSSET1   ITEM-GROUP                                             BL120   BL122
          ITEM                                                   BL130   BL20.1
          SUBTYPE                                                BL20.3  BL21.2
          SUB-ITEM                                               BL21.5  BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 IC11.1  IC13.1
                                                                 IC213   RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ35.1  RQ500
                                                                 RQIC.1  RQID.1
                                                                 RQIF.1  RQIG.1
                                                                 RQIH.1  RQIJ.1
                                                                 WH110   WH20.2
                                                                 WH20.7

ITSSET2   ITEM-GROUP                                             IC13.1  IC213
          SUBTYPE
          ITEM
          SUB-ITEM

ITSSET3   ITEM-GROUP                                             IC11.1
          SUB-ITEM
          ITEM
          SUBTYPE

                         ITEMSUB FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemgroup      ITEMGROUP    Required

                            ITS-ITEM-GROUP    -> ITG-ITEM-GROUP

Itemmast       ITEMMAST     Required

                            ITS-ITEM-GROUP    -> ITE-ITEM-GROUP
                            ITS-ITEM          -> ITE-ITEM

Itemmaster     ITEMMAST     Required

                            ITS-ITEM-GROUP    -> ITE-ITEM-GROUP
                            ITS-ITEM          -> ITE-ITEM

Subitemmaster  ITEMMAST     Required

                            ITS-ITEM-GROUP    -> ITE-ITEM-GROUP
                            ITS-SUB-ITEM      -> ITE-ITEM