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 2000 User Import DTS Task extends and exports data into the Data Warehouse for properties with the Exported (Exp) attribute marked as True (1). The corresponding class in the Data Warehouse that the Address profiles are exported into is set via 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 | General Info |
AddressID
Supplied by the system. |
address_line1 | Unicode String |
T | F | General Info |
AddressLine1 |
address_line2 | Unicode String |
F | F | General Info |
AddressLine2 |
address_name | Unicode String |
F | T | General Info |
Address Name |
address_type | Integer | F | T | General Info |
Address Type
0 – Address |
city | Unicode String |
F | T | General Info |
City |
country_code | Unicode String |
T | T | General Info |
Country (ISO) Code |
country_name | Unicode String |
F | T | General Info |
Country Name |
date_created | Date Time |
F | T | Profile System |
Date Created
The default is getdate() |
date_last_changed | Date Time |
F | T | Profile System |
Date Last Changed
The default is getdate() |
description | Unicode String |
F | F | General Info |
Description |
first_name | Unicode String |
F | T | General Info |
(User) First Name |
id | GUID | F | F | General Info |
ID of the organization/user to which this entry refers |
last_name | Unicode String |
F | T | General Info |
(User) Last Name |
locale | Integer | F | F | General Info |
Locale Id
Locale (character set) in which to render the address form |
postal_code | Unicode String |
T | T | General Info |
Postal (zip) Code |
region_code | Unicode String |
T | T | General Info |
Region or State Code |
region_name | Unicode String |
F | T | General Info |
Region or State Name |
tel_extension | Unicode String |
F | T | General Info |
Telephone (number) Extension |
tel_number | Unicode String |
F | T | General Info |
Telephone Number at this address |
user_id_changed_by | Unicode String |
F | F | General Info |
Changed by
Person making the last change |