Share via


Address Profile Schema

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

An instance of this profile schema stores both user and organization addresses. The profile is mapped to the physical Addresses table. The Commerce Server 2007 User Import DTS Task extends and exports data into the Data Warehouse for properties with the Exported (Exp) attribute marked as True (1). The Data Warehouse class into which the Address profiles are exported is set through the DWClassName attribute of the Address profile, and defaults to Address. For information about the table entries, see Conventions.

Property Name

Data

Type

Req

Exp

Group

Display Name/

Description

address_id

(primary and join key)

GUID

T

T

GeneralInfo

Unique ID of this address

last_name

Unicode String

F

T

GeneralInfo

Last name of the user associated with this address

first_name

Unicode String

F

T

GeneralInfo

First name of the user associated with this address

address_name

Unicode String

T

T

GeneralInfo

Name of this address

address_type

Integer

F

T

GeneralInfo

Type of this address (address / ship to address / bill to address)

description

Unicode String

F

F

GeneralInfo

Description of this address

address_line1

Unicode String

T

F

GeneralInfo

First line of this address

address_line2

Unicode String

F

F

GeneralInfo

Second line of this address

city

Unicode String

F

T

GeneralInfo

City name

region_code

Unicode String

T

T

GeneralInfo

State or province code

region_name

Unicode String

F

T

GeneralInfo

State or province name

postal_code

Unicode String

T

T

GeneralInfo

Zip or postal code

country_code

Unicode String

T

T

GeneralInfo

Country or region ISO code

country_name

Unicode String

F

T

GeneralInfo

Country or region name

tel_number

Unicode String

F

T

GeneralInfo

Telephone number at this address

tel_extension

Unicode String

F

T

GeneralInfo

Telephone number extension at this address

locale

Integer

F

F

GeneralInfo

Locale in which to render this address form

user_id_changed_by

Unicode String

F

F

ProfileSystem

ID of the user that last changed this address

date_last_changed

Date Time

F

T

ProfileSystem

Date that this address was last changed

date_created

Date Time

F

T

ProfileSystem

Date that this address was created

csadapter_date_last_changed

Date

Time

F

F

ProfileSystem

Reserved for BizTalk adapter functionality

See Also

Other Resources

BlanketPOs Profile Schema

CreditCard Profile Schema

Currency Profile Schema

Organization Profile Schema

UserObject Profile Schema

Profiles Schema