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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
How to pull the Shipping Address using ODBC?
Hi. I am using SuiteQL ODBC to show transaction details through the transaction, transactionLine, and entity tables from NetSuite2.
FROM transaction A
INNER JOIN transactionLine B ON B.transaction = A.ID
LEFT OUTER JOIN item C ON B.item = C.id
LEFT OUTER JOIN entity D ON B.entity = D.id
I am able to get all my transaction details I need (customer, parent, item, etc.), but I cannot find what table to join to that does not produce null results for address, city, state, & zip. I accomplished this from NetSuite1 through the transaction_address table, but I am hitting nothing but walls with NetSuite2. Is anyone able to help?
0