Item Substitute
The Item Substitute file stores valid substitutes for an item.
REFERENCED BY
| CX20.4 |
| DR100 | IC11.1 | IC13.1 | IC141 | IC142 | IC213 |
| IC83.1 | RQ10.1 | RQ10.3 | RQ10.4 | RQ11.1 | RQ35.1 |
| RQ500 | RQIC.1 | RQID.1 | RQIF.1 | RQIG.1 | RQIH.1 |
| RQIJ.1 | WH110 | WH20.2 | WH20.7 |
| 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 |
|
| 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.