Export (0) Print
Expand All

Address Profile Schema

Commerce Server 2002

An instance of this profile schema stores both user and organization addresses. The profile is mapped to the physical Addresses table. The Commerce Server 2002 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 NameData
Type
ReqExpGroupDisplay Name/
Description
address_id

(primary and join key)

GUIDTTGeneral
Info
Address ID

Supplied by the system. Note that Commerce Server uses “{“ and “}” to surround GUID data types.

address_line1 Unicode
String
TFGeneral
Info
Address line 1
address_line2Unicode
String
FFGeneral
Info
Address line 2
address_nameUnicode
String
FTGeneral
Info
Address name
address_typeIntegerFTGeneral
Info
Address type

0 – Address
1 – ShipTo address
2 – BillTo address

cityUnicode
String
FTGeneral
Info
City
country_codeUnicode
String
TTGeneral
Info
Country/region (ISO) code
country_name Unicode
String
FTGeneral
Info
Country/region name
date_createdDate
Time
FTProfile
System
Date created

The default is getdate()

date_last_changedDate
Time
FTProfile
System
Date last changed

The default is getdate()

descriptionUnicode
String
FFGeneral
Info
Description
first_name Unicode
String
FTGeneral
Info
(User) first name
idGUIDFFGeneral
Info
ID of the organization/user to which this entry refers
last_name Unicode
String
FTGeneral
Info
(User) last name
localeIntegerFFGeneral
Info
Locale ID

Locale (character set) in which to render the address form

postal_codeUnicode
String
TTGeneral
Info
Postal (ZIP) code
region_codeUnicode
String
TTGeneral
Info
Country/region or state/province code
region_name Unicode
String
FTGeneral
Info
Country/region or state/province name
tel_extensionUnicode
String
FTGeneral
Info
Telephone (number) extension
tel_numberUnicode
String
FTGeneral
Info
Telephone number at this address
user_id_changed_byUnicode
String
FFGeneral
Info
Changed by

Person making the last change

Copyright © 2005 Microsoft Corporation.
All rights reserved.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft