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.
SuiteAnalytics Connect - isResidential (Addressbook)
So,
I need to pull the ship/bill address from a sales order ... no problem. But, I also need to extract the 'isResidential' fields, which I don't see anywhere. Here's what I got so far ...
SELECT TRANSACTION_ADDRESS.SHIP_COUNTRY AS ShipCountry, TRANSACTION_ADDRESS.SHIP_ATTENTION AS ShipAttention, TRANSACTION_ADDRESS.SHIP_ADDRESS_LINE_1 AS ShipAddr1, TRANSACTION_ADDRESS.SHIP_ADDRESS_LINE_2 AS ShipAddr2, TRANSACTION_ADDRESS.SHIP_ZIP AS ShipZip, TRANSACTION_ADDRESS.SHIP_STATE AS ShipState, TRANSACTION_ADDRESS.SHIP_CITY AS ShipCity, TRANSACTION_ADDRESS.SHIP_COMPANY AS ShipCompany, REGEXP_SUBSTR(TRANSACTION_ADDRESS.SHIP_PHONE_NUMBER, '(.*)x?') AS ShipPhone, REGEXP_SUBSTR(TRANSACTION_ADDRESS.SHIP_PHONE_NUMBER, 'x(.*)') AS ShipPhoneExt, TRANSACTION_ADDRESS.BILL_COUNTRY AS BillCountry, TRANSACTION_ADDRESS.BILL_ADDRESS_LINE_1 AS BillAddr1, TRANSACTION_ADDRESS.BILL_ADDRESS_LINE_2 AS BillAddr2, TRANSACTION_ADDRESS.BILL_ZIP AS BillZip, TRANSACTION_ADDRESS.BILL_STATE AS BillState, TRANSACTION_ADDRESS.BILL_CITY AS BillCity, TRANSACTION_ADDRESS.BILL_COMPANY AS BillCompany, REGEXP_SUBSTR(TRANSACTION_ADDRESS.BILL_PHONE_NUMBER, '(.*)x?') AS BillPhone, REGEXP_SUBSTR(TRANSACTION_ADDRESS.BILL_PHONE_NUMBER, 'x(.*)') AS BillPhoneExt, TRANSACTIONS.TRANID AS OrderNum, TRANSACTIONS.RELATED_TRANID AS PONum, EMPLOYEES.EMAIL AS SalesRepEmail FROM Administrator.TRANSACTIONS TRANSACTIONS INNER JOIN Administrator.TRANSACTION_ADDRESS TRANSACTION_ADDRESS ON TRANSACTIONS.TRANSACTION_ID = TRANSACTION_ADDRESS.TRANSACTION_ID INNER JOIN Administrator.EMPLOYEES EMPLOYEES ON TRANSACTIONS.SALES_REP_ID = EMPLOYEES.EMPLOYEE_ID WHERE TRANSACTIONS.TRANID = 'SO-28633'
0