Each row of this table represents a store address. StoreEntities, FulfillmentCenters, and Vendors can have store addresses. Sore addresses can be staged using the staging server.
Column Descriptions
| Column Name
| Column Type
| Description
|
| STADDRESS_ID
| INTEGER NOT NULL
| Generated unique key.
|
| ADDRESS1
| VARCHAR(50)
| The first line of the store address.
|
| MEMBER_ID
| BIGINT NOT NULL
| The owner of this address.
|
| ADDRESS2
| VARCHAR(50)
| The second line of the store address.
|
| ADDRESS3
| VARCHAR(50)
| The third line of the store address.
|
| CITY
| VARCHAR(128)
| The city within this address.
|
| COUNTRY
| VARCHAR(128)
| The country or region within this address.
|
| EMAIL1
| VARCHAR(254)
| The primary e-mail address.
|
| EMAIL2
| VARCHAR(254)
| The secondary e-mail address.
|
| FAX1
| VARCHAR(32)
| The primary fax number.
|
| FAX2
| VARCHAR(32)
| The secondary fax number.
|
| FIELD1
| VARCHAR(64)
| Customizable.
|
| FIELD2
| VARCHAR(64)
| Customizable.
|
| FIELD3
| VARCHAR(64)
| Customizable.
|
| PHONE1
| VARCHAR(32)
| The primary phone number.
|
| PHONE2
| VARCHAR(32)
| The secondary phone number.
|
| STATE
| VARCHAR(128)
| The state within this address.
|
| ZIPCODE
| VARCHAR(40)
| The ZIP code within this address.
|
| FIRSTNAME
| VARCHAR(128)
| First name for the contact person.
|
| LASTNAME
| VARCHAR(128)
| Last name for the contact person.
|
| MIDDLENAME
| VARCHAR(128)
| Middle name for the contact person.
|
| PERSONTITLE
| VARCHAR(50)
| Title of the contact person (for example, Mr or Mrs).
|
| BUSINESSTITLE
| VARCHAR(128)
| Occupation of the contact person (for example, Site Administrator or Customer Service Representative).
|
| NICKNAME
| VARCHAR(254) NOT NULL
| Nickname or identifier for the address. Ensure that the nickname is unique for each store.
|
| SHIPPINGGEOCODE
| VARCHAR(254)
| Reserved for IBM internal use.
|
| TAXGEOCODE
| VARCHAR(254)
| Reserved for IBM internal use.
|
| URL
| VARCHAR(254)
| The URL of the store.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|