We are using ODBC Connector from NetSuite to Access database and creating a Revenue Waterfall report. We need to SQL to link the Sales Order Revenue Commitment and the Invoice. We can find the field in the UI>Transaction search, Type = Sales Order> Field – Revenue Committing Transaction: Internal ID but cannot find the field in the Schema. Basically, I’m looking for the SQL statement that says this “invoice” transaction is linked to this revenue commitment line(s). In the UI>Transaction Search, Type = Sales Order> Field – Revenue Committing Transaction: Internal ID
This is a cached copy. Click here to see the original post.