ADDRESS

This table stores the addresses of users or organizations in the HCL 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:

NameTypeDescription
ADDRESS_IDBIGINT NOT NULLUnique reference number, internally generated. This is a primary key, replacing the SASHNBR column in the SHADDR table used in previous versions of HCL Commerce.
ADDRESSTYPECHAR (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_IDBIGINT NOT NULLForeign key to the MEMBER table.
ADDRBOOK_IDBIGINT NOT NULLForeign 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 HCL Commerce Suite.
ORGUNITNAMEVARCHAR (128)Name of the organizational unit to which this address information applies, if this is a business address. See comment on ADDRESS.ORGNAME column.
FIELD3VARCHAR (64)Customizable.
BILLINGCODEVARCHAR (17)A code to identify the shipping or billing information.
BILLINGCODETYPECHAR (2)The code designating the system or method of code structure used for billing.
STATUSCHAR (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 HCL Commerce.
ORGNAMEVARCHAR (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 HCL Commerce.
ISPRIMARYINTEGERA 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).
LASTNAMEVARCHAR (128)Last name of the person to which this address applies, replacing SALNAME used in previous versions of WebSphere Commerce or HCL Commerce Suite.
PERSONTITLEVARCHAR (50)Title of the person to which this address applies, replacing SATITLE used in previous versions of WebSphere Commerce or HCL 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.
FIRSTNAMEVARCHAR (128)First name of the person to which this address applies, replacing SAFNAME used in previous versions of WebSphere Commerce or HCL Commerce Suite.
MIDDLENAMEVARCHAR (128)Middle name or initials of the person to which this address applies, replacing SAMNAME used in previous versions of WebSphere Commerce or HCL Commerce Suite.
BUSINESSTITLEVARCHAR (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.
PHONE1VARCHAR (32)The primary phone number, replacing SAPHONE1 used in previous versions of WebSphere Commerce or HCL Commerce Suite.
FAX1VARCHAR (32)The primary fax number 1, replacing SAFAX used in previous versions of HCL Commerce or HCL Commerce Suite.
PHONE2VARCHAR (32)The secondary phone number, replacing SAPHONE2 used in previous versions of WebSphere Commerce or HCL Commerce Suite.
ADDRESS1VARCHAR (256)Address line 1, replacing SAADDR1 used in previous versions of WebSphere Commerce or HCL Commerce Suite.
FAX2VARCHAR (32)The secondary fax number.
NICKNAMEVARCHAR (254) NOT NULLThe nickname or identifier of the address, replacing SANICK used in previous versions of HCL Commerce or HCL Commerce Suite. Among all the addresses owned by a member, their nicknames must be unique.
ADDRESS2VARCHAR (128)Address line 2, replacing SAADDR2 used in previous versions of WebSphere Commerce or HCL Commerce Suite.
ADDRESS3VARCHAR (128)Address line 3, replacing SAADDR3 used in previous versions of WebSphere Commerce or HCL Commerce Suite.
CITYVARCHAR (128)The city, replacing SACITY used in previous versions of HCL Commerce or HCL Commerce Suite.
STATEVARCHAR (128)State or province, replacing SASTATE used in previous versions of WebSphere Commerce or HCL Commerce Suite.
COUNTRYVARCHAR (128)The country or region, replacing SACNTRY used in previous versions of WebSphere Commerce or HCL Commerce Suite.
ZIPCODEVARCHAR (40)ZIP or postal code, replacing SAZIPC used in previous versions of HCL Commerce or HCL Commerce Suite.
EMAIL1VARCHAR (256)The primary e-mail address, replacing SAEMAIL1 used in previous versions of WebSphere Commerce or HCL Commerce Suite. By default, this email address is used for email notifications.
EMAIL2VARCHAR (256)The secondary e-mail address. By default, it is not used for notifications to the member.
PHONE1TYPECHAR (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.
PHONE2TYPECHAR (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.
PUBLISHPHONE1INTEGERSpecifies whether or not the primary phone number is listed. Valid values are 1 (listed) or 0 (unlisted).
PUBLISHPHONE2INTEGERSpecifies whether or not the secondary phone number is listed. Valid values are 1 (listed) or 0 (unlisted).
BESTCALLINGTIMECHAR (1)The best time to call, replacing SABTCALL used in previous versions of WebSphere Commerce or HCL Commerce Suite. Valid values are D (daytime) and E (evening).
PACKAGESUPPRESSIONINTEGERSpecifies whether or not to include package inserts. Valid values are 1 (include) or 0 (do not include).
LASTCREATETIMESTAMPThe date and time the row was created, replacing SASTMP used in previous versions of HCL Commerce or HCL Commerce Suite.
OFFICEADDRESSVARCHAR (128)Desktop delivery or office address associated with a shipping address.
SELFADDRESSINTEGER NOT NULL DEFAULT 0Specifies the address that is associated with the registration of the user or organization. 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 shipping address or an address of a friend or relative.
FIELD1VARCHAR (64)Customizable. This column replaces the SAFIELD1 column in the SHADDR table (used in previous versions of WebSphere Commerce or HCL Commerce Suite).
FIELD2VARCHAR (64)Customizable. This column replaces the SAFIELD2 column in the SHADDR table (used in previous versions of WebSphere Commerce or HCL Commerce Suite).
TAXGEOCODEVARCHAR (254)Tax code based on geographical region, used for integration with Taxware.
SHIPPINGGEOCODEVARCHAR (254)Shipping code based on geographical region. This value is used for integration with Taxware.
MOBILEPHONE1VARCHAR (32)The primary mobile device number or address of the user, used for SMS text messaging. The number should be stored in this column without the country code. The country code is stored in the MOBILEPHONE1CNTRY column.
MOBILEPHONE1CNTRYVARCHAR (128)The country of the mobile device address. This country is used for country code resolution when sending SMS text messages. This data is required when using MOBILEPHONE1.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ADDRESS_IDPrimary Key
I0000015ADDRBOOK_ID+ADDRESSTYPE+ISPRIMARY+STATUSNon-Unique Index
I0000016 MEMBER_ID+STATUS+SELFADDRESS+ADDRESSTYPE+ISPRIMARYNon-Unique Index
I0000346LASTNAMENon-Unique Index
I0001521EMAIL1Non-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_58ADDRBOOK_IDADDRBOOKADDRBOOK_IDCascade
F_59MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1090ADDRESS_IDORDRELEASEADDRESS_IDCascade
F_1146ADDRESS_IDSHIPINFOADDRESS_IDCascade
F_3580ADDRESS_IDSTLFFMRELADDRESS_IDCascade
F_499ADDRESS_IDORDERITEMSALLOCADDRESS_IDCascade
F_503ADDRESS_IDORDERITEMSADDRESS_IDCascade
F_515ADDRESS_IDORDERSADDRESS_IDCascade
F_812ADDRESS_IDSUBORDERSADDRESS_IDCascade