We have a couple of optional fields set up in I/C on about 50K items that have not been used in years.

Can't delete then because "they are in use"

I want to clean this up and then set up one new valid optional field.

Are there any ramifications to deleting all the records in ICITEMO and then getting rid of the fields in Common Services, and starting from scratch?

What about the VALUES field in ICITEM - should it be updated to 0 to reflect that the optional fields no longer exist?

Any other related tables?

Running Sage 300 Premium 2019.