hello, we are trying to get all the data from netsuite to a datawarehouse. Upon looking into the data closely, I wasn't able to find the Approval Status (native field) data associated to Transactions (purchase order in our case). How can I get this data? Is it associated with a different table? If so, what is the table called?

Do you mean like

Fully Billed

,

Partially Received

etc? Isn’t that just the

status

field?

I am looking for Approval Status like Approved, Rejected and Pending Approval.

oh I see, we use ours differently

Yup I see it in saved searches and reports, however the schema I have for the raw netsuite database does not have approvalstatus available in the transaction table.

some of the schemas I’ve come across have been unreliable

got it, I will probably open a case with them