This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

I have the `internalid` of an address. This query gets the correct address name, internalid and nothing more.

`SELECT * FROM addressbook WHERE internalid = 12602053`

*What other table must I join to get the address detail? (label, city, zip, etc)*

Using ODBC I join `ADDRESS_BOOK` and `ADDRESSES`. In SuiteQL address or addresses doesn't seem to exist.

go to the records catalog to find the more useful entity and transaction addressbook related tables

So at least for me, the actual `address` table is not listed in the sidebar menu

if you manipulate the URL to end in /record_ss/Address you will find the definition

be extra careful that you know the difference between the id of the addressbook and the id of the address, they are different things

and they aren’t really truly JOINed I don’t think

what record are you trying to get addresses associated with, <@U03A2UBF6BE>?

that will determine the name of the table for the addressbook

OK well I don’t deal with those but it’s a similar method no matter what

Here’s an example to get addresses for a customer

```SELECT customer.id, customer.entityid,
customeraddressbook.internalid AS addressbook_id,
customeraddressbookentityaddress.addrText

FROM customer
JOIN customeraddressbook ON customeraddressbook.entity = customer.id
JOIN customeraddressbookentityaddress ON customeraddressbook.addressbookaddress = customeraddressbookentityaddress.nkey

WHERE customer.id = 265```

start in records catalog from the base record (in my example it’s customer)

Screenshot 2024-05-31 at 11.39.04 AM.png

then click here to follow the rabbit down the hold

the little i icon is _extremely_ helpful for figuring out your joins

Thanks <@U4TPAFXEC> Will put my SQL hat on

I could be wrong (<@U5TF1GQ20> might know) but I don’t think addresses _themselves_ have ids.

Done

The ID I have correspond to `customeraddressbook.internalid`

`customeraddressbook` doesnt have the columns I need, those are on `customeraddressbookentityaddress`

The join is between `customeraddressbook.addressbookaddress` AND `customeraddressbookentityaddress.nkey`

And the filter is `customeraddressbook.internalid` = my internal ID