Address

This class stores user and organization addresses. By default, the Commerce Server 2000 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 WSTR None None
AddressType LONG None 0 – Address
1 – ShipTo address
2 – BillTo address
City WSTR None None
CountryCode WSTR None Stores the country/region (ISO) code.
CountryName WSTR None None
DateCreated FILETIME None None
DateLastChanged FILETIME None None
FirstName WSTR None Stores the first name of the user.
Id UUID {00000000-0000-0000-0000-000000000000} Stores the unique key for the object.
LastName WSTR None Stores the last name of the user.
PostalCode WSTR None Stores the postal or ZIP Code.
RegionCode WSTR None None
RegionName WSTR None Stores the state or region name.
SiteName WSTR Not available None
TelephoneExtension WSTR None None
TelephoneNumber WSTR None 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
SiteAddressRel Site Address 3


All rights reserved.