Dual-write mapping reference

Mapping tables

Mapping types

There are several different mapping types. The following table explains the symbols used in the template tables.

Symbol	Description
>	One-way
>>	One-way, and data is transformed in the process.
=	Bidirectional
><	Bidirectional, and data is transformed in the process.
<<	One-way, and data is transformed in the process.

Filters

The source filter and reverse source filter determine which rows are synchronized.

Default values

If a synchronized field does not exist in either the finance and operations table or the customer engagement table, then a default value is assigned in the synchronized table. In some cases, the default value is an integer that is a lookup to an attribute value in Dataverse. For example, in the Contact table, the default value for address1AddressTypeCode is 3 (Primary address).

Templates

Finance and operations app	Customer engagement app	Description
All products	msdyn_globalproducts
Asset management asset lifecycle models	msdyn_assetlifecyclemodels
Asset management asset lifecycle states	msdyn_assetlifecyclestates
Asset management asset types	msdyn_customerassetcategories
Asset management assets	msdyn_customerassets
Asset management functional location lifecycle models	msdyn_functionallocationlifecyclemodels
Asset management functional location lifecycle states	msdyn_functionallocationlifecyclestates
Asset management functional location types	msdyn_functionallocationtypes
Asset management functional locations	msdyn_functionallocations
Asset management manufacturers	msdyn_manufacturers
Asset management models	msdyn_models
Asset management warranty	msdyn_warranties
CDS Contacts V2	contacts
CDS Exchange Rates	msdyn_currencyexchangerates
CDS Parties	msdyn_parties
CDS Party postal address locations	msdyn_partypostaladdresses
CDS inventory on-hand entries	msdyn_inventoryonhandentries
CDS inventory on-hand requests	msdyn_inventoryonhandrequests
CDS postal address history V2	msdyn_postaladdresses
CDS postal address locations	msdyn_postaladdresscollections
CDS purchase order line entity	msdyn_purchaseorderproducts
CDS purchase order line soft deleted entity	msdyn_purchaseorderproducts
CDS released distinct products	products
CDS sales order headers	salesorders
CDS sales order lines	salesorderdetails
CDS sales quotation header	quotes
CDS sales quotation lines	quotedetails
Chart of accounts	msdyn_chartofaccountses
Colors	msdyn_productcolors
Compensation job function	cdm_jobfunctions
Compensation job type	cdm_jobtypes
Complimentary closings	msdyn_complimentaryclosings
Configurations	msdyn_productconfigurations
Contact person titles	msdyn_salescontactpersontitles
Contacts V2	msdyn_contactforparties
Currencies	transactioncurrencies
Customer Attachments	annotations
Customer groups	msdyn_customergroups
Customer hierarchies	msdyn_customerhierarchies
Customer hierarchy nodes	msdyn_customerhierarchynodes
Customer payment method	msdyn_customerpaymentmethods
Customers V3	accounts
Customers V3	contacts
Decision making roles	msdyn_decisionmakingroles
Default order settings	msdyn_productdefaultordersettings
DV released distinct products	products
DV released products	msdyn_sharedproductdetails
Dynamics 365 Sales feature management states	msdyn_supplychainfeaturestates
Dynamics 365 Sales order headers	salesorders
Dynamics 365 Sales order lines	salesorderdetails
Dynamics 365 Sales quotation header	quotes
Dynamics 365 Sales quotation lines	quotedetails
Employment job functions	msdyn_employmentjobfunctions
Employment per company	cdm_employments
Ethnic origins	cdm_ethnicorigins
Exchange rate currency pair	msdyn_currencyexchangeratepairs
Exchange rate type	msdyn_exchangeratetypes
Financial dimension format	msdyn_financialdimensionformats
Financial dimensions	msdyn_dimensionattributes
Fiscal calendar integration entity	msdyn_fiscalcalendars
Fiscal calendar period	msdyn_fiscalcalendarperiods
Fiscal calendar year integration entity	msdyn_fiscalcalendaryears
Inventory aisle	msdyn_warehouseaisles
Item sales tax group	msdyn_taxitemgroups
Jobs	cdm_jobs
Language codes	cdm_languages
Ledger	msdyn_ledgers
Legal entities	cdm_companies
Legal entities	msdyn_internalorganizations
Loyalty card	msdyn_loyaltycards
Loyalty levels	msdyn_loyaltylevels
Loyalty reward points	msdyn_loyaltyrewardpoints
Main account	msdyn_mainaccounts
Main account categories	msdyn_mainaccountcategories
Mixed reality guides entity	msmrw_guides
Modes of delivery	msdyn_shipvias
Name affixes	msdyn_nameaffixes
Operating unit	msdyn_internalorganizations
Organization hierarchy - published	msdyn_internalorganizationhierarchies
Organization hierarchy purposes	msdyn_internalorganizationhierarchypurposes
Organization hierarchy type	msdyn_internalorganizationhierarchytypes
Party contacts V3	msdyn_partyelectronicaddresses
Payment day lines CDS V2	msdyn_paymentdaylines
Payment days CDS	msdyn_paymentdays
Payment schedule	msdyn_paymentschedules
Payment schedule lines	msdyn_paymentschedulelines
Personal character types	msdyn_personalcharactertypes
Position type	cdm_positiontypes
Position worker assignments	cdm_positionworkerassignmentmaps
Positions V2	cdm_jobpositions
Price customer groups	msdyn_pricecustomergroups
Product Number Identified Barcode	msdyn_productbarcodes
Product categories	msdyn_productcategories
Product category assignments	msdyn_productcategoryassignments
Product category hierarchies	msdyn_productcategoryhierarchies
Product category hierarchy roles	msdyn_productcategoryhierarchyroles
Product default order settings V2	msdyn_productspecificdefaultordersettings
Product dimension groups	msdyn_productdimensiongroups
Product master colors	msdyn_sharedproductcolors
Product master configurations	msdyn_sharedproductconfigurations
Product master sizes	msdyn_sharedproductsizes
Product master styles	msdyn_sharedproductstyles
Product receipt header	msdyn_purchaseorderreceipts
Product receipt line	msdyn_purchaseorderreceiptproducts
Product specific unit conversions	msdyn_productspecificunitofmeasureconversions
Prospects	leads
Purchase order header document attachments	annotations
Purchase order headers V2	msdyn_purchaseorders
Released products V2	msdyn_sharedproductdetails
Sales invoice headers V2	invoices
Sales invoice lines V2	invoicedetails
Sales order header document attachments	annotations
Sales order origin codes	msdyn_salesorderorigins
Sales tax authorities	msdyn_taxauthorities
Sales tax exempt code entity CDS	msdyn_taxexemptcodes
Sales tax groups	msdyn_taxgroups
Sales tax ledger posting groups V2	msdyn_taxpostinggroups
Salutations	msdyn_salutations
Sites	msdyn_operationalsites
Sizes	msdyn_productsizes
Storage dimension groups	msdyn_productstoragedimensiongroups
Styles	msdyn_productstyles
Terms of delivery	msdyn_termsofdeliveries
Terms of payment	msdyn_paymentterms
Tracking dimension groups	msdyn_producttrackingdimensiongroups
Unit conversions	msdyn_unitofmeasureconversions
Units	uoms
Vendor document attachments	annotations
Vendor groups	msdyn_vendorgroups
Vendor payment method	msdyn_vendorpaymentmethods
Vendors V2	msdyn_vendors
Veteran status	cdm_veteranstatuses
Warehouse locations	msdyn_inventorylocations
Warehouse work headers	msdyn_warehouseworkheaders
Warehouse work lines	msdyn_warehouseworklines
Warehouse zone groups	msdyn_warehousezonegroups
Warehouse zones	msdyn_warehousezones
Warehouses	msdyn_warehouses
Withholding tax codes	msdyn_withholdingtaxcodes
Withholding tax groups	msdyn_withholdingtaxgroups
Worker	cdm_workers

All products (msdyn_globalproducts)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PRODUCTNAME	>	msdyn_productname
PRODUCTNUMBER	>	msdyn_productnumber

Asset management asset lifecycle models (msdyn_assetlifecyclemodels)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
ACTIVELIFECYCLESTATEID	=	msdyn_activelifecyclestate.msdyn_assetlifecyclestate_id
INBOUNDLIFECYCLESTATEID	=	msdyn_inboundlifecyclestate.msdyn_assetlifecyclestate_id
INSTORAGELIFECYCLESTATEID	=	msdyn_instoragelifecyclestate.msdyn_assetlifecyclestate_id
LIFECYCLEMODELID	=	msdyn_assetlifecyclemodel_id
NAME	=	msdyn_name
ONLOANLIFECYCLESTATEID	=	msdyn_onloanlifecyclestate.msdyn_assetlifecyclestate_id
OUTBOUNDLIFECYCLESTATEID	=	msdyn_outboundlifecyclestate.msdyn_assetlifecyclestate_id
RECEIVEDLIFECYCLESTATEID	=	msdyn_receivedlifecyclestate.msdyn_assetlifecyclestate_id

Asset management asset lifecycle states (msdyn_assetlifecyclestates)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DELETEOPENCALENDARLINES	>< yes : True no : False	msdyn_deleteopencalendarlines
LIFECYCLESTATEID	=	msdyn_assetlifecyclestate_id
LINE	=	msdyn_line
MAINTENANCEASSETACTIVE	>< yes : True no : False	msdyn_maintenanceassetactive
NAME	=	msdyn_name

Asset management asset types (msdyn_customerassetcategories)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
LIFECYCLEMODELID	=	msdyn_lifecyclemodel.msdyn_assetlifecyclemodel_id
MAINTENANCEASSETTYPEID	=	msdyn_maintenanceassettypeid
NAME	=	msdyn_name
CALCULATEKPITOTAL	>< no : False yes : True	msdyn_calculatekpitotal

Asset management assets (msdyn_customerassets)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
ACQUISITIONCOST	=	msdyn_acquisitioncost
ACQUISITIONDATE	=	msdyn_acquisitiondate
ACTIVEFROM	=	msdyn_activefrom
ACTIVETO	=	msdyn_activeto
FUNCTIONALLOCATIONID	=	msdyn_functionallocation.msdyn_functionallocation_id
MAINTENANCEASSETLIFECYCLESTATEID	=	msdyn_assetlifecyclestate.msdyn_assetlifecyclestate_id
MODELID	=	msdyn_model.msdyn_model_id
MODELPRODUCTID	=	msdyn_model.msdyn_manufacturer.msdyn_manufacturer_id
MODELYEAR	=	msdyn_modelyear
NAME	=	msdyn_name
NOTES	=	msdyn_notes
PURCHASEORDERID	=	msdyn_purchaseorderid
REPLACEMENTDATE	>< 1/1/1900 : blank	msdyn_replacementdate
REPLACEMENTVALUE	=	msdyn_replacementvalue
SERIALID	=	msdyn_serialid
VENDACCOUNT	=	msdyn_vendaccount
WARRANTYDATEFROMVEND	=	msdyn_warrantydatefromvend
WARRANTYID	=	msdyn_warranty.msdyn_warranty_id
WRKCTRID	=	msdyn_wrkctrid
FIXEDASSETID	=	msdyn_fixedassetid
MAINTENANCEASSETID	=	msdyn_maintenanceassetid
PARENTMAINTENANCEASSETID	=	msdyn_parentasset.msdyn_maintenanceassetid
MAINTENANCEASSETTYPEID	=	msdyn_customerassetcategory.msdyn_maintenanceassettypeid
PRODUCTID	=	msdyn_manufacturer.msdyn_manufacturer_id

Asset management functional location lifecycle models (msdyn_functionallocationlifecyclemodels)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
LIFECYCLEMODELID	=	msdyn_functionallocationlifecyclemodel_id
NAME	=	msdyn_name

Asset management functional location lifecycle states (msdyn_functionallocationlifecyclestates)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
ALLOWDELETELOCATION	>< yes : True no : False	msdyn_allowdeletelocation
ALLOWNEWSUBLOCATIONS	>< yes : True no : False	msdyn_allownewsublocations
ALLOWRENAMELOCATION	>< yes : True no : False	msdyn_allowrenamelocation
FUNCTIONALLOCATIONACTIVE	>< yes : True no : False	msdyn_functionallocationactive
LIFECYCLESTATEID	=	msdyn_functionallocationlifecyclestate_id
NAME	=	msdyn_name
ALLOWINSTALLMAINTENANCEASSETS	>< yes : True no : False	msdyn_allowinstallmaintenanceassets
CREATELOCATIONMAINTENANCEASSET	>< yes : True no : False	msdyn_createlocationmaintenanceasset
MAINTENANCEASSETLIFECYCLESTATEID	=	msdyn_assetlifecyclestate.msdyn_assetlifecyclestate_id

