This table stores the addresses of members in the WebSphere Commerce system. The addresses can be the members own addresses or for their friends, associates, or clients, and so on. Some columns here replace columns used in previous versions.
Column Name | Column Type | Column Description |
---|---|---|
ADDRBOOK_ID | BIGINT NOT NULL |
Foreign key to the ADDRBOOK table for the address book to which this address belongs, replacing the SASHNBR column in the SHADDR table used in previous versions of WebSohere Commerce or WebSphere Commerce Suite. |
ADDRESS1 | VARCHAR (50) NULL |
Address line 1, replacing SAADDR1 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
ADDRESS2 | VARCHAR (50) NULL |
Address line 2, replacing SAADDR2 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
ADDRESS3 | VARCHAR (50) NULL |
Address line 3, replacing SAADDR3 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
ADDRESSTYPE | CHARACTER (5) NULL |
Type of address, valid values are configurable by using a properties file: S (shipto), B (billto), and SB (both shipto and billto). A single address may be of different types. If a properties file cannot be found, a default of SB will be used. |
ADDRESS_ID | BIGINT NOT NULL |
Unique reference number, internally generated. This is a primary key, replacing the SASHNBR column in the SHADDR table used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
BESTCALLINGTIME | CHARACTER (1) NULL |
The best time to call, replacing SABTCALL used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. Valid values are D (daytime) and E (evening). |
BILLINGCODE | VARCHAR (17) NULL |
A code to identify the shipping or billing information. |
BILLINGCODETYPE | CHARACTER (2) NULL |
The code designating the system or method of code structure used for billing. |
BUSINESSTITLE | VARCHAR (128) NULL |
The business title. For example, Manager or Chief Executive Officer. LDAP uses a length of 128 characters for title attribute in ePerson. Compare with the BCTITLE column in the BUCONT table. |
CITY | VARCHAR (128) NULL |
The city, replacing SACITY used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
COUNTRY | VARCHAR (128) NULL |
The country or region, replacing SACNTRY used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
EMAIL1 | VARCHAR (256) NULL |
The primary e-mail address, replacing SAEMAIL1 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
EMAIL2 | VARCHAR (256) NULL |
The secondary e-mail address. |
FAX1 | VARCHAR (32) NULL |
The primary fax number 1, replacing SAFAX used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
FAX2 | VARCHAR (32) NULL |
The secondary fax number. |
FIELD1 | VARCHAR (64) NULL |
Customizable. This column replaces the SAFIELD1 column in the SHADDR table (used in previous versions of WebSphere Commerce or WebSphere Commerce Suite) and accepts up to 3 characters. |
FIELD2 | VARCHAR (64) NULL |
Customizable. This column replaces the SAFIELD2 column in the SHADDR table (used in previous versions of WebSphere Commerce or WebSphere Commerce Suite) and accepts up to one character. |
FIELD3 | VARCHAR (64) NULL |
Compare with the BCFIELD3 column in the BUCONT. |
FIRSTNAME | VARCHAR (128) NULL |
First name of the person to which this address applies, replacing SAFNAME used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
ISPRIMARY | INTEGER NULL |
Specifies whether the address specified is a primary address for the user. Valid values are 1 (primary address) or 0 (non-primary address). This allows multiple addresses of each ADDRESSTYPE and one of them to be designated as primary. |
LASTCREATE | TIMESTAMP NULL |
The date and time the row was created, replacing SASTMP used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
LASTNAME | VARCHAR (128) NULL |
Last name of the person to which this address applies, replacing SALNAME used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
MEMBER_ID | BIGINT NOT NULL |
Foreign key to the MEMBER table for the member who owns this address. |
MIDDLENAME | VARCHAR (128) NULL |
Middle name or initials of the person to which this address applies, replacing SAMNAME used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
NICKNAME | VARCHAR (254) NOT NULL |
The nickname or identifier of the address, replacing SANICK used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. Among all the addresses owned by a member, their nicknames must be unique. |
OFFICEADDRESS | VARCHAR (128) NULL |
Desktop delivery or office address associated with a shipping address. |
ORGNAME | VARCHAR (128) NULL |
If this is a business address, the name of the organization to for this address. This is not the name of the organization that owns the address book with this address. This column replaces SAREPCOM used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
ORGUNITNAME | VARCHAR (128) NULL |
Name of the organizational unit to which this address information applies, if this is a business address. See comment on ORGNAME above. |
PACKAGESUPPRESSION | INTEGER NULL |
Specifies whether or not to include package inserts. Valid values are 1 (include) or 0 (do not include). |
PERSONTITLE | VARCHAR (50) NULL |
Title of the person to which this address applies, replacing SATITLE used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. LDAP uses a length of 50. Valid values are Dr, Prof, Rev, Mr, Mrs, Ms, and N (not provided). The default is N. |
PHONE1 | VARCHAR (32) NULL |
The primary phone number, replacing SAPHONE1 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
PHONE1TYPE | CHARACTER (3) NULL |
Phone type for the primary phone number, such as TTY for a teletypewriter for people who have a hearing impairment or PHN for a standard phone. This column replaces SADPHTYP. |
PHONE2 | VARCHAR (32) NULL |
The secondary phone number, replacing SAPHONE2 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
PHONE2TYPE | CHARACTER (3) NULL |
Phone type for the secondary phone number, such as TTY for a teletypewriter for people who have a hearing impairment or PHN for a standard phone. This column replaces SAEPHTYP. |
PUBLISHPHONE1 | INTEGER NULL |
Specifies whether or not the primary phone number is listed. Valid values are 1 (listed) or 0 (unlisted). |
PUBLISHPHONE2 | INTEGER NULL |
Specifies whether or not the secondary phone number is listed. Valid values are 1 (listed) or 0 (unlisted). |
SELFADDRESS | INTEGER NOT NULL, DEFAULT 0 |
Specifies whether or not the address belongs to the user. Valid values are 1 (the address belongs to the user) or 0 (the number does not belong to the user; it may belong to a friend, associate, or relative). |
SHIPPINGGEOCODE | VARCHAR (254) NULL |
Shipping code based on geographical region. This value is used for integration with Taxware. |
STATE | VARCHAR (128) NULL |
State or province, replacing SASTATE used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
STATUS | CHARACTER (1) NULL |
Specifies the status of the address. Valid values are Permanent (current) or temporary (historical). This column replaces SAADRFLAG used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
TAXGEOCODE | VARCHAR (254) NULL |
Tax code based on geographical region, used for integration with Taxware. |
ZIPCODE | VARCHAR (40) NULL |
ZIP or postal code, replacing SAZIPC used in previous versions of WebSphere Commerce or WebSphere Commerce Suite. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000015 | ADDRBOOK_ID, ADDRESSTYPE, ISPRIMARY, STATUS | Non-Unique Index |
I0000016 | MEMBER_ID, STATUS, SELFADDRESS, ADDRESSTYPE, ISPRIMARY | Non-Unique Index |
I0000346 | LASTNAME | Non-Unique Index |
SQL030416034835120 | ADDRESS_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_58 | ADDRBOOK_ID | ADDRBOOK | ADDRBOOK_ID | Cascade |
F_59 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_499 | ADDRESS_ID | ORDERITEMS | ALLOCADDRESS_ID | Cascade |
F_503 | ADDRESS_ID | ORDERITEMS | ADDRESS_ID | Cascade |
F_515 | ADDRESS_ID | ORDERS | ADDRESS_ID | Cascade |
F_812 | ADDRESS_ID | SUBORDERS | ADDRESS_ID | Cascade |