I am sure that you have used the following functionality within Sage 500 ERP already: Vendor Items and Customer Items. This allows you to create a link between your items and your customer and vendor items. This information is stored in the following table timItemAliasCat and timItemAlias.
If you look at the information in the Schema Browser for table timItemAliasCat under the field AliasType you will see that you have a User-Defined option for alias category.
If you run the following SELECT you will see they actually have some 0 defined AliasType records already.
Sage 500 ERP does not have a User Interface for you to perform maintenance for this AliasType but it does not mean that you are not able to use it. You would have to import this information yourself or build your own UI to perform maintenance of the base table but then you could use this information to create views for BI or use it on labels, reports, forms, etc. The timItemAliasCat table is a Parent table of the following tables: (see the Schema Browser for more definition on these tables)
- timCustItemAliasCat – Contains a list of Item Alias Categories that can be used for Customers. Use this for items with an AliasType of 1.
- timVendItemAliasCat – Contains a list of Item Alias Categories that can be used for Vendors. Use this for items with an AliasType of 2.
- timItemAlias – Contains alternative Item IDs and Item Numbers. Each item in the Item table can have an unlimited number of alternate IDs in this table. Each of these records belong to a category of alias numbers, meaning 0, 1, 2. So records in this table that are attached to a 0 AliasType do not need any records in the first 2 tables but you can use them. You could also create multiple ItemAliasCat records with a 0 AliasType. You can give each of them their own unique ID and Description plus they will have their own key.
You create a record in the timItemAliasCat table for example:
I have seen this used in the auto parts industry to create cross-reference items for the same part number but different manufacturers part number.