二重書き込みマッピングのリファレンス

テーブルのマッピング

マッピング タイプ

さまざまな異なるマッピング タイプがあります。 次の表は、テンプレート テーブルで使用される記号について説明します。

記号 説明
> 一方向
>> 一方向、データはプロセス内で変換されます。
= 双方向
>< 双方向、データはプロセス内で変換されます。
<< 一方向、データはプロセス内で変換されます。

フィルター

ソースフィルタとリバースソースフィルタによって、どの行が同期されるかが決まります。

既定値

財務と運用テーブルまたは顧客エンゲージメントテーブルのいずれにも同期フィールドが存在しない場合は、同期テーブルに既定値が割り当てられます。 場合によっては、デフォルト値は、Dataverse 内の属性値へのルックアップである整数となります。 たとえば、連絡先テーブルでは、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 製品
CDS 販売注文ヘッダー 販売注文
CDS 販売注文明細行 販売注文詳細
CDS 販売見積ヘッダー 見積
CDS 販売見積明細行 見積詳細
勘定科目表 msdyn_chartofaccountses
カラー 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 勘定
顧客 V3 連絡先
意思決定ロール msdyn_decisionmakingroles
既定の注文設定 msdyn_productdefaultordersettings
DV リリース済み特徴的製品 製品
DV リリース済み製品 msdyn_sharedproductdetails
Dynamics 365 Sales 機能管理の状態 msdyn_supplychainfeaturestates
Dynamics 365 Sales 注文ヘッダー 販売注文
Dynamics 365 Sales 注文明細行 販売注文詳細
Dynamics 365 Sales 見積書ヘッダー 見積
Dynamics 365 Sales 見積明細行 見積詳細
雇用職務権限 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
Mixed Reality ガイド エンティティ msmrw_guides
配送モード msdyn_shipvias
名前の接辞 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
見込顧客 leads
発注書のヘッダー ドキュメントの添付ファイル 注釈
発注書ヘッダー 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 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PRODUCTNAME > msdyn_productname
PRODUCTNUMBER > msdyn_productnumber

資産管理資産のライフサイクル モデル (msdyn_assetlifecyclemodels)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
ACTIVELIFECYCLESTATEID = msdyn_activelifecyclestate.msdyn_assetlifecyclestate_id
INBOUNDLIFECYCLESTATEID = msdyn_inboundlifecyclestate.msdyn_assetlifecyclestate_id
INSTORAGELIFECYCLESTATEID = msdyn_instoragelifecyclestate.msdyn_assetlifecyclestate_id
LIFECYCLEMODELID = msdyn_assetlifecyclemodel_id
NAME = msdyn_name
ONLOANLIFECYCLESTATEID = msdyn_onloanlifecyclestate.msdyn_assetlifecyclestate_id
OUTBOUNDLIFECYCLESTATEID = msdyn_outboundlifecyclestate.msdyn_assetlifecyclestate_id
RECEIVEDLIFECYCLESTATEID = msdyn_receivedlifecyclestate.msdyn_assetlifecyclestate_id

資産管理資産のライフサイクル状態 (msdyn_assetlifecyclestates)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
DELETEOPENCALENDARLINES ><
yes : True
no : False
msdyn_deleteopencalendarlines
LIFECYCLESTATEID = msdyn_assetlifecyclestate_id
LINE = msdyn_line
MAINTENANCEASSETACTIVE ><
yes : True
no : False
msdyn_maintenanceassetactive
NAME = msdyn_name

資産管理資産のタイプ (msdyn_customerassetcategories)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
LIFECYCLEMODELID = msdyn_lifecyclemodel.msdyn_assetlifecyclemodel_id
MAINTENANCEASSETTYPEID = msdyn_maintenanceassettypeid
NAME = msdyn_name
CALCULATEKPITOTAL ><
no : False
yes : True
msdyn_calculatekpitotal

資産管理資産 (msdyn_customerassets)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
ACQUISITIONCOST = msdyn_acquisitioncost
ACQUISITIONDATE = msdyn_acquisitiondate
ACTIVEFROM = msdyn_activefrom
ACTIVETO = msdyn_activeto
FUNCTIONALLOCATIONID = msdyn_functionallocation.msdyn_functionallocation_id
MAINTENANCEASSETLIFECYCLESTATEID = msdyn_assetlifecyclestate.msdyn_assetlifecyclestate_id
MODELID = msdyn_model.msdyn_model_id
MODELPRODUCTID = msdyn_model.msdyn_manufacturer.msdyn_manufacturer_id
MODELYEAR = msdyn_modelyear
NAME = msdyn_name
メモ = 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 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
LIFECYCLEMODELID = msdyn_functionallocationlifecyclemodel_id
NAME = msdyn_name

資産管理機能の場所のライフサイクル状態 (msdyn_functionallocationlifecyclestates)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
ALLOWDELETELOCATION ><
yes : True
no : False
msdyn_allowdeletelocation
ALLOWNEWSUBLOCATIONS ><
yes : True
no : False
msdyn_allownewsublocations
ALLOWRENAMELOCATION ><
yes : True
no : False
msdyn_allowrenamelocation
FUNCTIONALLOCATIONACTIVE ><
yes : True
no : False
msdyn_functionallocationactive
LIFECYCLESTATEID = msdyn_functionallocationlifecyclestate_id
NAME = msdyn_name
ALLOWINSTALLMAINTENANCEASSETS ><
yes : True
no : False
msdyn_allowinstallmaintenanceassets
CREATELOCATIONMAINTENANCEASSET ><
yes : True
no : False
msdyn_createlocationmaintenanceasset
MAINTENANCEASSETLIFECYCLESTATEID = msdyn_assetlifecyclestate.msdyn_assetlifecyclestate_id

