Sample SQL query to verify the Table Structure Answer:
SELECT * FROM OA_COLUMNS WHERE TABLE_NAME='{tablename}'
- OA_COLUMNS is a system audit table that list all the table structure of a NetSuite account. This table is default hidden when viewing the schema catalog.
This is very helpful. Thanks!
ReplyDelete