WebSphere Commerce database table: ADDRESS

Reference > Database > WebSphere Commerce database tables > A

WebSphere Commerce database table: ADDRESS

This table stores the addresses of users or organizations 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 Description
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.
ADDRESSTYPE CHAR(5) The purpose of the address. Valid values are: S (shipto), B (billto), and SB (both shipto and billto). If this is unspecified when creating a new address, the business logic will default to SB.
MEMBER_ID BIGINT NOT NULL Foreign key to the MEMBER table for the member who owns this address.
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 WebSphere Commerce or WebSphere Commerce Suite.
ORGUNITNAME VARCHAR(128) Name of the organizational unit to which this address information applies, if this is a business address. See comment on ADDRESS.ORGNAME column.
FIELD3 VARCHAR(64) Customizable.
BILLINGCODE VARCHAR(17) A code to identify the shipping or billing information.
BILLINGCODETYPE CHAR(2) The code designating the system or method of code structure used for billing.
STATUS CHAR(1) Specifies the status of the address. Valid values are P (permanent or current) and T (temporary or historical). This column replaces SAADRFLAG used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
ORGNAME VARCHAR(128) If this is a business address, the name of the organization 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.
ISPRIMARY INTEGER A user or organization can have multiple addresses of the same address type (ADDRTYPE column). For example, a user may have multiple shipping addresses. The isPrimary column can be used to mark one of these shipping addresses as being the primary one. This may be useful when populating a drop down list of available shipping addresses as one of them can be chosen as the default option in the drop down list. Valid values are 1 (primary address) or 0 (non-primary address).
LASTNAME VARCHAR(128) Last name of the person to which this address applies, replacing SALNAME used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
PERSONTITLE VARCHAR(50) 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.
FIRSTNAME VARCHAR(128) First name of the person to which this address applies, replacing SAFNAME used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
MIDDLENAME VARCHAR(128) 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.
BUSINESSTITLE VARCHAR(128) 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 BUCONT.BCTITLE column.
PHONE1 VARCHAR(32) The primary phone number, replacing SAPHONE1 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
FAX1 VARCHAR(32) The primary fax number 1, replacing SAFAX used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
PHONE2 VARCHAR(32) The secondary phone number, replacing SAPHONE2 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
ADDRESS1 VARCHAR(100) Address line 1, replacing SAADDR1 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
FAX2 VARCHAR(32) The secondary fax number.
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.
ADDRESS2 VARCHAR(50) Address line 2, replacing SAADDR2 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
ADDRESS3 VARCHAR(50) Address line 3, replacing SAADDR3 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
CITY VARCHAR(128) The city, replacing SACITY used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
STATE VARCHAR(128) State or province, replacing SASTATE used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
COUNTRY VARCHAR(128) The country or region, replacing SACNTRY used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
ZIPCODE VARCHAR(40) ZIP or postal code, replacing SAZIPC used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
EMAIL1 VARCHAR(256) The primary e-mail address, replacing SAEMAIL1 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
EMAIL2 VARCHAR(256) The secondary e-mail address. By default, it is not used for notifications to the member.
PHONE1TYPE CHAR(3) 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.
PHONE2TYPE CHAR(3) 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 Specifies whether or not the primary phone number is listed. Valid values are 1 (listed) or 0 (unlisted).
PUBLISHPHONE2 INTEGER Specifies whether or not the secondary phone number is listed. Valid values are 1 (listed) or 0 (unlisted).
BESTCALLINGTIME CHAR(1) 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).
PACKAGESUPPRESSION INTEGER Specifies whether or not to include package inserts. Valid values are 1 (include) or 0 (do not include).
LASTCREATE TIMESTAMP The date and time the row was created, replacing SASTMP used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
OFFICEADDRESS VARCHAR(128) Desktop delivery or office address associated with a shipping address.
SELFADDRESS INTEGER NOT NULL DEFAULT 0 Specifies the address that is associated with the registration of the user or oranization. Valid values are 1 (the address is the registration address) or 0 (the address is not the registration address). A user or organization can have only one permanent self address. An example of an address that is not a self address would be an alternate shiping address or an address of a friend or relative.
FIELD1 VARCHAR(64) Customizable. This column replaces the SAFIELD1 column in the SHADDR table (used in previous versions of WebSphere Commerce or WebSphere Commerce Suite).
FIELD2 VARCHAR(64) Customizable. This column replaces the SAFIELD2 column in the SHADDR table (used in previous versions of WebSphere Commerce or WebSphere Commerce Suite).
TAXGEOCODE VARCHAR(254) Tax code based on geographical region, used for integration with Taxware.
SHIPPINGGEOCODE VARCHAR(254) Ship code based on geographical region. This value is used for integration with Taxware.
MOBILEPHONE1 VARCHAR(32) The primary mobile device number or address of the user, used for SMS text messaging. The number should be stored without the country code.
MOBILEPHONE1CNTRY VARCHAR(128) The country of the mobile device address. This country is used for country code resolution when sending SMS text messages.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030256110 ADDRESS_ID Primary Key
I0000015 ADDRBOOK_ID+ADDRESSTYPE+ISPRIMARY+STATUS Non-Unique Index
I0000016 MEMBER_ID+STATUS+SELFADDRESS+ADDRESSTYPE+ISPRIMARY Non-Unique Index
I0000346 LASTNAME Non-Unique Index