資産管理機能の場所のタイプ (msdyn_functionallocationtypes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
ALLOWMULTIPLEINSTALLEDASSETS ><
yes : True
no : False
msdyn_allowmultipleinstalledassets
FUNCTIONALLOCATIONTYPEID = msdyn_functionallocationtype_id
NAME = msdyn_name
UPDATEASSETDIMENSION ><
yes : True
no : False
msdyn_updateassetdimension
LIFECYCLEMODELID = msdyn_lifecyclemodelid.msdyn_functionallocationlifecyclemodel_id
MAINTENANCEASSETTYPEID = msdyn_maintenanceassettype.msdyn_maintenanceassettypeid

資産管理機能の場所のタイプ (msdyn_functionallocations)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
FUNCTIONALLOCATIONID = msdyn_functionallocation_id
INVENTORYLOCATIONID = msdyn_inventorylocationid
INVENTORYSITEID = msdyn_inventorysiteid
NAME = 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 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
説明 = msdyn_description
PRODUCTID = msdyn_manufacturer_id

資産管理モデル (msdyn_models)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
説明 = msdyn_description
MODELID = msdyn_model_id
PRODUCTID = msdyn_manufacturer.msdyn_manufacturer_id
MAINTENANCEASSETTYPEID = msdyn_maintenanceassettype.msdyn_maintenanceassettypeid

資産管理の保証 (msdyn_warranties)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
NAME = msdyn_name
WARRANTYID = msdyn_warranty_id

CDS 連絡先 V2 (連絡先)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

ソース フィルター: (AssociatedContactType = 1)

取消済ソース フィルター: msdyn_contactforvendor eq true および msdyn_sellable eq false および msdyn_contactpersonid ne null

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CONTACTPERSONPARTYNUMBER = msdyn_partyid.msdyn_partynumber
ASSOCIATEDCONTACTTYPE << なし 仕入先
ASSOCIATEDCONTACTNUMBER = msdyn_vendorcontactid.msdyn_vendoraccountnumber
EMPLOYMENTDEPARTMENT = 部門
メモ = 説明
GOVERNMENTIDENTIFICATIONNUMBER = governmentid
ISRECEIVINGDIRECTMAIL ><
no : False
yes : True
donotemail
SPOUSENAME = spousesname
なし >> msdyn_contactforvendor True
CONTACTPERSONID = msdyn_contactpersonid

CDS 為替レート (msdyn_currencyexchangerates)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
EXCHANGERATETYPENAME > msdyn_currencyexchangeratepair.msdyn_currencyexchangeratetypeid.msdyn_name
FROMCURRENCYCODE > msdyn_currencyexchangeratepair.msdyn_fromtransactioncurrencyid.isocurrencycode
TOCURRENCYCODE > msdyn_currencyexchangeratepair.msdyn_totransactioncurrencyid.isocurrencycode
RATE > msdyn_exchangerate
VALIDFROM > msdyn_validfrom
VALIDTO > msdyn_validto

CDS 関係者 (msdyn_parties)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

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

CDS 当事者の住所場所 (msdyn_partypostaladdresses)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
ISPRIMARY ><
no : False
yes : True
msdyn_isprimary
LOCATIONID = msdyn_postaladdresscollectionid.msdyn_location
PARTYNUMBER = msdyn_partyid.msdyn_partynumber
PURPOSE = msdyn_postaladdresspurposenames
ISLOCATIONOWNER >>
no : False
yes : True
msdyn_islocationowner

CDS 在庫の手持在庫エントリー (msdyn_inventoryonhandentries)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
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 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
REQUESTID = msdyn_requestid
PRODUCTNUMBER < msdyn_product.msdyn_productnumber
ISATPCALCULATION <<
no : False
yes : True
msdyn_isatpcalculation
ORDERQUANTITY < msdyn_orderquantity
INVENTORYSITEID < msdyn_inventorysite.msdyn_siteid
INVENTORYWAREHOUSEID < msdyn_inventorywarehouse.msdyn_warehouseidentifier
REFERENCENUMBER < msdyn_referencenumber
LINECREATIONSEQUENCENUMBER < msdyn_linecreationsequencenumber

CDS 住所履歴 V2 (msdyn_postaladdresses)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
LOCATIONID = msdyn_postaladdresscollectionid.msdyn_location
VALIDFROM = msdyn_validfrom
VALIDTO = msdyn_validto
説明 = msdyn_name
STREET = msdyn_street
STREETNUMBER = msdyn_streetnumber
CITY = msdyn_city
STATE = msdyn_state
COUNTRYREGIONID = msdyn_countryregionid
ZIPCODE = msdyn_zipcode
COUNTY = msdyn_county
DISTRICTNAME = msdyn_district
BUILDINGCOMPLIMENT = msdyn_buildingcompliment
POSTBOX = msdyn_postbox

CDS 住所場所 (msdyn_postaladdresscollections)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
説明 = msdyn_description
LOCATIONID = msdyn_location

CDS 発注書明細行のエンティティ (msdyn_purchaseorderproducts)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
REQUESTEDDELIVERYDATE = msdyn_dateexpected
LINEDESCRIPTION = msdyn_description
LINENUMBER = msdyn_lineorder
PRODUCTNUMBER = msdyn_product.msdyn_productnumber
PURCHASEORDERNUMBER = msdyn_purchaseorder.msdyn_name
ORDEREDPURCHASEQUANTITY = msdyn_quantity
LINEAMOUNT > msdyn_lineamount
PURCHASEPRICE > msdyn_unitcost
BARCODE = msdyn_barcode
CATCHWEIGHTUNITSYMBOL = msdyn_catchweightunitsymbol.msdyn_symbol
CONFIRMEDSHIPPINGDATE = msdyn_confirmedshippingdate
CUSTOMERREFERENCE = msdyn_customerreference
CUSTOMERREQUISITIONNUMBER = msdyn_customerrequisitionnumber
EXTERNALITEMNUMBER = msdyn_externalitemnumber
ISPARTIALDELIVERYPREVENTED ><
yes : true
no : false
msdyn_ispartialdeliveryprevented
LINEDISCOUNTAMOUNT > msdyn_linediscountamount
LINEDISCOUNTPERCENTAGE > msdyn_linediscountpercentage
ORDEREDCATCHWEIGHTQUANTITY = msdyn_orderedcatchweightquantity
PURCHASEORDERLINESTATUS >>
none : 192350000
backorder : 192350001
received : 192350002
invoiced : 192350003
canceled : 192350004
msdyn_purchaseorderlinestatus
PURCHASEPRICEQUANTITY = msdyn_purchasepricequantity
RECEIVINGSITEID = msdyn_receivingsiteid.msdyn_siteid
REQUESTEDSHIPPINGDATE = msdyn_requestedshippingdate
REQUESTERPERSONNELNUMBER = msdyn_requesterpersonnelnumber.cdm_workernumber
PROCUREMENTPRODUCTCATEGORYNAME > msdyn_procurementproductcategory.msdyn_name
PROCUREMENTPRODUCTCATEGORYHIERACHYNAME > msdyn_procurementproductcategory.msdyn_hierarchy.msdyn_name
CURRENCYCODE > transactioncurrencyid.isocurrencycode
CONFIRMEDDELIVERYDATE = msdyn_confirmeddeliverydate
DELIVERYADDRESSCITY > msdyn_deliveryaddresscity
DELIVERYADDRESSCOUNTRYREGIONID > msdyn_deliveryaddresscountryregionid
DELIVERYADDRESSSTATEID > msdyn_deliveryaddressstate
DELIVERYADDRESSSTREET > msdyn_deliveryaddressstreet
DELIVERYADDRESSSTREETNUMBER > msdyn_deliveryaddressstreetnumber
DELIVERYADDRESSZIPCODE > msdyn_deliveryaddresszipcode
FORMATTEDDELVERYADDRESS > msdyn_formatteddeliveryaddress
PURCHASEUNITSYMBOL = msdyn_unit.msdyn_symbol
RECEIVINGWAREHOUSEID = msdyn_associatetowarehouse.msdyn_warehouseidentifier
DELIVERYADDRESSDESCRIPTION > msdyn_deliveryaddressdescription
DELIVERYADDRESSNAME > msdyn_deliveryaddressname

ソフトウェアによって削除された CDS 発注書明細行のエンティティ (msdyn_purchaseorderproducts)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
LINENUMBER > msdyn_lineorder
PURCHASEORDERNUMBER > msdyn_purchaseorder.msdyn_name
ISDELETED >>
yes : true
no : false
msdyn_issoftdeletedinscm

CDS リリース済の特徴的製品 (products)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PRODUCTNUMBER > msdyn_productnumber
PRODUCTNAME > name
PRODUCTDESCRIPTION > description
ITEMNUMBER > msdyn_itemnumber
CURRENCYCODE > transactioncurrencyid.isocurrencycode
SALESUNITSYMBOL > defaultuomid.msdyn_symbol
SALESPRICE > 価格
UNITCOST > currentcost
PRODUCTTYPE >>
item : 1
service : 3
producttypecode
SALESUNITDECIMALPRECISION >> quantitydecimal 0
ISCATCHWEIGHTPRODUCT >>
no : false
yes : true
msdyn_iscatchweight
ISSTOCKEDPRODUCT >>
no : False
yes : True
msdyn_isstockedproduct
PRODUCTCOLORID > msdyn_productcolor.msdyn_productcolorname
PRODUCTCONFIGURATIONID > msdyn_productconfiguration.msdyn_productconfiguration
PRODUCTSIZEID > msdyn_productsize.msdyn_productsize
PRODUCTSTYLEID > msdyn_productstyle.msdyn_productstyle
FIELDSERVICEPRODUCTTYPE >>
Inventory : 690970000
NonInventory : 690970001
Service : 690970002
msdyn_fieldserviceproducttype
[なし] >> msdyn_shouldsyncwithsharedproductdetails

CDS 販売注文ヘッダー (salesorders)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

取消済ソース フィルター: msdyn_ordertype eq 192350000

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

CDS 販売注文明細行 (salesorderdetails)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CURRENCYCODE > transactioncurrencyid.isocurrencycode
DELIVERYADDRESSCITY = shipto_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE ><
us : united states
de : germany
fr : france
gb : united kingdom
jp : japan
in : india
es : spain
nz : new zealand
au : australia
co : columbia
za : south africa
be : belgium
ca : canada
at : austria
tr : türkiye
cn : china
dk : denmark
se : sweden
no : norway
fi : finland
eg : egypt
shipto_country
DELIVERYADDRESSZIPCODE = shipto_postalcode
DELIVERYADDRESSSTATEID = shipto_stateorprovince
DELIVERYADDRESSSTREET = shipto_line1
DELIVERYADDRESSSTREETNUMBER = shipto_line2
LINEAMOUNT > extendedamount
LINECREATIONSEQUENCENUMBER = sequencenumber
ORDEREDSALESQUANTITY = quantity
PRODUCTNAME = 説明
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 : False
yes : True
msdyn_isdeliveryaddressspecific
ISDELIVERYADDRESSPRIVATE ><
no : False
yes : True
msdyn_isdeliveryaddressprivate
ISLINESTOPPED ><
no : False
yes : True
msdyn_islinestopped
ALLOWEDOVERDELIVERYPERCENTAGE = msdyn_allowedoverdeliverypercentage
ALLOWEDUNDERDELIVERYPERCENTAGE = msdyn_allowedunderdeliverypercentage
CONFIRMEDSHIPPINGDATE = msdyn_confirmedshippingdate
CONFIRMEDRECEIPTDATE = msdyn_confirmedreceiptdate
DELIVERYADDRESSCOUNTYID = msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION = msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME = msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER = msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLATITUDE = msdyn_deliveryaddresslatitude
DELIVERYADDRESSLOCATIONID = msdyn_deliveryaddresslocationid
DELIVERYADDRESSLONGITUDE = msdyn_deliveryaddresslongitude
DELIVERYADDRESSNAME = msdyn_deliveryaddressname
DELIVERYADDRESSPOSTBOX = msdyn_deliveryaddresspostbox
DELIVERYBUILDINGCOMPLIMENT = msdyn_deliverybuildingcompliment
EXTERNALITEMNUMBER = msdyn_externalitemnumber
FIXEDPRICECHARGES = msdyn_fixedpricecharges
FORMATTEDDELIVERYADDRESS = msdyn_formatteddeliveryaddress
LINEDESCRIPTION = msdyn_linedescription
LINEDISCOUNTAMOUNT = msdyn_linediscountamount
LINEDISCOUNTPERCENTAGE = msdyn_linediscountpercentage
MULTILINEDISCOUNTAMOUNT = msdyn_multilinediscountamount
MULTILINEDISCOUNTPERCENTAGE = msdyn_multilinediscountpercentage
REQUESTEDRECEIPTDATE = msdyn_requestedreceiptdate
REQUESTEDSHIPPINGDATE = requestdeliveryby
SALESORDERLINESTATUS >>
none : 192350000
backorder : 192350001
delivered : 192350002
invoiced : 192350003
canceled : 192350004
msdyn_linestatus
SALESORDERPROMISINGMETHOD ><
none : 192350000
salesLeadTime : 192350001
atp : 192350002
atpPlusIssueMargin : 192350003
ctp : 192350004
msdyn_salesorderpromisingmethod
SALESPRICEQUANTITY = msdyn_salespricequantity
SHIPPINGSITEID = msdyn_shippingsite.msdyn_siteid
SHIPPINGWAREHOUSEID = msdyn_shippingwarehouse.msdyn_warehouseidentifier
なし >> ispriceoverridden はい
TOTALCHARGESAMOUNT > msdyn_totalchargesamount
DELIVERYMODECODE = msdyn_deliverymode.msdyn_name
DELIVERYTERMSID = msdyn_deliveryterms.msdyn_termscode

CDS 販売見積ヘッダー (quotes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

取消済ソース フィルター: msdyn_ordertype eq 192350000 and statecode eq 0

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

CDS 販売見積明細行 (quotedetails)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

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

勘定科目表 (msdyn_chartofaccountses)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
説明 = msdyn_description
MAINACCOUNTMASK = msdyn_mainaccountmask
CHARTOFACCOUNTS = msdyn_name

色 (msdyn_productcolors)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
COLORID > msdyn_productcolorname

報酬ジョブ機能 (cdm_jobfunctions)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
JOBFUNCTIONID = cdm_name
説明 = cdm_description

報酬ジョブ タイプ (cdm_jobtypes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
JOBTYPEID = cdm_name
説明 = cdm_description
EXEMPTSTATUS ><
exempt : 754400000
nonexempt : 754400001
doesnotapply : 754400002
cdm_exemptstatus

結句 (msdyn_complimentaryclosings)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CLOSINGPHRASE = msdyn_closingphrase

コンフィギュレーション (msdyn_productconfigurations)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CONFIGURATIONID > msdyn_productconfiguration

連絡担当者の肩書き (msdyn_salescontactpersontitles)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
JOBTITLE = msdyn_jobtitle
JOBTITLEALIAS = msdyn_jobtitlealias

連絡先 V2 (msdyn_contactforparties)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

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

通貨 (transactioncurrencies)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

ソース フィルター: ((CURRENCYCODE != "999"))

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CURRENCYCODE = isocurrencycode
NAME = currencyname
SYMBOL = currencysymbol
なし >> exchangerate 1.0000000000

顧客の添付ファイル (annotations)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

ソース フィルター: ((TypeId == "Note") || (TypeId == "URL"))

取消済ソース フィルター: (objecttypecode eq 'account' または objecttypecode eq 'contact') および msdyn_relatedentityid ne null

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
DOCUMENTID = msdyn_notesid
NAME = subject
なし >> objecttypecode 勘定
CUSTOMERACCOUNTNUMBER = msdyn_relatedentityid
TYPEID << なし メモ
メモ = notetext
RESTRICTION ><
internal : 0
external : 1
msdyn_restriction

顧客グループ (msdyn_customergroups)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CUSTOMERGROUPID = msdyn_groupid
説明 = msdyn_description
ISSALESTAXINCLUDEDINPRICE ><
no : False
yes : True
msdyn_issalestaxincludedinprice
PAYMENTTERMID = msdyn_paymenttermid.msdyn_name
CLEARINGPERIODPAYMENTTERMNAME = msdyn_clearingperiodpaymenttermname.msdyn_name

顧客階層 (msdyn_customerhierarchies)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CUSTOMERHIERARCHYID = msdyn_customerhierarchynumber
NAME = msdyn_name
ORGANIZATIONPARTYNUMBER = msdyn_organizationpartynumber.msdyn_partynumber
PURPOSE ><
B2BOrganization : 192350000
msdyn_purpose

顧客階層ノード (msdyn_customerhierarchynodes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CUSTOMERHIERARCHYID = msdyn_customerhierarchynumber.msdyn_customerhierarchynumber
NODEPARTYNUMBER = msdyn_nodepartynumber.msdyn_partynumber
NODETYPE ><
Customer : 192350000
msdyn_nodetype
ROLE ><
Admin : 192350000
User : 192350001
msdyn_role

顧客支払方法 (msdyn_customerpaymentmethods)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
NAME = msdyn_name
ACCOUNTTYPE ><
ledger : 806380000
cust : 806380001
vend : 806380002
project : 806380003
fixedassets : 806380004
bank : 806380005
msdyn_accounttype
DISCOUNTGRACEPERIODDAYS = msdyn_discountgraceperioddays
BRIDGINGPOSTINGENABLED ><
no : False
yes : True
msdyn_bridgingpostingenabled
ISSEPA ><
no : False
yes : True
msdyn_issepa
LASTFILENUMBER = msdyn_lastfilenumber
LASTFILENUMBERTODAY = msdyn_lastfilenumbertoday
説明 = msdyn_description
PAYMENTTYPE ><
other : 806380000
electronicPayment : 806380001
check : 806380002
billOfExchange : 806380003
creditCard : 806380004
msdyn_paymenttype
CREATEANDDRAWBILLOFEXCHANGEDURINGINVOICEPOSTING ><
no : False
yes : True
msdyn_invoiceupdate
PAYMENTSTATUS ><
none : 806380000
sent : 806380001
recieved : 806380002
confirmed : 806380003
rejected : 806380004
msdyn_paymentstatus
SUMBYPERIOD ><
invoice : 806380000
week : 806380002
total : 806380003
transDate : 806380001
msdyn_sumbyperiod
ENABLEPOSTDATEDCHECKCLEARINGPOSTING ><
no : False
yes : True
msdyn_enablepostdatescheckclearingposting
BILLOFEXCHANGEDRAFTTYPE ><
acceptance : 806380002
promissory : 806380003
bankAcceptance : 806380004
nodraft : 806380000
noacceptance : 806380001
msdyn_billofexchangedrafttype
DIRECTDEBIT ><
no : False
yes : True
msdyn_directdebit

顧客 V3 (アカウント)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

ソース フィルター: ((PartyType == "組織"))

取消済ソース フィルター: customertypecode eq 3

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CUSTOMERACCOUNT = accountnumber
CREDITLIMIT = creditlimit
SALESCURRENCYCODE = transactioncurrencyid.isocurrencycode
SALESMEMO = 説明
CREDITLIMITISMANDATORY ><
no : False
yes : True
msdyn_creditlimitismandatory
CREDITRATING = msdyn_creditrating
CUSTOMERGROUPID = msdyn_customergroupid.msdyn_groupid
IDENTIFICATIONNUMBER = msdyn_identificationnumber
INVOICEACCOUNT = msdyn_billingaccount.accountnumber
ISONETIMECUSTOMER ><
no : False
yes : True
msdyn_onetimecustomer
ONHOLDSTATUS ><
no : 806380000
invoice : 806380001
all : 806380002
payment : 806380003
requisition : 806380004
never : 806380005
msdyn_onholdstatus
PARTYCOUNTRY = msdyn_partycountry
PARTYSTATE = msdyn_partystateprovince
PAYMENTDAY = msdyn_paymentday.msdyn_name
PAYMENTMETHOD = msdyn_customerpaymentmethod.msdyn_name
PAYMENTSCHEDULE = msdyn_paymentschedule.msdyn_name
PAYMENTTERMS = msdyn_paymentterm.msdyn_name
PAYMENTTERMSBASEDAYS = msdyn_paymenttermsbasedays
TAXEXEMPTNUMBER = msdyn_taxexemptnumber
VENDORACCOUNT = msdyn_vendor.msdyn_vendoraccountnumber
なし >> customertypecode 3
PARTYTYPE << なし 組織
PARTYNUMBER = msdyn_partyid.msdyn_partynumber
CONTACTPERSONID = msdyn_primarycontact.msdyn_contactforpartynumber
SALESTAXGROUP = msdyn_salestaxgroup.msdyn_name

顧客 V3 (連絡先)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

ソース フィルター: ((PartyType == "個人"))

取消済ソース フィルター: msdyn_sellable eq true および msdyn_contactpersonid ne null

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
なし >> msdyn_sellable True
PARTYTYPE << なし 個人
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 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
ROLEDESCRIPTION = msdyn_roledescription
ROLENAME = msdyn_rolename

既定の注文設定 (msdyn_productdefaultordersettings)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
INVENTWAREHOUSEID = msdyn_inventorywarehouse.msdyn_warehouseidentifier
INVENTORYSITEID = msdyn_inventorysite.msdyn_siteid
INVENTORYATPDELAYEDDEMANDOFFSETDAYS = msdyn_inventoryatpdelayeddemandoffsetdays
INVENTORYATPDELAYEDSUPPLYOFFSETDAYS = msdyn_inventoryatpdelayedsupplyoffsetdays
ITEMNUMBER = msdyn_itemnumber.msdyn_itemnumber
INVENTORYATPBACKWARDDEMANDTIMEFENCEDAYS = msdyn_inventoryatpbackwarddemandtimefencedays
INVENTORYATPBACKWARDSUPPLYTIMEFENCEDAYS = msdyn_inventoryatpbackwardsupplytimefencedays
INVENTORYATPTIMEFENCEDAYS = msdyn_inventoryatptimefencedays
MAXIMUMINVENTORYORDERQUANTITY = msdyn_maximuminventoryorderquantity
MAXIMUMPROCUREMENTORDERQUANTITY = msdyn_maximumprocurementorderquantity
MAXIMUMSALESORDERQUANTITY = msdyn_maximumsalesorderquantity
MINIMUMINVENTORYORDERQUANTITY = msdyn_minimuminventoryorderquantity
MINIMUMPROCUREMENTORDERQUANTITY = msdyn_minimumprocurementorderquantity
MINIMUMSALESORDERQUANTITY = msdyn_minimumsalesorderquantity
STANDARDINVENTORYORDERQUANTITY = msdyn_standardinventoryorderquantity
STANDARDPROCUREMENTORDERQUANTITY = msdyn_standardprocurementorderquantity
STANDARDSALESORDERQUANTITY = msdyn_standardsalesorderquantity
INVENTORYLEADTIMEDAYS = msdyn_inventoryleadtimedays
INVENTORYQUANTITYMULTIPLES = msdyn_inventoryquantitymultiples
PROCUREMENTQUANTITYMULTIPLES = msdyn_procurementquantitymultiples
SALESQUANTITYMULTIPLES = msdyn_salesquantitymultiples
PROCUREMENTSITEID = msdyn_procurementsite.msdyn_siteid
PROCUREMENTLEADTIMEDAYS = msdyn_procurementleadtimedays
SALESSITEID = msdyn_salessite.msdyn_siteid
SALESATPDELAYEDDEMANDOFFSETDAYS = msdyn_salesatpdelayeddemandoffsetdays
SALESATPDELAYEDSUPPLYOFFSETDAYS = msdyn_salesatpdelayedsupplyoffsetdays
SALESATPBACKWARDDEMANDTIMEFENCEDAYS = msdyn_salesatpbackwarddemandtimefencedays
SALESATPBACKWARDSUPPLYTIMEFENCEDAYS = msdyn_salesatpbackwardsupplytimefencedays
SALESATPTIMEFENCEDAYS = msdyn_salesatptimefencedays
SALESLEADTIMEDAYS = msdyn_salesleadtimedays
PROCUREMENTWAREHOUSEID = msdyn_procurementwarehouse.msdyn_warehouseidentifier
SALESWAREHOUSEID = msdyn_saleswarehouse.msdyn_warehouseidentifier
AREINVENTORYORDERPROMISINGDEFAULTSOVERRIDDEN ><
no : False
yes : True
msdyn_areinventoryorderdefaultsoverridden
INVENTORYORDERPROMISINGMETHOD ><
none : 192350000
salesLeadTime : 192350001
atp : 192350002
atpPlusIssueMargin : 192350003
ctp : 192350004
msdyn_inventoryorderpromisingmethod
ISINVENTORYATPINCLUDINGPLANNEDORDERS ><
false : False
true : True
msdyn_isinventoryatpincludingplannedorders
ISINVENTORYUSINGWORKINGDAYS ><
no : False
yes : True
msdyn_isinventoryusingworkingdays
ISINVENTORYSITEMANDATORY ><
no : False
yes : True
msdyn_isinventorysitemandatory
ISINVENTORYPROCESSINGSTOPPED ><
no : False
yes : True
msdyn_isinventoryprocessingstopped
ISPROCUREMENTUSINGWORKINGDAYS ><
no : False
yes : True
msdyn_isprocurementusingworkingdays
ISPROCUREMENTSITEMANDATORY ><
no : False
yes : True
msdyn_isprocurementsitemandatory
ISPROCUREMENTPROCESSINGSTOPPED ><
no : False
yes : True
msdyn_isprocurementprocessingstopped
ARESALESORDERPROMISINGDEFAULTSOVERRIDDEN ><
no : False
yes : True
msdyn_aresalesorderdefaultsoverridden
SALESORDERPROMISINGMETHOD ><
none : 192350000
salesLeadTime : 192350001
atp : 192350002
atpPlusIssueMargin : 192350003
ctp : 192350004
msdyn_salesorderpromisingmethod
ISSALESATPINCLUDINGPLANNEDORDERS ><
false : False
true : True
msdyn_issalesatpincludingplannedorders
ISSALESSITEMANDATORY ><
no : False
yes : True
msdyn_issalessitemandatory
ISSALESLEADTIMEOVERRIDDEN ><
no : False
yes : True
msdyn_issalesleadtimeoverridden
ISSALESPROCESSINGSTOPPED ><
no : False
yes : True
msdyn_issalesprocessingstopped
ISINVENTORYWAREHOUSEMANDATORY ><
no : False
yes : True
msdyn_isinventorywarehousemandatory
ISPROCUREMENTWAREHOUSEMANDATORY ><
no : False
yes : True
msdyn_isprocurementwarehousemandatory
ISSALESWAREHOUSEMANDATORY ><
no : False
yes : True
msdyn_issaleswarehousemandatory

DV リリース済特徴的製品 (products)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PRODUCTNUMBER > msdyn_productnumber
PRODUCTNAME > name
PRODUCTDESCRIPTION > 説明
ITEMNUMBER > msdyn_itemnumber
PRODUCTTYPE >>
item : 1
service : 3
producttypecode
PRODUCTCOLORID > msdyn_productcolor.msdyn_productcolorname
PRODUCTCONFIGURATIONID > msdyn_productconfiguration.msdyn_productconfiguration
PRODUCTSIZEID > msdyn_productsize.msdyn_productsize
PRODUCTSTYLEID > msdyn_productstyle.msdyn_productstyle
ITEMNUMBER > msdyn_sharedproductdetailid.msdyn_itemnumber
[なし] >> msdyn_shouldsyncwithsharedproductdetails

DV リリース済製品 (msdyn_sharedproductdetails)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

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

Dynamics 365 Sales 機能管理の状態 (msdyn_supplychainfeaturestates)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
名前 = msdyn_name
ISENABLED ><
no : 1
yes : 0
statecode

Dynamics 365 Sales 注文ヘッダー (salesorders)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

取消済ソース フィルター: msdyn_ordertype eq 192350000 および msdyn_isreadytosync eq true

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

Dynamics 365 Sales 注文明細行 (salesorderdetails)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

取り消されたソース フィルター:

  • バージョン 1.x.x.x: msdyn_isreadytosync true
    (Project Operations ソリューションまたは Field Services ソリューションがインストールされていないサプライ チェーン ソリューションのコンテキストで使用されます。)
  • バージョン 2.x.x.x.x: (msdyn_linetype ne 690970000 および msdyn_linetype eq null) および msdyn_isreadytosync eq true
    (Project Operations ソリューションまたは Field Services ソリューションがインストールされているサプライ チェーン ソリューションのコンテキストで使用されます。)
財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CURRENCYCODE > transactioncurrencyid.isocurrencycode
DELIVERYADDRESSCITY = shipto_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE ><
us : united states
de : germany
fr : france
gb : united kingdom
jp : japan
in : india
es : spain
nz : new zealand
au : australia
co : columbia
za : south africa
be : belgium
ca : canada
at : austria
tr : turkey
cn : china
dk : denmark
se : sweden
no : norway
fi : finland
eg : egypt
shipto_country
DELIVERYADDRESSZIPCODE = shipto_postalcode
DELIVERYADDRESSSTATEID = shipto_stateorprovince
DELIVERYADDRESSSTREET = shipto_line1
DELIVERYADDRESSSTREETNUMBER = shipto_line2
LINEAMOUNT > extendedamount
LINECREATIONSEQUENCENUMBER = sequencenumber
ORDEREDSALESQUANTITY = quantity
PRODUCTNAME = 説明
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 : False
yes : True
msdyn_isdeliveryaddressspecific
ISDELIVERYADDRESSPRIVATE ><
no : False
yes : True
msdyn_isdeliveryaddressprivate
ISLINESTOPPED ><
no : False
yes : True
msdyn_islinestopped
ALLOWEDOVERDELIVERYPERCENTAGE = msdyn_allowedoverdeliverypercentage
ALLOWEDUNDERDELIVERYPERCENTAGE = msdyn_allowedunderdeliverypercentage
CONFIRMEDSHIPPINGDATE = msdyn_confirmedshippingdate
CONFIRMEDRECEIPTDATE = msdyn_confirmedreceiptdate
DELIVERYADDRESSCOUNTYID = msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION = msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME = msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER = msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLATITUDE = msdyn_deliveryaddresslatitude
DELIVERYADDRESSLOCATIONID = msdyn_deliveryaddresslocationid
DELIVERYADDRESSLONGITUDE = msdyn_deliveryaddresslongitude
DELIVERYADDRESSNAME = msdyn_deliveryaddressname
DELIVERYADDRESSPOSTBOX = msdyn_deliveryaddresspostbox
DELIVERYBUILDINGCOMPLIMENT = msdyn_deliverybuildingcompliment
EXTERNALITEMNUMBER = msdyn_externalitemnumber
FIXEDPRICECHARGES = msdyn_fixedpricecharges
FORMATTEDDELIVERYADDRESS = msdyn_formatteddeliveryaddress
LINEDESCRIPTION = msdyn_linedescription
LINEDISCOUNTAMOUNT = msdyn_linediscountamount
LINEDISCOUNTPERCENTAGE = msdyn_linediscountpercentage
MULTILINEDISCOUNTAMOUNT = msdyn_multilinediscountamount
MULTILINEDISCOUNTPERCENTAGE = msdyn_multilinediscountpercentage
REQUESTEDRECEIPTDATE = msdyn_requestedreceiptdate
REQUESTEDSHIPPINGDATE = requestdeliveryby
SALESORDERLINESTATUS >>
none : 192350000
backorder : 192350001
delivered : 192350002
invoiced : 192350003
canceled : 192350004
msdyn_linestatus
SALESORDERPROMISINGMETHOD ><
none : 192350000
salesLeadTime : 192350001
atp : 192350002
atpPlusIssueMargin : 192350003
ctp : 192350004
msdyn_salesorderpromisingmethod
SALESPRICEQUANTITY = msdyn_salespricequantity
SHIPPINGSITEID = msdyn_shippingsite.msdyn_siteid
SHIPPINGWAREHOUSEID = msdyn_shippingwarehouse.msdyn_warehouseidentifier
なし >> ispriceoverridden はい
TOTALCHARGESAMOUNT > msdyn_totalchargesamount
DELIVERYMODECODE = msdyn_deliverymode.msdyn_name
DELIVERYTERMSID = msdyn_deliveryterms.msdyn_termscode
SALESDELIVERNOW = quantityshipped
INVENTORYSERVICERESERVATIONID = msdyn_reservationid

Dynamics 365 Sales 見積書ヘッダー (見積)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

取消済ソース フィルター: msdyn_ordertype eq 192350000

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

Dynamics 365 Sales 見積明細行 (quotedetails)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

取り消されたソース フィルター:

  • バージョン 1.x.x.x: なし
    (Project Operations ソリューションまたは Field Services ソリューションがインストールされていないサプライ チェーン ソリューションのコンテキストで使用されます。)
  • バージョン 2.x.x.x: msdyn_linetype ne 690970000 or msdyn_linetype eq null
    (Project Operations ソリューションまたは Field Services ソリューションがインストールされているサプライ チェーン ソリューションのコンテキストで使用されます。)
財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
ALLOWEDOVERDELIVERYPERCENTAGE = msdyn_allowedoverdeliverypercentage
ALLOWEDUNDERDELIVERYPERCENTAGE = msdyn_allowedunderdeliverypercentage
SALESQUOTATIONNUMBER = quoteid.msdyn_quotenumber
LINECREATIONSEQUENCENUMBER = sequencenumber
CURRENCYCODE > transactioncurrencyid.isocurrencycode
DELIVERYADDRESSCITY = shipto_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE ><
us : united states
de : germany
fr : france
gb : united kingdom
jp : japan
in : india
es : spain
nz : new zealand
au : australia
co : columbia
za : south africa
be : belgium
ca : canada
at : austria
tr : turkey
cn : china
dk : denmark
se : sweden
no : norway
fi : finland
eg : egypt
shipto_country
DELIVERYADDRESSCOUNTYID = msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION = msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME = msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER = msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLATITUDE = msdyn_deliveryaddresslatitude
DELIVERYADDRESSLOCATIONID = msdyn_deliveryaddresslocationid
DELIVERYADDRESSLONGITUDE = msdyn_deliveryaddresslongitude
DELIVERYADDRESSNAME = msdyn_deliveryaddressname
DELIVERYADDRESSPOSTBOX = msdyn_deliveryaddresspostbox
DELIVERYADDRESSSTATEID = shipto_stateorprovince
DELIVERYADDRESSSTREET = shipto_line1
DELIVERYADDRESSSTREETNUMBER = shipto_line2
DELIVERYADDRESSZIPCODE = shipto_postalcode
DELIVERYBUILDINGCOMPLIMENT = msdyn_deliverybuildingcompliment
EXTERNALITEMNUMBER = msdyn_externalitemnumber
FIXEDPRICECHARGES = msdyn_fixedpricecharges
FORMATTEDDELIVERYADDRESS = msdyn_formatteddeliveryaddress
ISDELIVERYADDRESSPRIVATE ><
no : False
yes : True
msdyn_isdeliveryaddressprivate
ISDELIVERYADDRESSORDERSPECIFIC ><
no : False
yes : True
msdyn_isdeliveryaddressspecific
LINEAMOUNT > baseamount
LINEAMOUNT > extendedamount
LINEDESCRIPTION = msdyn_linedescription2
LINEDISCOUNTAMOUNT = msdyn_linediscountamount
LINEDISCOUNTPERCENTAGE = msdyn_linediscountpercentage
MULTILINEDISCOUNTAMOUNT = msdyn_multilinediscountamount
MULTILINEDISCOUNTPERCENTAGE = msdyn_multilinediscountpercentage
PRODUCTNAME = 説明
PRODUCTNUMBER = productid.msdyn_productnumber
REQUESTEDRECEIPTDATE = msdyn_requestedreceiptdate
REQUESTEDSALESQUANTITY = quantity
REQUESTEDSHIPPINGDATE = requestdeliveryby
SALESPRICE = priceperunit
SALESPRICEQUANTITY = msdyn_salespricequantity
SALESQUOTATIONPROMISINGMETHOD ><
none : 192350000
salesLeadTime : 192350001
atp : 192350002
atpPlusIssueMargin : 192350003
ctp : 192350004
msdyn_salesquotationpromisingmethod
SALESQUOTATIONSTATUS ><
created : 192350000
sent : 192350001
confirmed : 192350002
lost : 192350003
cancelled : 192350004
reset : 192350005
modified : 192350006
submitted : 192350007
approved : 192350008
revised : 192350009
msdyn_salesquotationstatus
SALESUNITSYMBOL = uomid.msdyn_symbol
SHIPPINGSITEID = msdyn_shippingsite.msdyn_siteid
SHIPPINGWAREHOUSEID = msdyn_shippingwarehouse.msdyn_warehouseidentifier
TOTALCHARGESAMOUNT > msdyn_totalchargesamount
TOTALDISCOUNTAMOUNT = manualdiscountamount
TOTALTAXAMOUNT >
SALESPRODUCTCATEGORYHIERARCHYNAME > msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name
SALESPRODUCTCATEGORYNAME = msdyn_salesproductcategory.msdyn_name
なし >> ispriceoverridden はい

雇用職務権限 (msdyn_employmentjobfunctions)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
FUNCTIONDESCRIPTION = msdyn_functiondescription
FUNCTIONNAME = msdyn_functionname

会社ごとの雇用 (cdm_employments)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
EMPLOYMENTENDDATE = cdm_employmentenddate
PERSONNELNUMBER = cdm_workerid.cdm_workernumber
EMPLOYMENTSTARTDATE = cdm_employmentstartdate
WORKERTYPE >>
employee : 754400000
contractor : 754400001
both : 754400000
cdm_workertype

出身民族 (cdm_ethnicorigins)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
ETHNICORIGINID = cdm_name
説明 = cdm_description

為替レートの通貨ペア (msdyn_currencyexchangeratepairs)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
EXCHANGERATEDISPLAYFACTOR ><
one : 192350000
ten : 192350001
hundred : 192350002
thousand : 192350003
tenThousand : 192350004
msdyn_displayfactor
EXCHANGERATETYPENAME = msdyn_currencyexchangeratetypeid.msdyn_name
FROMCURRENCYCODE = msdyn_fromtransactioncurrencyid.isocurrencycode
TOCURRENCYCODE = msdyn_totransactioncurrencyid.isocurrencycode

為替レート タイプ (msdyn_exchangeratetypes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
NAME = msdyn_name
説明 = msdyn_description

財務分析コード形式 (msdyn_financialdimensionformats)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
DIMENSIONFORMATNAME = msdyn_dimensionformatname
DIMENSIONFORMATTYPE ><
dataEntityDefaultDimensionFormat : 192350000
dataEntityLedgerDimensionFormat : 192350001
dataEntityBudgetDimensionFormat : 192350002
dataEntityBudgetPlanningDimensionFormat : 192350003
msdyn_dimensionformattype
FINANCIALDIMENSIONFORMAT = msdyn_financialdimensionformat
ISACTIVE ><
no : False
yes : True
msdyn_isactive

財務分析コード (msdyn_dimensionattributes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
DIMENSIONNAME = msdyn_dimensionname
COPYVALUESONCREATE ><
no : False
yes : True
msdyn_copyvaluesoncreate
REPORTCOLUMNNAME = msdyn_reportcolumnname
GIVEDERIVEDDIMENSIONSPRECEDENCE ><
no : False
yes : True
msdyn_givederiveddimensionsprecedence
UseValuesFrom = msdyn_usevaluesfrom
DimensionValueMask = msdyn_dimensionvaluemask

会計カレンダー統合エンティティ (msdyn_fiscalcalendars)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CALENDARID = msdyn_calendar
説明 = msdyn_description

会計カレンダー期間 (msdyn_fiscalcalendarperiods)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
COMMENTS = msdyn_comments
ENDDATE = msdyn_enddate
MONTH ><
month1 : 192350000
month2 : 192350001
month3 : 192350002
month4 : 192350003
month5 : 192350004
month6 : 192350005
month7 : 192350006
month8 : 192350007
month9 : 192350008
month10 : 192350009
month11 : 192350010
month12 : 192350011
msdyn_month
CALENDAR = msdyn_fiscalcalendar.msdyn_calendar
QUARTER ><
q1 : 192350000
q2 : 192350001
q3 : 192350002
q4 : 192350003
msdyn_quarter
SHORTNAME = msdyn_shortname
STARTDATE = msdyn_startdate
タイプ ><
opening : 192350000
operating : 192350001
closing : 192350002
msdyn_fiscalperiodtype
PERIODNAME = msdyn_periodname
FISCALYEAR = msdyn_fiscalcalendaryear.msdyn_name
CALENDAR = msdyn_fiscalcalendaryear.msdyn_fiscalcalendarname

会計カレンダー統合エンティティ (msdyn_fiscalcalendaryears)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
FISCALCALENDAR_CALENDARID = msdyn_fiscalcalendarname
NAME = msdyn_name
STARTDATE = msdyn_startdate
ENDDATE = msdyn_enddate
FISCALCALENDAR_CALENDARID = msdyn_calendar.msdyn_calendar

在庫通路 (msdyn_warehouseaisles)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
AISLEID = msdyn_aisleid
AISLENUMBER = msdyn_aislenumber
WAREHOUSEID = msdyn_warehouse.msdyn_warehouseidentifier
AISLENAME = msdyn_aislename
MANUALSTARTINGSORTORDERCODE = msdyn_manualstartingsortordercode
ISSORTORDERCODEASSIGNEDDESCENDING ><
yes : True
no : False
msdyn_issortordercodeassigneddescending

品目消費税グループ (msdyn_taxitemgroups)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
TAXITEMGROUP = msdyn_name
NAME = msdyn_description

ジョブ (cdm_jobs)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
JOBID = cdm_name
MAXIMUMNUMBEROFPOSITIONS = cdm_maximumnumberofpositions
ALLOWUNLIMITEDPOSITIONS ><
yes : true
no : 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 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
LANGUAGECODEID = cdm_name
説明 = cdm_description

元帳 (msdyn_ledgers)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
LEGALENTITYID > msdyn_company.cdm_companycode
DESCRIPTION > msdyn_description
ACCOUNTINGCURRENCY > msdyn_accountingcurrency.isocurrencycode
ISBUDGETCONTROLENABLED >>
no : False
yes : True
msdyn_isbudgetcontrolenabled
NAME > msdyn_name
REPORTINGCURRENCY > msdyn_reportingcurrency.isocurrencycode
BUDGETEXCHANGERATETYPE > msdyn_budgetexchangeratetype.msdyn_name
CHARTOFACCOUNTS > msdyn_chartofaccounts.msdyn_name
EXCHANGERATETYPE > msdyn_exchangeratetype.msdyn_name
FISCALCALENDAR > msdyn_fiscalcalendar.msdyn_calendar
REPORTINGCURRENCYEXCHANGERATETYPE > msdyn_reportingcurrencyexchangeratetype.msdyn_name

法人 (cdm_companies)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
NAME > cdm_name
LEGALENTITYID > cdm_companycode

法人 (msdyn_internalorganizations)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
NAMEALIAS > msdyn_namealias
LANGUAGEID > msdyn_languageid
NAME > msdyn_name
PARTYNUMBER > msdyn_partynumber
なし >> msdyn_type 806380000
LEGALENTITYID > msdyn_companycode

ロイヤルティ カード (msdyn_loyaltycards)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CARDNUMBER = msdyn_cardnumber
CARDTENDERTYPE ><
asCardTender : 806380000
asContactTender : 806380001
noTender : 806380002
blocked : 806380003
msdyn_cardtendertype
PARTYNUMBER = msdyn_partynumber
REPLACEMENTCARDNUMBER > msdyn_replacementcardnumber
OMOPERATINGUNITNUMBER = msdyn_operatingunitnumber
LOYALTYENROLLMENTDATE = msdyn_enrollmentdate
LOYALTYENROLLMENTDATELOCAL = msdyn_effectivedate

ロイヤリティ レベル (msdyn_loyaltylevels)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
LEVELPHRASE = msdyn_levelphrase
LEVELDESCRIPTION = msdyn_description

ロイヤルティ報酬ポイント (msdyn_loyaltyrewardpoints)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
EXPIRATIONTIMEUNIT ><
day : 806380000
month : 806380001
year : 806380002
msdyn_expirationtimeunit
EXPIRATIONTIMEVALUE = msdyn_expirationtimevalue
REDEEMABLE ><
yes : True
no : False
msdyn_redeemable
REDEEMRANKING = msdyn_redeemranking
REWARDPOINTCURRENCY = msdyn_rewardpointcurrency.isocurrencycode
REWARDPOINTID = msdyn_rewardpointid
REWARDPOINTTYPE ><
quantity : 192350000
amount : 192350001
msdyn_rewardpointtype
MAXIMUMLOYALTYREWARDPOINTS = msdyn_maximumloyaltyrewardpoints
VESTINGTIMEUNIT ><
day : 806380000
month : 806380001
year : 806380002
msdyn_vestingtimeunit
VESTINGTIMEVALUE = msdyn_vestingtimevalue

主勘定 (msdyn_mainaccounts)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

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

主勘定カテゴリ (msdyn_mainaccountcategories)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
MAINACCOUNTCATEGORY = msdyn_mainaccountcategory
REFERENCEID = msdyn_referenceid
DESCRIPTION = msdyn_description
DISPLAYORDER = msdyn_displayorder
終了 ><
no : False
yes : True
msdyn_closed
MAINACCOUNTTYPE ><
blank : 192350000
profitAndLoss : 192350001
revenue : 192350002
expense : 192350003
balanceSheet : 192350004
asset : 192350005
liability : 192350006
equity : 192350007
msdyn_mainaccounttypevalue

Mixed Reality ガイド エンティティ (msmrw_guides)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
INTEGRATIONKEY < msmrw_integrationkey
NAME < msmrw_name
SCHEMAVERSION < msmrw_schemaversion
GUIDEID < msmrw_guideid
CREATEDON < createdon
LASTMODIFIEDON < modifiedon

配送モード (msdyn_shipvias)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
MODECODE = msdyn_name
MODEDESCRIPTION = msdyn_description

名前の接辞 (msdyn_nameaffixes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
接辞 = msdyn_affix
タイプ ><
personalSuffix : 806380001
personalPrefix : 806380000
msdyn_affixtype
説明 = msdyn_description

作業単位 (msdyn_internalorganizations)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
LANGUAGEID > msdyn_languageid
NAMEALIAS > msdyn_namealias
NAME > msdyn_name
PARTYNUMBER > msdyn_partynumber
OPERATINGUNITTYPE >>
omDepartment : 806380001
none : 806380002
omCostCenter : 806380003
omValueStream : 806380004
omBusinessUnit : 806380005
omAnyOU : 806380006
retailChannel : 192350000
msdyn_type

組織階層 - 公開済 (msdyn_internalorganizationhierarchies)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
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 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
HIERARCHYTYPE > msdyn_hierarchypurposetypename
HIERARCHYTYPE > msdyn_hierarchytype.msdyn_name
HIERARCHYPURPOSE >>
notSet : 806380000
purchaseControl : 806380001
expenseControl : 806380002
organizationChart : 806380003
signingLimitControl : 806380004
invoiceControl : 806380005
auditInternalControl : 806380006
centralizedPayments : 806380007
security : 806380008
retailAssortment : 806380009
retailReplenishment : 806380010
retailReporting : 806380011
benefitEligibilityControl : 806380012
budgetPlanning : 806380013
retailPOSPosting : 806380014
project : 806380015
premiumEarningGeneration : 806380016
distributedOrderManagement : 806380017
msdyn_hierarchypurpose
IMMUTABLE >>
no : False
yes : True
msdyn_immutable
SETASDEFAULT >>
no : False
yes : True
msdyn_setasdefault

組織階層タイプ (msdyn_internalorganizationhierarchytypes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
NAME > msdyn_name

関係者の連絡先 V3 (msdyn_partyelectronicaddresses)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
COUNTRYREGIONCODE = msdyn_internationalcallingcode
説明 = msdyn_description
ELECTRONICADDRESSID = msdyn_electronicaddressnumber
PARTYNUMBER = msdyn_partyid.msdyn_partynumber
LOCATOR = msdyn_locator
LOCATOREXTENSION = msdyn_locatorextension
ISINSTANTMESSAGE ><
no : False
yes : True
msdyn_isinstantmessage
ISMOBILEPHONE ><
no : False
yes : True
msdyn_ismobile
ISPRIMARY ><
no : False
yes : True
msdyn_isprimary
ISPRIVATE ><
no : False
yes : True
msdyn_isprivate
PURPOSE = msdyn_purpose
タイプ ><
phone : 192350001
email : 192350002
url : 192350003
telex : 192350004
fax : 192350005
facebook : 192350006
twitter : 192350007
linkedin : 192350008
msdyn_type

支払期日明細行 CDS V2 (msdyn_paymentdaylines)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
NAME = msdyn_paymentday.msdyn_name
LINENUMBER = msdyn_linenumber
頻度 ><
week : 806380000
month : 806380001
msdyn_frequency
DAYOFWEEK ><
none : 806380000
monday : 806380001
tuesday : 806380002
wednesday : 806380003
thursday : 806380004
friday : 806380005
saturday : 806380006
sunday : 806380007
msdyn_dayofweek
DAYOFMONTH = msdyn_dayofmonth

支払期日 CDS (msdyn_paymentdays)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
NAME = msdyn_name
説明 = msdyn_description

支払スケジュール (msdyn_paymentschedules)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
NAME = msdyn_name
説明 = msdyn_description
ALLOCATIONMETHOD ><
total : 806380000
amountByPayment : 806380001
numOfPayment : 806380002
specified : 806380003
msdyn_allocationmethod
PAYMENTFREQUENCYUNITS ><
day : 806380000
month : 806380001
year : 806380002
msdyn_paymentfrequencyunit
PAYMENTFREQUENCY = msdyn_paymentfrequency
NUMBEROFPAYMENTS = msdyn_numberofpayments
FIXEDPAYMENTAMOUNT = msdyn_fixedpaymentamount
MINIMUMPAYMENTAMOUNT = msdyn_minimumpaymentamount
SALESTAXALLOCATIONMETHOD ><
proportional : 806380000
firstRate : 806380001
lastRate : 806380002
msdyn_salestaxallocationmethod
メモ = msdyn_note

支払スケジュール明細行 (msdyn_paymentschedulelines)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PAYMENTSCHEDULENAME = msdyn_paymentschedule.msdyn_name
LINENUMBER = msdyn_linenumber
PERIODSAFTERDUEDATE = msdyn_periodsafterduedate
PERCENTORAMOUNT ><
percent : 806380000
amount : 806380001
msdyn_percentoramount
PERCENTORAMOUNTVALUE = msdyn_percentoramountvalue

個人の特徴タイプ (msdyn_personalcharactertypes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
TYPEDESCRIPTION = msdyn_typedescription
TYPENAME = msdyn_typename

職位タイプ (cdm_positiontypes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
POSITIONTYPEID = cdm_name
説明 = cdm_description
CLASSIFICATION ><
fulltime : 754400000
parttime : 754400001
空白 : 754400002
cdm_classification

職位作業者割り当て (cdm_positionworkerassignmentmaps)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PERSONNELNUMBER = cdm_workerid.cdm_workernumber
POSITIONID = cdm_jobpositionid.cdm_jobpositionnumber
VALIDFROM = cdm_validfrom
VALIDTO = cdm_validto

職位 V2 (cdm_jobpositions)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
POSITIONID = cdm_jobpositionnumber
説明 = cdm_description
ACTIVATION = cdm_activation
AVAILABLEFORASSIGNMENT = cdm_availableforassignment
FULLTIMEEQUIVALENT = cdm_fulltimeequivalent
DETAILEFFECTIVE = cdm_validfrom
DETAILEXPIRATION = cdm_validto
定年退職 = cdm_retirement
POSITIONTYPEID = cdm_positiontypeid.cdm_name
JOBID = cdm_jobid.cdm_name

価格顧客グループ (msdyn_pricecustomergroups)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
GROUPCODE = msdyn_groupcode
GROUPNAME = msdyn_groupname

製品番号識別バーコード (msdyn_productbarcodes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PRODUCTNUMBER > msdyn_productnumberid.msdyn_productnumber
BARCODE > msdyn_name
BARCODE > msdyn_barcode
PRODUCTQUANTITY > msdyn_productquantity
PRODUCTDESCRIPTION > msdyn_productdescription
BARCODESETUPID > msdyn_barcodesetupid
PRODUCTQUANTITYUNITSYMBOL > msdyn_unitofmeasureid.msdyn_symbol
ISDEFAULTSCANNEDBARCODE >>
no : False
yes : True
msdyn_isdefaultscannedbarcode
ISDEFAULTPRINTEDBARCODE >>
no : False
yes : True
msdyn_isdefaultprintedbarcode
ISDEFAULTDISPLAYEDBARCODE >>
no : False
yes : True
msdyn_isdefaultdisplayedbarcode

製品カテゴリ (msdyn_productcategories)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PRODUCTCATEGORYHIERARCHYNAME = msdyn_hierarchy.msdyn_name
ISCATEGORYINHERITINGPARENTPRODUCTATTRIBUTES ><
no : False
yes : True
msdyn_isinheritingparentproductattributes
PROJECTCATEGORYNAME = msdyn_projectcategoryname
ISTANGIBLEPRODUCT ><
no : False
yes : True
msdyn_istangibleproduct
ISCATEGORYINHERITINGPARENTCATEGORYATTRIBUTES ><
no : False
yes : True
msdyn_isinheritingparentcategoryattributes
CATEGORYCODE = msdyn_code
CATEGORYDESCRIPTION = msdyn_description
CATEGORYKEYWORDS = msdyn_keywords
CATEGORYNAME = msdyn_name
FRIENDLYCATEGORYNAME = msdyn_friendlycategoryname
PARENTPRODUCTCATEGORYNAME = msdyn_parentproductcategory.msdyn_name
PARENTPRODUCTCATEGORYHIERARCHYNAME > msdyn_parentproductcategory.msdyn_hierarchy.msdyn_name
CATEGORYRECORDID > msdyn_externalproductcategoryid
EXTERNALID = msdyn_integrationid

製品カテゴリの割り当て (msdyn_productcategoryassignments)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PRODUCTNUMBER = msdyn_globalproduct.msdyn_productnumber
PRODUCTCATEGORYNAME = msdyn_productcategory.msdyn_name
PRODUCTCATEGORYHIERARCHYNAME = msdyn_productcategory.msdyn_hierarchy.msdyn_name
PRODUCTNUMBER > msdyn_name

製品カテゴリ階層 (msdyn_productcategoryhierarchies)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
HIERARCHYNAME = msdyn_name
HIERARCHYDESCRIPTION = msdyn_description

製品カテゴリ階層ロール (msdyn_productcategoryhierarchyroles)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PRODUCTCATEGORYHIERARCHYNAME = msdyn_hierarchy.msdyn_name
HIERARCHYROLE ><
procurement : 192350000
sales : 192350001
retail : 192350002
commodity : 192350003
financials : 192350004
retailSpecialGroup : 192350005
retailVendorProductHierarchy : 192350006
retailChannelNavigation : 192350007
packingMaterials_W : 192350008
commonDataService : 192350009
costManagement : 192350010
engineeringProduct : 192350011
msdyn_hierarchyrole

製品の既定の注文設定 V2 (msdyn_productspecificdefaultordersettings)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
INVENTORYWAREHOUSEID = msdyn_inventorywarehouse.msdyn_warehouseidentifier
INVENTORYSITEID = msdyn_inventorysite.msdyn_siteid
INVENTORYATPDELAYEDDEMANDOFFSETDAYS = msdyn_inventoryatpdelayeddemandoffsetdays
INVENTORYATPDELAYEDSUPPLYOFFSETDAYS = msdyn_inventoryatpdelayedsupplyoffsetdays
ITEMNUMBER = msdyn_itemnumber.msdyn_itemnumber
INVENTORYATPBACKWARDDEMANDTIMEFENCEDAYS = msdyn_inventoryatpbackwarddemandtimefencedays
INVENTORYATPBACKWARDSUPPLYTIMEFENCEDAYS = msdyn_inventoryatpbackwardsupplytimefencedays
INVENTORYATPTIMEFENCEDAYS = msdyn_inventoryatptimefencedays
MAXIMUMINVENTORYORDERQUANTITY = msdyn_maximuminventoryorderquantity
MAXIMUMPROCUREMENTORDERQUANTITY = msdyn_maximumprocurementorderquantity
MAXIMUMSALESORDERQUANTITY = msdyn_maximumsalesorderquantity
MINIMUMINVENTORYORDERQUANTITY = msdyn_minimuminventoryorderquantity
MINIMUMPROCUREMENTORDERQUANTITY = msdyn_minimumprocurementorderquantity
MINIMUMSALESORDERQUANTITY = msdyn_minimumsalesorderquantity
STANDARDINVENTORYORDERQUANTITY = msdyn_standardinventoryorderquantity
STANDARDPROCUREMENTORDERQUANTITY = msdyn_standardprocurementorderquantity
STANDARDSALESORDERQUANTITY = msdyn_standardsalesorderquantity
INVENTORYLEADTIMEDAYS = msdyn_inventoryleadtimedays
INVENTORYQUANTITYMULTIPLES = msdyn_inventoryquantitymultiples
PROCUREMENTQUANTITYMULTIPLES = msdyn_procurementquantitymultiples
SALESQUANTITYMULTIPLES = msdyn_salesquantitymultiples
PROCUREMENTSITEID = msdyn_procurementsite.msdyn_siteid
PROCUREMENTLEADTIMEDAYS = msdyn_procurementleadtimedays
SALESSITEID = msdyn_salessite.msdyn_siteid
SALESATPDELAYEDDEMANDOFFSETDAYS = msdyn_salesatpdelayeddemandoffsetdays
SALESATPDELAYEDSUPPLYOFFSETDAYS = msdyn_salesatpdelayedsupplyoffsetdays
SALESATPBACKWARDDEMANDTIMEFENCEDAYS = msdyn_salesatpbackwarddemandtimefencedays
SALESATPBACKWARDSUPPLYTIMEFENCEDAYS = msdyn_salesatpbackwardsupplytimefencedays
SALESATPTIMEFENCEDAYS = msdyn_salesatptimefencedays
SALESLEADTIMEDAYS = msdyn_salesleadtimedays
PROCUREMENTWAREHOUSEID = msdyn_procurementwarehouse.msdyn_warehouseidentifier
SALESWAREHOUSEID = msdyn_saleswarehouse.msdyn_warehouseidentifier
AREINVENTORYDEFAULTORDERSETTINGSOVERRIDDEN ><
no : False
yes : True
msdyn_areinventoryorderdefaultsoverridden
INVENTORYORDERPROMISINGMETHOD ><
none : 192350000
salesLeadTime : 192350001
atp : 192350002
atpPlusIssueMargin : 192350003
ctp : 192350004
msdyn_inventoryorderpromisingmethod
ISINVENTORYATPINCLUDINGPLANNEDORDERS ><
false : False
true : True
msdyn_isinventoryatpincludingplannedorders
ISINVENTORYUSINGWORKINGDAYS ><
no : False
yes : True
msdyn_isinventoryusingworkingdays
ISINVENTORYSITEMANDATORY ><
no : False
yes : True
msdyn_isinventorysitemandatory
ISINVENTORYPROCESSINGSTOPPED ><
no : False
yes : True
msdyn_isinventoryprocessingstopped
ISPROCUREMENTUSINGWORKINGDAYS ><
no : False
yes : True
msdyn_isprocurementusingworkingdays
ISPROCUREMENTSITEMANDATORY ><
no : False
yes : True
msdyn_isprocurementsitemandatory
ISPROCUREMENTPROCESSINGSTOPPED ><
no : False
yes : True
msdyn_isprocurementprocessingstopped
ARESALESDEFAULTORDERSETTINGSOVERRIDDEN ><
no : False
yes : True
msdyn_aresalesorderdefaultsoverridden
SALESORDERPROMISINGMETHOD ><
none : 192350000
salesLeadTime : 192350001
atp : 192350002
atpPlusIssueMargin : 192350003
ctp : 192350004
msdyn_salesorderpromisingmethod
ISSALESATPINCLUDINGPLANNEDORDERS ><
false : False
true : True
msdyn_issalesatpincludingplannedorders
ISSALESSITEMANDATORY ><
no : False
yes : True
msdyn_issalessitemandatory
ISSALESLEADTIMEOVERRIDDEN ><
no : False
yes : True
msdyn_issalesleadtimeoverridden
ISSALESPROCESSINGSTOPPED ><
no : False
yes : True
msdyn_issalesprocessingstopped
ISINVENTORYWAREHOUSEMANDATORY ><
no : False
yes : True
msdyn_isinventorywarehousemandatory
ISPROCUREMENTWAREHOUSEMANDATORY ><
no : False
yes : True
msdyn_isprocurementwarehousemandatory
ISSALESWAREHOUSEMANDATORY ><
no : False
yes : True
msdyn_issaleswarehousemandatory
OPERATIONALSITEID = msdyn_operationalsite.msdyn_siteid
PRODUCTCOLORID = msdyn_productcolor.msdyn_productcolorname
PRODUCTCONFIGURATIONID = msdyn_productconfiguration.msdyn_productconfiguration
PRODUCTSIZEID = msdyn_productsize.msdyn_productsize
PRODUCTSTYLEID = msdyn_productstyle.msdyn_productstyle

製品分析コード グループ (msdyn_productdimensiongroups)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
WILLSALESPRICESEARCHUSEPRODUCTSTYLE ><
no : false
yes : true
msdyn_willsalespricesearchuseproductstyle
WILLPURCHASEPRICESEARCHUSEPRODUCTSIZE ><
no : false
yes : true
msdyn_willpurchasepricesearchuseproductsize
WILLSALESPRICESEARCHUSEPRODUCTCONFIGURATION ><
no : false
yes : true
msdyn_willsalespricesearchuseprodconfig
WILLSALESPRICESEARCHUSEPRODUCTCOLOR ><
no : false
yes : true
msdyn_willsalespricesearchuseproductcolor
WILLPURCHASEPRICESEARCHUSEPRODUCTSTYLE ><
no : false
yes : true
msdyn_willpurchasepricesearchuseproductstyle
WILLPURCHASEPRICESEARCHUSEPRODUCTCONFIGURATION ><
no : false
yes : true
msdyn_willpurchpricesearchuseprodconfig
WILLPURCHASEPRICESEARCHUSEPRODUCTCOLOR ><
no : false
yes : true
msdyn_willpurchpricesearchuseproductcolor
ISPRODUCTSTYLEACTIVE ><
no : false
yes : true
msdyn_isproductstyleactive
ISPRODUCTSIZEACTIVE ><
no : false
yes : true
msdyn_isproductsizeactive
ISPRODUCTCONFIGURATIONACTIVE ><
no : false
yes : true
msdyn_isproductconfigurationactive
ISPRODUCTCOLORACTIVE ><
no : false
yes : true
msdyn_isproductcoloractive
GROUPNAME = msdyn_groupname
GROUPDESCRIPTION = msdyn_groupdescription
PRODUCTVARIANTNOMENCLATURENAME = msdyn_productvariantnomenclaturename
WILLSALESPRICESEARCHUSEPRODUCTSIZE ><
yes : true
no : false
msdyn_willsalespricesearchuseproductsize

製品マスターの色 (msdyn_sharedproductcolors)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PRODUCTCOLORID > msdyn_productcolor.msdyn_productcolorname
PRODUCTMASTERNUMBER > msdyn_globalproduct.msdyn_productnumber
REPLENISHMENTWEIGHT > msdyn_replenishmentweight
DISPLAYSEQUENCENUMBER > msdyn_displaysequencenumber

製品マスターのコンフィギュレーション (msdyn_sharedproductconfigurations)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CONTAINERUNITSYMBOL > msdyn_containerunit.msdyn_symbol
PRODUCTCONFIGURATIONID > msdyn_productconfiguration.msdyn_productconfiguration
PRODUCTMASTERNUMBER > msdyn_globalproduct.msdyn_productnumber
REPLENISHMENTWEIGHT > msdyn_replenishmentweight
DISPLAYSEQUENCENUMBER > msdyn_displaysequencenumber

製品マスターのサイズ (msdyn_sharedproductsizes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PRODUCTMASTERNUMBER > msdyn_globalproduct.msdyn_productnumber
PRODUCTSIZEID > msdyn_productsize.msdyn_productsize
REPLENISHMENTWEIGHT > msdyn_replenishmentweight
DISPLAYSEQUENCENUMBER > msdyn_displaysequencenumber

製品マスターのスタイル (msdyn_sharedproductstyles)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PRODUCTMASTERNUMBER > msdyn_globalproduct.msdyn_productnumber
PRODUCTSTYLEID > msdyn_productstyle.msdyn_productstyle
REPLENISHMENTWEIGHT > msdyn_replenishmentweight
DISPLAYSEQUENCENUMBER > msdyn_displaysequencenumber

製品受領書ヘッダー (msdyn_purchaseorderreceipts)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
RECORDID > msdyn_recordid
PRODUCTRECEIPTDATE > msdyn_datereceived
DELIVERYADDRESSLATITUDE > msdyn_deliveryaddresslatitude
DELIVERYADDRESSLONGITUDE > msdyn_deliveryaddresslongitude
PURCHASEORDERNUMBER > msdyn_purchaseorder.msdyn_name
DELIVERYMODEID > msdyn_shipvia.msdyn_name
DELIVERYTERMSID > msdyn_deliveryterm.msdyn_termscode
ORDERVENDORACCOUNTNUMBER > msdyn_ordervendor.msdyn_vendoraccountnumber
REQUESTERPERSONNELNUMBER > msdyn_requesterpersonnel.cdm_workernumber
ISDELIVERYADDRESSPRIVATE >>
Yes : true
No : false
msdyn_isdeliveryaddressprivate
DELIVERYADDRESSCOUNTRYREGIONID > msdyn_deliveryaddresscountryregionid
DELIVERYADDRESSCOUNTYID > msdyn_deliveryaddresscountyid
DELIVERYADDRESSSTATEID > msdyn_deliveryaddressstateid
DELIVERYADDRESSZIPCODE > msdyn_deliveryaddresszipcode
DELIVERYADDRESSNAME > msdyn_deliveryaddressname
DELIVERYADDRESSTIMEZONE > msdyn_deliveryaddresstimezone
DELIVERYADDRESSPOSTBOX > msdyn_deliveryaddresspostbox
DELIVERYADDRESSSTREETNUMBER > msdyn_deliveryaddressstreetnumber
DELIVERYADDRESSSTREET > msdyn_deliveryaddressstreet
PRODUCTRECEIPTNUMBER > msdyn_name
ATTENTIONINFORMATION > msdyn_note
DELIVERYCITYINKANA > msdyn_deliverycityinkana
DELIVERYSTREETINKANA > msdyn_deliverystreetinkana
FORMATTEDDELIVERYADDRESS > msdyn_formatteddeliveryaddress
DELIVERYADDRESSLOCATIONID > msdyn_deliveryaddresslocationid
DELIVERYADDRESSCITY > msdyn_deliveryaddresscity
DELIVERYADDRESSDESCRIPTION > msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME > msdyn_deliveryaddressdistrictname
DELIVERYBUILDINGCOMPLIMENT > msdyn_deliverybuildingcompliment
DELIVERYADDRESSDUNSNUMBER > msdyn_deliveryaddressdunsnumber

製品受領書明細行 (msdyn_purchaseorderreceiptproducts)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
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 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
DENOMINATOR = msdyn_denominator
NUMERATOR = msdyn_numerator
FACTOR = msdyn_factor
FROMUNITSYMBOL = msdyn_fromunit.msdyn_symbol
TOUNITSYMBOL = msdyn_tounit.msdyn_symbol
PRODUCTNUMBER = msdyn_globalproduct.msdyn_productnumber
INNEROFFSET = msdyn_inneroffset
OUTEROFFSET = msdyn_outeroffset
ROUNDING ><
nearest : 192350000
up : 192350001
down : 192350002
msdyn_rounding

見込顧客 (潜在顧客)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

ソース フィルター: (IsB2BProspect == 1)

取消済ソース フィルター: (msdyn_b2bcommerceprospect eq true)

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PROSPECTNAME = fullname
PROSPECTPARTYNUMBER = msdyn_partyid.msdyn_partynumber
PROSPECTID = msdyn_prospectid
PRIMARYPHONENUMBER = 電話 1
PRIMARYPHONENUMBEREXTENSION = msdyn_telephone1extension
PRIMARYPHONENUMBERDESCRIPTION = 説明
PRIMARYEMAILADDRESS = 電子メール アドレス 1
PRIMARYEMAILADDRESSDESCRIPTION = msdyn_emailaddress1description
PRIMARYURL = Web サイト URL
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 << なし 勤務先
なし >> address1_addresstypecode 1
COMPANYNAME = companyname
COMPANYSIZE = numberofemployees
ADDRESSLATITUDE = address1_latitude
ADDRESSLONGITUDE = address1_longitude
CURRENCYCODE = transactioncurrencyid.isocurrencycode
CUSTOMERGROUPID = msdyn_customergroupid.msdyn_groupid
SALESTAXGROUPCODE = msdyn_salestaxgroup.msdyn_name
PRIMARYFAXNUMBER = fax
PRIMARYFAXNUMBERDESCRIPTION = msdyn_faxdescription
PRIMARYFAXNUMBEREXTENSION = msdyn_faxextension
RETAILCHANNELOPERATINGUNITPARTYNUMBER = msdyn_retailchannel.msdyn_partynumber
ISB2BPROSPECT ><
no : False
yes : True
msdyn_b2bcommerceprospect
B2BPROSPECTSTATUS ><
Pending : 192350000
Approved : 192350001
Rejected : 192350002
msdyn_b2bprospectstatus

発注書のヘッダー ドキュメントの添付ファイル (annotations)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

ソース フィルター: ((DocumentAttachmentTypeCode == "Note") || (DocumentAttachmentTypeCode == "URL"))

取消済ソース フィルター: objecttypecode eq 'msdyn_purchaseorder'

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
DOCUMENTID = msdyn_notesid
メモ = notetext
ATTACHMENTDESCRIPTION = subject
PURCHASEORDERNUMBER = msdyn_relatedentityid
DOCUMENTATTACHMENTTYPECODE << なし メモ
なし >> objecttypecode msdyn_purchaseorder
ACCESSRESTRICTION ><
internal : 0
external : 1
msdyn_restriction

発注書ヘッダー V2 (msdyn_purchaseorders)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

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

リリース済製品 V2 (msdyn_sharedproductdetails)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

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

売上請求書ヘッダー V2 (invoices)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

ソース フィルター: (SalesOrderNumber != "")

取消済ソース フィルター: msdyn_ordertype eq 192350000

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
なし >> ispricelocked いいえ
なし >> statuscode 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).Contact(msdyn_contactpersonid)
INVOICEDATE > msdyn_invoicedate
INVOICENUMBER > msdyn_invoicenumber
LEDGERVOUCHER > msdyn_ledgervoucher
PAYMENTTERMSNAME > msdyn_paymentterms.msdyn_name
SALESORDERNUMBER > salesorderid.msdyn_salesordernumber
TOTALCHARGEAMOUNT > freightamount
TOTALDISCOUNTAMOUNT > msdyn_totaldiscountamount
TOTALDISCOUNTCUSTOMERGROUPCODE > discountamount
TOTALINVOICEAMOUNT > msdyn_totalamount
TOTALTAXAMOUNT > msdyn_totaltax
なし >> msdyn_ordertype 192350000

売上請求書明細行 V2 (invoicedetails)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
CONFIRMEDSHIPPINGDATE > msdyn_confirmedshippingdate
CURRENCYCODE > transactioncurrencyid.isocurrencycode
INVENTORYSITEID > msdyn_inventorysite.msdyn_siteid
INVENTORYWAREHOUSEID > msdyn_inventorywarehouse.msdyn_warehouseidentifier
INVOICEDATE > invoiceid.msdyn_invoicedate
INVOICEDQUANTITY > quantity
INVOICENUMBER > invoiceid.msdyn_invoicenumber
LEDGERVOUCHER > invoiceid.msdyn_ledgervoucher
LINEAMOUNT > extendedamount
LINECREATIONSEQUENCENUMBER > sequencenumber
LINETOTALCHARGEAMOUNT > msdyn_totalchargeamount
LINETOTALDISCOUNTAMOUNT > manualdiscountamount
LINETOTALTAXAMOUNT >
PRODUCTNAME > 説明
PRODUCTNUMBER > productid.msdyn_productnumber
SALESPRICE > priceperunit
SALESPRODUCTCATEGORYHIERARCHYNAME > msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name
SALESPRODUCTCATEGORYNAME > msdyn_salesproductcategory.msdyn_name
SALESUNITSYMBOL > uomid.msdyn_symbol
なし >> producttypecode 1
なし >> propertyconfigurationstatus 2
なし >> ispriceoverridden True

販売注文のヘッダー ドキュメントの添付ファイル (annotations)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

ソース フィルター: ((DocumentAttachmentTypeCode == "Note") || (DocumentAttachmentTypeCode == "URL"))

取消済ソース フィルター: objecttypecode eq 'salesorder'

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
DOCUMENTID = msdyn_notesid
メモ = notetext
ATTACHMENTDESCRIPTION = subject
SALESORDERNUMBER = msdyn_relatedentityid
DOCUMENTATTACHMENTTYPECODE << なし メモ
なし >> objecttypecode salesorder
ACCESSRESTRICTION ><
internal : 0
external : 1
msdyn_restriction

販売注文元コード (msdyn_salesorderorigins)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
ORIGINCODE = msdyn_origincode
ORIGINDESCRIPTION = msdyn_origindescription

消費税所轄官庁 (msdyn_taxauthorities)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
TAXAUTHORITYCODE = msdyn_taxauthoritycode
TAXAUTHORITYIDENTIFICATION = msdyn_taxauthorityidentificator
説明 = msdyn_description
REPORTLAYOUT ><
default : 192350000
norway : 192350001
unitedKingdom : 192350002
sweden : 192350003
germany : 192350004
austria : 192350005
netherlands : 192350006
usa : 192350007
italy : 192350008
belgium : 192350009
singapore : 192350010
japan : 192350011
finland : 192350012
estonia : 192350013
uae : 192350014
msdyn_taxreportlayout
ROUNDOFFTYPE ><
ordinary : 192350000
roundDown : 192350001
roundUp : 192350002
advantage : 192350003
msdyn_roundofftype
ROUNDOFF = msdyn_roundoff
電子メール = msdyn_email
PHONE = msdyn_phone
URL = msdyn_url

消費税非課税コード エンティティ CDS (msdyn_taxexemptcodes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
NAME = msdyn_name
説明 = msdyn_description

消費税グループ (msdyn_taxgroups)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
TAXGROUPCODE = msdyn_name
説明 = msdyn_description

消費税元帳転記グループ V2 (msdyn_taxpostinggroups)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
TAXPOSTINGGROUPCODE = msdyn_name
説明 = msdyn_description

あいさつ文 (msdyn‑salutations)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
SALUTATIONPHRASE = msdyn_salutationphrase

サイト (msdyn_operationalsites)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
DEFAULTFINANCIALDIMENSIONVALUE = msdyn_defaultfinancialdimensionvalue
DEFAULTINVENTORYSTATUSID = msdyn_defaultinventorystatusid
ISRECEIVINGWAREHOUSEOVERRIDEALLOWED ><
no : False
yes : True
msdyn_isreceivingwarehouseoverrideallowed
SITEID = msdyn_siteid
SITENAME = msdyn_sitename
TAXBRANCHCODE = msdyn_taxbranchcode
FISCALESTABLISHMENTID = msdyn_fiscalestablishmentid
ISPRIMARYADDRESSASSIGNED ><
no : False
yes : True
msdyn_isprimaryaddressassigned
PRIMARYADDRESSCITY = msdyn_primaryaddresscity
PRIMARYADDRESSCOUNTRYREGIONID = msdyn_primaryaddresscountryregionid
PRIMARYADDRESSCOUNTYID = msdyn_primaryaddresscountyid
PRIMARYADDRESSDISTRICTNAME = msdyn_primaryaddressdistrictname
PRIMARYADDRESSLATITUDE = msdyn_primaryaddresslatitude
PRIMARYADDRESSLOCATIONROLES = msdyn_primaryaddresslocationrole
PRIMARYADDRESSLOCATIONSALESTAXGROUPCODE = msdyn_primaryaddresslocationsalestaxgroupcode
PRIMARYADDRESSLONGITUDE = msdyn_primaryaddresslongitude
PRIMARYADDRESSSTATEID = msdyn_primaryaddressstateid
PRIMARYADDRESSSTREET = msdyn_primaryaddressstreet
PRIMARYADDRESSZIPCODE = msdyn_primaryaddresszipcode
PRIMARYADDRESSBUILDINGCOMPLIMENT = msdyn_primaryaddressbuildingcompliment
PRIMARYADDRESSCITYINKANA = msdyn_primaryaddresscityinkana
PRIMARYADDRESSSTREETINKANA = msdyn_primaryaddressstreetinkana
PRIMARYADDRESSDESCRIPTION = msdyn_primaryaddressdescription
FORMATTEDPRIMARYADDRESS = msdyn_formattedprimaryaddress
WILLMASTERPLANNEDINTRASITEMOVEMENTSUSETRANSFERJOURNALS ><
no : False
yes : True
msdyn_masterplannedusestransferjournal
PRIMARYADDRESSPOSTBOX = msdyn_primaryaddresspostbox
PRIMARYADDRESSSTREETNUMBER = msdyn_primaryaddressstreetnumber

サイズ (msdyn_productsizes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
SIZEID > msdyn_productsize

保管分析コード グループ (msdyn_productstoragedimensiongroups)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
WILLSALESPRICESEARCHUSEWAREHOUSE ><
no : false
yes : true
msdyn_willsalespricesearchusewarehouse
WILLSALESPRICESEARCHUSESITE ><
no : false
yes : true
msdyn_willsalespricesearchusesite
WILLSALESPRICESEARCHUSEINVENTORYSTATUS ><
no : false
yes : true
msdyn_willsalespricesearchuseinventorystatus
WILLPURCHASEPRICESEARCHUSEWAREHOUSE ><
no : false
yes : true
msdyn_willpurchasepricesearchusewarehouse
WILLPURCHASEPRICESEARCHUSESITE ><
no : false
yes : true
msdyn_willpurchasepricesearchusesite
WILLPURCHASEPRICESEARCHUSEINVENTORYSTATUS ><
no : false
yes : true
msdyn_willpurchpricesearchuseinventstatus
WILLCOVERAGEPLANNINGUSEWAREHOUSE ><
no : false
yes : true
msdyn_willcoverageplanusewarehouse
WILLCOVERAGEPLANNINGUSELOCATION ><
no : false
yes : true
msdyn_iscoverageplanenabledforlocation
WILLCOVERAGEPLANNINGUSEINVENTORYSTATUS ><
no : false
yes : true
msdyn_willcoverageplanuseinventorystatus
AREADVANCEDWAREHOUSEMANAGEMENTPROCESSESENABLED ><
no : false
yes : true
msdyn_areadvancedwmprocessesenabled
ISWAREHOUSEPRIMARYSTORAGEDIMENSION ><
no : false
yes : true
msdyn_iswarehouseprimarystoragedimension
ISWAREHOUSEMANDATORY ><
no : false
yes : true
msdyn_iswarehousemandatory
ISPHYSICALINVENTORYENABLEDFORWAREHOUSE ><
no : false
yes : true
msdyn_isphysicalinventoryenabledforwarehouse
ISPHYSICALINVENTORYENABLEDFORLOCATION ><
no : false
yes : true
msdyn_isphysicalinventoryenabledforlocation
ISLOCATIONACTIVE ><
no : false
yes : true
msdyn_islocationactive
ISFINANCIALINVENTORYENABLEDFORWAREHOUSE ><
no : false
yes : true
msdyn_isfinancialinventoryenabledforwarehouse
GROUPNAME = msdyn_groupname
GROUPDESCRIPTION = msdyn_groupdescription
ISBLANKRECEIPTALLOWEDFORLOCATION ><
no : false
yes : true
msdyn_isblankreceiptallowedforlocation
ISBLANKISSUEALLOWEDFORLOCATION ><
no : false
yes : true
msdyn_isblankissueallowedforlocation

スタイル (msdyn_productstyles)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
STYLEID > msdyn_productstyle

配送条件 (msdyn_termsofdeliveries)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
TERMSCODE = msdyn_termscode
INTRASTATCODE = msdyn_intrastatcode
SALESTAXLOCATIONROLE ><
none : 192350000
invoice : 192350001
delivery : 192350002
swift : 192350003
payment : 192350004
service : 192350005
home : 192350006
other : 192350007
business : 192350008
remitTo : 192350009
statement : 192350010
fixedAsset : 192350011
oneTime : 192350012
recruit : 192350013
sms : 192350014
lading_W : 192350015
unlading_W : 192350016
headCompany_IT : 192350017
stableOrganization_IT : 192350018
msdyn_salestaxlocationrole
TERMSDESCRIPTION = msdyn_termsdescription
FREIGHTCHARGETERMS ><
prepaid : 192350000
collect : 192350001
thirdParty : 192350002
nofreight : 192350003
msdyn_freightchargeterms
DORETAILSALESORDERSGETTRANSPORTATIONCHARGESADDED ><
no : False
yes : True
msdyn_doretailsogettransportationchargesadded
ISCASHONDELIVERY ><
no : False
yes : True
msdyn_iscashondelivery
WILLSHIPMENTCONFIRMATIONTRANSFERCHARGES ><
no : False
yes : True
msdyn_willshipmentconfirmationtransfercharges

支払条件 (msdyn_paymentterms)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
説明 = msdyn_description
NAME = msdyn_name
NUMBEROFMONTHS = msdyn_numberofmonth
CUTOFFDAYOFMONTH = msdyn_cutoffdayofmonth
ISCASHPAYMENT ><
no : False
yes : True
msdyn_iscashpayment
NUMBEROFDAYS = msdyn_days
ISCERTIFIEDCOMPANYCHECK ><
yes : True
no : False
msdyn_iscertifiedcompanycheck
ISDEFAULTPAYMENTTERM ><
no : False
yes : True
msdyn_isdefaultpaymentterm
CREDITCARDPAYMENTTYPE ><
na : 806380998
creditCard : 806380999
msdyn_creditcardpaymenttype
CREDITCARDCREDITCHECKTYPE ><
normal : 806380000
byPass : 806380001
msdyn_creditcardcreditchecktype
PAYMENTDAYNAME = msdyn_paymentdayname.msdyn_name
PAYMENTMETHODTYPE ><
net : 806380991
currentMth : 806380992
currentQuart : 806380993
currentYear : 806380994
currentWeek : 806380995
cod : 806380996
cutOffDate : 806380997
msdyn_paymentmethodtype
PAYMENTSCHEDULENAME = msdyn_paymentschedulename.msdyn_name

追跡用分析コード グループ (msdyn_producttrackingdimensiongroups)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
SERIALNUMBERCAPTURINGOPERATION ><
none : 806380000
picking : 806380001
packing : 806380002
msdyn_serialnumbercapturingoperation
GROUPNAME = msdyn_groupname
GROUPDESCRIPTION = msdyn_groupdescription
ISSERIALNUMBERENABLEDFORPRODUCTIONCONSUMPTIONPROCESS ><
no : false
yes : true
msdyn_issnenabledforpcprocess
ISSERIALNUMBERCONTROLENABLED ><
no : false
yes : true
msdyn_isserialnumbercontrolenabled
ISSERIALNUMBERENABLEDFORSALESPROCESS ><
no : false
yes : true
msdyn_isserialnumberenabledforsalesprocess
ISSERIALNUMBERACTIVE ><
no : false
yes : true
msdyn_isserialnumberactive
ISSALESPRICEBYSERIALNUMBER ><
no : false
yes : true
msdyn_issalespricebyserialnumber
ISSALESPRICEBYBATCHNUMBER ><
no : false
yes : true
msdyn_issalespricebybatchnumber
ISPURCHASEPRICEBYSERIALNUMBER ><
no : false
yes : true
msdyn_ispurchasepricebyserialnumber
ISPURCHASEPRICEBYBATCHNUMBER ><
no : false
yes : true
msdyn_ispurchasepricebybatchnumber
ISPRIMARYSTOCKINGENABLEDFORSERIALNUMBER ><
no : false
yes : true
msdyn_isprimarystockingenabledforsn
ISPRIMARYSTOCKINGENABLEDFORBATCHNUMBER ><
no : false
yes : true
msdyn_isprimarystockingenabledforbn
ISPHYSICALINVENTORYENABLEDFORSERIALNUMBER ><
no : false
yes : true
msdyn_isphysicalinventoryenabledforsn
ISPHYSICALINVENTORYENABLEDFORBATCHNUMBER ><
no : false
yes : true
msdyn_isphysicalinventoryenabledforbn
ISFINANCIALINVENTORYENABLEDFORSERIALNUMBER ><
no : false
yes : true
msdyn_isfinancialinventoryenabledforsn
ISFINANCIALINVENTORYENABLEDFORBATCHNUMBER ><
no : false
yes : true
msdyn_isfinancialinventoryenabledforbn
ISCOVERAGEPLANENABLEDFORSERIALNUMBER ><
no : false
yes : true
msdyn_iscoverageplanenabledforserialnumber
ISCOVERAGEPLANENABLEDFORBATCHNUMBER ><
no : false
yes : true
msdyn_iscoverageplanenabledforbatchnumber
ISBLANKRECEIPTALLOWEDFORSERIALNUMBER ><
no : false
yes : true
msdyn_isblankreceiptallowedforserialnumber
ISBLANKRECEIPTALLOWEDFORBATCHNUMBER ><
no : false
yes : true
msdyn_isblankreceiptallowedforbatchnumber
ISBLANKISSUEALLOWEDFORSERIALNUMBER ><
no : false
yes : true
msdyn_isblankissueallowedforserialnumber
ISBLANKISSUEALLOWEDFORBATCHNUMBER ><
no : false
yes : true
msdyn_isblankissueallowedforbatchnumber
ISBATCHNUMBERACTIVE ><
no : false
yes : true
msdyn_isbatchnumberactive
ISINVENTORYOWNERACTIVE ><
no : false
yes : true
msdyn_isinventoryowneractive

単位換算 (msdyn_unitofmeasureconversions)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
DENOMINATOR = msdyn_denominator
NUMERATOR = msdyn_numerator
FACTOR = msdyn_factor
INNEROFFSET = msdyn_inneroffset
OUTEROFFSET = msdyn_outeroffset
ROUNDING ><
nearest : 192350000
up : 192350001
down : 192350002
msdyn_rounding
TOUNITSYMBOL = msdyn_tounit.msdyn_symbol
FROMUNITSYMBOL = msdyn_fromunit.msdyn_symbol

単位 (uoms)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
UNITSYMBOL > msdyn_symbol
UNITCLASS > msdyn_externalunitclassname
DECIMALPRECISION > msdyn_decimalprecision
ISBASEUNIT >>
no : false
yes : true
msdyn_isbaseunit
ISSYSTEMUNIT >>
no : false
yes : true
msdyn_issystemunit
SYSTEMOFUNITS >>
none : 192350000
metric : 192350001
us : 192350002
msdyn_systemofunits
UNITSYMBOL > name
UNITDESCRIPTION > msdyn_description

仕入先ドキュメントの添付ファイル (annotations)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

ソース フィルター: ((DocumentAttachmentTypeCode == "Note") || (DocumentAttachmentTypeCode == "URL"))

取消済ソース フィルター: (objecttypecode eq 'msdyn_vendor' and msdyn_relatedentityid2 ne null) または (objecttypecode eq 'account' and msdyn_relatedentityid2 ne null) または (objecttypecode eq 'contact' and msdyn_relatedentityid2 ne null)

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
DOCUMENTID = msdyn_notesid
メモ = notetext
ATTACHMENTDESCRIPTION = subject
VENDORACCOUNTNUMBER = msdyn_relatedentityid2
DOCUMENTATTACHMENTTYPECODE << なし メモ
なし >> objecttypecode msdyn_vendor
ACCESSRESTRICTION ><
internal : 0
external : 1
msdyn_restriction

仕入先グループ (msdyn_vendorgroups)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
DEFAULTPAYMENTTERMNAME = msdyn_paymentterms.msdyn_name
DESCRIPTION = msdyn_description
VENDORGROUPID = msdyn_vendorgroup
CLEARINGPERIODPAYMENTTERMNAME = msdyn_clearingperiodpaymentpermname.msdyn_name

仕入先支払方法 (msdyn_vendorpaymentmethods)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
NAME = msdyn_name
説明 = msdyn_description
SUMBYPERIOD ><
transDate : 806380001
invoice : 806380000
week : 806380002
total : 806380003
msdyn_sumbyperiod
DISCOUNTGRACEPERIODDAYS = msdyn_discountgraceperioddays
PAYMENTSTATUS ><
none : 806380000
sent : 806380001
recieved : 806380002
approved : 806380003
rejected : 806380004
msdyn_paymentstatus
ALLOWPAYMENTCOPIES ><
no : False
yes : True
msdyn_allowpaymentcopies
PAYMENTTYPE ><
blank : 806380000
check : 806380001
electronicPayment : 806380002
promissoryNote : 806380003
msdyn_paymenttype
LASTFILENUMBER = msdyn_lastfilenumber
LASTFILENUMBERTODAY = msdyn_lastfilenumbertoday
ACCOUNTTYPE ><
ledger : 806380000
bank : 806380005
cust : 806380001
fixedAssets : 806380004
vend : 806380002
project : 806380003
msdyn_accounttype
BRIDGINGPOSTINGENABLED ><
no : False
yes : True
msdyn_bridgingposting
ENABLEPOSTDATEDCHECKCLEARINGPOSTING ><
no : False
yes : True
msdyn_postdatedcheckclearingposting
PROMISSORYNOTEDRAFTTYPE ><
noDraft : 806380000
noAcceptance : 806380001
acceptance : 806380002
promissory : 806380003
bankAcceptance : 806380004
msdyn_promissorynotedrafttype
DIRECTDEBIT ><
no : False
yes : True
msdyn_directdebit

仕入先 V2 (msdyn_vendors)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

ソース フィルター: ((VendorPartyType == "Organization") || (VendorPartyType == "Person"))

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
VENDORACCOUNTNUMBER = msdyn_vendoraccountnumber
VENDORGROUPID = msdyn_vendorgroupid.msdyn_vendorgroup
VENDORPARTYTYPE ><
person : True
organization : False
msdyn_isperson
CREDITLIMIT = msdyn_vendorcreditlimit
ISFOREIGNENTITY ><
no : False
yes : True
msdyn_isforeignentity
ISONETIMEVENDOR ><
no : False
yes : True
msdyn_isonetimevendor
CREDITRATING = msdyn_creditrating
DUNSNUMBER = msdyn_dunsnumber
ETHNICORIGINID = msdyn_ethnicorigin
OURACCOUNTNUMBER = msdyn_ourvendoraccountnumber
PAYMENTID = msdyn_paymentid
PRIMARYURL = msdyn_primarycontacturl
DEFAULTPAYMENTDAYNAME = msdyn_defaultpaymentdayname.msdyn_name
DEFAULTPAYMENTSCHEDULENAME = msdyn_paymentschedule.msdyn_name
DEFAULTPAYMENTTERMSNAME = msdyn_paymentterms.msdyn_name
HASONLYTAKENBIDS ><
no : False
yes : True
msdyn_hasonlytakenbids
ISMINORITYOWNED ><
no : False
yes : True
msdyn_isminorityowned
ISVENDORLOCALLYOWNED ><
yes : True
no : False
msdyn_isvendorlocallyowned
ISSERVICEVETERANOWNED ><
yes : True
no : False
msdyn_isserviceveteranowned
ISOWNERDISABLED ><
no : False
yes : True
msdyn_ownerisdisabled
ISWOMANOWNER ><
no : False
yes : True
msdyn_womanowner
ORGANIZATIONEMPLOYEEAMOUNT = msdyn_numberofemployees
VENDORHOLDRELEASEDATE = msdyn_vendoronholdreleasedate
VENDORPARTYNUMBER = msdyn_partyid.msdyn_partynumber
ONHOLDSTATUS ><
no : 806380000
invoice : 806380001
all : 806380002
payment : 806380003
requisition : 806380004
never : 806380005
msdyn_onholdstatus
CURRENCYCODE = msdyn_currencycode.isocurrencycode
ISVENDORLOCATEDINHUBZONE ><
no : False
yes : True
msdyn_isvendorlocatedinhubzone
DEFAULTVENDORPAYMENTMETHODNAME = msdyn_vendorpaymentmethod.msdyn_name
INVOICEVENDORACCOUNTNUMBER = msdyn_invoicevendoraccountnumber.msdyn_vendoraccountnumber
AREPRICESINCLUDINGSALESTAX ><
no : False
yes : True
msdyn_priceincludessalestax
SALESTAXGROUPCODE = msdyn_taxgroup.msdyn_name
PRIMARYCONTACTPERSONID = msdyn_primarycontact.msdyn_contactforpartynumber

退役軍人状態 (cdm_veteranstatuses)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
VETERANSTATUSID = cdm_name
説明 = cdm_description
ISPROTECTEDVETERAN ><
no : false
yes : true
cdm_isprotectedveteran

倉庫の場所 (msdyn_inventorylocations)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
BINID = msdyn_binid
CHECKDIGITS = msdyn_checkdigits
GENERATECHECKDIGITS ><
yes : True
no : False
msdyn_generatecheckdigits
ISSORTORDERCODEMANUAL ><
yes : True
no : False
msdyn_issortordercodemanual
ISWAREHOUSELOCATIONIDMANUAL ><
yes : True
no : False
msdyn_iswarehouselocationidmanual
LASTCOUNTEDUTCDATETIME = msdyn_lastcountedutcdatetime
PHYSICALDEPTH = msdyn_physicaldepth
PHYSICALHEIGHT = msdyn_physicalheight
PHYSICALHEIGHTABOVEGROUND = msdyn_physicalheightaboveground
PHYSICALMAXIMUMSTORAGEVOLUME = msdyn_physicalmaximumstoragevolume
PHYSICALMAXIMUMSTORAGEWEIGHT = msdyn_physicalmaximumstorageweight
PHYSICALWIDTH = msdyn_physicalwidth
RACKID = msdyn_rackid
SHELFID = msdyn_shelfid
WAREHOUSEID = msdyn_warehouse.msdyn_warehouseidentifier
WAREHOUSELOCATIONID = msdyn_warehouselocationid
WAREHOUSELOCATIONPROFILEID = msdyn_warehouselocationprofileid
WAREHOUSELOCATIONTYPE ><
buffer : 192350000
pick : 192350001
inputPort : 192350002
outputPort : 192350003
inspectionLocation : 192350004
kanbanSupermarket : 192350005
msdyn_warehouselocationtype
INPUTWAREHOUSELOCATIONBLOCKINGCAUSEID = msdyn_inputwarehouselocationblockingcauseid
OUTPUTWAREHOUSELOCATIONBLOCKINGCAUSEID = msdyn_outputwarehouselocationblockingcauseid
ISDEFAULTCREDITONLYRETURNWAREHOUSELOCATION ><
yes : True
no : False
msdyn_isdefaultcreditonlyreturnwarehouseloc
ISDEFAULTISSUEWAREHOUSELOCATION ><
yes : True
no : False
msdyn_isdefaultissuewarehouselocation
ISDEFAULTKANBANFINISHEDGOODSWAREHOUSELOCATION ><
yes : True
no : False
msdyn_isdefaultkanbanfinishedgoodswarehouseloc
ISDEFAULTPRODUCTIONFINISHEDGOODSWAREHOUSELOCATION ><
yes : True
no : False
msdyn_isdefaultproductionfinishedgoodswhsloc
ISDEFAULTPRODUCTIONINPUTWAREHOUSELOCATION ><
yes : True
no : False
msdyn_isdefaultproductioninputwarehouseloc
ISDEFAULTRECEIPTWAREHOUSELOCATION ><
yes : True
no : False
msdyn_isdefaultreceiptwarehouselocation
ISDEFAULTRETAILSTORERETURNWAREHOUSELOCATION ><
yes : True
no : False
msdyn_isdefaultretailstorereturnwarehouseloc
ISDEFAULTRETAILSTOREWAREHOUSELOCATION ><
yes : True
no : False
msdyn_isdefaultretailstorewarehouselocation
ISDEFAULTSHIPMENTMAINTENANCEWAREHOUSELOCATION ><
yes : True
no : False
msdyn_isdefaultshipmentmaintenancewarehouseloc
AGINGDATE > msdyn_agingdate
LASTACTIVITYDATETIME > msdyn_lastactivitydatetime
LOCATIONSTATUS >>
undetermined : 192350000
empty : 192350001
picking : 192350002
storage : 192350003
msdyn_locationstatus
ISITEMINLOCATIONMAINTAINED ><
yes : True
no : False
msdyn_isiteminlocationmaintained
ISLOCATIONACTIVITYDATETIMEMAINTAINED ><
yes : True
no : False
msdyn_islocationactivitydatetimemaintained
ISLOCATIONSTATUSMAINTAINED ><
yes : True
no : False
msdyn_islocationstatusmaintained
ISDEFAULTQUALITYMAINTENANCEWAREHOUSELOCATION ><
yes : True
no : False
msdyn_isdefaultqualitymaintenancewarehouseloc
WAREHOUSEAISLEID = msdyn_warehouseaisle.msdyn_aisleid
WAREHOUSEID > msdyn_warehouseaisle.msdyn_warehouse.msdyn_warehouseidentifier
WAREHOUSEZONEID = msdyn_warehousezone.msdyn_zoneid
FIRSTADDITIONALWAREHOUSEZONEID = msdyn_firstadditionalwarehousezone.msdyn_zoneid
SECONDADDITIONALWAREHOUSEZONEID = msdyn_secondadditionalwarehousezone.msdyn_zoneid
THIRDADDITIONALWAREHOUSEZONEID = msdyn_thirdadditionalwarehousezone.msdyn_zoneid
ITEMNUMBERINLOCATION = msdyn_itemnumberinlocation.msdyn_itemnumber

倉庫作業ヘッダー (msdyn_warehouseworkheaders)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
ACTUALPROCESSINGTIMESECONDS > msdyn_actualprocessingtimeseconds
ESTIMATEDPROCESSINGTIMESECONDS > msdyn_estimatedprocessingtimeseconds
ISWAREHOUSEWORKBLOCKED >>
yes : True
no : False
msdyn_iswarehouseworkblocked
WAREHOUSEID > msdyn_warehouse.msdyn_warehouseidentifier
INVENTORYSITEID > msdyn_inventorysite.msdyn_siteid
ISWAREHOUSEWORKERMANUALLYASSIGNED >>
yes : True
no : False
msdyn_iswarehouseworkermanuallyassigned
WAREHOUSEWORKCANCELLEDDATETIME > msdyn_warehouseworkcancelleddatetime
WAREHOUSEWORKCLOSEDDATETIME > msdyn_warehouseworkcloseddatetime
WAREHOUSEWORKID > msdyn_warehouseworkid
WAREHOUSEWORKPROCESSINGSTARTDATETIME > msdyn_warehouseworkprocessingstartdatetime
WAREHOUSEWORKPRIORITY > msdyn_warehouseworkpriority
WAREHOUSEWORKSTATUS >>
open : 192350000
inprocess : 192350001
skipped : 192350002
closed : 192350003
cancelled : 192350004
combined : 192350005
msdyn_warehouseworkstatus
WAREHOUSEWORKORDERTYPE >>
qualityOrder : 192350021
none : 192350000
purch : 192350001
sales : 192350002
prodPick : 192350003
prodPut : 192350004
prodProcessPut : 192350005
transferIssue : 192350006
transferReceipt : 192350007
invent : 192350008
workCancel : 192350009
cycleCount : 192350010
replenishment : 192350011
returnOrder : 192350012
kanbanPut : 192350013
kanbanPick : 192350014
cycleCountAccepted : 192350015
packedContainerPicking : 192350016
sortedInventoryPicking : 192350017
crossDocking : 192350018
qualityInQualityCheck : 192350019
qualityItemSampling : 192350020
msdyn_warehouseworkordertype
CONTAINERID > msdyn_containerid
WAREHOUSEWORKLOCKINGWAREHOUSEMOBILEDEVICEUSERID > msdyn_warehouseworklockingmobiledeviceuserid
TARGETLICENSEPLATENUMBER > msdyn_targetlicenseplatenumber
WAVEID > msdyn_waveid
WAREHOUSEWORKCANCELLINGUSERID > msdyn_warehouseworkcancellinguserid
WAREHOUSEWORKMANUALLYCOMPLETINGUSERID > msdyn_warehouseworkmanuallycompletinguserid
WAREHOUSEWORKPOOLID > msdyn_warehouseworkpoolid

倉庫の作業明細行 (msdyn_warehouseworklines)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
ACTUALPROCESSINGTIMESECONDS > msdyn_actualprocessingtimeseconds
ESTIMATEDPROCESSINGTIMESECONDS > msdyn_estimatedprocessingtimeseconds
FEFOITEMBATCHNUMBER > msdyn_fefoitembatchnumber
REMAININGHANDLINGQUANTITY > msdyn_remaininghandlingquantity
HANDLINGQUANTITY > msdyn_handlingquantity
WORKLINENUMBER > msdyn_worklinenumber
ISWORKLINEMANDATORY >>
yes : True
no : False
msdyn_isworklinemandatory
REMAININGWORKQUANTITY > msdyn_remainingworkquantity
WORKQUANTITY > msdyn_workquantity
ISREPLENISHMENTNEEDED >>
yes : True
no : False
msdyn_isreplenishmentneeded
SORTORDERCODE > msdyn_sortordercode
WORKQUANTITYUNITSYMBOL > msdyn_workquantityunit.msdyn_symbol
WAREHOUSEWORKCLOSEDDATETIME > msdyn_warehouseworkcloseddatetime
WAREHOUSEWORKID > msdyn_warehousework.msdyn_warehouseworkid
WAREHOUSEWORKPROCESSINGSTARTDATETIME > msdyn_warehouseworkprocessingstartdatetime
WAREHOUSEWORKSTATUS >>
open : 192350000
inProcess : 192350001
pendingReview : 192350002
skipped : 192350003
closed : 192350004
cancelled : 192350005
combined : 192350006
msdyn_warehouseworkstatus
ISWORKEXECUTIONSTOPPED >>
yes : True
no : False
msdyn_isworkexecutionstopped
WAREHOUSEWORKTYPE >>
none : 192350000
pick : 192350001
put : 192350002
count : 192350003
adjustment : 192350004
custom : 192350005
quarantine : 192350006
licensePlateBuild : 192350007
print : 192350008
statusChange : 192350009
packToNestedLicensePlate : 192350010
qualityCheck : 192350011
msdyn_warehouseworktype
EXTRAHANDLINGQUANTITY > msdyn_extrahandlingquantity
CAPTUREDWEIGHT > msdyn_capturedweight
WAREHOUSEID > msdyn_warehouse.msdyn_warehouseidentifier
INVENTORYSITEID > msdyn_inventorysite.msdyn_siteid
CONTAINERID > msdyn_containerid
PROCESSINGWAREHOUSEMOBILEDEVICEUSERID > msdyn_processingwarehousemobiledeviceuserid
ITEMBATCHNUMBER > msdyn_itembatchnumber
INVENTORYOWNERID > msdyn_inventoryownerid
ITEMSERIALNUMBER > msdyn_itemserialnumber
INVENTORYSTATUSID > msdyn_inventorystatusid
LICENSEPLATENUMBER > msdyn_licenseplatenumber
ITEMNUMBER > msdyn_item.msdyn_itemnumber
WAREHOUSEZONEID > msdyn_warehousezone.msdyn_zoneid
WAREHOUSELOCATIONID > msdyn_warehouselocation.msdyn_warehouselocationid
WAREHOUSEID > msdyn_warehouselocation.msdyn_warehouse.msdyn_warehouseidentifier
PRODUCTCONFIGURATIONID > msdyn_productconfiguration.msdyn_productconfiguration
PRODUCTCOLORID > msdyn_productcolor.msdyn_productcolorname
PRODUCTSIZEID > msdyn_productsize.msdyn_productsize
PRODUCTSTYLEID > msdyn_productstyle.msdyn_productstyle

倉庫ゾーン グループ (msdyn_warehousezonegroups)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
GROUPID = msdyn_groupid
GROUPNAME = msdyn_groupname

倉庫ゾーン (msdyn_warehousezones)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
WAREHOUSEZONEGROUPID = msdyn_warehousezonegroup.msdyn_groupid
ZONEID = msdyn_zoneid
ZONENAME = msdyn_zonename

倉庫 (msdyn_warehouses)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

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

源泉徴収税コード (msdyn_withholdingtaxcodes)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
WITHHOLDINGCODE = msdyn_name
WITHHOLDINGTAXNAME = msdyn_description
WITHHOLDINGTAXROUNDOFF = msdyn_roundoff
WITHHOLDINGTAXROUNDOFFTYPE ><
ordinary : 192350000
roundDown : 192350001
roundUp : 192350002
msdyn_roundofftype
CURRENCYCODEID = msdyn_currency.isocurrencycode
WITHHOLDINGTAXBASE ><
pctPerNet : 192350000
pctPerGross : 192350001
msdyn_taxableamountorigin

源泉徴収税グループ (msdyn_withholdingtaxgroups)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
WITHHOLDINGTAXGROUPCODE = msdyn_name
説明 = msdyn_description

作業者 (cdm_workers)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
PERSONNELNUMBER = cdm_workernumber
FIRSTNAME = cdm_firstname
MIDDLENAME = cdm_middlename
LASTNAME = cdm_lastname
WORKERTYPE >>
employee : 754400000
contractor : 754400001
both : 754400000
cdm_type
WORKERSTATUS >>
employed : 754400000
pending : 754400001
terminated : 754400001
cdm_status
PRIMARYCONTACTEMAIL = cdm_primaryemailaddress
PRIMARYCONTACTPHONE = cdm_primarytelephone
PRIMARYCONTACTFACEBOOK = cdm_facebookidentity
PRIMARYCONTACTTWITTER = cdm_twitteridentity
PRIMARYCONTACTLINKEDIN = cdm_linkedinidentity
PRIMARYCONTACTURL = cdm_websiteurl
GENDER ><
male : 754400000
female : 754400001
nonSpecific : 754400003
none : 754400002
cdm_gender
BIRTHDATE = cdm_birthdate
NAME > cdm_fullname

CDSの場所ロール (msdyn_addressroles)

このテンプレートは、財務と運用アプリと Dataverse 間でデータを同期します。

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
ISCONTACTINFORMATION ><
yes : true
no : false
msdyn_iselectronicaddressrole
ISPOSTALADDRESS ><
yes : true
no : false
msdyn_ispostaladdressrole
PURPOSE = msdyn_name

移動オーダーのヘッダー

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
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

移動オーダー製品

財務と運用フィールド タイプのマッピング Customer Engagement 列 既定値
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