|
Siebel Marketing Installation and Administration Guide > Advanced Marketing Information for Administrators >
Field Names for Marketing Integration Components
Table 22 contains a list of Marketing integration objects, their components, and field names.
Table 22. Field Names for Marketing Integration Components
Parent Integration Object |
Parent Integration Component |
|
|
|
Marketing Contact |
Account |
Account Location |
DTYPE_TEXT |
50 |
Marketing Contact |
Account |
Account Name |
DTYPE_TEXT |
100 |
Marketing Contact |
Account |
Home Page |
DTYPE_TEXT |
100 |
Marketing Contact |
Account |
Id |
DTYPE_TEXT |
30 |
Marketing Contact |
Account |
Integration Id |
DTYPE_TEXT |
30 |
Marketing Contact |
Account |
Main Fax Number |
DTYPE_TEXT |
|
Marketing Contact |
Account |
Main Phone Number |
DTYPE_TEXT |
|
Marketing Contact |
Account |
Region |
DTYPE_TEXT |
25 |
Marketing Contact |
Account Address |
Address Name |
DTYPE_TEXT |
100 |
Marketing Contact |
Account Address |
City |
DTYPE_TEXT |
50 |
Marketing Contact |
Account Address |
Country |
DTYPE_TEXT |
50 |
Marketing Contact |
Account Address |
Id |
DTYPE_TEXT |
30 |
Marketing Contact |
Account Address |
Integration Id |
DTYPE_TEXT |
30 |
Marketing Contact |
Account Address |
Postal Code |
DTYPE_TEXT |
30 |
Marketing Contact |
Account Address |
State |
DTYPE_TEXT |
10 |
Marketing Contact |
Account Address |
Street Address |
DTYPE_TEXT |
200 |
Marketing Contact |
Account Address |
Street Address 2 |
DTYPE_TEXT |
100 |
Marketing Contact |
Account Organization |
Organization |
DTYPE_TEXT |
50 |
Marketing Contact |
Campaign Contact |
Campaign Id |
DTYPE_ID |
|
Marketing Contact |
Campaign Contact |
Completion Date |
DTYPE_TEXT |
|
Marketing Contact |
Campaign Contact |
Distribution Id |
DTYPE_ID |
|
Marketing Contact |
Campaign Contact |
Key 1 |
DTYPE_TEXT |
30 |
Marketing Contact |
Campaign Contact |
Key 2 |
DTYPE_TEXT |
30 |
Marketing Contact |
Campaign Contact |
Key 3 |
DTYPE_TEXT |
30 |
Marketing Contact |
Campaign Contact |
Key 4 |
DTYPE_TEXT |
30 |
Marketing Contact |
Campaign Contact |
Key 5 |
DTYPE_TEXT |
30 |
Marketing Contact |
Campaign Contact |
Key 6 |
DTYPE_TEXT |
30 |
Marketing Contact |
Campaign Contact |
Key 7 |
DTYPE_TEXT |
30 |
Marketing Contact |
Campaign Contact |
Load Number |
DTYPE_NUMBER |
|
Marketing Contact |
Campaign Contact |
Load Wave Id |
DTYPE_ID |
|
Marketing Contact |
Campaign Contact |
Scalability Batch Number |
DTYPE_NUMBER |
|
Marketing Contact |
Campaign Contact |
Segment Id |
DTYPE_ID |
|
Marketing Contact |
Campaign Contact |
Source Code |
DTYPE_TEXT |
75 |
Marketing Contact |
Campaign Contact |
Token Number |
DTYPE_NUMBER |
|
Marketing Contact |
Contact |
Cellular Phone # |
DTYPE_TEXT |
|
Marketing Contact |
Contact |
Email Address |
DTYPE_TEXT |
50 |
Marketing Contact |
Contact |
Fax Phone # |
DTYPE_TEXT |
|
Marketing Contact |
Contact |
First Name |
DTYPE_TEXT |
50 |
Marketing Contact |
Contact |
Gender |
DTYPE_TEXT |
30 |
Marketing Contact |
Contact |
Home Phone # |
DTYPE_TEXT |
|
Marketing Contact |
Contact |
Id |
DTYPE_ID |
30 |
Marketing Contact |
Contact |
Integration Id |
DTYPE_TEXT |
30 |
Marketing Contact |
Contact |
Job Title |
DTYPE_TEXT |
75 |
Marketing Contact |
Contact |
Last Name |
DTYPE_TEXT |
50 |
Marketing Contact |
Contact |
Middle Name |
DTYPE_TEXT |
50 |
Marketing Contact |
Contact |
Person UId |
DTYPE_TEXT |
100 |
Marketing Contact |
Contact |
Preferred Communications |
DTYPE_TEXT |
30 |
Marketing Contact |
Contact |
Salutation |
DTYPE_TEXT |
15 |
Marketing Contact |
Contact |
Status |
DTYPE_TEXT |
30 |
Marketing Contact |
Contact |
Work Phone # |
DTYPE_TEXT |
|
Marketing Contact |
Contact Address |
Id |
DTYPE_TEXT |
30 |
Marketing Contact |
Contact Address |
Integration Id |
DTYPE_TEXT |
30 |
Marketing Contact |
Contact Address |
Personal Address Name |
DTYPE_TEXT |
100 |
Marketing Contact |
Contact Address |
Personal City |
DTYPE_TEXT |
50 |
Marketing Contact |
Contact Address |
Personal Country |
DTYPE_TEXT |
50 |
Marketing Contact |
Contact Address |
Personal Postal Code |
DTYPE_TEXT |
30 |
Marketing Contact |
Contact Address |
Personal State |
DTYPE_TEXT |
10 |
Marketing Contact |
Contact Address |
Personal Street Address |
DTYPE_TEXT |
200 |
Marketing Contact |
Contact Address |
Personal Street Address 2 |
DTYPE_TEXT |
100 |
Marketing Contact |
Contact Organization |
Organization |
DTYPE_TEXT |
50 |
Marketing Contact |
Household |
Fax Number |
DTYPE_TEXT |
|
Marketing Contact |
Household |
Household Name |
DTYPE_TEXT |
50 |
Marketing Contact |
Household |
Household Number |
DTYPE_TEXT |
100 |
Marketing Contact |
Household |
Household Size |
DTYPE_NUMBER |
|
Marketing Contact |
Household |
Household Wealth |
DTYPE_TEXT |
|
Marketing Contact |
Household |
Id |
DTYPE_ID |
30 |
Marketing Contact |
Household |
Income |
DTYPE_TEXT |
|
Marketing Contact |
Household |
Integration Id |
DTYPE_TEXT |
30 |
Marketing Contact |
Household |
Phone Number |
DTYPE_TEXT |
|
Marketing Contact |
Household |
Revenue |
DTYPE_TEXT |
|
Marketing Contact |
Household Organization |
Organization |
DTYPE_TEXT |
50 |
Marketing Person |
Campaign Contact |
Account Id |
DTYPE_ID |
|
Marketing Person |
Campaign Contact |
Campaign Id |
DTYPE_ID |
|
Marketing Person |
Campaign Contact |
Completion Date |
DTYPE_TEXT |
|
Marketing Person |
Campaign Contact |
Contact Id |
DTYPE_ID |
|
Marketing Person |
Campaign Contact |
Distribution Id |
DTYPE_ID |
|
Marketing Person |
Campaign Contact |
Household Id |
DTYPE_ID |
|
Marketing Person |
Campaign Contact |
Key 1 |
DTYPE_TEXT |
30 |
Marketing Person |
Campaign Contact |
Key 2 |
DTYPE_TEXT |
30 |
Marketing Person |
Campaign Contact |
Key 3 |
DTYPE_TEXT |
30 |
Marketing Person |
Campaign Contact |
Key 4 |
DTYPE_TEXT |
30 |
Marketing Person |
Campaign Contact |
Key 5 |
DTYPE_TEXT |
30 |
Marketing Person |
Campaign Contact |
Key 6 |
DTYPE_TEXT |
30 |
Marketing Person |
Campaign Contact |
Key 7 |
DTYPE_TEXT |
30 |
Marketing Person |
Campaign Contact |
Load Number |
DTYPE_NUMBER |
|
Marketing Person |
Campaign Contact |
Load Wave Id |
DTYPE_ID |
|
Marketing Person |
Campaign Contact |
Prospect Id |
DTYPE_ID |
|
Marketing Person |
Campaign Contact |
Scalability Batch Number |
DTYPE_NUMBER |
|
Marketing Person |
Campaign Contact |
Segment Id |
DTYPE_ID |
|
Marketing Person |
Campaign Contact |
Source Code |
DTYPE_TEXT |
75 |
Marketing Person |
Campaign Contact |
Token Number |
DTYPE_NUMBER |
|
Marketing Prospect |
Campaign Contact |
Call Completed |
DTYPE_TEXT |
|
Marketing Prospect |
Campaign Contact |
Campaign Id |
DTYPE_ID |
|
Marketing Prospect |
Campaign Contact |
Completion Date |
DTYPE_TEXT |
|
Marketing Prospect |
Campaign Contact |
Distribution Id |
DTYPE_ID |
|
Marketing Prospect |
Campaign Contact |
Key 1 |
DTYPE_TEXT |
30 |
Marketing Prospect |
Campaign Contact |
Key 2 |
DTYPE_TEXT |
30 |
Marketing Prospect |
Campaign Contact |
Key 3 |
DTYPE_TEXT |
30 |
Marketing Prospect |
Campaign Contact |
Key 4 |
DTYPE_TEXT |
30 |
Marketing Prospect |
Campaign Contact |
Key 5 |
DTYPE_TEXT |
30 |
Marketing Prospect |
Campaign Contact |
Key 6 |
DTYPE_TEXT |
30 |
Marketing Prospect |
Campaign Contact |
Key 7 |
DTYPE_TEXT |
30 |
Marketing Prospect |
Campaign Contact |
Load Number |
DTYPE_NUMBER |
|
Marketing Prospect |
Campaign Contact |
Load Wave Id |
DTYPE_ID |
|
Marketing Prospect |
Campaign Contact |
Prospect Id |
DTYPE_ID |
|
Marketing Prospect |
Campaign Contact |
Scalability Batch Number |
DTYPE_NUMBER |
|
Marketing Prospect |
Campaign Contact |
Segment Id |
DTYPE_ID |
|
Marketing Prospect |
Campaign Contact |
Token Number |
DTYPE_NUMBER |
|
Marketing Prospect |
Prospect |
Account |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Account Id |
DTYPE_ID |
|
Marketing Prospect |
Prospect |
Alias |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Alternate Phone # |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Annual Revenue |
DTYPE_NUMBER |
|
Marketing Prospect |
Prospect |
Assistant |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Assistant Phone # |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Birth Date |
DTYPE_DATETIME |
|
Marketing Prospect |
Prospect |
Cellular Phone # |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
City |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Comment |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Country |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
County |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
DUNS Number |
DTYPE_ID |
|
Marketing Prospect |
Prospect |
Disable DataCleansing |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Email Address |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Employee At Site |
DTYPE_NUMBER |
|
Marketing Prospect |
Prospect |
Employee Total |
DTYPE_NUMBER |
|
Marketing Prospect |
Prospect |
Expiration Date |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Fax Phone # |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
First Name |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Gender |
DTYPE_TEXT |
30 |
Marketing Prospect |
Prospect |
Hide DUNS Number Flag |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Home Page |
DTYPE_TEXT |
100 |
Marketing Prospect |
Prospect |
Home Phone # |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Id |
DTYPE_ID |
30 |
Marketing Prospect |
Prospect |
Job Title |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Last Name |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Line of Business |
DTYPE_TEXT |
50 |
Marketing Prospect |
Prospect |
Maiden Name |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Manager Name |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Marital Status Code |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Middle Name |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Nationality |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Postal Code |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Preferred Communications |
DTYPE_TEXT |
30 |
Marketing Prospect |
Prospect |
Preferred Language Name |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Primary Account Location |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Primary SIC Code |
DTYPE_TEXT |
30 |
Marketing Prospect |
Prospect |
Primary SIC Id |
DTYPE_ID |
|
Marketing Prospect |
Prospect |
Product Interest |
DTYPE_TEXT |
100 |
Marketing Prospect |
Prospect |
Prospective Contact UId |
DTYPE_TEXT |
100 |
Marketing Prospect |
Prospect |
Province |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Public |
DTYPE_TEXT |
1 |
Marketing Prospect |
Prospect |
Race |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Salutation |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Social Security Number |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Source Name |
DTYPE_TEXT |
100 |
Marketing Prospect |
Prospect |
State |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Street Address |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Street Address 2 |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Suppress Call Flag |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Suppress Email Flag |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Suppress Fax Flag |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Suppress Mail Flag |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Time Zone |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Work Phone # |
DTYPE_TEXT |
|
Marketing Prospect |
Prospect |
Year Started |
DTYPE_NUMBER |
|
Analytics Account |
Account |
Attribute 66 |
DTYPE_TEXT |
100 |
Analytics Account |
Account |
Attribute 67 |
DTYPE_TEXT |
100 |
Analytics Account |
Account |
Attribute 68 |
DTYPE_TEXT |
100 |
Analytics Account |
Account |
Attribute 69 |
DTYPE_TEXT |
100 |
Analytics Account |
Account |
Attribute 70 |
DTYPE_TEXT |
100 |
Analytics Account |
Account |
Attribute 71 |
DTYPE_TEXT |
100 |
Analytics Account |
Account |
Attribute 72 |
DTYPE_TEXT |
100 |
Analytics Account |
Account |
Attribute 73 |
DTYPE_NUMBER |
|
Analytics Account |
Account |
Attribute 74 |
DTYPE_NUMBER |
|
Analytics Account |
Account |
Attribute 75 |
DTYPE_NUMBER |
|
Analytics Account |
Account |
Attribute 76 |
DTYPE_NUMBER |
|
Analytics Account |
Account |
Attribute 77 |
DTYPE_NUMBER |
|
Analytics Account |
Account |
Attribute 78 |
DTYPE_NUMBER |
|
Analytics Account |
Account |
Attribute 79 |
DTYPE_NUMBER |
|
Analytics Account |
Account |
Attribute 80 |
DTYPE_NUMBER |
|
Analytics Account |
Account |
Attribute 81 |
DTYPE_NUMBER |
|
Analytics Account |
Account |
Id |
DTYPE_ID |
30 |
Analytics Account |
Account |
Integration Id |
DTYPE_TEXT |
30 |
Analytics Account |
Account |
Location |
DTYPE_TEXT |
50 |
Analytics Account |
Account |
Name |
DTYPE_TEXT |
100 |
Analytics Contact |
Contact |
Attribute 49 |
DTYPE_TEXT |
100 |
Analytics Contact |
Contact |
Attribute 50 |
DTYPE_TEXT |
100 |
Analytics Contact |
Contact |
Attribute 51 |
DTYPE_TEXT |
100 |
Analytics Contact |
Contact |
Attribute 52 |
DTYPE_TEXT |
100 |
Analytics Contact |
Contact |
Attribute 53 |
DTYPE_TEXT |
100 |
Analytics Contact |
Contact |
Attribute 54 |
DTYPE_TEXT |
100 |
Analytics Contact |
Contact |
Attribute 55 |
DTYPE_TEXT |
100 |
Analytics Contact |
Contact |
Attribute 56 |
DTYPE_NUMBER |
|
Analytics Contact |
Contact |
Attribute 57 |
DTYPE_NUMBER |
|
Analytics Contact |
Contact |
Attribute 58 |
DTYPE_NUMBER |
|
Analytics Contact |
Contact |
Attribute 59 |
DTYPE_NUMBER |
|
Analytics Contact |
Contact |
Attribute 60 |
DTYPE_NUMBER |
|
Analytics Contact |
Contact |
Attribute 61 |
DTYPE_NUMBER |
|
Analytics Contact |
Contact |
Attribute 62 |
DTYPE_NUMBER |
|
Analytics Contact |
Contact |
Attribute 63 |
DTYPE_NUMBER |
|
Analytics Contact |
Contact |
Attribute 64 |
DTYPE_NUMBER |
|
Analytics Contact |
Contact |
First Name |
DTYPE_TEXT |
50 |
Analytics Contact |
Contact |
Id |
DTYPE_ID |
30 |
Analytics Contact |
Contact |
Integration Id |
DTYPE_TEXT |
30 |
Analytics Contact |
Contact |
Last Name |
DTYPE_TEXT |
50 |
Analytics Contact |
Contact |
Person UId |
DTYPE_TEXT |
100 |
Analytics Household |
Household |
Attribute 48 |
DTYPE_TEXT |
100 |
Analytics Household |
Household |
Attribute 49 |
DTYPE_TEXT |
100 |
Analytics Household |
Household |
Attribute 50 |
DTYPE_TEXT |
100 |
Analytics Household |
Household |
Attribute 51 |
DTYPE_TEXT |
100 |
Analytics Household |
Household |
Attribute 52 |
DTYPE_TEXT |
100 |
Analytics Household |
Household |
Attribute 53 |
DTYPE_TEXT |
100 |
Analytics Household |
Household |
Attribute 54 |
DTYPE_TEXT |
100 |
Analytics Household |
Household |
Attribute 55 |
DTYPE_NUMBER |
|
Analytics Household |
Household |
Attribute 56 |
DTYPE_NUMBER |
|
Analytics Household |
Household |
Attribute 57 |
DTYPE_NUMBER |
|
Analytics Household |
Household |
Attribute 58 |
DTYPE_NUMBER |
|
Analytics Household |
Household |
Attribute 59 |
DTYPE_NUMBER |
|
Analytics Household |
Household |
Attribute 60 |
DTYPE_NUMBER |
|
Analytics Household |
Household |
Attribute 61 |
DTYPE_NUMBER |
|
Analytics Household |
Household |
Attribute 62 |
DTYPE_NUMBER |
|
Analytics Household |
Household |
Attribute 63 |
DTYPE_NUMBER |
|
Analytics Household |
Household |
Household Name |
DTYPE_TEXT |
50 |
Analytics Household |
Household |
Household Number |
DTYPE_TEXT |
100 |
Analytics Household |
Household |
Id |
DTYPE_ID |
30 |
Analytics Household |
Household |
Integration Id |
DTYPE_TEXT |
30 |
| 
