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