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


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

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