Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
NetSuite has launched SuiteSuccess Wholesale Distribution Edition, in Japan. Please join us the webinar on February 12 that introduces NetSuite solution with demos and case studies for Wholesale Industry.
Register Now
Getting at Billing and Shipping zipcodes for transactions via ODBC
Does anyone know how to get the billing and shipping zipcodes for a sales order transaction via ODBC?
In the GUI (reports and searches), I can access these fields easily, but I'm having a hard time on the ODBC side since I can't find an apparent link from the sales order transaction to the appropriate address book entry for the entity (customer)
The ODBC TRANSACTIONS view has a text representation of the entire addresses (including customer name)m but I don't really want to build an address parser since the data is in there somewhere.
I can join the TRANSACTIONS view to the ENTITY view with ENTITY_ID, but this doesn't give me a clue as to which address in the address book may have been used for that particular transaction