Addresses

The Addresses table contains information about all address instances. Any custom fields added to an address can be accessed from the Addresses table.

Columns

Name	Type	Length	Precision	Scale	References	In	Description
address	VARCHAR2	999					Full address text. NetSuite creates this field by combining the address fields.
address_id	NUMBER		39	0			Address ID
address_line_1	VARCHAR2	150					Address line 1
address_line_2	VARCHAR2	150					Address line 2
address_line_3	VARCHAR2	150					Address line 3
attention	VARCHAR2	150					Attention
city	VARCHAR2	50					City
company	VARCHAR2	100					Company
country	VARCHAR2	50					Country
date_last_modified	TIMESTAMP						Date last modified
is_overridden	VARCHAR2	3					Whether manually-defined address text is used instead of the address text generated by NetSuite.
phone	VARCHAR2	100					Phone number
state	VARCHAR2	50					State
zip	VARCHAR2	36					Zip code

Primary key

PK Column Name
address_id

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Address_book_addresses_fk	address_id	Address_book	address_id	1