Hello, I am new to querying NetSuite and I am a bit stuck and I was wondering if anyone here knew a little more than me.
What I am trying to do is query against Work Orders to get the item_id of what is being worked on and the qty. I have a linked server on our SQL server and the role the ODBC Driver is using is the Web Services Admin. I looked in multiple tables and found something with work orders in the AM_Production_Run, Summary, and Result tables. However it is random Work Orders in there and not new ones that were created. At least as far as I can tell by create dates and missing work order numbers.
So my question being, where are all work orders stored if in these tables at all, or can someone point me in the right direction.
Thanks in advanced.