Send your Microsoft Dynamics 365 data to

Microsoft Dynamics 365 Connector Reference

961 metrics1206 dimensions

Fields

The Microsoft Dynamics 365 connector exposes 2,167 fields (961 metrics, 1,206 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Microsoft Dynamics 365 Fields

Microsoft Dynamics 365 accounts fields

The accounts report of the Microsoft Dynamics 365 connector includes 141 fields.

Microsoft Dynamics 365 accounts fields (accounts_accountcategorycode to accounts_address2_line2)

ID	Type	Name	Description
accounts_accountcategorycode	NUMERIC	Account - Accountcategorycode	Account - Accountcategorycode
accounts_accountclassificationcode	NUMERIC	Account - Accountclassificationcode	Account - Accountclassificationcode
accounts_accountid	TEXT	Account - Accountid	Account - Accountid
accounts_accountnumber	TEXT	Account - Accountnumber	Account - Accountnumber
accounts_accountratingcode	NUMERIC	Account - Accountratingcode	Account - Accountratingcode
accounts_address1_addressid	TEXT	Account - Address1_addressid	Account - Address1_addressid
accounts_address1_addresstypecode	NUMERIC	Account - Address1_addresstypecode	Account - Address1_addresstypecode
accounts_address1_city	CITY	Account - Address1_city	Account - Address1_city
accounts_address1_composite	TEXT	Account - Address1_composite	Account - Address1_composite
accounts_address1_country	COUNTRY	Account - Address1_country	Account - Address1_country
accounts_address1_county	TEXT	Account - Address1_county	Account - Address1_county
accounts_address1_fax	TEXT	Account - Address1_fax	Account - Address1_fax
accounts_address1_freighttermscode	NUMERIC	Account - Address1_freighttermscode	Account - Address1_freighttermscode
accounts_address1_latitude	NUMERIC	Account - Address1_latitude	Account - Address1_latitude
accounts_address1_line1	TEXT	Account - Address1_line1	Account - Address1_line1
accounts_address1_line2	TEXT	Account - Address1_line2	Account - Address1_line2
accounts_address1_line3	TEXT	Account - Address1_line3	Account - Address1_line3
accounts_address1_longitude	NUMERIC	Account - Address1_longitude	Account - Address1_longitude
accounts_address1_name	TEXT	Account - Address1_name	Account - Address1_name
accounts_address1_postalcode	TEXT	Account - Address1_postalcode	Account - Address1_postalcode
accounts_address1_postofficebox	TEXT	Account - Address1_postofficebox	Account - Address1_postofficebox
accounts_address1_primarycontactname	TEXT	Account - Address1_primarycontactname	Account - Address1_primarycontactname
accounts_address1_shippingmethodcode	NUMERIC	Account - Address1_shippingmethodcode	Account - Address1_shippingmethodcode
accounts_address1_stateorprovince	TEXT	Account - Address1_stateorprovince	Account - Address1_stateorprovince
accounts_address1_telephone1	TEXT	Account - Address1_telephone1	Account - Address1_telephone1
accounts_address1_telephone2	TEXT	Account - Address1_telephone2	Account - Address1_telephone2
accounts_address1_telephone3	TEXT	Account - Address1_telephone3	Account - Address1_telephone3
accounts_address1_upszone	TEXT	Account - Address1_upszone	Account - Address1_upszone
accounts_address1_utcoffset	NUMERIC	Account - Address1_utcoffset	Account - Address1_utcoffset
accounts_address2_addressid	TEXT	Account - Address2_addressid	Account - Address2_addressid
accounts_address2_addresstypecode	NUMERIC	Account - Address2_addresstypecode	Account - Address2_addresstypecode
accounts_address2_city	CITY	Account - Address2_city	Account - Address2_city
accounts_address2_composite	TEXT	Account - Address2_composite	Account - Address2_composite
accounts_address2_country	COUNTRY	Account - Address2_country	Account - Address2_country
accounts_address2_county	TEXT	Account - Address2_county	Account - Address2_county
accounts_address2_fax	TEXT	Account - Address2_fax	Account - Address2_fax
accounts_address2_freighttermscode	NUMERIC	Account - Address2_freighttermscode	Account - Address2_freighttermscode
accounts_address2_latitude	NUMERIC	Account - Address2_latitude	Account - Address2_latitude
accounts_address2_line1	TEXT	Account - Address2_line1	Account - Address2_line1
accounts_address2_line2	TEXT	Account - Address2_line2	Account - Address2_line2

Microsoft Dynamics 365 accounts fields (accounts_address2_line3 to accounts_emailaddress2)

ID	Type	Name	Description
accounts_address2_line3	TEXT	Account - Address2_line3	Account - Address2_line3
accounts_address2_longitude	NUMERIC	Account - Address2_longitude	Account - Address2_longitude
accounts_address2_name	TEXT	Account - Address2_name	Account - Address2_name
accounts_address2_postalcode	TEXT	Account - Address2_postalcode	Account - Address2_postalcode
accounts_address2_postofficebox	TEXT	Account - Address2_postofficebox	Account - Address2_postofficebox
accounts_address2_primarycontactname	TEXT	Account - Address2_primarycontactname	Account - Address2_primarycontactname
accounts_address2_shippingmethodcode	NUMERIC	Account - Address2_shippingmethodcode	Account - Address2_shippingmethodcode
accounts_address2_stateorprovince	TEXT	Account - Address2_stateorprovince	Account - Address2_stateorprovince
accounts_address2_telephone1	TEXT	Account - Address2_telephone1	Account - Address2_telephone1
accounts_address2_telephone2	TEXT	Account - Address2_telephone2	Account - Address2_telephone2
accounts_address2_telephone3	TEXT	Account - Address2_telephone3	Account - Address2_telephone3
accounts_address2_upszone	TEXT	Account - Address2_upszone	Account - Address2_upszone
accounts_address2_utcoffset	NUMERIC	Account - Address2_utcoffset	Account - Address2_utcoffset
accounts_adx_createdbyipaddress	TEXT	Account - Adx_createdbyipaddress	Account - Adx_createdbyipaddress
accounts_adx_createdbyusername	TEXT	Account - Adx_createdbyusername	Account - Adx_createdbyusername
accounts_adx_modifiedbyipaddress	TEXT	Account - Adx_modifiedbyipaddress	Account - Adx_modifiedbyipaddress
accounts_adx_modifiedbyusername	TEXT	Account - Adx_modifiedbyusername	Account - Adx_modifiedbyusername
accounts_aging30	NUMERIC	Account - Aging30	Account - Aging30
accounts_aging30_base	NUMERIC	Account - Aging30_base	Account - Aging30_base
accounts_aging60	NUMERIC	Account - Aging60	Account - Aging60
accounts_aging60_base	NUMERIC	Account - Aging60_base	Account - Aging60_base
accounts_aging90	NUMERIC	Account - Aging90	Account - Aging90
accounts_aging90_base	NUMERIC	Account - Aging90_base	Account - Aging90_base
accounts_businesstypecode	NUMERIC	Account - Businesstypecode	Account - Businesstypecode
accounts_createdon	DATE	Account - Createdon	Account - Createdon
accounts_creditlimit	NUMERIC	Account - Creditlimit	Account - Creditlimit
accounts_creditlimit_base	NUMERIC	Account - Creditlimit_base	Account - Creditlimit_base
accounts_creditonhold	BOOLEAN	Account - Creditonhold	Account - Creditonhold
accounts_customersizecode	NUMERIC	Account - Customersizecode	Account - Customersizecode
accounts_customertypecode	NUMERIC	Account - Customertypecode	Account - Customertypecode
accounts_description	TEXT	Account - Description	Account - Description
accounts_donotbulkemail	BOOLEAN	Account - Donotbulkemail	Account - Donotbulkemail
accounts_donotbulkpostalmail	BOOLEAN	Account - Donotbulkpostalmail	Account - Donotbulkpostalmail
accounts_donotemail	BOOLEAN	Account - Donotemail	Account - Donotemail
accounts_donotfax	BOOLEAN	Account - Donotfax	Account - Donotfax
accounts_donotphone	BOOLEAN	Account - Donotphone	Account - Donotphone
accounts_donotpostalmail	BOOLEAN	Account - Donotpostalmail	Account - Donotpostalmail
accounts_donotsendmm	BOOLEAN	Account - Donotsendmm	Account - Donotsendmm
accounts_emailaddress1	TEXT	Account - Emailaddress1	Account - Emailaddress1
accounts_emailaddress2	TEXT	Account - Emailaddress2	Account - Emailaddress2

Microsoft Dynamics 365 accounts fields (accounts_emailaddress3 to accounts_revenue)

ID	Type	Name	Description
accounts_emailaddress3	TEXT	Account - Emailaddress3	Account - Emailaddress3
accounts_entityimage	TEXT	Account - Entityimage	Account - Entityimage
accounts_entityimage_timestamp	TIMESTAMP	Account - Entityimage_timestamp	Account - Entityimage_timestamp
accounts_entityimage_url	TEXT	Account - Entityimage_url	Account - Entityimage_url
accounts_entityimageid	TEXT	Account - Entityimageid	Account - Entityimageid
accounts_exchangerate	NUMERIC	Account - Exchangerate	Account - Exchangerate
accounts_fax	TEXT	Account - Fax	Account - Fax
accounts_followemail	BOOLEAN	Account - Followemail	Account - Followemail
accounts_ftpsiteurl	TEXT	Account - Ftpsiteurl	Account - Ftpsiteurl
accounts_importsequencenumber	NUMERIC	Account - Importsequencenumber	Account - Importsequencenumber
accounts_industrycode	NUMERIC	Account - Industrycode	Account - Industrycode
accounts_lastonholdtime	DATE	Account - Lastonholdtime	Account - Lastonholdtime
accounts_lastusedincampaign	DATE	Account - Lastusedincampaign	Account - Lastusedincampaign
accounts_marketcap	NUMERIC	Account - Marketcap	Account - Marketcap
accounts_marketcap_base	NUMERIC	Account - Marketcap_base	Account - Marketcap_base
accounts_marketingonly	BOOLEAN	Account - Marketingonly	Account - Marketingonly
accounts_merged	BOOLEAN	Account - Merged	Account - Merged
accounts_modifiedon	DATE	Account - Modifiedon	Account - Modifiedon
accounts_msdyn_gdproptout	BOOLEAN	Account - Msdyn_gdproptout	Account - Msdyn_gdproptout
accounts_name	TEXT	Account - Name	Account - Name
accounts_numberofemployees	NUMERIC	Account - Numberofemployees	Account - Numberofemployees
accounts_onholdtime	NUMERIC	Account - Onholdtime	Account - Onholdtime
accounts_opendeals	NUMERIC	Account - Opendeals	Account - Opendeals
accounts_opendeals_date	DATE	Account - Opendeals_date	Account - Opendeals_date
accounts_opendeals_state	NUMERIC	Account - Opendeals_state	Account - Opendeals_state
accounts_openrevenue	NUMERIC	Account - Openrevenue	Account - Openrevenue
accounts_openrevenue_base	NUMERIC	Account - Openrevenue_base	Account - Openrevenue_base
accounts_openrevenue_date	DATE	Account - Openrevenue_date	Account - Openrevenue_date
accounts_openrevenue_state	NUMERIC	Account - Openrevenue_state	Account - Openrevenue_state
accounts_overriddencreatedon	DATE	Account - Overriddencreatedon	Account - Overriddencreatedon
accounts_ownershipcode	NUMERIC	Account - Ownershipcode	Account - Ownershipcode
accounts_participatesinworkflow	BOOLEAN	Account - Participatesinworkflow	Account - Participatesinworkflow
accounts_paymenttermscode	NUMERIC	Account - Paymenttermscode	Account - Paymenttermscode
accounts_preferredappointmentdaycode	NUMERIC	Account - Preferredappointmentdaycode	Account - Preferredappointmentdaycode
accounts_preferredappointmenttimecode	NUMERIC	Account - Preferredappointmenttimecode	Account - Preferredappointmenttimecode
accounts_preferredcontactmethodcode	NUMERIC	Account - Preferredcontactmethodcode	Account - Preferredcontactmethodcode
accounts_primarysatoriid	TEXT	Account - Primarysatoriid	Account - Primarysatoriid
accounts_primarytwitterid	TEXT	Account - Primarytwitterid	Account - Primarytwitterid
accounts_processid	TEXT	Account - Processid	Account - Processid
accounts_revenue	NUMERIC	Account - Revenue	Account - Revenue

Microsoft Dynamics 365 accounts fields (accounts_revenue_base to accounts_yominame)

ID	Type	Name	Description
accounts_revenue_base	NUMERIC	Account - Revenue_base	Account - Revenue_base
accounts_sharesoutstanding	NUMERIC	Account - Sharesoutstanding	Account - Sharesoutstanding
accounts_shippingmethodcode	NUMERIC	Account - Shippingmethodcode	Account - Shippingmethodcode
accounts_sic	TEXT	Account - Sic	Account - Sic
accounts_stageid	TEXT	Account - Stageid	Account - Stageid
accounts_statecode	NUMERIC	Account - Statecode	Account - Statecode
accounts_statuscode	NUMERIC	Account - Statuscode	Account - Statuscode
accounts_stockexchange	TEXT	Account - Stockexchange	Account - Stockexchange
accounts_teamsfollowed	NUMERIC	Account - Teamsfollowed	Account - Teamsfollowed
accounts_telephone1	TEXT	Account - Telephone1	Account - Telephone1
accounts_telephone2	TEXT	Account - Telephone2	Account - Telephone2
accounts_telephone3	TEXT	Account - Telephone3	Account - Telephone3
accounts_territorycode	NUMERIC	Account - Territorycode	Account - Territorycode
accounts_tickersymbol	TEXT	Account - Tickersymbol	Account - Tickersymbol
accounts_timespentbymeonemailandmeetings	TEXT	Account - Timespentbymeonemailandmeetings	Account - Timespentbymeonemailandmeetings
accounts_timezoneruleversionnumber	NUMERIC	Account - Timezoneruleversionnumber	Account - Timezoneruleversionnumber
accounts_traversedpath	TEXT	Account - Traversedpath	Account - Traversedpath
accounts_utcconversiontimezonecode	NUMERIC	Account - Utcconversiontimezonecode	Account - Utcconversiontimezonecode
accounts_versionnumber	NUMERIC	Account - Versionnumber	Account - Versionnumber
accounts_websiteurl	TEXT	Account - Websiteurl	Account - Websiteurl
accounts_yominame	TEXT	Account - Yominame	Account - Yominame

Microsoft Dynamics 365 bulkoperations fields

The bulkoperations report of the Microsoft Dynamics 365 connector includes 12 fields.

ID	Type	Name	Description
bulkoperations_bulkoperationnumber	TEXT	Bulkoperation - Bulkoperationnumber	Bulkoperation - Bulkoperationnumber
bulkoperations_createdrecordtypecode	NUMERIC	Bulkoperation - Createdrecordtypecode	Bulkoperation - Createdrecordtypecode
bulkoperations_errornumber	NUMERIC	Bulkoperation - Errornumber	Bulkoperation - Errornumber
bulkoperations_failurecount	NUMERIC	Bulkoperation - Failurecount	Bulkoperation - Failurecount
bulkoperations_importsequencenumber	NUMERIC	Bulkoperation - Importsequencenumber	Bulkoperation - Importsequencenumber
bulkoperations_operationtypecode	NUMERIC	Bulkoperation - Operationtypecode	Bulkoperation - Operationtypecode
bulkoperations_overriddencreatedon	DATE	Bulkoperation - Overriddencreatedon	Bulkoperation - Overriddencreatedon
bulkoperations_parameters	TEXT	Bulkoperation - Parameters	Bulkoperation - Parameters
bulkoperations_successcount	NUMERIC	Bulkoperation - Successcount	Bulkoperation - Successcount
bulkoperations_targetedrecordtypecode	NUMERIC	Bulkoperation - Targetedrecordtypecode	Bulkoperation - Targetedrecordtypecode
bulkoperations_targetmemberscount	NUMERIC	Bulkoperation - Targetmemberscount	Bulkoperation - Targetmemberscount
bulkoperations_workflowinfo	TEXT	Bulkoperation - Workflowinfo	Bulkoperation - Workflowinfo

Microsoft Dynamics 365 campaignactivities fields

The campaignactivities report of the Microsoft Dynamics 365 connector includes 13 fields.

ID	Type	Name	Description
campaignactivities_actualcost	NUMERIC	Campaignactivity - Actualcost	Campaignactivity - Actualcost
campaignactivities_actualcost_base	NUMERIC	Campaignactivity - Actualcost_base	Campaignactivity - Actualcost_base
campaignactivities_budgetedcost	NUMERIC	Campaignactivity - Budgetedcost	Campaignactivity - Budgetedcost
campaignactivities_budgetedcost_base	NUMERIC	Campaignactivity - Budgetedcost_base	Campaignactivity - Budgetedcost_base
campaignactivities_category	TEXT	Campaignactivity - Category	Campaignactivity - Category
campaignactivities_channeltypecode	NUMERIC	Campaignactivity - Channeltypecode	Campaignactivity - Channeltypecode
campaignactivities_donotsendonoptout	BOOLEAN	Campaignactivity - Donotsendonoptout	Campaignactivity - Donotsendonoptout
campaignactivities_excludeifcontactedinxdays	NUMERIC	Campaignactivity - Excludeifcontactedinxdays	Campaignactivity - Excludeifcontactedinxdays
campaignactivities_ignoreinactivelistmembers	BOOLEAN	Campaignactivity - Ignoreinactivelistmembers	Campaignactivity - Ignoreinactivelistmembers
campaignactivities_importsequencenumber	NUMERIC	Campaignactivity - Importsequencenumber	Campaignactivity - Importsequencenumber
campaignactivities_overriddencreatedon	DATE	Campaignactivity - Overriddencreatedon	Campaignactivity - Overriddencreatedon
campaignactivities_subcategory	TEXT	Campaignactivity - Subcategory	Campaignactivity - Subcategory
campaignactivities_typecode	NUMERIC	Campaignactivity - Typecode	Campaignactivity - Typecode

Microsoft Dynamics 365 campaignresponses fields

The campaignresponses report of the Microsoft Dynamics 365 connector includes 17 fields.

Microsoft Dynamics 365 campaigns fields

The campaigns report of the Microsoft Dynamics 365 connector includes 45 fields.

Microsoft Dynamics 365 campaigns fields (campaign to campaigns_totalcampaignactivityactualcost)

ID	Type	Name	Description
campaign	TEXT	Campaign	The Campaign Name
campaigns_actualend	DATE	Campaign - Actualend	Campaign - Actualend
campaigns_actualstart	DATE	Campaign - Actualstart	Campaign - Actualstart
campaigns_budgetedcost	NUMERIC	Campaign - Budgetedcost	Campaign - Budgetedcost
campaigns_budgetedcost_base	NUMERIC	Campaign - Budgetedcost_base	Campaign - Budgetedcost_base
campaigns_campaignid	TEXT	Campaign - Campaignid	Campaign - Campaignid
campaigns_codename	TEXT	Campaign - Codename	Campaign - Codename
campaigns_createdon	DATE	Campaign - Createdon	Campaign - Createdon
campaigns_description	TEXT	Campaign - Description	Campaign - Description
campaigns_emailaddress	TEXT	Campaign - Emailaddress	Campaign - Emailaddress
campaigns_entityimage	TEXT	Campaign - Entityimage	Campaign - Entityimage
campaigns_entityimage_timestamp	TIMESTAMP	Campaign - Entityimage_timestamp	Campaign - Entityimage_timestamp
campaigns_entityimage_url	TEXT	Campaign - Entityimage_url	Campaign - Entityimage_url
campaigns_entityimageid	TEXT	Campaign - Entityimageid	Campaign - Entityimageid
campaigns_exchangerate	NUMERIC	Campaign - Exchangerate	Campaign - Exchangerate
campaigns_expectedresponse	NUMERIC	Campaign - Expectedresponse	Campaign - Expectedresponse
campaigns_expectedrevenue	NUMERIC	Campaign - Expectedrevenue	Campaign - Expectedrevenue
campaigns_expectedrevenue_base	NUMERIC	Campaign - Expectedrevenue_base	Campaign - Expectedrevenue_base
campaigns_importsequencenumber	NUMERIC	Campaign - Importsequencenumber	Campaign - Importsequencenumber
campaigns_istemplate	BOOLEAN	Campaign - Istemplate	Campaign - Istemplate
campaigns_message	TEXT	Campaign - Message	Campaign - Message
campaigns_modifiedon	DATE	Campaign - Modifiedon	Campaign - Modifiedon
campaigns_msdyn_gdproptout	BOOLEAN	Campaign - Msdyn_gdproptout	Campaign - Msdyn_gdproptout
campaigns_name	TEXT	Campaign - Name	Campaign - Name
campaigns_objective	TEXT	Campaign - Objective	Campaign - Objective
campaigns_othercost	NUMERIC	Campaign - Othercost	Campaign - Othercost
campaigns_othercost_base	NUMERIC	Campaign - Othercost_base	Campaign - Othercost_base
campaigns_overriddencreatedon	DATE	Campaign - Overriddencreatedon	Campaign - Overriddencreatedon
campaigns_processid	TEXT	Campaign - Processid	Campaign - Processid
campaigns_promotioncodename	TEXT	Campaign - Promotioncodename	Campaign - Promotioncodename
campaigns_proposedend	DATE	Campaign - Proposedend	Campaign - Proposedend
campaigns_proposedstart	DATE	Campaign - Proposedstart	Campaign - Proposedstart
campaigns_stageid	TEXT	Campaign - Stageid	Campaign - Stageid
campaigns_statecode	NUMERIC	Campaign - Statecode	Campaign - Statecode
campaigns_statuscode	NUMERIC	Campaign - Statuscode	Campaign - Statuscode
campaigns_timezoneruleversionnumber	NUMERIC	Campaign - Timezoneruleversionnumber	Campaign - Timezoneruleversionnumber
campaigns_tmpregardingobjectid	TEXT	Campaign - Tmpregardingobjectid	Campaign - Tmpregardingobjectid
campaigns_totalactualcost	NUMERIC	Campaign - Totalactualcost	Campaign - Totalactualcost
campaigns_totalactualcost_base	NUMERIC	Campaign - Totalactualcost_base	Campaign - Totalactualcost_base
campaigns_totalcampaignactivityactualcost	NUMERIC	Campaign - Totalcampaignactivityactualcost	Campaign - Totalcampaignactivityactualcost

Microsoft Dynamics 365 campaigns fields (campaigns_totalcampaignactivityactualcost_base to campaigns_versionnumber)

ID	Type	Name	Description
campaigns_totalcampaignactivityactualcost_base	NUMERIC	Campaign - Totalcampaignactivityactualcost_base	Campaign - Totalcampaignactivityactualcost_base
campaigns_traversedpath	TEXT	Campaign - Traversedpath	Campaign - Traversedpath
campaigns_typecode	NUMERIC	Campaign - Typecode	Campaign - Typecode
campaigns_utcconversiontimezonecode	NUMERIC	Campaign - Utcconversiontimezonecode	Campaign - Utcconversiontimezonecode
campaigns_versionnumber	NUMERIC	Campaign - Versionnumber	Campaign - Versionnumber

Microsoft Dynamics 365 competitors fields

The competitors report of the Microsoft Dynamics 365 connector includes 78 fields.

Microsoft Dynamics 365 competitors fields (competitors_address1_addressid to competitors_address2_telephone1)

ID	Type	Name	Description
competitors_address1_addressid	TEXT	Competitor - Address1_addressid	Competitor - Address1_addressid
competitors_address1_addresstypecode	NUMERIC	Competitor - Address1_addresstypecode	Competitor - Address1_addresstypecode
competitors_address1_city	CITY	Competitor - Address1_city	Competitor - Address1_city
competitors_address1_composite	TEXT	Competitor - Address1_composite	Competitor - Address1_composite
competitors_address1_country	COUNTRY	Competitor - Address1_country	Competitor - Address1_country
competitors_address1_county	COUNTRY	Competitor - Address1_county	Competitor - Address1_county
competitors_address1_fax	TEXT	Competitor - Address1_fax	Competitor - Address1_fax
competitors_address1_latitude	NUMERIC	Competitor - Address1_latitude	Competitor - Address1_latitude
competitors_address1_line1	TEXT	Competitor - Address1_line1	Competitor - Address1_line1
competitors_address1_line2	TEXT	Competitor - Address1_line2	Competitor - Address1_line2
competitors_address1_line3	TEXT	Competitor - Address1_line3	Competitor - Address1_line3
competitors_address1_longitude	NUMERIC	Competitor - Address1_longitude	Competitor - Address1_longitude
competitors_address1_name	TEXT	Competitor - Address1_name	Competitor - Address1_name
competitors_address1_postalcode	TEXT	Competitor - Address1_postalcode	Competitor - Address1_postalcode
competitors_address1_postofficebox	TEXT	Competitor - Address1_postofficebox	Competitor - Address1_postofficebox
competitors_address1_shippingmethodcode	NUMERIC	Competitor - Address1_shippingmethodcode	Competitor - Address1_shippingmethodcode
competitors_address1_stateorprovince	TEXT	Competitor - Address1_stateorprovince	Competitor - Address1_stateorprovince
competitors_address1_telephone1	TEXT	Competitor - Address1_telephone1	Competitor - Address1_telephone1
competitors_address1_telephone2	TEXT	Competitor - Address1_telephone2	Competitor - Address1_telephone2
competitors_address1_telephone3	TEXT	Competitor - Address1_telephone3	Competitor - Address1_telephone3
competitors_address1_upszone	TEXT	Competitor - Address1_upszone	Competitor - Address1_upszone
competitors_address1_utcoffset	NUMERIC	Competitor - Address1_utcoffset	Competitor - Address1_utcoffset
competitors_address2_addressid	TEXT	Competitor - Address2_addressid	Competitor - Address2_addressid
competitors_address2_addresstypecode	NUMERIC	Competitor - Address2_addresstypecode	Competitor - Address2_addresstypecode
competitors_address2_city	CITY	Competitor - Address2_city	Competitor - Address2_city
competitors_address2_composite	TEXT	Competitor - Address2_composite	Competitor - Address2_composite
competitors_address2_country	COUNTRY	Competitor - Address2_country	Competitor - Address2_country
competitors_address2_county	TEXT	Competitor - Address2_county	Competitor - Address2_county
competitors_address2_fax	TEXT	Competitor - Address2_fax	Competitor - Address2_fax
competitors_address2_latitude	NUMERIC	Competitor - Address2_latitude	Competitor - Address2_latitude
competitors_address2_line1	TEXT	Competitor - Address2_line1	Competitor - Address2_line1
competitors_address2_line2	TEXT	Competitor - Address2_line2	Competitor - Address2_line2
competitors_address2_line3	TEXT	Competitor - Address2_line3	Competitor - Address2_line3
competitors_address2_longitude	NUMERIC	Competitor - Address2_longitude	Competitor - Address2_longitude
competitors_address2_name	TEXT	Competitor - Address2_name	Competitor - Address2_name
competitors_address2_postalcode	TEXT	Competitor - Address2_postalcode	Competitor - Address2_postalcode
competitors_address2_postofficebox	TEXT	Competitor - Address2_postofficebox	Competitor - Address2_postofficebox
competitors_address2_shippingmethodcode	NUMERIC	Competitor - Address2_shippingmethodcode	Competitor - Address2_shippingmethodcode
competitors_address2_stateorprovince	TEXT	Competitor - Address2_stateorprovince	Competitor - Address2_stateorprovince
competitors_address2_telephone1	TEXT	Competitor - Address2_telephone1	Competitor - Address2_telephone1

Microsoft Dynamics 365 competitors fields (competitors_address2_telephone2 to competitors_yominame)

ID	Type	Name	Description
competitors_address2_telephone2	TEXT	Competitor - Address2_telephone2	Competitor - Address2_telephone2
competitors_address2_telephone3	TEXT	Competitor - Address2_telephone3	Competitor - Address2_telephone3
competitors_address2_upszone	TEXT	Competitor - Address2_upszone	Competitor - Address2_upszone
competitors_address2_utcoffset	NUMERIC	Competitor - Address2_utcoffset	Competitor - Address2_utcoffset
competitors_competitorid	TEXT	Competitor - Competitorid	Competitor - Competitorid
competitors_createdon	DATE	Competitor - Createdon	Competitor - Createdon
competitors_entityimage	TEXT	Competitor - Entityimage	Competitor - Entityimage
competitors_entityimage_timestamp	TIMESTAMP	Competitor - Entityimage_timestamp	Competitor - Entityimage_timestamp
competitors_entityimage_url	TEXT	Competitor - Entityimage_url	Competitor - Entityimage_url
competitors_entityimageid	TEXT	Competitor - Entityimageid	Competitor - Entityimageid
competitors_exchangerate	NUMERIC	Competitor - Exchangerate	Competitor - Exchangerate
competitors_importsequencenumber	NUMERIC	Competitor - Importsequencenumber	Competitor - Importsequencenumber
competitors_keyproduct	TEXT	Competitor - Keyproduct	Competitor - Keyproduct
competitors_modifiedon	DATE	Competitor - Modifiedon	Competitor - Modifiedon
competitors_msdyn_gdproptout	BOOLEAN	Competitor - Msdyn_gdproptout	Competitor - Msdyn_gdproptout
competitors_name	TEXT	Competitor - Name	Competitor - Name
competitors_opportunities	TEXT	Competitor - Opportunities	Competitor - Opportunities
competitors_overriddencreatedon	DATE	Competitor - Overriddencreatedon	Competitor - Overriddencreatedon
competitors_overview	TEXT	Competitor - Overview	Competitor - Overview
competitors_processid	TEXT	Competitor - Processid	Competitor - Processid
competitors_referenceinfourl	TEXT	Competitor - Referenceinfourl	Competitor - Referenceinfourl
competitors_reportedrevenue	NUMERIC	Competitor - Reportedrevenue	Competitor - Reportedrevenue
competitors_reportedrevenue_base	NUMERIC	Competitor - Reportedrevenue_base	Competitor - Reportedrevenue_base
competitors_reportingquarter	NUMERIC	Competitor - Reportingquarter	Competitor - Reportingquarter
competitors_reportingyear	NUMERIC	Competitor - Reportingyear	Competitor - Reportingyear
competitors_stageid	TEXT	Competitor - Stageid	Competitor - Stageid
competitors_stockexchange	TEXT	Competitor - Stockexchange	Competitor - Stockexchange
competitors_strengths	TEXT	Competitor - Strengths	Competitor - Strengths
competitors_threats	TEXT	Competitor - Threats	Competitor - Threats
competitors_tickersymbol	TEXT	Competitor - Tickersymbol	Competitor - Tickersymbol
competitors_timezoneruleversionnumber	NUMERIC	Competitor - Timezoneruleversionnumber	Competitor - Timezoneruleversionnumber
competitors_traversedpath	TEXT	Competitor - Traversedpath	Competitor - Traversedpath
competitors_utcconversiontimezonecode	NUMERIC	Competitor - Utcconversiontimezonecode	Competitor - Utcconversiontimezonecode
competitors_versionnumber	NUMERIC	Competitor - Versionnumber	Competitor - Versionnumber
competitors_weaknesses	TEXT	Competitor - Weaknesses	Competitor - Weaknesses
competitors_websiteurl	TEXT	Competitor - Websiteurl	Competitor - Websiteurl
competitors_winpercentage	NUMERIC	Competitor - Winpercentage	Competitor - Winpercentage
competitors_yominame	TEXT	Competitor - Yominame	Competitor - Yominame

Microsoft Dynamics 365 contacts fields

The contacts report of the Microsoft Dynamics 365 connector includes 213 fields.

Microsoft Dynamics 365 contacts fields (contacts_accountrolecode to contacts_address2_postalcode)

ID	Type	Name	Description
contacts_accountrolecode	NUMERIC	Contact - Accountrolecode	Contact - Accountrolecode
contacts_address1_addressid	TEXT	Contact - Address1_addressid	Contact - Address1_addressid
contacts_address1_addresstypecode	NUMERIC	Contact - Address1_addresstypecode	Contact - Address1_addresstypecode
contacts_address1_city	CITY	Contact - Address1_city	Contact - Address1_city
contacts_address1_composite	TEXT	Contact - Address1_composite	Contact - Address1_composite
contacts_address1_country	COUNTRY	Contact - Address1_country	Contact - Address1_country
contacts_address1_county	TEXT	Contact - Address1_county	Contact - Address1_county
contacts_address1_fax	TEXT	Contact - Address1_fax	Contact - Address1_fax
contacts_address1_freighttermscode	NUMERIC	Contact - Address1_freighttermscode	Contact - Address1_freighttermscode
contacts_address1_latitude	NUMERIC	Contact - Address1_latitude	Contact - Address1_latitude
contacts_address1_line1	TEXT	Contact - Address1_line1	Contact - Address1_line1
contacts_address1_line2	TEXT	Contact - Address1_line2	Contact - Address1_line2
contacts_address1_line3	TEXT	Contact - Address1_line3	Contact - Address1_line3
contacts_address1_longitude	NUMERIC	Contact - Address1_longitude	Contact - Address1_longitude
contacts_address1_name	TEXT	Contact - Address1_name	Contact - Address1_name
contacts_address1_postalcode	TEXT	Contact - Address1_postalcode	Contact - Address1_postalcode
contacts_address1_postofficebox	TEXT	Contact - Address1_postofficebox	Contact - Address1_postofficebox
contacts_address1_primarycontactname	TEXT	Contact - Address1_primarycontactname	Contact - Address1_primarycontactname
contacts_address1_shippingmethodcode	NUMERIC	Contact - Address1_shippingmethodcode	Contact - Address1_shippingmethodcode
contacts_address1_stateorprovince	TEXT	Contact - Address1_stateorprovince	Contact - Address1_stateorprovince
contacts_address1_telephone1	TEXT	Contact - Address1_telephone1	Contact - Address1_telephone1
contacts_address1_telephone2	TEXT	Contact - Address1_telephone2	Contact - Address1_telephone2
contacts_address1_telephone3	TEXT	Contact - Address1_telephone3	Contact - Address1_telephone3
contacts_address1_upszone	TEXT	Contact - Address1_upszone	Contact - Address1_upszone
contacts_address1_utcoffset	NUMERIC	Contact - Address1_utcoffset	Contact - Address1_utcoffset
contacts_address2_addressid	TEXT	Contact - Address2_addressid	Contact - Address2_addressid
contacts_address2_addresstypecode	NUMERIC	Contact - Address2_addresstypecode	Contact - Address2_addresstypecode
contacts_address2_city	CITY	Contact - Address2_city	Contact - Address2_city
contacts_address2_composite	TEXT	Contact - Address2_composite	Contact - Address2_composite
contacts_address2_country	COUNTRY	Contact - Address2_country	Contact - Address2_country
contacts_address2_county	TEXT	Contact - Address2_county	Contact - Address2_county
contacts_address2_fax	TEXT	Contact - Address2_fax	Contact - Address2_fax
contacts_address2_freighttermscode	NUMERIC	Contact - Address2_freighttermscode	Contact - Address2_freighttermscode
contacts_address2_latitude	NUMERIC	Contact - Address2_latitude	Contact - Address2_latitude
contacts_address2_line1	TEXT	Contact - Address2_line1	Contact - Address2_line1
contacts_address2_line2	TEXT	Contact - Address2_line2	Contact - Address2_line2
contacts_address2_line3	TEXT	Contact - Address2_line3	Contact - Address2_line3
contacts_address2_longitude	NUMERIC	Contact - Address2_longitude	Contact - Address2_longitude
contacts_address2_name	TEXT	Contact - Address2_name	Contact - Address2_name
contacts_address2_postalcode	TEXT	Contact - Address2_postalcode	Contact - Address2_postalcode

Microsoft Dynamics 365 contacts fields (contacts_address2_postofficebox to contacts_adx_identity_locallogindisabled)

ID	Type	Name	Description
contacts_address2_postofficebox	TEXT	Contact - Address2_postofficebox	Contact - Address2_postofficebox
contacts_address2_primarycontactname	TEXT	Contact - Address2_primarycontactname	Contact - Address2_primarycontactname
contacts_address2_shippingmethodcode	NUMERIC	Contact - Address2_shippingmethodcode	Contact - Address2_shippingmethodcode
contacts_address2_stateorprovince	TEXT	Contact - Address2_stateorprovince	Contact - Address2_stateorprovince
contacts_address2_telephone1	TEXT	Contact - Address2_telephone1	Contact - Address2_telephone1
contacts_address2_telephone2	TEXT	Contact - Address2_telephone2	Contact - Address2_telephone2
contacts_address2_telephone3	TEXT	Contact - Address2_telephone3	Contact - Address2_telephone3
contacts_address2_upszone	TEXT	Contact - Address2_upszone	Contact - Address2_upszone
contacts_address2_utcoffset	NUMERIC	Contact - Address2_utcoffset	Contact - Address2_utcoffset
contacts_address3_addressid	TEXT	Contact - Address3_addressid	Contact - Address3_addressid
contacts_address3_addresstypecode	NUMERIC	Contact - Address3_addresstypecode	Contact - Address3_addresstypecode
contacts_address3_city	CITY	Contact - Address3_city	Contact - Address3_city
contacts_address3_composite	TEXT	Contact - Address3_composite	Contact - Address3_composite
contacts_address3_country	COUNTRY	Contact - Address3_country	Contact - Address3_country
contacts_address3_county	TEXT	Contact - Address3_county	Contact - Address3_county
contacts_address3_fax	TEXT	Contact - Address3_fax	Contact - Address3_fax
contacts_address3_freighttermscode	NUMERIC	Contact - Address3_freighttermscode	Contact - Address3_freighttermscode
contacts_address3_latitude	NUMERIC	Contact - Address3_latitude	Contact - Address3_latitude
contacts_address3_line1	TEXT	Contact - Address3_line1	Contact - Address3_line1
contacts_address3_line2	TEXT	Contact - Address3_line2	Contact - Address3_line2
contacts_address3_line3	TEXT	Contact - Address3_line3	Contact - Address3_line3
contacts_address3_longitude	NUMERIC	Contact - Address3_longitude	Contact - Address3_longitude
contacts_address3_name	TEXT	Contact - Address3_name	Contact - Address3_name
contacts_address3_postalcode	TEXT	Contact - Address3_postalcode	Contact - Address3_postalcode
contacts_address3_postofficebox	TEXT	Contact - Address3_postofficebox	Contact - Address3_postofficebox
contacts_address3_primarycontactname	TEXT	Contact - Address3_primarycontactname	Contact - Address3_primarycontactname
contacts_address3_shippingmethodcode	NUMERIC	Contact - Address3_shippingmethodcode	Contact - Address3_shippingmethodcode
contacts_address3_stateorprovince	TEXT	Contact - Address3_stateorprovince	Contact - Address3_stateorprovince
contacts_address3_telephone1	TEXT	Contact - Address3_telephone1	Contact - Address3_telephone1
contacts_address3_telephone2	TEXT	Contact - Address3_telephone2	Contact - Address3_telephone2
contacts_address3_telephone3	TEXT	Contact - Address3_telephone3	Contact - Address3_telephone3
contacts_address3_upszone	TEXT	Contact - Address3_upszone	Contact - Address3_upszone
contacts_address3_utcoffset	NUMERIC	Contact - Address3_utcoffset	Contact - Address3_utcoffset
contacts_adx_confirmremovepassword	BOOLEAN	Contact - Adx_confirmremovepassword	Contact - Adx_confirmremovepassword
contacts_adx_createdbyipaddress	TEXT	Contact - Adx_createdbyipaddress	Contact - Adx_createdbyipaddress
contacts_adx_createdbyusername	TEXT	Contact - Adx_createdbyusername	Contact - Adx_createdbyusername
contacts_adx_identity_accessfailedcount	NUMERIC	Contact - Adx_identity_accessfailedcount	Contact - Adx_identity_accessfailedcount
contacts_adx_identity_emailaddress1confirmed	BOOLEAN	Contact - Adx_identity_emailaddress1confirmed	Contact - Adx_identity_emailaddress1confirmed
contacts_adx_identity_lastsuccessfullogin	DATE	Contact - Adx_identity_lastsuccessfullogin	Contact - Adx_identity_lastsuccessfullogin
contacts_adx_identity_locallogindisabled	BOOLEAN	Contact - Adx_identity_locallogindisabled	Contact - Adx_identity_locallogindisabled

Microsoft Dynamics 365 contacts fields (contacts_adx_identity_lockoutenabled to contacts_contactid)

ID	Type	Name	Description
contacts_adx_identity_lockoutenabled	BOOLEAN	Contact - Adx_identity_lockoutenabled	Contact - Adx_identity_lockoutenabled
contacts_adx_identity_lockoutenddate	DATE	Contact - Adx_identity_lockoutenddate	Contact - Adx_identity_lockoutenddate
contacts_adx_identity_logonenabled	BOOLEAN	Contact - Adx_identity_logonenabled	Contact - Adx_identity_logonenabled
contacts_adx_identity_mobilephoneconfirmed	BOOLEAN	Contact - Adx_identity_mobilephoneconfirmed	Contact - Adx_identity_mobilephoneconfirmed
contacts_adx_identity_newpassword	TEXT	Contact - Adx_identity_newpassword	Contact - Adx_identity_newpassword
contacts_adx_identity_passwordhash	TEXT	Contact - Adx_identity_passwordhash	Contact - Adx_identity_passwordhash
contacts_adx_identity_securitystamp	TEXT	Contact - Adx_identity_securitystamp	Contact - Adx_identity_securitystamp
contacts_adx_identity_twofactorenabled	BOOLEAN	Contact - Adx_identity_twofactorenabled	Contact - Adx_identity_twofactorenabled
contacts_adx_identity_username	TEXT	Contact - Adx_identity_username	Contact - Adx_identity_username
contacts_adx_modifiedbyipaddress	TEXT	Contact - Adx_modifiedbyipaddress	Contact - Adx_modifiedbyipaddress
contacts_adx_modifiedbyusername	TEXT	Contact - Adx_modifiedbyusername	Contact - Adx_modifiedbyusername
contacts_adx_organizationname	TEXT	Contact - Adx_organizationname	Contact - Adx_organizationname
contacts_adx_preferredlcid	NUMERIC	Contact - Adx_preferredlcid	Contact - Adx_preferredlcid
contacts_adx_profilealert	BOOLEAN	Contact - Adx_profilealert	Contact - Adx_profilealert
contacts_adx_profilealertdate	DATE	Contact - Adx_profilealertdate	Contact - Adx_profilealertdate
contacts_adx_profilealertinstructions	TEXT	Contact - Adx_profilealertinstructions	Contact - Adx_profilealertinstructions
contacts_adx_profileisanonymous	BOOLEAN	Contact - Adx_profileisanonymous	Contact - Adx_profileisanonymous
contacts_adx_profilelastactivity	DATE	Contact - Adx_profilelastactivity	Contact - Adx_profilelastactivity
contacts_adx_profilemodifiedon	DATE	Contact - Adx_profilemodifiedon	Contact - Adx_profilemodifiedon
contacts_adx_publicprofilecopy	TEXT	Contact - Adx_publicprofilecopy	Contact - Adx_publicprofilecopy
contacts_adx_timezone	NUMERIC	Contact - Adx_timezone	Contact - Adx_timezone
contacts_aging30	NUMERIC	Contact - Aging30	Contact - Aging30
contacts_aging30_base	NUMERIC	Contact - Aging30_base	Contact - Aging30_base
contacts_aging60	NUMERIC	Contact - Aging60	Contact - Aging60
contacts_aging60_base	NUMERIC	Contact - Aging60_base	Contact - Aging60_base
contacts_aging90	NUMERIC	Contact - Aging90	Contact - Aging90
contacts_aging90_base	NUMERIC	Contact - Aging90_base	Contact - Aging90_base
contacts_anniversary	DATE	Contact - Anniversary	Contact - Anniversary
contacts_annualincome	NUMERIC	Contact - Annualincome	Contact - Annualincome
contacts_annualincome_base	NUMERIC	Contact - Annualincome_base	Contact - Annualincome_base
contacts_assistantname	TEXT	Contact - Assistantname	Contact - Assistantname
contacts_assistantphone	TEXT	Contact - Assistantphone	Contact - Assistantphone
contacts_birthdate	DATE	Contact - Birthdate	Contact - Birthdate
contacts_business2	TEXT	Contact - Business2	Contact - Business2
contacts_businesscard	TEXT	Contact - Businesscard	Contact - Businesscard
contacts_businesscardattributes	TEXT	Contact - Businesscardattributes	Contact - Businesscardattributes
contacts_callback	TEXT	Contact - Callback	Contact - Callback
contacts_childrensnames	TEXT	Contact - Childrensnames	Contact - Childrensnames
contacts_company	TEXT	Contact - Company	Contact - Company
contacts_contactid	TEXT	Contact - Contactid	Contact - Contactid

Microsoft Dynamics 365 contacts fields (contacts_createdon to contacts_lastname)

ID	Type	Name	Description
contacts_createdon	DATE	Contact - Createdon	Contact - Createdon
contacts_creditlimit	NUMERIC	Contact - Creditlimit	Contact - Creditlimit
contacts_creditlimit_base	NUMERIC	Contact - Creditlimit_base	Contact - Creditlimit_base
contacts_creditonhold	BOOLEAN	Contact - Creditonhold	Contact - Creditonhold
contacts_customersizecode	NUMERIC	Contact - Customersizecode	Contact - Customersizecode
contacts_customertypecode	NUMERIC	Contact - Customertypecode	Contact - Customertypecode
contacts_department	TEXT	Contact - Department	Contact - Department
contacts_description	TEXT	Contact - Description	Contact - Description
contacts_donotbulkemail	BOOLEAN	Contact - Donotbulkemail	Contact - Donotbulkemail
contacts_donotbulkpostalmail	BOOLEAN	Contact - Donotbulkpostalmail	Contact - Donotbulkpostalmail
contacts_donotemail	BOOLEAN	Contact - Donotemail	Contact - Donotemail
contacts_donotfax	BOOLEAN	Contact - Donotfax	Contact - Donotfax
contacts_donotphone	BOOLEAN	Contact - Donotphone	Contact - Donotphone
contacts_donotpostalmail	BOOLEAN	Contact - Donotpostalmail	Contact - Donotpostalmail
contacts_donotsendmm	BOOLEAN	Contact - Donotsendmm	Contact - Donotsendmm
contacts_educationcode	NUMERIC	Contact - Educationcode	Contact - Educationcode
contacts_emailaddress1	TEXT	Contact - Emailaddress1	Contact - Emailaddress1
contacts_emailaddress2	TEXT	Contact - Emailaddress2	Contact - Emailaddress2
contacts_emailaddress3	TEXT	Contact - Emailaddress3	Contact - Emailaddress3
contacts_employeeid	TEXT	Contact - Employeeid	Contact - Employeeid
contacts_entityimage	TEXT	Contact - Entityimage	Contact - Entityimage
contacts_entityimage_timestamp	TIMESTAMP	Contact - Entityimage_timestamp	Contact - Entityimage_timestamp
contacts_entityimage_url	TEXT	Contact - Entityimage_url	Contact - Entityimage_url
contacts_entityimageid	TEXT	Contact - Entityimageid	Contact - Entityimageid
contacts_exchangerate	NUMERIC	Contact - Exchangerate	Contact - Exchangerate
contacts_externaluseridentifier	TEXT	Contact - Externaluseridentifier	Contact - Externaluseridentifier
contacts_familystatuscode	NUMERIC	Contact - Familystatuscode	Contact - Familystatuscode
contacts_fax	TEXT	Contact - Fax	Contact - Fax
contacts_firstname	TEXT	Contact - Firstname	Contact - Firstname
contacts_followemail	BOOLEAN	Contact - Followemail	Contact - Followemail
contacts_ftpsiteurl	TEXT	Contact - Ftpsiteurl	Contact - Ftpsiteurl
contacts_fullname	TEXT	Contact - Fullname	Contact - Fullname
contacts_gendercode	NUMERIC	Contact - Gendercode	Contact - Gendercode
contacts_governmentid	TEXT	Contact - Governmentid	Contact - Governmentid
contacts_haschildrencode	NUMERIC	Contact - Haschildrencode	Contact - Haschildrencode
contacts_home2	TEXT	Contact - Home2	Contact - Home2
contacts_importsequencenumber	NUMERIC	Contact - Importsequencenumber	Contact - Importsequencenumber
contacts_isbackofficecustomer	BOOLEAN	Contact - Isbackofficecustomer	Contact - Isbackofficecustomer
contacts_jobtitle	TEXT	Contact - Jobtitle	Contact - Jobtitle
contacts_lastname	TEXT	Contact - Lastname	Contact - Lastname

Microsoft Dynamics 365 contacts fields (contacts_lastonholdtime to contacts_telephone1)

ID	Type	Name	Description
contacts_lastonholdtime	DATE	Contact - Lastonholdtime	Contact - Lastonholdtime
contacts_lastusedincampaign	DATE	Contact - Lastusedincampaign	Contact - Lastusedincampaign
contacts_leadsourcecode	NUMERIC	Contact - Leadsourcecode	Contact - Leadsourcecode
contacts_managername	TEXT	Contact - Managername	Contact - Managername
contacts_managerphone	TEXT	Contact - Managerphone	Contact - Managerphone
contacts_marketingonly	BOOLEAN	Contact - Marketingonly	Contact - Marketingonly
contacts_merged	BOOLEAN	Contact - Merged	Contact - Merged
contacts_middlename	TEXT	Contact - Middlename	Contact - Middlename
contacts_mobilephone	TEXT	Contact - Mobilephone	Contact - Mobilephone
contacts_modifiedon	DATE	Contact - Modifiedon	Contact - Modifiedon
contacts_msdyn_decisioninfluencetag	NUMERIC	Contact - Msdyn_decisioninfluencetag	Contact - Msdyn_decisioninfluencetag
contacts_msdyn_disablewebtracking	BOOLEAN	Contact - Msdyn_disablewebtracking	Contact - Msdyn_disablewebtracking
contacts_msdyn_gdproptout	BOOLEAN	Contact - Msdyn_gdproptout	Contact - Msdyn_gdproptout
contacts_msdyn_isassistantinorgchart	BOOLEAN	Contact - Msdyn_isassistantinorgchart	Contact - Msdyn_isassistantinorgchart
contacts_msdyn_isminor	BOOLEAN	Contact - Msdyn_isminor	Contact - Msdyn_isminor
contacts_msdyn_isminorwithparentalconsent	BOOLEAN	Contact - Msdyn_isminorwithparentalconsent	Contact - Msdyn_isminorwithparentalconsent
contacts_msdyn_orgchangestatus	NUMERIC	Contact - Msdyn_orgchangestatus	Contact - Msdyn_orgchangestatus
contacts_msdyn_portaltermsagreementdate	DATE	Contact - Msdyn_portaltermsagreementdate	Contact - Msdyn_portaltermsagreementdate
contacts_mspp_userpreferredlcid	NUMERIC	Contact - Mspp_userpreferredlcid	Contact - Mspp_userpreferredlcid
contacts_nickname	TEXT	Contact - Nickname	Contact - Nickname
contacts_numberofchildren	NUMERIC	Contact - Numberofchildren	Contact - Numberofchildren
contacts_onholdtime	NUMERIC	Contact - Onholdtime	Contact - Onholdtime
contacts_overriddencreatedon	DATE	Contact - Overriddencreatedon	Contact - Overriddencreatedon
contacts_pager	TEXT	Contact - Pager	Contact - Pager
contacts_participatesinworkflow	BOOLEAN	Contact - Participatesinworkflow	Contact - Participatesinworkflow
contacts_paymenttermscode	NUMERIC	Contact - Paymenttermscode	Contact - Paymenttermscode
contacts_preferredappointmentdaycode	NUMERIC	Contact - Preferredappointmentdaycode	Contact - Preferredappointmentdaycode
contacts_preferredappointmenttimecode	NUMERIC	Contact - Preferredappointmenttimecode	Contact - Preferredappointmenttimecode
contacts_preferredcontactmethodcode	NUMERIC	Contact - Preferredcontactmethodcode	Contact - Preferredcontactmethodcode
contacts_processid	TEXT	Contact - Processid	Contact - Processid
contacts_salutation	TEXT	Contact - Salutation	Contact - Salutation
contacts_shippingmethodcode	NUMERIC	Contact - Shippingmethodcode	Contact - Shippingmethodcode
contacts_spousesname	TEXT	Contact - Spousesname	Contact - Spousesname
contacts_stageid	TEXT	Contact - Stageid	Contact - Stageid
contacts_statecode	NUMERIC	Contact - Statecode	Contact - Statecode
contacts_statuscode	NUMERIC	Contact - Statuscode	Contact - Statuscode
contacts_subscriptionid	TEXT	Contact - Subscriptionid	Contact - Subscriptionid
contacts_suffix	TEXT	Contact - Suffix	Contact - Suffix
contacts_teamsfollowed	NUMERIC	Contact - Teamsfollowed	Contact - Teamsfollowed
contacts_telephone1	TEXT	Contact - Telephone1	Contact - Telephone1

Microsoft Dynamics 365 contacts fields (contacts_telephone2 to contacts_yomimiddlename)

ID	Type	Name	Description
contacts_telephone2	TEXT	Contact - Telephone2	Contact - Telephone2
contacts_telephone3	TEXT	Contact - Telephone3	Contact - Telephone3
contacts_territorycode	NUMERIC	Contact - Territorycode	Contact - Territorycode
contacts_timespentbymeonemailandmeetings	TEXT	Contact - Timespentbymeonemailandmeetings	Contact - Timespentbymeonemailandmeetings
contacts_timezoneruleversionnumber	NUMERIC	Contact - Timezoneruleversionnumber	Contact - Timezoneruleversionnumber
contacts_traversedpath	TEXT	Contact - Traversedpath	Contact - Traversedpath
contacts_utcconversiontimezonecode	NUMERIC	Contact - Utcconversiontimezonecode	Contact - Utcconversiontimezonecode
contacts_versionnumber	NUMERIC	Contact - Versionnumber	Contact - Versionnumber
contacts_websiteurl	TEXT	Contact - Websiteurl	Contact - Websiteurl
contacts_yomifirstname	TEXT	Contact - Yomifirstname	Contact - Yomifirstname
contacts_yomifullname	TEXT	Contact - Yomifullname	Contact - Yomifullname
contacts_yomilastname	TEXT	Contact - Yomilastname	Contact - Yomilastname
contacts_yomimiddlename	TEXT	Contact - Yomimiddlename	Contact - Yomimiddlename

Microsoft Dynamics 365 discounts fields

The discounts report of the Microsoft Dynamics 365 connector includes 17 fields.

ID	Type	Name	Description
discounts_amount	NUMERIC	Discount - Amount	Discount - Amount
discounts_amount_base	NUMERIC	Discount - Amount_base	Discount - Amount_base
discounts_createdon	DATE	Discount - Createdon	Discount - Createdon
discounts_discountid	TEXT	Discount - Discountid	Discount - Discountid
discounts_exchangerate	NUMERIC	Discount - Exchangerate	Discount - Exchangerate
discounts_highquantity	NUMERIC	Discount - Highquantity	Discount - Highquantity
discounts_importsequencenumber	NUMERIC	Discount - Importsequencenumber	Discount - Importsequencenumber
discounts_isamounttype	BOOLEAN	Discount - Isamounttype	Discount - Isamounttype
discounts_lowquantity	NUMERIC	Discount - Lowquantity	Discount - Lowquantity
discounts_modifiedon	DATE	Discount - Modifiedon	Discount - Modifiedon
discounts_name	TEXT	Discount - Name	Discount - Name
discounts_organizationid	TEXT	Discount - Organizationid	Discount - Organizationid
discounts_overriddencreatedon	DATE	Discount - Overriddencreatedon	Discount - Overriddencreatedon
discounts_percentage	NUMERIC	Discount - Percentage	Discount - Percentage
discounts_timezoneruleversionnumber	NUMERIC	Discount - Timezoneruleversionnumber	Discount - Timezoneruleversionnumber
discounts_utcconversiontimezonecode	NUMERIC	Discount - Utcconversiontimezonecode	Discount - Utcconversiontimezonecode
discounts_versionnumber	NUMERIC	Discount - Versionnumber	Discount - Versionnumber

Microsoft Dynamics 365 discounttypes fields

The discounttypes report of the Microsoft Dynamics 365 connector includes 13 fields.

ID	Type	Name	Description
discounttypes_createdon	DATE	Discounttype - Createdon	Discounttype - Createdon
discounttypes_description	TEXT	Discounttype - Description	Discounttype - Description
discounttypes_discounttypeid	TEXT	Discounttype - Discounttypeid	Discounttype - Discounttypeid
discounttypes_importsequencenumber	NUMERIC	Discounttype - Importsequencenumber	Discounttype - Importsequencenumber
discounttypes_isamounttype	BOOLEAN	Discounttype - Isamounttype	Discounttype - Isamounttype
discounttypes_modifiedon	DATE	Discounttype - Modifiedon	Discounttype - Modifiedon
discounttypes_name	TEXT	Discounttype - Name	Discounttype - Name
discounttypes_overriddencreatedon	DATE	Discounttype - Overriddencreatedon	Discounttype - Overriddencreatedon
discounttypes_statecode	NUMERIC	Discounttype - Statecode	Discounttype - Statecode
discounttypes_statuscode	NUMERIC	Discounttype - Statuscode	Discounttype - Statuscode
discounttypes_timezoneruleversionnumber	NUMERIC	Discounttype - Timezoneruleversionnumber	Discounttype - Timezoneruleversionnumber
discounttypes_utcconversiontimezonecode	NUMERIC	Discounttype - Utcconversiontimezonecode	Discounttype - Utcconversiontimezonecode
discounttypes_versionnumber	NUMERIC	Discounttype - Versionnumber	Discounttype - Versionnumber

Microsoft Dynamics 365 dynamicpropertyinstances fields

The dynamicpropertyinstances report of the Microsoft Dynamics 365 connector includes 16 fields.

Microsoft Dynamics 365 goalrollupqueries fields

The goalrollupqueries report of the Microsoft Dynamics 365 connector includes 13 fields.

ID	Type	Name	Description
goalrollupqueries_createdon	DATE	Goalrollupquery - Createdon	Goalrollupquery - Createdon
goalrollupqueries_fetchxml	TEXT	Goalrollupquery - Fetchxml	Goalrollupquery - Fetchxml
goalrollupqueries_goalrollupqueryid	TEXT	Goalrollupquery - Goalrollupqueryid	Goalrollupquery - Goalrollupqueryid
goalrollupqueries_importsequencenumber	NUMERIC	Goalrollupquery - Importsequencenumber	Goalrollupquery - Importsequencenumber
goalrollupqueries_modifiedon	DATE	Goalrollupquery - Modifiedon	Goalrollupquery - Modifiedon
goalrollupqueries_name	TEXT	Goalrollupquery - Name	Goalrollupquery - Name
goalrollupqueries_overriddencreatedon	DATE	Goalrollupquery - Overriddencreatedon	Goalrollupquery - Overriddencreatedon
goalrollupqueries_queryentitytype	TEXT	Goalrollupquery - Queryentitytype	Goalrollupquery - Queryentitytype
goalrollupqueries_statecode	NUMERIC	Goalrollupquery - Statecode	Goalrollupquery - Statecode
goalrollupqueries_statuscode	NUMERIC	Goalrollupquery - Statuscode	Goalrollupquery - Statuscode
goalrollupqueries_timezoneruleversionnumber	NUMERIC	Goalrollupquery - Timezoneruleversionnumber	Goalrollupquery - Timezoneruleversionnumber
goalrollupqueries_utcconversiontimezonecode	NUMERIC	Goalrollupquery - Utcconversiontimezonecode	Goalrollupquery - Utcconversiontimezonecode
goalrollupqueries_versionnumber	NUMERIC	Goalrollupquery - Versionnumber	Goalrollupquery - Versionnumber

Microsoft Dynamics 365 goals fields

The goals report of the Microsoft Dynamics 365 connector includes 62 fields.

Microsoft Dynamics 365 goals fields (goals_actualdecimal to goals_lastrolledupdate)

ID	Type	Name	Description
goals_actualdecimal	NUMERIC	Goal - Actualdecimal	Goal - Actualdecimal
goals_actualinteger	NUMERIC	Goal - Actualinteger	Goal - Actualinteger
goals_actualmoney	NUMERIC	Goal - Actualmoney	Goal - Actualmoney
goals_actualmoney_base	NUMERIC	Goal - Actualmoney_base	Goal - Actualmoney_base
goals_actualstring	TEXT	Goal - Actualstring	Goal - Actualstring
goals_amountdatatype	NUMERIC	Goal - Amountdatatype	Goal - Amountdatatype
goals_computedtargetasoftodaydecimal	NUMERIC	Goal - Computedtargetasoftodaydecimal	Goal - Computedtargetasoftodaydecimal
goals_computedtargetasoftodayinteger	NUMERIC	Goal - Computedtargetasoftodayinteger	Goal - Computedtargetasoftodayinteger
goals_computedtargetasoftodaymoney	NUMERIC	Goal - Computedtargetasoftodaymoney	Goal - Computedtargetasoftodaymoney
goals_computedtargetasoftodaymoney_base	NUMERIC	Goal - Computedtargetasoftodaymoney_base	Goal - Computedtargetasoftodaymoney_base
goals_computedtargetasoftodaypercentageachieved	NUMERIC	Goal - Computedtargetasoftodaypercentageachieved	Goal - Computedtargetasoftodaypercentageachieved
goals_consideronlygoalownersrecords	BOOLEAN	Goal - Consideronlygoalownersrecords	Goal - Consideronlygoalownersrecords
goals_createdon	DATE	Goal - Createdon	Goal - Createdon
goals_customrollupfielddecimal	NUMERIC	Goal - Customrollupfielddecimal	Goal - Customrollupfielddecimal
goals_customrollupfieldinteger	NUMERIC	Goal - Customrollupfieldinteger	Goal - Customrollupfieldinteger
goals_customrollupfieldmoney	NUMERIC	Goal - Customrollupfieldmoney	Goal - Customrollupfieldmoney
goals_customrollupfieldmoney_base	NUMERIC	Goal - Customrollupfieldmoney_base	Goal - Customrollupfieldmoney_base
goals_customrollupfieldstring	TEXT	Goal - Customrollupfieldstring	Goal - Customrollupfieldstring
goals_depth	NUMERIC	Goal - Depth	Goal - Depth
goals_entityimage	TEXT	Goal - Entityimage	Goal - Entityimage
goals_entityimage_timestamp	TIMESTAMP	Goal - Entityimage_timestamp	Goal - Entityimage_timestamp
goals_entityimage_url	TEXT	Goal - Entityimage_url	Goal - Entityimage_url
goals_entityimageid	TEXT	Goal - Entityimageid	Goal - Entityimageid
goals_exchangerate	NUMERIC	Goal - Exchangerate	Goal - Exchangerate
goals_fiscalperiod	NUMERIC	Goal - Fiscalperiod	Goal - Fiscalperiod
goals_fiscalyear	NUMERIC	Goal - Fiscalyear	Goal - Fiscalyear
goals_goalenddate	DATE	Goal - Goalenddate	Goal - Goalenddate
goals_goalid	TEXT	Goal - Goalid	Goal - Goalid
goals_goalstartdate	DATE	Goal - Goalstartdate	Goal - Goalstartdate
goals_importsequencenumber	NUMERIC	Goal - Importsequencenumber	Goal - Importsequencenumber
goals_inprogressdecimal	NUMERIC	Goal - Inprogressdecimal	Goal - Inprogressdecimal
goals_inprogressinteger	NUMERIC	Goal - Inprogressinteger	Goal - Inprogressinteger
goals_inprogressmoney	NUMERIC	Goal - Inprogressmoney	Goal - Inprogressmoney
goals_inprogressmoney_base	NUMERIC	Goal - Inprogressmoney_base	Goal - Inprogressmoney_base
goals_inprogressstring	TEXT	Goal - Inprogressstring	Goal - Inprogressstring
goals_isamount	BOOLEAN	Goal - Isamount	Goal - Isamount
goals_isfiscalperiodgoal	BOOLEAN	Goal - Isfiscalperiodgoal	Goal - Isfiscalperiodgoal
goals_isoverridden	BOOLEAN	Goal - Isoverridden	Goal - Isoverridden
goals_isoverride	BOOLEAN	Goal - Isoverride	Goal - Isoverride
goals_lastrolledupdate	DATE	Goal - Lastrolledupdate	Goal - Lastrolledupdate

Microsoft Dynamics 365 goals fields (goals_modifiedon to goals_versionnumber)

ID	Type	Name	Description
goals_modifiedon	DATE	Goal - Modifiedon	Goal - Modifiedon
goals_overriddencreatedon	DATE	Goal - Overriddencreatedon	Goal - Overriddencreatedon
goals_percentage	NUMERIC	Goal - Percentage	Goal - Percentage
goals_rolluperrorcode	NUMERIC	Goal - Rolluperrorcode	Goal - Rolluperrorcode
goals_rolluponlyfromchildgoals	BOOLEAN	Goal - Rolluponlyfromchildgoals	Goal - Rolluponlyfromchildgoals
goals_statecode	NUMERIC	Goal - Statecode	Goal - Statecode
goals_statuscode	NUMERIC	Goal - Statuscode	Goal - Statuscode
goals_stretchtargetdecimal	NUMERIC	Goal - Stretchtargetdecimal	Goal - Stretchtargetdecimal
goals_stretchtargetinteger	NUMERIC	Goal - Stretchtargetinteger	Goal - Stretchtargetinteger
goals_stretchtargetmoney	NUMERIC	Goal - Stretchtargetmoney	Goal - Stretchtargetmoney
goals_stretchtargetmoney_base	NUMERIC	Goal - Stretchtargetmoney_base	Goal - Stretchtargetmoney_base
goals_stretchtargetstring	TEXT	Goal - Stretchtargetstring	Goal - Stretchtargetstring
goals_targetdecimal	NUMERIC	Goal - Targetdecimal	Goal - Targetdecimal
goals_targetinteger	NUMERIC	Goal - Targetinteger	Goal - Targetinteger
goals_targetmoney	NUMERIC	Goal - Targetmoney	Goal - Targetmoney
goals_targetmoney_base	NUMERIC	Goal - Targetmoney_base	Goal - Targetmoney_base
goals_targetstring	TEXT	Goal - Targetstring	Goal - Targetstring
goals_timezoneruleversionnumber	NUMERIC	Goal - Timezoneruleversionnumber	Goal - Timezoneruleversionnumber
goals_title	TEXT	Goal - Title	Goal - Title
goals_treeid	TEXT	Goal - Treeid	Goal - Treeid
goals_utcconversiontimezonecode	NUMERIC	Goal - Utcconversiontimezonecode	Goal - Utcconversiontimezonecode
goals_versionnumber	NUMERIC	Goal - Versionnumber	Goal - Versionnumber

Microsoft Dynamics 365 invoicedetails fields

The invoicedetails report of the Microsoft Dynamics 365 connector includes 57 fields.

Microsoft Dynamics 365 invoicedetails fields (invoicedetails_actualdeliveryon to invoicedetails_shipto_fax)

Microsoft Dynamics 365 invoicedetails fields (invoicedetails_shipto_freighttermscode to invoicedetails_willcall)

ID	Type	Name	Description
invoicedetails_shipto_freighttermscode	NUMERIC	Invoicedetail - Shipto_freighttermscode	Invoicedetail - Shipto_freighttermscode
invoicedetails_shipto_line1	TEXT	Invoicedetail - Shipto_line1	Invoicedetail - Shipto_line1
invoicedetails_shipto_line2	TEXT	Invoicedetail - Shipto_line2	Invoicedetail - Shipto_line2
invoicedetails_shipto_line3	TEXT	Invoicedetail - Shipto_line3	Invoicedetail - Shipto_line3
invoicedetails_shipto_name	TEXT	Invoicedetail - Shipto_name	Invoicedetail - Shipto_name
invoicedetails_shipto_postalcode	TEXT	Invoicedetail - Shipto_postalcode	Invoicedetail - Shipto_postalcode
invoicedetails_shipto_stateorprovince	TEXT	Invoicedetail - Shipto_stateorprovince	Invoicedetail - Shipto_stateorprovince
invoicedetails_shipto_telephone	TEXT	Invoicedetail - Shipto_telephone	Invoicedetail - Shipto_telephone
invoicedetails_skippricecalculation	NUMERIC	Invoicedetail - Skippricecalculation	Invoicedetail - Skippricecalculation
invoicedetails_tax	NUMERIC	Invoicedetail - Tax	Invoicedetail - Tax
invoicedetails_tax_base	NUMERIC	Invoicedetail - Tax_base	Invoicedetail - Tax_base
invoicedetails_timezoneruleversionnumber	NUMERIC	Invoicedetail - Timezoneruleversionnumber	Invoicedetail - Timezoneruleversionnumber
invoicedetails_utcconversiontimezonecode	NUMERIC	Invoicedetail - Utcconversiontimezonecode	Invoicedetail - Utcconversiontimezonecode
invoicedetails_versionnumber	NUMERIC	Invoicedetail - Versionnumber	Invoicedetail - Versionnumber
invoicedetails_volumediscountamount	NUMERIC	Invoicedetail - Volumediscountamount	Invoicedetail - Volumediscountamount
invoicedetails_volumediscountamount_base	NUMERIC	Invoicedetail - Volumediscountamount_base	Invoicedetail - Volumediscountamount_base
invoicedetails_willcall	BOOLEAN	Invoicedetail - Willcall	Invoicedetail - Willcall

Microsoft Dynamics 365 invoices fields

The invoices report of the Microsoft Dynamics 365 connector includes 74 fields.

Microsoft Dynamics 365 invoices fields (invoices_billto_city to invoices_processid)

ID	Type	Name	Description
invoices_billto_city	CITY	Invoice - Billto_city	Invoice - Billto_city
invoices_billto_composite	TEXT	Invoice - Billto_composite	Invoice - Billto_composite
invoices_billto_country	COUNTRY	Invoice - Billto_country	Invoice - Billto_country
invoices_billto_fax	TEXT	Invoice - Billto_fax	Invoice - Billto_fax
invoices_billto_line1	TEXT	Invoice - Billto_line1	Invoice - Billto_line1
invoices_billto_line2	TEXT	Invoice - Billto_line2	Invoice - Billto_line2
invoices_billto_line3	TEXT	Invoice - Billto_line3	Invoice - Billto_line3
invoices_billto_name	TEXT	Invoice - Billto_name	Invoice - Billto_name
invoices_billto_postalcode	TEXT	Invoice - Billto_postalcode	Invoice - Billto_postalcode
invoices_billto_stateorprovince	TEXT	Invoice - Billto_stateorprovince	Invoice - Billto_stateorprovince
invoices_billto_telephone	TEXT	Invoice - Billto_telephone	Invoice - Billto_telephone
invoices_createdon	DATE	Invoice - Createdon	Invoice - Createdon
invoices_datedelivered	DATE	Invoice - Datedelivered	Invoice - Datedelivered
invoices_description	TEXT	Invoice - Description	Invoice - Description
invoices_discountamount	NUMERIC	Invoice - Discountamount	Invoice - Discountamount
invoices_discountamount_base	NUMERIC	Invoice - Discountamount_base	Invoice - Discountamount_base
invoices_discountpercentage	NUMERIC	Invoice - Discountpercentage	Invoice - Discountpercentage
invoices_duedate	DATE	Invoice - Duedate	Invoice - Duedate
invoices_emailaddress	TEXT	Invoice - Emailaddress	Invoice - Emailaddress
invoices_entityimage	TEXT	Invoice - Entityimage	Invoice - Entityimage
invoices_entityimage_timestamp	TIMESTAMP	Invoice - Entityimage_timestamp	Invoice - Entityimage_timestamp
invoices_entityimage_url	TEXT	Invoice - Entityimage_url	Invoice - Entityimage_url
invoices_entityimageid	TEXT	Invoice - Entityimageid	Invoice - Entityimageid
invoices_exchangerate	NUMERIC	Invoice - Exchangerate	Invoice - Exchangerate
invoices_freightamount	NUMERIC	Invoice - Freightamount	Invoice - Freightamount
invoices_freightamount_base	NUMERIC	Invoice - Freightamount_base	Invoice - Freightamount_base
invoices_importsequencenumber	NUMERIC	Invoice - Importsequencenumber	Invoice - Importsequencenumber
invoices_invoiceid	TEXT	Invoice - Invoiceid	Invoice - Invoiceid
invoices_invoicenumber	TEXT	Invoice - Invoicenumber	Invoice - Invoicenumber
invoices_ispricelocked	BOOLEAN	Invoice - Ispricelocked	Invoice - Ispricelocked
invoices_lastbackofficesubmit	DATE	Invoice - Lastbackofficesubmit	Invoice - Lastbackofficesubmit
invoices_lastonholdtime	DATE	Invoice - Lastonholdtime	Invoice - Lastonholdtime
invoices_modifiedon	DATE	Invoice - Modifiedon	Invoice - Modifiedon
invoices_name	TEXT	Invoice - Name	Invoice - Name
invoices_onholdtime	NUMERIC	Invoice - Onholdtime	Invoice - Onholdtime
invoices_overriddencreatedon	DATE	Invoice - Overriddencreatedon	Invoice - Overriddencreatedon
invoices_paymenttermscode	NUMERIC	Invoice - Paymenttermscode	Invoice - Paymenttermscode
invoices_pricingerrorcode	NUMERIC	Invoice - Pricingerrorcode	Invoice - Pricingerrorcode
invoices_prioritycode	NUMERIC	Invoice - Prioritycode	Invoice - Prioritycode
invoices_processid	TEXT	Invoice - Processid	Invoice - Processid

Microsoft Dynamics 365 invoices fields (invoices_shippingmethodcode to invoices_willcall)

ID	Type	Name	Description
invoices_shippingmethodcode	NUMERIC	Invoice - Shippingmethodcode	Invoice - Shippingmethodcode
invoices_shipto_city	CITY	Invoice - Shipto_city	Invoice - Shipto_city
invoices_shipto_composite	TEXT	Invoice - Shipto_composite	Invoice - Shipto_composite
invoices_shipto_country	COUNTRY	Invoice - Shipto_country	Invoice - Shipto_country
invoices_shipto_fax	TEXT	Invoice - Shipto_fax	Invoice - Shipto_fax
invoices_shipto_freighttermscode	NUMERIC	Invoice - Shipto_freighttermscode	Invoice - Shipto_freighttermscode
invoices_shipto_line1	TEXT	Invoice - Shipto_line1	Invoice - Shipto_line1
invoices_shipto_line2	TEXT	Invoice - Shipto_line2	Invoice - Shipto_line2
invoices_shipto_line3	TEXT	Invoice - Shipto_line3	Invoice - Shipto_line3
invoices_shipto_name	TEXT	Invoice - Shipto_name	Invoice - Shipto_name
invoices_shipto_postalcode	TEXT	Invoice - Shipto_postalcode	Invoice - Shipto_postalcode
invoices_shipto_stateorprovince	TEXT	Invoice - Shipto_stateorprovince	Invoice - Shipto_stateorprovince
invoices_shipto_telephone	TEXT	Invoice - Shipto_telephone	Invoice - Shipto_telephone
invoices_skippricecalculation	NUMERIC	Invoice - Skippricecalculation	Invoice - Skippricecalculation
invoices_stageid	TEXT	Invoice - Stageid	Invoice - Stageid
invoices_statecode	NUMERIC	Invoice - Statecode	Invoice - Statecode
invoices_statuscode	NUMERIC	Invoice - Statuscode	Invoice - Statuscode
invoices_timezoneruleversionnumber	NUMERIC	Invoice - Timezoneruleversionnumber	Invoice - Timezoneruleversionnumber
invoices_totalamount	NUMERIC	Invoice - Totalamount	Invoice - Totalamount
invoices_totalamount_base	NUMERIC	Invoice - Totalamount_base	Invoice - Totalamount_base
invoices_totalamountlessfreight	NUMERIC	Invoice - Totalamountlessfreight	Invoice - Totalamountlessfreight
invoices_totalamountlessfreight_base	NUMERIC	Invoice - Totalamountlessfreight_base	Invoice - Totalamountlessfreight_base
invoices_totaldiscountamount	NUMERIC	Invoice - Totaldiscountamount	Invoice - Totaldiscountamount
invoices_totaldiscountamount_base	NUMERIC	Invoice - Totaldiscountamount_base	Invoice - Totaldiscountamount_base
invoices_totallineitemamount	NUMERIC	Invoice - Totallineitemamount	Invoice - Totallineitemamount
invoices_totallineitemamount_base	NUMERIC	Invoice - Totallineitemamount_base	Invoice - Totallineitemamount_base
invoices_totallineitemdiscountamount	NUMERIC	Invoice - Totallineitemdiscountamount	Invoice - Totallineitemdiscountamount
invoices_totallineitemdiscountamount_base	NUMERIC	Invoice - Totallineitemdiscountamount_base	Invoice - Totallineitemdiscountamount_base
invoices_totaltax	NUMERIC	Invoice - Totaltax	Invoice - Totaltax
invoices_totaltax_base	NUMERIC	Invoice - Totaltax_base	Invoice - Totaltax_base
invoices_traversedpath	TEXT	Invoice - Traversedpath	Invoice - Traversedpath
invoices_utcconversiontimezonecode	NUMERIC	Invoice - Utcconversiontimezonecode	Invoice - Utcconversiontimezonecode
invoices_versionnumber	NUMERIC	Invoice - Versionnumber	Invoice - Versionnumber
invoices_willcall	BOOLEAN	Invoice - Willcall	Invoice - Willcall

Microsoft Dynamics 365 leadaddresses fields

The leadaddresses report of the Microsoft Dynamics 365 connector includes 31 fields.

ID	Type	Name	Description
leadaddresses_addressnumber	NUMERIC	Leadaddress - Addressnumber	Leadaddress - Addressnumber
leadaddresses_addresstypecode	NUMERIC	Leadaddress - Addresstypecode	Leadaddress - Addresstypecode
leadaddresses_city	CITY	Leadaddress - City	Leadaddress - City
leadaddresses_composite	TEXT	Leadaddress - Composite	Leadaddress - Composite
leadaddresses_country	COUNTRY	Leadaddress - Country	Leadaddress - Country
leadaddresses_county	TEXT	Leadaddress - County	Leadaddress - County
leadaddresses_createdon	DATE	Leadaddress - Createdon	Leadaddress - Createdon
leadaddresses_exchangerate	NUMERIC	Leadaddress - Exchangerate	Leadaddress - Exchangerate
leadaddresses_fax	TEXT	Leadaddress - Fax	Leadaddress - Fax
leadaddresses_importsequencenumber	NUMERIC	Leadaddress - Importsequencenumber	Leadaddress - Importsequencenumber
leadaddresses_latitude	NUMERIC	Leadaddress - Latitude	Leadaddress - Latitude
leadaddresses_leadaddressid	TEXT	Leadaddress - Leadaddressid	Leadaddress - Leadaddressid
leadaddresses_line1	TEXT	Leadaddress - Line1	Leadaddress - Line1
leadaddresses_line2	TEXT	Leadaddress - Line2	Leadaddress - Line2
leadaddresses_line3	TEXT	Leadaddress - Line3	Leadaddress - Line3
leadaddresses_longitude	NUMERIC	Leadaddress - Longitude	Leadaddress - Longitude
leadaddresses_modifiedon	DATE	Leadaddress - Modifiedon	Leadaddress - Modifiedon
leadaddresses_name	TEXT	Leadaddress - Name	Leadaddress - Name
leadaddresses_overriddencreatedon	DATE	Leadaddress - Overriddencreatedon	Leadaddress - Overriddencreatedon
leadaddresses_postalcode	TEXT	Leadaddress - Postalcode	Leadaddress - Postalcode
leadaddresses_postofficebox	TEXT	Leadaddress - Postofficebox	Leadaddress - Postofficebox
leadaddresses_shippingmethodcode	NUMERIC	Leadaddress - Shippingmethodcode	Leadaddress - Shippingmethodcode
leadaddresses_stateorprovince	TEXT	Leadaddress - Stateorprovince	Leadaddress - Stateorprovince
leadaddresses_telephone1	TEXT	Leadaddress - Telephone1	Leadaddress - Telephone1
leadaddresses_telephone2	TEXT	Leadaddress - Telephone2	Leadaddress - Telephone2
leadaddresses_telephone3	TEXT	Leadaddress - Telephone3	Leadaddress - Telephone3
leadaddresses_timezoneruleversionnumber	NUMERIC	Leadaddress - Timezoneruleversionnumber	Leadaddress - Timezoneruleversionnumber
leadaddresses_upszone	TEXT	Leadaddress - Upszone	Leadaddress - Upszone
leadaddresses_utcconversiontimezonecode	NUMERIC	Leadaddress - Utcconversiontimezonecode	Leadaddress - Utcconversiontimezonecode
leadaddresses_utcoffset	NUMERIC	Leadaddress - Utcoffset	Leadaddress - Utcoffset
leadaddresses_versionnumber	NUMERIC	Leadaddress - Versionnumber	Leadaddress - Versionnumber

Microsoft Dynamics 365 leads fields

The leads report of the Microsoft Dynamics 365 connector includes 137 fields.

Microsoft Dynamics 365 leads fields (leads_address1_addressid to leads_address2_telephone1)

ID	Type	Name	Description
leads_address1_addressid	TEXT	Lead - Address1_addressid	Lead - Address1_addressid
leads_address1_addresstypecode	NUMERIC	Lead - Address1_addresstypecode	Lead - Address1_addresstypecode
leads_address1_city	CITY	Lead - Address1_city	Lead - Address1_city
leads_address1_composite	TEXT	Lead - Address1_composite	Lead - Address1_composite
leads_address1_country	COUNTRY	Lead - Address1_country	Lead - Address1_country
leads_address1_county	TEXT	Lead - Address1_county	Lead - Address1_county
leads_address1_fax	TEXT	Lead - Address1_fax	Lead - Address1_fax
leads_address1_latitude	NUMERIC	Lead - Address1_latitude	Lead - Address1_latitude
leads_address1_line1	TEXT	Lead - Address1_line1	Lead - Address1_line1
leads_address1_line2	TEXT	Lead - Address1_line2	Lead - Address1_line2
leads_address1_line3	TEXT	Lead - Address1_line3	Lead - Address1_line3
leads_address1_longitude	NUMERIC	Lead - Address1_longitude	Lead - Address1_longitude
leads_address1_name	TEXT	Lead - Address1_name	Lead - Address1_name
leads_address1_postalcode	TEXT	Lead - Address1_postalcode	Lead - Address1_postalcode
leads_address1_postofficebox	TEXT	Lead - Address1_postofficebox	Lead - Address1_postofficebox
leads_address1_shippingmethodcode	NUMERIC	Lead - Address1_shippingmethodcode	Lead - Address1_shippingmethodcode
leads_address1_stateorprovince	TEXT	Lead - Address1_stateorprovince	Lead - Address1_stateorprovince
leads_address1_telephone1	TEXT	Lead - Address1_telephone1	Lead - Address1_telephone1
leads_address1_telephone2	TEXT	Lead - Address1_telephone2	Lead - Address1_telephone2
leads_address1_telephone3	TEXT	Lead - Address1_telephone3	Lead - Address1_telephone3
leads_address1_upszone	TEXT	Lead - Address1_upszone	Lead - Address1_upszone
leads_address1_utcoffset	NUMERIC	Lead - Address1_utcoffset	Lead - Address1_utcoffset
leads_address2_addressid	TEXT	Lead - Address2_addressid	Lead - Address2_addressid
leads_address2_addresstypecode	NUMERIC	Lead - Address2_addresstypecode	Lead - Address2_addresstypecode
leads_address2_city	CITY	Lead - Address2_city	Lead - Address2_city
leads_address2_composite	TEXT	Lead - Address2_composite	Lead - Address2_composite
leads_address2_country	COUNTRY	Lead - Address2_country	Lead - Address2_country
leads_address2_county	TEXT	Lead - Address2_county	Lead - Address2_county
leads_address2_fax	TEXT	Lead - Address2_fax	Lead - Address2_fax
leads_address2_latitude	NUMERIC	Lead - Address2_latitude	Lead - Address2_latitude
leads_address2_line1	TEXT	Lead - Address2_line1	Lead - Address2_line1
leads_address2_line2	TEXT	Lead - Address2_line2	Lead - Address2_line2
leads_address2_line3	TEXT	Lead - Address2_line3	Lead - Address2_line3
leads_address2_longitude	NUMERIC	Lead - Address2_longitude	Lead - Address2_longitude
leads_address2_name	TEXT	Lead - Address2_name	Lead - Address2_name
leads_address2_postalcode	TEXT	Lead - Address2_postalcode	Lead - Address2_postalcode
leads_address2_postofficebox	TEXT	Lead - Address2_postofficebox	Lead - Address2_postofficebox
leads_address2_shippingmethodcode	NUMERIC	Lead - Address2_shippingmethodcode	Lead - Address2_shippingmethodcode
leads_address2_stateorprovince	TEXT	Lead - Address2_stateorprovince	Lead - Address2_stateorprovince
leads_address2_telephone1	TEXT	Lead - Address2_telephone1	Lead - Address2_telephone1

Microsoft Dynamics 365 leads fields (leads_address2_telephone2 to leads_initialcommunication)

ID	Type	Name	Description
leads_address2_telephone2	TEXT	Lead - Address2_telephone2	Lead - Address2_telephone2
leads_address2_telephone3	TEXT	Lead - Address2_telephone3	Lead - Address2_telephone3
leads_address2_upszone	TEXT	Lead - Address2_upszone	Lead - Address2_upszone
leads_address2_utcoffset	NUMERIC	Lead - Address2_utcoffset	Lead - Address2_utcoffset
leads_budgetamount	NUMERIC	Lead - Budgetamount	Lead - Budgetamount
leads_budgetamount_base	NUMERIC	Lead - Budgetamount_base	Lead - Budgetamount_base
leads_budgetstatus	NUMERIC	Lead - Budgetstatus	Lead - Budgetstatus
leads_businesscard	TEXT	Lead - Businesscard	Lead - Businesscard
leads_businesscardattributes	TEXT	Lead - Businesscardattributes	Lead - Businesscardattributes
leads_companyname	TEXT	Lead - Companyname	Lead - Companyname
leads_confirminterest	BOOLEAN	Lead - Confirminterest	Lead - Confirminterest
leads_createdon	DATE	Lead - Createdon	Lead - Createdon
leads_decisionmaker	BOOLEAN	Lead - Decisionmaker	Lead - Decisionmaker
leads_description	TEXT	Lead - Description	Lead - Description
leads_donotbulkemail	BOOLEAN	Lead - Donotbulkemail	Lead - Donotbulkemail
leads_donotemail	BOOLEAN	Lead - Donotemail	Lead - Donotemail
leads_donotfax	BOOLEAN	Lead - Donotfax	Lead - Donotfax
leads_donotphone	BOOLEAN	Lead - Donotphone	Lead - Donotphone
leads_donotpostalmail	BOOLEAN	Lead - Donotpostalmail	Lead - Donotpostalmail
leads_donotsendmm	BOOLEAN	Lead - Donotsendmm	Lead - Donotsendmm
leads_emailaddress1	TEXT	Lead - Emailaddress1	Lead - Emailaddress1
leads_emailaddress2	TEXT	Lead - Emailaddress2	Lead - Emailaddress2
leads_emailaddress3	TEXT	Lead - Emailaddress3	Lead - Emailaddress3
leads_entityimage	TEXT	Lead - Entityimage	Lead - Entityimage
leads_entityimage_timestamp	TIMESTAMP	Lead - Entityimage_timestamp	Lead - Entityimage_timestamp
leads_entityimage_url	TEXT	Lead - Entityimage_url	Lead - Entityimage_url
leads_entityimageid	TEXT	Lead - Entityimageid	Lead - Entityimageid
leads_estimatedamount	NUMERIC	Lead - Estimatedamount	Lead - Estimatedamount
leads_estimatedamount_base	NUMERIC	Lead - Estimatedamount_base	Lead - Estimatedamount_base
leads_estimatedclosedate	DATE	Lead - Estimatedclosedate	Lead - Estimatedclosedate
leads_estimatedvalue	NUMERIC	Lead - Estimatedvalue	Lead - Estimatedvalue
leads_evaluatefit	BOOLEAN	Lead - Evaluatefit	Lead - Evaluatefit
leads_exchangerate	NUMERIC	Lead - Exchangerate	Lead - Exchangerate
leads_fax	TEXT	Lead - Fax	Lead - Fax
leads_firstname	TEXT	Lead - Firstname	Lead - Firstname
leads_followemail	BOOLEAN	Lead - Followemail	Lead - Followemail
leads_fullname	TEXT	Lead - Fullname	Lead - Fullname
leads_importsequencenumber	NUMERIC	Lead - Importsequencenumber	Lead - Importsequencenumber
leads_industrycode	NUMERIC	Lead - Industrycode	Lead - Industrycode
leads_initialcommunication	NUMERIC	Lead - Initialcommunication	Lead - Initialcommunication

Microsoft Dynamics 365 leads fields (leads_jobtitle to leads_statecode)

ID	Type	Name	Description
leads_jobtitle	TEXT	Lead - Jobtitle	Lead - Jobtitle
leads_lastname	TEXT	Lead - Lastname	Lead - Lastname
leads_lastonholdtime	DATE	Lead - Lastonholdtime	Lead - Lastonholdtime
leads_lastusedincampaign	DATE	Lead - Lastusedincampaign	Lead - Lastusedincampaign
leads_leadid	TEXT	Lead - Leadid	Lead - Leadid
leads_leadqualitycode	NUMERIC	Lead - Leadqualitycode	Lead - Leadqualitycode
leads_leadsourcecode	NUMERIC	Lead - Leadsourcecode	Lead - Leadsourcecode
leads_merged	BOOLEAN	Lead - Merged	Lead - Merged
leads_middlename	TEXT	Lead - Middlename	Lead - Middlename
leads_mobilephone	TEXT	Lead - Mobilephone	Lead - Mobilephone
leads_modifiedon	DATE	Lead - Modifiedon	Lead - Modifiedon
leads_msdyn_gdproptout	BOOLEAN	Lead - Msdyn_gdproptout	Lead - Msdyn_gdproptout
leads_msdyn_leadgrade	NUMERIC	Lead - Msdyn_leadgrade	Lead - Msdyn_leadgrade
leads_msdyn_leadscore	NUMERIC	Lead - Msdyn_leadscore	Lead - Msdyn_leadscore
leads_msdyn_leadscoretrend	NUMERIC	Lead - Msdyn_leadscoretrend	Lead - Msdyn_leadscoretrend
leads_msdyn_salesassignmentresult	NUMERIC	Lead - Msdyn_salesassignmentresult	Lead - Msdyn_salesassignmentresult
leads_msdyn_scorehistory	TEXT	Lead - Msdyn_scorehistory	Lead - Msdyn_scorehistory
leads_msdyn_scorereasons	TEXT	Lead - Msdyn_scorereasons	Lead - Msdyn_scorereasons
leads_need	NUMERIC	Lead - Need	Lead - Need
leads_numberofemployees	NUMERIC	Lead - Numberofemployees	Lead - Numberofemployees
leads_onholdtime	NUMERIC	Lead - Onholdtime	Lead - Onholdtime
leads_overriddencreatedon	DATE	Lead - Overriddencreatedon	Lead - Overriddencreatedon
leads_pager	TEXT	Lead - Pager	Lead - Pager
leads_participatesinworkflow	BOOLEAN	Lead - Participatesinworkflow	Lead - Participatesinworkflow
leads_preferredcontactmethodcode	NUMERIC	Lead - Preferredcontactmethodcode	Lead - Preferredcontactmethodcode
leads_prioritycode	NUMERIC	Lead - Prioritycode	Lead - Prioritycode
leads_processid	TEXT	Lead - Processid	Lead - Processid
leads_purchaseprocess	NUMERIC	Lead - Purchaseprocess	Lead - Purchaseprocess
leads_purchasetimeframe	NUMERIC	Lead - Purchasetimeframe	Lead - Purchasetimeframe
leads_qualificationcomments	TEXT	Lead - Qualificationcomments	Lead - Qualificationcomments
leads_revenue	NUMERIC	Lead - Revenue	Lead - Revenue
leads_revenue_base	NUMERIC	Lead - Revenue_base	Lead - Revenue_base
leads_salesstage	NUMERIC	Lead - Salesstage	Lead - Salesstage
leads_salesstagecode	NUMERIC	Lead - Salesstagecode	Lead - Salesstagecode
leads_salutation	TEXT	Lead - Salutation	Lead - Salutation
leads_schedulefollowup_prospect	DATE	Lead - Schedulefollowup_prospect	Lead - Schedulefollowup_prospect
leads_schedulefollowup_qualify	DATE	Lead - Schedulefollowup_qualify	Lead - Schedulefollowup_qualify
leads_sic	TEXT	Lead - Sic	Lead - Sic
leads_stageid	TEXT	Lead - Stageid	Lead - Stageid
leads_statecode	NUMERIC	Lead - Statecode	Lead - Statecode

Microsoft Dynamics 365 leads fields (leads_statuscode to leads_yomimiddlename)

ID	Type	Name	Description
leads_statuscode	NUMERIC	Lead - Statuscode	Lead - Statuscode
leads_subject	TEXT	Lead - Subject	Lead - Subject
leads_teamsfollowed	NUMERIC	Lead - Teamsfollowed	Lead - Teamsfollowed
leads_telephone1	TEXT	Lead - Telephone1	Lead - Telephone1
leads_telephone2	TEXT	Lead - Telephone2	Lead - Telephone2
leads_telephone3	TEXT	Lead - Telephone3	Lead - Telephone3
leads_timespentbymeonemailandmeetings	TEXT	Lead - Timespentbymeonemailandmeetings	Lead - Timespentbymeonemailandmeetings
leads_timezoneruleversionnumber	NUMERIC	Lead - Timezoneruleversionnumber	Lead - Timezoneruleversionnumber
leads_traversedpath	TEXT	Lead - Traversedpath	Lead - Traversedpath
leads_utcconversiontimezonecode	NUMERIC	Lead - Utcconversiontimezonecode	Lead - Utcconversiontimezonecode
leads_versionnumber	NUMERIC	Lead - Versionnumber	Lead - Versionnumber
leads_websiteurl	TEXT	Lead - Websiteurl	Lead - Websiteurl
leads_yomicompanyname	TEXT	Lead - Yomicompanyname	Lead - Yomicompanyname
leads_yomifirstname	TEXT	Lead - Yomifirstname	Lead - Yomifirstname
leads_yomifullname	TEXT	Lead - Yomifullname	Lead - Yomifullname
leads_yomilastname	TEXT	Lead - Yomilastname	Lead - Yomilastname
leads_yomimiddlename	TEXT	Lead - Yomimiddlename	Lead - Yomimiddlename

Microsoft Dynamics 365 leadtoopportunitysalesprocesses fields

The leadtoopportunitysalesprocesses report of the Microsoft Dynamics 365 connector includes 16 fields.

Microsoft Dynamics 365 lists fields

The lists report of the Microsoft Dynamics 365 connector includes 31 fields.

ID	Type	Name	Description
lists_cost	NUMERIC	List - Cost	List - Cost
lists_cost_base	NUMERIC	List - Cost_base	List - Cost_base
lists_createdfromcode	NUMERIC	List - Createdfromcode	List - Createdfromcode
lists_createdon	DATE	List - Createdon	List - Createdon
lists_description	TEXT	List - Description	List - Description
lists_donotsendonoptout	BOOLEAN	List - Donotsendonoptout	List - Donotsendonoptout
lists_exchangerate	NUMERIC	List - Exchangerate	List - Exchangerate
lists_ignoreinactivelistmembers	BOOLEAN	List - Ignoreinactivelistmembers	List - Ignoreinactivelistmembers
lists_importsequencenumber	NUMERIC	List - Importsequencenumber	List - Importsequencenumber
lists_lastusedon	DATE	List - Lastusedon	List - Lastusedon
lists_listid	TEXT	List - Listid	List - Listid
lists_listname	TEXT	List - Listname	List - Listname
lists_lockstatus	BOOLEAN	List - Lockstatus	List - Lockstatus
lists_membercount	NUMERIC	List - Membercount	List - Membercount
lists_membertype	NUMERIC	List - Membertype	List - Membertype
lists_modifiedon	DATE	List - Modifiedon	List - Modifiedon
lists_overriddencreatedon	DATE	List - Overriddencreatedon	List - Overriddencreatedon
lists_processedmembercount	NUMERIC	List - Processedmembercount	List - Processedmembercount
lists_processfetchxml	TEXT	List - Processfetchxml	List - Processfetchxml
lists_processid	TEXT	List - Processid	List - Processid
lists_purpose	TEXT	List - Purpose	List - Purpose
lists_query	TEXT	List - Query	List - Query
lists_source	TEXT	List - Source	List - Source
lists_stageid	TEXT	List - Stageid	List - Stageid
lists_statecode	NUMERIC	List - Statecode	List - Statecode
lists_statuscode	NUMERIC	List - Statuscode	List - Statuscode
lists_timezoneruleversionnumber	NUMERIC	List - Timezoneruleversionnumber	List - Timezoneruleversionnumber
lists_traversedpath	TEXT	List - Traversedpath	List - Traversedpath
lists_type	BOOLEAN	List - Type	List - Type
lists_utcconversiontimezonecode	NUMERIC	List - Utcconversiontimezonecode	List - Utcconversiontimezonecode
lists_versionnumber	NUMERIC	List - Versionnumber	List - Versionnumber

Microsoft Dynamics 365 metrics fields

The metrics report of the Microsoft Dynamics 365 connector includes 15 fields.

ID	Type	Name	Description
metrics_amountdatatype	NUMERIC	Metric - Amountdatatype	Metric - Amountdatatype
metrics_createdon	DATE	Metric - Createdon	Metric - Createdon
metrics_description	TEXT	Metric - Description	Metric - Description
metrics_importsequencenumber	NUMERIC	Metric - Importsequencenumber	Metric - Importsequencenumber
metrics_isamount	BOOLEAN	Metric - Isamount	Metric - Isamount
metrics_isstretchtracked	BOOLEAN	Metric - Isstretchtracked	Metric - Isstretchtracked
metrics_metricid	TEXT	Metric - Metricid	Metric - Metricid
metrics_modifiedon	DATE	Metric - Modifiedon	Metric - Modifiedon
metrics_name	TEXT	Metric - Name	Metric - Name
metrics_overriddencreatedon	DATE	Metric - Overriddencreatedon	Metric - Overriddencreatedon
metrics_statecode	NUMERIC	Metric - Statecode	Metric - Statecode
metrics_statuscode	NUMERIC	Metric - Statuscode	Metric - Statuscode
metrics_timezoneruleversionnumber	NUMERIC	Metric - Timezoneruleversionnumber	Metric - Timezoneruleversionnumber
metrics_utcconversiontimezonecode	NUMERIC	Metric - Utcconversiontimezonecode	Metric - Utcconversiontimezonecode
metrics_versionnumber	NUMERIC	Metric - Versionnumber	Metric - Versionnumber

Microsoft Dynamics 365 msdyn_assignmentmaps fields

The msdyn_assignmentmaps report of the Microsoft Dynamics 365 connector includes 16 fields.

Microsoft Dynamics 365 msdyn_assignmentrules fields

The msdyn_assignmentrules report of the Microsoft Dynamics 365 connector includes 29 fields.

Microsoft Dynamics 365 msdyn_attribute fields

The msdyn_attribute report of the Microsoft Dynamics 365 connector includes 15 fields.

Microsoft Dynamics 365 msdyn_attributevalues fields

The msdyn_attributevalues report of the Microsoft Dynamics 365 connector includes 13 fields.

ID	Type	Name	Description
msdyn_attributevalues_createdon	DATE	Msdyn_attributevalue - Createdon	Msdyn_attributevalue - Createdon
msdyn_attributevalues_importsequencenumber	NUMERIC	Msdyn_attributevalue - Importsequencenumber	Msdyn_attributevalue - Importsequencenumber
msdyn_attributevalues_modifiedon	DATE	Msdyn_attributevalue - Modifiedon	Msdyn_attributevalue - Modifiedon
msdyn_attributevalues_msdyn_attributevalueid	TEXT	Msdyn_attributevalue - Msdyn_attributevalueid	Msdyn_attributevalue - Msdyn_attributevalueid
msdyn_attributevalues_msdyn_linkedvalue	TEXT	Msdyn_attributevalue - Msdyn_linkedvalue	Msdyn_attributevalue - Msdyn_linkedvalue
msdyn_attributevalues_msdyn_name	TEXT	Msdyn_attributevalue - Msdyn_name	Msdyn_attributevalue - Msdyn_name
msdyn_attributevalues_msdyn_reviewstatus	NUMERIC	Msdyn_attributevalue - Msdyn_reviewstatus	Msdyn_attributevalue - Msdyn_reviewstatus
msdyn_attributevalues_overriddencreatedon	DATE	Msdyn_attributevalue - Overriddencreatedon	Msdyn_attributevalue - Overriddencreatedon
msdyn_attributevalues_statecode	NUMERIC	Msdyn_attributevalue - Statecode	Msdyn_attributevalue - Statecode
msdyn_attributevalues_statuscode	NUMERIC	Msdyn_attributevalue - Statuscode	Msdyn_attributevalue - Statuscode
msdyn_attributevalues_timezoneruleversionnumber	NUMERIC	Msdyn_attributevalue - Timezoneruleversionnumber	Msdyn_attributevalue - Timezoneruleversionnumber
msdyn_attributevalues_utcconversiontimezonecode	NUMERIC	Msdyn_attributevalue - Utcconversiontimezonecode	Msdyn_attributevalue - Utcconversiontimezonecode
msdyn_attributevalues_versionnumber	NUMERIC	Msdyn_attributevalue - Versionnumber	Msdyn_attributevalue - Versionnumber

Microsoft Dynamics 365 msdyn_callablecontexts fields

The msdyn_callablecontexts report of the Microsoft Dynamics 365 connector includes 12 fields.

ID	Type	Name	Description
msdyn_callablecontexts_createdon	DATE	Msdyn_callablecontext - Createdon	Msdyn_callablecontext - Createdon
msdyn_callablecontexts_importsequencenumber	NUMERIC	Msdyn_callablecontext - Importsequencenumber	Msdyn_callablecontext - Importsequencenumber
msdyn_callablecontexts_modifiedon	DATE	Msdyn_callablecontext - Modifiedon	Msdyn_callablecontext - Modifiedon
msdyn_callablecontexts_msdyn_callablecontextid	TEXT	Msdyn_callablecontext - Msdyn_callablecontextid	Msdyn_callablecontext - Msdyn_callablecontextid
msdyn_callablecontexts_msdyn_entitylogicalname	TEXT	Msdyn_callablecontext - Msdyn_entitylogicalname	Msdyn_callablecontext - Msdyn_entitylogicalname
msdyn_callablecontexts_msdyn_entityotc	NUMERIC	Msdyn_callablecontext - Msdyn_entityotc	Msdyn_callablecontext - Msdyn_entityotc
msdyn_callablecontexts_overriddencreatedon	DATE	Msdyn_callablecontext - Overriddencreatedon	Msdyn_callablecontext - Overriddencreatedon
msdyn_callablecontexts_statecode	NUMERIC	Msdyn_callablecontext - Statecode	Msdyn_callablecontext - Statecode
msdyn_callablecontexts_statuscode	NUMERIC	Msdyn_callablecontext - Statuscode	Msdyn_callablecontext - Statuscode
msdyn_callablecontexts_timezoneruleversionnumber	NUMERIC	Msdyn_callablecontext - Timezoneruleversionnumber	Msdyn_callablecontext - Timezoneruleversionnumber
msdyn_callablecontexts_utcconversiontimezonecode	NUMERIC	Msdyn_callablecontext - Utcconversiontimezonecode	Msdyn_callablecontext - Utcconversiontimezonecode
msdyn_callablecontexts_versionnumber	NUMERIC	Msdyn_callablecontext - Versionnumber	Msdyn_callablecontext - Versionnumber

Microsoft Dynamics 365 msdyn_conversationactionitems fields

The msdyn_conversationactionitems report of the Microsoft Dynamics 365 connector includes 21 fields.

Microsoft Dynamics 365 msdyn_conversationaggregatedinsights fields

The msdyn_conversationaggregatedinsights report of the Microsoft Dynamics 365 connector includes 14 fields.

ID	Type	Name	Description
msdyn_conversationaggregatedinsights_createdon	DATE	Msdyn_conversationaggregatedinsights - Createdon	Msdyn_conversationaggregatedinsights - Createdon
msdyn_conversationaggregatedinsights_importsequencenumber	NUMERIC	Msdyn_conversationaggregatedinsights - Importsequencenumber	Msdyn_conversationaggregatedinsights - Importsequencenumber
msdyn_conversationaggregatedinsights_modifiedon	DATE	Msdyn_conversationaggregatedinsights - Modifiedon	Msdyn_conversationaggregatedinsights - Modifiedon
msdyn_conversationaggregatedinsights_msdyn_conversationaggregatedinsightsid	TEXT	Msdyn_conversationaggregatedinsights - Msdyn_conversationaggregatedinsightsid	Msdyn_conversationaggregatedinsights - Msdyn_conversationaggregatedinsightsid
msdyn_conversationaggregatedinsights_msdyn_conversationdurationinms	NUMERIC	Msdyn_conversationaggregatedinsights - Msdyn_conversationdurationinms	Msdyn_conversationaggregatedinsights - Msdyn_conversationdurationinms
msdyn_conversationaggregatedinsights_msdyn_customerlongestmonologueinms	NUMERIC	Msdyn_conversationaggregatedinsights - Msdyn_customerlongestmonologueinms	Msdyn_conversationaggregatedinsights - Msdyn_customerlongestmonologueinms
msdyn_conversationaggregatedinsights_msdyn_name	TEXT	Msdyn_conversationaggregatedinsights - Msdyn_name	Msdyn_conversationaggregatedinsights - Msdyn_name
msdyn_conversationaggregatedinsights_msdyn_switchcount	NUMERIC	Msdyn_conversationaggregatedinsights - Msdyn_switchcount	Msdyn_conversationaggregatedinsights - Msdyn_switchcount
msdyn_conversationaggregatedinsights_overriddencreatedon	DATE	Msdyn_conversationaggregatedinsights - Overriddencreatedon	Msdyn_conversationaggregatedinsights - Overriddencreatedon
msdyn_conversationaggregatedinsights_statecode	NUMERIC	Msdyn_conversationaggregatedinsights - Statecode	Msdyn_conversationaggregatedinsights - Statecode
msdyn_conversationaggregatedinsights_statuscode	NUMERIC	Msdyn_conversationaggregatedinsights - Statuscode	Msdyn_conversationaggregatedinsights - Statuscode
msdyn_conversationaggregatedinsights_timezoneruleversionnumber	NUMERIC	Msdyn_conversationaggregatedinsights - Timezoneruleversionnumber	Msdyn_conversationaggregatedinsights - Timezoneruleversionnumber
msdyn_conversationaggregatedinsights_utcconversiontimezonecode	NUMERIC	Msdyn_conversationaggregatedinsights - Utcconversiontimezonecode	Msdyn_conversationaggregatedinsights - Utcconversiontimezonecode
msdyn_conversationaggregatedinsights_versionnumber	NUMERIC	Msdyn_conversationaggregatedinsights - Versionnumber	Msdyn_conversationaggregatedinsights - Versionnumber

Microsoft Dynamics 365 msdyn_conversationparticipantinsights fields

The msdyn_conversationparticipantinsights report of the Microsoft Dynamics 365 connector includes 25 fields.

Microsoft Dynamics 365 msdyn_conversationparticipantsentiments fields

The msdyn_conversationparticipantsentiments report of the Microsoft Dynamics 365 connector includes 14 fields.

ID	Type	Name	Description
msdyn_conversationparticipantsentiments_createdon	DATE	Msdyn_conversationparticipantsentiment - Createdon	Msdyn_conversationparticipantsentiment - Createdon
msdyn_conversationparticipantsentiments_importsequencenumber	NUMERIC	Msdyn_conversationparticipantsentiment - Importsequencenumber	Msdyn_conversationparticipantsentiment - Importsequencenumber
msdyn_conversationparticipantsentiments_modifiedon	DATE	Msdyn_conversationparticipantsentiment - Modifiedon	Msdyn_conversationparticipantsentiment - Modifiedon
msdyn_conversationparticipantsentiments_msdyn_conversationparticipantsentimentid	TEXT	Msdyn_conversationparticipantsentiment - Msdyn_conversationparticipantsentimentid	Msdyn_conversationparticipantsentiment - Msdyn_conversationparticipantsentimentid
msdyn_conversationparticipantsentiments_msdyn_name	TEXT	Msdyn_conversationparticipantsentiment - Msdyn_name	Msdyn_conversationparticipantsentiment - Msdyn_name
msdyn_conversationparticipantsentiments_msdyn_overallnegativesentiment	NUMERIC	Msdyn_conversationparticipantsentiment - Msdyn_overallnegativesentiment	Msdyn_conversationparticipantsentiment - Msdyn_overallnegativesentiment
msdyn_conversationparticipantsentiments_msdyn_overallneutralsentiment	NUMERIC	Msdyn_conversationparticipantsentiment - Msdyn_overallneutralsentiment	Msdyn_conversationparticipantsentiment - Msdyn_overallneutralsentiment
msdyn_conversationparticipantsentiments_msdyn_overallpositivesentiment	NUMERIC	Msdyn_conversationparticipantsentiment - Msdyn_overallpositivesentiment	Msdyn_conversationparticipantsentiment - Msdyn_overallpositivesentiment
msdyn_conversationparticipantsentiments_overriddencreatedon	DATE	Msdyn_conversationparticipantsentiment - Overriddencreatedon	Msdyn_conversationparticipantsentiment - Overriddencreatedon
msdyn_conversationparticipantsentiments_statecode	NUMERIC	Msdyn_conversationparticipantsentiment - Statecode	Msdyn_conversationparticipantsentiment - Statecode
msdyn_conversationparticipantsentiments_statuscode	NUMERIC	Msdyn_conversationparticipantsentiment - Statuscode	Msdyn_conversationparticipantsentiment - Statuscode
msdyn_conversationparticipantsentiments_timezoneruleversionnumber	NUMERIC	Msdyn_conversationparticipantsentiment - Timezoneruleversionnumber	Msdyn_conversationparticipantsentiment - Timezoneruleversionnumber
msdyn_conversationparticipantsentiments_utcconversiontimezonecode	NUMERIC	Msdyn_conversationparticipantsentiment - Utcconversiontimezonecode	Msdyn_conversationparticipantsentiment - Utcconversiontimezonecode
msdyn_conversationparticipantsentiments_versionnumber	NUMERIC	Msdyn_conversationparticipantsentiment - Versionnumber	Msdyn_conversationparticipantsentiment - Versionnumber

Microsoft Dynamics 365 msdyn_conversationquestions fields

The msdyn_conversationquestions report of the Microsoft Dynamics 365 connector includes 19 fields.

Microsoft Dynamics 365 msdyn_conversationsentiments fields

The msdyn_conversationsentiments report of the Microsoft Dynamics 365 connector includes 14 fields.

ID	Type	Name	Description
msdyn_conversationsentiments_createdon	DATE	Msdyn_conversationsentiment - Createdon	Msdyn_conversationsentiment - Createdon
msdyn_conversationsentiments_importsequencenumber	NUMERIC	Msdyn_conversationsentiment - Importsequencenumber	Msdyn_conversationsentiment - Importsequencenumber
msdyn_conversationsentiments_modifiedon	DATE	Msdyn_conversationsentiment - Modifiedon	Msdyn_conversationsentiment - Modifiedon
msdyn_conversationsentiments_msdyn_conversationsentimentid	TEXT	Msdyn_conversationsentiment - Msdyn_conversationsentimentid	Msdyn_conversationsentiment - Msdyn_conversationsentimentid
msdyn_conversationsentiments_msdyn_customernegativesentiment	NUMERIC	Msdyn_conversationsentiment - Msdyn_customernegativesentiment	Msdyn_conversationsentiment - Msdyn_customernegativesentiment
msdyn_conversationsentiments_msdyn_customerneutralsentiment	NUMERIC	Msdyn_conversationsentiment - Msdyn_customerneutralsentiment	Msdyn_conversationsentiment - Msdyn_customerneutralsentiment
msdyn_conversationsentiments_msdyn_customerpositivesentiment	NUMERIC	Msdyn_conversationsentiment - Msdyn_customerpositivesentiment	Msdyn_conversationsentiment - Msdyn_customerpositivesentiment
msdyn_conversationsentiments_msdyn_name	TEXT	Msdyn_conversationsentiment - Msdyn_name	Msdyn_conversationsentiment - Msdyn_name
msdyn_conversationsentiments_overriddencreatedon	DATE	Msdyn_conversationsentiment - Overriddencreatedon	Msdyn_conversationsentiment - Overriddencreatedon
msdyn_conversationsentiments_statecode	NUMERIC	Msdyn_conversationsentiment - Statecode	Msdyn_conversationsentiment - Statecode
msdyn_conversationsentiments_statuscode	NUMERIC	Msdyn_conversationsentiment - Statuscode	Msdyn_conversationsentiment - Statuscode
msdyn_conversationsentiments_timezoneruleversionnumber	NUMERIC	Msdyn_conversationsentiment - Timezoneruleversionnumber	Msdyn_conversationsentiment - Timezoneruleversionnumber
msdyn_conversationsentiments_utcconversiontimezonecode	NUMERIC	Msdyn_conversationsentiment - Utcconversiontimezonecode	Msdyn_conversationsentiment - Utcconversiontimezonecode
msdyn_conversationsentiments_versionnumber	NUMERIC	Msdyn_conversationsentiment - Versionnumber	Msdyn_conversationsentiment - Versionnumber

Microsoft Dynamics 365 msdyn_conversationsignals fields

The msdyn_conversationsignals report of the Microsoft Dynamics 365 connector includes 20 fields.

Microsoft Dynamics 365 msdyn_conversationsubjects fields

The msdyn_conversationsubjects report of the Microsoft Dynamics 365 connector includes 15 fields.

Microsoft Dynamics 365 msdyn_conversationsummarysuggestions fields

The msdyn_conversationsummarysuggestions report of the Microsoft Dynamics 365 connector includes 19 fields.

Microsoft Dynamics 365 msdyn_conversationsystemtags fields

The msdyn_conversationsystemtags report of the Microsoft Dynamics 365 connector includes 11 fields.

ID	Type	Name	Description
msdyn_conversationsystemtags_createdon	DATE	Msdyn_conversationsystemtag - Createdon	Msdyn_conversationsystemtag - Createdon
msdyn_conversationsystemtags_importsequencenumber	NUMERIC	Msdyn_conversationsystemtag - Importsequencenumber	Msdyn_conversationsystemtag - Importsequencenumber
msdyn_conversationsystemtags_modifiedon	DATE	Msdyn_conversationsystemtag - Modifiedon	Msdyn_conversationsystemtag - Modifiedon
msdyn_conversationsystemtags_msdyn_conversationsystemtagid	TEXT	Msdyn_conversationsystemtag - Msdyn_conversationsystemtagid	Msdyn_conversationsystemtag - Msdyn_conversationsystemtagid
msdyn_conversationsystemtags_msdyn_name	TEXT	Msdyn_conversationsystemtag - Msdyn_name	Msdyn_conversationsystemtag - Msdyn_name
msdyn_conversationsystemtags_overriddencreatedon	DATE	Msdyn_conversationsystemtag - Overriddencreatedon	Msdyn_conversationsystemtag - Overriddencreatedon
msdyn_conversationsystemtags_statecode	NUMERIC	Msdyn_conversationsystemtag - Statecode	Msdyn_conversationsystemtag - Statecode
msdyn_conversationsystemtags_statuscode	NUMERIC	Msdyn_conversationsystemtag - Statuscode	Msdyn_conversationsystemtag - Statuscode
msdyn_conversationsystemtags_timezoneruleversionnumber	NUMERIC	Msdyn_conversationsystemtag - Timezoneruleversionnumber	Msdyn_conversationsystemtag - Timezoneruleversionnumber
msdyn_conversationsystemtags_utcconversiontimezonecode	NUMERIC	Msdyn_conversationsystemtag - Utcconversiontimezonecode	Msdyn_conversationsystemtag - Utcconversiontimezonecode
msdyn_conversationsystemtags_versionnumber	NUMERIC	Msdyn_conversationsystemtag - Versionnumber	Msdyn_conversationsystemtag - Versionnumber

Microsoft Dynamics 365 msdyn_conversationtags fields

The msdyn_conversationtags report of the Microsoft Dynamics 365 connector includes 11 fields.

ID	Type	Name	Description
msdyn_conversationtags_createdon	DATE	Msdyn_conversationtag - Createdon	Msdyn_conversationtag - Createdon
msdyn_conversationtags_importsequencenumber	NUMERIC	Msdyn_conversationtag - Importsequencenumber	Msdyn_conversationtag - Importsequencenumber
msdyn_conversationtags_modifiedon	DATE	Msdyn_conversationtag - Modifiedon	Msdyn_conversationtag - Modifiedon
msdyn_conversationtags_msdyn_conversationtagid	TEXT	Msdyn_conversationtag - Msdyn_conversationtagid	Msdyn_conversationtag - Msdyn_conversationtagid
msdyn_conversationtags_msdyn_name	TEXT	Msdyn_conversationtag - Msdyn_name	Msdyn_conversationtag - Msdyn_name
msdyn_conversationtags_overriddencreatedon	DATE	Msdyn_conversationtag - Overriddencreatedon	Msdyn_conversationtag - Overriddencreatedon
msdyn_conversationtags_statecode	NUMERIC	Msdyn_conversationtag - Statecode	Msdyn_conversationtag - Statecode
msdyn_conversationtags_statuscode	NUMERIC	Msdyn_conversationtag - Statuscode	Msdyn_conversationtag - Statuscode
msdyn_conversationtags_timezoneruleversionnumber	NUMERIC	Msdyn_conversationtag - Timezoneruleversionnumber	Msdyn_conversationtag - Timezoneruleversionnumber
msdyn_conversationtags_utcconversiontimezonecode	NUMERIC	Msdyn_conversationtag - Utcconversiontimezonecode	Msdyn_conversationtag - Utcconversiontimezonecode
msdyn_conversationtags_versionnumber	NUMERIC	Msdyn_conversationtag - Versionnumber	Msdyn_conversationtag - Versionnumber

Microsoft Dynamics 365 msdyn_forecastdefinitions fields

The msdyn_forecastdefinitions report of the Microsoft Dynamics 365 connector includes 19 fields.

Microsoft Dynamics 365 msdyn_forecastinstances fields

The msdyn_forecastinstances report of the Microsoft Dynamics 365 connector includes 36 fields.

Microsoft Dynamics 365 msdyn_forecastrecurrences fields

The msdyn_forecastrecurrences report of the Microsoft Dynamics 365 connector includes 23 fields.

Microsoft Dynamics 365 msdyn_ocrecordings fields

The msdyn_ocrecordings report of the Microsoft Dynamics 365 connector includes 17 fields.

Microsoft Dynamics 365 msdyn_salesassignmentsettings fields

The msdyn_salesassignmentsettings report of the Microsoft Dynamics 365 connector includes 20 fields.

Microsoft Dynamics 365 msdyn_salesroutingruns fields

The msdyn_salesroutingruns report of the Microsoft Dynamics 365 connector includes 18 fields.

Microsoft Dynamics 365 msdyn_saruninstances fields

The msdyn_saruninstances report of the Microsoft Dynamics 365 connector includes 20 fields.

Microsoft Dynamics 365 msdyn_sciconversations fields

The msdyn_sciconversations report of the Microsoft Dynamics 365 connector includes 19 fields.

Microsoft Dynamics 365 msdyn_segmentattributes fields

The msdyn_segmentattributes report of the Microsoft Dynamics 365 connector includes 16 fields.

Microsoft Dynamics 365 msdyn_segments fields

The msdyn_segments report of the Microsoft Dynamics 365 connector includes 19 fields.

Microsoft Dynamics 365 msdyn_transcripts fields

The msdyn_transcripts report of the Microsoft Dynamics 365 connector includes 21 fields.

Microsoft Dynamics 365 opportunities fields

The opportunities report of the Microsoft Dynamics 365 connector includes 97 fields.

Microsoft Dynamics 365 opportunities fields (opportunities_actualclosedate to opportunities_msdyn_forecastcategory)

ID	Type	Name	Description
opportunities_actualclosedate	DATE	Opportunity - Actualclosedate	Opportunity - Actualclosedate
opportunities_actualvalue	NUMERIC	Opportunity - Actualvalue	Opportunity - Actualvalue
opportunities_actualvalue_base	NUMERIC	Opportunity - Actualvalue_base	Opportunity - Actualvalue_base
opportunities_budgetamount	NUMERIC	Opportunity - Budgetamount	Opportunity - Budgetamount
opportunities_budgetamount_base	NUMERIC	Opportunity - Budgetamount_base	Opportunity - Budgetamount_base
opportunities_budgetstatus	NUMERIC	Opportunity - Budgetstatus	Opportunity - Budgetstatus
opportunities_captureproposalfeedback	BOOLEAN	Opportunity - Captureproposalfeedback	Opportunity - Captureproposalfeedback
opportunities_closeprobability	NUMERIC	Opportunity - Closeprobability	Opportunity - Closeprobability
opportunities_completefinalproposal	BOOLEAN	Opportunity - Completefinalproposal	Opportunity - Completefinalproposal
opportunities_completeinternalreview	BOOLEAN	Opportunity - Completeinternalreview	Opportunity - Completeinternalreview
opportunities_confirminterest	BOOLEAN	Opportunity - Confirminterest	Opportunity - Confirminterest
opportunities_createdon	DATE	Opportunity - Createdon	Opportunity - Createdon
opportunities_currentsituation	TEXT	Opportunity - Currentsituation	Opportunity - Currentsituation
opportunities_customerneed	TEXT	Opportunity - Customerneed	Opportunity - Customerneed
opportunities_customerpainpoints	TEXT	Opportunity - Customerpainpoints	Opportunity - Customerpainpoints
opportunities_decisionmaker	BOOLEAN	Opportunity - Decisionmaker	Opportunity - Decisionmaker
opportunities_description	TEXT	Opportunity - Description	Opportunity - Description
opportunities_developproposal	BOOLEAN	Opportunity - Developproposal	Opportunity - Developproposal
opportunities_discountamount	NUMERIC	Opportunity - Discountamount	Opportunity - Discountamount
opportunities_discountamount_base	NUMERIC	Opportunity - Discountamount_base	Opportunity - Discountamount_base
opportunities_discountpercentage	NUMERIC	Opportunity - Discountpercentage	Opportunity - Discountpercentage
opportunities_emailaddress	TEXT	Opportunity - Emailaddress	Opportunity - Emailaddress
opportunities_estimatedclosedate	DATE	Opportunity - Estimatedclosedate	Opportunity - Estimatedclosedate
opportunities_estimatedvalue	NUMERIC	Opportunity - Estimatedvalue	Opportunity - Estimatedvalue
opportunities_estimatedvalue_base	NUMERIC	Opportunity - Estimatedvalue_base	Opportunity - Estimatedvalue_base
opportunities_evaluatefit	BOOLEAN	Opportunity - Evaluatefit	Opportunity - Evaluatefit
opportunities_exchangerate	NUMERIC	Opportunity - Exchangerate	Opportunity - Exchangerate
opportunities_filedebrief	BOOLEAN	Opportunity - Filedebrief	Opportunity - Filedebrief
opportunities_finaldecisiondate	DATE	Opportunity - Finaldecisiondate	Opportunity - Finaldecisiondate
opportunities_freightamount	NUMERIC	Opportunity - Freightamount	Opportunity - Freightamount
opportunities_freightamount_base	NUMERIC	Opportunity - Freightamount_base	Opportunity - Freightamount_base
opportunities_identifycompetitors	BOOLEAN	Opportunity - Identifycompetitors	Opportunity - Identifycompetitors
opportunities_identifycustomercontacts	BOOLEAN	Opportunity - Identifycustomercontacts	Opportunity - Identifycustomercontacts
opportunities_identifypursuitteam	BOOLEAN	Opportunity - Identifypursuitteam	Opportunity - Identifypursuitteam
opportunities_importsequencenumber	NUMERIC	Opportunity - Importsequencenumber	Opportunity - Importsequencenumber
opportunities_initialcommunication	NUMERIC	Opportunity - Initialcommunication	Opportunity - Initialcommunication
opportunities_isrevenuesystemcalculated	BOOLEAN	Opportunity - Isrevenuesystemcalculated	Opportunity - Isrevenuesystemcalculated
opportunities_lastonholdtime	DATE	Opportunity - Lastonholdtime	Opportunity - Lastonholdtime
opportunities_modifiedon	DATE	Opportunity - Modifiedon	Opportunity - Modifiedon
opportunities_msdyn_forecastcategory	NUMERIC	Opportunity - Msdyn_forecastcategory	Opportunity - Msdyn_forecastcategory

Microsoft Dynamics 365 opportunities fields (opportunities_msdyn_gdproptout to opportunities_timeline)

ID	Type	Name	Description
opportunities_msdyn_gdproptout	BOOLEAN	Opportunity - Msdyn_gdproptout	Opportunity - Msdyn_gdproptout
opportunities_msdyn_opportunitygrade	NUMERIC	Opportunity - Msdyn_opportunitygrade	Opportunity - Msdyn_opportunitygrade
opportunities_msdyn_opportunityscore	NUMERIC	Opportunity - Msdyn_opportunityscore	Opportunity - Msdyn_opportunityscore
opportunities_msdyn_opportunityscoretrend	NUMERIC	Opportunity - Msdyn_opportunityscoretrend	Opportunity - Msdyn_opportunityscoretrend
opportunities_msdyn_scorehistory	TEXT	Opportunity - Msdyn_scorehistory	Opportunity - Msdyn_scorehistory
opportunities_msdyn_scorereasons	TEXT	Opportunity - Msdyn_scorereasons	Opportunity - Msdyn_scorereasons
opportunities_msdyn_similaropportunities	TEXT	Opportunity - Msdyn_similaropportunities	Opportunity - Msdyn_similaropportunities
opportunities_name	TEXT	Opportunity - Name	Opportunity - Name
opportunities_need	NUMERIC	Opportunity - Need	Opportunity - Need
opportunities_onholdtime	NUMERIC	Opportunity - Onholdtime	Opportunity - Onholdtime
opportunities_opportunityid	TEXT	Opportunity - Opportunityid	Opportunity - Opportunityid
opportunities_opportunityratingcode	NUMERIC	Opportunity - Opportunityratingcode	Opportunity - Opportunityratingcode
opportunities_overriddencreatedon	DATE	Opportunity - Overriddencreatedon	Opportunity - Overriddencreatedon
opportunities_participatesinworkflow	BOOLEAN	Opportunity - Participatesinworkflow	Opportunity - Participatesinworkflow
opportunities_presentfinalproposal	BOOLEAN	Opportunity - Presentfinalproposal	Opportunity - Presentfinalproposal
opportunities_presentproposal	BOOLEAN	Opportunity - Presentproposal	Opportunity - Presentproposal
opportunities_pricingerrorcode	NUMERIC	Opportunity - Pricingerrorcode	Opportunity - Pricingerrorcode
opportunities_prioritycode	NUMERIC	Opportunity - Prioritycode	Opportunity - Prioritycode
opportunities_processid	TEXT	Opportunity - Processid	Opportunity - Processid
opportunities_proposedsolution	TEXT	Opportunity - Proposedsolution	Opportunity - Proposedsolution
opportunities_purchaseprocess	NUMERIC	Opportunity - Purchaseprocess	Opportunity - Purchaseprocess
opportunities_purchasetimeframe	NUMERIC	Opportunity - Purchasetimeframe	Opportunity - Purchasetimeframe
opportunities_pursuitdecision	BOOLEAN	Opportunity - Pursuitdecision	Opportunity - Pursuitdecision
opportunities_qualificationcomments	TEXT	Opportunity - Qualificationcomments	Opportunity - Qualificationcomments
opportunities_quotecomments	TEXT	Opportunity - Quotecomments	Opportunity - Quotecomments
opportunities_resolvefeedback	BOOLEAN	Opportunity - Resolvefeedback	Opportunity - Resolvefeedback
opportunities_salesstage	NUMERIC	Opportunity - Salesstage	Opportunity - Salesstage
opportunities_salesstagecode	NUMERIC	Opportunity - Salesstagecode	Opportunity - Salesstagecode
opportunities_schedulefollowup_prospect	DATE	Opportunity - Schedulefollowup_prospect	Opportunity - Schedulefollowup_prospect
opportunities_schedulefollowup_qualify	DATE	Opportunity - Schedulefollowup_qualify	Opportunity - Schedulefollowup_qualify
opportunities_scheduleproposalmeeting	DATE	Opportunity - Scheduleproposalmeeting	Opportunity - Scheduleproposalmeeting
opportunities_sendthankyounote	BOOLEAN	Opportunity - Sendthankyounote	Opportunity - Sendthankyounote
opportunities_skippricecalculation	NUMERIC	Opportunity - Skippricecalculation	Opportunity - Skippricecalculation
opportunities_stageid	TEXT	Opportunity - Stageid	Opportunity - Stageid
opportunities_statecode	NUMERIC	Opportunity - Statecode	Opportunity - Statecode
opportunities_statuscode	NUMERIC	Opportunity - Statuscode	Opportunity - Statuscode
opportunities_stepid	TEXT	Opportunity - Stepid	Opportunity - Stepid
opportunities_stepname	TEXT	Opportunity - Stepname	Opportunity - Stepname
opportunities_teamsfollowed	NUMERIC	Opportunity - Teamsfollowed	Opportunity - Teamsfollowed
opportunities_timeline	NUMERIC	Opportunity - Timeline	Opportunity - Timeline

Microsoft Dynamics 365 opportunities fields (opportunities_timespentbymeonemailandmeetings to opportunities_versionnumber)

Microsoft Dynamics 365 opportunitycloses fields

The opportunitycloses report of the Microsoft Dynamics 365 connector includes 8 fields.

ID	Type	Name	Description
opportunitycloses_actualrevenue	NUMERIC	Opportunityclose - Actualrevenue	Opportunityclose - Actualrevenue
opportunitycloses_actualrevenue_base	NUMERIC	Opportunityclose - Actualrevenue_base	Opportunityclose - Actualrevenue_base
opportunitycloses_category	TEXT	Opportunityclose - Category	Opportunityclose - Category
opportunitycloses_importsequencenumber	NUMERIC	Opportunityclose - Importsequencenumber	Opportunityclose - Importsequencenumber
opportunitycloses_opportunitystatecode	NUMERIC	Opportunityclose - Opportunitystatecode	Opportunityclose - Opportunitystatecode
opportunitycloses_opportunitystatuscode	NUMERIC	Opportunityclose - Opportunitystatuscode	Opportunityclose - Opportunitystatuscode
opportunitycloses_overriddencreatedon	DATE	Opportunityclose - Overriddencreatedon	Opportunityclose - Overriddencreatedon
opportunitycloses_subcategory	TEXT	Opportunityclose - Subcategory	Opportunityclose - Subcategory

Microsoft Dynamics 365 opportunityproducts fields

The opportunityproducts report of the Microsoft Dynamics 365 connector includes 41 fields.

Microsoft Dynamics 365 opportunityproducts fields (opportunityproducts_baseamount to opportunityproducts_volumediscountamount)

Microsoft Dynamics 365 opportunityproducts fields (opportunityproducts_volumediscountamount_base to opportunityproducts_volumediscountamount_base)

ID	Type	Name	Description
opportunityproducts_volumediscountamount_base	NUMERIC	Opportunityproduct - Volumediscountamount_base	Opportunityproduct - Volumediscountamount_base

Microsoft Dynamics 365 opportunitysalesprocesses fields

The opportunitysalesprocesses report of the Microsoft Dynamics 365 connector includes 16 fields.

Microsoft Dynamics 365 ordercloses fields

The ordercloses report of the Microsoft Dynamics 365 connector includes 6 fields.

ID	Type	Name	Description
ordercloses_category	TEXT	Orderclose - Category	Orderclose - Category
ordercloses_importsequencenumber	NUMERIC	Orderclose - Importsequencenumber	Orderclose - Importsequencenumber
ordercloses_ordernumber	TEXT	Orderclose - Ordernumber	Orderclose - Ordernumber
ordercloses_overriddencreatedon	DATE	Orderclose - Overriddencreatedon	Orderclose - Overriddencreatedon
ordercloses_revision	NUMERIC	Orderclose - Revision	Orderclose - Revision
ordercloses_subcategory	TEXT	Orderclose - Subcategory	Orderclose - Subcategory

Microsoft Dynamics 365 pricelevels fields

The pricelevels report of the Microsoft Dynamics 365 connector includes 18 fields.

ID	Type	Name	Description
pricelevels_begindate	DATE	Pricelevel - Begindate	Pricelevel - Begindate
pricelevels_createdon	DATE	Pricelevel - Createdon	Pricelevel - Createdon
pricelevels_description	TEXT	Pricelevel - Description	Pricelevel - Description
pricelevels_enddate	DATE	Pricelevel - Enddate	Pricelevel - Enddate
pricelevels_exchangerate	NUMERIC	Pricelevel - Exchangerate	Pricelevel - Exchangerate
pricelevels_freighttermscode	NUMERIC	Pricelevel - Freighttermscode	Pricelevel - Freighttermscode
pricelevels_importsequencenumber	NUMERIC	Pricelevel - Importsequencenumber	Pricelevel - Importsequencenumber
pricelevels_modifiedon	DATE	Pricelevel - Modifiedon	Pricelevel - Modifiedon
pricelevels_name	TEXT	Pricelevel - Name	Pricelevel - Name
pricelevels_overriddencreatedon	DATE	Pricelevel - Overriddencreatedon	Pricelevel - Overriddencreatedon
pricelevels_paymentmethodcode	NUMERIC	Pricelevel - Paymentmethodcode	Pricelevel - Paymentmethodcode
pricelevels_pricelevelid	TEXT	Pricelevel - Pricelevelid	Pricelevel - Pricelevelid
pricelevels_shippingmethodcode	NUMERIC	Pricelevel - Shippingmethodcode	Pricelevel - Shippingmethodcode
pricelevels_statecode	NUMERIC	Pricelevel - Statecode	Pricelevel - Statecode
pricelevels_statuscode	NUMERIC	Pricelevel - Statuscode	Pricelevel - Statuscode
pricelevels_timezoneruleversionnumber	NUMERIC	Pricelevel - Timezoneruleversionnumber	Pricelevel - Timezoneruleversionnumber
pricelevels_utcconversiontimezonecode	NUMERIC	Pricelevel - Utcconversiontimezonecode	Pricelevel - Utcconversiontimezonecode
pricelevels_versionnumber	NUMERIC	Pricelevel - Versionnumber	Pricelevel - Versionnumber

Microsoft Dynamics 365 productassociations fields

The productassociations report of the Microsoft Dynamics 365 connector includes 15 fields.

Microsoft Dynamics 365 productpricelevels fields

The productpricelevels report of the Microsoft Dynamics 365 connector includes 23 fields.

Microsoft Dynamics 365 products fields

The products report of the Microsoft Dynamics 365 connector includes 47 fields.

Microsoft Dynamics 365 products fields (products_createdon to products_traversedpath)

ID	Type	Name	Description
products_createdon	DATE	Product - Createdon	Product - Createdon
products_currentcost	NUMERIC	Product - Currentcost	Product - Currentcost
products_currentcost_base	NUMERIC	Product - Currentcost_base	Product - Currentcost_base
products_description	TEXT	Product - Description	Product - Description
products_dmtimportstate	NUMERIC	Product - Dmtimportstate	Product - Dmtimportstate
products_entityimage	TEXT	Product - Entityimage	Product - Entityimage
products_entityimage_timestamp	TIMESTAMP	Product - Entityimage_timestamp	Product - Entityimage_timestamp
products_entityimage_url	TEXT	Product - Entityimage_url	Product - Entityimage_url
products_entityimageid	TEXT	Product - Entityimageid	Product - Entityimageid
products_exchangerate	NUMERIC	Product - Exchangerate	Product - Exchangerate
products_hierarchypath	TEXT	Product - Hierarchypath	Product - Hierarchypath
products_importsequencenumber	NUMERIC	Product - Importsequencenumber	Product - Importsequencenumber
products_iskit	BOOLEAN	Product - Iskit	Product - Iskit
products_isreparented	BOOLEAN	Product - Isreparented	Product - Isreparented
products_isstockitem	BOOLEAN	Product - Isstockitem	Product - Isstockitem
products_modifiedon	DATE	Product - Modifiedon	Product - Modifiedon
products_msdyn_gdproptout	BOOLEAN	Product - Msdyn_gdproptout	Product - Msdyn_gdproptout
products_name	TEXT	Product - Name	Product - Name
products_overriddencreatedon	DATE	Product - Overriddencreatedon	Product - Overriddencreatedon
products_price	NUMERIC	Product - Price	Product - Price
products_price_base	NUMERIC	Product - Price_base	Product - Price_base
products_processid	TEXT	Product - Processid	Product - Processid
products_productid	TEXT	Product - Productid	Product - Productid
products_productnumber	TEXT	Product - Productnumber	Product - Productnumber
products_productstructure	NUMERIC	Product - Productstructure	Product - Productstructure
products_producttypecode	NUMERIC	Product - Producttypecode	Product - Producttypecode
products_producturl	TEXT	Product - Producturl	Product - Producturl
products_quantitydecimal	NUMERIC	Product - Quantitydecimal	Product - Quantitydecimal
products_quantityonhand	NUMERIC	Product - Quantityonhand	Product - Quantityonhand
products_size	TEXT	Product - Size	Product - Size
products_stageid	TEXT	Product - Stageid	Product - Stageid
products_standardcost	NUMERIC	Product - Standardcost	Product - Standardcost
products_standardcost_base	NUMERIC	Product - Standardcost_base	Product - Standardcost_base
products_statecode	NUMERIC	Product - Statecode	Product - Statecode
products_statuscode	NUMERIC	Product - Statuscode	Product - Statuscode
products_stockvolume	NUMERIC	Product - Stockvolume	Product - Stockvolume
products_stockweight	NUMERIC	Product - Stockweight	Product - Stockweight
products_suppliername	TEXT	Product - Suppliername	Product - Suppliername
products_timezoneruleversionnumber	NUMERIC	Product - Timezoneruleversionnumber	Product - Timezoneruleversionnumber
products_traversedpath	TEXT	Product - Traversedpath	Product - Traversedpath

Microsoft Dynamics 365 products fields (products_utcconversiontimezonecode to products_versionnumber)

ID	Type	Name	Description
products_utcconversiontimezonecode	NUMERIC	Product - Utcconversiontimezonecode	Product - Utcconversiontimezonecode
products_validfromdate	DATE	Product - Validfromdate	Product - Validfromdate
products_validtodate	DATE	Product - Validtodate	Product - Validtodate
products_vendorid	TEXT	Product - Vendorid	Product - Vendorid
products_vendorname	TEXT	Product - Vendorname	Product - Vendorname
products_vendorpartnumber	TEXT	Product - Vendorpartnumber	Product - Vendorpartnumber
products_versionnumber	NUMERIC	Product - Versionnumber	Product - Versionnumber

Microsoft Dynamics 365 productsubstitutes fields

The productsubstitutes report of the Microsoft Dynamics 365 connector includes 14 fields.

ID	Type	Name	Description
productsubstitutes_createdon	DATE	Productsubstitute - Createdon	Productsubstitute - Createdon
productsubstitutes_direction	NUMERIC	Productsubstitute - Direction	Productsubstitute - Direction
productsubstitutes_exchangerate	NUMERIC	Productsubstitute - Exchangerate	Productsubstitute - Exchangerate
productsubstitutes_importsequencenumber	NUMERIC	Productsubstitute - Importsequencenumber	Productsubstitute - Importsequencenumber
productsubstitutes_modifiedon	DATE	Productsubstitute - Modifiedon	Productsubstitute - Modifiedon
productsubstitutes_name	TEXT	Productsubstitute - Name	Productsubstitute - Name
productsubstitutes_overriddencreatedon	DATE	Productsubstitute - Overriddencreatedon	Productsubstitute - Overriddencreatedon
productsubstitutes_productsubstituteid	TEXT	Productsubstitute - Productsubstituteid	Productsubstitute - Productsubstituteid
productsubstitutes_salesrelationshiptype	NUMERIC	Productsubstitute - Salesrelationshiptype	Productsubstitute - Salesrelationshiptype
productsubstitutes_statecode	NUMERIC	Productsubstitute - Statecode	Productsubstitute - Statecode
productsubstitutes_statuscode	NUMERIC	Productsubstitute - Statuscode	Productsubstitute - Statuscode
productsubstitutes_timezoneruleversionnumber	NUMERIC	Productsubstitute - Timezoneruleversionnumber	Productsubstitute - Timezoneruleversionnumber
productsubstitutes_utcconversiontimezonecode	NUMERIC	Productsubstitute - Utcconversiontimezonecode	Productsubstitute - Utcconversiontimezonecode
productsubstitutes_versionnumber	NUMERIC	Productsubstitute - Versionnumber	Productsubstitute - Versionnumber

Microsoft Dynamics 365 quotecloses fields

The quotecloses report of the Microsoft Dynamics 365 connector includes 6 fields.

ID	Type	Name	Description
quotecloses_category	TEXT	Quoteclose - Category	Quoteclose - Category
quotecloses_importsequencenumber	NUMERIC	Quoteclose - Importsequencenumber	Quoteclose - Importsequencenumber
quotecloses_overriddencreatedon	DATE	Quoteclose - Overriddencreatedon	Quoteclose - Overriddencreatedon
quotecloses_quotenumber	TEXT	Quoteclose - Quotenumber	Quoteclose - Quotenumber
quotecloses_revision	NUMERIC	Quoteclose - Revision	Quoteclose - Revision
quotecloses_subcategory	TEXT	Quoteclose - Subcategory	Quoteclose - Subcategory

Microsoft Dynamics 365 quotedetails fields

The quotedetails report of the Microsoft Dynamics 365 connector includes 54 fields.

Microsoft Dynamics 365 quotedetails fields (quotedetails_baseamount to quotedetails_shipto_line2)

ID	Type	Name	Description
quotedetails_baseamount	NUMERIC	Quotedetail - Baseamount	Quotedetail - Baseamount
quotedetails_baseamount_base	NUMERIC	Quotedetail - Baseamount_base	Quotedetail - Baseamount_base
quotedetails_createdon	DATE	Quotedetail - Createdon	Quotedetail - Createdon
quotedetails_description	TEXT	Quotedetail - Description	Quotedetail - Description
quotedetails_exchangerate	NUMERIC	Quotedetail - Exchangerate	Quotedetail - Exchangerate
quotedetails_extendedamount	NUMERIC	Quotedetail - Extendedamount	Quotedetail - Extendedamount
quotedetails_extendedamount_base	NUMERIC	Quotedetail - Extendedamount_base	Quotedetail - Extendedamount_base
quotedetails_importsequencenumber	NUMERIC	Quotedetail - Importsequencenumber	Quotedetail - Importsequencenumber
quotedetails_ispriceoverridden	BOOLEAN	Quotedetail - Ispriceoverridden	Quotedetail - Ispriceoverridden
quotedetails_isproductoverridden	BOOLEAN	Quotedetail - Isproductoverridden	Quotedetail - Isproductoverridden
quotedetails_lineitemnumber	NUMERIC	Quotedetail - Lineitemnumber	Quotedetail - Lineitemnumber
quotedetails_manualdiscountamount	NUMERIC	Quotedetail - Manualdiscountamount	Quotedetail - Manualdiscountamount
quotedetails_manualdiscountamount_base	NUMERIC	Quotedetail - Manualdiscountamount_base	Quotedetail - Manualdiscountamount_base
quotedetails_modifiedon	DATE	Quotedetail - Modifiedon	Quotedetail - Modifiedon
quotedetails_overriddencreatedon	DATE	Quotedetail - Overriddencreatedon	Quotedetail - Overriddencreatedon
quotedetails_parentbundleid	TEXT	Quotedetail - Parentbundleid	Quotedetail - Parentbundleid
quotedetails_priceperunit	NUMERIC	Quotedetail - Priceperunit	Quotedetail - Priceperunit
quotedetails_priceperunit_base	NUMERIC	Quotedetail - Priceperunit_base	Quotedetail - Priceperunit_base
quotedetails_pricingerrorcode	NUMERIC	Quotedetail - Pricingerrorcode	Quotedetail - Pricingerrorcode
quotedetails_productassociationid	TEXT	Quotedetail - Productassociationid	Quotedetail - Productassociationid
quotedetails_productdescription	TEXT	Quotedetail - Productdescription	Quotedetail - Productdescription
quotedetails_productname	TEXT	Quotedetail - Productname	Quotedetail - Productname
quotedetails_productnumber	TEXT	Quotedetail - Productnumber	Quotedetail - Productnumber
quotedetails_producttypecode	NUMERIC	Quotedetail - Producttypecode	Quotedetail - Producttypecode
quotedetails_propertyconfigurationstatus	NUMERIC	Quotedetail - Propertyconfigurationstatus	Quotedetail - Propertyconfigurationstatus
quotedetails_quantity	NUMERIC	Quotedetail - Quantity	Quotedetail - Quantity
quotedetails_quotecreationmethod	NUMERIC	Quotedetail - Quotecreationmethod	Quotedetail - Quotecreationmethod
quotedetails_quotedetailid	TEXT	Quotedetail - Quotedetailid	Quotedetail - Quotedetailid
quotedetails_quotedetailname	TEXT	Quotedetail - Quotedetailname	Quotedetail - Quotedetailname
quotedetails_quotestatecode	NUMERIC	Quotedetail - Quotestatecode	Quotedetail - Quotestatecode
quotedetails_requestdeliveryby	DATE	Quotedetail - Requestdeliveryby	Quotedetail - Requestdeliveryby
quotedetails_sequencenumber	NUMERIC	Quotedetail - Sequencenumber	Quotedetail - Sequencenumber
quotedetails_shipto_addressid	TEXT	Quotedetail - Shipto_addressid	Quotedetail - Shipto_addressid
quotedetails_shipto_city	CITY	Quotedetail - Shipto_city	Quotedetail - Shipto_city
quotedetails_shipto_contactname	TEXT	Quotedetail - Shipto_contactname	Quotedetail - Shipto_contactname
quotedetails_shipto_country	COUNTRY	Quotedetail - Shipto_country	Quotedetail - Shipto_country
quotedetails_shipto_fax	TEXT	Quotedetail - Shipto_fax	Quotedetail - Shipto_fax
quotedetails_shipto_freighttermscode	NUMERIC	Quotedetail - Shipto_freighttermscode	Quotedetail - Shipto_freighttermscode
quotedetails_shipto_line1	TEXT	Quotedetail - Shipto_line1	Quotedetail - Shipto_line1
quotedetails_shipto_line2	TEXT	Quotedetail - Shipto_line2	Quotedetail - Shipto_line2

Microsoft Dynamics 365 quotedetails fields (quotedetails_shipto_line3 to quotedetails_willcall)

ID	Type	Name	Description
quotedetails_shipto_line3	TEXT	Quotedetail - Shipto_line3	Quotedetail - Shipto_line3
quotedetails_shipto_name	TEXT	Quotedetail - Shipto_name	Quotedetail - Shipto_name
quotedetails_shipto_postalcode	TEXT	Quotedetail - Shipto_postalcode	Quotedetail - Shipto_postalcode
quotedetails_shipto_stateorprovince	TEXT	Quotedetail - Shipto_stateorprovince	Quotedetail - Shipto_stateorprovince
quotedetails_shipto_telephone	TEXT	Quotedetail - Shipto_telephone	Quotedetail - Shipto_telephone
quotedetails_skippricecalculation	NUMERIC	Quotedetail - Skippricecalculation	Quotedetail - Skippricecalculation
quotedetails_tax	NUMERIC	Quotedetail - Tax	Quotedetail - Tax
quotedetails_tax_base	NUMERIC	Quotedetail - Tax_base	Quotedetail - Tax_base
quotedetails_timezoneruleversionnumber	NUMERIC	Quotedetail - Timezoneruleversionnumber	Quotedetail - Timezoneruleversionnumber
quotedetails_utcconversiontimezonecode	NUMERIC	Quotedetail - Utcconversiontimezonecode	Quotedetail - Utcconversiontimezonecode
quotedetails_versionnumber	NUMERIC	Quotedetail - Versionnumber	Quotedetail - Versionnumber
quotedetails_volumediscountamount	NUMERIC	Quotedetail - Volumediscountamount	Quotedetail - Volumediscountamount
quotedetails_volumediscountamount_base	NUMERIC	Quotedetail - Volumediscountamount_base	Quotedetail - Volumediscountamount_base
quotedetails_willcall	BOOLEAN	Quotedetail - Willcall	Quotedetail - Willcall

Microsoft Dynamics 365 quotes fields

The quotes report of the Microsoft Dynamics 365 connector includes 77 fields.

Microsoft Dynamics 365 quotes fields (quotes_billto_addressid to quotes_requestdeliveryby)

ID	Type	Name	Description
quotes_billto_addressid	TEXT	Quote - Billto_addressid	Quote - Billto_addressid
quotes_billto_city	CITY	Quote - Billto_city	Quote - Billto_city
quotes_billto_composite	TEXT	Quote - Billto_composite	Quote - Billto_composite
quotes_billto_contactname	TEXT	Quote - Billto_contactname	Quote - Billto_contactname
quotes_billto_country	COUNTRY	Quote - Billto_country	Quote - Billto_country
quotes_billto_fax	TEXT	Quote - Billto_fax	Quote - Billto_fax
quotes_billto_line1	TEXT	Quote - Billto_line1	Quote - Billto_line1
quotes_billto_line2	TEXT	Quote - Billto_line2	Quote - Billto_line2
quotes_billto_line3	TEXT	Quote - Billto_line3	Quote - Billto_line3
quotes_billto_name	TEXT	Quote - Billto_name	Quote - Billto_name
quotes_billto_postalcode	TEXT	Quote - Billto_postalcode	Quote - Billto_postalcode
quotes_billto_stateorprovince	TEXT	Quote - Billto_stateorprovince	Quote - Billto_stateorprovince
quotes_billto_telephone	TEXT	Quote - Billto_telephone	Quote - Billto_telephone
quotes_closedon	DATE	Quote - Closedon	Quote - Closedon
quotes_createdon	DATE	Quote - Createdon	Quote - Createdon
quotes_description	TEXT	Quote - Description	Quote - Description
quotes_discountamount	NUMERIC	Quote - Discountamount	Quote - Discountamount
quotes_discountamount_base	NUMERIC	Quote - Discountamount_base	Quote - Discountamount_base
quotes_discountpercentage	NUMERIC	Quote - Discountpercentage	Quote - Discountpercentage
quotes_effectivefrom	DATE	Quote - Effectivefrom	Quote - Effectivefrom
quotes_effectiveto	DATE	Quote - Effectiveto	Quote - Effectiveto
quotes_emailaddress	TEXT	Quote - Emailaddress	Quote - Emailaddress
quotes_exchangerate	NUMERIC	Quote - Exchangerate	Quote - Exchangerate
quotes_expireson	DATE	Quote - Expireson	Quote - Expireson
quotes_freightamount	NUMERIC	Quote - Freightamount	Quote - Freightamount
quotes_freightamount_base	NUMERIC	Quote - Freightamount_base	Quote - Freightamount_base
quotes_freighttermscode	NUMERIC	Quote - Freighttermscode	Quote - Freighttermscode
quotes_importsequencenumber	NUMERIC	Quote - Importsequencenumber	Quote - Importsequencenumber
quotes_lastonholdtime	DATE	Quote - Lastonholdtime	Quote - Lastonholdtime
quotes_modifiedon	DATE	Quote - Modifiedon	Quote - Modifiedon
quotes_name	TEXT	Quote - Name	Quote - Name
quotes_onholdtime	NUMERIC	Quote - Onholdtime	Quote - Onholdtime
quotes_overriddencreatedon	DATE	Quote - Overriddencreatedon	Quote - Overriddencreatedon
quotes_paymenttermscode	NUMERIC	Quote - Paymenttermscode	Quote - Paymenttermscode
quotes_pricingerrorcode	NUMERIC	Quote - Pricingerrorcode	Quote - Pricingerrorcode
quotes_processid	TEXT	Quote - Processid	Quote - Processid
quotes_quotecreationmethod	NUMERIC	Quote - Quotecreationmethod	Quote - Quotecreationmethod
quotes_quoteid	TEXT	Quote - Quoteid	Quote - Quoteid
quotes_quotenumber	TEXT	Quote - Quotenumber	Quote - Quotenumber
quotes_requestdeliveryby	DATE	Quote - Requestdeliveryby	Quote - Requestdeliveryby

Microsoft Dynamics 365 quotes fields (quotes_revisionnumber to quotes_willcall)

ID	Type	Name	Description
quotes_revisionnumber	NUMERIC	Quote - Revisionnumber	Quote - Revisionnumber
quotes_shippingmethodcode	NUMERIC	Quote - Shippingmethodcode	Quote - Shippingmethodcode
quotes_shipto_addressid	TEXT	Quote - Shipto_addressid	Quote - Shipto_addressid
quotes_shipto_city	CITY	Quote - Shipto_city	Quote - Shipto_city
quotes_shipto_composite	TEXT	Quote - Shipto_composite	Quote - Shipto_composite
quotes_shipto_contactname	TEXT	Quote - Shipto_contactname	Quote - Shipto_contactname
quotes_shipto_country	COUNTRY	Quote - Shipto_country	Quote - Shipto_country
quotes_shipto_fax	TEXT	Quote - Shipto_fax	Quote - Shipto_fax
quotes_shipto_freighttermscode	NUMERIC	Quote - Shipto_freighttermscode	Quote - Shipto_freighttermscode
quotes_shipto_line1	TEXT	Quote - Shipto_line1	Quote - Shipto_line1
quotes_shipto_line2	TEXT	Quote - Shipto_line2	Quote - Shipto_line2
quotes_shipto_line3	TEXT	Quote - Shipto_line3	Quote - Shipto_line3
quotes_shipto_name	TEXT	Quote - Shipto_name	Quote - Shipto_name
quotes_shipto_postalcode	TEXT	Quote - Shipto_postalcode	Quote - Shipto_postalcode
quotes_shipto_stateorprovince	TEXT	Quote - Shipto_stateorprovince	Quote - Shipto_stateorprovince
quotes_shipto_telephone	TEXT	Quote - Shipto_telephone	Quote - Shipto_telephone
quotes_skippricecalculation	NUMERIC	Quote - Skippricecalculation	Quote - Skippricecalculation
quotes_stageid	TEXT	Quote - Stageid	Quote - Stageid
quotes_statecode	NUMERIC	Quote - Statecode	Quote - Statecode
quotes_statuscode	NUMERIC	Quote - Statuscode	Quote - Statuscode
quotes_timezoneruleversionnumber	NUMERIC	Quote - Timezoneruleversionnumber	Quote - Timezoneruleversionnumber
quotes_totalamount	NUMERIC	Quote - Totalamount	Quote - Totalamount
quotes_totalamount_base	NUMERIC	Quote - Totalamount_base	Quote - Totalamount_base
quotes_totalamountlessfreight	NUMERIC	Quote - Totalamountlessfreight	Quote - Totalamountlessfreight
quotes_totalamountlessfreight_base	NUMERIC	Quote - Totalamountlessfreight_base	Quote - Totalamountlessfreight_base
quotes_totaldiscountamount	NUMERIC	Quote - Totaldiscountamount	Quote - Totaldiscountamount
quotes_totaldiscountamount_base	NUMERIC	Quote - Totaldiscountamount_base	Quote - Totaldiscountamount_base
quotes_totallineitemamount	NUMERIC	Quote - Totallineitemamount	Quote - Totallineitemamount
quotes_totallineitemamount_base	NUMERIC	Quote - Totallineitemamount_base	Quote - Totallineitemamount_base
quotes_totallineitemdiscountamount	NUMERIC	Quote - Totallineitemdiscountamount	Quote - Totallineitemdiscountamount
quotes_totallineitemdiscountamount_base	NUMERIC	Quote - Totallineitemdiscountamount_base	Quote - Totallineitemdiscountamount_base
quotes_totaltax	NUMERIC	Quote - Totaltax	Quote - Totaltax
quotes_totaltax_base	NUMERIC	Quote - Totaltax_base	Quote - Totaltax_base
quotes_traversedpath	TEXT	Quote - Traversedpath	Quote - Traversedpath
quotes_utcconversiontimezonecode	NUMERIC	Quote - Utcconversiontimezonecode	Quote - Utcconversiontimezonecode
quotes_versionnumber	NUMERIC	Quote - Versionnumber	Quote - Versionnumber
quotes_willcall	BOOLEAN	Quote - Willcall	Quote - Willcall

Microsoft Dynamics 365 rollupfields fields

The rollupfields report of the Microsoft Dynamics 365 connector includes 15 fields.

ID	Type	Name	Description
rollupfields_createdon	DATE	Rollupfield - Createdon	Rollupfield - Createdon
rollupfields_dateattribute	TEXT	Rollupfield - Dateattribute	Rollupfield - Dateattribute
rollupfields_entityfordateattribute	TEXT	Rollupfield - Entityfordateattribute	Rollupfield - Entityfordateattribute
rollupfields_goalattribute	TEXT	Rollupfield - Goalattribute	Rollupfield - Goalattribute
rollupfields_importsequencenumber	NUMERIC	Rollupfield - Importsequencenumber	Rollupfield - Importsequencenumber
rollupfields_isstateparententityattribute	BOOLEAN	Rollupfield - Isstateparententityattribute	Rollupfield - Isstateparententityattribute
rollupfields_modifiedon	DATE	Rollupfield - Modifiedon	Rollupfield - Modifiedon
rollupfields_rollupfieldid	TEXT	Rollupfield - Rollupfieldid	Rollupfield - Rollupfieldid
rollupfields_sourceattribute	TEXT	Rollupfield - Sourceattribute	Rollupfield - Sourceattribute
rollupfields_sourceentity	TEXT	Rollupfield - Sourceentity	Rollupfield - Sourceentity
rollupfields_sourcestate	NUMERIC	Rollupfield - Sourcestate	Rollupfield - Sourcestate
rollupfields_sourcestatus	NUMERIC	Rollupfield - Sourcestatus	Rollupfield - Sourcestatus
rollupfields_timezoneruleversionnumber	NUMERIC	Rollupfield - Timezoneruleversionnumber	Rollupfield - Timezoneruleversionnumber
rollupfields_utcconversiontimezonecode	NUMERIC	Rollupfield - Utcconversiontimezonecode	Rollupfield - Utcconversiontimezonecode
rollupfields_versionnumber	NUMERIC	Rollupfield - Versionnumber	Rollupfield - Versionnumber

Microsoft Dynamics 365 salesliteratureitems fields

The salesliteratureitems report of the Microsoft Dynamics 365 connector includes 22 fields.

Microsoft Dynamics 365 salesliteratures fields

The salesliteratures report of the Microsoft Dynamics 365 connector includes 23 fields.

Microsoft Dynamics 365 salesorderdetails fields

The salesorderdetails report of the Microsoft Dynamics 365 connector includes 59 fields.

Microsoft Dynamics 365 salesorderdetails fields (salesorderdetails_baseamount to salesorderdetails_shipto_contactname)

Microsoft Dynamics 365 salesorderdetails fields (salesorderdetails_shipto_country to salesorderdetails_willcall)

Microsoft Dynamics 365 salesorders fields

The salesorders report of the Microsoft Dynamics 365 connector includes 83 fields.

Microsoft Dynamics 365 salesorders fields (salesorders_billto_addressid to salesorders_pricingerrorcode)

ID	Type	Name	Description
salesorders_billto_addressid	TEXT	Salesorder - Billto_addressid	Salesorder - Billto_addressid
salesorders_billto_city	CITY	Salesorder - Billto_city	Salesorder - Billto_city
salesorders_billto_composite	TEXT	Salesorder - Billto_composite	Salesorder - Billto_composite
salesorders_billto_contactname	TEXT	Salesorder - Billto_contactname	Salesorder - Billto_contactname
salesorders_billto_country	COUNTRY	Salesorder - Billto_country	Salesorder - Billto_country
salesorders_billto_fax	TEXT	Salesorder - Billto_fax	Salesorder - Billto_fax
salesorders_billto_line1	TEXT	Salesorder - Billto_line1	Salesorder - Billto_line1
salesorders_billto_line2	TEXT	Salesorder - Billto_line2	Salesorder - Billto_line2
salesorders_billto_line3	TEXT	Salesorder - Billto_line3	Salesorder - Billto_line3
salesorders_billto_name	TEXT	Salesorder - Billto_name	Salesorder - Billto_name
salesorders_billto_postalcode	TEXT	Salesorder - Billto_postalcode	Salesorder - Billto_postalcode
salesorders_billto_stateorprovince	TEXT	Salesorder - Billto_stateorprovince	Salesorder - Billto_stateorprovince
salesorders_billto_telephone	TEXT	Salesorder - Billto_telephone	Salesorder - Billto_telephone
salesorders_createdon	DATE	Salesorder - Createdon	Salesorder - Createdon
salesorders_datefulfilled	DATE	Salesorder - Datefulfilled	Salesorder - Datefulfilled
salesorders_description	TEXT	Salesorder - Description	Salesorder - Description
salesorders_discountamount	NUMERIC	Salesorder - Discountamount	Salesorder - Discountamount
salesorders_discountamount_base	NUMERIC	Salesorder - Discountamount_base	Salesorder - Discountamount_base
salesorders_discountpercentage	NUMERIC	Salesorder - Discountpercentage	Salesorder - Discountpercentage
salesorders_emailaddress	TEXT	Salesorder - Emailaddress	Salesorder - Emailaddress
salesorders_entityimage	TEXT	Salesorder - Entityimage	Salesorder - Entityimage
salesorders_entityimage_timestamp	TIMESTAMP	Salesorder - Entityimage_timestamp	Salesorder - Entityimage_timestamp
salesorders_entityimage_url	TEXT	Salesorder - Entityimage_url	Salesorder - Entityimage_url
salesorders_entityimageid	TEXT	Salesorder - Entityimageid	Salesorder - Entityimageid
salesorders_exchangerate	NUMERIC	Salesorder - Exchangerate	Salesorder - Exchangerate
salesorders_freightamount	NUMERIC	Salesorder - Freightamount	Salesorder - Freightamount
salesorders_freightamount_base	NUMERIC	Salesorder - Freightamount_base	Salesorder - Freightamount_base
salesorders_freighttermscode	NUMERIC	Salesorder - Freighttermscode	Salesorder - Freighttermscode
salesorders_importsequencenumber	NUMERIC	Salesorder - Importsequencenumber	Salesorder - Importsequencenumber
salesorders_ispricelocked	BOOLEAN	Salesorder - Ispricelocked	Salesorder - Ispricelocked
salesorders_lastbackofficesubmit	DATE	Salesorder - Lastbackofficesubmit	Salesorder - Lastbackofficesubmit
salesorders_lastonholdtime	DATE	Salesorder - Lastonholdtime	Salesorder - Lastonholdtime
salesorders_modifiedon	DATE	Salesorder - Modifiedon	Salesorder - Modifiedon
salesorders_name	TEXT	Salesorder - Name	Salesorder - Name
salesorders_onholdtime	NUMERIC	Salesorder - Onholdtime	Salesorder - Onholdtime
salesorders_ordercreationmethod	NUMERIC	Salesorder - Ordercreationmethod	Salesorder - Ordercreationmethod
salesorders_ordernumber	TEXT	Salesorder - Ordernumber	Salesorder - Ordernumber
salesorders_overriddencreatedon	DATE	Salesorder - Overriddencreatedon	Salesorder - Overriddencreatedon
salesorders_paymenttermscode	NUMERIC	Salesorder - Paymenttermscode	Salesorder - Paymenttermscode
salesorders_pricingerrorcode	NUMERIC	Salesorder - Pricingerrorcode	Salesorder - Pricingerrorcode

Microsoft Dynamics 365 salesorders fields (salesorders_prioritycode to salesorders_traversedpath)

ID	Type	Name	Description
salesorders_prioritycode	NUMERIC	Salesorder - Prioritycode	Salesorder - Prioritycode
salesorders_processid	TEXT	Salesorder - Processid	Salesorder - Processid
salesorders_requestdeliveryby	DATE	Salesorder - Requestdeliveryby	Salesorder - Requestdeliveryby
salesorders_salesorderid	TEXT	Salesorder - Salesorderid	Salesorder - Salesorderid
salesorders_shippingmethodcode	NUMERIC	Salesorder - Shippingmethodcode	Salesorder - Shippingmethodcode
salesorders_shipto_addressid	TEXT	Salesorder - Shipto_addressid	Salesorder - Shipto_addressid
salesorders_shipto_city	CITY	Salesorder - Shipto_city	Salesorder - Shipto_city
salesorders_shipto_composite	TEXT	Salesorder - Shipto_composite	Salesorder - Shipto_composite
salesorders_shipto_contactname	TEXT	Salesorder - Shipto_contactname	Salesorder - Shipto_contactname
salesorders_shipto_country	COUNTRY	Salesorder - Shipto_country	Salesorder - Shipto_country
salesorders_shipto_fax	TEXT	Salesorder - Shipto_fax	Salesorder - Shipto_fax
salesorders_shipto_freighttermscode	NUMERIC	Salesorder - Shipto_freighttermscode	Salesorder - Shipto_freighttermscode
salesorders_shipto_line1	TEXT	Salesorder - Shipto_line1	Salesorder - Shipto_line1
salesorders_shipto_line2	TEXT	Salesorder - Shipto_line2	Salesorder - Shipto_line2
salesorders_shipto_line3	TEXT	Salesorder - Shipto_line3	Salesorder - Shipto_line3
salesorders_shipto_name	TEXT	Salesorder - Shipto_name	Salesorder - Shipto_name
salesorders_shipto_postalcode	TEXT	Salesorder - Shipto_postalcode	Salesorder - Shipto_postalcode
salesorders_shipto_stateorprovince	TEXT	Salesorder - Shipto_stateorprovince	Salesorder - Shipto_stateorprovince
salesorders_shipto_telephone	TEXT	Salesorder - Shipto_telephone	Salesorder - Shipto_telephone
salesorders_skippricecalculation	NUMERIC	Salesorder - Skippricecalculation	Salesorder - Skippricecalculation
salesorders_stageid	TEXT	Salesorder - Stageid	Salesorder - Stageid
salesorders_statecode	NUMERIC	Salesorder - Statecode	Salesorder - Statecode
salesorders_statuscode	NUMERIC	Salesorder - Statuscode	Salesorder - Statuscode
salesorders_submitdate	DATE	Salesorder - Submitdate	Salesorder - Submitdate
salesorders_submitstatus	NUMERIC	Salesorder - Submitstatus	Salesorder - Submitstatus
salesorders_submitstatusdescription	TEXT	Salesorder - Submitstatusdescription	Salesorder - Submitstatusdescription
salesorders_timezoneruleversionnumber	NUMERIC	Salesorder - Timezoneruleversionnumber	Salesorder - Timezoneruleversionnumber
salesorders_totalamount	NUMERIC	Salesorder - Totalamount	Salesorder - Totalamount
salesorders_totalamount_base	NUMERIC	Salesorder - Totalamount_base	Salesorder - Totalamount_base
salesorders_totalamountlessfreight	NUMERIC	Salesorder - Totalamountlessfreight	Salesorder - Totalamountlessfreight
salesorders_totalamountlessfreight_base	NUMERIC	Salesorder - Totalamountlessfreight_base	Salesorder - Totalamountlessfreight_base
salesorders_totaldiscountamount	NUMERIC	Salesorder - Totaldiscountamount	Salesorder - Totaldiscountamount
salesorders_totaldiscountamount_base	NUMERIC	Salesorder - Totaldiscountamount_base	Salesorder - Totaldiscountamount_base
salesorders_totallineitemamount	NUMERIC	Salesorder - Totallineitemamount	Salesorder - Totallineitemamount
salesorders_totallineitemamount_base	NUMERIC	Salesorder - Totallineitemamount_base	Salesorder - Totallineitemamount_base
salesorders_totallineitemdiscountamount	NUMERIC	Salesorder - Totallineitemdiscountamount	Salesorder - Totallineitemdiscountamount
salesorders_totallineitemdiscountamount_base	NUMERIC	Salesorder - Totallineitemdiscountamount_base	Salesorder - Totallineitemdiscountamount_base
salesorders_totaltax	NUMERIC	Salesorder - Totaltax	Salesorder - Totaltax
salesorders_totaltax_base	NUMERIC	Salesorder - Totaltax_base	Salesorder - Totaltax_base
salesorders_traversedpath	TEXT	Salesorder - Traversedpath	Salesorder - Traversedpath

Microsoft Dynamics 365 salesorders fields (salesorders_utcconversiontimezonecode to salesorders_willcall)

ID	Type	Name	Description
salesorders_utcconversiontimezonecode	NUMERIC	Salesorder - Utcconversiontimezonecode	Salesorder - Utcconversiontimezonecode
salesorders_versionnumber	NUMERIC	Salesorder - Versionnumber	Salesorder - Versionnumber
salesorders_willcall	BOOLEAN	Salesorder - Willcall	Salesorder - Willcall

Microsoft Dynamics 365 uoms fields

The uoms report of the Microsoft Dynamics 365 connector includes 12 fields.

ID	Type	Name	Description
uoms_createdon	DATE	Uom - Createdon	Uom - Createdon
uoms_importsequencenumber	NUMERIC	Uom - Importsequencenumber	Uom - Importsequencenumber
uoms_isschedulebaseuom	BOOLEAN	Uom - Isschedulebaseuom	Uom - Isschedulebaseuom
uoms_modifiedon	DATE	Uom - Modifiedon	Uom - Modifiedon
uoms_name	TEXT	Uom - Name	Uom - Name
uoms_organizationid	TEXT	Uom - Organizationid	Uom - Organizationid
uoms_overriddencreatedon	DATE	Uom - Overriddencreatedon	Uom - Overriddencreatedon
uoms_quantity	NUMERIC	Uom - Quantity	Uom - Quantity
uoms_timezoneruleversionnumber	NUMERIC	Uom - Timezoneruleversionnumber	Uom - Timezoneruleversionnumber
uoms_uomid	TEXT	Uom - Uomid	Uom - Uomid
uoms_utcconversiontimezonecode	NUMERIC	Uom - Utcconversiontimezonecode	Uom - Utcconversiontimezonecode
uoms_versionnumber	NUMERIC	Uom - Versionnumber	Uom - Versionnumber

Microsoft Dynamics 365 uomschedules fields

The uomschedules report of the Microsoft Dynamics 365 connector includes 13 fields.

ID	Type	Name	Description
uomschedules_baseuomname	TEXT	Uomschedule - Baseuomname	Uomschedule - Baseuomname
uomschedules_createdon	DATE	Uomschedule - Createdon	Uomschedule - Createdon
uomschedules_description	TEXT	Uomschedule - Description	Uomschedule - Description
uomschedules_importsequencenumber	NUMERIC	Uomschedule - Importsequencenumber	Uomschedule - Importsequencenumber
uomschedules_modifiedon	DATE	Uomschedule - Modifiedon	Uomschedule - Modifiedon
uomschedules_name	TEXT	Uomschedule - Name	Uomschedule - Name
uomschedules_overriddencreatedon	DATE	Uomschedule - Overriddencreatedon	Uomschedule - Overriddencreatedon
uomschedules_statecode	NUMERIC	Uomschedule - Statecode	Uomschedule - Statecode
uomschedules_statuscode	NUMERIC	Uomschedule - Statuscode	Uomschedule - Statuscode
uomschedules_timezoneruleversionnumber	NUMERIC	Uomschedule - Timezoneruleversionnumber	Uomschedule - Timezoneruleversionnumber
uomschedules_uomscheduleid	TEXT	Uomschedule - Uomscheduleid	Uomschedule - Uomscheduleid
uomschedules_utcconversiontimezonecode	NUMERIC	Uomschedule - Utcconversiontimezonecode	Uomschedule - Utcconversiontimezonecode
uomschedules_versionnumber	NUMERIC	Uomschedule - Versionnumber	Uomschedule - Versionnumber

Microsoft Dynamics 365 other fields

The Microsoft Dynamics 365 connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description
account_id	TEXT	Account ID	The account ID
account_name	TEXT	Account Name	The account name
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	The Date
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

ID	Type	Name	Description
campaignresponses_category	TEXT	Campaignresponse - Category	Campaignresponse - Category
campaignresponses_channeltypecode	NUMERIC	Campaignresponse - Channeltypecode	Campaignresponse - Channeltypecode
campaignresponses_companyname	TEXT	Campaignresponse - Companyname	Campaignresponse - Companyname
campaignresponses_emailaddress	TEXT	Campaignresponse - Emailaddress	Campaignresponse - Emailaddress
campaignresponses_fax	TEXT	Campaignresponse - Fax	Campaignresponse - Fax
campaignresponses_firstname	TEXT	Campaignresponse - Firstname	Campaignresponse - Firstname
campaignresponses_importsequencenumber	NUMERIC	Campaignresponse - Importsequencenumber	Campaignresponse - Importsequencenumber
campaignresponses_lastname	TEXT	Campaignresponse - Lastname	Campaignresponse - Lastname
campaignresponses_overriddencreatedon	DATE	Campaignresponse - Overriddencreatedon	Campaignresponse - Overriddencreatedon
campaignresponses_promotioncodename	TEXT	Campaignresponse - Promotioncodename	Campaignresponse - Promotioncodename
campaignresponses_receivedon	DATE	Campaignresponse - Receivedon	Campaignresponse - Receivedon
campaignresponses_responsecode	NUMERIC	Campaignresponse - Responsecode	Campaignresponse - Responsecode
campaignresponses_subcategory	TEXT	Campaignresponse - Subcategory	Campaignresponse - Subcategory
campaignresponses_telephone	TEXT	Campaignresponse - Telephone	Campaignresponse - Telephone
campaignresponses_yomicompanyname	TEXT	Campaignresponse - Yomicompanyname	Campaignresponse - Yomicompanyname
campaignresponses_yomifirstname	TEXT	Campaignresponse - Yomifirstname	Campaignresponse - Yomifirstname
campaignresponses_yomilastname	TEXT	Campaignresponse - Yomilastname	Campaignresponse - Yomilastname

ID	Type	Name	Description
dynamicpropertyinstances_createdon	DATE	Dynamicpropertyinstance - Createdon	Dynamicpropertyinstance - Createdon
dynamicpropertyinstances_dmtimportstate	NUMERIC	Dynamicpropertyinstance - Dmtimportstate	Dynamicpropertyinstance - Dmtimportstate
dynamicpropertyinstances_dynamicpropertyinstanceid	TEXT	Dynamicpropertyinstance - Dynamicpropertyinstanceid	Dynamicpropertyinstance - Dynamicpropertyinstanceid
dynamicpropertyinstances_exchangerate	NUMERIC	Dynamicpropertyinstance - Exchangerate	Dynamicpropertyinstance - Exchangerate
dynamicpropertyinstances_importsequencenumber	NUMERIC	Dynamicpropertyinstance - Importsequencenumber	Dynamicpropertyinstance - Importsequencenumber
dynamicpropertyinstances_modifiedon	DATE	Dynamicpropertyinstance - Modifiedon	Dynamicpropertyinstance - Modifiedon
dynamicpropertyinstances_name	TEXT	Dynamicpropertyinstance - Name	Dynamicpropertyinstance - Name
dynamicpropertyinstances_overriddencreatedon	DATE	Dynamicpropertyinstance - Overriddencreatedon	Dynamicpropertyinstance - Overriddencreatedon
dynamicpropertyinstances_timezoneruleversionnumber	NUMERIC	Dynamicpropertyinstance - Timezoneruleversionnumber	Dynamicpropertyinstance - Timezoneruleversionnumber
dynamicpropertyinstances_utcconversiontimezonecode	NUMERIC	Dynamicpropertyinstance - Utcconversiontimezonecode	Dynamicpropertyinstance - Utcconversiontimezonecode
dynamicpropertyinstances_validationstatus	BOOLEAN	Dynamicpropertyinstance - Validationstatus	Dynamicpropertyinstance - Validationstatus
dynamicpropertyinstances_valuedecimal	NUMERIC	Dynamicpropertyinstance - Valuedecimal	Dynamicpropertyinstance - Valuedecimal
dynamicpropertyinstances_valuedouble	NUMERIC	Dynamicpropertyinstance - Valuedouble	Dynamicpropertyinstance - Valuedouble
dynamicpropertyinstances_valueinteger	NUMERIC	Dynamicpropertyinstance - Valueinteger	Dynamicpropertyinstance - Valueinteger
dynamicpropertyinstances_valuestring	TEXT	Dynamicpropertyinstance - Valuestring	Dynamicpropertyinstance - Valuestring
dynamicpropertyinstances_versionnumber	NUMERIC	Dynamicpropertyinstance - Versionnumber	Dynamicpropertyinstance - Versionnumber

ID	Type	Name	Description
leadtoopportunitysalesprocesses_activestagestartedon	DATE	Leadtoopportunitysalesprocess - Activestagestartedon	Leadtoopportunitysalesprocess - Activestagestartedon
leadtoopportunitysalesprocesses_businessprocessflowinstanceid	TEXT	Leadtoopportunitysalesprocess - Businessprocessflowinstanceid	Leadtoopportunitysalesprocess - Businessprocessflowinstanceid
leadtoopportunitysalesprocesses_completedon	DATE	Leadtoopportunitysalesprocess - Completedon	Leadtoopportunitysalesprocess - Completedon
leadtoopportunitysalesprocesses_createdon	DATE	Leadtoopportunitysalesprocess - Createdon	Leadtoopportunitysalesprocess - Createdon
leadtoopportunitysalesprocesses_duration	NUMERIC	Leadtoopportunitysalesprocess - Duration	Leadtoopportunitysalesprocess - Duration
leadtoopportunitysalesprocesses_exchangerate	NUMERIC	Leadtoopportunitysalesprocess - Exchangerate	Leadtoopportunitysalesprocess - Exchangerate
leadtoopportunitysalesprocesses_importsequencenumber	NUMERIC	Leadtoopportunitysalesprocess - Importsequencenumber	Leadtoopportunitysalesprocess - Importsequencenumber
leadtoopportunitysalesprocesses_modifiedon	DATE	Leadtoopportunitysalesprocess - Modifiedon	Leadtoopportunitysalesprocess - Modifiedon
leadtoopportunitysalesprocesses_name	TEXT	Leadtoopportunitysalesprocess - Name	Leadtoopportunitysalesprocess - Name
leadtoopportunitysalesprocesses_overriddencreatedon	DATE	Leadtoopportunitysalesprocess - Overriddencreatedon	Leadtoopportunitysalesprocess - Overriddencreatedon
leadtoopportunitysalesprocesses_statecode	NUMERIC	Leadtoopportunitysalesprocess - Statecode	Leadtoopportunitysalesprocess - Statecode
leadtoopportunitysalesprocesses_statuscode	NUMERIC	Leadtoopportunitysalesprocess - Statuscode	Leadtoopportunitysalesprocess - Statuscode
leadtoopportunitysalesprocesses_timezoneruleversionnumber	NUMERIC	Leadtoopportunitysalesprocess - Timezoneruleversionnumber	Leadtoopportunitysalesprocess - Timezoneruleversionnumber
leadtoopportunitysalesprocesses_traversedpath	TEXT	Leadtoopportunitysalesprocess - Traversedpath	Leadtoopportunitysalesprocess - Traversedpath
leadtoopportunitysalesprocesses_utcconversiontimezonecode	NUMERIC	Leadtoopportunitysalesprocess - Utcconversiontimezonecode	Leadtoopportunitysalesprocess - Utcconversiontimezonecode
leadtoopportunitysalesprocesses_versionnumber	NUMERIC	Leadtoopportunitysalesprocess - Versionnumber	Leadtoopportunitysalesprocess - Versionnumber

ID	Type	Name	Description
msdyn_assignmentmaps_createdon	DATE	Msdyn_assignmentmap - Createdon	Msdyn_assignmentmap - Createdon
msdyn_assignmentmaps_importsequencenumber	NUMERIC	Msdyn_assignmentmap - Importsequencenumber	Msdyn_assignmentmap - Importsequencenumber
msdyn_assignmentmaps_modifiedon	DATE	Msdyn_assignmentmap - Modifiedon	Msdyn_assignmentmap - Modifiedon
msdyn_assignmentmaps_msdyn_applicableforrouting	BOOLEAN	Msdyn_assignmentmap - Msdyn_applicableforrouting	Msdyn_assignmentmap - Msdyn_applicableforrouting
msdyn_assignmentmaps_msdyn_assignedticks	TEXT	Msdyn_assignmentmap - Msdyn_assignedticks	Msdyn_assignmentmap - Msdyn_assignedticks
msdyn_assignmentmaps_msdyn_assignmentmapid	TEXT	Msdyn_assignmentmap - Msdyn_assignmentmapid	Msdyn_assignmentmap - Msdyn_assignmentmapid
msdyn_assignmentmaps_msdyn_availablecapacity	NUMERIC	Msdyn_assignmentmap - Msdyn_availablecapacity	Msdyn_assignmentmap - Msdyn_availablecapacity
msdyn_assignmentmaps_msdyn_maxcapacity	NUMERIC	Msdyn_assignmentmap - Msdyn_maxcapacity	Msdyn_assignmentmap - Msdyn_maxcapacity
msdyn_assignmentmaps_msdyn_name	TEXT	Msdyn_assignmentmap - Msdyn_name	Msdyn_assignmentmap - Msdyn_name
msdyn_assignmentmaps_msdyn_rulelevelassignedticksjson	TEXT	Msdyn_assignmentmap - Msdyn_rulelevelassignedticksjson	Msdyn_assignmentmap - Msdyn_rulelevelassignedticksjson
msdyn_assignmentmaps_overriddencreatedon	DATE	Msdyn_assignmentmap - Overriddencreatedon	Msdyn_assignmentmap - Overriddencreatedon
msdyn_assignmentmaps_statecode	NUMERIC	Msdyn_assignmentmap - Statecode	Msdyn_assignmentmap - Statecode
msdyn_assignmentmaps_statuscode	NUMERIC	Msdyn_assignmentmap - Statuscode	Msdyn_assignmentmap - Statuscode
msdyn_assignmentmaps_timezoneruleversionnumber	NUMERIC	Msdyn_assignmentmap - Timezoneruleversionnumber	Msdyn_assignmentmap - Timezoneruleversionnumber
msdyn_assignmentmaps_utcconversiontimezonecode	NUMERIC	Msdyn_assignmentmap - Utcconversiontimezonecode	Msdyn_assignmentmap - Utcconversiontimezonecode
msdyn_assignmentmaps_versionnumber	NUMERIC	Msdyn_assignmentmap - Versionnumber	Msdyn_assignmentmap - Versionnumber

API Connectors