ITEMSUB FILE
Item Substitute
The Item Substitute file stores valid substitutes for an item.
REFERENCED BY
DR100 IC11.1 IC141 IC142 IC213 IC83.1
SEA1.1 RQ11.1 SEA3.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-SUBTYPE Alpha 1 IC13.1
Subtype C = Companion
S = Substitute
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 DR100 IC11.1
ITEM IC13.1 IC141
SUBTYPE IC142 IC213
SUB-ITEM IC83.1 SEA1.1
RQ11.1 SEA3.1
ITSSET2 ITEM-GROUP IC13.1 IC213
SUBTYPE
ITEM
SUB-ITEM
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
|
