Forums › Cached › Customization › Reporting › SuiteAnalytics Connect (ODBC)

This topic contains 0 replies, has 0 voices, and was last updated by cduffyaz4 8 years, 5 months ago.

  • Author
    Posts
  • June 10, 2016 at 4:15 pm #8317

    cduffyaz4

    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.

  • Author
    Posts

You must be logged in to reply to this topic.