Field Names for Marketing Integration Components

The followning tbale contains a list of Marketing integration objects, their components, and field names.

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