Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The mktg_customer table in the marketing database contains information about various marketing campaign customers.
The following table describes the columns in the mktg_customer table.
Column name |
Type |
Allow null |
Description |
|---|---|---|---|
i_customer_id |
int |
no |
The ID of this marketing campaign customer. This is the primary key. |
i_industry_id |
int |
yes |
The industry code associated with this customer. This is a foreign key into the mktg_industry_code table. |
i_customer_type |
int |
no |
The type of this customer. |
u_customer_name |
nvarchar(255) |
no |
The name of this customer. |
u_customer_contact |
nvarchar(255) |
yes |
The name of the contact within this customer organization. |
u_customer_url |
nvarchar(512) |
yes |
The URL of this customer's Web site. |
u_customer_address |
nvarchar(1024) |
yes |
The address of this customer. |
u_customer_phone |
nvarchar(100) |
yes |
The telephone number of this customer. |
u_customer_fax |
nvarchar(100) |
yes |
The fax number of this customer. |
u_customer_email |
nvarchar(128) |
yes |
The e-mail address of the contact for this customer. |
u_customer_created |
datetime |
no |
The date and time at which this customer record was created. |
u_customer_exported |
datetime |
yes |
The date and time at which this customer record was last exported to the Data Warehouse Analytics System. |
u_customer_modified |
datetime |
yes |
The date and time at which this customer created was last modified. |
u_customer_modified_by |
nvarchar(50) |
yes |
The name of the user who created or last modified this customer record. |
u_customer_archived |
datetime |
yes |
The date and time at which this customer record was archived/deleted. |
u_customer_comments |
nvarchar(1024) |
yes |
Any arbitrary comments about this customer. |
u_customer_username |
nvarchar(50) |
yes |
A user name for use by the customer when they log on to view and/or modify their campaign data. |
u_customer_password |
nvarchar(50) |
yes |
A password for use by the customer when they log on to view and/or modify their campaign data. |
b_customer_deleted |
bit |
yes |
A Boolean value that indicates whether this customer record has been archived/deleted. |