注释
社区兴趣团体现已从 Yammer 迁移到Microsoft Viva Engage。 若要加入 Viva Engage 社区并参与最新讨论，请填写 “请求访问财务和运营 Viva Engage 社区 ”表单，然后选择要加入的社区。
映射表
映射类型
有多种不同的映射类型。 下表说明了模板表中使用的符号。
| 符号 | Description |
|---|---|
| > | 单向 |
| >> | 单向数据正在进程中转换。 |
| = | 双向 |
| >< | 双向数据正在进程中转换。 |
| << | 单向数据正在进程中转换。 |
过滤 器
源筛选器和反向源筛选器确定同步的行。
默认值
如果财务和运营表或客户参与表中不存在同步字段，则会在同步表中分配默认值。 在某些情况下，默认值是一个整数，用于查找 Dataverse 中的属性值。 例如，在 Contact 表中， address1AddressTypeCode 的默认值为 3 （主地址）。
模板
| 财务和运营应用 | Customer engagement 应用 | Description |
|---|---|---|
| 所有产品 | msdyn_globalproducts | |
| 资产管理资产生命周期模型 | msdyn_assetlifecyclemodels | |
| 资产管理资产生命周期状态 | msdyn_assetlifecyclestates | |
| 资产管理资产类型 | msdyn_customerassetcategories | |
| 资产管理资产 | msdyn_customerassets | |
| 资产管理功能位置生命周期模型 | msdyn_functionallocationlifecyclemodels | |
| 资产管理功能位置生命周期状态 | msdyn_functionallocationlifecyclestates | |
| 资产管理功能位置类型 | msdyn_functionallocationtypes | |
| 资产管理功能位置 | msdyn_functionallocations | |
| 资产管理制造商 | msdyn_manufacturers | |
| 资产管理模型 | msdyn_models | |
| 资产管理保修 | msdyn_warranties | |
| CDS 联系人 V2 | 联系人 | |
| CDS 汇率 | msdyn_currencyexchangerates | |
| CDS 参与方 | msdyn_parties | |
| CDS 群邮政地址位置 | msdyn_partypostaladdresses | |
| CDS 清单手动条目 | msdyn_inventoryonhandentries | |
| CDS 清单手动请求 | msdyn_inventoryonhandrequests | |
| CDS 邮政地址历史记录 V2 | msdyn_postaladdresses | |
| CDS 邮政地址位置 | msdyn_postaladdresscollections | |
| CDS 采购订单行实体 | msdyn_purchaseorderproducts | |
| CDS 采购订单行软删除实体 | msdyn_purchaseorderproducts | |
| CDS 发布的不同产品 | products | |
| CDS 销售订单标题 | salesorders | |
| CDS 销售订单行 | salesorderdetails | |
| CDS 销售报价标题 | 询价 | |
| CDS 销售报价行 | quotedetails | |
| 帐户图表 | msdyn_chartofaccountses | |
| Colors | msdyn_productcolors | |
| 补偿作业功能 | cdm_jobfunctions | |
| 补偿作业类型 | cdm_jobtypes | |
| 免费闭幕式 | msdyn_complimentaryclosings | |
| 配置 | msdyn_productconfigurations | |
| 联系人标题 | msdyn_salescontactpersontitles | |
| 联系人 V2 | msdyn_contactforparties | |
| 货币 | transactioncurrencies | |
| 客户附件 | 注释 | |
| 客户组 | msdyn_customergroups | |
| 客户层次结构 | msdyn_customerhierarchies | |
| 客户层次结构节点 | msdyn_customerhierarchynodes | |
| 客户付款方式 | msdyn_customerpaymentmethods | |
| 客户 V3 | accounts | |
| 客户 V3 | 联系人 | |
| 决策角色 | msdyn_decisionmakingroles | |
| 默认订单设置 | msdyn_productdefaultordersettings | |
| DV 发布的不同产品 | products | |
| DV 已发布的产品 | msdyn_sharedproductdetails | |
| Dynamics 365 Sales 功能管理状态 | msdyn_supplychainfeaturestates | |
| Dynamics 365 Sales 订单标头 | salesorders | |
| Dynamics 365 Sales 订单行 | salesorderdetails | |
| Dynamics 365 Sales 报价单标头 | 询价 | |
| Dynamics 365 Sales 报价单行 | quotedetails | |
| 就业工作职能 | msdyn_employmentjobfunctions | |
| 每家公司的就业人数 | cdm_employments | |
| 民族起源 | cdm_ethnicorigins | |
| 汇率货币对 | msdyn_currencyexchangeratepairs | |
| 汇率类型 | msdyn_exchangeratetypes | |
| 财务维度格式 | msdyn_financialdimensionformats | |
| 财务维度 | msdyn_dimensionattributes | |
| 会计日历集成实体 | msdyn_fiscalcalendars | |
| 会计日历周期 | msdyn_fiscalcalendarperiods | |
| 会计日历年集成实体 | msdyn_fiscalcalendaryears | |
| 清单过道 | msdyn_warehouseaisles | |
| 项目销售税组 | msdyn_taxitemgroups | |
| 作业 | cdm_jobs | |
| 语言代码 | cdm_languages | |
| 账本 | msdyn_ledgers | |
| 法律实体 | cdm_companies | |
| 法律实体 | msdyn_internalorganizations | |
| 会员卡 | msdyn_loyaltycards | |
| 忠诚级别 | msdyn_loyaltylevels | |
| 忠诚奖励积分 | msdyn_loyaltyrewardpoints | |
| 主科目 | msdyn_mainaccounts | |
| 主帐户类别 | msdyn_mainaccountcategories | |
| 混合现实指南实体 | msmrw_guides | |
| 交付模式 | msdyn_shipvias | |
| 名称 affixes | msdyn_nameaffixes | |
| 作单元 | msdyn_internalorganizations | |
| 组织层次结构 - 已发布 | msdyn_internalorganizationhierarchies | |
| 组织层次结构用途 | msdyn_internalorganizationhierarchypurposes | |
| 组织层次结构类型 | msdyn_internalorganizationhierarchytypes | |
| 群联系人 V3 | msdyn_partyelectronicaddresses | |
| 付款日行 CDS V2 | msdyn_paymentdaylines | |
| 付款日 CDS | msdyn_paymentdays | |
| 付款计划 | msdyn_paymentschedules | |
| 付款计划行 | msdyn_paymentschedulelines | |
| 个人字符类型 | msdyn_personalcharactertypes | |
| 职位类型 | cdm_positiontypes | |
| 定位辅助角色分配 | cdm_positionworkerassignmentmaps | |
| 位置 V2 | cdm_jobpositions | |
| 价格客户组 | msdyn_pricecustomergroups | |
| 已标识的条形码的产品名称 | msdyn_productbarcodes | |
| 产品类别 | msdyn_productcategories | |
| 产品类别分配 | msdyn_productcategoryassignments | |
| 产品类别层次结构 | msdyn_productcategoryhierarchies | |
| 产品类别层次结构角色 | msdyn_productcategoryhierarchyroles | |
| 产品默认订单设置 V2 | msdyn_productspecificdefaultordersettings | |
| 产品维度组 | msdyn_productdimensiongroups | |
| 产品主控颜色 | msdyn_sharedproductcolors | |
| 产品主配置 | msdyn_sharedproductconfigurations | |
| 产品主控形状大小 | msdyn_sharedproductsizes | |
| 产品母版样式 | msdyn_sharedproductstyles | |
| 物料收货标题 | msdyn_purchaseorderreceipts | |
| 物料收货行 | msdyn_purchaseorderreceiptproducts | |
| 特定于产品的单位转换 | msdyn_productspecificunitofmeasureconversions | |
| 前景 | 导致 | |
| 采购订单头文档附件 | 注释 | |
| 采购订单标头 V2 | msdyn_purchaseorders | |
| 已发布产品 V2 | msdyn_sharedproductdetails | |
| 销售账单抬头 V2 | 发票 | |
| 销售账单行 V2 | invoicedetails | |
| 销售订单头文档附件 | 注释 | |
| 销售订单来源代码 | msdyn_salesorderorigins | |
| 销售税主管机构 | msdyn_taxauthorities | |
| 销售税免税代码实体 CDS | msdyn_taxexemptcodes | |
| 销售税组 | msdyn_taxgroups | |
| 销售税账本发布组 V2 | msdyn_taxpostinggroups | |
| 打招呼 | msdyn_salutations | |
| 网站 | msdyn_operationalsites | |
| 大小 | msdyn_productsizes | |
| 存储维度组 | msdyn_productstoragedimensiongroups | |
| 样式 | msdyn_productstyles | |
| 交付条款 | msdyn_termsofdeliveries | |
| 付款条款 | msdyn_paymentterms | |
| 跟踪维度组 | msdyn_producttrackingdimensiongroups | |
| 单位转换 | msdyn_unitofmeasureconversions | |
| 单位 | uoms | |
| 供应商单据附件 | 注释 | |
| 供应商组 | msdyn_vendorgroups | |
| 供应商付款方式 | msdyn_vendorpaymentmethods | |
| 供应商 V2 | msdyn_vendors | |
| 退伍军人状态 | cdm_veteranstatuses | |
| 仓库位置 | msdyn_inventorylocations | |
| 仓库工作标头 | msdyn_warehouseworkheaders | |
| 仓库工作线 | msdyn_warehouseworklines | |
| 仓库区域组 | msdyn_warehousezonegroups | |
| 仓库区域 | msdyn_warehousezones | |
| 仓库 | msdyn_warehouses | |
| 预扣税税代码 | msdyn_withholdingtaxcodes | |
| 预扣税组 | msdyn_withholdingtaxgroups | |
| 辅助角色 | cdm_workers |
所有产品（msdyn_globalproducts）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PRODUCTNAME | > | msdyn_productname | |
| PRODUCTNUMBER | > | msdyn_productnumber |
资产管理资产生命周期模型（msdyn_assetlifecyclemodels）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| ACTIVELIFECYCLESTATEID | = | msdyn_activelifecyclestate.msdyn_assetlifecyclestate_id | |
| INBOUNDLIFECYCLESTATEID | = | msdyn_inboundlifecyclestate.msdyn_assetlifecyclestate_id | |
| INSTORAGELIFECYCLESTATEID | = | msdyn_instoragelifecyclestate.msdyn_assetlifecyclestate_id | |
| LIFECYCLEMODELID | = | msdyn_assetlifecyclemodel_id | |
| 名称 | = | msdyn_name | |
| ONLOANLIFECYCLESTATEID | = | msdyn_onloanlifecyclestate.msdyn_assetlifecyclestate_id | |
| OUTBOUNDLIFECYCLESTATEID | = | msdyn_outboundlifecyclestate.msdyn_assetlifecyclestate_id | |
| RECEIVEDLIFECYCLESTATEID | = | msdyn_receivedlifecyclestate.msdyn_assetlifecyclestate_id |
资产管理资产生命周期状态（msdyn_assetlifecyclestates）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| DELETEOPENCALENDARLINES | ><yes : Trueno : False |
msdyn_deleteopencalendarlines | |
| LIFECYCLESTATEID | = | msdyn_assetlifecyclestate_id | |
| LINE | = | msdyn_line | |
| MAINTENANCEASSETACTIVE | ><yes : Trueno : False |
msdyn_maintenanceassetactive | |
| 名称 | = | msdyn_name |
资产管理资产类型（msdyn_customerassetcategories）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| LIFECYCLEMODELID | = | msdyn_lifecyclemodel.msdyn_assetlifecyclemodel_id | |
| MAINTENANCEASSETTYPEID | = | msdyn_maintenanceassettypeid | |
| 名称 | = | msdyn_name | |
| CALCULATEKPITOTAL | ><no : Falseyes : True |
msdyn_calculatekpitotal |
资产管理资产（msdyn_customerassets）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 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 | |
| 名称 | = | msdyn_name | |
| 笔记 | = | msdyn_notes | |
| PURCHASEORDERID | = | msdyn_purchaseorderid | |
| REPLACEMENTDATE | ><1/1/1900 ：空白 |
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 |
资产管理功能位置生命周期模型（msdyn_functionallocationlifecyclemodels）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| LIFECYCLEMODELID | = | msdyn_functionallocationlifecyclemodel_id | |
| 名称 | = | msdyn_name |
资产管理功能位置生命周期状态（msdyn_functionallocationlifecyclestates）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| ALLOWDELETELOCATION | ><yes : Trueno : False |
msdyn_allowdeletelocation | |
| ALLOWNEWSUBLOCATIONS | ><yes : Trueno : False |
msdyn_allownewsublocations | |
| ALLOWRENAMELOCATION | ><yes : Trueno : False |
msdyn_allowrenamelocation | |
| FUNCTIONALLOCATIONACTIVE | ><yes : Trueno : False |
msdyn_functionallocationactive | |
| LIFECYCLESTATEID | = | msdyn_functionallocationlifecyclestate_id | |
| 名称 | = | msdyn_name | |
| ALLOWINSTALLMAINTENANCEASSETS | ><yes : Trueno : False |
msdyn_allowinstallmaintenanceassets | |
| CREATELOCATIONMAINTENANCEASSET | ><yes : Trueno : False |
msdyn_createlocationmaintenanceasset | |
| MAINTENANCEASSETLIFECYCLESTATEID | = | msdyn_assetlifecyclestate.msdyn_assetlifecyclestate_id |
资产管理功能位置类型（msdyn_functionallocationtypes）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| ALLOWMULTIPLEINSTALLEDASSETS | ><yes : Trueno : False |
msdyn_allowmultipleinstalledassets | |
| FUNCTIONALLOCATIONTYPEID | = | msdyn_functionallocationtype_id | |
| 名称 | = | msdyn_name | |
| UPDATEASSETDIMENSION | ><yes : Trueno : False |
msdyn_updateassetdimension | |
| LIFECYCLEMODELID | = | msdyn_lifecyclemodelid.msdyn_functionallocationlifecyclemodel_id | |
| MAINTENANCEASSETTYPEID | = | msdyn_maintenanceassettype.msdyn_maintenanceassettypeid |
资产管理功能位置（msdyn_functionallocations）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| FUNCTIONALLOCATIONID | = | msdyn_functionallocation_id | |
| INVENTORYLOCATIONID | = | msdyn_inventorylocationid | |
| INVENTORYSITEID | = | msdyn_inventorysiteid | |
| 名称 | = | msdyn_name | |
| 笔记 | = | msdyn_notes | |
| PARENTFUNCTIONALLOCATIONID | = | msdyn_parentfunctionallocation.msdyn_functionallocation_id | |
| FUNCTIONALLOCATIONLIFECYCLESTATEID | = | msdyn_functionallocationlifecyclestate.msdyn_functionallocationlifecyclestate_id | |
| FUNCTIONALLOCATIONTYPEID | = | msdyn_functionallocationtype.msdyn_functionallocationtype_id |
资产管理制造商（msdyn_manufacturers）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 描述 | = | msdyn_description | |
| PRODUCTID | = | msdyn_manufacturer_id |
资产管理模型（msdyn_models）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 描述 | = | msdyn_description | |
| MODELID | = | msdyn_model_id | |
| PRODUCTID | = | msdyn_manufacturer.msdyn_manufacturer_id | |
| MAINTENANCEASSETTYPEID | = | msdyn_maintenanceassettype.msdyn_maintenanceassettypeid |
资产管理保修（msdyn_warranties）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 名称 | = | msdyn_name | |
| WARRANTYID | = | msdyn_warranty_id |
CDS 联系人 V2（联系人）
此模板在财务和运营应用与 Dataverse 之间同步数据。
源筛选器：（AssociatedContactType = 1）
反向源筛选器：msdyn_contactforvendor eq true 和 msdyn_sellable eq false，msdyn_contactpersonid ne null
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CONTACTPERSONPARTYNUMBER | = | msdyn_partyid.msdyn_partynumber | |
| ASSOCIATEDCONTACTTYPE | << | none | 供应商 |
| ASSOCIATEDCONTACTNUMBER | = | msdyn_vendorcontactid.msdyn_vendoraccountnumber | |
| EMPLOYMENTDEPARTMENT | = | 部门 | |
| 笔记 | = | 描述 | |
| GOVERNMENTIDENTIFICATIONNUMBER | = | governmentid | |
| ISRECEIVINGDIRECTMAIL | ><no : Falseyes : True |
donotemail | |
| SPOUSENAME | = | spousesname | |
| none | >> | msdyn_contactforvendor | True |
| CONTACTPERSONID | = | msdyn_contactpersonid |
CDS 汇率（msdyn_currencyexchangerates）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| EXCHANGERATETYPENAME | > | msdyn_currencyexchangeratepair.msdyn_currencyexchangeratetypeid.msdyn_name | |
| FROMCURRENCYCODE | > | msdyn_currencyexchangeratepair.msdyn_fromtransactioncurrencyid.isocurrencycode | |
| TOCURRENCYCODE | > | msdyn_currencyexchangeratepair.msdyn_totransactioncurrencyid.isocurrencycode | |
| 率 | > | msdyn_exchangerate | |
| VALIDFROM | > | msdyn_validfrom | |
| VALIDTO | > | msdyn_validto |
CDS 各方（msdyn_parties）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PARTYNUMBER | = | msdyn_partynumber | |
| PARTYTYPE | ><person : 192350001organization : 192350002legalEntity : 192350003team : 192350004operatingUnit : 192350005none : 192350000 |
msdyn_partytype | |
| NAMEALIAS | = | msdyn_namealias | |
| KNOWNAS | = | msdyn_nickname | |
| LANGUAGEID | ><ar : 192350000ar-ae : 192350001en-us : 192350015en-gb : 192350009cs : 192350002da : 192350003de : 192350004de-at : 192350005de-ch : 192350006en-au : 192350007en-ca : 192350008en-ie : 192350010en-in : 192350011en-my : 192350012en-nz : 192350013en-sg : 192350014en-za : 192350016es : 192350017es-mx : 192350018et : 192350019fi : 192350020fr : 192350021fr-be : 192350022fr-ca : 192350023fr-ch : 192350024hu : 192350025is : 192350026it : 192350027it-ch : 192350028ja : 192350029lt : 192350030lv : 192350031nb-no : 192350032nl : 192350033nl-be : 192350034pl : 192350035pt-br : 192350036ru : 192350037sv : 192350038th : 192350039tr : 192350040zh-hans : 192350041 |
msdyn_language | |
| ORGANIZATIONNAME | = | msdyn_organizationname | |
| ORGANIZATIONABCCODE | ><a : 192350000b : 192350001c : 192350002none : 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 : 1female : 2non-Specific : 192350000unknown : 192350001 |
msdyn_gender | |
| PERSONMARITALSTATUS | ><single : 1married : 2divorced : 3widowhood : 4none : 192350000 |
msdyn_maritalstatus | |
| PERSONHOBBIES | = | msdyn_hobbies | |
| PERSONCHILDRENNAMES | = | msdyn_childrennames | |
| PERSONANNIVERSARYDAY | = | msdyn_anniversaryday | |
| PERSONANNIVERSARYYEAR | = | msdyn_anniversaryyear | |
| PERSONBIRTHDAY | = | msdyn_birthday | |
| PERSONBIRTHYEAR | = | msdyn_birthyear | |
| PERSONANNIVERSARYMONTH | ><january : 1february : 2march : 3none : 0april : 4may : 5june : 6july : 7august : 8september : 9october : 10november : 11december : 12 |
msdyn_anniversarymonth | |
| PERSONBIRTHMONTH | ><none : 0january : 1february : 2march : 3april : 4may : 5june : 6july : 7august : 8september : 9october : 10november : 11december : 12 |
msdyn_birthmonth |
CDS Party 邮政地址位置（msdyn_partypostaladdresses）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| ISPRIMARY | ><no : Falseyes : True |
msdyn_isprimary | |
| LOCATIONID | = | msdyn_postaladdresscollectionid.msdyn_location | |
| PARTYNUMBER | = | msdyn_partyid.msdyn_partynumber | |
| 目的 | = | msdyn_postaladdresspurposenames | |
| ISLOCATIONOWNER | >>no : Falseyes : True |
msdyn_islocationowner |
CDS 库存现场条目（msdyn_inventoryonhandentries）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 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 手动清单请求（msdyn_inventoryonhandrequests）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| REQUESTID | = | msdyn_requestid | |
| PRODUCTNUMBER | < | msdyn_product.msdyn_productnumber | |
| ISATPCALCULATION | <<no : Falseyes : True |
msdyn_isatpcalculation | |
| ORDERQUANTITY | < | msdyn_orderquantity | |
| INVENTORYSITEID | < | msdyn_inventorysite.msdyn_siteid | |
| INVENTORYWAREHOUSEID | < | msdyn_inventorywarehouse.msdyn_warehouseidentifier | |
| REFERENCENUMBER | < | msdyn_referencenumber | |
| LINECREATIONSEQUENCENUMBER | < | msdyn_linecreationsequencenumber |
CDS 邮政地址历史记录 V2 （msdyn_postaladdresses）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| LOCATIONID | = | msdyn_postaladdresscollectionid.msdyn_location | |
| VALIDFROM | = | msdyn_validfrom | |
| VALIDTO | = | msdyn_validto | |
| 描述 | = | msdyn_name | |
| 街 | = | 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 | |
| 邮箱 | = | msdyn_postbox |
CDS 邮政地址位置（msdyn_postaladdresscollections）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 描述 | = | msdyn_description | |
| LOCATIONID | = | msdyn_location |
CDS 采购订单行实体（msdyn_purchaseorderproducts）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 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 | |
| 条形码 | = | msdyn_barcode | |
| CATCHWEIGHTUNITSYMBOL | = | msdyn_catchweightunitsymbol.msdyn_symbol | |
| CONFIRMEDSHIPPINGDATE | = | msdyn_confirmedshippingdate | |
| CUSTOMERREFERENCE | = | msdyn_customerreference | |
| CUSTOMERREQUISITIONNUMBER | = | msdyn_customerrequisitionnumber | |
| EXTERNALITEMNUMBER | = | msdyn_externalitemnumber | |
| ISPARTIALDELIVERYPREVENTED | ><yes : trueno : false |
msdyn_ispartialdeliveryprevented | |
| LINEDISCOUNTAMOUNT | > | msdyn_linediscountamount | |
| LINEDISCOUNTPERCENTAGE | > | msdyn_linediscountpercentage | |
| ORDEREDCATCHWEIGHTQUANTITY | = | msdyn_orderedcatchweightquantity | |
| PURCHASEORDERLINESTATUS | >>none : 192350000backorder : 192350001received : 192350002invoiced : 192350003canceled : 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 采购订单行软删除实体（msdyn_purchaseorderproducts）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| LINENUMBER | > | msdyn_lineorder | |
| PURCHASEORDERNUMBER | > | msdyn_purchaseorder.msdyn_name | |
| ISDELETED | >>yes : trueno : false |
msdyn_issoftdeletedinscm |
CDS 发布了不同的产品（产品）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PRODUCTNUMBER | > | msdyn_productnumber | |
| PRODUCTNAME | > | 姓名 | |
| PRODUCTDESCRIPTION | > | 描述 | |
| ITEMNUMBER | > | msdyn_itemnumber | |
| CURRENCYCODE | > | transactioncurrencyid.isocurrencycode | |
| SALESUNITSYMBOL | > | defaultuomid.msdyn_symbol | |
| SALESPRICE | > | 价格 | |
| UNITCOST | > | currentcost | |
| PRODUCTTYPE | >>item : 1service : 3 |
producttypecode | |
| SALESUNITDECIMALPRECISION | >> | quantitydecimal | 0 |
| ISCATCHWEIGHTPRODUCT | >>no : falseyes : true |
msdyn_iscatchweight | |
| ISSTOCKEDPRODUCT | >>no : Falseyes : 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 : 690970000NonInventory : 690970001Service : 690970002 |
msdyn_fieldserviceproducttype | |
| [无] | >> | msdyn_shouldsyncwithsharedproductdetails | 假 |
CDS 销售订单标头 (salesorders)
此模板在财务和运营应用与 Dataverse 之间同步数据。
反向源筛选器：msdyn_ordertype eq 192350000
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| SALESORDERNUMBER | = | msdyn_salesordernumber | |
| ORDERINGCUSTOMERACCOUNTNUMBER | = | customerid。Account（accountnumber）。联系人（msdyn_contactpersonid） | |
| CURRENCYCODE | = | transactioncurrencyid.isocurrencycode | |
| DELIVERYADDRESSCITY | = | shipto_city | |
| DELIVERYADDRESSCOUNTRYREGIONISOCODE | ><us : united statesde : germanyfr : francegb : united kingdomjp : japanin : indiaes : spainnz : new zealandau : australiaco : columbiaza : south africabe : belgiumca : canadaat : austriatr : türkiyecn : chinadk : denmarkse : swedenno : norwayfi : finlandeg : egypt |
shipto_country | |
| DELIVERYADDRESSSTREETNUMBER | = | shipto_line2 | |
| DELIVERYADDRESSZIPCODE | = | shipto_postalcode | |
| DELIVERYADDRESSSTREET | = | shipto_line1 | |
| DELIVERYADDRESSSTATEID | = | shipto_stateorprovince | |
| SALESORDERNAME | > | 姓名 | |
| 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 : Falseyes : 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 | |
| 电子邮件 | = | 电子邮件地址 | |
| 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）。联系人（msdyn_contactpersonid） | |
| ISDELIVERYADDRESSORDERSPECIFIC | ><no : Falseyes : True |
msdyn_isdeliveryaddressorderspecific | |
| ISDELIVERYADDRESSPRIVATE | ><no : Falseyes : True |
msdyn_isdeliveryaddressprivate | |
| ISINVOICEADDRESSPRIVATE | >>no : Falseyes : True |
msdyn_isinvoiceaddressprivate | |
| ISONETIMECUSTOMER | ><no : Falseyes : True |
msdyn_isonetimecustomer | |
| ISSALESPROCESSINGSTOPPED | ><no : Falseyes : 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 : 192350000salesLeadTime : 192350001atp : 192350002atpPlusIssueMargin : 192350003ctp : 192350004 |
msdyn_salesorderpromisingmethod | |
| URL | = | msdyn_url | |
| SALESORDERPROCESSINGSTATUS | ><active : 192350000confirmed : 192350001picked : 192350002partiallyDelivered : 192350003delivered : 192350004invoiced : 192350005partiallyInvoiced : 192350006canceled : 192350007 |
msdyn_processingstatus | |
| LANGUAGEID | ><ar : 192350000ar-ae : 192350001cs : 192350002da : 192350003de : 192350004de-at : 192350005de-ch : 192350006en-au : 192350007en-gb : 192350009en-ie : 192350010en-in : 192350011en-ca : 192350008en-my : 192350012en-nz : 192350013en-sg : 192350014en-us : 192350015en-za : 192350016es : 192350017es-mx : 192350018et : 192350019fi : 192350020fr : 192350021fr-be : 192350022fr-ca : 192350023fr-ch : 192350024hu : 192350025is : 192350026it : 192350027it-ch : 192350028ja : 192350029lt : 192350030lv : 192350031nb-no : 192350032nl : 192350033nl-be : 192350034pl : 192350035pt-br : 192350036ru : 192350037sv : 192350038th : 192350039tr : 192350040zh-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 销售订单行 (salesorderdetails)
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CURRENCYCODE | > | transactioncurrencyid.isocurrencycode | |
| DELIVERYADDRESSCITY | = | shipto_city | |
| DELIVERYADDRESSCOUNTRYREGIONISOCODE | ><us : united statesde : germanyfr : francegb : united kingdomjp : japanin : indiaes : spainnz : new zealandau : australiaco : columbiaza : south africabe : belgiumca : canadaat : austriatr : türkiyecn : chinadk : denmarkse : swedenno : norwayfi : finlandeg : egypt |
shipto_country | |
| DELIVERYADDRESSZIPCODE | = | shipto_postalcode | |
| DELIVERYADDRESSSTATEID | = | shipto_stateorprovince | |
| DELIVERYADDRESSSTREET | = | shipto_line1 | |
| DELIVERYADDRESSSTREETNUMBER | = | shipto_line2 | |
| LINEAMOUNT | > | extendedamount | |
| LINECREATIONSEQUENCENUMBER | = | sequencenumber | |
| ORDEREDSALESQUANTITY | = | 数量 | |
| PRODUCTNAME | = | 描述 | |
| PRODUCTNUMBER | = | productid.msdyn_productnumber | |
| SALESORDERNUMBER | = | salesorderid.msdyn_salesordernumber | |
| SALESUNITSYMBOL | = | uomid.msdyn_symbol | |
| TOTALDISCOUNTAMOUNT | = | manualdiscountamount | |
| TOTALTAXAMOUNT | > | 税款 | |
| SALESPRICE | = | priceperunit | |
| LINEAMOUNT | > | baseamount | |
| SALESPRODUCTCATEGORYNAME | = | msdyn_salesproductcategory.msdyn_name | |
| SALESPRODUCTCATEGORYHIERARCHYNAME | > | msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name | |
| ISDELIVERYADDRESSORDERSPECIFIC | ><no : Falseyes : True |
msdyn_isdeliveryaddressspecific | |
| ISDELIVERYADDRESSPRIVATE | ><no : Falseyes : True |
msdyn_isdeliveryaddressprivate | |
| ISLINESTOPPED | ><no : Falseyes : 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 : 192350000backorder : 192350001delivered : 192350002invoiced : 192350003canceled : 192350004 |
msdyn_linestatus | |
| SALESORDERPROMISINGMETHOD | ><none : 192350000salesLeadTime : 192350001atp : 192350002atpPlusIssueMargin : 192350003ctp : 192350004 |
msdyn_salesorderpromisingmethod | |
| SALESPRICEQUANTITY | = | msdyn_salespricequantity | |
| SHIPPINGSITEID | = | msdyn_shippingsite.msdyn_siteid | |
| SHIPPINGWAREHOUSEID | = | msdyn_shippingwarehouse.msdyn_warehouseidentifier | |
| none | >> | ispriceoverridden | 是 |
| TOTALCHARGESAMOUNT | > | msdyn_totalchargesamount | |
| DELIVERYMODECODE | = | msdyn_deliverymode.msdyn_name | |
| DELIVERYTERMSID | = | msdyn_deliveryterms.msdyn_termscode |
CDS 销售报价单标头 (quotes)
此模板在财务和运营应用与 Dataverse 之间同步数据。
反向源筛选器：msdyn_ordertype eq 192350000 和状态代码 eq 0
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| SALESQUOTATIONNUMBER | = | msdyn_quotenumber | |
| REQUESTINGCUSTOMERACCOUNTNUMBER | = | customerid。Account（accountnumber）。联系人（msdyn_contactpersonid） | |
| CURRENCYCODE | = | transactioncurrencyid.isocurrencycode | |
| CUSTOMERSREFERENCE | = | msdyn_customersreference | |
| DELIVERYADDRESSCITY | = | shipto_city | |
| DELIVERYADDRESSCOUNTRYREGIONISOCODE | ><us : united statesde : germanyfr : francegb : united kingdomjp : japanin : indiaes : spainnz : new zealandau : australiaco : columbiaza : south africabe : belgiumca : canadaat : austriatr : türkiyecn : chinadk : denmarkse : swedenno : norwayfi : finlandeg : egypt |
shipto_country | |
| DELIVERYADDRESSSTREETNUMBER | = | shipto_line2 | |
| DELIVERYADDRESSZIPCODE | = | shipto_postalcode | |
| DELIVERYADDRESSSTREET | = | shipto_line1 | |
| DELIVERYADDRESSSTATEID | = | shipto_stateorprovince | |
| SALESQUOTATIONNAME | = | 姓名 | |
| 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 : Falseyes : 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）。联系人（msdyn_contactpersonid） | |
| ISDELIVERYADDRESSORDERSPECIFIC | ><no : Falseyes : True |
msdyn_isdeliveryaddressorderspecific | |
| ISDELIVERYADDRESSPRIVATE | ><no : Falseyes : True |
msdyn_isdeliveryaddressprivate | |
| ISINVOICEADDRESSPRIVATE | >>no : Falseyes : True |
msdyn_isinvoiceaddressprivate | |
| LANGUAGEID | ><ar : 192350000ar-ae : 192350001cs : 192350002da : 192350003de : 192350004de-at : 192350005de-ch : 192350006en-au : 192350007en-gb : 192350009en-ie : 192350010en-in : 192350011en-ca : 192350008en-my : 192350012en-nz : 192350013en-sg : 192350014en-us : 192350015en-za : 192350016es : 192350017es-mx : 192350018et : 192350019fi : 192350020fr : 192350021fr-be : 192350022fr-ca : 192350023fr-ch : 192350024hu : 192350025is : 192350026it : 192350027it-ch : 192350028ja : 192350029lt : 192350030lv : 192350031nb-no : 192350032nl : 192350033nl-be : 192350034pl : 192350035pt-br : 192350036ru : 192350037sv : 192350038th : 192350039tr : 192350040zh-hans : 192350041 |
msdyn_language | |
| PAYMENTTERMSNAME | = | msdyn_paymentterms.msdyn_name | |
| PRICECUSTOMERGROUPCODE | = | msdyn_pricecustomergroup.msdyn_groupcode | |
| RECEIPTDATEREQUESTED | = | msdyn_requestedreceiptdate | |
| REQUESTEDSHIPPINGDATE | = | requestdeliveryby | |
| SALESORDERPROMISINGMETHOD | ><none : 192350000salesLeadTime : 192350001atp : 192350002atpPlusIssueMargin : 192350003ctp : 192350004 |
msdyn_salesorderpromisingmethod | |
| SALESQUOTATIONCONFIRMATIONDATE | = | msdyn_salesquotationconfirmationdate | |
| SALESQUOTATIONEXPIRYDATE | = | msdyn_salesquotationexpirydate | |
| SALESQUOTATIONFOLLOWUPDATE | = | msdyn_salesquotationfollowupdate | |
| SALESQUOTATIONSTATUS | ><created : 192350000sent : 192350001confirmed : 192350002lost : 192350003cancelled : 192350004reset : 192350005modified : 192350006submitted : 192350007approved : 192350008revised : 192350009 |
msdyn_salesquotationstatus | |
| TOTALDISCOUNTPERCENTAGE | = | msdyn_totaldiscountpercentage | |
| URL | = | msdyn_url | |
| 电子邮件 | = | 电子邮件地址 | |
| none | >> | msdyn_ordertype | 192350000 |
| CURRENCYCODE | > | msdyn_isocurrencycode | |
| OPERATINGUNITPARTYNUMBER | = | msdyn_operatingunit.msdyn_partynumber |
CDS 销售报价单行 (quotedetails)
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| ALLOWEDOVERDELIVERYPERCENTAGE | = | msdyn_allowedoverdeliverypercentage | |
| ALLOWEDUNDERDELIVERYPERCENTAGE | = | msdyn_allowedunderdeliverypercentage | |
| SALESQUOTATIONNUMBER | = | quoteid.msdyn_quotenumber | |
| LINECREATIONSEQUENCENUMBER | = | sequencenumber | |
| CURRENCYCODE | > | transactioncurrencyid.isocurrencycode | |
| DELIVERYADDRESSCITY | = | shipto_city | |
| DELIVERYADDRESSCOUNTRYREGIONISOCODE | ><us : united statesde : germanyfr : francegb : united kingdomjp : japanin : indiaes : spainnz : new zealandau : australiaco : columbiaza : south africabe : belgiumca : canadaat : austriatr : türkiyecn : chinadk : denmarkse : swedenno : norwayfi : finlandeg : 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 : Falseyes : True |
msdyn_isdeliveryaddressprivate | |
| ISDELIVERYADDRESSORDERSPECIFIC | ><no : Falseyes : True |
msdyn_isdeliveryaddressspecific | |
| LINEAMOUNT | > | baseamount | |
| LINEAMOUNT | > | extendedamount | |
| LINEDESCRIPTION | = | msdyn_linedescription2 | |
| LINEDISCOUNTAMOUNT | = | msdyn_linediscountamount | |
| LINEDISCOUNTPERCENTAGE | = | msdyn_linediscountpercentage | |
| MULTILINEDISCOUNTAMOUNT | = | msdyn_multilinediscountamount | |
| MULTILINEDISCOUNTPERCENTAGE | = | msdyn_multilinediscountpercentage | |
| PRODUCTNAME | = | 描述 | |
| PRODUCTNUMBER | = | productid.msdyn_productnumber | |
| REQUESTEDRECEIPTDATE | = | msdyn_requestedreceiptdate | |
| REQUESTEDSALESQUANTITY | = | 数量 | |
| REQUESTEDSHIPPINGDATE | = | requestdeliveryby | |
| SALESPRICE | = | priceperunit | |
| SALESPRICEQUANTITY | = | msdyn_salespricequantity | |
| SALESQUOTATIONPROMISINGMETHOD | ><none : 192350000salesLeadTime : 192350001atp : 192350002atpPlusIssueMargin : 192350003ctp : 192350004 |
msdyn_salesquotationpromisingmethod | |
| SALESQUOTATIONSTATUS | ><created : 192350000sent : 192350001confirmed : 192350002lost : 192350003cancelled : 192350004reset : 192350005modified : 192350006submitted : 192350007approved : 192350008revised : 192350009 |
msdyn_salesquotationstatus | |
| SALESUNITSYMBOL | = | uomid.msdyn_symbol | |
| SHIPPINGSITEID | = | msdyn_shippingsite.msdyn_siteid | |
| SHIPPINGWAREHOUSEID | = | msdyn_shippingwarehouse.msdyn_warehouseidentifier | |
| TOTALCHARGESAMOUNT | > | msdyn_totalchargesamount | |
| TOTALDISCOUNTAMOUNT | = | manualdiscountamount | |
| TOTALTAXAMOUNT | > | 税款 | |
| SALESPRODUCTCATEGORYHIERARCHYNAME | > | msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name | |
| SALESPRODUCTCATEGORYNAME | = | msdyn_salesproductcategory.msdyn_name | |
| none | >> | ispriceoverridden | 是 |
帐户图表（msdyn_chartofaccountses）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 描述 | = | msdyn_description | |
| MAINACCOUNTMASK | = | msdyn_mainaccountmask | |
| CHARTOFACCOUNTS | = | msdyn_name |
颜色（msdyn_productcolors）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| COLORID | > | msdyn_productcolorname |
补偿工作职能 (cdm_jobfunctions)
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| JOBFUNCTIONID | = | cdm_name | |
| 描述 | = | cdm_description |
补偿工作类型 (cdm_jobtypes)
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| JOBTYPEID | = | cdm_name | |
| 描述 | = | cdm_description | |
| EXEMPTSTATUS | ><exempt : 754400000nonexempt : 754400001doesnotapply : 754400002 |
cdm_exemptstatus |
免费闭幕（msdyn_complimentaryclosings）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CLOSINGPHRASE | = | msdyn_closingphrase |
配置（msdyn_productconfigurations）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CONFIGURATIONID | > | msdyn_productconfiguration |
联系人标题（msdyn_salescontactpersontitles）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| JOBTITLE | = | msdyn_jobtitle | |
| JOBTITLEALIAS | = | msdyn_jobtitlealias |
联系人 V2 （msdyn_contactforparties）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 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 : 192350000personal : 192350001private : 192350002confidential : 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 : Falseyes : True |
msdyn_hasrequestedinternetaccess | |
| IDENTITYCARDNUMBER | = | msdyn_identitycardnumber | |
| ISRECEIVINGDIRECTMAIL | ><no : Falseyes : True |
msdyn_isreceivingdirectmail | |
| ISVIP | ><no : Falseyes : True |
msdyn_isvip | |
| LOYALTYLEVELPHRASE | = | msdyn_loyaltylevelphrase.msdyn_levelphrase | |
| MANAGERCONTACTPERSONID | = | msdyn_parentcontactforpartyid.msdyn_contactforpartynumber | |
| MICROSOFTOUTLOOKCATEGORIES | = | msdyn_microsoftoutlookcategories | |
| MILEAGEDISTANCE | = | msdyn_mileagedistance | |
| 笔记 | = | msdyn_notes | |
| ORGANIZATIONIDENTIFICATIONNUMBER | = | msdyn_organizationidentificationnumber | |
| PERSONALCHARACTERTYPECODE | = | msdyn_personalcharactertypecode.msdyn_typename | |
| PRIMARYCOMPLIMENTARYCLOSINGPHRASE | = | msdyn_primarycomplimentaryclosingphrase.msdyn_closingphrase | |
| CONTACTINFORMATIONLANGUAGEID | ><ar : 192350000ar-ae : 192350001cs : 192350002da : 192350003de : 192350004de-at : 192350005de-ch : 192350006en-au : 192350007en-gb : 192350009en-ie : 192350010en-in : 192350011en-ca : 192350008en-my : 192350012en-nz : 192350013en-sg : 192350014en-us : 192350015en-za : 192350016es : 192350017es-mx : 192350018et : 192350019fi : 192350020fr : 192350021fr-be : 192350022fr-ca : 192350023fr-ch : 192350024hu : 192350025is : 192350026it : 192350027it-ch : 192350028ja : 192350029lt : 192350030lv : 192350031nb-no : 192350032nl : 192350033nl-be : 192350034pl : 192350035pt-br : 192350036ru : 192350037sv : 192350038th : 192350039tr : 192350040zh-hans : 192350041 |
msdyn_nativelanguage | |
| SPOUSENAME | = | msdyn_spousename |
货币（交易货币）
此模板在财务和运营应用与 Dataverse 之间同步数据。
源筛选器：（CURRENCYCODE ！= “999”））
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CURRENCYCODE | = | isocurrencycode | |
| 名称 | = | currencyname | |
| 象征 | = | currencysymbol | |
| none | >> | exchangerate | 1.0000000000 |
客户附件（批注）
此模板在财务和运营应用与 Dataverse 之间同步数据。
源筛选器：（TypeId == “Note”） ||（TypeId == “URL”））
反向源筛选器：（objecttypecode eq 'account' 或 objecttypecode eq 'contact'） 和 msdyn_relatedentityid ne null
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| DOCUMENTID | = | msdyn_notesid | |
| 名称 | = | 主题 | |
| none | >> | objecttypecode | 帐户 |
| CUSTOMERACCOUNTNUMBER | = | msdyn_relatedentityid | |
| TYPEID | << | none | 注释 |
| 笔记 | = | notetext | |
| 限制 | ><internal : 0external : 1 |
msdyn_restriction |
客户组（msdyn_customergroups）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CUSTOMERGROUPID | = | msdyn_groupid | |
| 描述 | = | msdyn_description | |
| ISSALESTAXINCLUDEDINPRICE | ><no : Falseyes : True |
msdyn_issalestaxincludedinprice | |
| PAYMENTTERMID | = | msdyn_paymenttermid.msdyn_name | |
| CLEARINGPERIODPAYMENTTERMNAME | = | msdyn_clearingperiodpaymenttermname.msdyn_name |
客户层次结构（msdyn_customerhierarchies）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CUSTOMERHIERARCHYID | = | msdyn_customerhierarchynumber | |
| 名称 | = | msdyn_name | |
| ORGANIZATIONPARTYNUMBER | = | msdyn_organizationpartynumber.msdyn_partynumber | |
| 目的 | ><B2BOrganization : 192350000 |
msdyn_purpose |
客户层次结构节点（msdyn_customerhierarchynodes）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CUSTOMERHIERARCHYID | = | msdyn_customerhierarchynumber.msdyn_customerhierarchynumber | |
| NODEPARTYNUMBER | = | msdyn_nodepartynumber.msdyn_partynumber | |
| NODETYPE | ><Customer : 192350000 |
msdyn_nodetype | |
| ROLE | ><Admin : 192350000User : 192350001 |
msdyn_role |
客户付款方式（msdyn_customerpaymentmethods）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 名称 | = | msdyn_name | |
| ACCOUNTTYPE | ><ledger : 806380000cust : 806380001vend : 806380002project : 806380003fixedassets : 806380004bank : 806380005 |
msdyn_accounttype | |
| DISCOUNTGRACEPERIODDAYS | = | msdyn_discountgraceperioddays | |
| 桥接POSTINGENABLED | ><no : Falseyes : True |
msdyn_bridgingpostingenabled | |
| ISSEPA | ><no : Falseyes : True |
msdyn_issepa | |
| LASTFILENUMBER | = | msdyn_lastfilenumber | |
| LASTFILENUMBERTODAY | = | msdyn_lastfilenumbertoday | |
| 描述 | = | msdyn_description | |
| PAYMENTTYPE | ><other : 806380000electronicPayment : 806380001check : 806380002billOfExchange : 806380003creditCard : 806380004 |
msdyn_paymenttype | |
| CREATEANDDRAWBILLOFEXCHANGEDURINGINVOICEPOSTING | ><no : Falseyes : True |
msdyn_invoiceupdate | |
| PAYMENTSTATUS | ><none : 806380000sent : 806380001recieved : 806380002confirmed : 806380003rejected : 806380004 |
msdyn_paymentstatus | |
| SUMBYPERIOD | ><invoice : 806380000week : 806380002total : 806380003transDate : 806380001 |
msdyn_sumbyperiod | |
| ENABLEPOSTDATEDCHECKCLEARINGPOSTING | ><no : Falseyes : True |
msdyn_enablepostdatescheckclearingposting | |
| BILLOFEXCHANGEDRAFTTYPE | ><acceptance : 806380002promissory : 806380003bankAcceptance : 806380004nodraft : 806380000noacceptance : 806380001 |
msdyn_billofexchangedrafttype | |
| DIRECTDEBIT | ><no : Falseyes : True |
msdyn_directdebit |
客户 V3 (accounts)
此模板在财务和运营应用与 Dataverse 之间同步数据。
源筛选器：（PartyType == “Organization”））
反向源筛选器：customertypecode eq 3
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CUSTOMERACCOUNT | = | accountnumber | |
| CREDITLIMIT | = | creditlimit | |
| SALESCURRENCYCODE | = | transactioncurrencyid.isocurrencycode | |
| SALESMEMO | = | 描述 | |
| CREDITLIMITISMANDATORY | ><no : Falseyes : True |
msdyn_creditlimitismandatory | |
| CREDITRATING | = | msdyn_creditrating | |
| CUSTOMERGROUPID | = | msdyn_customergroupid.msdyn_groupid | |
| IDENTIFICATIONNUMBER | = | msdyn_identificationnumber | |
| INVOICEACCOUNT | = | msdyn_billingaccount.accountnumber | |
| ISONETIMECUSTOMER | ><no : Falseyes : True |
msdyn_onetimecustomer | |
| ONHOLDSTATUS | ><no : 806380000invoice : 806380001all : 806380002payment : 806380003requisition : 806380004never : 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 | 组织 |
| PARTYNUMBER | = | msdyn_partyid.msdyn_partynumber | |
| CONTACTPERSONID | = | msdyn_primarycontact.msdyn_contactforpartynumber | |
| SALESTAXGROUP | = | msdyn_salestaxgroup.msdyn_name |
客户 V3（联系人）
此模板在财务和运营应用与 Dataverse 之间同步数据。
源筛选器：（PartyType == “Person”））
反向源筛选器：msdyn_sellable eq true 和 msdyn_contactpersonid ne null
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| none | >> | msdyn_sellable | True |
| PARTYTYPE | << | none | 人员 |
| 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 | = | 描述 | |
| 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 |
决策角色（msdyn_decisionmakingroles）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| ROLEDESCRIPTION | = | msdyn_roledescription | |
| ROLENAME | = | msdyn_rolename |
默认顺序设置（msdyn_productdefaultordersettings）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 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 : Falseyes : True |
msdyn_areinventoryorderdefaultsoverridden | |
| INVENTORYORDERPROMISINGMETHOD | ><none : 192350000salesLeadTime : 192350001atp : 192350002atpPlusIssueMargin : 192350003ctp : 192350004 |
msdyn_inventoryorderpromisingmethod | |
| ISINVENTORYATPINCLUDINGPLANNEDORDERS | ><false : Falsetrue : True |
msdyn_isinventoryatpincludingplannedorders | |
| ISINVENTORYUSINGWORKINGDAYS | ><no : Falseyes : True |
msdyn_isinventoryusingworkingdays | |
| ISINVENTORYSITEMANDATORY | ><no : Falseyes : True |
msdyn_isinventorysitemandatory | |
| ISINVENTORYPROCESSINGSTOPPED | ><no : Falseyes : True |
msdyn_isinventoryprocessingstopped | |
| ISPROCUREMENTUSINGWORKINGDAYS | ><no : Falseyes : True |
msdyn_isprocurementusingworkingdays | |
| ISPROCUREMENTSITEMANDATORY | ><no : Falseyes : True |
msdyn_isprocurementsitemandatory | |
| ISPROCUREMENTPROCESSINGSTOPPED | ><no : Falseyes : True |
msdyn_isprocurementprocessingstopped | |
| ARESALESORDERPROMISINGDEFAULTSOVERRIDDEN | ><no : Falseyes : True |
msdyn_aresalesorderdefaultsoverridden | |
| SALESORDERPROMISINGMETHOD | ><none : 192350000salesLeadTime : 192350001atp : 192350002atpPlusIssueMargin : 192350003ctp : 192350004 |
msdyn_salesorderpromisingmethod | |
| ISSALESATPINCLUDINGPLANNEDORDERS | ><false : Falsetrue : True |
msdyn_issalesatpincludingplannedorders | |
| ISSALESSITEMANDATORY | ><no : Falseyes : True |
msdyn_issalessitemandatory | |
| ISSALESLEADTIMEOVERRIDDEN | ><no : Falseyes : True |
msdyn_issalesleadtimeoverridden | |
| ISSALESPROCESSINGSTOPPED | ><no : Falseyes : True |
msdyn_issalesprocessingstopped | |
| ISINVENTORYWAREHOUSEMANDATORY | ><no : Falseyes : True |
msdyn_isinventorywarehousemandatory | |
| ISPROCUREMENTWAREHOUSEMANDATORY | ><no : Falseyes : True |
msdyn_isprocurementwarehousemandatory | |
| ISSALESWAREHOUSEMANDATORY | ><no : Falseyes : True |
msdyn_issaleswarehousemandatory |
DV 发布了不同的产品（产品）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PRODUCTNUMBER | > | msdyn_productnumber | |
| PRODUCTNAME | > | 姓名 | |
| PRODUCTDESCRIPTION | > | 描述 | |
| ITEMNUMBER | > | msdyn_itemnumber | |
| PRODUCTTYPE | >>item : 1service : 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 | |
| [无] | >> | msdyn_shouldsyncwithsharedproductdetails | True |
DV 已发布的产品 （msdyn_sharedproductdetails）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PRODUCTNUMBER | > | msdyn_globalproduct.msdyn_productnumber | |
| INTRASTATCHARGEPERCENTAGE | > | msdyn_intrastatchargepercentage | |
| ITEMNUMBER | > | msdyn_itemnumber | |
| APPROXIMATESALESTAXPERCENTAGE | > | msdyn_approximatesalestaxpercentage | |
| BESTBEFOREPERIODDAYS | > | msdyn_bestbeforeperioddays | |
| CARRYINGCOSTABCCODE | >>none : 806380000a : 806380001b : 806380002c : 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 : Falseyes : True |
msdyn_isdiscountposregistrationprohibited | |
| ISEXEMPTFROMAUTOMATICNOTIFICATIONANDCANCELLATION | >>no : Falseyes : True |
msdyn_exemptautomaticnotificationcancel | |
| ISINSTALLMENTELIGIBLE | >>no : Falseyes : True |
msdyn_isinstallmenteligible | |
| ISINTERCOMPANYPURCHASEUSAGEBLOCKED | >>no : Falseyes : True |
msdyn_isintercompanypurchaseusageblocked | |
| ISINTERCOMPANYSALESUSAGEBLOCKED | >>no : Falseyes : True |
msdyn_isintercompanysalesusageblocked | |
| ISMANUALDISCOUNTPOSREGISTRATIONPROHIBITED | >>no : Falseyes : True |
msdyn_ismanualdiscposregistrationprohibited | |
| ISPHANTOM | >>no : Falseyes : True |
msdyn_isphantom | |
| ISPOSREGISTRATIONBLOCKED | >>no : Falseyes : True |
msdyn_isposregistrationblocked | |
| ISPOSREGISTRATIONQUANTITYNEGATIVE | >>no : Falseyes : True |
msdyn_isposregistrationquantitynegative | |
| ISPURCHASEPRICEAUTOMATICUPDATED | >>no : Falseyes : True |
msdyn_ispurchasepriceautomaticallyupdated | |
| ISPURCHASEPRICEINCLUDINGCHARGES | >>no : Falseyes : True |
msdyn_ispurchasepriceincludingcharges | |
| ISSALESWITHHOLDINGTAXCALCULATED | >>no : Falseyes : True |
msdyn_issaleswithholdingtaxcalculated | |
| ISRESTRICTEDFORCOUPONS | >>no : Falseyes : True |
msdyn_isrestrictedforcoupons | |
| ISSALESPRICEADJUSTMENTALLOWED | >>no : Falseyes : True |
msdyn_issalespriceadjustmentallowed | |
| ISSALESPRICEINCLUDINGCHARGES | >>no : Falseyes : True |
msdyn_issalespriceincludingcharges | |
| ISSCALEPRODUCT | >>no : Falseyes : True |
msdyn_isscaleproduct | |
| ISSHIPALONEENABLED | >>no : Falseyes : True |
msdyn_isshipaloneenabled | |
| ISUNITCOSTPRODUCTVARIANTSPECIFIC | >>no : Falseyes : True |
msdyn_isunitcostproductvariantspecific | |
| ISVARIANTSHELFLABELSPRINTINGENABLED | >>no : Falseyes : True |
msdyn_isvariantshelflabelsprintingenabled | |
| ISZEROPRICEPOSREGISTRATIONALLOWED | >>no : Falseyes : True |
msdyn_iszeropriceposregistrationallowed | |
| KEYINPRICEREQUIREMENTSATPOSREGISTER | >>notMandatory : 806380000newPrice : 806380001higherEqual : 806380002lowerEqual : 806380003noPrice : 806380004 |
msdyn_keyinpricerequirementsatposregister | |
| KEYINQUANTITYREQUIREMENTSATPOSREGISTER | >>notMandatory : 806380000keyIn : 806380001notKeyIn : 806380002 |
msdyn_keyinquantityrequirementsatposregister | |
| MARGINABCCODE | >>none : 806380000a : 806380001b : 806380002c : 806380003 |
msdyn_marginabccode | |
| MAXIMUMPICKQUANTITY | > | msdyn_maximumpickquantity | |
| MUSTKEYINCOMMENTATPOSREGISTER | >>no : Falseyes : 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 : 806380000quality : 806380001 |
msdyn_potencybaseattributevalueentryevent | |
| PRODUCTTYPE | >>item : 806380001service : 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 : 806380000orderPicking : 806380001 |
msdyn_rawmaterialpickingprinciple | |
| SALESCHARGESQUANTITY | > | msdyn_saleschargesquantity | |
| SALESOVERDELIVERYPERCENTAGE | > | msdyn_salesoverdeliverypercentage | |
| SALESPRICE | > | msdyn_salesprice | |
| SALESPRICECALCULATIONCHARGESPERCENTAGE | > | msdyn_salespricecalculationchargespercentage | |
| SALESPRICECALCULATIONCONTRIBUTIONRATIO | > | msdyn_salespricecalculationcontributionratio | |
| SALESPRICECALCULATIONMODEL | >>none : 806380000contributionratio : 806380001percentMarkup : 806380002 |
msdyn_salespricecalculationmodel | |
| SALESPRICEDATE | > | msdyn_salespricedate | |
| SALESPRICINGPRECISION | > | msdyn_salespricingprecision | |
| SALESUNDERDELIVERYPERCENTAGE | > | msdyn_salesunderdeliverypercentage | |
| SALESUNITSYMBOL | > | msdyn_salesunitsymbol.msdyn_symbol | |
| SCALEINDICATOR | >>relevant : 806380000notRelevant : 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 : Falseyes : True |
msdyn_willinventoryissueautoreportasfinished | |
| WILLINVENTORYRECEIPTIGNOREFLUSHINGPRINCIPLE | >>no : Falseyes : True |
msdyn_willinventoryreceiptignoreflushing | |
| WILLPICKINGWORKBENCHAPPLYBOXINGLOGIC | >>no : Falseyes : True |
msdyn_willpickingworkbenchapplyboxinglogic | |
| WILLTOTALPURCHASEDISCOUNTCALCULATIONINCLUDEPRODUCT | >>no : Falseyes : True |
msdyn_willtotalpurchdiscountcalcincludeproduct | |
| WILLTOTALSALESDISCOUNTCALCULATIONINCLUDEPRODUCT | >>no : Falseyes : True |
msdyn_willtotalsalesdiscountcalcincludeproduct | |
| WILLWORKCENTERPICKINGALLOWNEGATIVEINVENTORY | >>no : Falseyes : True |
msdyn_willworkcenterpickingallownegativeinvent | |
| YIELDPERCENTAGE | > | msdyn_yieldpercentage | |
| ISUNITCOSTAUTOMATICALLYUPDATED | >>no : Falseyes : True |
msdyn_isunitcostautomaticallyupdated | |
| PURCHASEUNITSYMBOL | > | msdyn_purchaseunitsymbol.msdyn_symbol | |
| PURCHASEPRICEQUANTITY | > | msdyn_purchasepricequantity | |
| ISUNITCOSTINCLUDINGCHARGES | >>no : Falseyes : 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 : Falseyes : 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 : Falseyes : True |
msdyn_isstockedproduct | |
| FIELDSERVICEPRODUCTTYPE | >>Inventory : 690970000NonInventory : 690970001Service : 690970002 |
msdyn_fieldserviceproducttype | |
| CURRENCYCODE | > | msdyn_transactioncurrencyid.isocurrencycode | |
| [无] | >> | msdyn_shouldsyncwithproducts | True |
Dynamics 365 Sales 功能管理状态 (msdyn_supplychainfeaturestates)
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 名称 | = | msdyn_name | |
| ISENABLED | ><no : 1yes : 0 |
statecode |
Dynamics 365 Sales 订单标头 (salesorders)
此模板在财务和运营应用与 Dataverse 之间同步数据。
反向源筛选器：msdyn_ordertype eq 192350000 和 msdyn_isreadytosync eq true
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| SALESORDERNUMBER | = | msdyn_salesordernumber | |
| ORDERINGCUSTOMERACCOUNTNUMBER | = | customerid。Account（accountnumber）。联系人（msdyn_contactpersonid） | |
| CURRENCYCODE | = | transactioncurrencyid.isocurrencycode | |
| DELIVERYADDRESSCITY | = | shipto_city | |
| DELIVERYADDRESSCOUNTRYREGIONISOCODE | ><us : united statesde : germanyfr : francegb : united kingdomjp : japanin : indiaes : spainnz : new zealandau : australiaco : columbiaza : south africabe : belgiumca : canadaat : austriatr : turkeycn : chinadk : denmarkse : swedenno : norwayfi : finlandeg : egypt |
shipto_country | |
| DELIVERYADDRESSSTREETNUMBER | = | shipto_line2 | |
| DELIVERYADDRESSZIPCODE | = | shipto_postalcode | |
| DELIVERYADDRESSSTREET | = | shipto_line1 | |
| DELIVERYADDRESSSTATEID | = | shipto_stateorprovince | |
| SALESORDERNAME | > | 姓名 | |
| 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 : Falseyes : 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 | |
| 电子邮件 | = | 电子邮件地址 | |
| 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）。联系人（msdyn_contactpersonid） | |
| ISDELIVERYADDRESSORDERSPECIFIC | ><no : Falseyes : True |
msdyn_isdeliveryaddressorderspecific | |
| ISDELIVERYADDRESSPRIVATE | ><no : Falseyes : True |
msdyn_isdeliveryaddressprivate | |
| ISINVOICEADDRESSPRIVATE | >>no : Falseyes : True |
msdyn_isinvoiceaddressprivate | |
| ISONETIMECUSTOMER | ><no : Falseyes : True |
msdyn_isonetimecustomer | |
| ISSALESPROCESSINGSTOPPED | ><no : Falseyes : 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 : 192350000salesLeadTime : 192350001atp : 192350002atpPlusIssueMargin : 192350003ctp : 192350004 |
msdyn_salesorderpromisingmethod | |
| URL | = | msdyn_url | |
| SALESORDERPROCESSINGSTATUS | ><active : 192350000confirmed : 192350001picked : 192350002partiallyDelivered : 192350003delivered : 192350004invoiced : 192350005partiallyInvoiced : 192350006canceled : 192350007deliveredPartiallyInvoiced : 192350008 |
msdyn_processingstatus | |
| LANGUAGEID | ><ar : 192350000ar-ae : 192350001cs : 192350002da : 192350003de : 192350004de-at : 192350005de-ch : 192350006en-au : 192350007en-gb : 192350009en-ie : 192350010en-in : 192350011en-ca : 192350008en-my : 192350012en-nz : 192350013en-sg : 192350014en-us : 192350015en-za : 192350016es : 192350017es-mx : 192350018et : 192350019fi : 192350020fr : 192350021fr-be : 192350022fr-ca : 192350023fr-ch : 192350024hu : 192350025is : 192350026it : 192350027it-ch : 192350028ja : 192350029lt : 192350030lv : 192350031nb-no : 192350032nl : 192350033nl-be : 192350034pl : 192350035pt-br : 192350036ru : 192350037sv : 192350038th : 192350039tr : 192350040zh-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 订单行 (salesorderdetails)
此模板在财务和运营应用与 Dataverse 之间同步数据。
反向源筛选器：
- 版本 1.x.x.x：msdyn_isreadytosync eq true
（在未安装项目运营或现场服务解决方案的供应链解决方案的上下文中使用。 - 版本 2.x.x.x：（msdyn_linetype ne 690970000 或 msdyn_linetype eq null）和 msdyn_isreadytosync eq true
（在已安装的供应链解决方案和项目运营或现场服务解决方案的上下文中使用。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CURRENCYCODE | > | transactioncurrencyid.isocurrencycode | |
| DELIVERYADDRESSCITY | = | shipto_city | |
| DELIVERYADDRESSCOUNTRYREGIONISOCODE | ><us : united statesde : germanyfr : francegb : united kingdomjp : japanin : indiaes : spainnz : new zealandau : australiaco : columbiaza : south africabe : belgiumca : canadaat : austriatr : turkeycn : chinadk : denmarkse : swedenno : norwayfi : finlandeg : egypt |
shipto_country | |
| DELIVERYADDRESSZIPCODE | = | shipto_postalcode | |
| DELIVERYADDRESSSTATEID | = | shipto_stateorprovince | |
| DELIVERYADDRESSSTREET | = | shipto_line1 | |
| DELIVERYADDRESSSTREETNUMBER | = | shipto_line2 | |
| LINEAMOUNT | > | extendedamount | |
| LINECREATIONSEQUENCENUMBER | = | sequencenumber | |
| ORDEREDSALESQUANTITY | = | 数量 | |
| PRODUCTNAME | = | 描述 | |
| PRODUCTNUMBER | = | productid.msdyn_productnumber | |
| SALESORDERNUMBER | = | salesorderid.msdyn_salesordernumber | |
| SALESUNITSYMBOL | = | uomid.msdyn_symbol | |
| TOTALDISCOUNTAMOUNT | = | manualdiscountamount | |
| TOTALTAXAMOUNT | > | 税款 | |
| SALESPRICE | = | priceperunit | |
| LINEAMOUNT | > | baseamount | |
| SALESPRODUCTCATEGORYNAME | = | msdyn_salesproductcategory.msdyn_name | |
| SALESPRODUCTCATEGORYHIERARCHYNAME | > | msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name | |
| ISDELIVERYADDRESSORDERSPECIFIC | ><no : Falseyes : True |
msdyn_isdeliveryaddressspecific | |
| ISDELIVERYADDRESSPRIVATE | ><no : Falseyes : True |
msdyn_isdeliveryaddressprivate | |
| ISLINESTOPPED | ><no : Falseyes : 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 : 192350000backorder : 192350001delivered : 192350002invoiced : 192350003canceled : 192350004 |
msdyn_linestatus | |
| SALESORDERPROMISINGMETHOD | ><none : 192350000salesLeadTime : 192350001atp : 192350002atpPlusIssueMargin : 192350003ctp : 192350004 |
msdyn_salesorderpromisingmethod | |
| SALESPRICEQUANTITY | = | msdyn_salespricequantity | |
| SHIPPINGSITEID | = | msdyn_shippingsite.msdyn_siteid | |
| SHIPPINGWAREHOUSEID | = | msdyn_shippingwarehouse.msdyn_warehouseidentifier | |
| none | >> | ispriceoverridden | 是 |
| TOTALCHARGESAMOUNT | > | msdyn_totalchargesamount | |
| DELIVERYMODECODE | = | msdyn_deliverymode.msdyn_name | |
| DELIVERYTERMSID | = | msdyn_deliveryterms.msdyn_termscode | |
| SALESDELIVERNOW | = | quantityshipped | |
| INVENTORYSERVICERESERVATIONID | = | msdyn_reservationid |
Dynamics 365 Sales 报价单标头 (quotes)
此模板在财务和运营应用与 Dataverse 之间同步数据。
反向源筛选器：msdyn_ordertype eq 192350000
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| SALESQUOTATIONNUMBER | = | msdyn_quotenumber | |
| REQUESTINGCUSTOMERACCOUNTNUMBER | = | customerid。Account（accountnumber）。联系人（msdyn_contactpersonid） | |
| CURRENCYCODE | = | transactioncurrencyid.isocurrencycode | |
| CUSTOMERSREFERENCE | = | msdyn_customersreference | |
| DELIVERYADDRESSCITY | = | shipto_city | |
| DELIVERYADDRESSCOUNTRYREGIONISOCODE | ><us : united statesde : germanyfr : francegb : united kingdomjp : japanin : indiaes : spainnz : new zealandau : australiaco : columbiaza : south africabe : belgiumca : canadaat : austriatr : turkeycn : chinadk : denmarkse : swedenno : norwayfi : finlandeg : egypt |
shipto_country | |
| DELIVERYADDRESSSTREETNUMBER | = | shipto_line2 | |
| DELIVERYADDRESSZIPCODE | = | shipto_postalcode | |
| DELIVERYADDRESSSTREET | = | shipto_line1 | |
| DELIVERYADDRESSSTATEID | = | shipto_stateorprovince | |
| SALESQUOTATIONNAME | = | 姓名 | |
| 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 : Falseyes : 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）。联系人（msdyn_contactpersonid） | |
| ISDELIVERYADDRESSORDERSPECIFIC | ><no : Falseyes : True |
msdyn_isdeliveryaddressorderspecific | |
| ISDELIVERYADDRESSPRIVATE | ><no : Falseyes : True |
msdyn_isdeliveryaddressprivate | |
| ISINVOICEADDRESSPRIVATE | >>no : Falseyes : True |
msdyn_isinvoiceaddressprivate | |
| LANGUAGEID | ><ar : 192350000ar-ae : 192350001cs : 192350002da : 192350003de : 192350004de-at : 192350005de-ch : 192350006en-au : 192350007en-gb : 192350009en-ie : 192350010en-in : 192350011en-ca : 192350008en-my : 192350012en-nz : 192350013en-sg : 192350014en-us : 192350015en-za : 192350016es : 192350017es-mx : 192350018et : 192350019fi : 192350020fr : 192350021fr-be : 192350022fr-ca : 192350023fr-ch : 192350024hu : 192350025is : 192350026it : 192350027it-ch : 192350028ja : 192350029lt : 192350030lv : 192350031nb-no : 192350032nl : 192350033nl-be : 192350034pl : 192350035pt-br : 192350036ru : 192350037sv : 192350038th : 192350039tr : 192350040zh-hans : 192350041 |
msdyn_language | |
| PAYMENTTERMSNAME | = | msdyn_paymentterms.msdyn_name | |
| PRICECUSTOMERGROUPCODE | = | msdyn_pricecustomergroup.msdyn_groupcode | |
| RECEIPTDATEREQUESTED | = | msdyn_requestedreceiptdate | |
| REQUESTEDSHIPPINGDATE | = | requestdeliveryby | |
| SALESORDERPROMISINGMETHOD | ><none : 192350000salesLeadTime : 192350001atp : 192350002atpPlusIssueMargin : 192350003ctp : 192350004 |
msdyn_salesorderpromisingmethod | |
| SALESQUOTATIONCONFIRMATIONDATE | = | msdyn_salesquotationconfirmationdate | |
| SALESQUOTATIONEXPIRYDATE | = | msdyn_salesquotationexpirydate | |
| SALESQUOTATIONFOLLOWUPDATE | = | msdyn_salesquotationfollowupdate | |
| SALESQUOTATIONSTATUS | ><created : 192350000sent : 192350001confirmed : 192350002lost : 192350003cancelled : 192350004reset : 192350005modified : 192350006submitted : 192350007approved : 192350008revised : 192350009 |
msdyn_salesquotationstatus | |
| TOTALDISCOUNTPERCENTAGE | = | msdyn_totaldiscountpercentage | |
| URL | = | msdyn_url | |
| 电子邮件 | = | 电子邮件地址 | |
| none | >> | msdyn_ordertype | 192350000 |
| CURRENCYCODE | > | msdyn_isocurrencycode | |
| OPERATINGUNITPARTYNUMBER | = | msdyn_operatingunit.msdyn_partynumber | |
| SALESQUOTATIONHEADERCREATIONMETHOD | >>SCM : 776160000Dynamics365Sales : 776160001 |
msdyn_quotationcreationmethod | |
| SALESQUOTATIONOWNERSHIP | >>BasedOnOrigin : 776160000SCM : 776160001Dynamics365Sales : 776160002 |
msdyn_quotationownership |
Dynamics 365 Sales 报价单行 (quotedetails)
此模板在财务和运营应用与 Dataverse 之间同步数据。
反向源筛选器：
- 版本 1.x.x.x：无
（在未安装项目运营或现场服务解决方案的供应链解决方案的上下文中使用。 - 版本 2.x.x.x：msdyn_linetype ne 690970000 或 msdyn_linetype eq null
（在已安装的供应链解决方案和项目运营或现场服务解决方案的上下文中使用。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| ALLOWEDOVERDELIVERYPERCENTAGE | = | msdyn_allowedoverdeliverypercentage | |
| ALLOWEDUNDERDELIVERYPERCENTAGE | = | msdyn_allowedunderdeliverypercentage | |
| SALESQUOTATIONNUMBER | = | quoteid.msdyn_quotenumber | |
| LINECREATIONSEQUENCENUMBER | = | sequencenumber | |
| CURRENCYCODE | > | transactioncurrencyid.isocurrencycode | |
| DELIVERYADDRESSCITY | = | shipto_city | |
| DELIVERYADDRESSCOUNTRYREGIONISOCODE | ><us : united statesde : germanyfr : francegb : united kingdomjp : japanin : indiaes : spainnz : new zealandau : australiaco : columbiaza : south africabe : belgiumca : canadaat : austriatr : turkeycn : chinadk : denmarkse : swedenno : norwayfi : finlandeg : 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 : Falseyes : True |
msdyn_isdeliveryaddressprivate | |
| ISDELIVERYADDRESSORDERSPECIFIC | ><no : Falseyes : True |
msdyn_isdeliveryaddressspecific | |
| LINEAMOUNT | > | baseamount | |
| LINEAMOUNT | > | extendedamount | |
| LINEDESCRIPTION | = | msdyn_linedescription2 | |
| LINEDISCOUNTAMOUNT | = | msdyn_linediscountamount | |
| LINEDISCOUNTPERCENTAGE | = | msdyn_linediscountpercentage | |
| MULTILINEDISCOUNTAMOUNT | = | msdyn_multilinediscountamount | |
| MULTILINEDISCOUNTPERCENTAGE | = | msdyn_multilinediscountpercentage | |
| PRODUCTNAME | = | 描述 | |
| PRODUCTNUMBER | = | productid.msdyn_productnumber | |
| REQUESTEDRECEIPTDATE | = | msdyn_requestedreceiptdate | |
| REQUESTEDSALESQUANTITY | = | 数量 | |
| REQUESTEDSHIPPINGDATE | = | requestdeliveryby | |
| SALESPRICE | = | priceperunit | |
| SALESPRICEQUANTITY | = | msdyn_salespricequantity | |
| SALESQUOTATIONPROMISINGMETHOD | ><none : 192350000salesLeadTime : 192350001atp : 192350002atpPlusIssueMargin : 192350003ctp : 192350004 |
msdyn_salesquotationpromisingmethod | |
| SALESQUOTATIONSTATUS | ><created : 192350000sent : 192350001confirmed : 192350002lost : 192350003cancelled : 192350004reset : 192350005modified : 192350006submitted : 192350007approved : 192350008revised : 192350009 |
msdyn_salesquotationstatus | |
| SALESUNITSYMBOL | = | uomid.msdyn_symbol | |
| SHIPPINGSITEID | = | msdyn_shippingsite.msdyn_siteid | |
| SHIPPINGWAREHOUSEID | = | msdyn_shippingwarehouse.msdyn_warehouseidentifier | |
| TOTALCHARGESAMOUNT | > | msdyn_totalchargesamount | |
| TOTALDISCOUNTAMOUNT | = | manualdiscountamount | |
| TOTALTAXAMOUNT | > | 税款 | |
| SALESPRODUCTCATEGORYHIERARCHYNAME | > | msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name | |
| SALESPRODUCTCATEGORYNAME | = | msdyn_salesproductcategory.msdyn_name | |
| none | >> | ispriceoverridden | 是 |
就业工作职能（msdyn_employmentjobfunctions）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| FUNCTIONDESCRIPTION | = | msdyn_functiondescription | |
| FUNCTIONNAME | = | msdyn_functionname |
每个公司的雇用 (cdm_employments)
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| EMPLOYMENTENDDATE | = | cdm_employmentenddate | |
| PERSONNELNUMBER | = | cdm_workerid.cdm_workernumber | |
| EMPLOYMENTSTARTDATE | = | cdm_employmentstartdate | |
| WORKERTYPE | >>employee : 754400000contractor : 754400001both : 754400000 |
cdm_workertype |
民族起源（cdm_ethnicorigins）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| ETHNICORIGINID | = | cdm_name | |
| 描述 | = | cdm_description |
汇率货币对（msdyn_currencyexchangeratepairs）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| EXCHANGERATEDISPLAYFACTOR | ><one : 192350000ten : 192350001hundred : 192350002thousand : 192350003tenThousand : 192350004 |
msdyn_displayfactor | |
| EXCHANGERATETYPENAME | = | msdyn_currencyexchangeratetypeid.msdyn_name | |
| FROMCURRENCYCODE | = | msdyn_fromtransactioncurrencyid.isocurrencycode | |
| TOCURRENCYCODE | = | msdyn_totransactioncurrencyid.isocurrencycode |
汇率类型（msdyn_exchangeratetypes）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 名称 | = | msdyn_name | |
| 描述 | = | msdyn_description |
财务维度格式（msdyn_financialdimensionformats）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| DIMENSIONFORMATNAME | = | msdyn_dimensionformatname | |
| DIMENSIONFORMATTYPE | ><dataEntityDefaultDimensionFormat : 192350000dataEntityLedgerDimensionFormat : 192350001dataEntityBudgetDimensionFormat : 192350002dataEntityBudgetPlanningDimensionFormat : 192350003 |
msdyn_dimensionformattype | |
| FINANCIALDIMENSIONFORMAT | = | msdyn_financialdimensionformat | |
| ISACTIVE | ><no : Falseyes : True |
msdyn_isactive |
财务维度（msdyn_dimensionattributes）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| DIMENSIONNAME | = | msdyn_dimensionname | |
| COPYVALUESONCREATE | ><no : Falseyes : True |
msdyn_copyvaluesoncreate | |
| REPORTCOLUMNNAME | = | msdyn_reportcolumnname | |
| GIVEDERIVEDDIMENSIONSPRECEDENCE | ><no : Falseyes : True |
msdyn_givederiveddimensionsprecedence | |
| UseValuesFrom | = | msdyn_usevaluesfrom | |
| DimensionValueMask | = | msdyn_dimensionvaluemask |
会计日历集成实体（msdyn_fiscalcalendars）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CALENDARID | = | msdyn_calendar | |
| 描述 | = | msdyn_description |
会计日历周期（msdyn_fiscalcalendarperiods）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| COMMENTS | = | msdyn_comments | |
| ENDDATE | = | msdyn_enddate | |
| MONTH | ><month1 : 192350000month2 : 192350001month3 : 192350002month4 : 192350003month5 : 192350004month6 : 192350005month7 : 192350006month8 : 192350007month9 : 192350008month10 : 192350009month11 : 192350010month12 : 192350011 |
msdyn_month | |
| 日历 | = | msdyn_fiscalcalendar.msdyn_calendar | |
| 季度 | ><q1 : 192350000q2 : 192350001q3 : 192350002q4 : 192350003 |
msdyn_quarter | |
| SHORTNAME | = | msdyn_shortname | |
| STARTDATE | = | msdyn_startdate | |
| TYPE | ><opening : 192350000operating : 192350001closing : 192350002 |
msdyn_fiscalperiodtype | |
| PERIODNAME | = | msdyn_periodname | |
| FISCALYEAR | = | msdyn_fiscalcalendaryear.msdyn_name | |
| 日历 | = | msdyn_fiscalcalendaryear.msdyn_fiscalcalendarname |
会计日历年集成实体（msdyn_fiscalcalendaryears）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| FISCALCALENDAR_CALENDARID | = | msdyn_fiscalcalendarname | |
| 名称 | = | msdyn_name | |
| STARTDATE | = | msdyn_startdate | |
| ENDDATE | = | msdyn_enddate | |
| FISCALCALENDAR_CALENDARID | = | msdyn_calendar.msdyn_calendar |
库存过道 （msdyn_warehouseaisles）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| AISLEID | = | msdyn_aisleid | |
| AISLENUMBER | = | msdyn_aislenumber | |
| WAREHOUSEID | = | msdyn_warehouse.msdyn_warehouseidentifier | |
| AISLENAME | = | msdyn_aislename | |
| MANUALSTARTINGSORTORDERCODE | = | msdyn_manualstartingsortordercode | |
| ISSORTORDERCODEASSIGNEDDESCENDING | ><yes : Trueno : False |
msdyn_issortordercodeassigneddescending |
项目销售税组 （msdyn_taxitemgroups）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| TAXITEMGROUP | = | msdyn_name | |
| 名称 | = | msdyn_description |
作业（cdm_jobs）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| JOBID | = | cdm_name | |
| MAXIMUMNUMBEROFPOSITIONS | = | cdm_maximumnumberofpositions | |
| ALLOWUNLIMITEDPOSITIONS | ><yes : trueno : false |
cdm_allowunlimitedpositions | |
| 描述 | = | cdm_description | |
| JOBDESCRIPTION | = | cdm_jobdescription | |
| JOBTYPEID | = | cdm_jobtypeid.cdm_name | |
| FUNCTIONID | = | cdm_jobfunctionid.cdm_name | |
| EFFECTIVE | = | cdm_validfrom | |
| EXPIRATION | = | cdm_validto | |
| FULLTIMEEQUIVALENT | = | cdm_defaultfulltimeequivalent |
语言代码（cdm_languages）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| LANGUAGECODEID | = | cdm_name | |
| 描述 | = | cdm_description |
账本 （msdyn_ledgers）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| LEGALENTITYID | > | msdyn_company.cdm_companycode | |
| 描述 | > | msdyn_description | |
| ACCOUNTINGCURRENCY | > | msdyn_accountingcurrency.isocurrencycode | |
| ISBUDGETCONTROLENABLED | >>no : Falseyes : True |
msdyn_isbudgetcontrolenabled | |
| 名称 | > | 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 |
法律实体（cdm_companies）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 名称 | > | cdm_name | |
| LEGALENTITYID | > | cdm_companycode |
法律实体（msdyn_internalorganizations）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| NAMEALIAS | > | msdyn_namealias | |
| LANGUAGEID | > | msdyn_languageid | |
| 名称 | > | msdyn_name | |
| PARTYNUMBER | > | msdyn_partynumber | |
| none | >> | msdyn_type | 806380000 |
| LEGALENTITYID | > | msdyn_companycode |
会员卡 （msdyn_loyaltycards）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CARDNUMBER | = | msdyn_cardnumber | |
| CARDTENDERTYPE | ><asCardTender : 806380000asContactTender : 806380001noTender : 806380002blocked : 806380003 |
msdyn_cardtendertype | |
| PARTYNUMBER | = | msdyn_partynumber | |
| REPLACEMENTCARDNUMBER | > | msdyn_replacementcardnumber | |
| OMOPERATINGUNITNUMBER | = | msdyn_operatingunitnumber | |
| LOYALTYENROLLMENTDATE | = | msdyn_enrollmentdate | |
| LOYALTYENROLLMENTDATELOCAL | = | msdyn_effectivedate |
忠诚级别 （msdyn_loyaltylevels）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| LEVELPHRASE | = | msdyn_levelphrase | |
| LEVELDESCRIPTION | = | msdyn_description |
忠诚奖励积分（msdyn_loyaltyrewardpoints）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| EXPIRATIONTIMEUNIT | ><day : 806380000month : 806380001year : 806380002 |
msdyn_expirationtimeunit | |
| EXPIRATIONTIMEVALUE | = | msdyn_expirationtimevalue | |
| 赎回 | ><yes : Trueno : False |
msdyn_redeemable | |
| REDEEMRANKING | = | msdyn_redeemranking | |
| REWARDPOINTCURRENCY | = | msdyn_rewardpointcurrency.isocurrencycode | |
| REWARDPOINTID | = | msdyn_rewardpointid | |
| REWARDPOINTTYPE | ><quantity : 192350000amount : 192350001 |
msdyn_rewardpointtype | |
| MAXIMUMLOYALTYREWARDPOINTS | = | msdyn_maximumloyaltyrewardpoints | |
| VESTINGTIMEUNIT | ><day : 806380000month : 806380001year : 806380002 |
msdyn_vestingtimeunit | |
| VESTINGTIMEVALUE | = | msdyn_vestingtimevalue |
主帐户（msdyn_mainaccounts）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| MAINACCOUNTID | = | msdyn_accountnumber | |
| CHARTOFACCOUNTS | = | msdyn_chartofaccounts.msdyn_name | |
| 名称 | = | msdyn_name | |
| BALANCECONTROL | ><none : 192350000debit : 192350001credit : 192350002 |
msdyn_balancecontrol | |
| EXCHANGEADJUSTMENTRATETYPE | = | msdyn_exchangeadjustmentratetype.msdyn_name | |
| 关闭 | ><none : 192350000result : 192350001balanceSheet : 192350002capital : 192350003 |
msdyn_closing | |
| REPORTINGEXCHANGEADJUSTMENTRATETYPE | = | msdyn_reportingexchangeadjustmentratetype.msdyn_name | |
| DEBITCREDITREQUIREMENT | ><none : 192350000debit : 192350001credit : 192350002 |
msdyn_debitcreditrequirement | |
| FINANCIALREPORTINGEXCHANGERATETYPE | = | msdyn_financialreportingexchangeratetype.msdyn_name | |
| FOREIGNCURRENCYREVALUATION | ><yes : Trueno : False |
msdyn_foreigncurrencyrevaluation | |
| MAINACCOUNTCATEGORY | = | msdyn_mainaccountcategoryname | |
| MANDATORYPAYMENTREFERENCE | ><yes : Trueno : False |
msdyn_mandatorypaymentreference | |
| 货币 | ><yes : Trueno : False |
msdyn_monetary | |
| OFFSETACCOUNTDISPLAYVALUE | = | msdyn_offsetaccount | |
| POSTINGTYPE | ><none : 192350000exchRateGain : 192350001exchRateLoss : 192350002interCompany : 192350003tax : 192350004vATRoundOff : 192350005allocation : 192350006investmentDuty : 192350007liquidity : 192350008mSTDiffSecond : 192350009errorAccount : 192350010mSTDiff : 192350011yearResult : 192350012closing : 192350013ledgerJournal : 192350014cashDiscount : 192350015consolidateDiffBalance : 192350016taxReport : 192350017transferOpeningClosing : 192350018bank : 192350019conversionProfit : 192350020conversionLoss : 192350021taxwithhold : 192350022consolidateDiffProfitLoss : 192350023indirectEstimatedAbsorptionOffset : 192350024indirectAbsorption : 192350025indirectAbsorptionOffset : 192350026freeTextInvoice : 192350027conversionReportingLoss : 192350029conversionReportingProfit : 192350030custBalance : 192350031custRevenue : 192350032custInterest : 192350033custCashDisc : 192350034custCollectionLetterFee : 192350035custInterestFee : 192350036custInvoiceDisc : 192350028custPayment : 192350037custReimbursement : 192350038custSettlement : 192350039vendBalance : 192350040vendPurchLedger : 192350041vendOffsetAccount : 192350042vendInterest : 192350043vendCashDisc : 192350044vendPayment : 192350045vendInvoiceDisc : 192350046vendSettlement : 192350047crossCompanySettlement : 192350048inventIssueFixedAsset : 192350049salesRevenue : 192350050salesConsump : 192350051salesDisc : 192350052salesCash : 192350053salesFreight : 192350054salesFee : 192350055salesPostage : 192350056salesRoundOff : 192350057salesPackingSlip : 192350058salesOffsetAccountPackingSlip : 192350059salesIssue : 192350060salesCommission : 192350061salesOffsetAccountCommission : 192350062salesPckSlipRevenue : 192350063salesPckSlipRevenueOffsetAccount : 192350064rebate : 192350065pdsCWLoss : 192350066pdsCWProfit : 192350067purchConsump : 192350068purchDisc : 192350069purchCash : 192350070purchFreight : 192350071purchFee : 192350072purchPostage : 192350073purchOffsetAccount : 192350074purchaseInvoiceRoundOff : 192350075purchMarkupFreight : 192350076purchMarkupCustoms : 192350077purchMarkupInsurance : 192350078purchPckSlp : 192350079purchOffsetAccountPckSlp : 192350080purchReceipt : 192350081purchStdProfit : 192350082purchStdLoss : 192350083purchStdOffsetAccount : 192350084inventReceipt : 192350085inventIssue : 192350086inventProfit : 192350087inventLoss : 192350088inventStdProfit : 192350089inventStdLoss : 192350090opening_ES : 192350091purchReq : 192350092aPInvoice : 192350093budget : 192350094purchOrderYearEnd : 192350095inflationAdjustment_MX : 192350096prodReportFinished : 192350097prodReportFinishedOffsetAccount : 192350098prodIssue : 192350099prodIssueOffsetAccount : 192350100prodReceipt : 192350101prodReceiptOffsetAccount : 192350102prodPicklistOffsetAccount : 192350103prodPicklist : 192350104prodWIPValuation : 192350105prodWIPIssue : 192350106prodWrkCtrIssue : 192350107prodScrap : 192350108prodScrapOffsetAccount : 192350109prodLeanWIPServiceReceipt : 192350110prodLeanWIPServiceClearing : 192350111projCost : 192350112projPayrollAllocation : 192350113projWIPCostvalue : 192350114projOffsetAccountItem : 192350115projStatusAccountItem : 192350116projTurnover : 192350117projOnAccount : 192350118projSalesvalue : 192350119projSalesvalueOffset : 192350120projAccruedTurnoverProd : 192350121projWIPProduction : 192350122proJAccruedTurnoverProfit : 192350123projWIPProfit : 192350125projNeverLedger : 192350126projAccruedCost : 192350127projWIPCost : 192350128projAccruedRevenueOnAccount : 192350129projWIPInvoicedOnAccount : 192350130projNoLedger : 192350131payrollDebitAccount : 192350132payrollCreditAccount : 192350133emplPayment_RU : 192350134rTSLTranslationDifference : 192350135rCash : 192350136inventRoundingLoss_RU : 192350137inventRoundingProfit_RU : 192350138advanceAdjustmentGain_RU : 192350139advanceAdjustmentLoss_RU : 192350140fixedAssetsDebit : 192350141fixedAssetsCredit : 192350142cACLedgerJournalNoOff : 192350143amountDiffGain_RU : 192350144amountDiffLoss_RU : 192350145misc_IN : 192350146transferGoodsTransit_IN : 192350147transferScrap_IN : 192350148purchCharge : 192350149purchStockVariation : 192350150purchPckSlpPurchaseOffsetAccount : 192350151purchPckSlpTax : 192350152purchPckSlpPurchase : 192350153salesPackingslipTax : 192350154projAccruedRevenueSubscription : 192350155projWIPSubscription : 192350156taxOffsetWithhold_TH : 192350157inventStdCostChangeVariance : 192350158inventSystemRounding : 192350159purchAdvance : 192350160purchStdCostPurchasePriceVariance : 192350161purchAdvanceApplication : 192350162prodStdCostProductionVariance : 192350163salesGoodsInRoute_RU : 192350164salesGoodsInRouteOffset_RU : 192350165inventInterUnitPayable : 192350166inventInterUnitReceivable : 192350167indirectEstimatedAbsorption : 192350168prodStdCostLotSizeVariance : 192350169prodStdCostQuantityVariance : 192350170prodStdCostSubstitutionVariance : 192350171inventStdCostRoundingVariance : 192350172purchReceiptFixedAsset : 192350173pSATransportation : 192350174pSACompanyCCClearing : 192350175pSAEmployeeClearing : 192350176pSAEmployeeAdvance : 192350177pSAWriteOffCap : 192350178pSAProjRetain : 192350179pSAProjPurchRetain : 192350180inventStdCostRevaluation : 192350181purchExpense : 192350182vAT_IN : 192350183inventMovingAveragePriceDifference : 192350184salesTax_IN : 192350185inventMovingAverageCostRevaluation : 192350186excise_IN : 192350187intercompanyCost : 192350188serviceTax_IN : 192350189intercompanyRevenue : 192350190customs_IN : 192350191tDS_IN : 192350192tCS_IN : 192350193transferIssue_IN : 192350194transferReceipt_IN : 192350195transferProfit_IN : 192350196transferLoss_IN : 192350197taxAdjustmentSettlement_IN : 192350198taxExpense_BR : 192350199bankStatement : 192350200emplBalance_RU : 192350201debitNote_BR : 192350202custFine_BR : 192350203vendFine_BR : 192350204payroll : 192350205interunitDebit : 192350206interunitCredit : 192350207fixedAssetsDebit_RU : 192350208fixedAssetsCredit_RU : 192350209transferInterim_In : 192350210deferralsDebit_RU : 192350211deferralsCredit_RU : 192350212mCRReturns : 192350213mCRReturnsConsump : 192350214mCRUnderpayWriteOff : 192350215mCRBrokerFee : 192350216rPayTaxRefundOffset : 192350217budgetReservation_PSN : 192350218budgetReservationYearEnd_PSN : 192350219billSchUnbilledAccountsReceivable : 192350220billSchAccruedRevenue : 192350221gST_IN : 192350222reportingCurrencyAdjustment : 192350223revRecDeferredRevenue : 192350224revRecDeferredCostOfGoodsSold : 192350225revRecPartialRevenue : 192350226revRecDeferredCost : 192350227 |
msdyn_postingtype | |
| SRUCODE | = | msdyn_srucode | |
| VALIDATECURRENCY | ><optional : 192350000fillIn : 192350001table : 192350002list : 192350003 |
msdyn_validatecurrencycode | |
| VALIDATEUSER | ><optional : 192350000fillIn : 192350001table : 192350002list : 192350003 |
msdyn_validateuser | |
| DEBITCREDITDEFAULT | ><none : 192350000debit : 192350001credit : 192350002 |
msdyn_debitcreditdefault | |
| DEFAULTCURRENCY | = | msdyn_defaultcurrency.isocurrencycode | |
| MAINACCOUNTTYPE | ><blank : 192350000profitAndLoss : 192350001revenue : 192350002expense : 192350003balanceSheet : 192350004asset : 192350005liability : 192350006equity : 192350007total : 192350008reporting : 192350009common_CN : 192350010 |
msdyn_mainaccounttype | |
| FINANCIALREPORTINGCURRENCYTRANSLATIONTYPE | ><weightedAverage : 192350000standardAverage : 192350001current : 192350002transactionDate : 192350003 |
msdyn_financialreportingcurrencytrantype | |
| USER | = | msdyn_user | |
| VALIDATEPOSTINGTYPE | ><optional : 192350000fillIn : 192350001table : 192350002list : 192350003 |
msdyn_validateposting |
主帐户类别（msdyn_mainaccountcategories）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| MAINACCOUNTCATEGORY | = | msdyn_mainaccountcategory | |
| REFERENCEID | = | msdyn_referenceid | |
| 描述 | = | msdyn_description | |
| DISPLAYORDER | = | msdyn_displayorder | |
| CLOSED | ><no : Falseyes : True |
msdyn_closed | |
| MAINACCOUNTTYPE | ><blank : 192350000profitAndLoss : 192350001revenue : 192350002expense : 192350003balanceSheet : 192350004asset : 192350005liability : 192350006equity : 192350007 |
msdyn_mainaccounttypevalue |
混合现实指南实体（msmrw_guides）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| INTEGRATIONKEY | < | msmrw_integrationkey | |
| 名称 | < | msmrw_name | |
| SCHEMAVERSION | < | msmrw_schemaversion | |
| GUIDEID | < | msmrw_guideid | |
| CREATEDON | < | 创建时间 | |
| LASTMODIFIEDON | < | 修改在 |
交付模式（msdyn_shipvias）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| MODECODE | = | msdyn_name | |
| MODEDESCRIPTION | = | msdyn_description |
名称修复 （msdyn_nameaffixes）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 词缀 | = | msdyn_affix | |
| TYPE | ><personalSuffix : 806380001personalPrefix : 806380000 |
msdyn_affixtype | |
| 描述 | = | msdyn_description |
运营单位（msdyn_internalorganizations）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| LANGUAGEID | > | msdyn_languageid | |
| NAMEALIAS | > | msdyn_namealias | |
| 名称 | > | msdyn_name | |
| PARTYNUMBER | > | msdyn_partynumber | |
| OPERATINGUNITTYPE | >>omDepartment : 806380001none : 806380002omCostCenter : 806380003omValueStream : 806380004omBusinessUnit : 806380005omAnyOU : 806380006retailChannel : 192350000 |
msdyn_type |
组织层次结构 - 已发布（msdyn_internalorganizationhierarchies）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 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 |
组织层次结构用途（msdyn_internalorganizationhierarchypurposes）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| HIERARCHYTYPE | > | msdyn_hierarchypurposetypename | |
| HIERARCHYTYPE | > | msdyn_hierarchytype.msdyn_name | |
| HIERARCHYPURPOSE | >>notSet : 806380000purchaseControl : 806380001expenseControl : 806380002organizationChart : 806380003signingLimitControl : 806380004invoiceControl : 806380005auditInternalControl : 806380006centralizedPayments : 806380007security : 806380008retailAssortment : 806380009retailReplenishment : 806380010retailReporting : 806380011benefitEligibilityControl : 806380012budgetPlanning : 806380013retailPOSPosting : 806380014project : 806380015premiumEarningGeneration : 806380016distributedOrderManagement : 806380017 |
msdyn_hierarchypurpose | |
| 变 | >>no : Falseyes : True |
msdyn_immutable | |
| SETASDEFAULT | >>no : Falseyes : True |
msdyn_setasdefault |
组织层次结构类型（msdyn_internalorganizationhierarchytypes）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 名称 | > | msdyn_name |
群联系人 V3 （msdyn_partyelectronicaddresses）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| COUNTRYREGIONCODE | = | msdyn_internationalcallingcode | |
| 描述 | = | msdyn_description | |
| ELECTRONICADDRESSID | = | msdyn_electronicaddressnumber | |
| PARTYNUMBER | = | msdyn_partyid.msdyn_partynumber | |
| 定位 | = | msdyn_locator | |
| LOCATOREXTENSION | = | msdyn_locatorextension | |
| ISINSTANTMESSAGE | ><no : Falseyes : True |
msdyn_isinstantmessage | |
| ISMOBILEPHONE | ><no : Falseyes : True |
msdyn_ismobile | |
| ISPRIMARY | ><no : Falseyes : True |
msdyn_isprimary | |
| ISPRIVATE | ><no : Falseyes : True |
msdyn_isprivate | |
| 目的 | = | msdyn_purpose | |
| TYPE | ><phone : 192350001email : 192350002url : 192350003telex : 192350004fax : 192350005facebook : 192350006twitter : 192350007linkedin : 192350008 |
msdyn_type |
付款日行 CDS V2 （msdyn_paymentdaylines）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 名称 | = | msdyn_paymentday.msdyn_name | |
| LINENUMBER | = | msdyn_linenumber | |
| FREQUENCY | ><week : 806380000month : 806380001 |
msdyn_frequency | |
| DAYOFWEEK | ><none : 806380000monday : 806380001tuesday : 806380002wednesday : 806380003thursday : 806380004friday : 806380005saturday : 806380006sunday : 806380007 |
msdyn_dayofweek | |
| DAYOFMONTH | = | msdyn_dayofmonth |
付款日 CDS （msdyn_paymentdays）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 名称 | = | msdyn_name | |
| 描述 | = | msdyn_description |
付款计划 （msdyn_paymentschedules）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 名称 | = | msdyn_name | |
| 描述 | = | msdyn_description | |
| ALLOCATIONMETHOD | ><total : 806380000amountByPayment : 806380001numOfPayment : 806380002specified : 806380003 |
msdyn_allocationmethod | |
| PAYMENTFREQUENCYUNITS | ><day : 806380000month : 806380001year : 806380002 |
msdyn_paymentfrequencyunit | |
| PAYMENTFREQUENCY | = | msdyn_paymentfrequency | |
| NUMBEROFPAYMENTS | = | msdyn_numberofpayments | |
| FIXEDPAYMENTAMOUNT | = | msdyn_fixedpaymentamount | |
| MINIMUMPAYMENTAMOUNT | = | msdyn_minimumpaymentamount | |
| SALESTAXALLOCATIONMETHOD | ><proportional : 806380000firstRate : 806380001lastRate : 806380002 |
msdyn_salestaxallocationmethod | |
| 笔记 | = | msdyn_note |
付款计划行（msdyn_paymentschedulelines）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PAYMENTSCHEDULENAME | = | msdyn_paymentschedule.msdyn_name | |
| LINENUMBER | = | msdyn_linenumber | |
| PERIODSAFTERDUEDATE | = | msdyn_periodsafterduedate | |
| PERCENTORAMOUNT | ><percent : 806380000amount : 806380001 |
msdyn_percentoramount | |
| PERCENTORAMOUNTVALUE | = | msdyn_percentoramountvalue |
个人字符类型（msdyn_personalcharactertypes）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| TYPEDESCRIPTION | = | msdyn_typedescription | |
| TYPENAME | = | msdyn_typename |
职位类型 (cdm_positiontypes)
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| POSITIONTYPEID | = | cdm_name | |
| 描述 | = | cdm_description | |
| CLASSIFICATION | ><fulltime : 754400000parttime : 754400001空白： 754400002 |
cdm_classification |
职位工作分配（cdm_positionworkerassignmentmaps）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PERSONNELNUMBER | = | cdm_workerid.cdm_workernumber | |
| POSITIONID | = | cdm_jobpositionid.cdm_jobpositionnumber | |
| VALIDFROM | = | cdm_validfrom | |
| VALIDTO | = | cdm_validto |
位置 V2 （cdm_jobpositions）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| POSITIONID | = | cdm_jobpositionnumber | |
| 描述 | = | 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 |
价格客户组 （msdyn_pricecustomergroups）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| GROUPCODE | = | msdyn_groupcode | |
| GROUPNAME | = | msdyn_groupname |
标识的条形码（msdyn_productbarcodes）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PRODUCTNUMBER | > | msdyn_productnumberid.msdyn_productnumber | |
| 条形码 | > | msdyn_name | |
| 条形码 | > | msdyn_barcode | |
| PRODUCTQUANTITY | > | msdyn_productquantity | |
| PRODUCTDESCRIPTION | > | msdyn_productdescription | |
| BARCODESETUPID | > | msdyn_barcodesetupid | |
| PRODUCTQUANTITYUNITSYMBOL | > | msdyn_unitofmeasureid.msdyn_symbol | |
| ISDEFAULTSCANNEDBARCODE | >>no : Falseyes : True |
msdyn_isdefaultscannedbarcode | |
| ISDEFAULTPRINTEDBARCODE | >>no : Falseyes : True |
msdyn_isdefaultprintedbarcode | |
| ISDEFAULTDISPLAYEDBARCODE | >>no : Falseyes : True |
msdyn_isdefaultdisplayedbarcode |
产品类别（msdyn_productcategories）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PRODUCTCATEGORYHIERARCHYNAME | = | msdyn_hierarchy.msdyn_name | |
| ISCATEGORYINHERITINGPARENTPRODUCTATTRIBUTES | ><no : Falseyes : True |
msdyn_isinheritingparentproductattributes | |
| PROJECTCATEGORYNAME | = | msdyn_projectcategoryname | |
| ISTANGIBLEPRODUCT | ><no : Falseyes : True |
msdyn_istangibleproduct | |
| ISCATEGORYINHERITINGPARENTCATEGORYATTRIBUTES | ><no : Falseyes : 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 |
产品类别分配（msdyn_productcategoryassignments）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PRODUCTNUMBER | = | msdyn_globalproduct.msdyn_productnumber | |
| PRODUCTCATEGORYNAME | = | msdyn_productcategory.msdyn_name | |
| PRODUCTCATEGORYHIERARCHYNAME | = | msdyn_productcategory.msdyn_hierarchy.msdyn_name | |
| PRODUCTNUMBER | > | msdyn_name |
产品类别层次结构（msdyn_productcategoryhierarchies）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| HIERARCHYNAME | = | msdyn_name | |
| HIERARCHYDESCRIPTION | = | msdyn_description |
产品类别层次结构角色（msdyn_productcategoryhierarchyroles）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PRODUCTCATEGORYHIERARCHYNAME | = | msdyn_hierarchy.msdyn_name | |
| HIERARCHYROLE | ><procurement : 192350000sales : 192350001retail : 192350002commodity : 192350003financials : 192350004retailSpecialGroup : 192350005retailVendorProductHierarchy : 192350006retailChannelNavigation : 192350007packingMaterials_W : 192350008commonDataService : 192350009costManagement : 192350010engineeringProduct : 192350011 |
msdyn_hierarchyrole |
产品默认订单设置 V2 （msdyn_productspecificdefaultordersettings）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 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 : Falseyes : True |
msdyn_areinventoryorderdefaultsoverridden | |
| INVENTORYORDERPROMISINGMETHOD | ><none : 192350000salesLeadTime : 192350001atp : 192350002atpPlusIssueMargin : 192350003ctp : 192350004 |
msdyn_inventoryorderpromisingmethod | |
| ISINVENTORYATPINCLUDINGPLANNEDORDERS | ><false : Falsetrue : True |
msdyn_isinventoryatpincludingplannedorders | |
| ISINVENTORYUSINGWORKINGDAYS | ><no : Falseyes : True |
msdyn_isinventoryusingworkingdays | |
| ISINVENTORYSITEMANDATORY | ><no : Falseyes : True |
msdyn_isinventorysitemandatory | |
| ISINVENTORYPROCESSINGSTOPPED | ><no : Falseyes : True |
msdyn_isinventoryprocessingstopped | |
| ISPROCUREMENTUSINGWORKINGDAYS | ><no : Falseyes : True |
msdyn_isprocurementusingworkingdays | |
| ISPROCUREMENTSITEMANDATORY | ><no : Falseyes : True |
msdyn_isprocurementsitemandatory | |
| ISPROCUREMENTPROCESSINGSTOPPED | ><no : Falseyes : True |
msdyn_isprocurementprocessingstopped | |
| ARESALESDEFAULTORDERSETTINGSOVERRIDDEN | ><no : Falseyes : True |
msdyn_aresalesorderdefaultsoverridden | |
| SALESORDERPROMISINGMETHOD | ><none : 192350000salesLeadTime : 192350001atp : 192350002atpPlusIssueMargin : 192350003ctp : 192350004 |
msdyn_salesorderpromisingmethod | |
| ISSALESATPINCLUDINGPLANNEDORDERS | ><false : Falsetrue : True |
msdyn_issalesatpincludingplannedorders | |
| ISSALESSITEMANDATORY | ><no : Falseyes : True |
msdyn_issalessitemandatory | |
| ISSALESLEADTIMEOVERRIDDEN | ><no : Falseyes : True |
msdyn_issalesleadtimeoverridden | |
| ISSALESPROCESSINGSTOPPED | ><no : Falseyes : True |
msdyn_issalesprocessingstopped | |
| ISINVENTORYWAREHOUSEMANDATORY | ><no : Falseyes : True |
msdyn_isinventorywarehousemandatory | |
| ISPROCUREMENTWAREHOUSEMANDATORY | ><no : Falseyes : True |
msdyn_isprocurementwarehousemandatory | |
| ISSALESWAREHOUSEMANDATORY | ><no : Falseyes : 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 |
产品维度组（msdyn_productdimensiongroups）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| WILLSALESPRICESEARCHUSEPRODUCTSTYLE | ><no : falseyes : true |
msdyn_willsalespricesearchuseproductstyle | |
| WILLPURCHASEPRICESEARCHUSEPRODUCTSIZE | ><no : falseyes : true |
msdyn_willpurchasepricesearchuseproductsize | |
| WILLSALESPRICESEARCHUSEPRODUCTCONFIGURATION | ><no : falseyes : true |
msdyn_willsalespricesearchuseprodconfig | |
| WILLSALESPRICESEARCHUSEPRODUCTCOLOR | ><no : falseyes : true |
msdyn_willsalespricesearchuseproductcolor | |
| WILLPURCHASEPRICESEARCHUSEPRODUCTSTYLE | ><no : falseyes : true |
msdyn_willpurchasepricesearchuseproductstyle | |
| WILLPURCHASEPRICESEARCHUSEPRODUCTCONFIGURATION | ><no : falseyes : true |
msdyn_willpurchpricesearchuseprodconfig | |
| WILLPURCHASEPRICESEARCHUSEPRODUCTCOLOR | ><no : falseyes : true |
msdyn_willpurchpricesearchuseproductcolor | |
| ISPRODUCTSTYLEACTIVE | ><no : falseyes : true |
msdyn_isproductstyleactive | |
| ISPRODUCTSIZEACTIVE | ><no : falseyes : true |
msdyn_isproductsizeactive | |
| ISPRODUCTCONFIGURATIONACTIVE | ><no : falseyes : true |
msdyn_isproductconfigurationactive | |
| ISPRODUCTCOLORACTIVE | ><no : falseyes : true |
msdyn_isproductcoloractive | |
| GROUPNAME | = | msdyn_groupname | |
| GROUPDESCRIPTION | = | msdyn_groupdescription | |
| PRODUCTVARIANTNOMENCLATURENAME | = | msdyn_productvariantnomenclaturename | |
| WILLSALESPRICESEARCHUSEPRODUCTSIZE | ><yes : trueno : false |
msdyn_willsalespricesearchuseproductsize |
产品主色（msdyn_sharedproductcolors）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PRODUCTCOLORID | > | msdyn_productcolor.msdyn_productcolorname | |
| PRODUCTMASTERNUMBER | > | msdyn_globalproduct.msdyn_productnumber | |
| 补充重量 | > | msdyn_replenishmentweight | |
| DISPLAYSEQUENCENUMBER | > | msdyn_displaysequencenumber |
产品主配置（msdyn_sharedproductconfigurations）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CONTAINERUNITSYMBOL | > | msdyn_containerunit.msdyn_symbol | |
| PRODUCTCONFIGURATIONID | > | msdyn_productconfiguration.msdyn_productconfiguration | |
| PRODUCTMASTERNUMBER | > | msdyn_globalproduct.msdyn_productnumber | |
| 补充重量 | > | msdyn_replenishmentweight | |
| DISPLAYSEQUENCENUMBER | > | msdyn_displaysequencenumber |
产品主控形状大小（msdyn_sharedproductsizes）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PRODUCTMASTERNUMBER | > | msdyn_globalproduct.msdyn_productnumber | |
| PRODUCTSIZEID | > | msdyn_productsize.msdyn_productsize | |
| 补充重量 | > | msdyn_replenishmentweight | |
| DISPLAYSEQUENCENUMBER | > | msdyn_displaysequencenumber |
产品母版样式（msdyn_sharedproductstyles）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PRODUCTMASTERNUMBER | > | msdyn_globalproduct.msdyn_productnumber | |
| PRODUCTSTYLEID | > | msdyn_productstyle.msdyn_productstyle | |
| 补充重量 | > | msdyn_replenishmentweight | |
| DISPLAYSEQUENCENUMBER | > | msdyn_displaysequencenumber |
产品收据标头（msdyn_purchaseorderreceipts）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 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 : trueNo : 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 |
产品收据行 （msdyn_purchaseorderreceiptproducts）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 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 |
特定于产品的单位转换（msdyn_productspecificunitofmeasureconversions）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 分母 | = | msdyn_denominator | |
| 分子 | = | msdyn_numerator | |
| 因素 | = | msdyn_factor | |
| FROMUNITSYMBOL | = | msdyn_fromunit.msdyn_symbol | |
| TOUNITSYMBOL | = | msdyn_tounit.msdyn_symbol | |
| PRODUCTNUMBER | = | msdyn_globalproduct.msdyn_productnumber | |
| INNEROFFSET | = | msdyn_inneroffset | |
| OUTEROFFSET | = | msdyn_outeroffset | |
| 舍入 | ><nearest : 192350000up : 192350001down : 192350002 |
msdyn_rounding |
前景（潜在顾客）
此模板在财务和运营应用与 Dataverse 之间同步数据。
源筛选器：（IsB2BProspect == 1）
反向源筛选器：（msdyn_b2bcommerceprospect eq true）
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PROSPECTNAME | = | fullname | |
| PROSPECTPARTYNUMBER | = | msdyn_partyid.msdyn_partynumber | |
| PROSPECTID | = | msdyn_prospectid | |
| PRIMARYPHONENUMBER | = | telephone1 | |
| PRIMARYPHONENUMBEREXTENSION | = | msdyn_telephone1extension | |
| PRIMARYPHONENUMBERDESCRIPTION | = | 描述 | |
| 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 | 企业 |
| none | >> | address1_addresstypecode | 1 |
| COMPANYNAME | = | 公司名称 | |
| COMPANYSIZE | = | 员工人数 | |
| 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 : Falseyes : True |
msdyn_b2bcommerceprospect | |
| B2BPROSPECTSTATUS | ><Pending : 192350000Approved : 192350001Rejected : 192350002 |
msdyn_b2bprospectstatus |
采购订单标题文档附件（批注）
此模板在财务和运营应用与 Dataverse 之间同步数据。
源筛选器：（DocumentAttachmentTypeCode == “Note”） ||（DocumentAttachmentTypeCode == “URL”））
反向源筛选器：objecttypecode eq “msdyn_purchaseorder”
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| DOCUMENTID | = | msdyn_notesid | |
| 笔记 | = | notetext | |
| ATTACHMENTDESCRIPTION | = | 主题 | |
| PURCHASEORDERNUMBER | = | msdyn_relatedentityid | |
| DOCUMENTATTACHMENTTYPECODE | << | none | 注释 |
| none | >> | objecttypecode | msdyn_purchaseorder |
| ACCESSRESTRICTION | ><internal : 0external : 1 |
msdyn_restriction |
采购订单标头 V2 （msdyn_purchaseorders）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| DELIVERYADDRESSNAME | > | msdyn_addressname | |
| REQUESTEDDELIVERYDATE | = | msdyn_dateexpected | |
| PURCHASEORDERNUMBER | = | msdyn_name | |
| PAYMENTTERMSNAME | = | msdyn_paymentterm.msdyn_name | |
| DEFAULTRECEIVINGWAREHOUSEID | = | msdyn_receivetowarehouse.msdyn_warehouseidentifier | |
| ACCOUNTINGDATE | = | msdyn_accountingdate | |
| AREPRICESINCLUDINGSALESTAX | ><yes : Trueno : 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 | |
| 电子邮件 | = | msdyn_email | |
| ISCHANGEMANAGEMENTACTIVE | >>yes : Trueno : False |
msdyn_ischangemanagementactive | |
| ISDELIVEREDDIRECTLY | >>yes : Trueno : False |
msdyn_isdeliverydirectly | |
| LANGUAGEID | ><ar : 192350000ar-ae : 192350001cs : 192350002da : 192350003de : 192350004de-at : 192350005de-ch : 192350006en-au : 192350007en-gb : 192350009en-ie : 192350010en-in : 192350011en-ca : 192350008en-my : 192350012en-nz : 192350013en-sg : 192350014en-us : 192350015en-za : 192350016es : 192350017es-mx : 192350018et : 192350019fi : 192350020fr : 192350021fr-be : 192350022fr-ca : 192350023fr-ch : 192350024hu : 192350025is : 192350026it : 192350027it-ch : 192350028ja : 192350029lt : 192350030lv : 192350031nb-no : 192350032nl : 192350033nl-be : 192350034pl : 192350035pt-br : 192350036ru : 192350037sv : 192350038th : 192350039tr : 192350040zh-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 : 192350000inReview : 192350001rejected : 192350002approved : 192350003inExternalReview : 192350004finalized : 192350005confirmed : 192350006 |
msdyn_documentapprovalstatus | |
| PURCHASEORDERSTATUS | >>none : 192350000backorder : 192350001received : 192350002invoiced : 192350003canceled : 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 |
已发布的产品 V2 （msdyn_sharedproductdetails）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PRODUCTNUMBER | > | msdyn_globalproduct.msdyn_productnumber | |
| INTRASTATCHARGEPERCENTAGE | > | msdyn_intrastatchargepercentage | |
| ITEMNUMBER | > | msdyn_itemnumber | |
| APPROXIMATESALESTAXPERCENTAGE | > | msdyn_approximatesalestaxpercentage | |
| BESTBEFOREPERIODDAYS | > | msdyn_bestbeforeperioddays | |
| CARRYINGCOSTABCCODE | >>none : 806380000a : 806380001b : 806380002c : 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 : Falseyes : True |
msdyn_isdiscountposregistrationprohibited | |
| ISEXEMPTFROMAUTOMATICNOTIFICATIONANDCANCELLATION | >>no : Falseyes : True |
msdyn_exemptautomaticnotificationcancel | |
| ISINSTALLMENTELIGIBLE | >>no : Falseyes : True |
msdyn_isinstallmenteligible | |
| ISINTERCOMPANYPURCHASEUSAGEBLOCKED | >>no : Falseyes : True |
msdyn_isintercompanypurchaseusageblocked | |
| ISINTERCOMPANYSALESUSAGEBLOCKED | >>no : Falseyes : True |
msdyn_isintercompanysalesusageblocked | |
| ISMANUALDISCOUNTPOSREGISTRATIONPROHIBITED | >>no : Falseyes : True |
msdyn_ismanualdiscposregistrationprohibited | |
| ISPHANTOM | >>no : Falseyes : True |
msdyn_isphantom | |
| ISPOSREGISTRATIONBLOCKED | >>no : Falseyes : True |
msdyn_isposregistrationblocked | |
| ISPOSREGISTRATIONQUANTITYNEGATIVE | >>no : Falseyes : True |
msdyn_isposregistrationquantitynegative | |
| ISPURCHASEPRICEAUTOMATICUPDATED | >>no : Falseyes : True |
msdyn_ispurchasepriceautomaticallyupdated | |
| ISPURCHASEPRICEINCLUDINGCHARGES | >>no : Falseyes : True |
msdyn_ispurchasepriceincludingcharges | |
| ISSALESWITHHOLDINGTAXCALCULATED | >>no : Falseyes : True |
msdyn_issaleswithholdingtaxcalculated | |
| ISRESTRICTEDFORCOUPONS | >>no : Falseyes : True |
msdyn_isrestrictedforcoupons | |
| ISSALESPRICEADJUSTMENTALLOWED | >>no : Falseyes : True |
msdyn_issalespriceadjustmentallowed | |
| ISSALESPRICEINCLUDINGCHARGES | >>no : Falseyes : True |
msdyn_issalespriceincludingcharges | |
| ISSCALEPRODUCT | >>no : Falseyes : True |
msdyn_isscaleproduct | |
| ISSHIPALONEENABLED | >>no : Falseyes : True |
msdyn_isshipaloneenabled | |
| ISUNITCOSTPRODUCTVARIANTSPECIFIC | >>no : Falseyes : True |
msdyn_isunitcostproductvariantspecific | |
| ISVARIANTSHELFLABELSPRINTINGENABLED | >>no : Falseyes : True |
msdyn_isvariantshelflabelsprintingenabled | |
| ISZEROPRICEPOSREGISTRATIONALLOWED | >>no : Falseyes : True |
msdyn_iszeropriceposregistrationallowed | |
| KEYINPRICEREQUIREMENTSATPOSREGISTER | >>notMandatory : 806380000newPrice : 806380001higherEqual : 806380002lowerEqual : 806380003noPrice : 806380004 |
msdyn_keyinpricerequirementsatposregister | |
| KEYINQUANTITYREQUIREMENTSATPOSREGISTER | >>notMandatory : 806380000keyIn : 806380001notKeyIn : 806380002 |
msdyn_keyinquantityrequirementsatposregister | |
| MARGINABCCODE | >>none : 806380000a : 806380001b : 806380002c : 806380003 |
msdyn_marginabccode | |
| MAXIMUMPICKQUANTITY | > | msdyn_maximumpickquantity | |
| MUSTKEYINCOMMENTATPOSREGISTER | >>no : Falseyes : 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 : 806380000quality : 806380001 |
msdyn_potencybaseattributevalueentryevent | |
| PRODUCTTYPE | >>item : 806380001service : 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 : 806380000orderPicking : 806380001 |
msdyn_rawmaterialpickingprinciple | |
| SALESCHARGESQUANTITY | > | msdyn_saleschargesquantity | |
| SALESOVERDELIVERYPERCENTAGE | > | msdyn_salesoverdeliverypercentage | |
| SALESPRICE | > | msdyn_salesprice | |
| SALESPRICECALCULATIONCHARGESPERCENTAGE | > | msdyn_salespricecalculationchargespercentage | |
| SALESPRICECALCULATIONCONTRIBUTIONRATIO | > | msdyn_salespricecalculationcontributionratio | |
| SALESPRICECALCULATIONMODEL | >>none : 806380000contributionratio : 806380001percentMarkup : 806380002 |
msdyn_salespricecalculationmodel | |
| SALESPRICEDATE | > | msdyn_salespricedate | |
| SALESPRICINGPRECISION | > | msdyn_salespricingprecision | |
| SALESUNDERDELIVERYPERCENTAGE | > | msdyn_salesunderdeliverypercentage | |
| SALESUNITSYMBOL | > | msdyn_salesunitsymbol.msdyn_symbol | |
| SCALEINDICATOR | >>relevant : 806380000notRelevant : 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 : Falseyes : True |
msdyn_willinventoryissueautoreportasfinished | |
| WILLINVENTORYRECEIPTIGNOREFLUSHINGPRINCIPLE | >>no : Falseyes : True |
msdyn_willinventoryreceiptignoreflushing | |
| WILLPICKINGWORKBENCHAPPLYBOXINGLOGIC | >>no : Falseyes : True |
msdyn_willpickingworkbenchapplyboxinglogic | |
| WILLTOTALPURCHASEDISCOUNTCALCULATIONINCLUDEPRODUCT | >>no : Falseyes : True |
msdyn_willtotalpurchdiscountcalcincludeproduct | |
| WILLTOTALSALESDISCOUNTCALCULATIONINCLUDEPRODUCT | >>no : Falseyes : True |
msdyn_willtotalsalesdiscountcalcincludeproduct | |
| WILLWORKCENTERPICKINGALLOWNEGATIVEINVENTORY | >>no : Falseyes : True |
msdyn_willworkcenterpickingallownegativeinvent | |
| YIELDPERCENTAGE | > | msdyn_yieldpercentage | |
| ISUNITCOSTAUTOMATICALLYUPDATED | >>no : Falseyes : True |
msdyn_isunitcostautomaticallyupdated | |
| PURCHASEUNITSYMBOL | > | msdyn_purchaseunitsymbol.msdyn_symbol | |
| PURCHASEPRICEQUANTITY | > | msdyn_purchasepricequantity | |
| ISUNITCOSTINCLUDINGCHARGES | >>no : Falseyes : 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 : Falseyes : True |
msdyn_iscatchweight | |
| PRODUCTDIMENSIONGROUPNAME | > | msdyn_productdimensiongroupid.msdyn_groupname | |
| STORAGEDIMENSIONGROUPNAME | > | msdyn_storagedimensiongroup.msdyn_groupname | |
| TRACKINGDIMENSIONGROUPNAME | > | msdyn_trackingdimensiongroup.msdyn_groupname | |
| [无] | >> | msdyn_shouldsyncwithproducts | 假 |
销售发票头 V2 （发票）
此模板在财务和运营应用与 Dataverse 之间同步数据。
源筛选器：（SalesOrderNumber ！= “”）
反向源筛选器：msdyn_ordertype eq 192350000
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| none | >> | ispricelocked | 假 |
| none | >> | 状态码 | 4 |
| CONTACTPERSONID | > | msdyn_associatedcontact.msdyn_contactforpartynumber | |
| CURRENCYCODE | > | transactioncurrencyid.isocurrencycode | |
| CUSTOMERSORDERREFERENCE | > | 描述 | |
| INVOICEADDRESSCITY | > | billto_city | |
| INVOICEADDRESSCOUNTRYREGIONISOCODE | > | billto_country | |
| INVOICEADDRESSSTATE | > | billto_stateorprovince | |
| INVOICEADDRESSSTREET | > | billto_line1 | |
| INVOICEADDRESSSTREETNUMBER | > | billto_line2 | |
| INVOICEADDRESSZIPCODE | > | billto_postalcode | |
| INVOICECUSTOMERACCOUNTNUMBER | > | customerid。Account（accountnumber）。联系人（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 |
销售发票行 V2 （invoicedetails）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| CONFIRMEDSHIPPINGDATE | > | msdyn_confirmedshippingdate | |
| CURRENCYCODE | > | transactioncurrencyid.isocurrencycode | |
| INVENTORYSITEID | > | msdyn_inventorysite.msdyn_siteid | |
| INVENTORYWAREHOUSEID | > | msdyn_inventorywarehouse.msdyn_warehouseidentifier | |
| INVOICEDATE | > | invoiceid.msdyn_invoicedate | |
| INVOICEDQUANTITY | > | 数量 | |
| INVOICENUMBER | > | invoiceid.msdyn_invoicenumber | |
| LEDGERVOUCHER | > | invoiceid.msdyn_ledgervoucher | |
| LINEAMOUNT | > | extendedamount | |
| LINECREATIONSEQUENCENUMBER | > | sequencenumber | |
| LINETOTALCHARGEAMOUNT | > | msdyn_totalchargeamount | |
| LINETOTALDISCOUNTAMOUNT | > | manualdiscountamount | |
| LINETOTALTAXAMOUNT | > | 税款 | |
| PRODUCTNAME | > | 描述 | |
| 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 |
销售订单标题文档附件（批注）
此模板在财务和运营应用与 Dataverse 之间同步数据。
源筛选器：（DocumentAttachmentTypeCode == “Note”） ||（DocumentAttachmentTypeCode == “URL”））
反向源筛选器：objecttypecode eq 'salesorder'
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| DOCUMENTID | = | msdyn_notesid | |
| 笔记 | = | notetext | |
| ATTACHMENTDESCRIPTION | = | 主题 | |
| SALESORDERNUMBER | = | msdyn_relatedentityid | |
| DOCUMENTATTACHMENTTYPECODE | << | none | 注释 |
| none | >> | objecttypecode | salesorder |
| ACCESSRESTRICTION | ><internal : 0external : 1 |
msdyn_restriction |
销售订单源代码（msdyn_salesorderorigins）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| ORIGINCODE | = | msdyn_origincode | |
| ORIGINDESCRIPTION | = | msdyn_origindescription |
销售税部门（msdyn_taxauthorities）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| TAXAUTHORITYCODE | = | msdyn_taxauthoritycode | |
| TAXAUTHORITYIDENTIFICATION | = | msdyn_taxauthorityidentificator | |
| 描述 | = | msdyn_description | |
| REPORTLAYOUT | ><default : 192350000norway : 192350001unitedKingdom : 192350002sweden : 192350003germany : 192350004austria : 192350005netherlands : 192350006usa : 192350007italy : 192350008belgium : 192350009singapore : 192350010japan : 192350011finland : 192350012estonia : 192350013uae : 192350014 |
msdyn_taxreportlayout | |
| ROUNDOFFTYPE | ><ordinary : 192350000roundDown : 192350001roundUp : 192350002advantage : 192350003 |
msdyn_roundofftype | |
| ROUNDOFF | = | msdyn_roundoff | |
| 电子邮件 | = | msdyn_email | |
| 电话 | = | msdyn_phone | |
| URL | = | msdyn_url |
销售税免税代码实体 CDS （msdyn_taxexemptcodes）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 名称 | = | msdyn_name | |
| 描述 | = | msdyn_description |
销售税组（msdyn_taxgroups）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| TAXGROUPCODE | = | msdyn_name | |
| 描述 | = | msdyn_description |
销售税账本发布组 V2 （msdyn_taxpostinggroups）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| TAXPOSTINGGROUPCODE | = | msdyn_name | |
| 描述 | = | msdyn_description |
敬礼（msdyn_salutations）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| SALUTATIONPHRASE | = | msdyn_salutationphrase |
网站（msdyn_operationalsites）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| DEFAULTFINANCIALDIMENSIONVALUE | = | msdyn_defaultfinancialdimensionvalue | |
| DEFAULTINVENTORYSTATUSID | = | msdyn_defaultinventorystatusid | |
| ISRECEIVINGWAREHOUSEOVERRIDEALLOWED | ><no : Falseyes : True |
msdyn_isreceivingwarehouseoverrideallowed | |
| SITEID | = | msdyn_siteid | |
| SITENAME | = | msdyn_sitename | |
| TAXBRANCHCODE | = | msdyn_taxbranchcode | |
| FISCALESTABLISHMENTID | = | msdyn_fiscalestablishmentid | |
| ISPRIMARYADDRESSASSIGNED | ><no : Falseyes : 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 : Falseyes : True |
msdyn_masterplannedusestransferjournal | |
| PRIMARYADDRESSPOSTBOX | = | msdyn_primaryaddresspostbox | |
| PRIMARYADDRESSSTREETNUMBER | = | msdyn_primaryaddressstreetnumber |
大小（msdyn_productsizes）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| SIZEID | > | msdyn_productsize |
存储维度组（msdyn_productstoragedimensiongroups）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| WILLSALESPRICESEARCHUSEWAREHOUSE | ><no : falseyes : true |
msdyn_willsalespricesearchusewarehouse | |
| WILLSALESPRICESEARCHUSESITE | ><no : falseyes : true |
msdyn_willsalespricesearchusesite | |
| WILLSALESPRICESEARCHUSEINVENTORYSTATUS | ><no : falseyes : true |
msdyn_willsalespricesearchuseinventorystatus | |
| WILLPURCHASEPRICESEARCHUSEWAREHOUSE | ><no : falseyes : true |
msdyn_willpurchasepricesearchusewarehouse | |
| WILLPURCHASEPRICESEARCHUSESITE | ><no : falseyes : true |
msdyn_willpurchasepricesearchusesite | |
| WILLPURCHASEPRICESEARCHUSEINVENTORYSTATUS | ><no : falseyes : true |
msdyn_willpurchpricesearchuseinventstatus | |
| WILLCOVERAGEPLANNINGUSEWAREHOUSE | ><no : falseyes : true |
msdyn_willcoverageplanusewarehouse | |
| WILLCOVERAGEPLANNINGUSELOCATION | ><no : falseyes : true |
msdyn_iscoverageplanenabledforlocation | |
| WILLCOVERAGEPLANNINGUSEINVENTORYSTATUS | ><no : falseyes : true |
msdyn_willcoverageplanuseinventorystatus | |
| AREADVANCEDWAREHOUSEMANAGEMENTPROCESSESENABLED | ><no : falseyes : true |
msdyn_areadvancedwmprocessesenabled | |
| ISWAREHOUSEPRIMARYSTORAGEDIMENSION | ><no : falseyes : true |
msdyn_iswarehouseprimarystoragedimension | |
| ISWAREHOUSEMANDATORY | ><no : falseyes : true |
msdyn_iswarehousemandatory | |
| ISPHYSICALINVENTORYENABLEDFORWAREHOUSE | ><no : falseyes : true |
msdyn_isphysicalinventoryenabledforwarehouse | |
| ISPHYSICALINVENTORYENABLEDFORLOCATION | ><no : falseyes : true |
msdyn_isphysicalinventoryenabledforlocation | |
| ISLOCATIONACTIVE | ><no : falseyes : true |
msdyn_islocationactive | |
| ISFINANCIALINVENTORYENABLEDFORWAREHOUSE | ><no : falseyes : true |
msdyn_isfinancialinventoryenabledforwarehouse | |
| GROUPNAME | = | msdyn_groupname | |
| GROUPDESCRIPTION | = | msdyn_groupdescription | |
| ISBLANKRECEIPTALLOWEDFORLOCATION | ><no : falseyes : true |
msdyn_isblankreceiptallowedforlocation | |
| ISBLANKISSUEALLOWEDFORLOCATION | ><no : falseyes : true |
msdyn_isblankissueallowedforlocation |
样式（msdyn_productstyles）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| STYLEID | > | msdyn_productstyle |
交付条款（msdyn_termsofdeliveries）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| TERMSCODE | = | msdyn_termscode | |
| INTRASTATCODE | = | msdyn_intrastatcode | |
| SALESTAXLOCATIONROLE | ><none : 192350000invoice : 192350001delivery : 192350002swift : 192350003payment : 192350004service : 192350005home : 192350006other : 192350007business : 192350008remitTo : 192350009statement : 192350010fixedAsset : 192350011oneTime : 192350012recruit : 192350013sms : 192350014lading_W : 192350015unlading_W : 192350016headCompany_IT : 192350017stableOrganization_IT : 192350018 |
msdyn_salestaxlocationrole | |
| TERMSDESCRIPTION | = | msdyn_termsdescription | |
| FREIGHTCHARGETERMS | ><prepaid : 192350000collect : 192350001thirdParty : 192350002nofreight : 192350003 |
msdyn_freightchargeterms | |
| DORETAILSALESORDERSGETTRANSPORTATIONCHARGESADDED | ><no : Falseyes : True |
msdyn_doretailsogettransportationchargesadded | |
| ISCASHONDELIVERY | ><no : Falseyes : True |
msdyn_iscashondelivery | |
| WILLSHIPMENTCONFIRMATIONTRANSFERCHARGES | ><no : Falseyes : True |
msdyn_willshipmentconfirmationtransfercharges |
付款条款（msdyn_paymentterms）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 描述 | = | msdyn_description | |
| 名称 | = | msdyn_name | |
| NUMBEROFMONTHS | = | msdyn_numberofmonth | |
| CUTOFFDAYOFMONTH | = | msdyn_cutoffdayofmonth | |
| ISCASHPAYMENT | ><no : Falseyes : True |
msdyn_iscashpayment | |
| NUMBEROFDAYS | = | msdyn_days | |
| ISCERTIFIEDCOMPANYCHECK | ><yes : Trueno : False |
msdyn_iscertifiedcompanycheck | |
| ISDEFAULTPAYMENTTERM | ><no : Falseyes : True |
msdyn_isdefaultpaymentterm | |
| CREDITCARDPAYMENTTYPE | ><na : 806380998creditCard : 806380999 |
msdyn_creditcardpaymenttype | |
| CREDITCARDCREDITCHECKTYPE | ><normal : 806380000byPass : 806380001 |
msdyn_creditcardcreditchecktype | |
| PAYMENTDAYNAME | = | msdyn_paymentdayname.msdyn_name | |
| PAYMENTMETHODTYPE | ><net : 806380991currentMth : 806380992currentQuart : 806380993currentYear : 806380994currentWeek : 806380995cod : 806380996cutOffDate : 806380997 |
msdyn_paymentmethodtype | |
| PAYMENTSCHEDULENAME | = | msdyn_paymentschedulename.msdyn_name |
跟踪维度组（msdyn_producttrackingdimensiongroups）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| SERIALNUMBERCAPTURINGOPERATION | ><none : 806380000picking : 806380001packing : 806380002 |
msdyn_serialnumbercapturingoperation | |
| GROUPNAME | = | msdyn_groupname | |
| GROUPDESCRIPTION | = | msdyn_groupdescription | |
| ISSERIALNUMBERENABLEDFORPRODUCTIONCONSUMPTIONPROCESS | ><no : falseyes : true |
msdyn_issnenabledforpcprocess | |
| ISSERIALNUMBERCONTROLENABLED | ><no : falseyes : true |
msdyn_isserialnumbercontrolenabled | |
| ISSERIALNUMBERENABLEDFORSALESPROCESS | ><no : falseyes : true |
msdyn_isserialnumberenabledforsalesprocess | |
| ISSERIALNUMBERACTIVE | ><no : falseyes : true |
msdyn_isserialnumberactive | |
| ISSALESPRICEBYSERIALNUMBER | ><no : falseyes : true |
msdyn_issalespricebyserialnumber | |
| ISSALESPRICEBYBATCHNUMBER | ><no : falseyes : true |
msdyn_issalespricebybatchnumber | |
| ISPURCHASEPRICEBYSERIALNUMBER | ><no : falseyes : true |
msdyn_ispurchasepricebyserialnumber | |
| ISPURCHASEPRICEBYBATCHNUMBER | ><no : falseyes : true |
msdyn_ispurchasepricebybatchnumber | |
| ISPRIMARYSTOCKINGENABLEDFORSERIALNUMBER | ><no : falseyes : true |
msdyn_isprimarystockingenabledforsn | |
| ISPRIMARYSTOCKINGENABLEDFORBATCHNUMBER | ><no : falseyes : true |
msdyn_isprimarystockingenabledforbn | |
| ISPHYSICALINVENTORYENABLEDFORSERIALNUMBER | ><no : falseyes : true |
msdyn_isphysicalinventoryenabledforsn | |
| ISPHYSICALINVENTORYENABLEDFORBATCHNUMBER | ><no : falseyes : true |
msdyn_isphysicalinventoryenabledforbn | |
| ISFINANCIALINVENTORYENABLEDFORSERIALNUMBER | ><no : falseyes : true |
msdyn_isfinancialinventoryenabledforsn | |
| ISFINANCIALINVENTORYENABLEDFORBATCHNUMBER | ><no : falseyes : true |
msdyn_isfinancialinventoryenabledforbn | |
| ISCOVERAGEPLANENABLEDFORSERIALNUMBER | ><no : falseyes : true |
msdyn_iscoverageplanenabledforserialnumber | |
| ISCOVERAGEPLANENABLEDFORBATCHNUMBER | ><no : falseyes : true |
msdyn_iscoverageplanenabledforbatchnumber | |
| ISBLANKRECEIPTALLOWEDFORSERIALNUMBER | ><no : falseyes : true |
msdyn_isblankreceiptallowedforserialnumber | |
| ISBLANKRECEIPTALLOWEDFORBATCHNUMBER | ><no : falseyes : true |
msdyn_isblankreceiptallowedforbatchnumber | |
| ISBLANKISSUEALLOWEDFORSERIALNUMBER | ><no : falseyes : true |
msdyn_isblankissueallowedforserialnumber | |
| ISBLANKISSUEALLOWEDFORBATCHNUMBER | ><no : falseyes : true |
msdyn_isblankissueallowedforbatchnumber | |
| ISBATCHNUMBERACTIVE | ><no : falseyes : true |
msdyn_isbatchnumberactive | |
| ISINVENTORYOWNERACTIVE | ><no : falseyes : true |
msdyn_isinventoryowneractive |
单位转换（msdyn_unitofmeasureconversions）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 分母 | = | msdyn_denominator | |
| 分子 | = | msdyn_numerator | |
| 因素 | = | msdyn_factor | |
| INNEROFFSET | = | msdyn_inneroffset | |
| OUTEROFFSET | = | msdyn_outeroffset | |
| 舍入 | ><nearest : 192350000up : 192350001down : 192350002 |
msdyn_rounding | |
| TOUNITSYMBOL | = | msdyn_tounit.msdyn_symbol | |
| FROMUNITSYMBOL | = | msdyn_fromunit.msdyn_symbol |
单位（乌姆）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| UNITSYMBOL | > | msdyn_symbol | |
| UNITCLASS | > | msdyn_externalunitclassname | |
| DECIMALPRECISION | > | msdyn_decimalprecision | |
| ISBASEUNIT | >>no : falseyes : true |
msdyn_isbaseunit | |
| ISSYSTEMUNIT | >>no : falseyes : true |
msdyn_issystemunit | |
| SYSTEMOFUNITS | >>none : 192350000metric : 192350001us : 192350002 |
msdyn_systemofunits | |
| UNITSYMBOL | > | 姓名 | |
| UNITDESCRIPTION | > | msdyn_description |
供应商文档附件（批注）
此模板在财务和运营应用与 Dataverse 之间同步数据。
源筛选器：（DocumentAttachmentTypeCode == “Note”） ||（DocumentAttachmentTypeCode == “URL”））
反向源筛选器：（objecttypecode eq “msdyn_vendor” 和 msdyn_relatedentityid2 ne null） 或 （objecttypecode eq 'account' and msdyn_relatedentityid2 ne null） 或 （objecttypecode eq 'contact' and msdyn_relatedentityid2 ne null）
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| DOCUMENTID | = | msdyn_notesid | |
| 笔记 | = | notetext | |
| ATTACHMENTDESCRIPTION | = | 主题 | |
| VENDORACCOUNTNUMBER | = | msdyn_relatedentityid2 | |
| DOCUMENTATTACHMENTTYPECODE | << | none | 注释 |
| none | >> | objecttypecode | msdyn_vendor |
| ACCESSRESTRICTION | ><internal : 0external : 1 |
msdyn_restriction |
供应商组（msdyn_vendorgroups）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| DEFAULTPAYMENTTERMNAME | = | msdyn_paymentterms.msdyn_name | |
| 描述 | = | msdyn_description | |
| VENDORGROUPID | = | msdyn_vendorgroup | |
| CLEARINGPERIODPAYMENTTERMNAME | = | msdyn_clearingperiodpaymentpermname.msdyn_name |
供应商付款方式（msdyn_vendorpaymentmethods）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 名称 | = | msdyn_name | |
| 描述 | = | msdyn_description | |
| SUMBYPERIOD | ><transDate : 806380001invoice : 806380000week : 806380002total : 806380003 |
msdyn_sumbyperiod | |
| DISCOUNTGRACEPERIODDAYS | = | msdyn_discountgraceperioddays | |
| PAYMENTSTATUS | ><none : 806380000sent : 806380001recieved : 806380002approved : 806380003rejected : 806380004 |
msdyn_paymentstatus | |
| ALLOWPAYMENTCOPIES | ><no : Falseyes : True |
msdyn_allowpaymentcopies | |
| PAYMENTTYPE | ><blank : 806380000check : 806380001electronicPayment : 806380002promissoryNote : 806380003 |
msdyn_paymenttype | |
| LASTFILENUMBER | = | msdyn_lastfilenumber | |
| LASTFILENUMBERTODAY | = | msdyn_lastfilenumbertoday | |
| ACCOUNTTYPE | ><ledger : 806380000bank : 806380005cust : 806380001fixedAssets : 806380004vend : 806380002project : 806380003 |
msdyn_accounttype | |
| 桥接POSTINGENABLED | ><no : Falseyes : True |
msdyn_bridgingposting | |
| ENABLEPOSTDATEDCHECKCLEARINGPOSTING | ><no : Falseyes : True |
msdyn_postdatedcheckclearingposting | |
| PROMISSORYNOTEDRAFTTYPE | ><noDraft : 806380000noAcceptance : 806380001acceptance : 806380002promissory : 806380003bankAcceptance : 806380004 |
msdyn_promissorynotedrafttype | |
| DIRECTDEBIT | ><no : Falseyes : True |
msdyn_directdebit |
供应商 V2 （msdyn_vendors）
此模板在财务和运营应用与 Dataverse 之间同步数据。
源筛选器：（VendorPartyType == “Organization”） ||（VendorPartyType == “Person”））
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| VENDORACCOUNTNUMBER | = | msdyn_vendoraccountnumber | |
| VENDORGROUPID | = | msdyn_vendorgroupid.msdyn_vendorgroup | |
| VENDORPARTYTYPE | ><person : Trueorganization : False |
msdyn_isperson | |
| CREDITLIMIT | = | msdyn_vendorcreditlimit | |
| ISFOREIGNENTITY | ><no : Falseyes : True |
msdyn_isforeignentity | |
| ISONETIMEVENDOR | ><no : Falseyes : 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 : Falseyes : True |
msdyn_hasonlytakenbids | |
| ISMINORITYOWNED | ><no : Falseyes : True |
msdyn_isminorityowned | |
| ISVENDORLOCALLYOWNED | ><yes : Trueno : False |
msdyn_isvendorlocallyowned | |
| ISSERVICEVETERANOWNED | ><yes : Trueno : False |
msdyn_isserviceveteranowned | |
| ISOWNERDISABLED | ><no : Falseyes : True |
msdyn_ownerisdisabled | |
| ISWOMANOWNER | ><no : Falseyes : True |
msdyn_womanowner | |
| ORGANIZATIONEMPLOYEEAMOUNT | = | msdyn_numberofemployees | |
| VENDORHOLDRELEASEDATE | = | msdyn_vendoronholdreleasedate | |
| VENDORPARTYNUMBER | = | msdyn_partyid.msdyn_partynumber | |
| ONHOLDSTATUS | ><no : 806380000invoice : 806380001all : 806380002payment : 806380003requisition : 806380004never : 806380005 |
msdyn_onholdstatus | |
| CURRENCYCODE | = | msdyn_currencycode.isocurrencycode | |
| ISVENDORLOCATEDINHUBZONE | ><no : Falseyes : True |
msdyn_isvendorlocatedinhubzone | |
| DEFAULTVENDORPAYMENTMETHODNAME | = | msdyn_vendorpaymentmethod.msdyn_name | |
| INVOICEVENDORACCOUNTNUMBER | = | msdyn_invoicevendoraccountnumber.msdyn_vendoraccountnumber | |
| AREPRICESINCLUDINGSALESTAX | ><no : Falseyes : True |
msdyn_priceincludessalestax | |
| SALESTAXGROUPCODE | = | msdyn_taxgroup.msdyn_name | |
| PRIMARYCONTACTPERSONID | = | msdyn_primarycontact.msdyn_contactforpartynumber |
退伍军人身份（cdm_veteranstatuses）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| VETERANSTATUSID | = | cdm_name | |
| 描述 | = | cdm_description | |
| ISPROTECTEDVETERAN | ><no : falseyes : true |
cdm_isprotectedveteran |
仓库位置（msdyn_inventorylocations）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| BINID | = | msdyn_binid | |
| CHECKDIGITS | = | msdyn_checkdigits | |
| GENERATECHECKDIGITS | ><yes : Trueno : False |
msdyn_generatecheckdigits | |
| ISSORTORDERCODEMANUAL | ><yes : Trueno : False |
msdyn_issortordercodemanual | |
| ISWAREHOUSELOCATIONIDMANUAL | ><yes : Trueno : 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 : 192350000pick : 192350001inputPort : 192350002outputPort : 192350003inspectionLocation : 192350004kanbanSupermarket : 192350005 |
msdyn_warehouselocationtype | |
| INPUTWAREHOUSELOCATIONBLOCKINGCAUSEID | = | msdyn_inputwarehouselocationblockingcauseid | |
| OUTPUTWAREHOUSELOCATIONBLOCKINGCAUSEID | = | msdyn_outputwarehouselocationblockingcauseid | |
| ISDEFAULTCREDITONLYRETURNWAREHOUSELOCATION | ><yes : Trueno : False |
msdyn_isdefaultcreditonlyreturnwarehouseloc | |
| ISDEFAULTISSUEWAREHOUSELOCATION | ><yes : Trueno : False |
msdyn_isdefaultissuewarehouselocation | |
| ISDEFAULTKANBANFINISHEDGOODSWAREHOUSELOCATION | ><yes : Trueno : False |
msdyn_isdefaultkanbanfinishedgoodswarehouseloc | |
| ISDEFAULTPRODUCTIONFINISHEDGOODSWAREHOUSELOCATION | ><yes : Trueno : False |
msdyn_isdefaultproductionfinishedgoodswhsloc | |
| ISDEFAULTPRODUCTIONINPUTWAREHOUSELOCATION | ><yes : Trueno : False |
msdyn_isdefaultproductioninputwarehouseloc | |
| ISDEFAULTRECEIPTWAREHOUSELOCATION | ><yes : Trueno : False |
msdyn_isdefaultreceiptwarehouselocation | |
| ISDEFAULTRETAILSTORERETURNWAREHOUSELOCATION | ><yes : Trueno : False |
msdyn_isdefaultretailstorereturnwarehouseloc | |
| ISDEFAULTRETAILSTOREWAREHOUSELOCATION | ><yes : Trueno : False |
msdyn_isdefaultretailstorewarehouselocation | |
| ISDEFAULTSHIPMENTMAINTENANCEWAREHOUSELOCATION | ><yes : Trueno : False |
msdyn_isdefaultshipmentmaintenancewarehouseloc | |
| AGINGDATE | > | msdyn_agingdate | |
| LASTACTIVITYDATETIME | > | msdyn_lastactivitydatetime | |
| LOCATIONSTATUS | >>undetermined : 192350000empty : 192350001picking : 192350002storage : 192350003 |
msdyn_locationstatus | |
| ISITEMINLOCATIONMAINTAINED | ><yes : Trueno : False |
msdyn_isiteminlocationmaintained | |
| ISLOCATIONACTIVITYDATETIMEMAINTAINED | ><yes : Trueno : False |
msdyn_islocationactivitydatetimemaintained | |
| ISLOCATIONSTATUSMAINTAINED | ><yes : Trueno : False |
msdyn_islocationstatusmaintained | |
| ISDEFAULTQUALITYMAINTENANCEWAREHOUSELOCATION | ><yes : Trueno : 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 |
仓库工作标头（msdyn_warehouseworkheaders）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| ACTUALPROCESSINGTIMESECONDS | > | msdyn_actualprocessingtimeseconds | |
| ESTIMATEDPROCESSINGTIMESECONDS | > | msdyn_estimatedprocessingtimeseconds | |
| ISWAREHOUSEWORKBLOCKED | >>yes : Trueno : False |
msdyn_iswarehouseworkblocked | |
| WAREHOUSEID | > | msdyn_warehouse.msdyn_warehouseidentifier | |
| INVENTORYSITEID | > | msdyn_inventorysite.msdyn_siteid | |
| ISWAREHOUSEWORKERMANUALLYASSIGNED | >>yes : Trueno : False |
msdyn_iswarehouseworkermanuallyassigned | |
| WAREHOUSEWORKCANCELLEDDATETIME | > | msdyn_warehouseworkcancelleddatetime | |
| WAREHOUSEWORKCLOSEDDATETIME | > | msdyn_warehouseworkcloseddatetime | |
| WAREHOUSEWORKID | > | msdyn_warehouseworkid | |
| WAREHOUSEWORKPROCESSINGSTARTDATETIME | > | msdyn_warehouseworkprocessingstartdatetime | |
| WAREHOUSEWORKPRIORITY | > | msdyn_warehouseworkpriority | |
| WAREHOUSEWORKSTATUS | >>open : 192350000inprocess : 192350001skipped : 192350002closed : 192350003cancelled : 192350004combined : 192350005 |
msdyn_warehouseworkstatus | |
| WAREHOUSEWORKORDERTYPE | >>qualityOrder : 192350021none : 192350000purch : 192350001sales : 192350002prodPick : 192350003prodPut : 192350004prodProcessPut : 192350005transferIssue : 192350006transferReceipt : 192350007invent : 192350008workCancel : 192350009cycleCount : 192350010replenishment : 192350011returnOrder : 192350012kanbanPut : 192350013kanbanPick : 192350014cycleCountAccepted : 192350015packedContainerPicking : 192350016sortedInventoryPicking : 192350017crossDocking : 192350018qualityInQualityCheck : 192350019qualityItemSampling : 192350020 |
msdyn_warehouseworkordertype | |
| CONTAINERID | > | msdyn_containerid | |
| WAREHOUSEWORKLOCKINGWAREHOUSEMOBILEDEVICEUSERID | > | msdyn_warehouseworklockingmobiledeviceuserid | |
| TARGETLICENSEPLATENUMBER | > | msdyn_targetlicenseplatenumber | |
| WAVEID | > | msdyn_waveid | |
| WAREHOUSEWORKCANCELLINGUSERID | > | msdyn_warehouseworkcancellinguserid | |
| WAREHOUSEWORKMANUALLYCOMPLETINGUSERID | > | msdyn_warehouseworkmanuallycompletinguserid | |
| WAREHOUSEWORKPOOLID | > | msdyn_warehouseworkpoolid |
仓库工作线（msdyn_warehouseworklines）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| ACTUALPROCESSINGTIMESECONDS | > | msdyn_actualprocessingtimeseconds | |
| ESTIMATEDPROCESSINGTIMESECONDS | > | msdyn_estimatedprocessingtimeseconds | |
| FEFOITEMBATCHNUMBER | > | msdyn_fefoitembatchnumber | |
| REMAININGHANDLINGQUANTITY | > | msdyn_remaininghandlingquantity | |
| HANDLINGQUANTITY | > | msdyn_handlingquantity | |
| WORKLINENUMBER | > | msdyn_worklinenumber | |
| ISWORKLINEMANDATORY | >>yes : Trueno : False |
msdyn_isworklinemandatory | |
| REMAININGWORKQUANTITY | > | msdyn_remainingworkquantity | |
| WORKQUANTITY | > | msdyn_workquantity | |
| ISREPLENISHMENTNEEDED | >>yes : Trueno : False |
msdyn_isreplenishmentneeded | |
| SORTORDERCODE | > | msdyn_sortordercode | |
| WORKQUANTITYUNITSYMBOL | > | msdyn_workquantityunit.msdyn_symbol | |
| WAREHOUSEWORKCLOSEDDATETIME | > | msdyn_warehouseworkcloseddatetime | |
| WAREHOUSEWORKID | > | msdyn_warehousework.msdyn_warehouseworkid | |
| WAREHOUSEWORKPROCESSINGSTARTDATETIME | > | msdyn_warehouseworkprocessingstartdatetime | |
| WAREHOUSEWORKSTATUS | >>open : 192350000inProcess : 192350001pendingReview : 192350002skipped : 192350003closed : 192350004cancelled : 192350005combined : 192350006 |
msdyn_warehouseworkstatus | |
| ISWORKEXECUTIONSTOPPED | >>yes : Trueno : False |
msdyn_isworkexecutionstopped | |
| WAREHOUSEWORKTYPE | >>none : 192350000pick : 192350001put : 192350002count : 192350003adjustment : 192350004custom : 192350005quarantine : 192350006licensePlateBuild : 192350007print : 192350008statusChange : 192350009packToNestedLicensePlate : 192350010qualityCheck : 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 |
仓库区域组（msdyn_warehousezonegroups）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| GROUPID | = | msdyn_groupid | |
| GROUPNAME | = | msdyn_groupname |
仓库区域（msdyn_warehousezones）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| WAREHOUSEZONEGROUPID | = | msdyn_warehousezonegroup.msdyn_groupid | |
| ZONEID | = | msdyn_zoneid | |
| ZONENAME | = | msdyn_zonename |
仓库（msdyn_warehouses）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| DEFAULTCONTAINERTYPEID | = | msdyn_defaultcontainertypeid | |
| AREITEMSCOVERAGEPLANNEDMANUALLY | ><no : falseyes : true |
msdyn_areitemscoverageplannedmanually | |
| ARELABORSTANDARDSALLOWED | ><no : falseyes : true |
msdyn_arelaborstandardsallowed | |
| PRIMARYADDRESSBUILDINGCOMPLIMENT | = | msdyn_primaryaddressbuildingcompliment | |
| PRIMARYADDRESSPOSTBOX | = | msdyn_primaryaddresspostbox | |
| PRIMARYADDRESSSTREETNUMBER | = | msdyn_primaryaddressstreetnumber | |
| AREWAREHOUSELOCATIONCHECKDIGITSUNIQUE | ><yes : trueno : false |
msdyn_arewarehouselocationcheckdigitsunique | |
| INVENTORYCOUNTINGREASONCODEPOLICYNAME | = | msdyn_inventorycountingreasoncodepolicyname | |
| AUTOUPDATESHIPMENTRULE | ><always : falseonQuantityDecrease : true |
msdyn_autoupdateshipmentrule | |
| WAREHOUSERELEASERESERVATIONREQUIREMENTRULE | ><notapplicable : 192350000allowpartialreservation : 192350001requirefullreservation : 192350002 |
msdyn_warehousereleasereservationrequirement | |
| EXTERNALLYLOCATEDWAREHOUSEVENDORACCOUNTNUMBER | = | msdyn_externallylocatedwarehousevendoraccountnu | |
| INVENTORYSTATUSCHANGERESERVATIONREMOVALLEVEL | ><none : 192350000reservation : 192350001markingreservation : 192350002 |
msdyn_inventorystatuschangereservationremoval | |
| WAREHOUSEWORKPROCESSINGPOLICYNAME | = | msdyn_warehouseworkprocessingpolicyname | |
| ISFALLBACKWAREHOUSE | ><yes : trueno : false |
msdyn_isfallbackwarehouse | |
| ISFINANCIALNEGATIVERETAILSTOREINVENTORYALLOWED | ><yes : trueno : false |
msdyn_financialnegativestoreinventoryallowed | |
| ISPALLETMOVEMENTDURINGCYCLECOUNTINGALLOWED | ><yes : trueno : false |
msdyn_palletmovementduringcyclecountingallowed | |
| ISPHYSICALNEGATIVERETAILSTOREINVENTORYALLOWED | ><yes : trueno : false |
msdyn_physicalnegativestoreinventoryallowed | |
| ISREFILLEDFROMMAINWAREHOUSE | ><yes : trueno : false |
msdyn_isrefilledfrommainwarehouse | |
| ISRETAILSTOREWAREHOUSE | ><yes : trueno : 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 : falseyes : 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 : 192350000transit : 192350001quarantine : 192350002standard : 192350003itmgit : 192350004itmunder : 192350005 |
msdyn_warehousetype | |
| ISPRIMARYADDRESSASSIGNED | ><yes : trueno : 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 : trueno : false |
msdyn_useadvancedwarehousemanagementprocesses | |
| AREPICKINGLISTSDELIVERYMODESPECIFIC | ><yes : trueno : false |
msdyn_arepickinglistsdeliverymodespecific | |
| AREPICKINGLISTSSHIPMENTSPECIFICONLY | ><yes : trueno : false |
msdyn_arepickinglistshipmentspecificonly | |
| FORMATTEDPRIMARYADDRESS | = | msdyn_formattedprimaryaddress | |
| ISBILLOFLADINGPRINTINGBEFORESHIPMENTCONFIRMATIONENABLED | ><yes : trueno : false |
msdyn_printbillofladingbeforeshipconfirmation | |
| RAWMATERIALPICKINGINVENTORYISSUESTATUS | ><pick : falsereserve : true |
msdyn_rawmaterialpickinginventoryissuestatus | |
| WILLAUTOMATICLOADRELEASERESERVEINVENTORY | ><yes : trueno : false |
msdyn_willautomaticloadreleaseinventory | |
| WILLINVENTORYSTATUSCHANGEREMOVEBLOCKING | ><yes : trueno : false |
msdyn_willinventorystatuschangeremoveblocking | |
| WILLMANUALLOADRELEASERESERVEINVENTORY | ><yes : trueno : false |
msdyn_willmanualloadreleasereserveinventory | |
| WILLORDERRELEASINGCONSOLIDATESHIPMENTS | ><yes : trueno : false |
msdyn_willorderreleasingconsolidateshipments | |
| WILLPRODUCTIONBOMSRESERVEWAREHOUSELEVELONLY | ><yes : trueno : false |
msdyn_productionbomsreservewarehouselevel | |
| WILLSHIPPINGCANCELLATIONDECREMENTLOADQUANITY | ><yes : trueno : false |
msdyn_shippingcanceldecrementloadquantity | |
| WILLWAREHOUSELOCATIONIDINCLUDEBINIDBYDEFAULT | ><yes : trueno : false |
msdyn_warehouselocationidincludeblindid | |
| WILLWAREHOUSELOCATIONIDINCLUDERACKIDBYDEFAULT | ><yes : trueno : false |
msdyn_warehouselocationincluderackidbydefault | |
| WILLWAREHOUSELOCATIONIDINCLUDESHELFIDBYDEFAULT | ><yes : trueno : false |
msdyn_warehouselocationidincludeshelfid |
预扣税法（msdyn_withholdingtaxcodes）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| WITHHOLDINGCODE | = | msdyn_name | |
| WITHHOLDINGTAXNAME | = | msdyn_description | |
| WITHHOLDINGTAXROUNDOFF | = | msdyn_roundoff | |
| WITHHOLDINGTAXROUNDOFFTYPE | ><ordinary : 192350000roundDown : 192350001roundUp : 192350002 |
msdyn_roundofftype | |
| CURRENCYCODEID | = | msdyn_currency.isocurrencycode | |
| WITHHOLDINGTAXBASE | ><pctPerNet : 192350000pctPerGross : 192350001 |
msdyn_taxableamountorigin |
预扣税组（msdyn_withholdingtaxgroups）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| WITHHOLDINGTAXGROUPCODE | = | msdyn_name | |
| 描述 | = | msdyn_description |
工作人员 (cdm_workers)
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| PERSONNELNUMBER | = | cdm_workernumber | |
| 名字 | = | cdm_firstname | |
| MIDDLENAME | = | cdm_middlename | |
| 姓 | = | cdm_lastname | |
| WORKERTYPE | >>employee : 754400000contractor : 754400001both : 754400000 |
cdm_type | |
| WORKERSTATUS | >>employed : 754400000pending : 754400001terminated : 754400001 |
cdm_status | |
| PRIMARYCONTACTEMAIL | = | cdm_primaryemailaddress | |
| PRIMARYCONTACTPHONE | = | cdm_primarytelephone | |
| PRIMARYCONTACTFACEBOOK | = | cdm_facebookidentity | |
| PRIMARYCONTACTTWITTER | = | cdm_twitteridentity | |
| PRIMARYCONTACTLINKEDIN | = | cdm_linkedinidentity | |
| PRIMARYCONTACTURL | = | cdm_websiteurl | |
| GENDER | ><male : 754400000female : 754400001nonSpecific : 754400003none : 754400002 |
cdm_gender | |
| BIRTHDATE | = | cdm_birthdate | |
| 名称 | > | cdm_fullname |
CDS 位置角色（msdyn_addressroles）
此模板在财务和运营应用与 Dataverse 之间同步数据。
| 财务和运营字段 | 地图类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| ISCONTACTINFORMATION | ><yes : trueno : false |
msdyn_iselectronicaddressrole | |
| ISPOSTALADDRESS | ><yes : trueno : false |
msdyn_ispostaladdressrole | |
| 目的 | = | msdyn_name |
传输订单标头
| 财务和运营字段 | 映射类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 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 |
转移订单产品
| 财务和运营字段 | 映射类型 | 客户参与列 | 默认值 |
|---|---|---|---|
| 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 |