I am working with SQL queries from ODBC Netsuite2.com Suite Analytics and I want to get the Invoice statuses that I see next to the Invoice Number in the UI.
For example - "Paid in Full", "Open", etc.
I tried to find this field in the "transaction" table, but couldn't find.
What table/field should I check?