Dual-write mapping reference

Статья
2022-10-07

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