Table 5717 Item Cross Reference in 23
- App
- Base Application
- Namespace
- Microsoft.Inventory.Item.Catalog
- Obsolete
- Removed 22.0. Replaced by ItemReference table as part of Item Reference feature.
Versions171819202122232425262728latest
Source-
Fields, 9
| Id | Name | Type | Obsolete |
|---|---|---|---|
| 1 | Item No. | Code[20] | - |
| 2 | Variant Code | Code[10] | - |
| 3 | Unit of Measure | Code[10] | - |
| 4 | Cross-Reference Type | Option | - |
| 5 | Cross-Reference Type No. | Code[30] | - |
| 6 | Cross-Reference No. | Code[20] | - |
| 7 | Description | Text[100] | - |
| 8 | Discontinue Bar Code | Boolean | - |
| 9 | Description 2 | Text[50] | - |
Keys, 6
| Name | Fields | Obsolete |
|---|---|---|
| Key1, clustered | Item No., Variant Code, Unit of Measure, Cross-Reference Type, Cross-Reference Type No., Cross-Reference No. | - |
| Key2 | Cross-Reference No. | - |
| Key3 | Cross-Reference No., Cross-Reference Type, Cross-Reference Type No., Discontinue Bar Code | - |
| Key4 | Cross-Reference Type, Cross-Reference No. | - |
| Key5 | Item No., Variant Code, Unit of Measure, Cross-Reference Type, Cross-Reference No., Discontinue Bar Code | - |
| Key6 | Cross-Reference Type, Cross-Reference Type No. | - |