Constraints
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

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_499 ALLOCADDRESS_ID ORDERITEMS ADDRESS_ID Cascade
F_503 ADDRESS_ID ORDERITEMS ADDRESS_ID Cascade
F_515 ADDRESS_ID ORDERS ADDRESS_ID Cascade
F_1090 ADDRESS_ID ORDRELEASE ADDRESS_ID Cascade
F_1146 ADDRESS_ID SHIPINFO ADDRESS_ID Cascade
F_3580 ADDRESS_ID STLFFMREL ADDRESS_ID Cascade
F_812 ADDRESS_ID SUBORDERS ADDRESS_ID Cascade

Related reference

Store data model

Suborders data model

Vendor data model

Order item data model

Member data model

Order data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

Column Name	Column Type	Description
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.
ADDRESSTYPE	CHAR(5)	The purpose of the address. Valid values are: S (shipto), B (billto), and SB (both shipto and billto). If this is unspecified when creating a new address, the business logic will default to SB.
MEMBER_ID	BIGINT NOT NULL	Foreign key to the MEMBER table for the member who owns this address.
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 WebSphere Commerce or WebSphere Commerce Suite.
ORGUNITNAME	VARCHAR(128)	Name of the organizational unit to which this address information applies, if this is a business address. See comment on ADDRESS.ORGNAME column.
FIELD3	VARCHAR(64)	Customizable.
BILLINGCODE	VARCHAR(17)	A code to identify the shipping or billing information.
BILLINGCODETYPE	CHAR(2)	The code designating the system or method of code structure used for billing.
STATUS	CHAR(1)	Specifies the status of the address. Valid values are P (permanent or current) and T (temporary or historical). This column replaces SAADRFLAG used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
ORGNAME	VARCHAR(128)	If this is a business address, the name of the organization 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.
ISPRIMARY	INTEGER	A user or organization can have multiple addresses of the same address type (ADDRTYPE column). For example, a user may have multiple shipping addresses. The isPrimary column can be used to mark one of these shipping addresses as being the primary one. This may be useful when populating a drop down list of available shipping addresses as one of them can be chosen as the default option in the drop down list. Valid values are 1 (primary address) or 0 (non-primary address).
LASTNAME	VARCHAR(128)	Last name of the person to which this address applies, replacing SALNAME used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
PERSONTITLE	VARCHAR(50)	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.
FIRSTNAME	VARCHAR(128)	First name of the person to which this address applies, replacing SAFNAME used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
MIDDLENAME	VARCHAR(128)	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.
BUSINESSTITLE	VARCHAR(128)	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 BUCONT.BCTITLE column.
PHONE1	VARCHAR(32)	The primary phone number, replacing SAPHONE1 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
FAX1	VARCHAR(32)	The primary fax number 1, replacing SAFAX used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
PHONE2	VARCHAR(32)	The secondary phone number, replacing SAPHONE2 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
ADDRESS1	VARCHAR(100)	Address line 1, replacing SAADDR1 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
FAX2	VARCHAR(32)	The secondary fax number.
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.
ADDRESS2	VARCHAR(50)	Address line 2, replacing SAADDR2 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
ADDRESS3	VARCHAR(50)	Address line 3, replacing SAADDR3 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
CITY	VARCHAR(128)	The city, replacing SACITY used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
STATE	VARCHAR(128)	State or province, replacing SASTATE used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
COUNTRY	VARCHAR(128)	The country or region, replacing SACNTRY used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
ZIPCODE	VARCHAR(40)	ZIP or postal code, replacing SAZIPC used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
EMAIL1	VARCHAR(256)	The primary e-mail address, replacing SAEMAIL1 used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
EMAIL2	VARCHAR(256)	The secondary e-mail address. By default, it is not used for notifications to the member.
PHONE1TYPE	CHAR(3)	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.
PHONE2TYPE	CHAR(3)	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	Specifies whether or not the primary phone number is listed. Valid values are 1 (listed) or 0 (unlisted).
PUBLISHPHONE2	INTEGER	Specifies whether or not the secondary phone number is listed. Valid values are 1 (listed) or 0 (unlisted).
BESTCALLINGTIME	CHAR(1)	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).
PACKAGESUPPRESSION	INTEGER	Specifies whether or not to include package inserts. Valid values are 1 (include) or 0 (do not include).
LASTCREATE	TIMESTAMP	The date and time the row was created, replacing SASTMP used in previous versions of WebSphere Commerce or WebSphere Commerce Suite.
OFFICEADDRESS	VARCHAR(128)	Desktop delivery or office address associated with a shipping address.
SELFADDRESS	INTEGER NOT NULL DEFAULT 0	Specifies the address that is associated with the registration of the user or oranization. Valid values are 1 (the address is the registration address) or 0 (the address is not the registration address). A user or organization can have only one permanent self address. An example of an address that is not a self address would be an alternate shiping address or an address of a friend or relative.
FIELD1	VARCHAR(64)	Customizable. This column replaces the SAFIELD1 column in the SHADDR table (used in previous versions of WebSphere Commerce or WebSphere Commerce Suite).
FIELD2	VARCHAR(64)	Customizable. This column replaces the SAFIELD2 column in the SHADDR table (used in previous versions of WebSphere Commerce or WebSphere Commerce Suite).
TAXGEOCODE	VARCHAR(254)	Tax code based on geographical region, used for integration with Taxware.
SHIPPINGGEOCODE	VARCHAR(254)	Ship code based on geographical region. This value is used for integration with Taxware.
MOBILEPHONE1	VARCHAR(32)	The primary mobile device number or address of the user, used for SMS text messaging. The number should be stored without the country code.
MOBILEPHONE1CNTRY	VARCHAR(128)	The country of the mobile device address. This country is used for country code resolution when sending SMS text messages.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
SQL100520030256110	ADDRESS_ID	Primary Key
I0000015	ADDRBOOK_ID+ADDRESSTYPE+ISPRIMARY+STATUS	Non-Unique Index
I0000016	MEMBER_ID+STATUS+SELFADDRESS+ADDRESSTYPE+ISPRIMARY	Non-Unique Index
I0000346	LASTNAME	Non-Unique Index

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	ALLOCADDRESS_ID	ORDERITEMS	ADDRESS_ID	Cascade
F_503	ADDRESS_ID	ORDERITEMS	ADDRESS_ID	Cascade
F_515	ADDRESS_ID	ORDERS	ADDRESS_ID	Cascade
F_1090	ADDRESS_ID	ORDRELEASE	ADDRESS_ID	Cascade
F_1146	ADDRESS_ID	SHIPINFO	ADDRESS_ID	Cascade
F_3580	ADDRESS_ID	STLFFMREL	ADDRESS_ID	Cascade
F_812	ADDRESS_ID	SUBORDERS	ADDRESS_ID	Cascade