Data Mapping Millennium into Dynamics

This page shows how data is stored and connected between Millennium and Dynamics.

Field Information

Fields define the individual data items that can be used to store data in an entity. For more information on Fields, please refer to learn.microsoft.com (opens in a new tab).

Data Mapping Table

The various data fields in different tables from Millennium were mapped accordingly into Dynamics.

Tables and Fields marked with an * indicate they are not yet located in Dynamics

Millenium Table	MS Dynamics Table	Millennium Fields	MS Dynamics Fields
address	address	addeline1	line1
address	address	addrcity	city
address	address	addrcntry	country
address	address	addrplace	stateorprovince
address	address	addrtype	addresstypecode
address	address	addrtype	name
address	address	addrzipcod	postalcode
addresses	address	addrcity	stfl_city*
addresses	address	addrcntry	stfl_country*
addresses	address	addrcounty	stfl_county*
addresses	address	addrkey	stfl_extrecordId*
addresses	address	addrline1	stfl_line1*
addresses	address	addrline2	stfl_line2*
addresses	address	addrline3	stfl_line3*
addresses	address	addrmc1	stfl_isprimary*
addresses	address	addrplace	stfl_stateorprovince*
addresses	address	addrtype	stfl_addresstype*
addresses	address	addrzipcod	stfl_postalcode*
attribute	attribute	attrcomm	stfl_comments*
attribute	attribute	attrcomm, attrnum2	stfl_stringattribute*
attribute	attribute	attrcrdate	overriddencreatedon*
attribute	attribute	attrid	stfl_accountId*
attribute	attribute	attrid	stfl_contactId*
attribute	attribute	attrkey	stfl_stringexternalid*
attribute	attribute	attrstop	gtwnhmla_attributestopdate*
attribute	attribute	attrstrt	gtwnhmla_attributestartdate*
attribute	attribute	table_val	gtwnhmla_attributetypeaddon*
attribute	attribute	table_val	stfl_name*
attribute_types	development attribute	attrcomm	stfl_comments
attribute_types	development attribute	attrcomm, attrnum2	stfl_stringattribute
attribute_types	development attribute	attrcrdate	overriddencreatedon
attribute_types	development attribute	attrid	stfl_accountId
attribute_types	development attribute	attrid	stfl_contactId
attribute_types	development attribute	attrkey	stfl_stringexternalId
attribute_types	development attribute	attrstop	gtwnhmla_attributestopdate
attribute_types	development attribute	attrstrt	gtwnhmla_attributestartdate
attribute_types	development attribute	table_code	stfl_code*
attribute_types	development attribute	table_val	stfl_name
attribute_types	development attribute	table_val	gtwnhmla_attributetypeaddon
attribute_types	development attribute	table_val	stfl_name
comments	annotations *	commcommnt	documentbody*
comments	annotations *	commcommnt	notetext*
comments	annotations *	commdate	createdon*
comments	annotations *	commkey	filename*
comments	annotations *	commtype	subject*
correspondence	millennium correspondence	corrdate	overriddencreatedon
correspondence	millennium correspondence	corrid	gtwnhmla_contact
correspondence	millennium correspondence	corrid	gtwnhmla_account
correspondence	millennium correspondence	corrkey	gtwnhmla_externalstringid
correspondence	millennium correspondence	corrnameval	gtwnhmla_correspondencenames
correspondence	millennium correspondence	corrnum1	gtwnhmla_rsvpcount
correspondence	millennium correspondence	corrnum2	gtwnhmla_attendedcount
correspondence	millennium correspondence	corrrespdt	gtwnhmla_responsedate
correspondence	millennium correspondence	corrsentdt	gtwnhmla_sentdate
correspondence	millennium correspondence	corrtxt1	gtwnhmla_guestname1
correspondence	millennium correspondence	corrtxt2	gtwnhmla_guestname2
correspondence	millennium correspondence	corrtxt3	gtwnhmla_guestname3
correspondence	millennium correspondence	corrtxt4	gtwnhmla_guestname4
correspondence	millennium correspondence	corrtxt5	gtwnhmla_guestname5
correspondence	millennium correspondence	millenium-correspondence	gtwnhmla_externalsource
correspondence	millennium correspondence	table_code	gtwnhmla_correspondencenames
correspondence	millennium correspondence	table_code	gtwnhmla_correspondencenames
correspondence	millennium correspondence	table_val	gtwnhmla_correspondencenames
correspondence	millennium correspondence	table_val	gtwnhmla_correspondencetype
correspondence	millennium correspondence	table_val	gtwnhmla_response
correspondence	millennium correspondence	table_val	gtwnhmla_correspondencenames
donor	tracking/rating	donrcomm	gtwnhmla_strategyplan
donor	tracking/rating	donrcrdate	overriddencreatedon
donor	tracking/rating	donrdate	gtwnhmla_changedate
donor	tracking/rating	donrdate2	gtwnhmla_defermentenddate
donor	tracking/rating	donrdate3	gtwnhmla_currentstatusstartdate
donor	tracking/rating	donrid	stfl_accountId
donor	tracking/rating	donrid	stfl_contactId
donor	tracking/rating	donrkey	gtwnhmla_externalstringid
donor	tracking/rating	donrmny1	gtwnhmla_campaigncapacity
donor	tracking/rating	donrmny2	gtwnhmla_proposedcampaignask
donor	tracking/rating	donrmny3	gtwnhmla_expectedcampaigngift
donor	tracking/rating	donrmny4	gtwnhmla_committedcampaigngift
donor	tracking/rating	donrnum1	gtwnhmla_plannedgivingtotal
donor	tracking/rating	donrreslvl	gtwnhmla_research_level_string
donor	tracking/rating	donrtrack	gtwnhmla_prospect
donor	tracking/rating	donrtxt1	gtwnhmla_researchcomments
donor	tracking/rating	table_val	gtwnhmla_capacityrange
donor	tracking/rating	table_val	gtwnhmla_inclination
donor	tracking/rating	table_val	gtwnhmla_prospectstatus
donor	tracking/rating	table_val	gtwnhmla_prospecttype
donor	tracking/rating	table_val	gtwnhmla_source
dues	payment	duesacctnm	gtwnhmla_purpose*
dues	payment	duesacctno	gtwnhmla_accountnumber*
dues	payment	duesamount	stfl_amount*
dues	payment	duesasset	gtwnhmla_assetamount*
dues	payment	duesbatch	gtwnhmla_batchnumber*
dues	payment	duescampyr	gtwnhmla_campaignyear*
dues	payment	duescntpay	gtwnhmla_numberofpledgepayments*
dues	payment	duescomm	gtwnhmla_comments*
dues	payment	duescrdate	overriddencreatedon*
dues	payment	duescredid	gtwnhmla_creditId*
dues	payment	duesdeduct	gtwnhmla_deductible*
dues	payment	dueseffdat	gtwnhmla_effectivedate*
dues	payment	duesid	stfl_accountId*
dues	payment	duesid	stfl_contactId*
dues	payment	dueskey	stfl_externalstringId*
dues	payment	duesnonded	gtwnhmla_nondeductible*
dues	payment	duesorigpl	gtwnhmla_pledgeamount*
dues	payment	duespaycnt	gtwnhmla_pledgepaymentcount*
dues	payment	duesprocdt	gtwnhmla_processeddate*
dues	payment	duessolic	gtwnhmla_solicitationcode*
dues	payment	duessource	gtwnhmla_sourcecode*
dues	payment	duestender	gtwnhmla_tender*
dues	payment	duesttlpay	gtwnhmla_pledgepaid*
dues	payment	table_code	gtwnhmla_typedues*
finance	financial profile	finamount	gtwnhmla_amount
finance	financial profile	fincomm	gtwnhmla_comment
finance	financial profile	fincrdate	overriddencreatedon
finance	financial profile	findate	gtwnhmla_changedate
finance	financial profile	findescr	gtwnhmla_description
finance	financial profile	finid	stfl_accountid
finance	financial profile	finid	stfl_contactId
finance	financial profile	finkey	gtwnhmla_externalstringid
finance	financial profile	finmny1	gtwnhmla_annualincome
finance	financial profile	finmny2	gtwnhmla_networth
finance	financial profile	finmny3	gtwnhmla_investedassets
finance	financial profile	finmny4	gtwnhmla_discretionaryspending_base
finance	financial profile	finmny5	gtwnhmla_mgcapacity
finance	financial profile	finnum1	gtwnhmla_modelscore
finance	financial profile	finnum2	gtwnhmla_tgr
finance	financial profile	finnum3	gtwnhmla_mgl
finance	financial profile	finnum4	gtwnhmla_pgl
finance	financial profile	fintype	gtwnhmla_financial_profile_type
finance	financial profile	table_val	gtwnhmla_financial_profile_source
finance	financial profile	table_val	gtwnhmla_mosaicaffluence
finance	financial profile	table_val	gtwnhmla_tgrange
gifts	payment	giftamount (type y) giftasset (type w)	stfl_amount*
gifts	payment	gifteffdat	stfl_datereceived*
gifts	payment	giftid	stfl_accountId*
gifts	payment	giftid	stfl_contactId*
gifts	payment	giftkey	stfl_externalId*
gifts	payment	giftkey	stfl_externalreferenceId*
gifts	payment	giftkey	stfl_externalstringId*
gifts	payment	giftpstrtm giftpstrtd giftpstrty	stfl_dateexpected*
gifts	payment	gifttype	statuscode
gifts	payment	giftType	stfl_gifttype*
gifts	soft credit	giftacctnm	stfl_name
gifts	soft credit	giftacctnm	stfl_name
gifts	soft credit	giftamount	stfl_softcreditamount
gifts	soft credit	giftamount	stfl_softcreditamount
gifts	soft credit	giftcomm	gtwnhmla_notes
gifts	soft credit	giftcomm	gtwnhmla_notes
gifts	soft credit	giftcrdate	createdon
gifts	soft credit	giftcrdate	overriddencreatedon
gifts	soft credit	giftcrdkey gifthnrkey gifthonrid	stfl_donationId
gifts	soft credit	gifthnrkey	stfl_donationId
gifts	soft credit	giftid	stfl_accountid
gifts	soft credit	giftid	stfl_contactid
gifts	soft credit	giftkey	stfl_stringexternalId
gifts	soft credit	giftkey	stfl_stringexternalid
gifts	soft credit	gifttype	gtwnhmla_milleniumstatus
gifts	soft credit	gifttype	gtwnhmla_milleniumstatus
gifts	donation	giftacctnm	stfl_fundraisinggiftId
gifts	donation	giftamount	stfl_amount
gifts	donation	giftanon	stfl_anonymous
gifts	donation	giftbatch	stfl_rebatchnumber
gifts	donation	giftcampyr	gtwnhmla_fiscalyear
gifts	donation	giftcomm	stfl_refnote
gifts	donation	giftcrdate	overriddencreatedon
gifts	donation	giftdate	stfl_giftdate
gifts	donation	giftdate (gifteffdat) on v type	stfl_dateexpected
gifts	donation	gifteffdat (if present,giftpstrtm, giftpstrtd, giftpstrty)	stfl_datereceived
gifts	donation	giftid	stfl_accountId
gifts	donation	giftid	stfl_contactid
gifts	donation	giftjntamt	stfl_taxreceiptamount
gifts	donation	giftkey	stfl_externalreferenceId
gifts	donation	giftkey	stfl_regiftId
gifts	donation	giftmtchid	stfl_matchedgivingcontactid
gifts	donation	giftmtchky	stfl_matchedgivingparentdonationid
gifts	donation	giftsolic	gtwnhmla_solicitcodeId
gifts	donation	giftsolnam	stfl_fundraisingappealid
gifts	donation	giftsource	gtwnhmla_sourcecodeId
gifts	donation	gifttype	stfl_type
gifts	fundraising pledge	giftacctnm	stfl_fundraisingfundId
gifts	fundraising pledge	giftamtplg	stfl_actualvalue
gifts	fundraising pledge	giftamtplg	stfl_expectedvalue
gifts	fundraising pledge	giftcampyr	gtwnhmla_fiscalyear
gifts	fundraising pledge	gifteffdat	stfl_actualdate
gifts	fundraising pledge	gifteffdat	stfl_expecteddate
gifts	fundraising pledge	giftid	stfl_accountid
gifts	fundraising pledge	giftid	stfl_contactid
gifts	fundraising pledge	giftkey	stfl_externalid
gifts	fundraising pledge	giftkey	stfl_externalreferenceid
gifts	fundraising pledge	giftkey	stfl_externalstringId
gifts	fundraising pledge	giftkey	stfl_reid
gifts	fundraising pledge	giftmtchid	stfl_matchedgivingaccountId
gifts	fundraising pledge	giftmtchid	stfl_matchedgivingcontactId
gifts	fundraising pledge	giftmtchky	stfl_matchedgivingdonation
gifts	fundraising pledge	giftsolic	gtwnhmla_solicitcodeid
gifts	fundraising pledge	giftsolnam	stfl_fundraisingappealid
gifts	fundraising pledge	giftsource	gtwnhmla_sourcecodeid
gifts	fundraising pledge	giftsumkey	stfl_parentfundraisinggiftId
gifts	fundraising pledge	gifttype	gtwnhmla_milleniumstatus
internetaddress	email address	intaddress	stfl_emailaddress
internetaddress	email address	intid	stfl_stringexternalid
internetaddress	email address	intpref	stfl_isprimary
name	alias	namecrdate	overriddencreatedon
name	alias	namefirst	stfl_firstname
name	alias	nameid	stfl_accountid
name	alias	nameid	stfl_contactid
name	alias	namekey	stfl_stringexternalid
name	alias	namelast	stfl_keyname
name	alias	namemiddle	stfl_middlename
name	alias	table_val	stfl_aliastype
name/contactinfo	contact	contaddrl1	address1_line1
name/contactinfo	contact	contaddrl2	address1_line2
name/contactinfo	contact	contaddrl3	address1_line3
name/contactinfo	contact	contcity	address1_city
name/contactinfo	contact	contcntry	address1_country
name/contactinfo	contact	contcounty	address1_county
name/contactinfo	contact	contfaxph	fax
name/contactinfo	contact	contfirst	firstname
name/contactinfo	contact	contjobttl	jobtitle
name/contactinfo	contact	contkey	accountid
name/contactinfo	contact	contlast	lastname
name/contactinfo	contact	contphn	telephone1
name/contactinfo	contact	contplace	address1_stateorprovince
name/contactinfo	contact	contsalut	gtwuk_salutation
name/contactinfo	contact	contsalut	salutation
name/contactinfo	contact	contsalut	stfl_salutation
name/contactinfo	contact	conttitle	gtwuk_title
name/contactinfo	contact	contzipcod	address1_postalcode
name/contactinfo	contact	corebirthd	birthdate
name/contactinfo	contact	deathid	gtwuk_deceased
name/contactinfo	contact	intaddress	websiteurl
name/contactinfo	contact	titleBar	gtwnhmla_titlebar
name/contactinfo	account	constType	stfl_constituenttype
name/contactinfo	account	contaddrl1	address1_line1
name/contactinfo	account	contaddrl2	address1_line2
name/contactinfo	account	contaddrl3	address1_line3
name/contactinfo	account	contcity	address1_city
name/contactinfo	account	contcntry	address1_country
name/contactinfo	account	contcounty	address1_county
name/contactinfo	account	contemail	emailaddress1
name/contactinfo	account	contfaxph	fax
name/contactinfo	account	contformn	stfl_primaryaddressee
name/contactinfo	account	contkey	stfl_externalstringId
name/contactinfo	account	contlast	accountId
name/contactinfo	account	contlast	name
name/contactinfo	account	contphn	telephone1
name/contactinfo	account	contplace	address1_stateorprovince
name/contactinfo	account	contzipcod	address1_postalcode
name/contactinfo	account	intAddress	websiteurl
name/contactinfo	account	titleBar	gtwnhmla_titlebar
phone	contact method	phnid	stfl_accountId
phone	contact method	phnid	stfl_contactId
phone	contact method	phnkey	stfl_recordid
phone	contact method	phnnumber	stfl_value
phone	contact method	phntype	stfl_contacttype
phone	contact method	phntype	stfl_name
proposal	opportunity	propaskdt	stfl_askedgiftdate
proposal	opportunity	propcamp	gtwnhmla_campaign_string
proposal	opportunity	propcampyr	gtwnhmla_year
proposal	opportunity	propcomm	gtwnhmla_notescomments
proposal	opportunity	propcrdate	overriddencreatedon
proposal	opportunity	propdate	gtwnhmla_changedate
proposal	opportunity	propdate1	gtwnhmla_budgetedclosedate
proposal	opportunity	propdate2	gtwnhmla_confirmeddate
proposal	opportunity	propdate3	stfl_expectedpaymentcompletiondate
proposal	opportunity	propdate5	gtwnhmla_due
proposal	opportunity	propdate6	gtwnhmla_solicitedsubmitted
proposal	opportunity	propdecdat	gtwnhmla_decisiondate
proposal	opportunity	propfunddt	stfl_fundeddate
proposal	opportunity	propid	parentaccountid
proposal	opportunity	propid	parentcontactid
proposal	opportunity	propkey	gtwnhmla_externalIdstring
proposal	opportunity	propmny10	gtwnhmla_campaignbequest
proposal	opportunity	propmny2	gtwnhmla_projectedgift
proposal	opportunity	propmny4	gtwnhmla_requested
proposal	opportunity	propmny5	gtwnhmla_commited
proposal	opportunity	proppurpos	gtwnhmla_purpose
proposal	opportunity	propratamt	gtwnhmla_expectedamount
proposal	opportunity	propratedt	stfl_expectedgiftdate
proposal	opportunity	propyesno	gtwnhmla_reportsubmitted
proposal	opportunity	table_val	gtwnhmla_budgetedtype
proposal	opportunity	table_val	gtwnhmla_project
proposal	opportunity	table_val	gtwnhmla_rating
proposal	opportunity	table_val	gtwnhmla_solicitor
proposal	opportunity	table_val	name
proposal	opportunity	table_val/ propgoal	gtwnhmla_program
rating	tracking rating	MILLENIUM-Tracking	gtwnhmla_externalsource
rating	tracking rating	rateaskamt	gtwnhmla_evaluationamount
rating	tracking rating	rateaskrat	gtwnhmla_askrating_string
rating	tracking rating	ratecampyr	gtwnhmla_year
rating	tracking rating	ratecomm	gtwnhmla_nextsteps
rating	tracking rating	ratecrdate	overriddencreatedon
rating	tracking rating	ratecultiv	gtwnhmla_statusphase
rating	tracking rating	ratedate	gtwnhmla_changedate
rating	tracking rating	ratedate1	gtwnhmla_anticipatedsolicitationdate
rating	tracking rating	ratedate2	gtwnhmla_anticipatedclosedate
rating	tracking rating	rateend	gtwnhmla_actualclosedate
rating	tracking rating	rateid	stfl_accountid
rating	tracking rating	rateid	stfl_contactid
rating	tracking rating	ratekey	gtwnhmla_externalstringid
rating	tracking rating	ratemny1	gtwnhmla_amountpledgedreceived
rating	tracking rating	ratemny2	gtwnhmla_askamount
rating	tracking rating	ratemny4	gtwnhmla_anticipatedgiftamount
rating	tracking rating	table_val	gtwnhmla_campaign
rating	tracking rating	table_val	gtwnhmla_giftreadiness
relation	connection	fromContID	record1id
relation	connection	relkey	gtwuk_gwconnectionId
relation	connection	relrelatid	record2id
solicitations	fundraising appeal	sol_campyr	stfl_notes
solicitations	fundraising appeal	sol_code	stfl_externalstringId
solicitations	fundraising appeal	sol_date	stfl_startdate
solicitations	fundraising appeal	sol_val	stfl_description
solicitations	fundraising appeal	sol_val	stfl_name
solicitations	solicit code	sol_code	gtwnhmla_codevalue
solicitations	solicit code	sol_val	gtwnhmla_name
source_types	source code	table_code	gtwnhmla_CodeValue
source_types	source code	table_val	gtwnhmla_name

Mail Merge Fields Export SoCal Fossil Map