Change Data Field Format

Hello!

I am working with the PartPlant table in epicor and need to change the format to allow more decimals in a certain column. However, everywhere I’ve looked says to do this with a direct sql update, which I know is not the best way to go about this. Any one out there done this before?

1 Like

Recommendation:
To expand your format capabilities, I recommend utilising the Extended Properties Maintenance feature within Epicor. This approach ensures alignment with best practices and system integrity.

Caution:
I strongly advise against performing direct SQL updates, as they can compromise data integrity, bypass business logic, and may lead to unsupported system states.

1 Like

Thank you!

And yes, I avoid direct SQL updates at all costs!

1 Like

So, from my understanding, editing the format like so will change the format in the database, and the default format is just what it comes set up with?

Yes, you would modify the format here but if I remember correctly, you can’t go larger than the default.

Give it go and see if it moans.

1 Like

Well I saved it and it didn’t give me an issue, but I assume I will have to regenerate the data model before anything actually changes in the database.

1 Like

Kelsey Grammer Drinking GIF by Paramount+

1 Like