ITEMSUB FILE

                            Item Substitute

The Item Substitute file stores valid substitutes for an item.

REFERENCED BY

BL92.1    CX20.4    DR100     IC11.1    IC141     IC142
IC213     IC83.1    SEA1.1    OE10.1    OE10.2    OE10.3
OE10.4    OE10.5    OE10.6    OE10.7    OE10.8    OE11.1
OE11.4    OE11.8    OE11.9    OE110     OE113     OE114
OE129     OE14.4    OE15.1    OE15.2    OE15.3    OE15.4
OE15.5    OE15.7    OE510     OE810     OE920     RQ10.1
RQ10.3    RQ11.1    RQ20.1    RQ35.1    RQ500     SEA3.1
WH20.2    WH20.7    WO30.1

UPDATED BY

IC13.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ITS-ITEM-GROUP       Alpha 5                                     IC13.1
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
Item Number          This field contains the item identifier.

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

                         ITEMSUB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ITSSET1   ITEM-GROUP                                             BL92.1  CX20.4
          ITEM                                                   DR100   IC11.1
          SUB-ITEM                                               IC13.1  IC141
                                                                 IC142   IC213
                                                                 IC83.1  SEA1.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 OE110   OE113
                                                                 OE114   OE129
                                                                 OE14.4  OE15.1
                                                                 OE15.2  OE15.3
                                                                 ...

                         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