Bookshelf v8.1/8.2: Field Names for Marketing Integration Components

Table 23 contains a list of Marketing integration objects, their components, and field names.

Table 23. Field Names for Marketing Integration Components
Parent Integration Object	Parent Integration Component	Name	Data Type	Length
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

Siebel Marketing Installation and Administration Guide		Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.