Asset management functional location types (msdyn_functionallocationtypes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
ALLOWMULTIPLEINSTALLEDASSETS	>< yes : True no : False	msdyn_allowmultipleinstalledassets
FUNCTIONALLOCATIONTYPEID	=	msdyn_functionallocationtype_id
NAME	=	msdyn_name
UPDATEASSETDIMENSION	>< yes : True no : False	msdyn_updateassetdimension
LIFECYCLEMODELID	=	msdyn_lifecyclemodelid.msdyn_functionallocationlifecyclemodel_id
MAINTENANCEASSETTYPEID	=	msdyn_maintenanceassettype.msdyn_maintenanceassettypeid

Asset management functional locations (msdyn_functionallocations)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
FUNCTIONALLOCATIONID	=	msdyn_functionallocation_id
INVENTORYLOCATIONID	=	msdyn_inventorylocationid
INVENTORYSITEID	=	msdyn_inventorysiteid
NAME	=	msdyn_name
NOTES	=	msdyn_notes
PARENTFUNCTIONALLOCATIONID	=	msdyn_parentfunctionallocation.msdyn_functionallocation_id
FUNCTIONALLOCATIONLIFECYCLESTATEID	=	msdyn_functionallocationlifecyclestate.msdyn_functionallocationlifecyclestate_id
FUNCTIONALLOCATIONTYPEID	=	msdyn_functionallocationtype.msdyn_functionallocationtype_id

Asset management manufacturers (msdyn_manufacturers)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DESCRIPTION	=	msdyn_description
PRODUCTID	=	msdyn_manufacturer_id

Asset management models (msdyn_models)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DESCRIPTION	=	msdyn_description
MODELID	=	msdyn_model_id
PRODUCTID	=	msdyn_manufacturer.msdyn_manufacturer_id
MAINTENANCEASSETTYPEID	=	msdyn_maintenanceassettype.msdyn_maintenanceassettypeid

Asset management warranty (msdyn_warranties)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
NAME	=	msdyn_name
WARRANTYID	=	msdyn_warranty_id

CDS Contacts V2 (contacts)

This template synchronizes data between finance and operations apps and Dataverse.

Source filter: (AssociatedContactType = 1)

Reversed source filter: msdyn_contactforvendor eq true and msdyn_sellable eq false and msdyn_contactpersonid ne null

Finance and operations field	Map type	Customer engagement column	Default value
CONTACTPERSONPARTYNUMBER	=	msdyn_partyid.msdyn_partynumber
ASSOCIATEDCONTACTTYPE	<<	none	Vendor
ASSOCIATEDCONTACTNUMBER	=	msdyn_vendorcontactid.msdyn_vendoraccountnumber
EMPLOYMENTDEPARTMENT	=	department
NOTES	=	description
GOVERNMENTIDENTIFICATIONNUMBER	=	governmentid
ISRECEIVINGDIRECTMAIL	>< no : False yes : True	donotemail
SPOUSENAME	=	spousesname
none	>>	msdyn_contactforvendor	True
CONTACTPERSONID	=	msdyn_contactpersonid

CDS Exchange Rates (msdyn_currencyexchangerates)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
EXCHANGERATETYPENAME	>	msdyn_currencyexchangeratepair.msdyn_currencyexchangeratetypeid.msdyn_name
FROMCURRENCYCODE	>	msdyn_currencyexchangeratepair.msdyn_fromtransactioncurrencyid.isocurrencycode
TOCURRENCYCODE	>	msdyn_currencyexchangeratepair.msdyn_totransactioncurrencyid.isocurrencycode
RATE	>	msdyn_exchangerate
VALIDFROM	>	msdyn_validfrom
VALIDTO	>	msdyn_validto

CDS Parties (msdyn_parties)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PARTYNUMBER	=	msdyn_partynumber
PARTYTYPE	>< person : 192350001 organization : 192350002 legalEntity : 192350003 team : 192350004 operatingUnit : 192350005 none : 192350000	msdyn_partytype
NAMEALIAS	=	msdyn_namealias
KNOWNAS	=	msdyn_nickname
LANGUAGEID	>< ar : 192350000 ar-ae : 192350001 en-us : 192350015 en-gb : 192350009 cs : 192350002 da : 192350003 de : 192350004 de-at : 192350005 de-ch : 192350006 en-au : 192350007 en-ca : 192350008 en-ie : 192350010 en-in : 192350011 en-my : 192350012 en-nz : 192350013 en-sg : 192350014 en-za : 192350016 es : 192350017 es-mx : 192350018 et : 192350019 fi : 192350020 fr : 192350021 fr-be : 192350022 fr-ca : 192350023 fr-ch : 192350024 hu : 192350025 is : 192350026 it : 192350027 it-ch : 192350028 ja : 192350029 lt : 192350030 lv : 192350031 nb-no : 192350032 nl : 192350033 nl-be : 192350034 pl : 192350035 pt-br : 192350036 ru : 192350037 sv : 192350038 th : 192350039 tr : 192350040 zh-hans : 192350041	msdyn_language
ORGANIZATIONNAME	=	msdyn_organizationname
ORGANIZATIONABCCODE	>< a : 192350000 b : 192350001 c : 192350002 none : 192350003	msdyn_organizationabccode
ORGANIZATIONNUMOFEMPLOYEES	=	msdyn_numberofemployees
ORGANIZATIONNUMBER	=	msdyn_organizationnumber
ORGANIZATIONPHONETICNAME	=	msdyn_organizationphoneticname
PERSONFIRSTNAME	=	msdyn_firstname
PERSONMIDDLENAME	=	msdyn_middlename
PERSONLASTNAME	=	msdyn_lastname
PERSONLASTNAMEPREFIX	=	msdyn_lastnameprefix
PERSONINITIALS	=	msdyn_initials
PERSONPROFESSIONALTITLE	=	msdyn_professionaltitle
PERSONPROFESSIONALSUFFIX	=	msdyn_professionalsuffix
PERSONPHONETICFIRSTNAME	=	msdyn_phoneticfirstname
PERSONPHONETICLASTNAME	=	msdyn_phoneticlastname
PERSONPHONETICMIDDLENAME	=	msdyn_phoneticmiddlename
PERSONGENDER	>< male : 1 female : 2 non-Specific : 192350000 unknown : 192350001	msdyn_gender
PERSONMARITALSTATUS	>< single : 1 married : 2 divorced : 3 widowhood : 4 none : 192350000	msdyn_maritalstatus
PERSONHOBBIES	=	msdyn_hobbies
PERSONCHILDRENNAMES	=	msdyn_childrennames
PERSONANNIVERSARYDAY	=	msdyn_anniversaryday
PERSONANNIVERSARYYEAR	=	msdyn_anniversaryyear
PERSONBIRTHDAY	=	msdyn_birthday
PERSONBIRTHYEAR	=	msdyn_birthyear
PERSONANNIVERSARYMONTH	>< january : 1 february : 2 march : 3 none : 0 april : 4 may : 5 june : 6 july : 7 august : 8 september : 9 october : 10 november : 11 december : 12	msdyn_anniversarymonth
PERSONBIRTHMONTH	>< none : 0 january : 1 february : 2 march : 3 april : 4 may : 5 june : 6 july : 7 august : 8 september : 9 october : 10 november : 11 december : 12	msdyn_birthmonth

CDS Party postal address locations (msdyn_partypostaladdresses)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
ISPRIMARY	>< no : False yes : True	msdyn_isprimary
LOCATIONID	=	msdyn_postaladdresscollectionid.msdyn_location
PARTYNUMBER	=	msdyn_partyid.msdyn_partynumber
PURPOSE	=	msdyn_postaladdresspurposenames
ISLOCATIONOWNER	>> no : False yes : True	msdyn_islocationowner

CDS inventory on-hand entries (msdyn_inventoryonhandentries)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
REQUESTID	=	msdyn_request.msdyn_requestid
INVENTORYSITEID	=	msdyn_inventorysite.msdyn_siteid
INVENTORYWAREHOUSEID	=	msdyn_inventorywarehouse.msdyn_warehouseidentifier
AVAILABLEONHANDQUANTITY	>	msdyn_availableonhandquantity
AVAILABLEORDEREDQUANTITY	>	msdyn_availableorderedquantity
ONHANDQUANTITY	>	msdyn_onhandquantity
ONORDERQUANTITY	>	msdyn_onorderquantity
ORDEREDQUANTITY	>	msdyn_orderedquantity
RESERVEDONHANDQUANTITY	>	msdyn_reservedonhandquantity
RESERVEDORDEREDQUANTITY	>	msdyn_reservedorderedquantity
TOTALAVAILABLEQUANTITY	>	msdyn_totalavailablequantity
ATPDATE	=	msdyn_atpdate
ATPQUANTITY	>	msdyn_atpquantity
PROJECTEDISSUEQUANTITY	>	msdyn_projectedissuequantity
PROJECTEDONHANDQUANTITY	>	msdyn_projectedonhandquantity
PROJECTEDRECEIPTQUANTITY	>	msdyn_projectedreceiptquantity
ORDERQUANTITY	>	msdyn_orderquantity
UNAVAILABLEONHANDQUANTITY	>	msdyn_unavailableonhandquantity

CDS inventory on-hand requests (msdyn_inventoryonhandrequests)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
REQUESTID	=	msdyn_requestid
PRODUCTNUMBER	<	msdyn_product.msdyn_productnumber
ISATPCALCULATION	<< no : False yes : True	msdyn_isatpcalculation
ORDERQUANTITY	<	msdyn_orderquantity
INVENTORYSITEID	<	msdyn_inventorysite.msdyn_siteid
INVENTORYWAREHOUSEID	<	msdyn_inventorywarehouse.msdyn_warehouseidentifier
REFERENCENUMBER	<	msdyn_referencenumber
LINECREATIONSEQUENCENUMBER	<	msdyn_linecreationsequencenumber

CDS postal address history V2 (msdyn_postaladdresses)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
LOCATIONID	=	msdyn_postaladdresscollectionid.msdyn_location
VALIDFROM	=	msdyn_validfrom
VALIDTO	=	msdyn_validto
DESCRIPTION	=	msdyn_name
STREET	=	msdyn_street
STREETNUMBER	=	msdyn_streetnumber
CITY	=	msdyn_city
STATE	=	msdyn_state
COUNTRYREGIONID	=	msdyn_countryregionid
ZIPCODE	=	msdyn_zipcode
COUNTY	=	msdyn_county
DISTRICTNAME	=	msdyn_district
BUILDINGCOMPLIMENT	=	msdyn_buildingcompliment
POSTBOX	=	msdyn_postbox

CDS postal address locations (msdyn_postaladdresscollections)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DESCRIPTION	=	msdyn_description
LOCATIONID	=	msdyn_location

CDS purchase order line entity (msdyn_purchaseorderproducts)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
REQUESTEDDELIVERYDATE	=	msdyn_dateexpected
LINEDESCRIPTION	=	msdyn_description
LINENUMBER	=	msdyn_lineorder
PRODUCTNUMBER	=	msdyn_product.msdyn_productnumber
PURCHASEORDERNUMBER	=	msdyn_purchaseorder.msdyn_name
ORDEREDPURCHASEQUANTITY	=	msdyn_quantity
LINEAMOUNT	>	msdyn_lineamount
PURCHASEPRICE	>	msdyn_unitcost
BARCODE	=	msdyn_barcode
CATCHWEIGHTUNITSYMBOL	=	msdyn_catchweightunitsymbol.msdyn_symbol
CONFIRMEDSHIPPINGDATE	=	msdyn_confirmedshippingdate
CUSTOMERREFERENCE	=	msdyn_customerreference
CUSTOMERREQUISITIONNUMBER	=	msdyn_customerrequisitionnumber
EXTERNALITEMNUMBER	=	msdyn_externalitemnumber
ISPARTIALDELIVERYPREVENTED	>< yes : true no : false	msdyn_ispartialdeliveryprevented
LINEDISCOUNTAMOUNT	>	msdyn_linediscountamount
LINEDISCOUNTPERCENTAGE	>	msdyn_linediscountpercentage
ORDEREDCATCHWEIGHTQUANTITY	=	msdyn_orderedcatchweightquantity
PURCHASEORDERLINESTATUS	>> none : 192350000 backorder : 192350001 received : 192350002 invoiced : 192350003 canceled : 192350004	msdyn_purchaseorderlinestatus
PURCHASEPRICEQUANTITY	=	msdyn_purchasepricequantity
RECEIVINGSITEID	=	msdyn_receivingsiteid.msdyn_siteid
REQUESTEDSHIPPINGDATE	=	msdyn_requestedshippingdate
REQUESTERPERSONNELNUMBER	=	msdyn_requesterpersonnelnumber.cdm_workernumber
PROCUREMENTPRODUCTCATEGORYNAME	>	msdyn_procurementproductcategory.msdyn_name
PROCUREMENTPRODUCTCATEGORYHIERACHYNAME	>	msdyn_procurementproductcategory.msdyn_hierarchy.msdyn_name
CURRENCYCODE	>	transactioncurrencyid.isocurrencycode
CONFIRMEDDELIVERYDATE	=	msdyn_confirmeddeliverydate
DELIVERYADDRESSCITY	>	msdyn_deliveryaddresscity
DELIVERYADDRESSCOUNTRYREGIONID	>	msdyn_deliveryaddresscountryregionid
DELIVERYADDRESSSTATEID	>	msdyn_deliveryaddressstate
DELIVERYADDRESSSTREET	>	msdyn_deliveryaddressstreet
DELIVERYADDRESSSTREETNUMBER	>	msdyn_deliveryaddressstreetnumber
DELIVERYADDRESSZIPCODE	>	msdyn_deliveryaddresszipcode
FORMATTEDDELVERYADDRESS	>	msdyn_formatteddeliveryaddress
PURCHASEUNITSYMBOL	=	msdyn_unit.msdyn_symbol
RECEIVINGWAREHOUSEID	=	msdyn_associatetowarehouse.msdyn_warehouseidentifier
DELIVERYADDRESSDESCRIPTION	>	msdyn_deliveryaddressdescription
DELIVERYADDRESSNAME	>	msdyn_deliveryaddressname

CDS purchase order line soft deleted entity (msdyn_purchaseorderproducts)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
LINENUMBER	>	msdyn_lineorder
PURCHASEORDERNUMBER	>	msdyn_purchaseorder.msdyn_name
ISDELETED	>> yes : true no : false	msdyn_issoftdeletedinscm

CDS released distinct products (products)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PRODUCTNUMBER	>	msdyn_productnumber
PRODUCTNAME	>	name
PRODUCTDESCRIPTION	>	description
ITEMNUMBER	>	msdyn_itemnumber
CURRENCYCODE	>	transactioncurrencyid.isocurrencycode
SALESUNITSYMBOL	>	defaultuomid.msdyn_symbol
SALESPRICE	>	price
UNITCOST	>	currentcost
PRODUCTTYPE	>> item : 1 service : 3	producttypecode
SALESUNITDECIMALPRECISION	>>	quantitydecimal	0
ISCATCHWEIGHTPRODUCT	>> no : false yes : true	msdyn_iscatchweight
ISSTOCKEDPRODUCT	>> no : False yes : True	msdyn_isstockedproduct
PRODUCTCOLORID	>	msdyn_productcolor.msdyn_productcolorname
PRODUCTCONFIGURATIONID	>	msdyn_productconfiguration.msdyn_productconfiguration
PRODUCTSIZEID	>	msdyn_productsize.msdyn_productsize
PRODUCTSTYLEID	>	msdyn_productstyle.msdyn_productstyle
FIELDSERVICEPRODUCTTYPE	>> Inventory : 690970000 NonInventory : 690970001 Service : 690970002	msdyn_fieldserviceproducttype
[None]	>>	msdyn_shouldsyncwithsharedproductdetails	False

CDS sales order headers (salesorders)

This template synchronizes data between finance and operations apps and Dataverse.

Reversed source filter: msdyn_ordertype eq 192350000

Finance and operations field	Map type	Customer engagement column	Default value
SALESORDERNUMBER	=	msdyn_salesordernumber
ORDERINGCUSTOMERACCOUNTNUMBER	=	customerid.Account(accountnumber).Contact(msdyn_contactpersonid)
CURRENCYCODE	=	transactioncurrencyid.isocurrencycode
DELIVERYADDRESSCITY	=	shipto_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE	>< us : united states de : germany fr : france gb : united kingdom jp : japan in : india es : spain nz : new zealand au : australia co : columbia za : south africa be : belgium ca : canada at : austria tr : türkiye cn : china dk : denmark se : sweden no : norway fi : finland eg : egypt	shipto_country
DELIVERYADDRESSSTREETNUMBER	=	shipto_line2
DELIVERYADDRESSZIPCODE	=	shipto_postalcode
DELIVERYADDRESSSTREET	=	shipto_line1
DELIVERYADDRESSSTATEID	=	shipto_stateorprovince
SALESORDERNAME	>	name
INVOICEADDRESSCITY	>	billto_city
INVOICEADDRESSSTREET	>	billto_line1
INVOICEADDRESSSTREETNUMBER	>	billto_line2
INVOICEADDRESSCOUNTRYREGIONISOCODE	>	billto_country
INVOICEADDRESSSTATEID	>	billto_stateorprovince
INVOICEADDRESSZIPCODE	>	billto_postalcode
ORDERTOTALAMOUNT	>	totalamount
TOTALDISCOUNTAMOUNT	>	discountamount
ORDERTOTALTAXAMOUNT	>	totaltax
ORDERTOTALCHARGESAMOUNT	>	freightamount
AREPRICESINCLUDINGSALESTAX	>< no : False yes : True	msdyn_arepricesincludingsalestax
CONFIRMEDRECEIPTDATE	=	msdyn_confirmedreceiptdate
CONFIRMEDSHIPPINGDATE	=	msdyn_confirmedshippingdate
CONTACTPERSONID	=	msdyn_associatedcontact.msdyn_contactforpartynumber
CUSTOMERREQUISITIONNUMBER	=	msdyn_customerrequisitionnumber
DEFAULTSHIPPINGSITEID	=	msdyn_defaultshippingsite.msdyn_siteid
DEFAULTSHIPPINGWAREHOUSEID	=	msdyn_defaultshippingwarehouse.msdyn_warehouseidentifier
DELIVERYADDRESSCOUNTYID	=	msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION	=	msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME	=	msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER	=	msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLATITUDE	=	msdyn_deliveryaddresslatitude
DELIVERYADDRESSLOCATIONID	=	msdyn_deliveryaddresslocationid
DELIVERYADDRESSLONGITUDE	=	msdyn_deliveryaddresslongitude
DELIVERYADDRESSNAME	=	msdyn_deliveryaddressname
DELIVERYADDRESSPOSTBOX	=	msdyn_deliveryaddresspostbox
DELIVERYBUILDINGCOMPLIMENT	=	msdyn_deliverybuildingcompliment
FORMATTEDDELVERYADDRESS	>	msdyn_formatteddeliveryaddress
EMAIL	=	emailaddress
FORMATTEDINVOICEADDRESS	>	msdyn_formattedinvoiceaddress
INVOICEADDRESSCOUNTYID	>	msdyn_invoiceaddresscountyid
INVOICEADDRESSDISTRICTNAME	>	msdyn_invoiceaddressdistrictname
INVOICEADDRESSLATITUDE	>	msdyn_invoiceaddresslatitude
INVOICEADDRESSLONGITUDE	>	msdyn_invoiceaddresslongitude
INVOICEADDRESSPOSTBOX	>	msdyn_invoiceaddresspostbox
INVOICEBUILDINGCOMPLIMENT	>	msdyn_invoicebuildingcompliment
INVOICECUSTOMERACCOUNTNUMBER	=	msdyn_invoicecustomerid.Account(accountnumber).Contact(msdyn_contactpersonid)
ISDELIVERYADDRESSORDERSPECIFIC	>< no : False yes : True	msdyn_isdeliveryaddressorderspecific
ISDELIVERYADDRESSPRIVATE	>< no : False yes : True	msdyn_isdeliveryaddressprivate
ISINVOICEADDRESSPRIVATE	>> no : False yes : True	msdyn_isinvoiceaddressprivate
ISONETIMECUSTOMER	>< no : False yes : True	msdyn_isonetimecustomer
ISSALESPROCESSINGSTOPPED	>< no : False yes : True	msdyn_issalesprocessingstopped
PAYMENTTERMSBASEDATE	=	msdyn_paymenttermsbasedate
PAYMENTTERMSNAME	=	msdyn_paymentterms.msdyn_name
PRICECUSTOMERGROUPCODE	=	msdyn_pricecustomergroup.msdyn_groupcode
QUOTATIONNUMBER	=	msdyn_quotationnumber
REQUESTEDRECEIPTDATE	=	msdyn_requestedreceiptdate
REQUESTEDSHIPPINGDATE	=	requestdeliveryby
SALESORDERPROMISINGMETHOD	>< none : 192350000 salesLeadTime : 192350001 atp : 192350002 atpPlusIssueMargin : 192350003 ctp : 192350004	msdyn_salesorderpromisingmethod
URL	=	msdyn_url
SALESORDERPROCESSINGSTATUS	>< active : 192350000 confirmed : 192350001 picked : 192350002 partiallyDelivered : 192350003 delivered : 192350004 invoiced : 192350005 partiallyInvoiced : 192350006 canceled : 192350007	msdyn_processingstatus
LANGUAGEID	>< ar : 192350000 ar-ae : 192350001 cs : 192350002 da : 192350003 de : 192350004 de-at : 192350005 de-ch : 192350006 en-au : 192350007 en-gb : 192350009 en-ie : 192350010 en-in : 192350011 en-ca : 192350008 en-my : 192350012 en-nz : 192350013 en-sg : 192350014 en-us : 192350015 en-za : 192350016 es : 192350017 es-mx : 192350018 et : 192350019 fi : 192350020 fr : 192350021 fr-be : 192350022 fr-ca : 192350023 fr-ch : 192350024 hu : 192350025 is : 192350026 it : 192350027 it-ch : 192350028 ja : 192350029 lt : 192350030 lv : 192350031 nb-no : 192350032 nl : 192350033 nl-be : 192350034 pl : 192350035 pt-br : 192350036 ru : 192350037 sv : 192350038 th : 192350039 tr : 192350040 zh-hans : 192350041	msdyn_language
CUSTOMERSORDERREFERENCE	=	msdyn_customersorderreference
DELIVERYMODECODE	=	msdyn_deliverymode.msdyn_name
DELIVERYTERMSCODE	=	msdyn_deliveryterms.msdyn_termscode
SALESORDERORIGINCODE	=	msdyn_salesorderorigin.msdyn_origincode
none	>>	msdyn_ordertype	192350000
CURRENCYCODE	>	msdyn_isocurrencycode

CDS sales order lines (salesorderdetails)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
CURRENCYCODE	>	transactioncurrencyid.isocurrencycode
DELIVERYADDRESSCITY	=	shipto_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE	>< us : united states de : germany fr : france gb : united kingdom jp : japan in : india es : spain nz : new zealand au : australia co : columbia za : south africa be : belgium ca : canada at : austria tr : türkiye cn : china dk : denmark se : sweden no : norway fi : finland eg : egypt	shipto_country
DELIVERYADDRESSZIPCODE	=	shipto_postalcode
DELIVERYADDRESSSTATEID	=	shipto_stateorprovince
DELIVERYADDRESSSTREET	=	shipto_line1
DELIVERYADDRESSSTREETNUMBER	=	shipto_line2
LINEAMOUNT	>	extendedamount
LINECREATIONSEQUENCENUMBER	=	sequencenumber
ORDEREDSALESQUANTITY	=	quantity
PRODUCTNAME	=	description
PRODUCTNUMBER	=	productid.msdyn_productnumber
SALESORDERNUMBER	=	salesorderid.msdyn_salesordernumber
SALESUNITSYMBOL	=	uomid.msdyn_symbol
TOTALDISCOUNTAMOUNT	=	manualdiscountamount
TOTALTAXAMOUNT	>	tax
SALESPRICE	=	priceperunit
LINEAMOUNT	>	baseamount
SALESPRODUCTCATEGORYNAME	=	msdyn_salesproductcategory.msdyn_name
SALESPRODUCTCATEGORYHIERARCHYNAME	>	msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name
ISDELIVERYADDRESSORDERSPECIFIC	>< no : False yes : True	msdyn_isdeliveryaddressspecific
ISDELIVERYADDRESSPRIVATE	>< no : False yes : True	msdyn_isdeliveryaddressprivate
ISLINESTOPPED	>< no : False yes : True	msdyn_islinestopped
ALLOWEDOVERDELIVERYPERCENTAGE	=	msdyn_allowedoverdeliverypercentage
ALLOWEDUNDERDELIVERYPERCENTAGE	=	msdyn_allowedunderdeliverypercentage
CONFIRMEDSHIPPINGDATE	=	msdyn_confirmedshippingdate
CONFIRMEDRECEIPTDATE	=	msdyn_confirmedreceiptdate
DELIVERYADDRESSCOUNTYID	=	msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION	=	msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME	=	msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER	=	msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLATITUDE	=	msdyn_deliveryaddresslatitude
DELIVERYADDRESSLOCATIONID	=	msdyn_deliveryaddresslocationid
DELIVERYADDRESSLONGITUDE	=	msdyn_deliveryaddresslongitude
DELIVERYADDRESSNAME	=	msdyn_deliveryaddressname
DELIVERYADDRESSPOSTBOX	=	msdyn_deliveryaddresspostbox
DELIVERYBUILDINGCOMPLIMENT	=	msdyn_deliverybuildingcompliment
EXTERNALITEMNUMBER	=	msdyn_externalitemnumber
FIXEDPRICECHARGES	=	msdyn_fixedpricecharges
FORMATTEDDELIVERYADDRESS	=	msdyn_formatteddeliveryaddress
LINEDESCRIPTION	=	msdyn_linedescription
LINEDISCOUNTAMOUNT	=	msdyn_linediscountamount
LINEDISCOUNTPERCENTAGE	=	msdyn_linediscountpercentage
MULTILINEDISCOUNTAMOUNT	=	msdyn_multilinediscountamount
MULTILINEDISCOUNTPERCENTAGE	=	msdyn_multilinediscountpercentage
REQUESTEDRECEIPTDATE	=	msdyn_requestedreceiptdate
REQUESTEDSHIPPINGDATE	=	requestdeliveryby
SALESORDERLINESTATUS	>> none : 192350000 backorder : 192350001 delivered : 192350002 invoiced : 192350003 canceled : 192350004	msdyn_linestatus
SALESORDERPROMISINGMETHOD	>< none : 192350000 salesLeadTime : 192350001 atp : 192350002 atpPlusIssueMargin : 192350003 ctp : 192350004	msdyn_salesorderpromisingmethod
SALESPRICEQUANTITY	=	msdyn_salespricequantity
SHIPPINGSITEID	=	msdyn_shippingsite.msdyn_siteid
SHIPPINGWAREHOUSEID	=	msdyn_shippingwarehouse.msdyn_warehouseidentifier
none	>>	ispriceoverridden	true
TOTALCHARGESAMOUNT	>	msdyn_totalchargesamount
DELIVERYMODECODE	=	msdyn_deliverymode.msdyn_name
DELIVERYTERMSID	=	msdyn_deliveryterms.msdyn_termscode

CDS sales quotation header (quotes)

This template synchronizes data between finance and operations apps and Dataverse.

Reversed source filter: msdyn_ordertype eq 192350000 and statecode eq 0

Finance and operations field	Map type	Customer engagement column	Default value
SALESQUOTATIONNUMBER	=	msdyn_quotenumber
REQUESTINGCUSTOMERACCOUNTNUMBER	=	customerid.Account(accountnumber).Contact(msdyn_contactpersonid)
CURRENCYCODE	=	transactioncurrencyid.isocurrencycode
CUSTOMERSREFERENCE	=	msdyn_customersreference
DELIVERYADDRESSCITY	=	shipto_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE	>< us : united states de : germany fr : france gb : united kingdom jp : japan in : india es : spain nz : new zealand au : australia co : columbia za : south africa be : belgium ca : canada at : austria tr : türkiye cn : china dk : denmark se : sweden no : norway fi : finland eg : egypt	shipto_country
DELIVERYADDRESSSTREETNUMBER	=	shipto_line2
DELIVERYADDRESSZIPCODE	=	shipto_postalcode
DELIVERYADDRESSSTREET	=	shipto_line1
DELIVERYADDRESSSTATEID	=	shipto_stateorprovince
SALESQUOTATIONNAME	=	name
INVOICEADDRESSCITY	>	billto_city
INVOICEADDRESSSTREET	>	billto_line1
INVOICEADDRESSSTREETNUMBER	>	billto_line2
INVOICEADDRESSCOUNTRYREGIONISOCODE	>	billto_country
INVOICEADDRESSSTATEID	>	billto_stateorprovince
INVOICEADDRESSZIPCODE	>	billto_postalcode
QUOTATIONTOTALAMOUNT	>	totalamount
TOTALDISCOUNTAMOUNT	>	discountamount
QUOTATIONTOTALTAXAMOUNT	>	totaltax
QUOTATIONTOTALCHARGESAMOUNT	>	freightamount
AREPRICESINCLUDINGSALESTAX	>< no : False yes : True	msdyn_arepricesincludingsalestax
CONTACTPERSONID	=	msdyn_associatedcontact.msdyn_contactforpartynumber
CUSTOMERREQUISITIONNUMBER	=	msdyn_customerrequisitionnumber
DEFAULTSHIPPINGSITEID	=	msdyn_defaultshippingsite.msdyn_siteid
DEFAULTSHIPPINGWAREHOUSEID	=	msdyn_defaultshippingwarehouse.msdyn_warehouseidentifier
DELIVERYADDRESSCOUNTYID	=	msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION	=	msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME	=	msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER	=	msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLATITUDE	=	msdyn_deliveryaddresslatitude
DELIVERYADDRESSLOCATIONID	=	msdyn_deliveryaddresslocationid
DELIVERYADDRESSLONGITUDE	=	msdyn_deliveryaddresslongitude
DELIVERYADDRESSNAME	=	msdyn_deliveryaddressname
DELIVERYADDRESSPOSTBOX	=	msdyn_deliveryaddresspostbox
DELIVERYBUILDINGCOMPLIMENT	=	msdyn_deliverybuildingcompliment
FORMATTEDDELIVERYADDRESS	>	msdyn_formatteddeliveryaddress
FORMATTEDINVOICEADDRESS	>	msdyn_formattedinvoiceaddress
GENERATEDSALESORDERNUMBER	=	msdyn_generatedsalesordernumber.msdyn_salesordernumber
INVOICEADDRESSCOUNTRYREGIONID	>	msdyn_invoiceaddresscountryregionid
INVOICEADDRESSCOUNTYID	>	msdyn_invoiceaddresscountyid
INVOICEADDRESSDISTRICTNAME	>	msdyn_invoiceaddressdistrictname
INVOICEADDRESSLATITUDE	>	msdyn_invoiceaddresslatitude
INVOICEADDRESSLONGITUDE	>	msdyn_invoiceaddresslongitude
INVOICEADDRESSPOSTBOX	>	msdyn_invoiceaddresspostbox
INVOICEBUILDINGCOMPLIMENT	>	msdyn_invoicebuildingcompliment
INVOICECUSTOMERACCOUNTNUMBER	=	msdyn_invoicecustomerid.Account(accountnumber).Contact(msdyn_contactpersonid)
ISDELIVERYADDRESSORDERSPECIFIC	>< no : False yes : True	msdyn_isdeliveryaddressorderspecific
ISDELIVERYADDRESSPRIVATE	>< no : False yes : True	msdyn_isdeliveryaddressprivate
ISINVOICEADDRESSPRIVATE	>> no : False yes : True	msdyn_isinvoiceaddressprivate
LANGUAGEID	>< ar : 192350000 ar-ae : 192350001 cs : 192350002 da : 192350003 de : 192350004 de-at : 192350005 de-ch : 192350006 en-au : 192350007 en-gb : 192350009 en-ie : 192350010 en-in : 192350011 en-ca : 192350008 en-my : 192350012 en-nz : 192350013 en-sg : 192350014 en-us : 192350015 en-za : 192350016 es : 192350017 es-mx : 192350018 et : 192350019 fi : 192350020 fr : 192350021 fr-be : 192350022 fr-ca : 192350023 fr-ch : 192350024 hu : 192350025 is : 192350026 it : 192350027 it-ch : 192350028 ja : 192350029 lt : 192350030 lv : 192350031 nb-no : 192350032 nl : 192350033 nl-be : 192350034 pl : 192350035 pt-br : 192350036 ru : 192350037 sv : 192350038 th : 192350039 tr : 192350040 zh-hans : 192350041	msdyn_language
PAYMENTTERMSNAME	=	msdyn_paymentterms.msdyn_name
PRICECUSTOMERGROUPCODE	=	msdyn_pricecustomergroup.msdyn_groupcode
RECEIPTDATEREQUESTED	=	msdyn_requestedreceiptdate
REQUESTEDSHIPPINGDATE	=	requestdeliveryby
SALESORDERPROMISINGMETHOD	>< none : 192350000 salesLeadTime : 192350001 atp : 192350002 atpPlusIssueMargin : 192350003 ctp : 192350004	msdyn_salesorderpromisingmethod
SALESQUOTATIONCONFIRMATIONDATE	=	msdyn_salesquotationconfirmationdate
SALESQUOTATIONEXPIRYDATE	=	msdyn_salesquotationexpirydate
SALESQUOTATIONFOLLOWUPDATE	=	msdyn_salesquotationfollowupdate
SALESQUOTATIONSTATUS	>< created : 192350000 sent : 192350001 confirmed : 192350002 lost : 192350003 cancelled : 192350004 reset : 192350005 modified : 192350006 submitted : 192350007 approved : 192350008 revised : 192350009	msdyn_salesquotationstatus
TOTALDISCOUNTPERCENTAGE	=	msdyn_totaldiscountpercentage
URL	=	msdyn_url
EMAIL	=	emailaddress
none	>>	msdyn_ordertype	192350000
CURRENCYCODE	>	msdyn_isocurrencycode
OPERATINGUNITPARTYNUMBER	=	msdyn_operatingunit.msdyn_partynumber

CDS sales quotation lines (quotedetails)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
ALLOWEDOVERDELIVERYPERCENTAGE	=	msdyn_allowedoverdeliverypercentage
ALLOWEDUNDERDELIVERYPERCENTAGE	=	msdyn_allowedunderdeliverypercentage
SALESQUOTATIONNUMBER	=	quoteid.msdyn_quotenumber
LINECREATIONSEQUENCENUMBER	=	sequencenumber
CURRENCYCODE	>	transactioncurrencyid.isocurrencycode
DELIVERYADDRESSCITY	=	shipto_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE	>< us : united states de : germany fr : france gb : united kingdom jp : japan in : india es : spain nz : new zealand au : australia co : columbia za : south africa be : belgium ca : canada at : austria tr : türkiye cn : china dk : denmark se : sweden no : norway fi : finland eg : egypt	shipto_country
DELIVERYADDRESSCOUNTYID	=	msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION	=	msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME	=	msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER	=	msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLATITUDE	=	msdyn_deliveryaddresslatitude
DELIVERYADDRESSLOCATIONID	=	msdyn_deliveryaddresslocationid
DELIVERYADDRESSLONGITUDE	=	msdyn_deliveryaddresslongitude
DELIVERYADDRESSNAME	=	msdyn_deliveryaddressname
DELIVERYADDRESSPOSTBOX	=	msdyn_deliveryaddresspostbox
DELIVERYADDRESSSTATEID	=	shipto_stateorprovince
DELIVERYADDRESSSTREET	=	shipto_line1
DELIVERYADDRESSSTREETNUMBER	=	shipto_line2
DELIVERYADDRESSZIPCODE	=	shipto_postalcode
DELIVERYBUILDINGCOMPLIMENT	=	msdyn_deliverybuildingcompliment
EXTERNALITEMNUMBER	=	msdyn_externalitemnumber
FIXEDPRICECHARGES	=	msdyn_fixedpricecharges
FORMATTEDDELIVERYADDRESS	=	msdyn_formatteddeliveryaddress
ISDELIVERYADDRESSPRIVATE	>< no : False yes : True	msdyn_isdeliveryaddressprivate
ISDELIVERYADDRESSORDERSPECIFIC	>< no : False yes : True	msdyn_isdeliveryaddressspecific
LINEAMOUNT	>	baseamount
LINEAMOUNT	>	extendedamount
LINEDESCRIPTION	=	msdyn_linedescription2
LINEDISCOUNTAMOUNT	=	msdyn_linediscountamount
LINEDISCOUNTPERCENTAGE	=	msdyn_linediscountpercentage
MULTILINEDISCOUNTAMOUNT	=	msdyn_multilinediscountamount
MULTILINEDISCOUNTPERCENTAGE	=	msdyn_multilinediscountpercentage
PRODUCTNAME	=	description
PRODUCTNUMBER	=	productid.msdyn_productnumber
REQUESTEDRECEIPTDATE	=	msdyn_requestedreceiptdate
REQUESTEDSALESQUANTITY	=	quantity
REQUESTEDSHIPPINGDATE	=	requestdeliveryby
SALESPRICE	=	priceperunit
SALESPRICEQUANTITY	=	msdyn_salespricequantity
SALESQUOTATIONPROMISINGMETHOD	>< none : 192350000 salesLeadTime : 192350001 atp : 192350002 atpPlusIssueMargin : 192350003 ctp : 192350004	msdyn_salesquotationpromisingmethod
SALESQUOTATIONSTATUS	>< created : 192350000 sent : 192350001 confirmed : 192350002 lost : 192350003 cancelled : 192350004 reset : 192350005 modified : 192350006 submitted : 192350007 approved : 192350008 revised : 192350009	msdyn_salesquotationstatus
SALESUNITSYMBOL	=	uomid.msdyn_symbol
SHIPPINGSITEID	=	msdyn_shippingsite.msdyn_siteid
SHIPPINGWAREHOUSEID	=	msdyn_shippingwarehouse.msdyn_warehouseidentifier
TOTALCHARGESAMOUNT	>	msdyn_totalchargesamount
TOTALDISCOUNTAMOUNT	=	manualdiscountamount
TOTALTAXAMOUNT	>	tax
SALESPRODUCTCATEGORYHIERARCHYNAME	>	msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name
SALESPRODUCTCATEGORYNAME	=	msdyn_salesproductcategory.msdyn_name
none	>>	ispriceoverridden	true

Chart of accounts (msdyn_chartofaccountses)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DESCRIPTION	=	msdyn_description
MAINACCOUNTMASK	=	msdyn_mainaccountmask
CHARTOFACCOUNTS	=	msdyn_name

Colors (msdyn_productcolors)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
COLORID	>	msdyn_productcolorname

Compensation job function (cdm_jobfunctions)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
JOBFUNCTIONID	=	cdm_name
DESCRIPTION	=	cdm_description

Compensation job type (cdm_jobtypes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
JOBTYPEID	=	cdm_name
DESCRIPTION	=	cdm_description
EXEMPTSTATUS	>< exempt : 754400000 nonexempt : 754400001 doesnotapply : 754400002	cdm_exemptstatus

Complimentary closings (msdyn_complimentaryclosings)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
CLOSINGPHRASE	=	msdyn_closingphrase

Configurations (msdyn_productconfigurations)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
CONFIGURATIONID	>	msdyn_productconfiguration

Contact person titles (msdyn_salescontactpersontitles)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
JOBTITLE	=	msdyn_jobtitle
JOBTITLEALIAS	=	msdyn_jobtitlealias

Contacts V2 (msdyn_contactforparties)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
CONTACTPERSONID	=	msdyn_contactforpartynumber
CONTACTPERSONPARTYNUMBER	=	msdyn_contactpartyid.msdyn_partynumber
ASSOCIATEDPARTYNUMBER	=	msdyn_associatedpartyid.msdyn_partynumber
EMPLOYMENTPROFESSION	=	msdyn_employmentprofession
EMPLOYMENTDEPARTMENT	=	msdyn_employmentdepartment
PRIMARYSALUTATIONPHRASE	=	msdyn_primarysalutationphrase.msdyn_salutationphrase
ASSISTANTNAME	=	msdyn_assistantname
ASSISTANTPHONENUMBER	=	msdyn_assistantphonenumber
AVAILABLEFROMTIME	=	msdyn_availablefromtime
AVAILABLETOTIME	=	msdyn_availabletotime
CONTACTACTIVITYSENSITIVITYLEVEL	>< normal : 192350000 personal : 192350001 private : 192350002 confidential : 192350003	msdyn_contactactivitysensitivitylevel
CONTACTPERSONRESPONSIBLEPERSONNELNUMBER	=	msdyn_employeeresponsible.cdm_workernumber
DECISIONMAKINGROLECODE	=	msdyn_decisionmakingrole.msdyn_rolename
EMPLOYMENTCOMPUTERNETWORKNAME	=	msdyn_employmentcomputernetworkname
EMPLOYMENTJOBFUNCTIONNAME	=	msdyn_employmentjobfunctionname
EMPLOYMENTJOBTITLE	=	msdyn_jobtitle.msdyn_jobtitlealias
EMPLOYMENTOFFICELOCATION	=	msdyn_employmentofficelocation
GOVERNMENTIDENTIFICATIONNUMBER	=	msdyn_governmentidentificationnumber
HASREQUESTEDINTERNETACCESS	>< no : False yes : True	msdyn_hasrequestedinternetaccess
IDENTITYCARDNUMBER	=	msdyn_identitycardnumber
ISRECEIVINGDIRECTMAIL	>< no : False yes : True	msdyn_isreceivingdirectmail
ISVIP	>< no : False yes : True	msdyn_isvip
LOYALTYLEVELPHRASE	=	msdyn_loyaltylevelphrase.msdyn_levelphrase
MANAGERCONTACTPERSONID	=	msdyn_parentcontactforpartyid.msdyn_contactforpartynumber
MICROSOFTOUTLOOKCATEGORIES	=	msdyn_microsoftoutlookcategories
MILEAGEDISTANCE	=	msdyn_mileagedistance
NOTES	=	msdyn_notes
ORGANIZATIONIDENTIFICATIONNUMBER	=	msdyn_organizationidentificationnumber
PERSONALCHARACTERTYPECODE	=	msdyn_personalcharactertypecode.msdyn_typename
PRIMARYCOMPLIMENTARYCLOSINGPHRASE	=	msdyn_primarycomplimentaryclosingphrase.msdyn_closingphrase
CONTACTINFORMATIONLANGUAGEID	>< ar : 192350000 ar-ae : 192350001 cs : 192350002 da : 192350003 de : 192350004 de-at : 192350005 de-ch : 192350006 en-au : 192350007 en-gb : 192350009 en-ie : 192350010 en-in : 192350011 en-ca : 192350008 en-my : 192350012 en-nz : 192350013 en-sg : 192350014 en-us : 192350015 en-za : 192350016 es : 192350017 es-mx : 192350018 et : 192350019 fi : 192350020 fr : 192350021 fr-be : 192350022 fr-ca : 192350023 fr-ch : 192350024 hu : 192350025 is : 192350026 it : 192350027 it-ch : 192350028 ja : 192350029 lt : 192350030 lv : 192350031 nb-no : 192350032 nl : 192350033 nl-be : 192350034 pl : 192350035 pt-br : 192350036 ru : 192350037 sv : 192350038 th : 192350039 tr : 192350040 zh-hans : 192350041	msdyn_nativelanguage
SPOUSENAME	=	msdyn_spousename

Currencies (transactioncurrencies)

This template synchronizes data between finance and operations apps and Dataverse.

Source filter: ((CURRENCYCODE != "999"))

Finance and operations field	Map type	Customer engagement column	Default value
CURRENCYCODE	=	isocurrencycode
NAME	=	currencyname
SYMBOL	=	currencysymbol
none	>>	exchangerate	1.0000000000

Customer Attachments (annotations)

This template synchronizes data between finance and operations apps and Dataverse.

Source filter: ((TypeId == "Note") || (TypeId == "URL"))

Reversed source filter: (objecttypecode eq 'account' or objecttypecode eq 'contact') and msdyn_relatedentityid ne null

Finance and operations field	Map type	Customer engagement column	Default value
DOCUMENTID	=	msdyn_notesid
NAME	=	subject
none	>>	objecttypecode	account
CUSTOMERACCOUNTNUMBER	=	msdyn_relatedentityid
TYPEID	<<	none	Note
NOTES	=	notetext
RESTRICTION	>< internal : 0 external : 1	msdyn_restriction

Customer groups (msdyn_customergroups)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
CUSTOMERGROUPID	=	msdyn_groupid
DESCRIPTION	=	msdyn_description
ISSALESTAXINCLUDEDINPRICE	>< no : False yes : True	msdyn_issalestaxincludedinprice
PAYMENTTERMID	=	msdyn_paymenttermid.msdyn_name
CLEARINGPERIODPAYMENTTERMNAME	=	msdyn_clearingperiodpaymenttermname.msdyn_name

Customer hierarchies (msdyn_customerhierarchies)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
CUSTOMERHIERARCHYID	=	msdyn_customerhierarchynumber
NAME	=	msdyn_name
ORGANIZATIONPARTYNUMBER	=	msdyn_organizationpartynumber.msdyn_partynumber
PURPOSE	>< B2BOrganization : 192350000	msdyn_purpose

Customer hierarchy nodes (msdyn_customerhierarchynodes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
CUSTOMERHIERARCHYID	=	msdyn_customerhierarchynumber.msdyn_customerhierarchynumber
NODEPARTYNUMBER	=	msdyn_nodepartynumber.msdyn_partynumber
NODETYPE	>< Customer : 192350000	msdyn_nodetype
ROLE	>< Admin : 192350000 User : 192350001	msdyn_role

Customer payment method (msdyn_customerpaymentmethods)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
NAME	=	msdyn_name
ACCOUNTTYPE	>< ledger : 806380000 cust : 806380001 vend : 806380002 project : 806380003 fixedassets : 806380004 bank : 806380005	msdyn_accounttype
DISCOUNTGRACEPERIODDAYS	=	msdyn_discountgraceperioddays
BRIDGINGPOSTINGENABLED	>< no : False yes : True	msdyn_bridgingpostingenabled
ISSEPA	>< no : False yes : True	msdyn_issepa
LASTFILENUMBER	=	msdyn_lastfilenumber
LASTFILENUMBERTODAY	=	msdyn_lastfilenumbertoday
DESCRIPTION	=	msdyn_description
PAYMENTTYPE	>< other : 806380000 electronicPayment : 806380001 check : 806380002 billOfExchange : 806380003 creditCard : 806380004	msdyn_paymenttype
CREATEANDDRAWBILLOFEXCHANGEDURINGINVOICEPOSTING	>< no : False yes : True	msdyn_invoiceupdate
PAYMENTSTATUS	>< none : 806380000 sent : 806380001 recieved : 806380002 confirmed : 806380003 rejected : 806380004	msdyn_paymentstatus
SUMBYPERIOD	>< invoice : 806380000 week : 806380002 total : 806380003 transDate : 806380001	msdyn_sumbyperiod
ENABLEPOSTDATEDCHECKCLEARINGPOSTING	>< no : False yes : True	msdyn_enablepostdatescheckclearingposting
BILLOFEXCHANGEDRAFTTYPE	>< acceptance : 806380002 promissory : 806380003 bankAcceptance : 806380004 nodraft : 806380000 noacceptance : 806380001	msdyn_billofexchangedrafttype
DIRECTDEBIT	>< no : False yes : True	msdyn_directdebit

Customers V3 (accounts)

This template synchronizes data between finance and operations apps and Dataverse.

Source filter: ((PartyType == "Organization"))

Reversed source filter: customertypecode eq 3

Finance and operations field	Map type	Customer engagement column	Default value
CUSTOMERACCOUNT	=	accountnumber
CREDITLIMIT	=	creditlimit
SALESCURRENCYCODE	=	transactioncurrencyid.isocurrencycode
SALESMEMO	=	description
CREDITLIMITISMANDATORY	>< no : False yes : True	msdyn_creditlimitismandatory
CREDITRATING	=	msdyn_creditrating
CUSTOMERGROUPID	=	msdyn_customergroupid.msdyn_groupid
IDENTIFICATIONNUMBER	=	msdyn_identificationnumber
INVOICEACCOUNT	=	msdyn_billingaccount.accountnumber
ISONETIMECUSTOMER	>< no : False yes : True	msdyn_onetimecustomer
ONHOLDSTATUS	>< no : 806380000 invoice : 806380001 all : 806380002 payment : 806380003 requisition : 806380004 never : 806380005	msdyn_onholdstatus
PARTYCOUNTRY	=	msdyn_partycountry
PARTYSTATE	=	msdyn_partystateprovince
PAYMENTDAY	=	msdyn_paymentday.msdyn_name
PAYMENTMETHOD	=	msdyn_customerpaymentmethod.msdyn_name
PAYMENTSCHEDULE	=	msdyn_paymentschedule.msdyn_name
PAYMENTTERMS	=	msdyn_paymentterm.msdyn_name
PAYMENTTERMSBASEDAYS	=	msdyn_paymenttermsbasedays
TAXEXEMPTNUMBER	=	msdyn_taxexemptnumber
VENDORACCOUNT	=	msdyn_vendor.msdyn_vendoraccountnumber
none	>>	customertypecode	3
PARTYTYPE	<<	none	Organization
PARTYNUMBER	=	msdyn_partyid.msdyn_partynumber
CONTACTPERSONID	=	msdyn_primarycontact.msdyn_contactforpartynumber
SALESTAXGROUP	=	msdyn_salestaxgroup.msdyn_name

Customers V3 (contacts)

This template synchronizes data between finance and operations apps and Dataverse.

Source filter: ((PartyType == "Person"))

Reversed source filter: msdyn_sellable eq true and msdyn_contactpersonid ne null

Finance and operations field	Map type	Customer engagement column	Default value
none	>>	msdyn_sellable	True
PARTYTYPE	<<	none	Person
PARTYNUMBER	=	msdyn_partyid.msdyn_partynumber
CUSTOMERACCOUNT	=	msdyn_contactpersonid
CUSTOMERGROUPID	=	msdyn_customergroupid.msdyn_groupid
IDENTIFICATIONNUMBER	=	msdyn_identificationnumber
PARTYCOUNTRY	=	msdyn_partycountry
PARTYSTATE	=	msdyn_partystateprovince
SALESCURRENCYCODE	=	transactioncurrencyid.isocurrencycode
SALESMEMO	=	description
PAYMENTDAY	=	msdyn_paymentday.msdyn_name
PAYMENTSCHEDULE	=	msdyn_paymentschedule.msdyn_name
PAYMENTMETHOD	=	msdyn_customerpaymentmethod.msdyn_name
SALESTAXGROUP	=	msdyn_salestaxgroup.msdyn_name
PAYMENTTERMS	=	msdyn_paymentterms.msdyn_name
CONTACTPERSONID	=	msdyn_primarycontact.msdyn_contactforpartynumber

Decision making roles (msdyn_decisionmakingroles)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
ROLEDESCRIPTION	=	msdyn_roledescription
ROLENAME	=	msdyn_rolename

Default order settings (msdyn_productdefaultordersettings)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
INVENTWAREHOUSEID	=	msdyn_inventorywarehouse.msdyn_warehouseidentifier
INVENTORYSITEID	=	msdyn_inventorysite.msdyn_siteid
INVENTORYATPDELAYEDDEMANDOFFSETDAYS	=	msdyn_inventoryatpdelayeddemandoffsetdays
INVENTORYATPDELAYEDSUPPLYOFFSETDAYS	=	msdyn_inventoryatpdelayedsupplyoffsetdays
ITEMNUMBER	=	msdyn_itemnumber.msdyn_itemnumber
INVENTORYATPBACKWARDDEMANDTIMEFENCEDAYS	=	msdyn_inventoryatpbackwarddemandtimefencedays
INVENTORYATPBACKWARDSUPPLYTIMEFENCEDAYS	=	msdyn_inventoryatpbackwardsupplytimefencedays
INVENTORYATPTIMEFENCEDAYS	=	msdyn_inventoryatptimefencedays
MAXIMUMINVENTORYORDERQUANTITY	=	msdyn_maximuminventoryorderquantity
MAXIMUMPROCUREMENTORDERQUANTITY	=	msdyn_maximumprocurementorderquantity
MAXIMUMSALESORDERQUANTITY	=	msdyn_maximumsalesorderquantity
MINIMUMINVENTORYORDERQUANTITY	=	msdyn_minimuminventoryorderquantity
MINIMUMPROCUREMENTORDERQUANTITY	=	msdyn_minimumprocurementorderquantity
MINIMUMSALESORDERQUANTITY	=	msdyn_minimumsalesorderquantity
STANDARDINVENTORYORDERQUANTITY	=	msdyn_standardinventoryorderquantity
STANDARDPROCUREMENTORDERQUANTITY	=	msdyn_standardprocurementorderquantity
STANDARDSALESORDERQUANTITY	=	msdyn_standardsalesorderquantity
INVENTORYLEADTIMEDAYS	=	msdyn_inventoryleadtimedays
INVENTORYQUANTITYMULTIPLES	=	msdyn_inventoryquantitymultiples
PROCUREMENTQUANTITYMULTIPLES	=	msdyn_procurementquantitymultiples
SALESQUANTITYMULTIPLES	=	msdyn_salesquantitymultiples
PROCUREMENTSITEID	=	msdyn_procurementsite.msdyn_siteid
PROCUREMENTLEADTIMEDAYS	=	msdyn_procurementleadtimedays
SALESSITEID	=	msdyn_salessite.msdyn_siteid
SALESATPDELAYEDDEMANDOFFSETDAYS	=	msdyn_salesatpdelayeddemandoffsetdays
SALESATPDELAYEDSUPPLYOFFSETDAYS	=	msdyn_salesatpdelayedsupplyoffsetdays
SALESATPBACKWARDDEMANDTIMEFENCEDAYS	=	msdyn_salesatpbackwarddemandtimefencedays
SALESATPBACKWARDSUPPLYTIMEFENCEDAYS	=	msdyn_salesatpbackwardsupplytimefencedays
SALESATPTIMEFENCEDAYS	=	msdyn_salesatptimefencedays
SALESLEADTIMEDAYS	=	msdyn_salesleadtimedays
PROCUREMENTWAREHOUSEID	=	msdyn_procurementwarehouse.msdyn_warehouseidentifier
SALESWAREHOUSEID	=	msdyn_saleswarehouse.msdyn_warehouseidentifier
AREINVENTORYORDERPROMISINGDEFAULTSOVERRIDDEN	>< no : False yes : True	msdyn_areinventoryorderdefaultsoverridden
INVENTORYORDERPROMISINGMETHOD	>< none : 192350000 salesLeadTime : 192350001 atp : 192350002 atpPlusIssueMargin : 192350003 ctp : 192350004	msdyn_inventoryorderpromisingmethod
ISINVENTORYATPINCLUDINGPLANNEDORDERS	>< false : False true : True	msdyn_isinventoryatpincludingplannedorders
ISINVENTORYUSINGWORKINGDAYS	>< no : False yes : True	msdyn_isinventoryusingworkingdays
ISINVENTORYSITEMANDATORY	>< no : False yes : True	msdyn_isinventorysitemandatory
ISINVENTORYPROCESSINGSTOPPED	>< no : False yes : True	msdyn_isinventoryprocessingstopped
ISPROCUREMENTUSINGWORKINGDAYS	>< no : False yes : True	msdyn_isprocurementusingworkingdays
ISPROCUREMENTSITEMANDATORY	>< no : False yes : True	msdyn_isprocurementsitemandatory
ISPROCUREMENTPROCESSINGSTOPPED	>< no : False yes : True	msdyn_isprocurementprocessingstopped
ARESALESORDERPROMISINGDEFAULTSOVERRIDDEN	>< no : False yes : True	msdyn_aresalesorderdefaultsoverridden
SALESORDERPROMISINGMETHOD	>< none : 192350000 salesLeadTime : 192350001 atp : 192350002 atpPlusIssueMargin : 192350003 ctp : 192350004	msdyn_salesorderpromisingmethod
ISSALESATPINCLUDINGPLANNEDORDERS	>< false : False true : True	msdyn_issalesatpincludingplannedorders
ISSALESSITEMANDATORY	>< no : False yes : True	msdyn_issalessitemandatory
ISSALESLEADTIMEOVERRIDDEN	>< no : False yes : True	msdyn_issalesleadtimeoverridden
ISSALESPROCESSINGSTOPPED	>< no : False yes : True	msdyn_issalesprocessingstopped
ISINVENTORYWAREHOUSEMANDATORY	>< no : False yes : True	msdyn_isinventorywarehousemandatory
ISPROCUREMENTWAREHOUSEMANDATORY	>< no : False yes : True	msdyn_isprocurementwarehousemandatory
ISSALESWAREHOUSEMANDATORY	>< no : False yes : True	msdyn_issaleswarehousemandatory

DV released distinct products (products)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PRODUCTNUMBER	>	msdyn_productnumber
PRODUCTNAME	>	name
PRODUCTDESCRIPTION	>	description
ITEMNUMBER	>	msdyn_itemnumber
PRODUCTTYPE	>> item : 1 service : 3	producttypecode
PRODUCTCOLORID	>	msdyn_productcolor.msdyn_productcolorname
PRODUCTCONFIGURATIONID	>	msdyn_productconfiguration.msdyn_productconfiguration
PRODUCTSIZEID	>	msdyn_productsize.msdyn_productsize
PRODUCTSTYLEID	>	msdyn_productstyle.msdyn_productstyle
ITEMNUMBER	>	msdyn_sharedproductdetailid.msdyn_itemnumber
[None]	>>	msdyn_shouldsyncwithsharedproductdetails	True

DV released products (msdyn_sharedproductdetails)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PRODUCTNUMBER	>	msdyn_globalproduct.msdyn_productnumber
INTRASTATCHARGEPERCENTAGE	>	msdyn_intrastatchargepercentage
ITEMNUMBER	>	msdyn_itemnumber
APPROXIMATESALESTAXPERCENTAGE	>	msdyn_approximatesalestaxpercentage
BESTBEFOREPERIODDAYS	>	msdyn_bestbeforeperioddays
CARRYINGCOSTABCCODE	>> none : 806380000 a : 806380001 b : 806380002 c : 806380003	msdyn_carryingcostabccode
CONSTANTSCRAPQUANTITY	>	msdyn_constantscrapquantity
COSTCHARGESQUANTITY	>	msdyn_costchargesquantity
DEFAULTRECEIVINGQUANTITY	>	msdyn_defaultreceivingquantity
FIXEDPURCHASEPRICECHARGES	>	msdyn_fixedpurchasepricecharges
FIXEDSALESPRICECHARGES	>	msdyn_fixedsalespricecharges
GROSSDEPTH	>	msdyn_grossdepth
GROSSPRODUCTHEIGHT	>	msdyn_grossproductheight
GROSSPRODUCTWIDTH	>	msdyn_grossproductwidth
INVENTORYUNITSYMBOL	>	msdyn_inventoryunitsymbol.msdyn_symbol
ISDISCOUNTPOSREGISTRATIONPROHIBITED	>> no : False yes : True	msdyn_isdiscountposregistrationprohibited
ISEXEMPTFROMAUTOMATICNOTIFICATIONANDCANCELLATION	>> no : False yes : True	msdyn_exemptautomaticnotificationcancel
ISINSTALLMENTELIGIBLE	>> no : False yes : True	msdyn_isinstallmenteligible
ISINTERCOMPANYPURCHASEUSAGEBLOCKED	>> no : False yes : True	msdyn_isintercompanypurchaseusageblocked
ISINTERCOMPANYSALESUSAGEBLOCKED	>> no : False yes : True	msdyn_isintercompanysalesusageblocked
ISMANUALDISCOUNTPOSREGISTRATIONPROHIBITED	>> no : False yes : True	msdyn_ismanualdiscposregistrationprohibited
ISPHANTOM	>> no : False yes : True	msdyn_isphantom
ISPOSREGISTRATIONBLOCKED	>> no : False yes : True	msdyn_isposregistrationblocked
ISPOSREGISTRATIONQUANTITYNEGATIVE	>> no : False yes : True	msdyn_isposregistrationquantitynegative
ISPURCHASEPRICEAUTOMATICALLYUPDATED	>> no : False yes : True	msdyn_ispurchasepriceautomaticallyupdated
ISPURCHASEPRICEINCLUDINGCHARGES	>> no : False yes : True	msdyn_ispurchasepriceincludingcharges
ISSALESWITHHOLDINGTAXCALCULATED	>> no : False yes : True	msdyn_issaleswithholdingtaxcalculated
ISRESTRICTEDFORCOUPONS	>> no : False yes : True	msdyn_isrestrictedforcoupons
ISSALESPRICEADJUSTMENTALLOWED	>> no : False yes : True	msdyn_issalespriceadjustmentallowed
ISSALESPRICEINCLUDINGCHARGES	>> no : False yes : True	msdyn_issalespriceincludingcharges
ISSCALEPRODUCT	>> no : False yes : True	msdyn_isscaleproduct
ISSHIPALONEENABLED	>> no : False yes : True	msdyn_isshipaloneenabled
ISUNITCOSTPRODUCTVARIANTSPECIFIC	>> no : False yes : True	msdyn_isunitcostproductvariantspecific
ISVARIANTSHELFLABELSPRINTINGENABLED	>> no : False yes : True	msdyn_isvariantshelflabelsprintingenabled
ISZEROPRICEPOSREGISTRATIONALLOWED	>> no : False yes : True	msdyn_iszeropriceposregistrationallowed
KEYINPRICEREQUIREMENTSATPOSREGISTER	>> notMandatory : 806380000 newPrice : 806380001 higherEqual : 806380002 lowerEqual : 806380003 noPrice : 806380004	msdyn_keyinpricerequirementsatposregister
KEYINQUANTITYREQUIREMENTSATPOSREGISTER	>> notMandatory : 806380000 keyIn : 806380001 notKeyIn : 806380002	msdyn_keyinquantityrequirementsatposregister
MARGINABCCODE	>> none : 806380000 a : 806380001 b : 806380002 c : 806380003	msdyn_marginabccode
MAXIMUMPICKQUANTITY	>	msdyn_maximumpickquantity
MUSTKEYINCOMMENTATPOSREGISTER	>> no : False yes : True	msdyn_mustkeyincommentatposregister
NECESSARYPRODUCTIONWORKINGTIMESCHEDULINGPROPERTYID	>	msdyn_necessaryproductionworkingtimeschedulingp
NETPRODUCTWEIGHT	>	msdyn_netproductweight
PACKINGDUTYQUANTITY	>	msdyn_packingdutyquantity
POSREGISTRATIONACTIVATIONDATE	>	msdyn_posregistrationactivationdate
POSREGISTRATIONBLOCKEDDATE	>	msdyn_posregistrationblockeddate
POSREGISTRATIONPLANNEDBLOCKEDDATE	>	msdyn_posregistrationplannedblockeddate
POTENCYBASEATTIBUTETARGETVALUE	>	msdyn_potencybaseattibutetargetvalue
POTENCYBASEATTRIBUTEVALUEENTRYEVENT	>> purchProdReceipt : 806380000 quality : 806380001	msdyn_potencybaseattributevalueentryevent
PRODUCTTYPE	>> item : 806380001 service : 806380002	msdyn_producttype
PRODUCTIONCONSUMPTIONDENSITYCONVERSIONFACTOR	>	msdyn_productionconsumptiondensityconversion
PRODUCTIONCONSUMPTIONDEPTHCONVERSIONFACTOR	>	msdyn_productionconsumptiondepthconversion
PRODUCTIONCONSUMPTIONHEIGHTCONVERSIONFACTOR	>	msdyn_productionconsumptionheightconversion
PRODUCTIONCONSUMPTIONWIDTHCONVERSIONFACTOR	>	msdyn_productionconsumptionwidthconversion
PRODUCTVOLUME	>	msdyn_productvolume
PURCHASECHARGESQUANTITY	>	msdyn_purchasechargesquantity
PURCHASEOVERDELIVERYPERCENTAGE	>	msdyn_purchaseoverdeliverypercentage
PURCHASEPRICE	>	msdyn_purchaseprice
PURCHASEPRICEDATE	>	msdyn_purchasepricedate
PURCHASEPRICINGPRECISION	>	msdyn_purchasepricingprecision
PURCHASEUNDERDELIVERYPERCENTAGE	>	msdyn_purchaseunderdeliverypercentage
RAWMATERIALPICKINGPRINCIPLE	>> staging : 806380000 orderPicking : 806380001	msdyn_rawmaterialpickingprinciple
SALESCHARGESQUANTITY	>	msdyn_saleschargesquantity
SALESOVERDELIVERYPERCENTAGE	>	msdyn_salesoverdeliverypercentage
SALESPRICE	>	msdyn_salesprice
SALESPRICECALCULATIONCHARGESPERCENTAGE	>	msdyn_salespricecalculationchargespercentage
SALESPRICECALCULATIONCONTRIBUTIONRATIO	>	msdyn_salespricecalculationcontributionratio
SALESPRICECALCULATIONMODEL	>> none : 806380000 contributionratio : 806380001 percentMarkup : 806380002	msdyn_salespricecalculationmodel
SALESPRICEDATE	>	msdyn_salespricedate
SALESPRICINGPRECISION	>	msdyn_salespricingprecision
SALESUNDERDELIVERYPERCENTAGE	>	msdyn_salesunderdeliverypercentage
SALESUNITSYMBOL	>	msdyn_salesunitsymbol.msdyn_symbol
SCALEINDICATOR	>> relevant : 806380000 notRelevant : 806380001	msdyn_scaleindicator
SELLSTARTDATE	>	msdyn_sellstartdate
SHELFADVICEPERIODDAYS	>	msdyn_shelfadviceperioddays
SHELFLIFEPERIODDAYS	>	msdyn_shelflifeperioddays
SHIPSTARTDATE	>	msdyn_shipstartdate
TAREPRODUCTWEIGHT	>	msdyn_tareproductweight
TRANSFERORDEROVERDELIVERYPERCENTAGE	>	msdyn_transferorderoverdeliverypercentage
TRANSFERORDERUNDERDELIVERYPERCENTAGE	>	msdyn_transferorderunderdeliverypercentage
UNITCOST	>	msdyn_unitcost
UNITCOSTDATE	>	msdyn_unitcostdate
UNITCOSTQUANTITY	>	msdyn_unitcostquantity
VARIABLESCRAPPERCENTAGE	>	msdyn_variablescrappercentage
WAREHOUSEMOBILEDEVICEDESCRIPTIONLINE1	>	msdyn_warehousemobiledevicedescriptionline1
WAREHOUSEMOBILEDEVICEDESCRIPTIONLINE2	>	msdyn_warehousemobiledevicedescriptionline2
WILLINVENTORYISSUEAUTOMATICALLYREPORTASFINISHED	>> no : False yes : True	msdyn_willinventoryissueautoreportasfinished
WILLINVENTORYRECEIPTIGNOREFLUSHINGPRINCIPLE	>> no : False yes : True	msdyn_willinventoryreceiptignoreflushing
WILLPICKINGWORKBENCHAPPLYBOXINGLOGIC	>> no : False yes : True	msdyn_willpickingworkbenchapplyboxinglogic
WILLTOTALPURCHASEDISCOUNTCALCULATIONINCLUDEPRODUCT	>> no : False yes : True	msdyn_willtotalpurchdiscountcalcincludeproduct
WILLTOTALSALESDISCOUNTCALCULATIONINCLUDEPRODUCT	>> no : False yes : True	msdyn_willtotalsalesdiscountcalcincludeproduct
WILLWORKCENTERPICKINGALLOWNEGATIVEINVENTORY	>> no : False yes : True	msdyn_willworkcenterpickingallownegativeinvent
YIELDPERCENTAGE	>	msdyn_yieldpercentage
ISUNITCOSTAUTOMATICALLYUPDATED	>> no : False yes : True	msdyn_isunitcostautomaticallyupdated
PURCHASEUNITSYMBOL	>	msdyn_purchaseunitsymbol.msdyn_symbol
PURCHASEPRICEQUANTITY	>	msdyn_purchasepricequantity
ISUNITCOSTINCLUDINGCHARGES	>> no : False yes : True	msdyn_isunitcostincludingcharges
FIXEDCOSTCHARGES	>	msdyn_fixedcostcharges
MINIMUMCATCHWEIGHTQUANTITY	>	msdyn_minimumcatchweightquantity
MAXIMUMCATCHWEIGHTQUANTITY	>	msdyn_maximumcatchweightquantity
ALTERNATIVEITEMNUMBER	>	msdyn_alternativeitemnumber.msdyn_itemnumber
BOMUNITSYMBOL	>	msdyn_bomunitsymbol.msdyn_symbol
CATCHWEIGHTUNITSYMBOL	>	msdyn_catchweightunitsymbol.msdyn_symbol
COMPARISONPRICEBASEUNITSYMBOL	>	msdyn_comparisonpricebaseunitsymbol.msdyn_symbol
PRIMARYVENDORACCOUNTNUMBER	>	msdyn_vendorid.msdyn_vendoraccountnumber
ISCATCHWEIGHTPRODUCT	>> no : False yes : True	msdyn_iscatchweight
PRODUCTDIMENSIONGROUPNAME	>	msdyn_productdimensiongroupid.msdyn_groupname
STORAGEDIMENSIONGROUPNAME	>	msdyn_storagedimensiongroup.msdyn_groupname
TRACKINGDIMENSIONGROUPNAME	>	msdyn_trackingdimensiongroup.msdyn_groupname
PRODUCTNAME	>	msdyn_productname
PRODUCTDESCRIPTION	>	msdyn_productdescription
ISSTOCKEDPRODUCT	>> no : False yes : True	msdyn_isstockedproduct
FIELDSERVICEPRODUCTTYPE	>> Inventory : 690970000 NonInventory : 690970001 Service : 690970002	msdyn_fieldserviceproducttype
CURRENCYCODE	>	msdyn_transactioncurrencyid.isocurrencycode
[None]	>>	msdyn_shouldsyncwithproducts	True

Dynamics 365 Sales feature management states (msdyn_supplychainfeaturestates)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
NAME	=	msdyn_name
ISENABLED	>< no : 1 yes : 0	statecode

Dynamics 365 Sales order headers (salesorders)

This template synchronizes data between finance and operations apps and Dataverse.

Reversed source filter: msdyn_ordertype eq 192350000 and msdyn_isreadytosync eq true

Finance and operations field	Map type	Customer engagement column	Default value
SALESORDERNUMBER	=	msdyn_salesordernumber
ORDERINGCUSTOMERACCOUNTNUMBER	=	customerid.Account(accountnumber).Contact(msdyn_contactpersonid)
CURRENCYCODE	=	transactioncurrencyid.isocurrencycode
DELIVERYADDRESSCITY	=	shipto_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE	>< us : united states de : germany fr : france gb : united kingdom jp : japan in : india es : spain nz : new zealand au : australia co : columbia za : south africa be : belgium ca : canada at : austria tr : turkey cn : china dk : denmark se : sweden no : norway fi : finland eg : egypt	shipto_country
DELIVERYADDRESSSTREETNUMBER	=	shipto_line2
DELIVERYADDRESSZIPCODE	=	shipto_postalcode
DELIVERYADDRESSSTREET	=	shipto_line1
DELIVERYADDRESSSTATEID	=	shipto_stateorprovince
SALESORDERNAME	>	name
INVOICEADDRESSCITY	>	billto_city
INVOICEADDRESSSTREET	>	billto_line1
INVOICEADDRESSSTREETNUMBER	>	billto_line2
INVOICEADDRESSCOUNTRYREGIONISOCODE	>	billto_country
INVOICEADDRESSSTATEID	>	billto_stateorprovince
INVOICEADDRESSZIPCODE	>	billto_postalcode
ORDERTOTALAMOUNT	>	totalamount
TOTALDISCOUNTAMOUNT	>	discountamount
ORDERTOTALTAXAMOUNT	>	totaltax
ORDERTOTALCHARGESAMOUNT	>	freightamount
AREPRICESINCLUDINGSALESTAX	>< no : False yes : True	msdyn_arepricesincludingsalestax
CONFIRMEDRECEIPTDATE	=	msdyn_confirmedreceiptdate
CONFIRMEDSHIPPINGDATE	=	msdyn_confirmedshippingdate
CONTACTPERSONID	=	msdyn_contactperson.msdyn_contactpersonid
CUSTOMERREQUISITIONNUMBER	=	msdyn_customerrequisitionnumber
DEFAULTSHIPPINGSITEID	=	msdyn_defaultshippingsite.msdyn_siteid
DEFAULTSHIPPINGWAREHOUSEID	=	msdyn_defaultshippingwarehouse.msdyn_warehouseidentifier
DELIVERYADDRESSCOUNTYID	=	msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION	=	msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME	=	msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER	=	msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLATITUDE	=	msdyn_deliveryaddresslatitude
DELIVERYADDRESSLOCATIONID	=	msdyn_deliveryaddresslocationid
DELIVERYADDRESSLONGITUDE	=	msdyn_deliveryaddresslongitude
DELIVERYADDRESSNAME	=	msdyn_deliveryaddressname
DELIVERYADDRESSPOSTBOX	=	msdyn_deliveryaddresspostbox
DELIVERYBUILDINGCOMPLIMENT	=	msdyn_deliverybuildingcompliment
FORMATTEDDELVERYADDRESS	>	msdyn_formatteddeliveryaddress
EMAIL	=	emailaddress
FORMATTEDINVOICEADDRESS	>	msdyn_formattedinvoiceaddress
INVOICEADDRESSCOUNTYID	>	msdyn_invoiceaddresscountyid
INVOICEADDRESSDISTRICTNAME	>	msdyn_invoiceaddressdistrictname
INVOICEADDRESSLATITUDE	>	msdyn_invoiceaddresslatitude
INVOICEADDRESSLONGITUDE	>	msdyn_invoiceaddresslongitude
INVOICEADDRESSPOSTBOX	>	msdyn_invoiceaddresspostbox
INVOICEBUILDINGCOMPLIMENT	>	msdyn_invoicebuildingcompliment
INVOICECUSTOMERACCOUNTNUMBER	=	msdyn_invoicecustomerid.Account(accountnumber).Contact(msdyn_contactpersonid)
ISDELIVERYADDRESSORDERSPECIFIC	>< no : False yes : True	msdyn_isdeliveryaddressorderspecific
ISDELIVERYADDRESSPRIVATE	>< no : False yes : True	msdyn_isdeliveryaddressprivate
ISINVOICEADDRESSPRIVATE	>> no : False yes : True	msdyn_isinvoiceaddressprivate
ISONETIMECUSTOMER	>< no : False yes : True	msdyn_isonetimecustomer
ISSALESPROCESSINGSTOPPED	>< no : False yes : True	msdyn_issalesprocessingstopped
PAYMENTTERMSBASEDATE	=	msdyn_paymenttermsbasedate
PAYMENTTERMSNAME	=	msdyn_paymentterms.msdyn_name
PRICECUSTOMERGROUPCODE	=	msdyn_pricecustomergroup.msdyn_groupcode
QUOTATIONNUMBER	=	msdyn_quotationnumber
REQUESTEDRECEIPTDATE	=	msdyn_requestedreceiptdate
REQUESTEDSHIPPINGDATE	=	requestdeliveryby
SALESORDERPROMISINGMETHOD	>< none : 192350000 salesLeadTime : 192350001 atp : 192350002 atpPlusIssueMargin : 192350003 ctp : 192350004	msdyn_salesorderpromisingmethod
URL	=	msdyn_url
SALESORDERPROCESSINGSTATUS	>< active : 192350000 confirmed : 192350001 picked : 192350002 partiallyDelivered : 192350003 delivered : 192350004 invoiced : 192350005 partiallyInvoiced : 192350006 canceled : 192350007 deliveredPartiallyInvoiced : 192350008	msdyn_processingstatus
LANGUAGEID	>< ar : 192350000 ar-ae : 192350001 cs : 192350002 da : 192350003 de : 192350004 de-at : 192350005 de-ch : 192350006 en-au : 192350007 en-gb : 192350009 en-ie : 192350010 en-in : 192350011 en-ca : 192350008 en-my : 192350012 en-nz : 192350013 en-sg : 192350014 en-us : 192350015 en-za : 192350016 es : 192350017 es-mx : 192350018 et : 192350019 fi : 192350020 fr : 192350021 fr-be : 192350022 fr-ca : 192350023 fr-ch : 192350024 hu : 192350025 is : 192350026 it : 192350027 it-ch : 192350028 ja : 192350029 lt : 192350030 lv : 192350031 nb-no : 192350032 nl : 192350033 nl-be : 192350034 pl : 192350035 pt-br : 192350036 ru : 192350037 sv : 192350038 th : 192350039 tr : 192350040 zh-hans : 192350041	msdyn_language
CUSTOMERSORDERREFERENCE	=	msdyn_customersorderreference
DELIVERYMODECODE	=	msdyn_deliverymode.msdyn_name
DELIVERYTERMSCODE	=	msdyn_deliveryterms.msdyn_termscode
SALESORDERORIGINCODE	=	msdyn_salesorderorigin.msdyn_origincode
none	>>	msdyn_ordertype	192350000
CURRENCYCODE	>	msdyn_isocurrencycode

Dynamics 365 Sales order lines (salesorderdetails)

This template synchronizes data between finance and operations apps and Dataverse.

Reversed source filter:

• Version 1.x.x.x: msdyn_isreadytosync eq true
  (to be used in the context of Supply Chain solution without Project Operations or Field Services solution installed.)
• Version 2.x.x.x: (msdyn_linetype ne 690970000 or msdyn_linetype eq null) and msdyn_isreadytosync eq true
  (to be used in the context of Supply Chain solution and Project Operations or Field Services solution installed.)

Finance and operations field	Map type	Customer engagement column	Default value
CURRENCYCODE	>	transactioncurrencyid.isocurrencycode
DELIVERYADDRESSCITY	=	shipto_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE	>< us : united states de : germany fr : france gb : united kingdom jp : japan in : india es : spain nz : new zealand au : australia co : columbia za : south africa be : belgium ca : canada at : austria tr : turkey cn : china dk : denmark se : sweden no : norway fi : finland eg : egypt	shipto_country
DELIVERYADDRESSZIPCODE	=	shipto_postalcode
DELIVERYADDRESSSTATEID	=	shipto_stateorprovince
DELIVERYADDRESSSTREET	=	shipto_line1
DELIVERYADDRESSSTREETNUMBER	=	shipto_line2
LINEAMOUNT	>	extendedamount
LINECREATIONSEQUENCENUMBER	=	sequencenumber
ORDEREDSALESQUANTITY	=	quantity
PRODUCTNAME	=	description
PRODUCTNUMBER	=	productid.msdyn_productnumber
SALESORDERNUMBER	=	salesorderid.msdyn_salesordernumber
SALESUNITSYMBOL	=	uomid.msdyn_symbol
TOTALDISCOUNTAMOUNT	=	manualdiscountamount
TOTALTAXAMOUNT	>	tax
SALESPRICE	=	priceperunit
LINEAMOUNT	>	baseamount
SALESPRODUCTCATEGORYNAME	=	msdyn_salesproductcategory.msdyn_name
SALESPRODUCTCATEGORYHIERARCHYNAME	>	msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name
ISDELIVERYADDRESSORDERSPECIFIC	>< no : False yes : True	msdyn_isdeliveryaddressspecific
ISDELIVERYADDRESSPRIVATE	>< no : False yes : True	msdyn_isdeliveryaddressprivate
ISLINESTOPPED	>< no : False yes : True	msdyn_islinestopped
ALLOWEDOVERDELIVERYPERCENTAGE	=	msdyn_allowedoverdeliverypercentage
ALLOWEDUNDERDELIVERYPERCENTAGE	=	msdyn_allowedunderdeliverypercentage
CONFIRMEDSHIPPINGDATE	=	msdyn_confirmedshippingdate
CONFIRMEDRECEIPTDATE	=	msdyn_confirmedreceiptdate
DELIVERYADDRESSCOUNTYID	=	msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION	=	msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME	=	msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER	=	msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLATITUDE	=	msdyn_deliveryaddresslatitude
DELIVERYADDRESSLOCATIONID	=	msdyn_deliveryaddresslocationid
DELIVERYADDRESSLONGITUDE	=	msdyn_deliveryaddresslongitude
DELIVERYADDRESSNAME	=	msdyn_deliveryaddressname
DELIVERYADDRESSPOSTBOX	=	msdyn_deliveryaddresspostbox
DELIVERYBUILDINGCOMPLIMENT	=	msdyn_deliverybuildingcompliment
EXTERNALITEMNUMBER	=	msdyn_externalitemnumber
FIXEDPRICECHARGES	=	msdyn_fixedpricecharges
FORMATTEDDELIVERYADDRESS	=	msdyn_formatteddeliveryaddress
LINEDESCRIPTION	=	msdyn_linedescription
LINEDISCOUNTAMOUNT	=	msdyn_linediscountamount
LINEDISCOUNTPERCENTAGE	=	msdyn_linediscountpercentage
MULTILINEDISCOUNTAMOUNT	=	msdyn_multilinediscountamount
MULTILINEDISCOUNTPERCENTAGE	=	msdyn_multilinediscountpercentage
REQUESTEDRECEIPTDATE	=	msdyn_requestedreceiptdate
REQUESTEDSHIPPINGDATE	=	requestdeliveryby
SALESORDERLINESTATUS	>> none : 192350000 backorder : 192350001 delivered : 192350002 invoiced : 192350003 canceled : 192350004	msdyn_linestatus
SALESORDERPROMISINGMETHOD	>< none : 192350000 salesLeadTime : 192350001 atp : 192350002 atpPlusIssueMargin : 192350003 ctp : 192350004	msdyn_salesorderpromisingmethod
SALESPRICEQUANTITY	=	msdyn_salespricequantity
SHIPPINGSITEID	=	msdyn_shippingsite.msdyn_siteid
SHIPPINGWAREHOUSEID	=	msdyn_shippingwarehouse.msdyn_warehouseidentifier
none	>>	ispriceoverridden	true
TOTALCHARGESAMOUNT	>	msdyn_totalchargesamount
DELIVERYMODECODE	=	msdyn_deliverymode.msdyn_name
DELIVERYTERMSID	=	msdyn_deliveryterms.msdyn_termscode
SALESDELIVERNOW	=	quantityshipped
INVENTORYSERVICERESERVATIONID	=	msdyn_reservationid

Dynamics 365 Sales quotation header (quotes)

This template synchronizes data between finance and operations apps and Dataverse.

Reversed source filter: msdyn_ordertype eq 192350000

Finance and operations field	Map type	Customer engagement column	Default value
SALESQUOTATIONNUMBER	=	msdyn_quotenumber
REQUESTINGCUSTOMERACCOUNTNUMBER	=	customerid.Account(accountnumber).Contact(msdyn_contactpersonid)
CURRENCYCODE	=	transactioncurrencyid.isocurrencycode
CUSTOMERSREFERENCE	=	msdyn_customersreference
DELIVERYADDRESSCITY	=	shipto_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE	>< us : united states de : germany fr : france gb : united kingdom jp : japan in : india es : spain nz : new zealand au : australia co : columbia za : south africa be : belgium ca : canada at : austria tr : turkey cn : china dk : denmark se : sweden no : norway fi : finland eg : egypt	shipto_country
DELIVERYADDRESSSTREETNUMBER	=	shipto_line2
DELIVERYADDRESSZIPCODE	=	shipto_postalcode
DELIVERYADDRESSSTREET	=	shipto_line1
DELIVERYADDRESSSTATEID	=	shipto_stateorprovince
SALESQUOTATIONNAME	=	name
INVOICEADDRESSCITY	>	billto_city
INVOICEADDRESSSTREET	>	billto_line1
INVOICEADDRESSSTREETNUMBER	>	billto_line2
INVOICEADDRESSCOUNTRYREGIONISOCODE	>	billto_country
INVOICEADDRESSSTATEID	>	billto_stateorprovince
INVOICEADDRESSZIPCODE	>	billto_postalcode
QUOTATIONTOTALAMOUNT	>	totalamount
TOTALDISCOUNTAMOUNT	>	discountamount
QUOTATIONTOTALTAXAMOUNT	>	totaltax
QUOTATIONTOTALCHARGESAMOUNT	>	freightamount
AREPRICESINCLUDINGSALESTAX	>< no : False yes : True	msdyn_arepricesincludingsalestax
CONTACTPERSONID	=	msdyn_contactperson.msdyn_contactpersonid
CUSTOMERREQUISITIONNUMBER	=	msdyn_customerrequisitionnumber
DEFAULTSHIPPINGSITEID	=	msdyn_defaultshippingsite.msdyn_siteid
DEFAULTSHIPPINGWAREHOUSEID	=	msdyn_defaultshippingwarehouse.msdyn_warehouseidentifier
DELIVERYADDRESSCOUNTYID	=	msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION	=	msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME	=	msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER	=	msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLATITUDE	=	msdyn_deliveryaddresslatitude
DELIVERYADDRESSLOCATIONID	=	msdyn_deliveryaddresslocationid
DELIVERYADDRESSLONGITUDE	=	msdyn_deliveryaddresslongitude
DELIVERYADDRESSNAME	=	msdyn_deliveryaddressname
DELIVERYADDRESSPOSTBOX	=	msdyn_deliveryaddresspostbox
DELIVERYBUILDINGCOMPLIMENT	=	msdyn_deliverybuildingcompliment
FORMATTEDDELIVERYADDRESS	>	msdyn_formatteddeliveryaddress
FORMATTEDINVOICEADDRESS	>	msdyn_formattedinvoiceaddress
GENERATEDSALESORDERNUMBER	=	msdyn_generatedsalesordernumber.msdyn_salesordernumber
INVOICEADDRESSCOUNTRYREGIONID	>	msdyn_invoiceaddresscountryregionid
INVOICEADDRESSCOUNTYID	>	msdyn_invoiceaddresscountyid
INVOICEADDRESSDISTRICTNAME	>	msdyn_invoiceaddressdistrictname
INVOICEADDRESSLATITUDE	>	msdyn_invoiceaddresslatitude
INVOICEADDRESSLONGITUDE	>	msdyn_invoiceaddresslongitude
INVOICEADDRESSPOSTBOX	>	msdyn_invoiceaddresspostbox
INVOICEBUILDINGCOMPLIMENT	>	msdyn_invoicebuildingcompliment
INVOICECUSTOMERACCOUNTNUMBER	=	msdyn_invoicecustomerid.Account(accountnumber).Contact(msdyn_contactpersonid)
ISDELIVERYADDRESSORDERSPECIFIC	>< no : False yes : True	msdyn_isdeliveryaddressorderspecific
ISDELIVERYADDRESSPRIVATE	>< no : False yes : True	msdyn_isdeliveryaddressprivate
ISINVOICEADDRESSPRIVATE	>> no : False yes : True	msdyn_isinvoiceaddressprivate
LANGUAGEID	>< ar : 192350000 ar-ae : 192350001 cs : 192350002 da : 192350003 de : 192350004 de-at : 192350005 de-ch : 192350006 en-au : 192350007 en-gb : 192350009 en-ie : 192350010 en-in : 192350011 en-ca : 192350008 en-my : 192350012 en-nz : 192350013 en-sg : 192350014 en-us : 192350015 en-za : 192350016 es : 192350017 es-mx : 192350018 et : 192350019 fi : 192350020 fr : 192350021 fr-be : 192350022 fr-ca : 192350023 fr-ch : 192350024 hu : 192350025 is : 192350026 it : 192350027 it-ch : 192350028 ja : 192350029 lt : 192350030 lv : 192350031 nb-no : 192350032 nl : 192350033 nl-be : 192350034 pl : 192350035 pt-br : 192350036 ru : 192350037 sv : 192350038 th : 192350039 tr : 192350040 zh-hans : 192350041	msdyn_language
PAYMENTTERMSNAME	=	msdyn_paymentterms.msdyn_name
PRICECUSTOMERGROUPCODE	=	msdyn_pricecustomergroup.msdyn_groupcode
RECEIPTDATEREQUESTED	=	msdyn_requestedreceiptdate
REQUESTEDSHIPPINGDATE	=	requestdeliveryby
SALESORDERPROMISINGMETHOD	>< none : 192350000 salesLeadTime : 192350001 atp : 192350002 atpPlusIssueMargin : 192350003 ctp : 192350004	msdyn_salesorderpromisingmethod
SALESQUOTATIONCONFIRMATIONDATE	=	msdyn_salesquotationconfirmationdate
SALESQUOTATIONEXPIRYDATE	=	msdyn_salesquotationexpirydate
SALESQUOTATIONFOLLOWUPDATE	=	msdyn_salesquotationfollowupdate
SALESQUOTATIONSTATUS	>< created : 192350000 sent : 192350001 confirmed : 192350002 lost : 192350003 cancelled : 192350004 reset : 192350005 modified : 192350006 submitted : 192350007 approved : 192350008 revised : 192350009	msdyn_salesquotationstatus
TOTALDISCOUNTPERCENTAGE	=	msdyn_totaldiscountpercentage
URL	=	msdyn_url
EMAIL	=	emailaddress
none	>>	msdyn_ordertype	192350000
CURRENCYCODE	>	msdyn_isocurrencycode
OPERATINGUNITPARTYNUMBER	=	msdyn_operatingunit.msdyn_partynumber
SALESQUOTATIONHEADERCREATIONMETHOD	>> SCM : 776160000 Dynamics365Sales : 776160001	msdyn_quotationcreationmethod
SALESQUOTATIONOWNERSHIP	>> BasedOnOrigin : 776160000 SCM : 776160001 Dynamics365Sales : 776160002	msdyn_quotationownership

Dynamics 365 Sales quotation lines (quotedetails)

This template synchronizes data between finance and operations apps and Dataverse.

Reversed source filter:

• Version 1.x.x.x: None
  (to be used in the context of Supply Chain solution without Project Operations or Field Services solution installed.)
• Version 2.x.x.x: msdyn_linetype ne 690970000 or msdyn_linetype eq null
  (to be used in the context of Supply Chain solution and Project Operations or Field Services solution installed.)

Finance and operations field	Map type	Customer engagement column	Default value
ALLOWEDOVERDELIVERYPERCENTAGE	=	msdyn_allowedoverdeliverypercentage
ALLOWEDUNDERDELIVERYPERCENTAGE	=	msdyn_allowedunderdeliverypercentage
SALESQUOTATIONNUMBER	=	quoteid.msdyn_quotenumber
LINECREATIONSEQUENCENUMBER	=	sequencenumber
CURRENCYCODE	>	transactioncurrencyid.isocurrencycode
DELIVERYADDRESSCITY	=	shipto_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE	>< us : united states de : germany fr : france gb : united kingdom jp : japan in : india es : spain nz : new zealand au : australia co : columbia za : south africa be : belgium ca : canada at : austria tr : turkey cn : china dk : denmark se : sweden no : norway fi : finland eg : egypt	shipto_country
DELIVERYADDRESSCOUNTYID	=	msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION	=	msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME	=	msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER	=	msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLATITUDE	=	msdyn_deliveryaddresslatitude
DELIVERYADDRESSLOCATIONID	=	msdyn_deliveryaddresslocationid
DELIVERYADDRESSLONGITUDE	=	msdyn_deliveryaddresslongitude
DELIVERYADDRESSNAME	=	msdyn_deliveryaddressname
DELIVERYADDRESSPOSTBOX	=	msdyn_deliveryaddresspostbox
DELIVERYADDRESSSTATEID	=	shipto_stateorprovince
DELIVERYADDRESSSTREET	=	shipto_line1
DELIVERYADDRESSSTREETNUMBER	=	shipto_line2
DELIVERYADDRESSZIPCODE	=	shipto_postalcode
DELIVERYBUILDINGCOMPLIMENT	=	msdyn_deliverybuildingcompliment
EXTERNALITEMNUMBER	=	msdyn_externalitemnumber
FIXEDPRICECHARGES	=	msdyn_fixedpricecharges
FORMATTEDDELIVERYADDRESS	=	msdyn_formatteddeliveryaddress
ISDELIVERYADDRESSPRIVATE	>< no : False yes : True	msdyn_isdeliveryaddressprivate
ISDELIVERYADDRESSORDERSPECIFIC	>< no : False yes : True	msdyn_isdeliveryaddressspecific
LINEAMOUNT	>	baseamount
LINEAMOUNT	>	extendedamount
LINEDESCRIPTION	=	msdyn_linedescription2
LINEDISCOUNTAMOUNT	=	msdyn_linediscountamount
LINEDISCOUNTPERCENTAGE	=	msdyn_linediscountpercentage
MULTILINEDISCOUNTAMOUNT	=	msdyn_multilinediscountamount
MULTILINEDISCOUNTPERCENTAGE	=	msdyn_multilinediscountpercentage
PRODUCTNAME	=	description
PRODUCTNUMBER	=	productid.msdyn_productnumber
REQUESTEDRECEIPTDATE	=	msdyn_requestedreceiptdate
REQUESTEDSALESQUANTITY	=	quantity
REQUESTEDSHIPPINGDATE	=	requestdeliveryby
SALESPRICE	=	priceperunit
SALESPRICEQUANTITY	=	msdyn_salespricequantity
SALESQUOTATIONPROMISINGMETHOD	>< none : 192350000 salesLeadTime : 192350001 atp : 192350002 atpPlusIssueMargin : 192350003 ctp : 192350004	msdyn_salesquotationpromisingmethod
SALESQUOTATIONSTATUS	>< created : 192350000 sent : 192350001 confirmed : 192350002 lost : 192350003 cancelled : 192350004 reset : 192350005 modified : 192350006 submitted : 192350007 approved : 192350008 revised : 192350009	msdyn_salesquotationstatus
SALESUNITSYMBOL	=	uomid.msdyn_symbol
SHIPPINGSITEID	=	msdyn_shippingsite.msdyn_siteid
SHIPPINGWAREHOUSEID	=	msdyn_shippingwarehouse.msdyn_warehouseidentifier
TOTALCHARGESAMOUNT	>	msdyn_totalchargesamount
TOTALDISCOUNTAMOUNT	=	manualdiscountamount
TOTALTAXAMOUNT	>	tax
SALESPRODUCTCATEGORYHIERARCHYNAME	>	msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name
SALESPRODUCTCATEGORYNAME	=	msdyn_salesproductcategory.msdyn_name
none	>>	ispriceoverridden	true

Employment job functions (msdyn_employmentjobfunctions)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
FUNCTIONDESCRIPTION	=	msdyn_functiondescription
FUNCTIONNAME	=	msdyn_functionname

Employment per company (cdm_employments)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
EMPLOYMENTENDDATE	=	cdm_employmentenddate
PERSONNELNUMBER	=	cdm_workerid.cdm_workernumber
EMPLOYMENTSTARTDATE	=	cdm_employmentstartdate
WORKERTYPE	>> employee : 754400000 contractor : 754400001 both : 754400000	cdm_workertype

Ethnic origins (cdm_ethnicorigins)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
ETHNICORIGINID	=	cdm_name
DESCRIPTION	=	cdm_description

Exchange rate currency pair (msdyn_currencyexchangeratepairs)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
EXCHANGERATEDISPLAYFACTOR	>< one : 192350000 ten : 192350001 hundred : 192350002 thousand : 192350003 tenThousand : 192350004	msdyn_displayfactor
EXCHANGERATETYPENAME	=	msdyn_currencyexchangeratetypeid.msdyn_name
FROMCURRENCYCODE	=	msdyn_fromtransactioncurrencyid.isocurrencycode
TOCURRENCYCODE	=	msdyn_totransactioncurrencyid.isocurrencycode

Exchange rate type (msdyn_exchangeratetypes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
NAME	=	msdyn_name
DESCRIPTION	=	msdyn_description

Financial dimension format (msdyn_financialdimensionformats)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DIMENSIONFORMATNAME	=	msdyn_dimensionformatname
DIMENSIONFORMATTYPE	>< dataEntityDefaultDimensionFormat : 192350000 dataEntityLedgerDimensionFormat : 192350001 dataEntityBudgetDimensionFormat : 192350002 dataEntityBudgetPlanningDimensionFormat : 192350003	msdyn_dimensionformattype
FINANCIALDIMENSIONFORMAT	=	msdyn_financialdimensionformat
ISACTIVE	>< no : False yes : True	msdyn_isactive

Financial dimensions (msdyn_dimensionattributes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DIMENSIONNAME	=	msdyn_dimensionname
COPYVALUESONCREATE	>< no : False yes : True	msdyn_copyvaluesoncreate
REPORTCOLUMNNAME	=	msdyn_reportcolumnname
GIVEDERIVEDDIMENSIONSPRECEDENCE	>< no : False yes : True	msdyn_givederiveddimensionsprecedence
UseValuesFrom	=	msdyn_usevaluesfrom
DimensionValueMask	=	msdyn_dimensionvaluemask

Fiscal calendar integration entity (msdyn_fiscalcalendars)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
CALENDARID	=	msdyn_calendar
DESCRIPTION	=	msdyn_description

Fiscal calendar period (msdyn_fiscalcalendarperiods)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
COMMENTS	=	msdyn_comments
ENDDATE	=	msdyn_enddate
MONTH	>< month1 : 192350000 month2 : 192350001 month3 : 192350002 month4 : 192350003 month5 : 192350004 month6 : 192350005 month7 : 192350006 month8 : 192350007 month9 : 192350008 month10 : 192350009 month11 : 192350010 month12 : 192350011	msdyn_month
CALENDAR	=	msdyn_fiscalcalendar.msdyn_calendar
QUARTER	>< q1 : 192350000 q2 : 192350001 q3 : 192350002 q4 : 192350003	msdyn_quarter
SHORTNAME	=	msdyn_shortname
STARTDATE	=	msdyn_startdate
TYPE	>< opening : 192350000 operating : 192350001 closing : 192350002	msdyn_fiscalperiodtype
PERIODNAME	=	msdyn_periodname
FISCALYEAR	=	msdyn_fiscalcalendaryear.msdyn_name
CALENDAR	=	msdyn_fiscalcalendaryear.msdyn_fiscalcalendarname

Fiscal calendar year integration entity (msdyn_fiscalcalendaryears)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
FISCALCALENDAR_CALENDARID	=	msdyn_fiscalcalendarname
NAME	=	msdyn_name
STARTDATE	=	msdyn_startdate
ENDDATE	=	msdyn_enddate
FISCALCALENDAR_CALENDARID	=	msdyn_calendar.msdyn_calendar

Inventory aisle (msdyn_warehouseaisles)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
AISLEID	=	msdyn_aisleid
AISLENUMBER	=	msdyn_aislenumber
WAREHOUSEID	=	msdyn_warehouse.msdyn_warehouseidentifier
AISLENAME	=	msdyn_aislename
MANUALSTARTINGSORTORDERCODE	=	msdyn_manualstartingsortordercode
ISSORTORDERCODEASSIGNEDDESCENDING	>< yes : True no : False	msdyn_issortordercodeassigneddescending

Item sales tax group (msdyn_taxitemgroups)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
TAXITEMGROUP	=	msdyn_name
NAME	=	msdyn_description

Jobs (cdm_jobs)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
JOBID	=	cdm_name
MAXIMUMNUMBEROFPOSITIONS	=	cdm_maximumnumberofpositions
ALLOWUNLIMITEDPOSITIONS	>< yes : true no : false	cdm_allowunlimitedpositions
DESCRIPTION	=	cdm_description
JOBDESCRIPTION	=	cdm_jobdescription
JOBTYPEID	=	cdm_jobtypeid.cdm_name
FUNCTIONID	=	cdm_jobfunctionid.cdm_name
EFFECTIVE	=	cdm_validfrom
EXPIRATION	=	cdm_validto
FULLTIMEEQUIVALENT	=	cdm_defaultfulltimeequivalent

Language codes (cdm_languages)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
LANGUAGECODEID	=	cdm_name
DESCRIPTION	=	cdm_description

Ledger (msdyn_ledgers)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
LEGALENTITYID	>	msdyn_company.cdm_companycode
DESCRIPTION	>	msdyn_description
ACCOUNTINGCURRENCY	>	msdyn_accountingcurrency.isocurrencycode
ISBUDGETCONTROLENABLED	>> no : False yes : True	msdyn_isbudgetcontrolenabled
NAME	>	msdyn_name
REPORTINGCURRENCY	>	msdyn_reportingcurrency.isocurrencycode
BUDGETEXCHANGERATETYPE	>	msdyn_budgetexchangeratetype.msdyn_name
CHARTOFACCOUNTS	>	msdyn_chartofaccounts.msdyn_name
EXCHANGERATETYPE	>	msdyn_exchangeratetype.msdyn_name
FISCALCALENDAR	>	msdyn_fiscalcalendar.msdyn_calendar
REPORTINGCURRENCYEXCHANGERATETYPE	>	msdyn_reportingcurrencyexchangeratetype.msdyn_name

Legal entities (cdm_companies)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
NAME	>	cdm_name
LEGALENTITYID	>	cdm_companycode

Legal entities (msdyn_internalorganizations)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
NAMEALIAS	>	msdyn_namealias
LANGUAGEID	>	msdyn_languageid
NAME	>	msdyn_name
PARTYNUMBER	>	msdyn_partynumber
none	>>	msdyn_type	806380000
LEGALENTITYID	>	msdyn_companycode

Loyalty card (msdyn_loyaltycards)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
CARDNUMBER	=	msdyn_cardnumber
CARDTENDERTYPE	>< asCardTender : 806380000 asContactTender : 806380001 noTender : 806380002 blocked : 806380003	msdyn_cardtendertype
PARTYNUMBER	=	msdyn_partynumber
REPLACEMENTCARDNUMBER	>	msdyn_replacementcardnumber
OMOPERATINGUNITNUMBER	=	msdyn_operatingunitnumber
LOYALTYENROLLMENTDATE	=	msdyn_enrollmentdate
LOYALTYENROLLMENTDATELOCAL	=	msdyn_effectivedate

Loyalty levels (msdyn_loyaltylevels)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
LEVELPHRASE	=	msdyn_levelphrase
LEVELDESCRIPTION	=	msdyn_description

Loyalty reward points (msdyn_loyaltyrewardpoints)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
EXPIRATIONTIMEUNIT	>< day : 806380000 month : 806380001 year : 806380002	msdyn_expirationtimeunit
EXPIRATIONTIMEVALUE	=	msdyn_expirationtimevalue
REDEEMABLE	>< yes : True no : False	msdyn_redeemable
REDEEMRANKING	=	msdyn_redeemranking
REWARDPOINTCURRENCY	=	msdyn_rewardpointcurrency.isocurrencycode
REWARDPOINTID	=	msdyn_rewardpointid
REWARDPOINTTYPE	>< quantity : 192350000 amount : 192350001	msdyn_rewardpointtype
MAXIMUMLOYALTYREWARDPOINTS	=	msdyn_maximumloyaltyrewardpoints
VESTINGTIMEUNIT	>< day : 806380000 month : 806380001 year : 806380002	msdyn_vestingtimeunit
VESTINGTIMEVALUE	=	msdyn_vestingtimevalue

Main account (msdyn_mainaccounts)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
MAINACCOUNTID	=	msdyn_accountnumber
CHARTOFACCOUNTS	=	msdyn_chartofaccounts.msdyn_name
NAME	=	msdyn_name
BALANCECONTROL	>< none : 192350000 debit : 192350001 credit : 192350002	msdyn_balancecontrol
EXCHANGEADJUSTMENTRATETYPE	=	msdyn_exchangeadjustmentratetype.msdyn_name
CLOSING	>< none : 192350000 result : 192350001 balanceSheet : 192350002 capital : 192350003	msdyn_closing
REPORTINGEXCHANGEADJUSTMENTRATETYPE	=	msdyn_reportingexchangeadjustmentratetype.msdyn_name
DEBITCREDITREQUIREMENT	>< none : 192350000 debit : 192350001 credit : 192350002	msdyn_debitcreditrequirement
FINANCIALREPORTINGEXCHANGERATETYPE	=	msdyn_financialreportingexchangeratetype.msdyn_name
FOREIGNCURRENCYREVALUATION	>< yes : True no : False	msdyn_foreigncurrencyrevaluation
MAINACCOUNTCATEGORY	=	msdyn_mainaccountcategoryname
MANDATORYPAYMENTREFERENCE	>< yes : True no : False	msdyn_mandatorypaymentreference
MONETARY	>< yes : True no : False	msdyn_monetary
OFFSETACCOUNTDISPLAYVALUE	=	msdyn_offsetaccount
POSTINGTYPE	>< none : 192350000 exchRateGain : 192350001 exchRateLoss : 192350002 interCompany : 192350003 tax : 192350004 vATRoundOff : 192350005 allocation : 192350006 investmentDuty : 192350007 liquidity : 192350008 mSTDiffSecond : 192350009 errorAccount : 192350010 mSTDiff : 192350011 yearResult : 192350012 closing : 192350013 ledgerJournal : 192350014 cashDiscount : 192350015 consolidateDiffBalance : 192350016 taxReport : 192350017 transferOpeningClosing : 192350018 bank : 192350019 conversionProfit : 192350020 conversionLoss : 192350021 taxwithhold : 192350022 consolidateDiffProfitLoss : 192350023 indirectEstimatedAbsorptionOffset : 192350024 indirectAbsorption : 192350025 indirectAbsorptionOffset : 192350026 freeTextInvoice : 192350027 conversionReportingLoss : 192350029 conversionReportingProfit : 192350030 custBalance : 192350031 custRevenue : 192350032 custInterest : 192350033 custCashDisc : 192350034 custCollectionLetterFee : 192350035 custInterestFee : 192350036 custInvoiceDisc : 192350028 custPayment : 192350037 custReimbursement : 192350038 custSettlement : 192350039 vendBalance : 192350040 vendPurchLedger : 192350041 vendOffsetAccount : 192350042 vendInterest : 192350043 vendCashDisc : 192350044 vendPayment : 192350045 vendInvoiceDisc : 192350046 vendSettlement : 192350047 crossCompanySettlement : 192350048 inventIssueFixedAsset : 192350049 salesRevenue : 192350050 salesConsump : 192350051 salesDisc : 192350052 salesCash : 192350053 salesFreight : 192350054 salesFee : 192350055 salesPostage : 192350056 salesRoundOff : 192350057 salesPackingSlip : 192350058 salesOffsetAccountPackingSlip : 192350059 salesIssue : 192350060 salesCommission : 192350061 salesOffsetAccountCommission : 192350062 salesPckSlipRevenue : 192350063 salesPckSlipRevenueOffsetAccount : 192350064 rebate : 192350065 pdsCWLoss : 192350066 pdsCWProfit : 192350067 purchConsump : 192350068 purchDisc : 192350069 purchCash : 192350070 purchFreight : 192350071 purchFee : 192350072 purchPostage : 192350073 purchOffsetAccount : 192350074 purchaseInvoiceRoundOff : 192350075 purchMarkupFreight : 192350076 purchMarkupCustoms : 192350077 purchMarkupInsurance : 192350078 purchPckSlp : 192350079 purchOffsetAccountPckSlp : 192350080 purchReceipt : 192350081 purchStdProfit : 192350082 purchStdLoss : 192350083 purchStdOffsetAccount : 192350084 inventReceipt : 192350085 inventIssue : 192350086 inventProfit : 192350087 inventLoss : 192350088 inventStdProfit : 192350089 inventStdLoss : 192350090 opening_ES : 192350091 purchReq : 192350092 aPInvoice : 192350093 budget : 192350094 purchOrderYearEnd : 192350095 inflationAdjustment_MX : 192350096 prodReportFinished : 192350097 prodReportFinishedOffsetAccount : 192350098 prodIssue : 192350099 prodIssueOffsetAccount : 192350100 prodReceipt : 192350101 prodReceiptOffsetAccount : 192350102 prodPicklistOffsetAccount : 192350103 prodPicklist : 192350104 prodWIPValuation : 192350105 prodWIPIssue : 192350106 prodWrkCtrIssue : 192350107 prodScrap : 192350108 prodScrapOffsetAccount : 192350109 prodLeanWIPServiceReceipt : 192350110 prodLeanWIPServiceClearing : 192350111 projCost : 192350112 projPayrollAllocation : 192350113 projWIPCostvalue : 192350114 projOffsetAccountItem : 192350115 projStatusAccountItem : 192350116 projTurnover : 192350117 projOnAccount : 192350118 projSalesvalue : 192350119 projSalesvalueOffset : 192350120 projAccruedTurnoverProd : 192350121 projWIPProduction : 192350122 proJAccruedTurnoverProfit : 192350123 projWIPProfit : 192350125 projNeverLedger : 192350126 projAccruedCost : 192350127 projWIPCost : 192350128 projAccruedRevenueOnAccount : 192350129 projWIPInvoicedOnAccount : 192350130 projNoLedger : 192350131 payrollDebitAccount : 192350132 payrollCreditAccount : 192350133 emplPayment_RU : 192350134 rTSLTranslationDifference : 192350135 rCash : 192350136 inventRoundingLoss_RU : 192350137 inventRoundingProfit_RU : 192350138 advanceAdjustmentGain_RU : 192350139 advanceAdjustmentLoss_RU : 192350140 fixedAssetsDebit : 192350141 fixedAssetsCredit : 192350142 cACLedgerJournalNoOff : 192350143 amountDiffGain_RU : 192350144 amountDiffLoss_RU : 192350145 misc_IN : 192350146 transferGoodsTransit_IN : 192350147 transferScrap_IN : 192350148 purchCharge : 192350149 purchStockVariation : 192350150 purchPckSlpPurchaseOffsetAccount : 192350151 purchPckSlpTax : 192350152 purchPckSlpPurchase : 192350153 salesPackingslipTax : 192350154 projAccruedRevenueSubscription : 192350155 projWIPSubscription : 192350156 taxOffsetWithhold_TH : 192350157 inventStdCostChangeVariance : 192350158 inventSystemRounding : 192350159 purchAdvance : 192350160 purchStdCostPurchasePriceVariance : 192350161 purchAdvanceApplication : 192350162 prodStdCostProductionVariance : 192350163 salesGoodsInRoute_RU : 192350164 salesGoodsInRouteOffset_RU : 192350165 inventInterUnitPayable : 192350166 inventInterUnitReceivable : 192350167 indirectEstimatedAbsorption : 192350168 prodStdCostLotSizeVariance : 192350169 prodStdCostQuantityVariance : 192350170 prodStdCostSubstitutionVariance : 192350171 inventStdCostRoundingVariance : 192350172 purchReceiptFixedAsset : 192350173 pSATransportation : 192350174 pSACompanyCCClearing : 192350175 pSAEmployeeClearing : 192350176 pSAEmployeeAdvance : 192350177 pSAWriteOffCap : 192350178 pSAProjRetain : 192350179 pSAProjPurchRetain : 192350180 inventStdCostRevaluation : 192350181 purchExpense : 192350182 vAT_IN : 192350183 inventMovingAveragePriceDifference : 192350184 salesTax_IN : 192350185 inventMovingAverageCostRevaluation : 192350186 excise_IN : 192350187 intercompanyCost : 192350188 serviceTax_IN : 192350189 intercompanyRevenue : 192350190 customs_IN : 192350191 tDS_IN : 192350192 tCS_IN : 192350193 transferIssue_IN : 192350194 transferReceipt_IN : 192350195 transferProfit_IN : 192350196 transferLoss_IN : 192350197 taxAdjustmentSettlement_IN : 192350198 taxExpense_BR : 192350199 bankStatement : 192350200 emplBalance_RU : 192350201 debitNote_BR : 192350202 custFine_BR : 192350203 vendFine_BR : 192350204 payroll : 192350205 interunitDebit : 192350206 interunitCredit : 192350207 fixedAssetsDebit_RU : 192350208 fixedAssetsCredit_RU : 192350209 transferInterim_In : 192350210 deferralsDebit_RU : 192350211 deferralsCredit_RU : 192350212 mCRReturns : 192350213 mCRReturnsConsump : 192350214 mCRUnderpayWriteOff : 192350215 mCRBrokerFee : 192350216 rPayTaxRefundOffset : 192350217 budgetReservation_PSN : 192350218 budgetReservationYearEnd_PSN : 192350219 billSchUnbilledAccountsReceivable : 192350220 billSchAccruedRevenue : 192350221 gST_IN : 192350222 reportingCurrencyAdjustment : 192350223 revRecDeferredRevenue : 192350224 revRecDeferredCostOfGoodsSold : 192350225 revRecPartialRevenue : 192350226 revRecDeferredCost : 192350227	msdyn_postingtype
SRUCODE	=	msdyn_srucode
VALIDATECURRENCY	>< optional : 192350000 fillIn : 192350001 table : 192350002 list : 192350003	msdyn_validatecurrencycode
VALIDATEUSER	>< optional : 192350000 fillIn : 192350001 table : 192350002 list : 192350003	msdyn_validateuser
DEBITCREDITDEFAULT	>< none : 192350000 debit : 192350001 credit : 192350002	msdyn_debitcreditdefault
DEFAULTCURRENCY	=	msdyn_defaultcurrency.isocurrencycode
MAINACCOUNTTYPE	>< blank : 192350000 profitAndLoss : 192350001 revenue : 192350002 expense : 192350003 balanceSheet : 192350004 asset : 192350005 liability : 192350006 equity : 192350007 total : 192350008 reporting : 192350009 common_CN : 192350010	msdyn_mainaccounttype
FINANCIALREPORTINGCURRENCYTRANSLATIONTYPE	>< weightedAverage : 192350000 standardAverage : 192350001 current : 192350002 transactionDate : 192350003	msdyn_financialreportingcurrencytrantype
USER	=	msdyn_user
VALIDATEPOSTINGTYPE	>< optional : 192350000 fillIn : 192350001 table : 192350002 list : 192350003	msdyn_validateposting

Main account categories (msdyn_mainaccountcategories)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
MAINACCOUNTCATEGORY	=	msdyn_mainaccountcategory
REFERENCEID	=	msdyn_referenceid
DESCRIPTION	=	msdyn_description
DISPLAYORDER	=	msdyn_displayorder
CLOSED	>< no : False yes : True	msdyn_closed
MAINACCOUNTTYPE	>< blank : 192350000 profitAndLoss : 192350001 revenue : 192350002 expense : 192350003 balanceSheet : 192350004 asset : 192350005 liability : 192350006 equity : 192350007	msdyn_mainaccounttypevalue

Mixed reality guides entity (msmrw_guides)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
INTEGRATIONKEY	<	msmrw_integrationkey
NAME	<	msmrw_name
SCHEMAVERSION	<	msmrw_schemaversion
GUIDEID	<	msmrw_guideid
CREATEDON	<	createdon
LASTMODIFIEDON	<	modifiedon

Modes of delivery (msdyn_shipvias)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
MODECODE	=	msdyn_name
MODEDESCRIPTION	=	msdyn_description

Name affixes (msdyn_nameaffixes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
AFFIX	=	msdyn_affix
TYPE	>< personalSuffix : 806380001 personalPrefix : 806380000	msdyn_affixtype
DESCRIPTION	=	msdyn_description

Operating unit (msdyn_internalorganizations)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
LANGUAGEID	>	msdyn_languageid
NAMEALIAS	>	msdyn_namealias
NAME	>	msdyn_name
PARTYNUMBER	>	msdyn_partynumber
OPERATINGUNITTYPE	>> omDepartment : 806380001 none : 806380002 omCostCenter : 806380003 omValueStream : 806380004 omBusinessUnit : 806380005 omAnyOU : 806380006 retailChannel : 192350000	msdyn_type

Organization hierarchy - published (msdyn_internalorganizationhierarchies)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
VALIDTO	>	msdyn_validto
VALIDFROM	>	msdyn_validfrom
HIERARCHYTYPE	>	msdyn_hierarchytypename
PARENTORGANIZATIONPARTYNUMBER	>	msdyn_parentpartyid
CHILDORGANIZATIONPARTYNUMBER	>	msdyn_childpartyid
HIERARCHYTYPE	>	msdyn_hierarchytypeid.msdyn_name
CHILDORGANIZATIONPARTYNUMBER	>	msdyn_childid.msdyn_partynumber
PARENTORGANIZATIONPARTYNUMBER	>	msdyn_parentid.msdyn_partynumber

Organization hierarchy purposes (msdyn_internalorganizationhierarchypurposes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
HIERARCHYTYPE	>	msdyn_hierarchypurposetypename
HIERARCHYTYPE	>	msdyn_hierarchytype.msdyn_name
HIERARCHYPURPOSE	>> notSet : 806380000 purchaseControl : 806380001 expenseControl : 806380002 organizationChart : 806380003 signingLimitControl : 806380004 invoiceControl : 806380005 auditInternalControl : 806380006 centralizedPayments : 806380007 security : 806380008 retailAssortment : 806380009 retailReplenishment : 806380010 retailReporting : 806380011 benefitEligibilityControl : 806380012 budgetPlanning : 806380013 retailPOSPosting : 806380014 project : 806380015 premiumEarningGeneration : 806380016 distributedOrderManagement : 806380017	msdyn_hierarchypurpose
IMMUTABLE	>> no : False yes : True	msdyn_immutable
SETASDEFAULT	>> no : False yes : True	msdyn_setasdefault

Organization hierarchy type (msdyn_internalorganizationhierarchytypes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
NAME	>	msdyn_name

Party contacts V3 (msdyn_partyelectronicaddresses)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
COUNTRYREGIONCODE	=	msdyn_internationalcallingcode
DESCRIPTION	=	msdyn_description
ELECTRONICADDRESSID	=	msdyn_electronicaddressnumber
PARTYNUMBER	=	msdyn_partyid.msdyn_partynumber
LOCATOR	=	msdyn_locator
LOCATOREXTENSION	=	msdyn_locatorextension
ISINSTANTMESSAGE	>< no : False yes : True	msdyn_isinstantmessage
ISMOBILEPHONE	>< no : False yes : True	msdyn_ismobile
ISPRIMARY	>< no : False yes : True	msdyn_isprimary
ISPRIVATE	>< no : False yes : True	msdyn_isprivate
PURPOSE	=	msdyn_purpose
TYPE	>< phone : 192350001 email : 192350002 url : 192350003 telex : 192350004 fax : 192350005 facebook : 192350006 twitter : 192350007 linkedin : 192350008	msdyn_type

Payment day lines CDS V2 (msdyn_paymentdaylines)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
NAME	=	msdyn_paymentday.msdyn_name
LINENUMBER	=	msdyn_linenumber
FREQUENCY	>< week : 806380000 month : 806380001	msdyn_frequency
DAYOFWEEK	>< none : 806380000 monday : 806380001 tuesday : 806380002 wednesday : 806380003 thursday : 806380004 friday : 806380005 saturday : 806380006 sunday : 806380007	msdyn_dayofweek
DAYOFMONTH	=	msdyn_dayofmonth

Payment days CDS (msdyn_paymentdays)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
NAME	=	msdyn_name
DESCRIPTION	=	msdyn_description

Payment schedule (msdyn_paymentschedules)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
NAME	=	msdyn_name
DESCRIPTION	=	msdyn_description
ALLOCATIONMETHOD	>< total : 806380000 amountByPayment : 806380001 numOfPayment : 806380002 specified : 806380003	msdyn_allocationmethod
PAYMENTFREQUENCYUNITS	>< day : 806380000 month : 806380001 year : 806380002	msdyn_paymentfrequencyunit
PAYMENTFREQUENCY	=	msdyn_paymentfrequency
NUMBEROFPAYMENTS	=	msdyn_numberofpayments
FIXEDPAYMENTAMOUNT	=	msdyn_fixedpaymentamount
MINIMUMPAYMENTAMOUNT	=	msdyn_minimumpaymentamount
SALESTAXALLOCATIONMETHOD	>< proportional : 806380000 firstRate : 806380001 lastRate : 806380002	msdyn_salestaxallocationmethod
NOTES	=	msdyn_note

Payment schedule lines (msdyn_paymentschedulelines)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PAYMENTSCHEDULENAME	=	msdyn_paymentschedule.msdyn_name
LINENUMBER	=	msdyn_linenumber
PERIODSAFTERDUEDATE	=	msdyn_periodsafterduedate
PERCENTORAMOUNT	>< percent : 806380000 amount : 806380001	msdyn_percentoramount
PERCENTORAMOUNTVALUE	=	msdyn_percentoramountvalue

Personal character types (msdyn_personalcharactertypes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
TYPEDESCRIPTION	=	msdyn_typedescription
TYPENAME	=	msdyn_typename

Position type (cdm_positiontypes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
POSITIONTYPEID	=	cdm_name
DESCRIPTION	=	cdm_description
CLASSIFICATION	>< fulltime : 754400000 parttime : 754400001 blank : 754400002	cdm_classification

Position worker assignments (cdm_positionworkerassignmentmaps)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PERSONNELNUMBER	=	cdm_workerid.cdm_workernumber
POSITIONID	=	cdm_jobpositionid.cdm_jobpositionnumber
VALIDFROM	=	cdm_validfrom
VALIDTO	=	cdm_validto

Positions V2 (cdm_jobpositions)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
POSITIONID	=	cdm_jobpositionnumber
DESCRIPTION	=	cdm_description
ACTIVATION	=	cdm_activation
AVAILABLEFORASSIGNMENT	=	cdm_availableforassignment
FULLTIMEEQUIVALENT	=	cdm_fulltimeequivalent
DETAILEFFECTIVE	=	cdm_validfrom
DETAILEXPIRATION	=	cdm_validto
RETIREMENT	=	cdm_retirement
POSITIONTYPEID	=	cdm_positiontypeid.cdm_name
JOBID	=	cdm_jobid.cdm_name

Price customer groups (msdyn_pricecustomergroups)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
GROUPCODE	=	msdyn_groupcode
GROUPNAME	=	msdyn_groupname

Product Number Identified Barcode (msdyn_productbarcodes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PRODUCTNUMBER	>	msdyn_productnumberid.msdyn_productnumber
BARCODE	>	msdyn_name
BARCODE	>	msdyn_barcode
PRODUCTQUANTITY	>	msdyn_productquantity
PRODUCTDESCRIPTION	>	msdyn_productdescription
BARCODESETUPID	>	msdyn_barcodesetupid
PRODUCTQUANTITYUNITSYMBOL	>	msdyn_unitofmeasureid.msdyn_symbol
ISDEFAULTSCANNEDBARCODE	>> no : False yes : True	msdyn_isdefaultscannedbarcode
ISDEFAULTPRINTEDBARCODE	>> no : False yes : True	msdyn_isdefaultprintedbarcode
ISDEFAULTDISPLAYEDBARCODE	>> no : False yes : True	msdyn_isdefaultdisplayedbarcode

Product categories (msdyn_productcategories)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PRODUCTCATEGORYHIERARCHYNAME	=	msdyn_hierarchy.msdyn_name
ISCATEGORYINHERITINGPARENTPRODUCTATTRIBUTES	>< no : False yes : True	msdyn_isinheritingparentproductattributes
PROJECTCATEGORYNAME	=	msdyn_projectcategoryname
ISTANGIBLEPRODUCT	>< no : False yes : True	msdyn_istangibleproduct
ISCATEGORYINHERITINGPARENTCATEGORYATTRIBUTES	>< no : False yes : True	msdyn_isinheritingparentcategoryattributes
CATEGORYCODE	=	msdyn_code
CATEGORYDESCRIPTION	=	msdyn_description
CATEGORYKEYWORDS	=	msdyn_keywords
CATEGORYNAME	=	msdyn_name
FRIENDLYCATEGORYNAME	=	msdyn_friendlycategoryname
PARENTPRODUCTCATEGORYNAME	=	msdyn_parentproductcategory.msdyn_name
PARENTPRODUCTCATEGORYHIERARCHYNAME	>	msdyn_parentproductcategory.msdyn_hierarchy.msdyn_name
CATEGORYRECORDID	>	msdyn_externalproductcategoryid
EXTERNALID	=	msdyn_integrationid

Product category assignments (msdyn_productcategoryassignments)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PRODUCTNUMBER	=	msdyn_globalproduct.msdyn_productnumber
PRODUCTCATEGORYNAME	=	msdyn_productcategory.msdyn_name
PRODUCTCATEGORYHIERARCHYNAME	=	msdyn_productcategory.msdyn_hierarchy.msdyn_name
PRODUCTNUMBER	>	msdyn_name

Product category hierarchies (msdyn_productcategoryhierarchies)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
HIERARCHYNAME	=	msdyn_name
HIERARCHYDESCRIPTION	=	msdyn_description

Product category hierarchy roles (msdyn_productcategoryhierarchyroles)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PRODUCTCATEGORYHIERARCHYNAME	=	msdyn_hierarchy.msdyn_name
HIERARCHYROLE	>< procurement : 192350000 sales : 192350001 retail : 192350002 commodity : 192350003 financials : 192350004 retailSpecialGroup : 192350005 retailVendorProductHierarchy : 192350006 retailChannelNavigation : 192350007 packingMaterials_W : 192350008 commonDataService : 192350009 costManagement : 192350010 engineeringProduct : 192350011	msdyn_hierarchyrole

Product default order settings V2 (msdyn_productspecificdefaultordersettings)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
INVENTORYWAREHOUSEID	=	msdyn_inventorywarehouse.msdyn_warehouseidentifier
INVENTORYSITEID	=	msdyn_inventorysite.msdyn_siteid
INVENTORYATPDELAYEDDEMANDOFFSETDAYS	=	msdyn_inventoryatpdelayeddemandoffsetdays
INVENTORYATPDELAYEDSUPPLYOFFSETDAYS	=	msdyn_inventoryatpdelayedsupplyoffsetdays
ITEMNUMBER	=	msdyn_itemnumber.msdyn_itemnumber
INVENTORYATPBACKWARDDEMANDTIMEFENCEDAYS	=	msdyn_inventoryatpbackwarddemandtimefencedays
INVENTORYATPBACKWARDSUPPLYTIMEFENCEDAYS	=	msdyn_inventoryatpbackwardsupplytimefencedays
INVENTORYATPTIMEFENCEDAYS	=	msdyn_inventoryatptimefencedays
MAXIMUMINVENTORYORDERQUANTITY	=	msdyn_maximuminventoryorderquantity
MAXIMUMPROCUREMENTORDERQUANTITY	=	msdyn_maximumprocurementorderquantity
MAXIMUMSALESORDERQUANTITY	=	msdyn_maximumsalesorderquantity
MINIMUMINVENTORYORDERQUANTITY	=	msdyn_minimuminventoryorderquantity
MINIMUMPROCUREMENTORDERQUANTITY	=	msdyn_minimumprocurementorderquantity
MINIMUMSALESORDERQUANTITY	=	msdyn_minimumsalesorderquantity
STANDARDINVENTORYORDERQUANTITY	=	msdyn_standardinventoryorderquantity
STANDARDPROCUREMENTORDERQUANTITY	=	msdyn_standardprocurementorderquantity
STANDARDSALESORDERQUANTITY	=	msdyn_standardsalesorderquantity
INVENTORYLEADTIMEDAYS	=	msdyn_inventoryleadtimedays
INVENTORYQUANTITYMULTIPLES	=	msdyn_inventoryquantitymultiples
PROCUREMENTQUANTITYMULTIPLES	=	msdyn_procurementquantitymultiples
SALESQUANTITYMULTIPLES	=	msdyn_salesquantitymultiples
PROCUREMENTSITEID	=	msdyn_procurementsite.msdyn_siteid
PROCUREMENTLEADTIMEDAYS	=	msdyn_procurementleadtimedays
SALESSITEID	=	msdyn_salessite.msdyn_siteid
SALESATPDELAYEDDEMANDOFFSETDAYS	=	msdyn_salesatpdelayeddemandoffsetdays
SALESATPDELAYEDSUPPLYOFFSETDAYS	=	msdyn_salesatpdelayedsupplyoffsetdays
SALESATPBACKWARDDEMANDTIMEFENCEDAYS	=	msdyn_salesatpbackwarddemandtimefencedays
SALESATPBACKWARDSUPPLYTIMEFENCEDAYS	=	msdyn_salesatpbackwardsupplytimefencedays
SALESATPTIMEFENCEDAYS	=	msdyn_salesatptimefencedays
SALESLEADTIMEDAYS	=	msdyn_salesleadtimedays
PROCUREMENTWAREHOUSEID	=	msdyn_procurementwarehouse.msdyn_warehouseidentifier
SALESWAREHOUSEID	=	msdyn_saleswarehouse.msdyn_warehouseidentifier
AREINVENTORYDEFAULTORDERSETTINGSOVERRIDDEN	>< no : False yes : True	msdyn_areinventoryorderdefaultsoverridden
INVENTORYORDERPROMISINGMETHOD	>< none : 192350000 salesLeadTime : 192350001 atp : 192350002 atpPlusIssueMargin : 192350003 ctp : 192350004	msdyn_inventoryorderpromisingmethod
ISINVENTORYATPINCLUDINGPLANNEDORDERS	>< false : False true : True	msdyn_isinventoryatpincludingplannedorders
ISINVENTORYUSINGWORKINGDAYS	>< no : False yes : True	msdyn_isinventoryusingworkingdays
ISINVENTORYSITEMANDATORY	>< no : False yes : True	msdyn_isinventorysitemandatory
ISINVENTORYPROCESSINGSTOPPED	>< no : False yes : True	msdyn_isinventoryprocessingstopped
ISPROCUREMENTUSINGWORKINGDAYS	>< no : False yes : True	msdyn_isprocurementusingworkingdays
ISPROCUREMENTSITEMANDATORY	>< no : False yes : True	msdyn_isprocurementsitemandatory
ISPROCUREMENTPROCESSINGSTOPPED	>< no : False yes : True	msdyn_isprocurementprocessingstopped
ARESALESDEFAULTORDERSETTINGSOVERRIDDEN	>< no : False yes : True	msdyn_aresalesorderdefaultsoverridden
SALESORDERPROMISINGMETHOD	>< none : 192350000 salesLeadTime : 192350001 atp : 192350002 atpPlusIssueMargin : 192350003 ctp : 192350004	msdyn_salesorderpromisingmethod
ISSALESATPINCLUDINGPLANNEDORDERS	>< false : False true : True	msdyn_issalesatpincludingplannedorders
ISSALESSITEMANDATORY	>< no : False yes : True	msdyn_issalessitemandatory
ISSALESLEADTIMEOVERRIDDEN	>< no : False yes : True	msdyn_issalesleadtimeoverridden
ISSALESPROCESSINGSTOPPED	>< no : False yes : True	msdyn_issalesprocessingstopped
ISINVENTORYWAREHOUSEMANDATORY	>< no : False yes : True	msdyn_isinventorywarehousemandatory
ISPROCUREMENTWAREHOUSEMANDATORY	>< no : False yes : True	msdyn_isprocurementwarehousemandatory
ISSALESWAREHOUSEMANDATORY	>< no : False yes : True	msdyn_issaleswarehousemandatory
OPERATIONALSITEID	=	msdyn_operationalsite.msdyn_siteid
PRODUCTCOLORID	=	msdyn_productcolor.msdyn_productcolorname
PRODUCTCONFIGURATIONID	=	msdyn_productconfiguration.msdyn_productconfiguration
PRODUCTSIZEID	=	msdyn_productsize.msdyn_productsize
PRODUCTSTYLEID	=	msdyn_productstyle.msdyn_productstyle

Product dimension groups (msdyn_productdimensiongroups)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
WILLSALESPRICESEARCHUSEPRODUCTSTYLE	>< no : false yes : true	msdyn_willsalespricesearchuseproductstyle
WILLPURCHASEPRICESEARCHUSEPRODUCTSIZE	>< no : false yes : true	msdyn_willpurchasepricesearchuseproductsize
WILLSALESPRICESEARCHUSEPRODUCTCONFIGURATION	>< no : false yes : true	msdyn_willsalespricesearchuseprodconfig
WILLSALESPRICESEARCHUSEPRODUCTCOLOR	>< no : false yes : true	msdyn_willsalespricesearchuseproductcolor
WILLPURCHASEPRICESEARCHUSEPRODUCTSTYLE	>< no : false yes : true	msdyn_willpurchasepricesearchuseproductstyle
WILLPURCHASEPRICESEARCHUSEPRODUCTCONFIGURATION	>< no : false yes : true	msdyn_willpurchpricesearchuseprodconfig
WILLPURCHASEPRICESEARCHUSEPRODUCTCOLOR	>< no : false yes : true	msdyn_willpurchpricesearchuseproductcolor
ISPRODUCTSTYLEACTIVE	>< no : false yes : true	msdyn_isproductstyleactive
ISPRODUCTSIZEACTIVE	>< no : false yes : true	msdyn_isproductsizeactive
ISPRODUCTCONFIGURATIONACTIVE	>< no : false yes : true	msdyn_isproductconfigurationactive
ISPRODUCTCOLORACTIVE	>< no : false yes : true	msdyn_isproductcoloractive
GROUPNAME	=	msdyn_groupname
GROUPDESCRIPTION	=	msdyn_groupdescription
PRODUCTVARIANTNOMENCLATURENAME	=	msdyn_productvariantnomenclaturename
WILLSALESPRICESEARCHUSEPRODUCTSIZE	>< yes : true no : false	msdyn_willsalespricesearchuseproductsize

Product master colors (msdyn_sharedproductcolors)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PRODUCTCOLORID	>	msdyn_productcolor.msdyn_productcolorname
PRODUCTMASTERNUMBER	>	msdyn_globalproduct.msdyn_productnumber
REPLENISHMENTWEIGHT	>	msdyn_replenishmentweight
DISPLAYSEQUENCENUMBER	>	msdyn_displaysequencenumber

Product master configurations (msdyn_sharedproductconfigurations)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
CONTAINERUNITSYMBOL	>	msdyn_containerunit.msdyn_symbol
PRODUCTCONFIGURATIONID	>	msdyn_productconfiguration.msdyn_productconfiguration
PRODUCTMASTERNUMBER	>	msdyn_globalproduct.msdyn_productnumber
REPLENISHMENTWEIGHT	>	msdyn_replenishmentweight
DISPLAYSEQUENCENUMBER	>	msdyn_displaysequencenumber

Product master sizes (msdyn_sharedproductsizes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PRODUCTMASTERNUMBER	>	msdyn_globalproduct.msdyn_productnumber
PRODUCTSIZEID	>	msdyn_productsize.msdyn_productsize
REPLENISHMENTWEIGHT	>	msdyn_replenishmentweight
DISPLAYSEQUENCENUMBER	>	msdyn_displaysequencenumber

Product master styles (msdyn_sharedproductstyles)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PRODUCTMASTERNUMBER	>	msdyn_globalproduct.msdyn_productnumber
PRODUCTSTYLEID	>	msdyn_productstyle.msdyn_productstyle
REPLENISHMENTWEIGHT	>	msdyn_replenishmentweight
DISPLAYSEQUENCENUMBER	>	msdyn_displaysequencenumber

Product receipt header (msdyn_purchaseorderreceipts)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
RECORDID	>	msdyn_recordid
PRODUCTRECEIPTDATE	>	msdyn_datereceived
DELIVERYADDRESSLATITUDE	>	msdyn_deliveryaddresslatitude
DELIVERYADDRESSLONGITUDE	>	msdyn_deliveryaddresslongitude
PURCHASEORDERNUMBER	>	msdyn_purchaseorder.msdyn_name
DELIVERYMODEID	>	msdyn_shipvia.msdyn_name
DELIVERYTERMSID	>	msdyn_deliveryterm.msdyn_termscode
ORDERVENDORACCOUNTNUMBER	>	msdyn_ordervendor.msdyn_vendoraccountnumber
REQUESTERPERSONNELNUMBER	>	msdyn_requesterpersonnel.cdm_workernumber
ISDELIVERYADDRESSPRIVATE	>> Yes : true No : false	msdyn_isdeliveryaddressprivate
DELIVERYADDRESSCOUNTRYREGIONID	>	msdyn_deliveryaddresscountryregionid
DELIVERYADDRESSCOUNTYID	>	msdyn_deliveryaddresscountyid
DELIVERYADDRESSSTATEID	>	msdyn_deliveryaddressstateid
DELIVERYADDRESSZIPCODE	>	msdyn_deliveryaddresszipcode
DELIVERYADDRESSNAME	>	msdyn_deliveryaddressname
DELIVERYADDRESSTIMEZONE	>	msdyn_deliveryaddresstimezone
DELIVERYADDRESSPOSTBOX	>	msdyn_deliveryaddresspostbox
DELIVERYADDRESSSTREETNUMBER	>	msdyn_deliveryaddressstreetnumber
DELIVERYADDRESSSTREET	>	msdyn_deliveryaddressstreet
PRODUCTRECEIPTNUMBER	>	msdyn_name
ATTENTIONINFORMATION	>	msdyn_note
DELIVERYCITYINKANA	>	msdyn_deliverycityinkana
DELIVERYSTREETINKANA	>	msdyn_deliverystreetinkana
FORMATTEDDELIVERYADDRESS	>	msdyn_formatteddeliveryaddress
DELIVERYADDRESSLOCATIONID	>	msdyn_deliveryaddresslocationid
DELIVERYADDRESSCITY	>	msdyn_deliveryaddresscity
DELIVERYADDRESSDESCRIPTION	>	msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME	>	msdyn_deliveryaddressdistrictname
DELIVERYBUILDINGCOMPLIMENT	>	msdyn_deliverybuildingcompliment
DELIVERYADDRESSDUNSNUMBER	>	msdyn_deliveryaddressdunsnumber

Product receipt line (msdyn_purchaseorderreceiptproducts)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
RECORDID	>	msdyn_recordid
DELIVERYADDRESSCOUNTRYREGIONID	>	msdyn_deliveryaddresscountryregionid
DELIVERYADDRESSCOUNTYID	>	msdyn_deliveryaddresscountyid
DELIVERYADDRESSSTATEID	>	msdyn_deliveryaddressstateid
EXPECTEDDELIVERYDATE	>	msdyn_expecteddeliverydate
EXTERNALITEMNUMBER	>	msdyn_externalitemnumber
ITEMBATCHNUMBER	>	msdyn_itembatchnumber
ITEMSERIALNUMBER	>	msdyn_itemserialnumber
LINEDESCRIPTION	>	msdyn_linedescription
ORDEREDPURCHASEQUANTITY	>	msdyn_orderedpurchasequantity
PROCUREMENTPRODUCTCATEGORYNAME	>	msdyn_procurementproductcategory.msdyn_name
PROCUREMENTPRODUCTCATEGORYHIERARCHYNAME	>	msdyn_procurementproductcategory.msdyn_hierarchy.msdyn_name
PRODUCTRECEIPTDATE	>	msdyn_productreceiptdate
PRODUCTRECEIPTHEADERRECORDID	>	msdyn_purchaseorderreceipt.msdyn_recordid
PRODUCTRECEIPTNUMBER	>	msdyn_productreceiptnumber
PURCHASEORDERLINENUMBER	>	msdyn_purchaseorderproduct.msdyn_lineorder
PURCHASEORDERNUMBER	>	msdyn_purchaseorderproduct.msdyn_purchaseorder.msdyn_name
PURCHASEORDERNUMBER	>	msdyn_purchaseorder.msdyn_name
PURCHASEUNITSYMBOL	>	msdyn_purchaseunitsymbol.msdyn_symbol
RECEIVEDINVENTORYQUANTITY	>	msdyn_receivedinventoryquantity
RECEIVEDINVENTORYSTATUSID	>	msdyn_receivedinventorystatusid
RECEIVEDPURCHASEQUANTITY	>	msdyn_quantity
RECEIVINGSITEID	>	msdyn_receivingsiteid.msdyn_siteid
RECEIVINGWAREHOUSEID	>	msdyn_associatetowarehouse.msdyn_warehouseidentifier
RECEIVINGWAREHOUSELOCATIONID	>	msdyn_receivingwarehouselocation.msdyn_warehouselocationid
RECEIVINGWAREHOUSEID	>	msdyn_receivingwarehouselocation.msdyn_warehouse.msdyn_warehouseidentifier
REMAININGINVENTORYQUANTITY	>	msdyn_remaininginventoryquantity
REMAININGPURCHASEQUANTITY	>	msdyn_remainingpurchasequantity
PRODUCTNUMBER	>	msdyn_product.msdyn_productnumber

Product specific unit conversions (msdyn_productspecificunitofmeasureconversions)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DENOMINATOR	=	msdyn_denominator
NUMERATOR	=	msdyn_numerator
FACTOR	=	msdyn_factor
FROMUNITSYMBOL	=	msdyn_fromunit.msdyn_symbol
TOUNITSYMBOL	=	msdyn_tounit.msdyn_symbol
PRODUCTNUMBER	=	msdyn_globalproduct.msdyn_productnumber
INNEROFFSET	=	msdyn_inneroffset
OUTEROFFSET	=	msdyn_outeroffset
ROUNDING	>< nearest : 192350000 up : 192350001 down : 192350002	msdyn_rounding

Prospects (leads)

This template synchronizes data between finance and operations apps and Dataverse.

Source filter: (IsB2BProspect == 1)

Reversed source filter: (msdyn_b2bcommerceprospect eq true)

Finance and operations field	Map type	Customer engagement column	Default value
PROSPECTNAME	=	fullname
PROSPECTPARTYNUMBER	=	msdyn_partyid.msdyn_partynumber
PROSPECTID	=	msdyn_prospectid
PRIMARYPHONENUMBER	=	telephone1
PRIMARYPHONENUMBEREXTENSION	=	msdyn_telephone1extension
PRIMARYPHONENUMBERDESCRIPTION	=	description
PRIMARYEMAILADDRESS	=	emailaddress1
PRIMARYEMAILADDRESSDESCRIPTION	=	msdyn_emailaddress1description
PRIMARYURL	=	websiteurl
PRIMARYURLDESCRIPTION	=	msdyn_websiteurldescription
ADDRESSCITY	=	address1_city
ADDRESSCOUNTRYREGIONISOCODE	=	address1_country
ADDRESSCOUNTYID	=	address1_county
ADDRESSSTATEID	=	address1_stateorprovince
ADDRESSSTREET	=	address1_line1
ADDRESSZIPCODE	=	address1_postalcode
ADDRESSPOSTBOX	=	address1_postofficebox
ADDRESSLOCATIONROLES	<<	none	Business
none	>>	address1_addresstypecode	1
COMPANYNAME	=	companyname
COMPANYSIZE	=	numberofemployees
ADDRESSLATITUDE	=	address1_latitude
ADDRESSLONGITUDE	=	address1_longitude
CURRENCYCODE	=	transactioncurrencyid.isocurrencycode
CUSTOMERGROUPID	=	msdyn_customergroupid.msdyn_groupid
SALESTAXGROUPCODE	=	msdyn_salestaxgroup.msdyn_name
PRIMARYFAXNUMBER	=	fax
PRIMARYFAXNUMBERDESCRIPTION	=	msdyn_faxdescription
PRIMARYFAXNUMBEREXTENSION	=	msdyn_faxextension
RETAILCHANNELOPERATINGUNITPARTYNUMBER	=	msdyn_retailchannel.msdyn_partynumber
ISB2BPROSPECT	>< no : False yes : True	msdyn_b2bcommerceprospect
B2BPROSPECTSTATUS	>< Pending : 192350000 Approved : 192350001 Rejected : 192350002	msdyn_b2bprospectstatus

Purchase order header document attachments (annotations)

This template synchronizes data between finance and operations apps and Dataverse.

Source filter: ((DocumentAttachmentTypeCode == "Note") || (DocumentAttachmentTypeCode == "URL"))

Reversed source filter: objecttypecode eq 'msdyn_purchaseorder'

Finance and operations field	Map type	Customer engagement column	Default value
DOCUMENTID	=	msdyn_notesid
NOTES	=	notetext
ATTACHMENTDESCRIPTION	=	subject
PURCHASEORDERNUMBER	=	msdyn_relatedentityid
DOCUMENTATTACHMENTTYPECODE	<<	none	Note
none	>>	objecttypecode	msdyn_purchaseorder
ACCESSRESTRICTION	>< internal : 0 external : 1	msdyn_restriction

Purchase order headers V2 (msdyn_purchaseorders)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DELIVERYADDRESSNAME	>	msdyn_addressname
REQUESTEDDELIVERYDATE	=	msdyn_dateexpected
PURCHASEORDERNUMBER	=	msdyn_name
PAYMENTTERMSNAME	=	msdyn_paymentterm.msdyn_name
DEFAULTRECEIVINGWAREHOUSEID	=	msdyn_receivetowarehouse.msdyn_warehouseidentifier
ACCOUNTINGDATE	=	msdyn_accountingdate
AREPRICESINCLUDINGSALESTAX	>< yes : True no : False	msdyn_arepriceincludingsalestax
ATTENTIONINFORMATION	>	msdyn_attentioninformation
CASHDISCOUNTCODE	=	msdyn_cashdiscountcode
CASHDISCOUNTPERCENTAGE	=	msdyn_cashdiscountpercentage
CONTACTPERSONID	=	msdyn_contactpersonid.msdyn_contactpersonid
CURRENCYCODE	=	transactioncurrencyid.isocurrencycode
DEFAULTRECEIVINGSITEID	=	msdyn_defaultreceivingsiteid.msdyn_siteid
DELIVERYTERMSID	=	msdyn_deliveryterm.msdyn_termscode
EMAIL	=	msdyn_email
ISCHANGEMANAGEMENTACTIVE	>> yes : True no : False	msdyn_ischangemanagementactive
ISDELIVEREDDIRECTLY	>> yes : True no : False	msdyn_isdeliverydirectly
LANGUAGEID	>< ar : 192350000 ar-ae : 192350001 cs : 192350002 da : 192350003 de : 192350004 de-at : 192350005 de-ch : 192350006 en-au : 192350007 en-gb : 192350009 en-ie : 192350010 en-in : 192350011 en-ca : 192350008 en-my : 192350012 en-nz : 192350013 en-sg : 192350014 en-us : 192350015 en-za : 192350016 es : 192350017 es-mx : 192350018 et : 192350019 fi : 192350020 fr : 192350021 fr-be : 192350022 fr-ca : 192350023 fr-ch : 192350024 hu : 192350025 is : 192350026 it : 192350027 it-ch : 192350028 ja : 192350029 lt : 192350030 lv : 192350031 nb-no : 192350032 nl : 192350033 nl-be : 192350034 pl : 192350035 pt-br : 192350036 ru : 192350037 sv : 192350038 th : 192350039 tr : 192350040 zh-hans : 192350041	msdyn_language
ORDERERPERSONNELNUMBER	=	msdyn_ordererpersonnelnumber.cdm_workernumber
REASONCODE	=	msdyn_reasoncode
REASONCOMMENT	=	msdyn_reasoncomment
TOTALDISCOUNTPERCENTAGE	=	msdyn_totaldiscountpercentage
URL	=	msdyn_url
VENDORORDERREFERENCE	=	msdyn_vendororderreference
VENDORPAYMENTMETHODNAME	=	msdyn_vendorpaymentmethod.msdyn_name
VENDORPAYMENTMETHODSPECIFICATIONNAME	>	msdyn_vendorpaymentmethodspecificationname
ORDERVENDORACCOUNTNUMBER	=	msdyn_vendor.accountnumber
DELIVERYMODEID	=	msdyn_shipvia.msdyn_name
INVOICEVENDORACCOUNTNUMBER	=	msdyn_invoicevendoraccount.accountnumber
DOCUMENTAPPROVALSTATUS	>> draft : 192350000 inReview : 192350001 rejected : 192350002 approved : 192350003 inExternalReview : 192350004 finalized : 192350005 confirmed : 192350006	msdyn_documentapprovalstatus
PURCHASEORDERSTATUS	>> none : 192350000 backorder : 192350001 received : 192350002 invoiced : 192350003 canceled : 192350004	msdyn_purchaseorderstatus
DELIVERYADDRESSCITY	>	msdyn_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE	>	msdyn_country
DELIVERYADDRESSSTATEID	>	msdyn_stateorprovince
DELIVERYADDRESSZIPCODE	>	msdyn_postalcode
DELIVERYADDRESSSTREET	>	msdyn_address1
INVOICEADDRESSSTREETNUMBER	>	msdyn_invoiceaddressstreetnumber
CONFIRMEDDELIVERYDATE	=	msdyn_confirmeddeliverydate
DELIVERYADDRESSLONGITUDE	>	msdyn_longitude
DELIVERYADDRESSLATITUDE	>	msdyn_latitude
DELIVERYADDRESSCOUNTRYREGIONID	>	msdyn_deliveryaddresscountryregionid
DELIVERYADDRESSCOUNTYID	>	msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION	>	msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME	>	msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER	>	msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLOCATIONID	>	msdyn_deliveryaddresslocationid
DELIVERYADDRESSPOSTBOX	>	msdyn_deliveryaddresspostbox
DELIVERYADDRESSTIMEZONE	>	msdyn_deliveryaddresstimezone
DELIVERYBUILDINGCOMPLIMENT	>	msdyn_deliverybuildingcompliment
FORMATTEDDELIVERYADDRESS	>	msdyn_formatteddeliveryaddress
FORMATTEDINVOICEADDRESS	>	msdyn_formattedinvoiceaddress
INVOICEADDRESSCITY	>	msdyn_invoiceaddresscity
INVOICEADDRESSCOUNTRYREGIONID	>	msdyn_invoiceaddresscountryregionid
INVOICEADDRESSCOUNTY	>	msdyn_invoiceaddresscounty
INVOICEADDRESSSTATE	>	msdyn_invoiceaddressstate
INVOICEADDRESSSTREET	>	msdyn_invoiceaddressstreet
DELIVERYADDRESSSTREETNUMBER	>	msdyn_address2
INVOICEADDRESSZIPCODE	>	msdyn_invoiceaddresszipcode

Released products V2 (msdyn_sharedproductdetails)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PRODUCTNUMBER	>	msdyn_globalproduct.msdyn_productnumber
INTRASTATCHARGEPERCENTAGE	>	msdyn_intrastatchargepercentage
ITEMNUMBER	>	msdyn_itemnumber
APPROXIMATESALESTAXPERCENTAGE	>	msdyn_approximatesalestaxpercentage
BESTBEFOREPERIODDAYS	>	msdyn_bestbeforeperioddays
CARRYINGCOSTABCCODE	>> none : 806380000 a : 806380001 b : 806380002 c : 806380003	msdyn_carryingcostabccode
CONSTANTSCRAPQUANTITY	>	msdyn_constantscrapquantity
COSTCHARGESQUANTITY	>	msdyn_costchargesquantity
DEFAULTRECEIVINGQUANTITY	>	msdyn_defaultreceivingquantity
FIXEDPURCHASEPRICECHARGES	>	msdyn_fixedpurchasepricecharges
FIXEDSALESPRICECHARGES	>	msdyn_fixedsalespricecharges
GROSSDEPTH	>	msdyn_grossdepth
GROSSPRODUCTHEIGHT	>	msdyn_grossproductheight
GROSSPRODUCTWIDTH	>	msdyn_grossproductwidth
INVENTORYUNITSYMBOL	>	msdyn_inventoryunitsymbol.msdyn_symbol
ISDISCOUNTPOSREGISTRATIONPROHIBITED	>> no : False yes : True	msdyn_isdiscountposregistrationprohibited
ISEXEMPTFROMAUTOMATICNOTIFICATIONANDCANCELLATION	>> no : False yes : True	msdyn_exemptautomaticnotificationcancel
ISINSTALLMENTELIGIBLE	>> no : False yes : True	msdyn_isinstallmenteligible
ISINTERCOMPANYPURCHASEUSAGEBLOCKED	>> no : False yes : True	msdyn_isintercompanypurchaseusageblocked
ISINTERCOMPANYSALESUSAGEBLOCKED	>> no : False yes : True	msdyn_isintercompanysalesusageblocked
ISMANUALDISCOUNTPOSREGISTRATIONPROHIBITED	>> no : False yes : True	msdyn_ismanualdiscposregistrationprohibited
ISPHANTOM	>> no : False yes : True	msdyn_isphantom
ISPOSREGISTRATIONBLOCKED	>> no : False yes : True	msdyn_isposregistrationblocked
ISPOSREGISTRATIONQUANTITYNEGATIVE	>> no : False yes : True	msdyn_isposregistrationquantitynegative
ISPURCHASEPRICEAUTOMATICALLYUPDATED	>> no : False yes : True	msdyn_ispurchasepriceautomaticallyupdated
ISPURCHASEPRICEINCLUDINGCHARGES	>> no : False yes : True	msdyn_ispurchasepriceincludingcharges
ISSALESWITHHOLDINGTAXCALCULATED	>> no : False yes : True	msdyn_issaleswithholdingtaxcalculated
ISRESTRICTEDFORCOUPONS	>> no : False yes : True	msdyn_isrestrictedforcoupons
ISSALESPRICEADJUSTMENTALLOWED	>> no : False yes : True	msdyn_issalespriceadjustmentallowed
ISSALESPRICEINCLUDINGCHARGES	>> no : False yes : True	msdyn_issalespriceincludingcharges
ISSCALEPRODUCT	>> no : False yes : True	msdyn_isscaleproduct
ISSHIPALONEENABLED	>> no : False yes : True	msdyn_isshipaloneenabled
ISUNITCOSTPRODUCTVARIANTSPECIFIC	>> no : False yes : True	msdyn_isunitcostproductvariantspecific
ISVARIANTSHELFLABELSPRINTINGENABLED	>> no : False yes : True	msdyn_isvariantshelflabelsprintingenabled
ISZEROPRICEPOSREGISTRATIONALLOWED	>> no : False yes : True	msdyn_iszeropriceposregistrationallowed
KEYINPRICEREQUIREMENTSATPOSREGISTER	>> notMandatory : 806380000 newPrice : 806380001 higherEqual : 806380002 lowerEqual : 806380003 noPrice : 806380004	msdyn_keyinpricerequirementsatposregister
KEYINQUANTITYREQUIREMENTSATPOSREGISTER	>> notMandatory : 806380000 keyIn : 806380001 notKeyIn : 806380002	msdyn_keyinquantityrequirementsatposregister
MARGINABCCODE	>> none : 806380000 a : 806380001 b : 806380002 c : 806380003	msdyn_marginabccode
MAXIMUMPICKQUANTITY	>	msdyn_maximumpickquantity
MUSTKEYINCOMMENTATPOSREGISTER	>> no : False yes : True	msdyn_mustkeyincommentatposregister
NECESSARYPRODUCTIONWORKINGTIMESCHEDULINGPROPERTYID	>	msdyn_necessaryproductionworkingtimeschedulingp
NETPRODUCTWEIGHT	>	msdyn_netproductweight
PACKINGDUTYQUANTITY	>	msdyn_packingdutyquantity
POSREGISTRATIONACTIVATIONDATE	>	msdyn_posregistrationactivationdate
POSREGISTRATIONBLOCKEDDATE	>	msdyn_posregistrationblockeddate
POSREGISTRATIONPLANNEDBLOCKEDDATE	>	msdyn_posregistrationplannedblockeddate
POTENCYBASEATTIBUTETARGETVALUE	>	msdyn_potencybaseattibutetargetvalue
POTENCYBASEATTRIBUTEVALUEENTRYEVENT	>> purchProdReceipt : 806380000 quality : 806380001	msdyn_potencybaseattributevalueentryevent
PRODUCTTYPE	>> item : 806380001 service : 806380002	msdyn_producttype
PRODUCTIONCONSUMPTIONDENSITYCONVERSIONFACTOR	>	msdyn_productionconsumptiondensityconversion
PRODUCTIONCONSUMPTIONDEPTHCONVERSIONFACTOR	>	msdyn_productionconsumptiondepthconversion
PRODUCTIONCONSUMPTIONHEIGHTCONVERSIONFACTOR	>	msdyn_productionconsumptionheightconversion
PRODUCTIONCONSUMPTIONWIDTHCONVERSIONFACTOR	>	msdyn_productionconsumptionwidthconversion
PRODUCTVOLUME	>	msdyn_productvolume
PURCHASECHARGESQUANTITY	>	msdyn_purchasechargesquantity
PURCHASEOVERDELIVERYPERCENTAGE	>	msdyn_purchaseoverdeliverypercentage
PURCHASEPRICE	>	msdyn_purchaseprice
PURCHASEPRICEDATE	>	msdyn_purchasepricedate
PURCHASEPRICINGPRECISION	>	msdyn_purchasepricingprecision
PURCHASEUNDERDELIVERYPERCENTAGE	>	msdyn_purchaseunderdeliverypercentage
RAWMATERIALPICKINGPRINCIPLE	>> staging : 806380000 orderPicking : 806380001	msdyn_rawmaterialpickingprinciple
SALESCHARGESQUANTITY	>	msdyn_saleschargesquantity
SALESOVERDELIVERYPERCENTAGE	>	msdyn_salesoverdeliverypercentage
SALESPRICE	>	msdyn_salesprice
SALESPRICECALCULATIONCHARGESPERCENTAGE	>	msdyn_salespricecalculationchargespercentage
SALESPRICECALCULATIONCONTRIBUTIONRATIO	>	msdyn_salespricecalculationcontributionratio
SALESPRICECALCULATIONMODEL	>> none : 806380000 contributionratio : 806380001 percentMarkup : 806380002	msdyn_salespricecalculationmodel
SALESPRICEDATE	>	msdyn_salespricedate
SALESPRICINGPRECISION	>	msdyn_salespricingprecision
SALESUNDERDELIVERYPERCENTAGE	>	msdyn_salesunderdeliverypercentage
SALESUNITSYMBOL	>	msdyn_salesunitsymbol.msdyn_symbol
SCALEINDICATOR	>> relevant : 806380000 notRelevant : 806380001	msdyn_scaleindicator
SELLSTARTDATE	>	msdyn_sellstartdate
SHELFADVICEPERIODDAYS	>	msdyn_shelfadviceperioddays
SHELFLIFEPERIODDAYS	>	msdyn_shelflifeperioddays
SHIPSTARTDATE	>	msdyn_shipstartdate
TAREPRODUCTWEIGHT	>	msdyn_tareproductweight
TRANSFERORDEROVERDELIVERYPERCENTAGE	>	msdyn_transferorderoverdeliverypercentage
TRANSFERORDERUNDERDELIVERYPERCENTAGE	>	msdyn_transferorderunderdeliverypercentage
UNITCOST	>	msdyn_unitcost
UNITCOSTDATE	>	msdyn_unitcostdate
UNITCOSTQUANTITY	>	msdyn_unitcostquantity
VARIABLESCRAPPERCENTAGE	>	msdyn_variablescrappercentage
WAREHOUSEMOBILEDEVICEDESCRIPTIONLINE1	>	msdyn_warehousemobiledevicedescriptionline1
WAREHOUSEMOBILEDEVICEDESCRIPTIONLINE2	>	msdyn_warehousemobiledevicedescriptionline2
WILLINVENTORYISSUEAUTOMATICALLYREPORTASFINISHED	>> no : False yes : True	msdyn_willinventoryissueautoreportasfinished
WILLINVENTORYRECEIPTIGNOREFLUSHINGPRINCIPLE	>> no : False yes : True	msdyn_willinventoryreceiptignoreflushing
WILLPICKINGWORKBENCHAPPLYBOXINGLOGIC	>> no : False yes : True	msdyn_willpickingworkbenchapplyboxinglogic
WILLTOTALPURCHASEDISCOUNTCALCULATIONINCLUDEPRODUCT	>> no : False yes : True	msdyn_willtotalpurchdiscountcalcincludeproduct
WILLTOTALSALESDISCOUNTCALCULATIONINCLUDEPRODUCT	>> no : False yes : True	msdyn_willtotalsalesdiscountcalcincludeproduct
WILLWORKCENTERPICKINGALLOWNEGATIVEINVENTORY	>> no : False yes : True	msdyn_willworkcenterpickingallownegativeinvent
YIELDPERCENTAGE	>	msdyn_yieldpercentage
ISUNITCOSTAUTOMATICALLYUPDATED	>> no : False yes : True	msdyn_isunitcostautomaticallyupdated
PURCHASEUNITSYMBOL	>	msdyn_purchaseunitsymbol.msdyn_symbol
PURCHASEPRICEQUANTITY	>	msdyn_purchasepricequantity
ISUNITCOSTINCLUDINGCHARGES	>> no : False yes : True	msdyn_isunitcostincludingcharges
FIXEDCOSTCHARGES	>	msdyn_fixedcostcharges
MINIMUMCATCHWEIGHTQUANTITY	>	msdyn_minimumcatchweightquantity
MAXIMUMCATCHWEIGHTQUANTITY	>	msdyn_maximumcatchweightquantity
ALTERNATIVEITEMNUMBER	>	msdyn_alternativeitemnumber.msdyn_itemnumber
BOMUNITSYMBOL	>	msdyn_bomunitsymbol.msdyn_symbol
CATCHWEIGHTUNITSYMBOL	>	msdyn_catchweightunitsymbol.msdyn_symbol
COMPARISONPRICEBASEUNITSYMBOL	>	msdyn_comparisonpricebaseunitsymbol.msdyn_symbol
PRIMARYVENDORACCOUNTNUMBER	>	msdyn_vendorid.msdyn_vendoraccountnumber
ISCATCHWEIGHTPRODUCT	>> no : False yes : True	msdyn_iscatchweight
PRODUCTDIMENSIONGROUPNAME	>	msdyn_productdimensiongroupid.msdyn_groupname
STORAGEDIMENSIONGROUPNAME	>	msdyn_storagedimensiongroup.msdyn_groupname
TRACKINGDIMENSIONGROUPNAME	>	msdyn_trackingdimensiongroup.msdyn_groupname
[None]	>>	msdyn_shouldsyncwithproducts	False

Sales invoice headers V2 (invoices)

This template synchronizes data between finance and operations apps and Dataverse.

Source filter: (SalesOrderNumber != "")

Reversed source filter: msdyn_ordertype eq 192350000

Finance and operations field	Map type	Customer engagement column	Default value
none	>>	ispricelocked	False
none	>>	statuscode	4
CONTACTPERSONID	>	msdyn_associatedcontact.msdyn_contactforpartynumber
CURRENCYCODE	>	transactioncurrencyid.isocurrencycode
CUSTOMERSORDERREFERENCE	>	description
INVOICEADDRESSCITY	>	billto_city
INVOICEADDRESSCOUNTRYREGIONISOCODE	>	billto_country
INVOICEADDRESSSTATE	>	billto_stateorprovince
INVOICEADDRESSSTREET	>	billto_line1
INVOICEADDRESSSTREETNUMBER	>	billto_line2
INVOICEADDRESSZIPCODE	>	billto_postalcode
INVOICECUSTOMERACCOUNTNUMBER	>	customerid.Account(accountnumber).Contact(msdyn_contactpersonid)
INVOICEDATE	>	msdyn_invoicedate
INVOICENUMBER	>	msdyn_invoicenumber
LEDGERVOUCHER	>	msdyn_ledgervoucher
PAYMENTTERMSNAME	>	msdyn_paymentterms.msdyn_name
SALESORDERNUMBER	>	salesorderid.msdyn_salesordernumber
TOTALCHARGEAMOUNT	>	freightamount
TOTALDISCOUNTAMOUNT	>	msdyn_totaldiscountamount
TOTALDISCOUNTCUSTOMERGROUPCODE	>	discountamount
TOTALINVOICEAMOUNT	>	msdyn_totalamount
TOTALTAXAMOUNT	>	msdyn_totaltax
none	>>	msdyn_ordertype	192350000

Sales invoice lines V2 (invoicedetails)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
CONFIRMEDSHIPPINGDATE	>	msdyn_confirmedshippingdate
CURRENCYCODE	>	transactioncurrencyid.isocurrencycode
INVENTORYSITEID	>	msdyn_inventorysite.msdyn_siteid
INVENTORYWAREHOUSEID	>	msdyn_inventorywarehouse.msdyn_warehouseidentifier
INVOICEDATE	>	invoiceid.msdyn_invoicedate
INVOICEDQUANTITY	>	quantity
INVOICENUMBER	>	invoiceid.msdyn_invoicenumber
LEDGERVOUCHER	>	invoiceid.msdyn_ledgervoucher
LINEAMOUNT	>	extendedamount
LINECREATIONSEQUENCENUMBER	>	sequencenumber
LINETOTALCHARGEAMOUNT	>	msdyn_totalchargeamount
LINETOTALDISCOUNTAMOUNT	>	manualdiscountamount
LINETOTALTAXAMOUNT	>	tax
PRODUCTNAME	>	description
PRODUCTNUMBER	>	productid.msdyn_productnumber
SALESPRICE	>	priceperunit
SALESPRODUCTCATEGORYHIERARCHYNAME	>	msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name
SALESPRODUCTCATEGORYNAME	>	msdyn_salesproductcategory.msdyn_name
SALESUNITSYMBOL	>	uomid.msdyn_symbol
none	>>	producttypecode	1
none	>>	propertyconfigurationstatus	2
none	>>	ispriceoverridden	True

Sales order header document attachments (annotations)

This template synchronizes data between finance and operations apps and Dataverse.

Source filter: ((DocumentAttachmentTypeCode == "Note") || (DocumentAttachmentTypeCode == "URL"))

Reversed source filter: objecttypecode eq 'salesorder'

Finance and operations field	Map type	Customer engagement column	Default value
DOCUMENTID	=	msdyn_notesid
NOTES	=	notetext
ATTACHMENTDESCRIPTION	=	subject
SALESORDERNUMBER	=	msdyn_relatedentityid
DOCUMENTATTACHMENTTYPECODE	<<	none	Note
none	>>	objecttypecode	salesorder
ACCESSRESTRICTION	>< internal : 0 external : 1	msdyn_restriction

Sales order origin codes (msdyn_salesorderorigins)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
ORIGINCODE	=	msdyn_origincode
ORIGINDESCRIPTION	=	msdyn_origindescription

Sales tax authorities (msdyn_taxauthorities)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
TAXAUTHORITYCODE	=	msdyn_taxauthoritycode
TAXAUTHORITYIDENTIFICATION	=	msdyn_taxauthorityidentificator
DESCRIPTION	=	msdyn_description
REPORTLAYOUT	>< default : 192350000 norway : 192350001 unitedKingdom : 192350002 sweden : 192350003 germany : 192350004 austria : 192350005 netherlands : 192350006 usa : 192350007 italy : 192350008 belgium : 192350009 singapore : 192350010 japan : 192350011 finland : 192350012 estonia : 192350013 uae : 192350014	msdyn_taxreportlayout
ROUNDOFFTYPE	>< ordinary : 192350000 roundDown : 192350001 roundUp : 192350002 advantage : 192350003	msdyn_roundofftype
ROUNDOFF	=	msdyn_roundoff
EMAIL	=	msdyn_email
PHONE	=	msdyn_phone
URL	=	msdyn_url

Sales tax exempt code entity CDS (msdyn_taxexemptcodes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
NAME	=	msdyn_name
DESCRIPTION	=	msdyn_description

Sales tax groups (msdyn_taxgroups)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
TAXGROUPCODE	=	msdyn_name
DESCRIPTION	=	msdyn_description

Sales tax ledger posting groups V2 (msdyn_taxpostinggroups)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
TAXPOSTINGGROUPCODE	=	msdyn_name
DESCRIPTION	=	msdyn_description

Salutations (msdyn_salutations)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
SALUTATIONPHRASE	=	msdyn_salutationphrase

Sites (msdyn_operationalsites)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DEFAULTFINANCIALDIMENSIONVALUE	=	msdyn_defaultfinancialdimensionvalue
DEFAULTINVENTORYSTATUSID	=	msdyn_defaultinventorystatusid
ISRECEIVINGWAREHOUSEOVERRIDEALLOWED	>< no : False yes : True	msdyn_isreceivingwarehouseoverrideallowed
SITEID	=	msdyn_siteid
SITENAME	=	msdyn_sitename
TAXBRANCHCODE	=	msdyn_taxbranchcode
FISCALESTABLISHMENTID	=	msdyn_fiscalestablishmentid
ISPRIMARYADDRESSASSIGNED	>< no : False yes : True	msdyn_isprimaryaddressassigned
PRIMARYADDRESSCITY	=	msdyn_primaryaddresscity
PRIMARYADDRESSCOUNTRYREGIONID	=	msdyn_primaryaddresscountryregionid
PRIMARYADDRESSCOUNTYID	=	msdyn_primaryaddresscountyid
PRIMARYADDRESSDISTRICTNAME	=	msdyn_primaryaddressdistrictname
PRIMARYADDRESSLATITUDE	=	msdyn_primaryaddresslatitude
PRIMARYADDRESSLOCATIONROLES	=	msdyn_primaryaddresslocationrole
PRIMARYADDRESSLOCATIONSALESTAXGROUPCODE	=	msdyn_primaryaddresslocationsalestaxgroupcode
PRIMARYADDRESSLONGITUDE	=	msdyn_primaryaddresslongitude
PRIMARYADDRESSSTATEID	=	msdyn_primaryaddressstateid
PRIMARYADDRESSSTREET	=	msdyn_primaryaddressstreet
PRIMARYADDRESSZIPCODE	=	msdyn_primaryaddresszipcode
PRIMARYADDRESSBUILDINGCOMPLIMENT	=	msdyn_primaryaddressbuildingcompliment
PRIMARYADDRESSCITYINKANA	=	msdyn_primaryaddresscityinkana
PRIMARYADDRESSSTREETINKANA	=	msdyn_primaryaddressstreetinkana
PRIMARYADDRESSDESCRIPTION	=	msdyn_primaryaddressdescription
FORMATTEDPRIMARYADDRESS	=	msdyn_formattedprimaryaddress
WILLMASTERPLANNEDINTRASITEMOVEMENTSUSETRANSFERJOURNALS	>< no : False yes : True	msdyn_masterplannedusestransferjournal
PRIMARYADDRESSPOSTBOX	=	msdyn_primaryaddresspostbox
PRIMARYADDRESSSTREETNUMBER	=	msdyn_primaryaddressstreetnumber

Sizes (msdyn_productsizes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
SIZEID	>	msdyn_productsize

Storage dimension groups (msdyn_productstoragedimensiongroups)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
WILLSALESPRICESEARCHUSEWAREHOUSE	>< no : false yes : true	msdyn_willsalespricesearchusewarehouse
WILLSALESPRICESEARCHUSESITE	>< no : false yes : true	msdyn_willsalespricesearchusesite
WILLSALESPRICESEARCHUSEINVENTORYSTATUS	>< no : false yes : true	msdyn_willsalespricesearchuseinventorystatus
WILLPURCHASEPRICESEARCHUSEWAREHOUSE	>< no : false yes : true	msdyn_willpurchasepricesearchusewarehouse
WILLPURCHASEPRICESEARCHUSESITE	>< no : false yes : true	msdyn_willpurchasepricesearchusesite
WILLPURCHASEPRICESEARCHUSEINVENTORYSTATUS	>< no : false yes : true	msdyn_willpurchpricesearchuseinventstatus
WILLCOVERAGEPLANNINGUSEWAREHOUSE	>< no : false yes : true	msdyn_willcoverageplanusewarehouse
WILLCOVERAGEPLANNINGUSELOCATION	>< no : false yes : true	msdyn_iscoverageplanenabledforlocation
WILLCOVERAGEPLANNINGUSEINVENTORYSTATUS	>< no : false yes : true	msdyn_willcoverageplanuseinventorystatus
AREADVANCEDWAREHOUSEMANAGEMENTPROCESSESENABLED	>< no : false yes : true	msdyn_areadvancedwmprocessesenabled
ISWAREHOUSEPRIMARYSTORAGEDIMENSION	>< no : false yes : true	msdyn_iswarehouseprimarystoragedimension
ISWAREHOUSEMANDATORY	>< no : false yes : true	msdyn_iswarehousemandatory
ISPHYSICALINVENTORYENABLEDFORWAREHOUSE	>< no : false yes : true	msdyn_isphysicalinventoryenabledforwarehouse
ISPHYSICALINVENTORYENABLEDFORLOCATION	>< no : false yes : true	msdyn_isphysicalinventoryenabledforlocation
ISLOCATIONACTIVE	>< no : false yes : true	msdyn_islocationactive
ISFINANCIALINVENTORYENABLEDFORWAREHOUSE	>< no : false yes : true	msdyn_isfinancialinventoryenabledforwarehouse
GROUPNAME	=	msdyn_groupname
GROUPDESCRIPTION	=	msdyn_groupdescription
ISBLANKRECEIPTALLOWEDFORLOCATION	>< no : false yes : true	msdyn_isblankreceiptallowedforlocation
ISBLANKISSUEALLOWEDFORLOCATION	>< no : false yes : true	msdyn_isblankissueallowedforlocation

Styles (msdyn_productstyles)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
STYLEID	>	msdyn_productstyle

Terms of delivery (msdyn_termsofdeliveries)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
TERMSCODE	=	msdyn_termscode
INTRASTATCODE	=	msdyn_intrastatcode
SALESTAXLOCATIONROLE	>< none : 192350000 invoice : 192350001 delivery : 192350002 swift : 192350003 payment : 192350004 service : 192350005 home : 192350006 other : 192350007 business : 192350008 remitTo : 192350009 statement : 192350010 fixedAsset : 192350011 oneTime : 192350012 recruit : 192350013 sms : 192350014 lading_W : 192350015 unlading_W : 192350016 headCompany_IT : 192350017 stableOrganization_IT : 192350018	msdyn_salestaxlocationrole
TERMSDESCRIPTION	=	msdyn_termsdescription
FREIGHTCHARGETERMS	>< prepaid : 192350000 collect : 192350001 thirdParty : 192350002 nofreight : 192350003	msdyn_freightchargeterms
DORETAILSALESORDERSGETTRANSPORTATIONCHARGESADDED	>< no : False yes : True	msdyn_doretailsogettransportationchargesadded
ISCASHONDELIVERY	>< no : False yes : True	msdyn_iscashondelivery
WILLSHIPMENTCONFIRMATIONTRANSFERCHARGES	>< no : False yes : True	msdyn_willshipmentconfirmationtransfercharges

Terms of payment (msdyn_paymentterms)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DESCRIPTION	=	msdyn_description
NAME	=	msdyn_name
NUMBEROFMONTHS	=	msdyn_numberofmonth
CUTOFFDAYOFMONTH	=	msdyn_cutoffdayofmonth
ISCASHPAYMENT	>< no : False yes : True	msdyn_iscashpayment
NUMBEROFDAYS	=	msdyn_days
ISCERTIFIEDCOMPANYCHECK	>< yes : True no : False	msdyn_iscertifiedcompanycheck
ISDEFAULTPAYMENTTERM	>< no : False yes : True	msdyn_isdefaultpaymentterm
CREDITCARDPAYMENTTYPE	>< na : 806380998 creditCard : 806380999	msdyn_creditcardpaymenttype
CREDITCARDCREDITCHECKTYPE	>< normal : 806380000 byPass : 806380001	msdyn_creditcardcreditchecktype
PAYMENTDAYNAME	=	msdyn_paymentdayname.msdyn_name
PAYMENTMETHODTYPE	>< net : 806380991 currentMth : 806380992 currentQuart : 806380993 currentYear : 806380994 currentWeek : 806380995 cod : 806380996 cutOffDate : 806380997	msdyn_paymentmethodtype
PAYMENTSCHEDULENAME	=	msdyn_paymentschedulename.msdyn_name

Tracking dimension groups (msdyn_producttrackingdimensiongroups)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
SERIALNUMBERCAPTURINGOPERATION	>< none : 806380000 picking : 806380001 packing : 806380002	msdyn_serialnumbercapturingoperation
GROUPNAME	=	msdyn_groupname
GROUPDESCRIPTION	=	msdyn_groupdescription
ISSERIALNUMBERENABLEDFORPRODUCTIONCONSUMPTIONPROCESS	>< no : false yes : true	msdyn_issnenabledforpcprocess
ISSERIALNUMBERCONTROLENABLED	>< no : false yes : true	msdyn_isserialnumbercontrolenabled
ISSERIALNUMBERENABLEDFORSALESPROCESS	>< no : false yes : true	msdyn_isserialnumberenabledforsalesprocess
ISSERIALNUMBERACTIVE	>< no : false yes : true	msdyn_isserialnumberactive
ISSALESPRICEBYSERIALNUMBER	>< no : false yes : true	msdyn_issalespricebyserialnumber
ISSALESPRICEBYBATCHNUMBER	>< no : false yes : true	msdyn_issalespricebybatchnumber
ISPURCHASEPRICEBYSERIALNUMBER	>< no : false yes : true	msdyn_ispurchasepricebyserialnumber
ISPURCHASEPRICEBYBATCHNUMBER	>< no : false yes : true	msdyn_ispurchasepricebybatchnumber
ISPRIMARYSTOCKINGENABLEDFORSERIALNUMBER	>< no : false yes : true	msdyn_isprimarystockingenabledforsn
ISPRIMARYSTOCKINGENABLEDFORBATCHNUMBER	>< no : false yes : true	msdyn_isprimarystockingenabledforbn
ISPHYSICALINVENTORYENABLEDFORSERIALNUMBER	>< no : false yes : true	msdyn_isphysicalinventoryenabledforsn
ISPHYSICALINVENTORYENABLEDFORBATCHNUMBER	>< no : false yes : true	msdyn_isphysicalinventoryenabledforbn
ISFINANCIALINVENTORYENABLEDFORSERIALNUMBER	>< no : false yes : true	msdyn_isfinancialinventoryenabledforsn
ISFINANCIALINVENTORYENABLEDFORBATCHNUMBER	>< no : false yes : true	msdyn_isfinancialinventoryenabledforbn
ISCOVERAGEPLANENABLEDFORSERIALNUMBER	>< no : false yes : true	msdyn_iscoverageplanenabledforserialnumber
ISCOVERAGEPLANENABLEDFORBATCHNUMBER	>< no : false yes : true	msdyn_iscoverageplanenabledforbatchnumber
ISBLANKRECEIPTALLOWEDFORSERIALNUMBER	>< no : false yes : true	msdyn_isblankreceiptallowedforserialnumber
ISBLANKRECEIPTALLOWEDFORBATCHNUMBER	>< no : false yes : true	msdyn_isblankreceiptallowedforbatchnumber
ISBLANKISSUEALLOWEDFORSERIALNUMBER	>< no : false yes : true	msdyn_isblankissueallowedforserialnumber
ISBLANKISSUEALLOWEDFORBATCHNUMBER	>< no : false yes : true	msdyn_isblankissueallowedforbatchnumber
ISBATCHNUMBERACTIVE	>< no : false yes : true	msdyn_isbatchnumberactive
ISINVENTORYOWNERACTIVE	>< no : false yes : true	msdyn_isinventoryowneractive

Unit conversions (msdyn_unitofmeasureconversions)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DENOMINATOR	=	msdyn_denominator
NUMERATOR	=	msdyn_numerator
FACTOR	=	msdyn_factor
INNEROFFSET	=	msdyn_inneroffset
OUTEROFFSET	=	msdyn_outeroffset
ROUNDING	>< nearest : 192350000 up : 192350001 down : 192350002	msdyn_rounding
TOUNITSYMBOL	=	msdyn_tounit.msdyn_symbol
FROMUNITSYMBOL	=	msdyn_fromunit.msdyn_symbol

Units (uoms)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
UNITSYMBOL	>	msdyn_symbol
UNITCLASS	>	msdyn_externalunitclassname
DECIMALPRECISION	>	msdyn_decimalprecision
ISBASEUNIT	>> no : false yes : true	msdyn_isbaseunit
ISSYSTEMUNIT	>> no : false yes : true	msdyn_issystemunit
SYSTEMOFUNITS	>> none : 192350000 metric : 192350001 us : 192350002	msdyn_systemofunits
UNITSYMBOL	>	name
UNITDESCRIPTION	>	msdyn_description

Vendor document attachments (annotations)

This template synchronizes data between finance and operations apps and Dataverse.

Source filter: ((DocumentAttachmentTypeCode == "Note") || (DocumentAttachmentTypeCode == "URL"))

Reversed source filter: (objecttypecode eq 'msdyn_vendor' and msdyn_relatedentityid2 ne null) or (objecttypecode eq 'account' and msdyn_relatedentityid2 ne null) or (objecttypecode eq 'contact' and msdyn_relatedentityid2 ne null)

Finance and operations field	Map type	Customer engagement column	Default value
DOCUMENTID	=	msdyn_notesid
NOTES	=	notetext
ATTACHMENTDESCRIPTION	=	subject
VENDORACCOUNTNUMBER	=	msdyn_relatedentityid2
DOCUMENTATTACHMENTTYPECODE	<<	none	Note
none	>>	objecttypecode	msdyn_vendor
ACCESSRESTRICTION	>< internal : 0 external : 1	msdyn_restriction

Vendor groups (msdyn_vendorgroups)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DEFAULTPAYMENTTERMNAME	=	msdyn_paymentterms.msdyn_name
DESCRIPTION	=	msdyn_description
VENDORGROUPID	=	msdyn_vendorgroup
CLEARINGPERIODPAYMENTTERMNAME	=	msdyn_clearingperiodpaymentpermname.msdyn_name

Vendor payment method (msdyn_vendorpaymentmethods)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
NAME	=	msdyn_name
DESCRIPTION	=	msdyn_description
SUMBYPERIOD	>< transDate : 806380001 invoice : 806380000 week : 806380002 total : 806380003	msdyn_sumbyperiod
DISCOUNTGRACEPERIODDAYS	=	msdyn_discountgraceperioddays
PAYMENTSTATUS	>< none : 806380000 sent : 806380001 recieved : 806380002 approved : 806380003 rejected : 806380004	msdyn_paymentstatus
ALLOWPAYMENTCOPIES	>< no : False yes : True	msdyn_allowpaymentcopies
PAYMENTTYPE	>< blank : 806380000 check : 806380001 electronicPayment : 806380002 promissoryNote : 806380003	msdyn_paymenttype
LASTFILENUMBER	=	msdyn_lastfilenumber
LASTFILENUMBERTODAY	=	msdyn_lastfilenumbertoday
ACCOUNTTYPE	>< ledger : 806380000 bank : 806380005 cust : 806380001 fixedAssets : 806380004 vend : 806380002 project : 806380003	msdyn_accounttype
BRIDGINGPOSTINGENABLED	>< no : False yes : True	msdyn_bridgingposting
ENABLEPOSTDATEDCHECKCLEARINGPOSTING	>< no : False yes : True	msdyn_postdatedcheckclearingposting
PROMISSORYNOTEDRAFTTYPE	>< noDraft : 806380000 noAcceptance : 806380001 acceptance : 806380002 promissory : 806380003 bankAcceptance : 806380004	msdyn_promissorynotedrafttype
DIRECTDEBIT	>< no : False yes : True	msdyn_directdebit

Vendors V2 (msdyn_vendors)

This template synchronizes data between finance and operations apps and Dataverse.

Source filter: ((VendorPartyType == "Organization") || (VendorPartyType == "Person"))

Finance and operations field	Map type	Customer engagement column	Default value
VENDORACCOUNTNUMBER	=	msdyn_vendoraccountnumber
VENDORGROUPID	=	msdyn_vendorgroupid.msdyn_vendorgroup
VENDORPARTYTYPE	>< person : True organization : False	msdyn_isperson
CREDITLIMIT	=	msdyn_vendorcreditlimit
ISFOREIGNENTITY	>< no : False yes : True	msdyn_isforeignentity
ISONETIMEVENDOR	>< no : False yes : True	msdyn_isonetimevendor
CREDITRATING	=	msdyn_creditrating
DUNSNUMBER	=	msdyn_dunsnumber
ETHNICORIGINID	=	msdyn_ethnicorigin
OURACCOUNTNUMBER	=	msdyn_ourvendoraccountnumber
PAYMENTID	=	msdyn_paymentid
PRIMARYURL	=	msdyn_primarycontacturl
DEFAULTPAYMENTDAYNAME	=	msdyn_defaultpaymentdayname.msdyn_name
DEFAULTPAYMENTSCHEDULENAME	=	msdyn_paymentschedule.msdyn_name
DEFAULTPAYMENTTERMSNAME	=	msdyn_paymentterms.msdyn_name
HASONLYTAKENBIDS	>< no : False yes : True	msdyn_hasonlytakenbids
ISMINORITYOWNED	>< no : False yes : True	msdyn_isminorityowned
ISVENDORLOCALLYOWNED	>< yes : True no : False	msdyn_isvendorlocallyowned
ISSERVICEVETERANOWNED	>< yes : True no : False	msdyn_isserviceveteranowned
ISOWNERDISABLED	>< no : False yes : True	msdyn_ownerisdisabled
ISWOMANOWNER	>< no : False yes : True	msdyn_womanowner
ORGANIZATIONEMPLOYEEAMOUNT	=	msdyn_numberofemployees
VENDORHOLDRELEASEDATE	=	msdyn_vendoronholdreleasedate
VENDORPARTYNUMBER	=	msdyn_partyid.msdyn_partynumber
ONHOLDSTATUS	>< no : 806380000 invoice : 806380001 all : 806380002 payment : 806380003 requisition : 806380004 never : 806380005	msdyn_onholdstatus
CURRENCYCODE	=	msdyn_currencycode.isocurrencycode
ISVENDORLOCATEDINHUBZONE	>< no : False yes : True	msdyn_isvendorlocatedinhubzone
DEFAULTVENDORPAYMENTMETHODNAME	=	msdyn_vendorpaymentmethod.msdyn_name
INVOICEVENDORACCOUNTNUMBER	=	msdyn_invoicevendoraccountnumber.msdyn_vendoraccountnumber
AREPRICESINCLUDINGSALESTAX	>< no : False yes : True	msdyn_priceincludessalestax
SALESTAXGROUPCODE	=	msdyn_taxgroup.msdyn_name
PRIMARYCONTACTPERSONID	=	msdyn_primarycontact.msdyn_contactforpartynumber

Veteran status (cdm_veteranstatuses)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
VETERANSTATUSID	=	cdm_name
DESCRIPTION	=	cdm_description
ISPROTECTEDVETERAN	>< no : false yes : true	cdm_isprotectedveteran

Warehouse locations (msdyn_inventorylocations)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
BINID	=	msdyn_binid
CHECKDIGITS	=	msdyn_checkdigits
GENERATECHECKDIGITS	>< yes : True no : False	msdyn_generatecheckdigits
ISSORTORDERCODEMANUAL	>< yes : True no : False	msdyn_issortordercodemanual
ISWAREHOUSELOCATIONIDMANUAL	>< yes : True no : False	msdyn_iswarehouselocationidmanual
LASTCOUNTEDUTCDATETIME	=	msdyn_lastcountedutcdatetime
PHYSICALDEPTH	=	msdyn_physicaldepth
PHYSICALHEIGHT	=	msdyn_physicalheight
PHYSICALHEIGHTABOVEGROUND	=	msdyn_physicalheightaboveground
PHYSICALMAXIMUMSTORAGEVOLUME	=	msdyn_physicalmaximumstoragevolume
PHYSICALMAXIMUMSTORAGEWEIGHT	=	msdyn_physicalmaximumstorageweight
PHYSICALWIDTH	=	msdyn_physicalwidth
RACKID	=	msdyn_rackid
SHELFID	=	msdyn_shelfid
WAREHOUSEID	=	msdyn_warehouse.msdyn_warehouseidentifier
WAREHOUSELOCATIONID	=	msdyn_warehouselocationid
WAREHOUSELOCATIONPROFILEID	=	msdyn_warehouselocationprofileid
WAREHOUSELOCATIONTYPE	>< buffer : 192350000 pick : 192350001 inputPort : 192350002 outputPort : 192350003 inspectionLocation : 192350004 kanbanSupermarket : 192350005	msdyn_warehouselocationtype
INPUTWAREHOUSELOCATIONBLOCKINGCAUSEID	=	msdyn_inputwarehouselocationblockingcauseid
OUTPUTWAREHOUSELOCATIONBLOCKINGCAUSEID	=	msdyn_outputwarehouselocationblockingcauseid
ISDEFAULTCREDITONLYRETURNWAREHOUSELOCATION	>< yes : True no : False	msdyn_isdefaultcreditonlyreturnwarehouseloc
ISDEFAULTISSUEWAREHOUSELOCATION	>< yes : True no : False	msdyn_isdefaultissuewarehouselocation
ISDEFAULTKANBANFINISHEDGOODSWAREHOUSELOCATION	>< yes : True no : False	msdyn_isdefaultkanbanfinishedgoodswarehouseloc
ISDEFAULTPRODUCTIONFINISHEDGOODSWAREHOUSELOCATION	>< yes : True no : False	msdyn_isdefaultproductionfinishedgoodswhsloc
ISDEFAULTPRODUCTIONINPUTWAREHOUSELOCATION	>< yes : True no : False	msdyn_isdefaultproductioninputwarehouseloc
ISDEFAULTRECEIPTWAREHOUSELOCATION	>< yes : True no : False	msdyn_isdefaultreceiptwarehouselocation
ISDEFAULTRETAILSTORERETURNWAREHOUSELOCATION	>< yes : True no : False	msdyn_isdefaultretailstorereturnwarehouseloc
ISDEFAULTRETAILSTOREWAREHOUSELOCATION	>< yes : True no : False	msdyn_isdefaultretailstorewarehouselocation
ISDEFAULTSHIPMENTMAINTENANCEWAREHOUSELOCATION	>< yes : True no : False	msdyn_isdefaultshipmentmaintenancewarehouseloc
AGINGDATE	>	msdyn_agingdate
LASTACTIVITYDATETIME	>	msdyn_lastactivitydatetime
LOCATIONSTATUS	>> undetermined : 192350000 empty : 192350001 picking : 192350002 storage : 192350003	msdyn_locationstatus
ISITEMINLOCATIONMAINTAINED	>< yes : True no : False	msdyn_isiteminlocationmaintained
ISLOCATIONACTIVITYDATETIMEMAINTAINED	>< yes : True no : False	msdyn_islocationactivitydatetimemaintained
ISLOCATIONSTATUSMAINTAINED	>< yes : True no : False	msdyn_islocationstatusmaintained
ISDEFAULTQUALITYMAINTENANCEWAREHOUSELOCATION	>< yes : True no : False	msdyn_isdefaultqualitymaintenancewarehouseloc
WAREHOUSEAISLEID	=	msdyn_warehouseaisle.msdyn_aisleid
WAREHOUSEID	>	msdyn_warehouseaisle.msdyn_warehouse.msdyn_warehouseidentifier
WAREHOUSEZONEID	=	msdyn_warehousezone.msdyn_zoneid
FIRSTADDITIONALWAREHOUSEZONEID	=	msdyn_firstadditionalwarehousezone.msdyn_zoneid
SECONDADDITIONALWAREHOUSEZONEID	=	msdyn_secondadditionalwarehousezone.msdyn_zoneid
THIRDADDITIONALWAREHOUSEZONEID	=	msdyn_thirdadditionalwarehousezone.msdyn_zoneid
ITEMNUMBERINLOCATION	=	msdyn_itemnumberinlocation.msdyn_itemnumber

Warehouse work headers (msdyn_warehouseworkheaders)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
ACTUALPROCESSINGTIMESECONDS	>	msdyn_actualprocessingtimeseconds
ESTIMATEDPROCESSINGTIMESECONDS	>	msdyn_estimatedprocessingtimeseconds
ISWAREHOUSEWORKBLOCKED	>> yes : True no : False	msdyn_iswarehouseworkblocked
WAREHOUSEID	>	msdyn_warehouse.msdyn_warehouseidentifier
INVENTORYSITEID	>	msdyn_inventorysite.msdyn_siteid
ISWAREHOUSEWORKERMANUALLYASSIGNED	>> yes : True no : False	msdyn_iswarehouseworkermanuallyassigned
WAREHOUSEWORKCANCELLEDDATETIME	>	msdyn_warehouseworkcancelleddatetime
WAREHOUSEWORKCLOSEDDATETIME	>	msdyn_warehouseworkcloseddatetime
WAREHOUSEWORKID	>	msdyn_warehouseworkid
WAREHOUSEWORKPROCESSINGSTARTDATETIME	>	msdyn_warehouseworkprocessingstartdatetime
WAREHOUSEWORKPRIORITY	>	msdyn_warehouseworkpriority
WAREHOUSEWORKSTATUS	>> open : 192350000 inprocess : 192350001 skipped : 192350002 closed : 192350003 cancelled : 192350004 combined : 192350005	msdyn_warehouseworkstatus
WAREHOUSEWORKORDERTYPE	>> qualityOrder : 192350021 none : 192350000 purch : 192350001 sales : 192350002 prodPick : 192350003 prodPut : 192350004 prodProcessPut : 192350005 transferIssue : 192350006 transferReceipt : 192350007 invent : 192350008 workCancel : 192350009 cycleCount : 192350010 replenishment : 192350011 returnOrder : 192350012 kanbanPut : 192350013 kanbanPick : 192350014 cycleCountAccepted : 192350015 packedContainerPicking : 192350016 sortedInventoryPicking : 192350017 crossDocking : 192350018 qualityInQualityCheck : 192350019 qualityItemSampling : 192350020	msdyn_warehouseworkordertype
CONTAINERID	>	msdyn_containerid
WAREHOUSEWORKLOCKINGWAREHOUSEMOBILEDEVICEUSERID	>	msdyn_warehouseworklockingmobiledeviceuserid
TARGETLICENSEPLATENUMBER	>	msdyn_targetlicenseplatenumber
WAVEID	>	msdyn_waveid
WAREHOUSEWORKCANCELLINGUSERID	>	msdyn_warehouseworkcancellinguserid
WAREHOUSEWORKMANUALLYCOMPLETINGUSERID	>	msdyn_warehouseworkmanuallycompletinguserid
WAREHOUSEWORKPOOLID	>	msdyn_warehouseworkpoolid

Warehouse work lines (msdyn_warehouseworklines)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
ACTUALPROCESSINGTIMESECONDS	>	msdyn_actualprocessingtimeseconds
ESTIMATEDPROCESSINGTIMESECONDS	>	msdyn_estimatedprocessingtimeseconds
FEFOITEMBATCHNUMBER	>	msdyn_fefoitembatchnumber
REMAININGHANDLINGQUANTITY	>	msdyn_remaininghandlingquantity
HANDLINGQUANTITY	>	msdyn_handlingquantity
WORKLINENUMBER	>	msdyn_worklinenumber
ISWORKLINEMANDATORY	>> yes : True no : False	msdyn_isworklinemandatory
REMAININGWORKQUANTITY	>	msdyn_remainingworkquantity
WORKQUANTITY	>	msdyn_workquantity
ISREPLENISHMENTNEEDED	>> yes : True no : False	msdyn_isreplenishmentneeded
SORTORDERCODE	>	msdyn_sortordercode
WORKQUANTITYUNITSYMBOL	>	msdyn_workquantityunit.msdyn_symbol
WAREHOUSEWORKCLOSEDDATETIME	>	msdyn_warehouseworkcloseddatetime
WAREHOUSEWORKID	>	msdyn_warehousework.msdyn_warehouseworkid
WAREHOUSEWORKPROCESSINGSTARTDATETIME	>	msdyn_warehouseworkprocessingstartdatetime
WAREHOUSEWORKSTATUS	>> open : 192350000 inProcess : 192350001 pendingReview : 192350002 skipped : 192350003 closed : 192350004 cancelled : 192350005 combined : 192350006	msdyn_warehouseworkstatus
ISWORKEXECUTIONSTOPPED	>> yes : True no : False	msdyn_isworkexecutionstopped
WAREHOUSEWORKTYPE	>> none : 192350000 pick : 192350001 put : 192350002 count : 192350003 adjustment : 192350004 custom : 192350005 quarantine : 192350006 licensePlateBuild : 192350007 print : 192350008 statusChange : 192350009 packToNestedLicensePlate : 192350010 qualityCheck : 192350011	msdyn_warehouseworktype
EXTRAHANDLINGQUANTITY	>	msdyn_extrahandlingquantity
CAPTUREDWEIGHT	>	msdyn_capturedweight
WAREHOUSEID	>	msdyn_warehouse.msdyn_warehouseidentifier
INVENTORYSITEID	>	msdyn_inventorysite.msdyn_siteid
CONTAINERID	>	msdyn_containerid
PROCESSINGWAREHOUSEMOBILEDEVICEUSERID	>	msdyn_processingwarehousemobiledeviceuserid
ITEMBATCHNUMBER	>	msdyn_itembatchnumber
INVENTORYOWNERID	>	msdyn_inventoryownerid
ITEMSERIALNUMBER	>	msdyn_itemserialnumber
INVENTORYSTATUSID	>	msdyn_inventorystatusid
LICENSEPLATENUMBER	>	msdyn_licenseplatenumber
ITEMNUMBER	>	msdyn_item.msdyn_itemnumber
WAREHOUSEZONEID	>	msdyn_warehousezone.msdyn_zoneid
WAREHOUSELOCATIONID	>	msdyn_warehouselocation.msdyn_warehouselocationid
WAREHOUSEID	>	msdyn_warehouselocation.msdyn_warehouse.msdyn_warehouseidentifier
PRODUCTCONFIGURATIONID	>	msdyn_productconfiguration.msdyn_productconfiguration
PRODUCTCOLORID	>	msdyn_productcolor.msdyn_productcolorname
PRODUCTSIZEID	>	msdyn_productsize.msdyn_productsize
PRODUCTSTYLEID	>	msdyn_productstyle.msdyn_productstyle

Warehouse zone groups (msdyn_warehousezonegroups)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
GROUPID	=	msdyn_groupid
GROUPNAME	=	msdyn_groupname

Warehouse zones (msdyn_warehousezones)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
WAREHOUSEZONEGROUPID	=	msdyn_warehousezonegroup.msdyn_groupid
ZONEID	=	msdyn_zoneid
ZONENAME	=	msdyn_zonename

Warehouses (msdyn_warehouses)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
DEFAULTCONTAINERTYPEID	=	msdyn_defaultcontainertypeid
AREITEMSCOVERAGEPLANNEDMANUALLY	>< no : false yes : true	msdyn_areitemscoverageplannedmanually
ARELABORSTANDARDSALLOWED	>< no : false yes : true	msdyn_arelaborstandardsallowed
PRIMARYADDRESSBUILDINGCOMPLIMENT	=	msdyn_primaryaddressbuildingcompliment
PRIMARYADDRESSPOSTBOX	=	msdyn_primaryaddresspostbox
PRIMARYADDRESSSTREETNUMBER	=	msdyn_primaryaddressstreetnumber
AREWAREHOUSELOCATIONCHECKDIGITSUNIQUE	>< yes : true no : false	msdyn_arewarehouselocationcheckdigitsunique
INVENTORYCOUNTINGREASONCODEPOLICYNAME	=	msdyn_inventorycountingreasoncodepolicyname
AUTOUPDATESHIPMENTRULE	>< always : false onQuantityDecrease : true	msdyn_autoupdateshipmentrule
WAREHOUSERELEASERESERVATIONREQUIREMENTRULE	>< notapplicable : 192350000 allowpartialreservation : 192350001 requirefullreservation : 192350002	msdyn_warehousereleasereservationrequirement
EXTERNALLYLOCATEDWAREHOUSEVENDORACCOUNTNUMBER	=	msdyn_externallylocatedwarehousevendoraccountnu
INVENTORYSTATUSCHANGERESERVATIONREMOVALLEVEL	>< none : 192350000 reservation : 192350001 markingreservation : 192350002	msdyn_inventorystatuschangereservationremoval
WAREHOUSEWORKPROCESSINGPOLICYNAME	=	msdyn_warehouseworkprocessingpolicyname
ISFALLBACKWAREHOUSE	>< yes : true no : false	msdyn_isfallbackwarehouse
ISFINANCIALNEGATIVERETAILSTOREINVENTORYALLOWED	>< yes : true no : false	msdyn_financialnegativestoreinventoryallowed
ISPALLETMOVEMENTDURINGCYCLECOUNTINGALLOWED	>< yes : true no : false	msdyn_palletmovementduringcyclecountingallowed
ISPHYSICALNEGATIVERETAILSTOREINVENTORYALLOWED	>< yes : true no : false	msdyn_physicalnegativestoreinventoryallowed
ISREFILLEDFROMMAINWAREHOUSE	>< yes : true no : false	msdyn_isrefilledfrommainwarehouse
ISRETAILSTOREWAREHOUSE	>< yes : true no : false	msdyn_isretailstorewarehouse
MAINREFILLINGWAREHOUSEID	=	msdyn_mainrefillingwarehouse.msdyn_warehouseidentifier
MASTERPLANNINGWORKCALENDARDID	=	msdyn_masterplanningworkcalendarid
MAXIMUMBATCHPICKINGLISTQUANTITY	=	msdyn_maximumbatchpickinglistquantity
MAXIMUMPICKINGLISTLINEQUANTITY	=	msdyn_maximumpickinglistlinequantity
OPERATIONALSITEID	=	msdyn_operationalsite.msdyn_siteid
QUARANTINEWAREHOUSEID	=	msdyn_quarantinewarehouse.msdyn_warehouseidentifier
RETAILSTOREQUANTITYALLOCATIONREPLENISMENTRULEWEIGHT	=	msdyn_storeqtyallocationreplenishmentweight
SHOULDWAREHOUSELOCATIONIDINCLUDEAISLEID	>< no : false yes : true	msdyn_shouldwarehouselocationincludeaisleid
TRANSITWAREHOUSEID	=	msdyn_transitwarehouse.msdyn_warehouseidentifier
WAREHOUSEID	=	msdyn_warehouseidentifier
WAREHOUSEID	>	msdyn_name
WAREHOUSELOCATIONIDBINIDFORMAT	=	msdyn_warehouselocationidbinidformat
WAREHOUSELOCATIONIDRACKIDFORMAT	=	msdyn_warehouselocationidrackidformat
WAREHOUSELOCATIONIDSHELFIDFORMAT	=	msdyn_warehouselocationidshelfidformat
WAREHOUSENAME	=	msdyn_description
WAREHOUSESPECIFICDEFAULTINVENTORYSTATUSID	=	msdyn_warehousespecificdefaultinventorystatusid
WAREHOUSETYPE	>< goodsinroute_ru : 192350000 transit : 192350001 quarantine : 192350002 standard : 192350003 itmgit : 192350004 itmunder : 192350005	msdyn_warehousetype
ISPRIMARYADDRESSASSIGNED	>< yes : true no : false	msdyn_isprimaryaddressassigned
PRIMARYADDRESSCITY	=	msdyn_primaryaddresscity
PRIMARYADDRESSCOUNTRYREGIONID	=	msdyn_primaryaddresscountryregionid
PRIMARYADDRESSCOUNTYID	=	msdyn_primaryaddresscountyid
PRIMARYADDRESSDISTRICTNAME	=	msdyn_primaryaddressdistrictname
PRIMARYADDRESSLATITUDE	=	msdyn_primaryaddresslatitude
PRIMARYADDRESSLONGITUDE	=	msdyn_primaryaddresslongitude
PRIMARYADDRESSLOCATIONROLES	=	msdyn_primaryaddresslocationroles
PRIMARYADDRESSLOCATIONSALESTAXGROUPCODE	=	msdyn_primaryaddresslocationsalestaxgroupcode
PRIMARYADDRESSSTATEID	=	msdyn_primaryaddressstateid
PRIMARYADDRESSSTREET	=	msdyn_primaryaddressstreet
PRIMARYADDRESSZIPCODE	=	msdyn_primaryaddresszipcode
EXTERNALLYLOCATEDWAREHOUSECUSTOMERACCOUNTNUMBER	=	msdyn_externallylocatedwarehousecustomeraccount
PRIMARYADDRESSCITYINKANA	=	msdyn_primaryaddresscityinkana
PRIMARYADDRESSSTREETINKANA	=	msdyn_primaryaddressstreetinkana
PRIMARYADDRESSDESCRIPTION	=	msdyn_primaryaddressdescription
AREADVANCEDWAREHOUSEMANAGEMENTPROCESSESENABLED	>< yes : true no : false	msdyn_useadvancedwarehousemanagementprocesses
AREPICKINGLISTSDELIVERYMODESPECIFIC	>< yes : true no : false	msdyn_arepickinglistsdeliverymodespecific
AREPICKINGLISTSSHIPMENTSPECIFICONLY	>< yes : true no : false	msdyn_arepickinglistshipmentspecificonly
FORMATTEDPRIMARYADDRESS	=	msdyn_formattedprimaryaddress
ISBILLOFLADINGPRINTINGBEFORESHIPMENTCONFIRMATIONENABLED	>< yes : true no : false	msdyn_printbillofladingbeforeshipconfirmation
RAWMATERIALPICKINGINVENTORYISSUESTATUS	>< pick : false reserve : true	msdyn_rawmaterialpickinginventoryissuestatus
WILLAUTOMATICLOADRELEASERESERVEINVENTORY	>< yes : true no : false	msdyn_willautomaticloadreleaseinventory
WILLINVENTORYSTATUSCHANGEREMOVEBLOCKING	>< yes : true no : false	msdyn_willinventorystatuschangeremoveblocking
WILLMANUALLOADRELEASERESERVEINVENTORY	>< yes : true no : false	msdyn_willmanualloadreleasereserveinventory
WILLORDERRELEASINGCONSOLIDATESHIPMENTS	>< yes : true no : false	msdyn_willorderreleasingconsolidateshipments
WILLPRODUCTIONBOMSRESERVEWAREHOUSELEVELONLY	>< yes : true no : false	msdyn_productionbomsreservewarehouselevel
WILLSHIPPINGCANCELLATIONDECREMENTLOADQUANITY	>< yes : true no : false	msdyn_shippingcanceldecrementloadquantity
WILLWAREHOUSELOCATIONIDINCLUDEBINIDBYDEFAULT	>< yes : true no : false	msdyn_warehouselocationidincludeblindid
WILLWAREHOUSELOCATIONIDINCLUDERACKIDBYDEFAULT	>< yes : true no : false	msdyn_warehouselocationincluderackidbydefault
WILLWAREHOUSELOCATIONIDINCLUDESHELFIDBYDEFAULT	>< yes : true no : false	msdyn_warehouselocationidincludeshelfid

Withholding tax codes (msdyn_withholdingtaxcodes)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
WITHHOLDINGCODE	=	msdyn_name
WITHHOLDINGTAXNAME	=	msdyn_description
WITHHOLDINGTAXROUNDOFF	=	msdyn_roundoff
WITHHOLDINGTAXROUNDOFFTYPE	>< ordinary : 192350000 roundDown : 192350001 roundUp : 192350002	msdyn_roundofftype
CURRENCYCODEID	=	msdyn_currency.isocurrencycode
WITHHOLDINGTAXBASE	>< pctPerNet : 192350000 pctPerGross : 192350001	msdyn_taxableamountorigin

Withholding tax groups (msdyn_withholdingtaxgroups)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
WITHHOLDINGTAXGROUPCODE	=	msdyn_name
DESCRIPTION	=	msdyn_description

Worker (cdm_workers)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
PERSONNELNUMBER	=	cdm_workernumber
FIRSTNAME	=	cdm_firstname
MIDDLENAME	=	cdm_middlename
LASTNAME	=	cdm_lastname
WORKERTYPE	>> employee : 754400000 contractor : 754400001 both : 754400000	cdm_type
WORKERSTATUS	>> employed : 754400000 pending : 754400001 terminated : 754400001	cdm_status
PRIMARYCONTACTEMAIL	=	cdm_primaryemailaddress
PRIMARYCONTACTPHONE	=	cdm_primarytelephone
PRIMARYCONTACTFACEBOOK	=	cdm_facebookidentity
PRIMARYCONTACTTWITTER	=	cdm_twitteridentity
PRIMARYCONTACTLINKEDIN	=	cdm_linkedinidentity
PRIMARYCONTACTURL	=	cdm_websiteurl
GENDER	>< male : 754400000 female : 754400001 nonSpecific : 754400003 none : 754400002	cdm_gender
BIRTHDATE	=	cdm_birthdate
NAME	>	cdm_fullname

CDS location roles (msdyn_addressroles)

This template synchronizes data between finance and operations apps and Dataverse.

Finance and operations field	Map type	Customer engagement column	Default value
ISCONTACTINFORMATION	>< yes : true no : false	msdyn_iselectronicaddressrole
ISPOSTALADDRESS	>< yes : true no : false	msdyn_ispostaladdressrole
PURPOSE	=	msdyn_name

Transfer order headers

Finance and operations field	Map type	Customer engagement column	Default value
SHIPPINGADDRESSNAME	>	msdyn_shippingaddressname
FORMATTEDSHIPPINGADDRESS	>	msdyn_formattedshippingaddress
SHIPPINGADDRESSCITY	>	msdyn_shippingaddresscity
SHIPPINGADDRESSCOUNTRYREGIONID	>	msdyn_shippingaddresscountryregionid
SHIPPINGADDRESSCOUNTYID	>	msdyn_shippingaddresscountyid
SHIPPINGADDRESSDESCRIPTION	>	msdyn_shippingaddressdescription
SHIPPINGADDRESSDISTRICTNAME	>	msdyn_shippingaddressdistrictname
SHIPPINGADDRESSDUNSNUMBER	>	msdyn_shippingaddressdunsnumber
SHIPPINGADDRESSLATITUDE	>	msdyn_shippingaddresslatitude
SHIPPINGADDRESSLOCATIONID	>	msdyn_shippingaddresslocationid
SHIPPINGADDRESSLONGITUDE	>	msdyn_shippingaddresslongitude
SHIPPINGADDRESSPOSTBOX	>	msdyn_shippingaddresspostbox
SHIPPINGADDRESSSTATEID	>	msdyn_shippingaddressstateorprovince
SHIPPINGADDRESSSTREET	>	msdyn_shippingaddress1
SHIPPINGADDRESSSTREETNUMBER	>	msdyn_shippingaddress2
SHIPPINGADDRESSTIMEZONE	>	msdyn_shippingaddresstimezone
SHIPPINGADDRESSZIPCODE	>	msdyn_shippingaddresspostalcode
SHIPPINGCONTACTPERSONNELNUMBER	>	msdyn_shippingcontactpersonnelnumber
DELIVERYMODECODE	=	msdyn_shipvia
DELIVERYTERMSCODE	=	msdyn_deliveryterm
SHIPPINGWAREHOUSEID	=	msdyn_fromwarehouse.msdyn_warehouseidentifier
RECEIVINGWAREHOUSEID	=	msdyn_towarehouse.msdyn_warehouseidentifier
TRANSITWAREHOUSEID	>	msdyn_transitwarehouse.msdyn_warehouseidentifier
REQUESTEDRECEIPTDATE	=	msdyn_receivedate
REQUESTEDSHIPPINGDATE	=	msdyn_shipdate
RECEIVINGADDRESSNAME	>	msdyn_receivingaddressname
TRANSFERORDERNUMBER	=	msdyn_name
TRANSFERORDERSTATUS	>>	msdyn_transferstatus
RECEIVINGCONTACTPERSONNELNUMBER	>	msdyn_receivingcontactpersonnelnumber
FORMATTEDRECEIVINGADDRESS	>	msdyn_formattedreceivingaddress
RECEIVINGADDRESSCITY	>	msdyn_receivingaddresscity
RECEIVINGADDRESSCOUNTRYREGIONID	>	msdyn_receivingaddresscountryregionid
RECEIVINGADDRESSCOUNTYID	>	msdyn_receivingaddresscountyid
RECEIVINGADDRESSDESCRIPTION	>	msdyn_receivingaddressdescription
RECEIVINGADDRESSDISTRICTNAME	>	msdyn_receivingaddressdistrictname
RECEIVINGADDRESSDUNSNUMBER	>	msdyn_receivingaddressdunsnumber
RECEIVINGADDRESSLATITUDE	>	msdyn_receivingaddresslatitude
RECEIVINGADDRESSLOCATIONID	>	msdyn_receivingaddresslocationid
RECEIVINGADDRESSLONGITUDE	>	msdyn_receivingaddresslongitude
RECEIVINGADDRESSPOSTBOX	>	msdyn_receivingaddresspostbox
RECEIVINGADDRESSSTATEID	>	msdyn_receivingaddressstateorprovince
RECEIVINGADDRESSSTREET	>	msdyn_receivingaddresss1
RECEIVINGADDRESSSTREETNUMBER	>	msdyn_receivingaddresss2
RECEIVINGADDRESSTIMEZONE	>	msdyn_receivingaddresstimezone
RECEIVINGADDRESSZIPCODE	>	msdyn_receivingaddresspostalcode

Transfer order products

Finance and operations field	Map type	Customer engagement column	Default value
ITEMNUMBER	=	msdyn_product.msdyn_productnumber
LINENUMBER	=	msdyn_lineorder
ALLOWEDOVERDELIVERYPERCENTAGE	=	msdyn_allowedoverdeliverypercentage
RECEIVEDCATCHWEIGHTQUANTITY	>	msdyn_catchweightquantityreceived
SCRAPPEDCATCHWEIGHTQUANTITY	>	msdyn_catchweightquantityscrapped
SHIPPEDCATCHWEIGHTQUANTITY	>	msdyn_catchweightquantityshipped
TRANSFERCATCHWEIGHTQUANTITY	=	msdyn_catchweightquantity
RECEIVEDQUANTITY	>	msdyn_quantityreceived
SCRAPPEDQUANTITY	>	msdyn_quantityscrapped
SHIPPEDQUANTITY	>	msdyn_quantityshipped
TRANSFERQUANTITY	>	msdyn_quantity
REQUESTEDRECEIPTDATE	=	msdyn_receivedate
LINESTATUS	>>	msdyn_linestatus
REQUESTEDSHIPPINGDATE	=	msdyn_shipdate
TRANSFERORDERNUMBER	=	msdyn_transferorder.msdyn_name
ALLOWEDUNDERDELIVERYPERCENTAGE	=	msdyn_allowedunderdeliverypercentage
INVENTORYUNITSYMBOL	>	msdyn_unit
SHIPPINGWAREHOUSEID	=	msdyn_shippingwarehouse
SHIPPINGSITEID	=	msdyn_shippingsite
SHIPPINGWAREHOUSELOCATIONID	=	msdyn_shippinglocation