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.