If we add an Index to a table, will the table be added to the skipped list on the next Upgrade?
We are considering importing UNSPSC Codes into the vendor_type table.
I am considering adding a new field for the UNSPSC Code and then adding the Description for the code in the 'name' field.
But then I thought, why create a new field?
Why not add the UNSPSC code and the description into the existing 'name' field so the value becomes something like:
80103029- Butter
I would then need to add an index to the "name" field. There are 21,000 UNSPSC Codes that I would need to load.
