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 all, I'm struggling on get *only* the default Billing address from an Employee record.  Any hints?

Have you tried something like
```SELECT {fields}
FROM entityaddressbook
WHERE
  entity = {employeeInternalId} AND
  defaultbilling = 'T'```

From what I can tell, the `entity` table is a superset of customers, contacts, vendors, employees, and partners (maybe including other names and competitors?) with a single pool of internalids

I ended up doing this
```SELECT 
	employeeaddressbookentityaddress.addr1 AS strStreet,
	employeeaddressbookentityaddress.country AS strCountryCode,
	employeeaddressbookentityaddress.state AS strState,
	employeeaddressbookentityaddress.city AS strCity,
	employeeaddressbookentityaddress.zip AS strPostCode
FROM
	Employee
	LEFT OUTER JOIN employeeaddressbook on (employee.id = employeeAddressbook.entity) AND (employeeaddressbook.defaultbilling = 'T')
	LEFT OUTER JOIN employeeaddressbookentityaddress ON (employeeAddressbook.addressbookaddress = employeeAddressbookEntityAddress.nkey)
	```