Address Profile Schema
An instance of this profile schema stores both user and organization addresses. The profile is mapped to the physical Addresses table. The Commerce Server Core Systems 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 |