Sample Data Sources
When you unpack a Solution Site, Commerce Server 2000 adds a sample data source, named ProfileService_SQLSource, to the Profiles resource. The ProfileService_SQLSource data source provides you with the Address, BlanketPOs, Organization, and User Object sample data objects.
Address
BlanketPOs
Organization
User Object
Address
The following table lists the data members available in the Address data object.
Name | Data type |
g_address_id | String |
g_id | String |
i_address_type | Number |
u_address_name | String |
u_last_name | String |
u_first_name | String |
u_description | String |
u_address_line1 | String |
u_address_line2 | String |
u_city | String |
u_region_name | String |
u_region_code | String |
u_postal_code | String |
u_country_name | String |
u_country_code | String |
u_tel_number | String |
u_tel_extension | String |
i_locale | Number |
u_user_id_changed by | String |
d_date_last_changed | DateTime |
d_date_created | DateTime |
BlanketPOs
The following table lists the data members available in the BlanketPOs data object.
Name | Data type |
g_org_id | String |
g_po_id | String |
u_po_number | String |
u_description | String |
g_user_id_changed_by | String |
d_date_last_changed | DateTime |
d_date_created | DateTime |
Organization
The following table lists the data members available in the Organization data object.
Name | Data type |
g_org_id | String |
u_name | String |
u_trading_partner_number | String |
g_user_id_admin_contact | String |
g_user_id_receiver | String |
u_org_catalog_set | String |
g_user_id_changed_by | String |
g_user_purchasing_manager | String |
d_date_last_changed | DateTime |
d_date_created | DateTime |
User Object
The following table lists the data members available in the User Object data object.
Name | Data type |
u_logon_name | String |
g_org_id | String |
g_user_id | String |
u_user_title | String |
i_user_type | Number |
u_last_name | String |
u_first_name | String |
u_email_address | String |
u_tel_number | String |
u_tel_extension | String |
u_fax_number | String |
u_fax_extension | String |
u_user_security_password | String |
g_user_id_changed_by | String |
i_account_status | Number |
u_user_catalog_set | String |
d_date_registered | DateTime |
u_campaign_history | String |
i_partner_desk_role | Number |
d_date_last_changed | DateTime |
d_date_created | DateTime |
u_pref1 | String |
u_pref2 | String |
u_pref3 | String |
u_pref4 | String |
u_pref5 | String |
Note
- The u_pref data members are provided so that you can add properties to the User Object profile definition without extending your database. You can customize these data members.
The ProfileService_SQLSource data source maps to sample profile definitions that are added by default to the Profiles resource and Commerce Server Business Desk. For information about the sample profile definitions, see Sample Profile Definitions.