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 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 OE111 OE113
OE114 OE116 OE129 OE13.2 OE13.3 OE13.5
OE13.6 OE14.4 OE30.1 OE30.2 OE30.3 OE30.4
OE30.5 OE30.6 OE30.7 OE30.9 OE510 OE530
OE810 OE830 WH110 WH20.2 WH20.7 WO30.1
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 Number 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 Number 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 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 OE111
...
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
|