Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
Unbilled Receivable Adjustment Journal Entry Line link to Revenue Element
I am working with ODBC Netsuite2.com data source.
I need to know the source of Unbilled Receivable Adjustment Journal Entry Lines
I do see "createdfrom" column in the transactionline table but it contains only the transaction id of the Revenue Arrangement, not the id of the Revenue Element/Plan.
What is the link (foreign key columns) that connects transactionline of the Unbilled Receivable Adjustment Journal Entry Line to Revenue Element/Plan that triggered it?
Or, maybe, there is a dedicated table that manages Revenue Element (or Plan) to Unbilled Receivable Adjustment Journal Entry Lines connection?
I know that some fields/columns are not visible to ODBC out-of-the-box, so if there is such a field which is not visible, please tell me what it is and I'll ask the developer to add as custom column.