Some Digging In Tables Of Acumatica

Hello everybody,

today I want to document one useful sql query that can be beneficial for cases if you need to dig in Acumatica tables, and need quickly to find type of some particular column.

Here it is:

select * from information_schema.columns where table_name = 'SOLine' and COLUMN_NAME like '%OrderQty%'

that sql will let you know all information about column OrderQty.

Ready to take your Acumatica experience to the next level? If this SQL tip helped you uncover valuable insights, imagine what a tailored customization could do for your business! Whether it’s optimizing workflows, enhancing reporting, or integrating unique features, we’re here to bring your vision to life. Leave a customization request today and let’s build the solution that fits your needs perfectly. Your Acumatica system, your way—let’s make it happen!