| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP40: Inventory/OP Base |
| 1 | F41001 | Inventory Constants | 54 | CI | XRT2 | Type - Cross-Reference Type Code | String | UDC | 2 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
TOPUDC 41 / DT (Cross Reference Type Code) stock values
| Value | Description | Special Handling Code | Hard Coded |
|---|
| 1 | | . | N | N |
| 2 | A | Associated Products | | N |
| 3 | B | Bar Codes | | |
| 4 | C | Customer Part Numbers | | |
| 5 | M | Manufacturer Part Number | | |
| 6 | MR | Master Routings | | |
| 7 | P | Preferred Items | | Y |
| 8 | PP | Purchasing Promotional Item | 2 | N |
| 9 | R | Replacements | | |
| 10 | S | Substitutes | | |
| 11 | SP | Sales Promotional Item | 1 | N |
| 12 | SS | SUPERSEDING PART | | N |
| 13 | UP | UPC/EAN code in Aggregate SCC | | N |
| 14 | VN | Vendor Part Number | | |
