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 Descriptions
| 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)
| Compare with the BCFIELD3 column in the BUCONT table.
|
| 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 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.
|
| ISPRIMARY
| INTEGER
| 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.
|
| 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 theBUCONT.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.
|
| 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 whether or not the address belongs to the member (user or organization). The address that belongs to a member is the one that was entered as part of registration. Valid values are 1 (the address belongs to the member) or 0 (the address does not belong to the user; it may belong to a friend, associate, or relative). A member can have only one permanent self address.
|
| 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) and accepts up to 3 characters.
|
| 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) and accepts up to one character.
|
| TAXGEOCODE
| VARCHAR(254)
| Tax code based on geographical region, used for integration with Taxware.
|
| SHIPPINGGEOCODE
| VARCHAR(254)
| Shipping code based on geographical region. This value is used for integration with Taxware.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|