Integrated sites and warehouses

Important

Dynamics 365 for Finance and Operations is now being licensed as Dynamics 365 Finance and Dynamics 365 Supply Chain Management. For more information about these licensing changes, see Dynamics 365 Licensing Update.

This topic describes the integration of site and warehouse data between Finance and Operations and Common Data Service. Operational sites and warehouses are common concepts in a Supply Chain Management application. They are used to model the supply chain of your company.

Templates

With the integration with Common Data Service, these concepts and all their related information are available in Common Data Service using the sites and warehouses data entities in the following table.

Finance and Operations apps Other Dynamics 365 apps Description
Sites msdyn_operationalsites
Warehouses msdyn_warehouses

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 other Dynamics 365 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 the Common Data Model. For example, in the Contacts table of the Common Data Model, the default value of address1_addresstypecode is 3. In the Common Data Model, for address1AddressTypeCode the value of 3 is Primary address.

Sites to msdyn_operationalsites

This template synchronizes data between Finance and Operations apps and Common Data Service.

Finance and Operations field Map type Other Dynamics 365 field Default value
DEFAULTFINANCIALDIMENSIONVALUE >< msdyn_defaultfinancialdimensionvalue
DEFAULTINVENTORYSTATUSID >< msdyn_defaultinventorystatusid
ISRECEIVINGWAREHOUSEOVERRIDEALLOWED >< msdyn_isreceivingwarehouseoverrideallowed
SITEID >< msdyn_siteid
SITENAME >< msdyn_sitename
TAXBRANCHCODE >< msdyn_taxbranchcode
FISCALESTABLISHMENTID >< msdyn_fiscalestablishmentid
ISPRIMARYADDRESSASSIGNED >< 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 >< msdyn_masterplannedusestransferjournal
PRIMARYADDRESSPOSTBOX >< msdyn_primaryaddresspostbox
PRIMARYADDRESSSTREETNUMBER >< msdyn_primaryaddressstreetnumber

Warehouses to msdyn_warehouses

This template synchronizes data between Finance and Operations apps and Common Data Service.

Finance and Operations field Map type Other Dynamics 365 field Default value
DEFAULTCONTAINERTYPEID >< msdyn_defaultcontainertypeid
AREITEMSCOVERAGEPLANNEDMANUALLY >< msdyn_areitemscoverageplannedmanually
ARELABORSTANDARDSALLOWED >< msdyn_arelaborstandardsallowed
PRIMARYADDRESSBUILDINGCOMPLIMENT >< msdyn_primaryaddressbuildingcompliment
PRIMARYADDRESSPOSTBOX >< msdyn_primaryaddresspostbox
PRIMARYADDRESSSTREETNUMBER >< msdyn_primaryaddressstreetnumber
AREWAREHOUSELOCATIONCHECKDIGITSUNIQUE >< msdyn_arewarehouselocationcheckdigitsunique
INVENTORYCOUNTINGREASONCODEPOLICYNAME >< msdyn_inventorycountingreasoncodepolicyname
AUTOUPDATESHIPMENTRULE >< msdyn_autoupdateshipmentrule
WAREHOUSERELEASERESERVATIONREQUIREMENTRULE >< msdyn_warehousereleasereservationrequirement
EXTERNALLYLOCATEDWAREHOUSEVENDORACCOUNTNUMBER >< msdyn_externallylocatedwarehousevendoraccountnu
INVENTORYSTATUSCHANGERESERVATIONREMOVALLEVEL >< msdyn_inventorystatuschangereservationremoval
WAREHOUSEWORKPROCESSINGPOLICYNAME >< msdyn_warehouseworkprocessingpolicyname
ISFALLBACKWAREHOUSE >< msdyn_isfallbackwarehouse
ISFINANCIALNEGATIVERETAILSTOREINVENTORYALLOWED >< msdyn_financialnegativestoreinventoryallowed
ISPALLETMOVEMENTDURINGCYCLECOUNTINGALLOWED >< msdyn_palletmovementduringcyclecountingallowed
ISPHYSICALNEGATIVERETAILSTOREINVENTORYALLOWED >< msdyn_physicalnegativestoreinventoryallowed
ISREFILLEDFROMMAINWAREHOUSE >< msdyn_isrefilledfrommainwarehouse
ISRETAILSTOREWAREHOUSE >< 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 >< 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 >< msdyn_warehousetype
ISPRIMARYADDRESSASSIGNED >< 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 >< msdyn_useadvancedwarehousemanagementprocesses
AREPICKINGLISTSDELIVERYMODESPECIFIC >< msdyn_arepickinglistsdeliverymodespecific
AREPICKINGLISTSSHIPMENTSPECIFICONLY >< msdyn_arepickinglistshipmentspecificonly
FORMATTEDPRIMARYADDRESS >< msdyn_formattedprimaryaddress
ISBILLOFLADINGPRINTINGBEFORESHIPMENTCONFIRMATIONENABLED >< msdyn_printbillofladingbeforeshipconfirmation
RAWMATERIALPICKINGINVENTORYISSUESTATUS >< msdyn_rawmaterialpickinginventoryissuestatus
WILLAUTOMATICLOADRELEASERESERVEINVENTORY >< msdyn_willautomaticloadreleaseinventory
WILLINVENTORYSTATUSCHANGEREMOVEBLOCKING >< msdyn_willinventorystatuschangeremoveblocking
WILLMANUALLOADRELEASERESERVEINVENTORY >< msdyn_willmanualloadreleasereserveinventory
WILLORDERRELEASINGCONSOLIDATESHIPMENTS >< msdyn_willorderreleasingconsolidateshipments
WILLPRODUCTIONBOMSRESERVEWAREHOUSELEVELONLY >< msdyn_productionbomsreservewarehouselevel
WILLSHIPPINGCANCELLATIONDECREMENTLOADQUANITY >< msdyn_shippingcanceldecrementloadquantity
WILLWAREHOUSELOCATIONIDINCLUDEBINIDBYDEFAULT >< msdyn_warehouselocationidincludeblindid
WILLWAREHOUSELOCATIONIDINCLUDERACKIDBYDEFAULT >< msdyn_warehouselocationincluderackidbydefault
WILLWAREHOUSELOCATIONIDINCLUDESHELFIDBYDEFAULT >< msdyn_warehouselocationidincludeshelfid