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

Hi, I can't find a linkage field between the address book to the entity. For example, for transaction lines, I can find from each line the internal id of the transaction itself. Shouldn't it be the same for an address book and it's entity?

```SELECT (whatever you want to select)

FROM transaction
JOIN entity ON (transaction.entity = entity.id)
LEFT JOIN entityaddressbook ON (entityaddressbook.entity = entity.id
-- AND entityaddressbook.defaultbilling = 'T'
-- AND entityaddressbook.defaultshipping = 'T'
)
LEFT JOIN entityaddress```