ITEMSUB FILE
Item Substitute
The Item Substitute file stores valid substitutes for an item.
REFERENCED BY
IC11.1 IC213 SEA1.1 RQ10.1 RQ10.3 RQ11.1
RQ35.1 SEA3.1 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 IC11.1 IC13.1
ITEM IC213 SEA1.1
SUBTYPE RQ10.1 RQ10.3
SUB-ITEM RQ11.1 RQ35.1
SEA3.1 WH110
WH20.2 WH20.7
WO30.1
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
|
