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 |