Item Substitute
The Item Substitute file stores valid substitutes for an item.
REFERENCED BY
IC13.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
ITS-ITEM-GROUP Element: Item Group | Alpha 5 This field contains the identifier for a group of items that can be shared by one or more companies. |
|
||
ITS-ITEM Element: Item | Alpha 32 This field contains the item identifier. |
|
||
ITS-SUBTYPE Element: Subtype | Alpha 1 C = Companion S = Substitute |
|
||
ITS-SUB-ITEM Element: Item | Alpha 32 This field contains a valid item number designated as a substitute item for the key item. |
|
||
ITS-ITEM-CODE-USED Element: Item Code Used | Derived |
|
||
ITS-EFFECT-DT Element: Date | Numeric 8 (yyyymmdd) This is the first date that this item should be used as a Substitute / Complementary item. |
|
||
ITS-EXPIRE-DT Element: Date | Numeric 8 (yyyymmdd) This is the last date that this item should be used as a Substitute / Complementary item. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
ITSSET1 |
ITEM-GROUP ITEM SUBTYPE SUB-ITEM |
|
|||||||||
ITSSET2 |
ITEM-GROUP SUBTYPE ITEM SUB-ITEM |
|
| ||||||||
ITSSET3 |
ITEM-GROUP SUB-ITEM ITEM SUBTYPE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Itemgroup | ITEMGROUP |
Required
| ||||||
Itemmast | ITEMMAST |
Required
| ||||||
Itemmaster | ITEMMAST |
Required
| ||||||
Subitemmaster | ITEMMAST |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.