Address
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The Address class stores user and organization addresses. By default, the Commerce Server User Profile Data Import Data Transformation Services (DTS) task imports profile data into this class.
Data Members
Data member name |
Data type |
Default value |
Description |
|---|---|---|---|
AddressName |
nvarchar(255) |
null |
None. |
AddressType |
int |
null |
0 – Address 1 – ShipTo address 2 – BillTo address. |
City |
nvarchar(255) |
null |
None. |
CountryCode |
nvarchar(255) |
null |
Stores the country/region (ISO) code. |
CountryName |
nvarchar(255) |
null |
None. |
DateCreated |
datetime |
null |
None. |
DateLastChanged |
datetime |
null |
None. |
FirstName |
nvarchar(255) |
null |
Stores the first name of the user. |
Id |
uniqueidentifier |
{00000000-0000-0000-0000-000000000000} |
Stores the unique key for the object. |
LastName |
nvarchar(255) |
null |
Stores the last name of the user. |
PostalCode |
nvarchar(255) |
null |
Stores the postal or ZIP code. |
RegionCode |
nvarchar(255) |
null |
None. |
RegionName |
nvarchar(255) |
null |
Stores the state/province or country/region name. |
TelephoneExtension |
nvarchar(255) |
null |
None. |
TelephoneNumber |
nvarchar(255) |
null |
None. |
Class Key
AddressKey is composed of a single data member, Id.
Relations
For a description of the relation type, see Data Warehouse Classes.
Relation name |
Parent |
Child |
Type |
|---|---|---|---|
AddressUserRel |
Address |
RegisteredUser |
2 |