Hi everyone When we query using SuiteQl (select * from Customer) , does the order in which the columns are sent back the same each time ? If not how do I enforce the ordering of the columns ?

ORDER BY

Interesting question. My experience says that * returns de columns in the order of the table definition, but in NetSuite it will change if later you remove or add a custom field, thus modifying the column order. No idea if this is documented.

The order of the columns? You'd need to specify the actual column names, not * in the SELECT.

Yes, but to specify all 84 of them would be a task Thanks for all your replies

It would be a valuable task.