Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Update: Narrative Insights has been restored and is now available.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.
AE: ODBC NetSuite2.com transactionaccountingline vs. transactionLine
What is the difference between transactionLine and transactionaccountingline ?
And what is the connection (join) between them?
I think that the PK in transactionaccountingline is: accountingbook + transactionline + transaction
But in the transactionLine - I don't see any PK. I see there some "double" records that all the fields have same values. And I just hate to do DISTINCT on transaction tables.
I wanted to use just transactionaccountingline but it doesn't have all the properties I need: item, department...
In the old Netsuite.com ODBC there was one TRANSACTION_LINES table and it was very convenient to work with.
So what is the correct way to select the transaction lines data in the new Netsuite2.com?
Tagged:
0