Kaksoiskirjoituksen yhdistämismääritysten viite

Mapping tables

Mapping types

Yhdistämismäärityksiä on useita erilaisia. Seuraavassa taulukossa kerrotaan mallitaulukoissa käytetyt symbolit.

Symbol Description
> One-way
>> Yksisuuntainen eli tiedot muunnetaan prosessissa.
= Bidirectional
>< Kaksisuuntainen ja tiedot muunnetaan prosessissa.
<< Yksisuuntainen eli tiedot muunnetaan prosessissa.

Filters

Lähdesuodatin ja lähdesuodattimen käänteissuodatin määrittävät, mitkä rivit synkronoidaan.

Default values

Jos synkronoituja kenttiä ei ole joko Finance and Operations -taulukossa tai Customer Engagement -taulukossa, synkronoidussa taulukossa määritetään oletusarvo. Joissakin tapauksissa oletusarvo on kokonaisluku, joka on haku Dataverse-funktion määritteen arvoon. Esimerkiksi Contact-taulukossaaddress1AddressTypeCode-arvon oletusarvo on 3 (Ensisijainen osoite).

Templates

Talous- ja toimintosovellus Asiakkaiden aktivointisovellus Description
All products msdyn_globalproducts
Resurssien hallinnan resurssien elinkaarimallit msdyn_assetlifecyclemodels
Resurssien hallinnan resurssien elinkaaritilat msdyn_assetlifecyclestates
Resurssien hallinnan resurssityypit msdyn_customerassetcategories
Resurssien hallinnan resurssit msdyn_customerassets
Resurssien hallinnan toiminnallisen sijainnin elinkaarimallit msdyn_functionallocationlifecyclemodels
Resurssien hallinnan toiminnallisen sijainnin elinkaaritilat msdyn_functionallocationlifecyclestates
Resurssien hallinnan toiminnallisen sijainnin tyypit msdyn_functionallocationtypes
Resurssien hallinnan toiminnalliset sijainnit msdyn_functionallocations
Resurssien hallinnan valmistajat msdyn_manufacturers
Resurssien hallinnan mallit msdyn_models
Resurssien hallinnan takuu msdyn_warranties
CDS-yhteyshenkilöt V2 contacts
CDS-vaihtokurssit msdyn_currencyexchangerates
CDS Parties msdyn_parties
CDS-osapuolen postiosoitteiden sijainnit msdyn_partypostaladdresses
CDS:n käytettävissä olevan varaston merkinnät msdyn_inventoryonhandentries
CDS:n käytettävissä olevan varaston pyynnöt msdyn_inventoryonhandrequests
CDS-osapuolen postiosoitteen historia V2 msdyn_postaladdresses
CDS-postiosoitteiden sijainnit msdyn_postaladdresscollections
CDS:n ostotilausrivin entiteetti msdyn_purchaseorderproducts
CDS:n ostotilausrivin pehmeä poisto -entiteetti msdyn_purchaseorderproducts
CDS-vapautetut erilliset tuotteet products
CDS-myyntitilauksien otsikot salesorders
CDS-myyntitilausrivit salesorderdetails
CDS-myyntitarjouksen otsikko quotes
CDS-myyntitarjousrivit quotedetails
Tilikartta msdyn_chartofaccountses
Colors msdyn_productcolors
Korvaustyöfunktio cdm_jobfunctions
Korvaustyön tyyppi cdm_jobtypes
Complimentary closings msdyn_complimentaryclosings
Configurations msdyn_productconfigurations
Yhteyshenkilöiden arvonimet msdyn_salescontactpersontitles
Contacts V2 msdyn_contactforparties
Currencies transactioncurrencies
Customer Attachments annotations
Customer groups msdyn_customergroups
Customer hierarchies msdyn_customerhierarchies
Asiakashierarkian solmut msdyn_customerhierarchynodes
Asiakkaan maksutapa msdyn_customerpaymentmethods
Customers V3 accounts
Customers V3 contacts
Päätöksentekoroolit msdyn_decisionmakingroles
Tilauksen oletusasetukset msdyn_productdefaultordersettings
DV julkaisi erillisiä tuotteita products
DV:n julkaisemat tuotteet msdyn_sharedproductdetails
Dynamics 365 Salesin ominaisuuksien hallinnan tilat msdyn_supplychainfeaturestates
Dynamics 365 Sales -tilauksen otsikot salesorders
Dynamics 365 Sales -tilausrivit salesorderdetails
Dynamics 365 Sales -tarjouksen otsikko quotes
Dynamics 365 Sales -tarjousrivit quotedetails
Työsuhteen työtehtävät msdyn_employmentjobfunctions
Työllisyys per yritys cdm_employments
Ethnic origins cdm_ethnicorigins
Vaihtokurssivaluuttapari msdyn_currencyexchangeratepairs
Vaihtokurssin tyyppi msdyn_exchangeratetypes
Taloushallinnon dimensiomuoto msdyn_financialdimensionformats
Financial dimensions msdyn_dimensionattributes
Kirjanpidon vuosikalenterin integraation yksikkö msdyn_fiscalcalendars
Kirjanpidon vuosikalenterin kausi msdyn_fiscalcalendarperiods
Kirjanpidon kalenterivuoden integraation yksikkö msdyn_fiscalcalendaryears
Inventory aisle msdyn_warehouseaisles
Nimikkeen arvonlisäveroryhmä msdyn_taxitemgroups
Jobs cdm_jobs
Language codes cdm_languages
Ledger msdyn_ledgers
Legal entities cdm_companies
Legal entities msdyn_internalorganizations
Loyalty card msdyn_loyaltycards
Loyalty levels msdyn_loyaltylevels
Kanta-asiakkaan palkkiopisteet msdyn_loyaltyrewardpoints
Main account msdyn_mainaccounts
Päätililuokat msdyn_mainaccountcategories
Tehostetun todellisuuden oppaan entiteetti msmrw_guides
Toimitustavat msdyn_shipvias
Name affixes msdyn_nameaffixes
Operating unit msdyn_internalorganizations
Organisaatiohierarkia – julkaistu msdyn_internalorganizationhierarchies
Organisaatiohierarkian tarkoitukset msdyn_internalorganizationhierarchypurposes
Organisaatiohierarkian tyyppi msdyn_internalorganizationhierarchytypes
Osapuolen yhteyshenkilöt V3 msdyn_partyelectronicaddresses
CDS V2 -maksupäivärivit msdyn_paymentdaylines
CDS-maksupäivät msdyn_paymentdays
Payment schedule msdyn_paymentschedules
Maksusuunnitelmarivit msdyn_paymentschedulelines
Henkilökohtaisten luonteenpiirteiden tyypit msdyn_personalcharactertypes
Position type cdm_positiontypes
Sijoita työntekijämääritykset cdm_positionworkerassignmentmaps
Positions V2 cdm_jobpositions
Hinta-asiakasryhmät msdyn_pricecustomergroups
Tuotenumeron viivakoodi msdyn_productbarcodes
Product categories msdyn_productcategories
Tuoteluokan määritykset msdyn_productcategoryassignments
Tuoteluokkahierarkiat msdyn_productcategoryhierarchies
Tuoteluokkahierarkian roolit msdyn_productcategoryhierarchyroles
Tuotteen oletustilausasetukset V2 msdyn_productspecificdefaultordersettings
Tuotedimension ryhmät msdyn_productdimensiongroups
Päätuotteen värit msdyn_sharedproductcolors
Päätuotteen konfiguraatiot msdyn_sharedproductconfigurations
Päätuotteen koot msdyn_sharedproductsizes
Päätuotteen tyylit msdyn_sharedproductstyles
Tuotteen vastaanoton otsikko msdyn_purchaseorderreceipts
Tuotteen vastaanottorivi msdyn_purchaseorderreceiptproducts
Tuotekohtaiset yksikkömuunnokset msdyn_productspecificunitofmeasureconversions
Prospects leads
Ostotilauksen otsikkoasiakirjan liitteet annotations
Ostotilauksen otsikot V2 msdyn_purchaseorders
Vapautetut tuotteet V2 msdyn_sharedproductdetails
Myyntilaskun otsikot V2 invoices
Myyntilaskun rivit V2 invoicedetails
Myyntitilauksen otsikkoasiakirjan liitteet annotations
Myyntitilausten alkuperän koodit msdyn_salesorderorigins
Alv-viranomaiset msdyn_taxauthorities
Arvonlisäveron verovapauskoodin yksikkö CDS:lle msdyn_taxexemptcodes
Arvonlisäveroryhmät msdyn_taxgroups
Arvonlisäveron kirjanpidon kirjausryhmät V2 msdyn_taxpostinggroups
Salutations msdyn_salutations
Sites msdyn_operationalsites
Sizes msdyn_productsizes
Varastodimensioryhmät msdyn_productstoragedimensiongroups
Styles msdyn_productstyles
Toimitusehdot msdyn_termsofdeliveries
Maksuehdot msdyn_paymentterms
Seurantadimensioryhmät msdyn_producttrackingdimensiongroups
Unit conversions msdyn_unitofmeasureconversions
Units uoms
Toimittajan asiakirjaliitteet annotations
Vendor groups msdyn_vendorgroups
Toimittajan maksutapa msdyn_vendorpaymentmethods
Vendors V2 msdyn_vendors
Veteran status cdm_veteranstatuses
Warehouse locations msdyn_inventorylocations
Varaston työotsikot msdyn_warehouseworkheaders
Varaston työrivit msdyn_warehouseworklines
Varastovyöhykeryhmät msdyn_warehousezonegroups
Warehouse zones msdyn_warehousezones
Warehouses msdyn_warehouses
Ennakonpidätyskoodit msdyn_withholdingtaxcodes
Ennakonpidätysryhmät msdyn_withholdingtaxgroups
Worker cdm_workers

Kaikki tuotteet (msdyn_globalproducts)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
PRODUCTNAME > msdyn_productname
PRODUCTNUMBER > msdyn_productnumber

Resurssien hallinnan resurssin elinkaarimallit (msdyn_assetlifecyclemodels)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
ACTIVELIFECYCLESTATEID = msdyn_activelifecyclestate.msdyn_assetlifecyclestate_id
INBOUNDLIFECYCLESTATEID = msdyn_inboundlifecyclestate.msdyn_assetlifecyclestate_id
INSTORAGELIFECYCLESTATEID = msdyn_instoragelifecyclestate.msdyn_assetlifecyclestate_id
LIFECYCLEMODELID = msdyn_assetlifecyclemodel_id
NAME = msdyn_name
ONLOANLIFECYCLESTATEID = msdyn_onloanlifecyclestate.msdyn_assetlifecyclestate_id
OUTBOUNDLIFECYCLESTATEID = msdyn_outboundlifecyclestate.msdyn_assetlifecyclestate_id
RECEIVEDLIFECYCLESTATEID = msdyn_receivedlifecyclestate.msdyn_assetlifecyclestate_id

Resurssien hallinnan resurssien elinkaaritiloja (msdyn_assetlifecyclestates)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DELETEOPENCALENDARLINES ><
yes : True
no : False		 msdyn_deleteopencalendarlines
LIFECYCLESTATEID = msdyn_assetlifecyclestate_id
LINE = msdyn_line
MAINTENANCEASSETACTIVE ><
yes : True
no : False		 msdyn_maintenanceassetactive
NAME = msdyn_name

Resurssien hallinnan resurssityypit (msdyn_customerassetcategories)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
LIFECYCLEMODELID = msdyn_lifecyclemodel.msdyn_assetlifecyclemodel_id
MAINTENANCEASSETTYPEID = msdyn_maintenanceassettypeid
NAME = msdyn_name
CALCULATEKPITOTAL ><
no : False
yes : True		 msdyn_calculatekpitotal

Resurssienhallintaresurssit (msdyn_customerassets)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
ACQUISITIONCOST = msdyn_acquisitioncost
ACQUISITIONDATE = msdyn_acquisitiondate
ACTIVEFROM = msdyn_activefrom
ACTIVETO = msdyn_activeto
FUNCTIONALLOCATIONID = msdyn_functionallocation.msdyn_functionallocation_id
MAINTENANCEASSETLIFECYCLESTATEID = msdyn_assetlifecyclestate.msdyn_assetlifecyclestate_id
MODELID = msdyn_model.msdyn_model_id
MODELPRODUCTID = msdyn_model.msdyn_manufacturer.msdyn_manufacturer_id
MODELYEAR = msdyn_modelyear
NAME = msdyn_name
NOTES = msdyn_notes
PURCHASEORDERID = msdyn_purchaseorderid
REPLACEMENTDATE ><
1/1/1900 :aihio		 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

Resurssien hallinnan toiminnalliset sijainnin elinkaarimallit (msdyn_functionallocationlifecyclemodels)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
LIFECYCLEMODELID = msdyn_functionallocationlifecyclemodel_id
NAME = msdyn_name

Resurssien hallinnan toiminnallisen sijainnin elinkaaren tilat (msdyn_functionallocationlifecyclestates)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
ALLOWDELETELOCATION ><
yes : True
no : False		 msdyn_allowdeletelocation
ALLOWNEWSUBLOCATIONS ><
yes : True
no : False		 msdyn_allownewsublocations
ALLOWRENAMELOCATION ><
yes : True
no : False		 msdyn_allowrenamelocation
FUNCTIONALLOCATIONACTIVE ><
yes : True
no : False		 msdyn_functionallocationactive
LIFECYCLESTATEID = msdyn_functionallocationlifecyclestate_id
NAME = msdyn_name
ALLOWINSTALLMAINTENANCEASSETS ><
yes : True
no : False		 msdyn_allowinstallmaintenanceassets
CREATELOCATIONMAINTENANCEASSET ><
yes : True
no : False		 msdyn_createlocationmaintenanceasset
MAINTENANCEASSETLIFECYCLESTATEID = msdyn_assetlifecyclestate.msdyn_assetlifecyclestate_id

Resurssien hallinnan toiminnalliset sijaintityypit (msdyn_functionallocationtypes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
ALLOWMULTIPLEINSTALLEDASSETS ><
yes : True
no : False		 msdyn_allowmultipleinstalledassets
FUNCTIONALLOCATIONTYPEID = msdyn_functionallocationtype_id
NAME = msdyn_name
UPDATEASSETDIMENSION ><
yes : True
no : False		 msdyn_updateassetdimension
LIFECYCLEMODELID = msdyn_lifecyclemodelid.msdyn_functionallocationlifecyclemodel_id
MAINTENANCEASSETTYPEID = msdyn_maintenanceassettype.msdyn_maintenanceassettypeid

Resurssienhallinnan toiminnalliset sijainnit (msdyn_functionallocations)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
FUNCTIONALLOCATIONID = msdyn_functionallocation_id
INVENTORYLOCATIONID = msdyn_inventorylocationid
INVENTORYSITEID = msdyn_inventorysiteid
NAME = msdyn_name
NOTES = msdyn_notes
PARENTFUNCTIONALLOCATIONID = msdyn_parentfunctionallocation.msdyn_functionallocation_id
FUNCTIONALLOCATIONLIFECYCLESTATEID = msdyn_functionallocationlifecyclestate.msdyn_functionallocationlifecyclestate_id
FUNCTIONALLOCATIONTYPEID = msdyn_functionallocationtype.msdyn_functionallocationtype_id

Resurssienhallinnan valmistajat (msdyn_manufacturers)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DESCRIPTION = msdyn_description
PRODUCTID = msdyn_manufacturer_id

Resurssienhallintamallit (msdyn_models)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DESCRIPTION = msdyn_description
MODELID = msdyn_model_id
PRODUCTID = msdyn_manufacturer.msdyn_manufacturer_id
MAINTENANCEASSETTYPEID = msdyn_maintenanceassettype.msdyn_maintenanceassettypeid

Resurssien hallinnan takuu (msdyn_warranties)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
NAME = msdyn_name
WARRANTYID = msdyn_warranty_id

CDS-kontaktit V2 (yhteyshenkilöt)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Lähdesuodatin: (AssociatedContactType = 1)

Käänteinen lähdesuodatin: msdyn_contactforvendor eq true ja msdyn_sellable eq false ja msdyn_contactpersonid ne null

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
CONTACTPERSONPARTYNUMBER = msdyn_partyid.msdyn_partynumber
ASSOCIATEDCONTACTTYPE << none Vendor
ASSOCIATEDCONTACTNUMBER = msdyn_vendorcontactid.msdyn_vendoraccountnumber
EMPLOYMENTDEPARTMENT = osasto
NOTES = description
GOVERNMENTIDENTIFICATIONNUMBER = governmentid
ISRECEIVINGDIRECTMAIL ><
no : False
yes : True		 donotemail
SPOUSENAME = spousesname
none >> msdyn_contactforvendor True
CONTACTPERSONID = msdyn_contactpersonid

CDS-valuuttakurssit (msdyn_currencyexchangerates)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
EXCHANGERATETYPENAME > msdyn_currencyexchangeratepair.msdyn_currencyexchangeratetypeid.msdyn_name
FROMCURRENCYCODE > msdyn_currencyexchangeratepair.msdyn_fromtransactioncurrencyid.isocurrencycode
TOCURRENCYCODE > msdyn_currencyexchangeratepair.msdyn_totransactioncurrencyid.isocurrencycode
RATE > msdyn_exchangerate
VALIDFROM > msdyn_validfrom
VALIDTO > msdyn_validto

CDS-osapuolet (msdyn_parties)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

CDS-osapuolen postiosoitesijainnit (msdyn_partypostaladdresses)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
ISPRIMARY ><
no : False
yes : True		 msdyn_isprimary
LOCATIONID = msdyn_postaladdresscollectionid.msdyn_location
PARTYNUMBER = msdyn_partyid.msdyn_partynumber
PURPOSE = msdyn_postaladdresspurposenames
ISLOCATIONOWNER >>
no : False
yes : True		 msdyn_islocationowner

CDS:n käytettävissä olevan varaston viennit (msdyn_inventoryonhandentries)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
REQUESTID = msdyn_request.msdyn_requestid
INVENTORYSITEID = msdyn_inventorysite.msdyn_siteid
INVENTORYWAREHOUSEID = msdyn_inventorywarehouse.msdyn_warehouseidentifier
AVAILABLEONHANDQUANTITY > msdyn_availableonhandquantity
AVAILABLEORDEREDQUANTITY > msdyn_availableorderedquantity
ONHANDQUANTITY > msdyn_onhandquantity
ONORDERQUANTITY > msdyn_onorderquantity
ORDEREDQUANTITY > msdyn_orderedquantity
RESERVEDONHANDQUANTITY > msdyn_reservedonhandquantity
RESERVEDORDEREDQUANTITY > msdyn_reservedorderedquantity
TOTALAVAILABLEQUANTITY > msdyn_totalavailablequantity
ATPDATE = msdyn_atpdate
ATPQUANTITY > msdyn_atpquantity
PROJECTEDISSUEQUANTITY > msdyn_projectedissuequantity
PROJECTEDONHANDQUANTITY > msdyn_projectedonhandquantity
PROJECTEDRECEIPTQUANTITY > msdyn_projectedreceiptquantity
ORDERQUANTITY > msdyn_orderquantity
UNAVAILABLEONHANDQUANTITY > msdyn_unavailableonhandquantity

CDS:n käytettävissä olevan varaston pyynnöt (msdyn_inventoryonhandrequests)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
REQUESTID = msdyn_requestid
PRODUCTNUMBER < msdyn_product.msdyn_productnumber
ISATPCALCULATION <<
no : False
yes : True		 msdyn_isatpcalculation
ORDERQUANTITY < msdyn_orderquantity
INVENTORYSITEID < msdyn_inventorysite.msdyn_siteid
INVENTORYWAREHOUSEID < msdyn_inventorywarehouse.msdyn_warehouseidentifier
REFERENCENUMBER < msdyn_referencenumber
LINECREATIONSEQUENCENUMBER < msdyn_linecreationsequencenumber

CDS-postiosoitehistoria V2 (msdyn_postaladdresses)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
LOCATIONID = msdyn_postaladdresscollectionid.msdyn_location
VALIDFROM = msdyn_validfrom
VALIDTO = msdyn_validto
DESCRIPTION = msdyn_name
STREET = msdyn_street
STREETNUMBER = msdyn_streetnumber
CITY = msdyn_city
STATE = msdyn_state
COUNTRYREGIONID = msdyn_countryregionid
ZIPCODE = msdyn_zipcode
COUNTY = msdyn_county
DISTRICTNAME = msdyn_district
BUILDINGCOMPLIMENT = msdyn_buildingcompliment
POSTBOX = msdyn_postbox

CDS-postiosoitesijainnit (msdyn_postaladdresscollections)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DESCRIPTION = msdyn_description
LOCATIONID = msdyn_location

CDS:n ostotilausrivin entiteetti (msdyn_purchaseorderproducts)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

CDS-ostotilauksen riviltä poistettu pehmeä entiteetti (msdyn_purchaseorderproducts)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
LINENUMBER > msdyn_lineorder
PURCHASEORDERNUMBER > msdyn_purchaseorder.msdyn_name
ISDELETED >>
yes : true
no : false		 msdyn_issoftdeletedinscm

CDS julkaisi erillisiä tuotteita (tuotteita)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

CDS-myyntitilauksen otsikot (salesorders)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Käänteinen lähdesuodatin: msdyn_ordertype eq 192350000

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

CDS-myyntitilauksen rivit (salesorderdetails)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

CDS-myyntitarjouksen otsikko (quotes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Käänteinen lähdesuodatin: msdyn_ordertype eq 192350000 ja statecode eq 0

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

CDS-myyntitarjouksen rivit (quotedetails)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Tilikaavio (msdyn_chartofaccountses)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DESCRIPTION = msdyn_description
MAINACCOUNTMASK = msdyn_mainaccountmask
CHARTOFACCOUNTS = msdyn_name

Colors (msdyn_productcolors)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
COLORID > msdyn_productcolorname

Kompensaatiotyötehtävä (cdm_jobfunctions)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
JOBFUNCTIONID = cdm_name
DESCRIPTION = cdm_description

Kompensaatiotyötyyppi (cdm_jobtypes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
JOBTYPEID = cdm_name
DESCRIPTION = cdm_description
EXEMPTSTATUS ><
exempt : 754400000
nonexempt : 754400001
doesnotapply : 754400002		 cdm_exemptstatus

Ilmaiset sulkemiset (msdyn_complimentaryclosings)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
CLOSINGPHRASE = msdyn_closingphrase

Configurations (msdyn_productconfigurations)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
CONFIGURATIONID > msdyn_productconfiguration

Yhteyshenkilön otsikot (msdyn_salescontactpersontitles)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
JOBTITLE = msdyn_jobtitle
JOBTITLEALIAS = msdyn_jobtitlealias

Yhteyshenkilöt V2 (msdyn_contactforparties)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Currencies (transactioncurrencies)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Lähdesuodatin: ((CURRENCYCODE != "999"))

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
CURRENCYCODE = isocurrencycode
NAME = currencyname
SYMBOL = currencysymbol
none >> exchangerate 1.0000000000

Asiakasliitteet (huomautukset)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Lähdesuodatin: ((TypeId == "Huomautus") || (TypeId == "URL"))

Käänteinen lähdesuodatin: (objecttypecode eq 'account' tai objecttypecode eq 'contact') ja msdyn_relatedentityid ne null

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DOCUMENTID = msdyn_notesid
NAME = subject
none >> objecttypecode tili
CUSTOMERACCOUNTNUMBER = msdyn_relatedentityid
TYPEID << none Note
NOTES = notetext
RESTRICTION ><
internal : 0
external : 1		 msdyn_restriction

Asiakasryhmät (msdyn_customergroups)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
CUSTOMERGROUPID = msdyn_groupid
DESCRIPTION = msdyn_description
ISSALESTAXINCLUDEDINPRICE ><
no : False
yes : True		 msdyn_issalestaxincludedinprice
PAYMENTTERMID = msdyn_paymenttermid.msdyn_name
CLEARINGPERIODPAYMENTTERMNAME = msdyn_clearingperiodpaymenttermname.msdyn_name

Asiakashierarkiat (msdyn_customerhierarchies)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
CUSTOMERHIERARCHYID = msdyn_customerhierarchynumber
NAME = msdyn_name
ORGANIZATIONPARTYNUMBER = msdyn_organizationpartynumber.msdyn_partynumber
PURPOSE ><
B2BOrganization : 192350000		 msdyn_purpose

Asiakashierarkian solmut (msdyn_customerhierarchynodes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
CUSTOMERHIERARCHYID = msdyn_customerhierarchynumber.msdyn_customerhierarchynumber
NODEPARTYNUMBER = msdyn_nodepartynumber.msdyn_partynumber
NODETYPE ><
Customer : 192350000		 msdyn_nodetype
ROLE ><
Admin : 192350000
User : 192350001		 msdyn_role

Asiakkaan maksutapa (msdyn_customerpaymentmethods)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Asiakkaat V3 (accounts)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Lähdesuodatin: ((PartyType == "Organisaatio"))

Käänteinen lähdesuodatin: customertypecode eq 3

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

Asiakkaat V3 (yhteyshenkilöt)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Lähdesuodatin: ((PartyType == "Henkilö"))

Käänteinen lähdesuodatin: msdyn_sellable eq true ja msdyn_contactpersonid ne null

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
none >> msdyn_sellable True
PARTYTYPE << none Person
PARTYNUMBER = msdyn_partyid.msdyn_partynumber
CUSTOMERACCOUNT = msdyn_contactpersonid
CUSTOMERGROUPID = msdyn_customergroupid.msdyn_groupid
IDENTIFICATIONNUMBER = msdyn_identificationnumber
PARTYCOUNTRY = msdyn_partycountry
PARTYSTATE = msdyn_partystateprovince
SALESCURRENCYCODE = transactioncurrencyid.isocurrencycode
SALESMEMO = description
PAYMENTDAY = msdyn_paymentday.msdyn_name
PAYMENTSCHEDULE = msdyn_paymentschedule.msdyn_name
PAYMENTMETHOD = msdyn_customerpaymentmethod.msdyn_name
SALESTAXGROUP = msdyn_salestaxgroup.msdyn_name
PAYMENTTERMS = msdyn_paymentterms.msdyn_name
CONTACTPERSONID = msdyn_primarycontact.msdyn_contactforpartynumber

Päätöksentekoroolit (msdyn_decisionmakingroles)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
ROLEDESCRIPTION = msdyn_roledescription
ROLENAME = msdyn_rolename

Oletusjärjestysasetukset (msdyn_productdefaultordersettings)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

DV julkaisi erillisiä tuotteita (tuotteita)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
PRODUCTNUMBER > msdyn_productnumber
PRODUCTNAME > name
PRODUCTDESCRIPTION > description
ITEMNUMBER > msdyn_itemnumber
PRODUCTTYPE >>
item : 1
service : 3		 producttypecode
PRODUCTCOLORID > msdyn_productcolor.msdyn_productcolorname
PRODUCTCONFIGURATIONID > msdyn_productconfiguration.msdyn_productconfiguration
PRODUCTSIZEID > msdyn_productsize.msdyn_productsize
PRODUCTSTYLEID > msdyn_productstyle.msdyn_productstyle
ITEMNUMBER > msdyn_sharedproductdetailid.msdyn_itemnumber
[None] >> msdyn_shouldsyncwithsharedproductdetails True

DV:n julkaisemat tuotteet (msdyn_sharedproductdetails)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Dynamics 365 Salesin ominaisuudenhallinnan tilat (msdyn_supplychainfeaturestates)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
NAME = msdyn_name
ISENABLED ><
no : 1
yes : 0		 statecode

Dynamics 365 Sales -tilauksen otsikot (salesorders)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Käänteinen lähdesuodatin: msdyn_ordertype eq 192350000 ja msdyn_isreadytosync eq true

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

Dynamics 365 Sales -tilausrivit (salesorderdetails)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Käänteinen lähdesuodatin:

  • Versio 1.x.x.x: msdyn_isreadytosync eq true
    (Käytetään toimitusketjuratkaisun yhteydessä ilman, että asennettuna on Projektitoiminnot- tai Field Services -ratkaisu.)
  • Versio 2.x.x.x: (msdyn_linetype ne 690970000 tai msdyn_linetype eq null) ja msdyn_isreadytosync eq true
    (käytetään toimitusketjuratkaisun ja asennettujen Projektitoiminnot- tai Kenttäpalvelut-ratkaisun yhteydessä.)
Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
CURRENCYCODE > transactioncurrencyid.isocurrencycode
DELIVERYADDRESSCITY = shipto_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE ><
us : united states
de : germany
fr : france
gb : united kingdom
jp : japan
in : india
es : spain
nz : new zealand
au : australia
co : columbia
za : south africa
be : belgium
ca : canada
at : austria
tr : turkey
cn : china
dk : denmark
se : sweden
no : norway
fi : finland
eg : egypt		 shipto_country
DELIVERYADDRESSZIPCODE = shipto_postalcode
DELIVERYADDRESSSTATEID = shipto_stateorprovince
DELIVERYADDRESSSTREET = shipto_line1
DELIVERYADDRESSSTREETNUMBER = shipto_line2
LINEAMOUNT > extendedamount
LINECREATIONSEQUENCENUMBER = sequencenumber
ORDEREDSALESQUANTITY = quantity
PRODUCTNAME = description
PRODUCTNUMBER = productid.msdyn_productnumber
SALESORDERNUMBER = salesorderid.msdyn_salesordernumber
SALESUNITSYMBOL = uomid.msdyn_symbol
TOTALDISCOUNTAMOUNT = manualdiscountamount
TOTALTAXAMOUNT > vero
SALESPRICE = priceperunit
LINEAMOUNT > baseamount
SALESPRODUCTCATEGORYNAME = msdyn_salesproductcategory.msdyn_name
SALESPRODUCTCATEGORYHIERARCHYNAME > msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name
ISDELIVERYADDRESSORDERSPECIFIC ><
no : False
yes : True		 msdyn_isdeliveryaddressspecific
ISDELIVERYADDRESSPRIVATE ><
no : False
yes : True		 msdyn_isdeliveryaddressprivate
ISLINESTOPPED ><
no : False
yes : True		 msdyn_islinestopped
ALLOWEDOVERDELIVERYPERCENTAGE = msdyn_allowedoverdeliverypercentage
ALLOWEDUNDERDELIVERYPERCENTAGE = msdyn_allowedunderdeliverypercentage
CONFIRMEDSHIPPINGDATE = msdyn_confirmedshippingdate
CONFIRMEDRECEIPTDATE = msdyn_confirmedreceiptdate
DELIVERYADDRESSCOUNTYID = msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION = msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME = msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER = msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLATITUDE = msdyn_deliveryaddresslatitude
DELIVERYADDRESSLOCATIONID = msdyn_deliveryaddresslocationid
DELIVERYADDRESSLONGITUDE = msdyn_deliveryaddresslongitude
DELIVERYADDRESSNAME = msdyn_deliveryaddressname
DELIVERYADDRESSPOSTBOX = msdyn_deliveryaddresspostbox
DELIVERYBUILDINGCOMPLIMENT = msdyn_deliverybuildingcompliment
EXTERNALITEMNUMBER = msdyn_externalitemnumber
FIXEDPRICECHARGES = msdyn_fixedpricecharges
FORMATTEDDELIVERYADDRESS = msdyn_formatteddeliveryaddress
LINEDESCRIPTION = msdyn_linedescription
LINEDISCOUNTAMOUNT = msdyn_linediscountamount
LINEDISCOUNTPERCENTAGE = msdyn_linediscountpercentage
MULTILINEDISCOUNTAMOUNT = msdyn_multilinediscountamount
MULTILINEDISCOUNTPERCENTAGE = msdyn_multilinediscountpercentage
REQUESTEDRECEIPTDATE = msdyn_requestedreceiptdate
REQUESTEDSHIPPINGDATE = requestdeliveryby
SALESORDERLINESTATUS >>
none : 192350000
backorder : 192350001
delivered : 192350002
invoiced : 192350003
canceled : 192350004		 msdyn_linestatus
SALESORDERPROMISINGMETHOD ><
none : 192350000
salesLeadTime : 192350001
atp : 192350002
atpPlusIssueMargin : 192350003
ctp : 192350004		 msdyn_salesorderpromisingmethod
SALESPRICEQUANTITY = msdyn_salespricequantity
SHIPPINGSITEID = msdyn_shippingsite.msdyn_siteid
SHIPPINGWAREHOUSEID = msdyn_shippingwarehouse.msdyn_warehouseidentifier
none >> ispriceoverridden true
TOTALCHARGESAMOUNT > msdyn_totalchargesamount
DELIVERYMODECODE = msdyn_deliverymode.msdyn_name
DELIVERYTERMSID = msdyn_deliveryterms.msdyn_termscode
SALESDELIVERNOW = quantityshipped
INVENTORYSERVICERESERVATIONID = msdyn_reservationid

Dynamics 365 Sales -tarjouksen otsikko (quotes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Käänteinen lähdesuodatin: msdyn_ordertype eq 192350000

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

Dynamics 365 Sales -tarjousrivit (quotedetails)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Käänteinen lähdesuodatin:

  • Versio 1.x.x.x: Ei mitään
    (Käytetään toimitusketjuratkaisun yhteydessä ilman, että asennettuna on Projektitoiminnot- tai Field Services -ratkaisu.)
  • Versio 2.x.x.x: msdyn_linetype ne 690970000 tai msdyn_linetype eq null
    (käytetään toimitusketjuratkaisun ja asennettujen Projektitoiminnot- tai Kenttäpalvelut-ratkaisun yhteydessä.)
Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
ALLOWEDOVERDELIVERYPERCENTAGE = msdyn_allowedoverdeliverypercentage
ALLOWEDUNDERDELIVERYPERCENTAGE = msdyn_allowedunderdeliverypercentage
SALESQUOTATIONNUMBER = quoteid.msdyn_quotenumber
LINECREATIONSEQUENCENUMBER = sequencenumber
CURRENCYCODE > transactioncurrencyid.isocurrencycode
DELIVERYADDRESSCITY = shipto_city
DELIVERYADDRESSCOUNTRYREGIONISOCODE ><
us : united states
de : germany
fr : france
gb : united kingdom
jp : japan
in : india
es : spain
nz : new zealand
au : australia
co : columbia
za : south africa
be : belgium
ca : canada
at : austria
tr : turkey
cn : china
dk : denmark
se : sweden
no : norway
fi : finland
eg : egypt		 shipto_country
DELIVERYADDRESSCOUNTYID = msdyn_deliveryaddresscountyid
DELIVERYADDRESSDESCRIPTION = msdyn_deliveryaddressdescription
DELIVERYADDRESSDISTRICTNAME = msdyn_deliveryaddressdistrictname
DELIVERYADDRESSDUNSNUMBER = msdyn_deliveryaddressdunsnumber
DELIVERYADDRESSLATITUDE = msdyn_deliveryaddresslatitude
DELIVERYADDRESSLOCATIONID = msdyn_deliveryaddresslocationid
DELIVERYADDRESSLONGITUDE = msdyn_deliveryaddresslongitude
DELIVERYADDRESSNAME = msdyn_deliveryaddressname
DELIVERYADDRESSPOSTBOX = msdyn_deliveryaddresspostbox
DELIVERYADDRESSSTATEID = shipto_stateorprovince
DELIVERYADDRESSSTREET = shipto_line1
DELIVERYADDRESSSTREETNUMBER = shipto_line2
DELIVERYADDRESSZIPCODE = shipto_postalcode
DELIVERYBUILDINGCOMPLIMENT = msdyn_deliverybuildingcompliment
EXTERNALITEMNUMBER = msdyn_externalitemnumber
FIXEDPRICECHARGES = msdyn_fixedpricecharges
FORMATTEDDELIVERYADDRESS = msdyn_formatteddeliveryaddress
ISDELIVERYADDRESSPRIVATE ><
no : False
yes : True		 msdyn_isdeliveryaddressprivate
ISDELIVERYADDRESSORDERSPECIFIC ><
no : False
yes : True		 msdyn_isdeliveryaddressspecific
LINEAMOUNT > baseamount
LINEAMOUNT > extendedamount
LINEDESCRIPTION = msdyn_linedescription2
LINEDISCOUNTAMOUNT = msdyn_linediscountamount
LINEDISCOUNTPERCENTAGE = msdyn_linediscountpercentage
MULTILINEDISCOUNTAMOUNT = msdyn_multilinediscountamount
MULTILINEDISCOUNTPERCENTAGE = msdyn_multilinediscountpercentage
PRODUCTNAME = description
PRODUCTNUMBER = productid.msdyn_productnumber
REQUESTEDRECEIPTDATE = msdyn_requestedreceiptdate
REQUESTEDSALESQUANTITY = quantity
REQUESTEDSHIPPINGDATE = requestdeliveryby
SALESPRICE = priceperunit
SALESPRICEQUANTITY = msdyn_salespricequantity
SALESQUOTATIONPROMISINGMETHOD ><
none : 192350000
salesLeadTime : 192350001
atp : 192350002
atpPlusIssueMargin : 192350003
ctp : 192350004		 msdyn_salesquotationpromisingmethod
SALESQUOTATIONSTATUS ><
created : 192350000
sent : 192350001
confirmed : 192350002
lost : 192350003
cancelled : 192350004
reset : 192350005
modified : 192350006
submitted : 192350007
approved : 192350008
revised : 192350009		 msdyn_salesquotationstatus
SALESUNITSYMBOL = uomid.msdyn_symbol
SHIPPINGSITEID = msdyn_shippingsite.msdyn_siteid
SHIPPINGWAREHOUSEID = msdyn_shippingwarehouse.msdyn_warehouseidentifier
TOTALCHARGESAMOUNT > msdyn_totalchargesamount
TOTALDISCOUNTAMOUNT = manualdiscountamount
TOTALTAXAMOUNT > vero
SALESPRODUCTCATEGORYHIERARCHYNAME > msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name
SALESPRODUCTCATEGORYNAME = msdyn_salesproductcategory.msdyn_name
none >> ispriceoverridden true

Työtehtävät (msdyn_employmentjobfunctions)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
FUNCTIONDESCRIPTION = msdyn_functiondescription
FUNCTIONNAME = msdyn_functionname

Työsuhteita yritystä kohti (cdm_employments)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
EMPLOYMENTENDDATE = cdm_employmentenddate
PERSONNELNUMBER = cdm_workerid.cdm_workernumber
EMPLOYMENTSTARTDATE = cdm_employmentstartdate
WORKERTYPE >>
employee : 754400000
contractor : 754400001
both : 754400000		 cdm_workertype

Etniset alkuperät (cdm_ethnicorigins)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
ETHNICORIGINID = cdm_name
DESCRIPTION = cdm_description

Vaihtokurssivaluuttapari (msdyn_currencyexchangeratepairs)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
EXCHANGERATEDISPLAYFACTOR ><
one : 192350000
ten : 192350001
hundred : 192350002
thousand : 192350003
tenThousand : 192350004		 msdyn_displayfactor
EXCHANGERATETYPENAME = msdyn_currencyexchangeratetypeid.msdyn_name
FROMCURRENCYCODE = msdyn_fromtransactioncurrencyid.isocurrencycode
TOCURRENCYCODE = msdyn_totransactioncurrencyid.isocurrencycode

Vaihtokurssityyppi (msdyn_exchangeratetypes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
NAME = msdyn_name
DESCRIPTION = msdyn_description

Taloushallinnon dimensiomuoto (msdyn_financialdimensionformats)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DIMENSIONFORMATNAME = msdyn_dimensionformatname
DIMENSIONFORMATTYPE ><
dataEntityDefaultDimensionFormat : 192350000
dataEntityLedgerDimensionFormat : 192350001
dataEntityBudgetDimensionFormat : 192350002
dataEntityBudgetPlanningDimensionFormat : 192350003		 msdyn_dimensionformattype
FINANCIALDIMENSIONFORMAT = msdyn_financialdimensionformat
ISACTIVE ><
no : False
yes : True		 msdyn_isactive

Taloushallinnon dimensiot (msdyn_dimensionattributes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DIMENSIONNAME = msdyn_dimensionname
COPYVALUESONCREATE ><
no : False
yes : True		 msdyn_copyvaluesoncreate
REPORTCOLUMNNAME = msdyn_reportcolumnname
GIVEDERIVEDDIMENSIONSPRECEDENCE ><
no : False
yes : True		 msdyn_givederiveddimensionsprecedence
UseValuesFrom = msdyn_usevaluesfrom
DimensionValueMask = msdyn_dimensionvaluemask

Tilikausikalenterin integroinnin entiteetti (msdyn_fiscalcalendars)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
CALENDARID = msdyn_calendar
DESCRIPTION = msdyn_description

Tilikausi (msdyn_fiscalcalendarperiods)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Tilivuoden integrointientiteetti (msdyn_fiscalcalendaryears)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
FISCALCALENDAR_CALENDARID = msdyn_fiscalcalendarname
NAME = msdyn_name
STARTDATE = msdyn_startdate
ENDDATE = msdyn_enddate
FISCALCALENDAR_CALENDARID = msdyn_calendar.msdyn_calendar

Inventory-käytävä (msdyn_warehouseaisles)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
AISLEID = msdyn_aisleid
AISLENUMBER = msdyn_aislenumber
WAREHOUSEID = msdyn_warehouse.msdyn_warehouseidentifier
AISLENAME = msdyn_aislename
MANUALSTARTINGSORTORDERCODE = msdyn_manualstartingsortordercode
ISSORTORDERCODEASSIGNEDDESCENDING ><
yes : True
no : False		 msdyn_issortordercodeassigneddescending

Nimikkeen arvonlisäveroryhmä (msdyn_taxitemgroups)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
TAXITEMGROUP = msdyn_name
NAME = msdyn_description

Jobs (cdm_jobs)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
JOBID = cdm_name
MAXIMUMNUMBEROFPOSITIONS = cdm_maximumnumberofpositions
ALLOWUNLIMITEDPOSITIONS ><
yes : true
no : false		 cdm_allowunlimitedpositions
DESCRIPTION = cdm_description
JOBDESCRIPTION = cdm_jobdescription
JOBTYPEID = cdm_jobtypeid.cdm_name
FUNCTIONID = cdm_jobfunctionid.cdm_name
EFFECTIVE = cdm_validfrom
EXPIRATION = cdm_validto
FULLTIMEEQUIVALENT = cdm_defaultfulltimeequivalent

Kielikoodit (cdm_languages)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
LANGUAGECODEID = cdm_name
DESCRIPTION = cdm_description

Ledger (msdyn_ledgers)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
LEGALENTITYID > msdyn_company.cdm_companycode
DESCRIPTION > msdyn_description
ACCOUNTINGCURRENCY > msdyn_accountingcurrency.isocurrencycode
ISBUDGETCONTROLENABLED >>
no : False
yes : True		 msdyn_isbudgetcontrolenabled
NAME > msdyn_name
REPORTINGCURRENCY > msdyn_reportingcurrency.isocurrencycode
BUDGETEXCHANGERATETYPE > msdyn_budgetexchangeratetype.msdyn_name
CHARTOFACCOUNTS > msdyn_chartofaccounts.msdyn_name
EXCHANGERATETYPE > msdyn_exchangeratetype.msdyn_name
FISCALCALENDAR > msdyn_fiscalcalendar.msdyn_calendar
REPORTINGCURRENCYEXCHANGERATETYPE > msdyn_reportingcurrencyexchangeratetype.msdyn_name

Juridiset yksiköt (cdm_companies)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
NAME > cdm_name
LEGALENTITYID > cdm_companycode

Juridiset yksiköt (msdyn_internalorganizations)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
NAMEALIAS > msdyn_namealias
LANGUAGEID > msdyn_languageid
NAME > msdyn_name
PARTYNUMBER > msdyn_partynumber
none >> msdyn_type 806380000
LEGALENTITYID > msdyn_companycode

Uskollisuuskortti (msdyn_loyaltycards)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
CARDNUMBER = msdyn_cardnumber
CARDTENDERTYPE ><
asCardTender : 806380000
asContactTender : 806380001
noTender : 806380002
blocked : 806380003		 msdyn_cardtendertype
PARTYNUMBER = msdyn_partynumber
REPLACEMENTCARDNUMBER > msdyn_replacementcardnumber
OMOPERATINGUNITNUMBER = msdyn_operatingunitnumber
LOYALTYENROLLMENTDATE = msdyn_enrollmentdate
LOYALTYENROLLMENTDATELOCAL = msdyn_effectivedate

Uskollisuustasot (msdyn_loyaltylevels)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
LEVELPHRASE = msdyn_levelphrase
LEVELDESCRIPTION = msdyn_description

Uskollisuuspalkintopisteet (msdyn_loyaltyrewardpoints)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
EXPIRATIONTIMEUNIT ><
day : 806380000
month : 806380001
year : 806380002		 msdyn_expirationtimeunit
EXPIRATIONTIMEVALUE = msdyn_expirationtimevalue
REDEEMABLE ><
yes : True
no : False		 msdyn_redeemable
REDEEMRANKING = msdyn_redeemranking
REWARDPOINTCURRENCY = msdyn_rewardpointcurrency.isocurrencycode
REWARDPOINTID = msdyn_rewardpointid
REWARDPOINTTYPE ><
quantity : 192350000
amount : 192350001		 msdyn_rewardpointtype
MAXIMUMLOYALTYREWARDPOINTS = msdyn_maximumloyaltyrewardpoints
VESTINGTIMEUNIT ><
day : 806380000
month : 806380001
year : 806380002		 msdyn_vestingtimeunit
VESTINGTIMEVALUE = msdyn_vestingtimevalue

Päätili (msdyn_mainaccounts)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Päätililuokat (msdyn_mainaccountcategories)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
MAINACCOUNTCATEGORY = msdyn_mainaccountcategory
REFERENCEID = msdyn_referenceid
DESCRIPTION = msdyn_description
DISPLAYORDER = msdyn_displayorder
CLOSED ><
no : False
yes : True		 msdyn_closed
MAINACCOUNTTYPE ><
blank : 192350000
profitAndLoss : 192350001
revenue : 192350002
expense : 192350003
balanceSheet : 192350004
asset : 192350005
liability : 192350006
equity : 192350007		 msdyn_mainaccounttypevalue

Tehostetun todellisuuden oppaan entiteetti (msmrw_guides)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
INTEGRATIONKEY < msmrw_integrationkey
NAME < msmrw_name
SCHEMAVERSION < msmrw_schemaversion
GUIDEID < msmrw_guideid
CREATEDON < createdon
LASTMODIFIEDON < modifiedon

Toimitustavat (msdyn_shipvias)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
MODECODE = msdyn_name
MODEDESCRIPTION = msdyn_description

Nimiliitteet (msdyn_nameaffixes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
AFFIX = msdyn_affix
TYPE ><
personalSuffix : 806380001
personalPrefix : 806380000		 msdyn_affixtype
DESCRIPTION = msdyn_description

Käyttöyksikkö (msdyn_internalorganizations)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
LANGUAGEID > msdyn_languageid
NAMEALIAS > msdyn_namealias
NAME > msdyn_name
PARTYNUMBER > msdyn_partynumber
OPERATINGUNITTYPE >>
omDepartment : 806380001
none : 806380002
omCostCenter : 806380003
omValueStream : 806380004
omBusinessUnit : 806380005
omAnyOU : 806380006
retailChannel : 192350000		 msdyn_type

Organisaatiohierarkia – julkaistu (msdyn_internalorganizationhierarchies)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
VALIDTO > msdyn_validto
VALIDFROM > msdyn_validfrom
HIERARCHYTYPE > msdyn_hierarchytypename
PARENTORGANIZATIONPARTYNUMBER > msdyn_parentpartyid
CHILDORGANIZATIONPARTYNUMBER > msdyn_childpartyid
HIERARCHYTYPE > msdyn_hierarchytypeid.msdyn_name
CHILDORGANIZATIONPARTYNUMBER > msdyn_childid.msdyn_partynumber
PARENTORGANIZATIONPARTYNUMBER > msdyn_parentid.msdyn_partynumber

Organisaatiohierarkian tarkoitukset (msdyn_internalorganizationhierarchypurposes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Organisaation hierarkiatyyppi (msdyn_internalorganizationhierarchytypes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
NAME > msdyn_name

Osapuolen yhteystiedot V3 (msdyn_partyelectronicaddresses)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
COUNTRYREGIONCODE = msdyn_internationalcallingcode
DESCRIPTION = msdyn_description
ELECTRONICADDRESSID = msdyn_electronicaddressnumber
PARTYNUMBER = msdyn_partyid.msdyn_partynumber
LOCATOR = msdyn_locator
LOCATOREXTENSION = msdyn_locatorextension
ISINSTANTMESSAGE ><
no : False
yes : True		 msdyn_isinstantmessage
ISMOBILEPHONE ><
no : False
yes : True		 msdyn_ismobile
ISPRIMARY ><
no : False
yes : True		 msdyn_isprimary
ISPRIVATE ><
no : False
yes : True		 msdyn_isprivate
PURPOSE = msdyn_purpose
TYPE ><
phone : 192350001
email : 192350002
url : 192350003
telex : 192350004
fax : 192350005
facebook : 192350006
twitter : 192350007
linkedin : 192350008		 msdyn_type

Maksupäivärivit CDS V2 (msdyn_paymentdaylines)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
NAME = msdyn_paymentday.msdyn_name
LINENUMBER = msdyn_linenumber
FREQUENCY ><
week : 806380000
month : 806380001		 msdyn_frequency
DAYOFWEEK ><
none : 806380000
monday : 806380001
tuesday : 806380002
wednesday : 806380003
thursday : 806380004
friday : 806380005
saturday : 806380006
sunday : 806380007		 msdyn_dayofweek
DAYOFMONTH = msdyn_dayofmonth

Maksupäivien CDS (msdyn_paymentdays)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
NAME = msdyn_name
DESCRIPTION = msdyn_description

Maksuaikataulu (msdyn_paymentschedules)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
NAME = msdyn_name
DESCRIPTION = msdyn_description
ALLOCATIONMETHOD ><
total : 806380000
amountByPayment : 806380001
numOfPayment : 806380002
specified : 806380003		 msdyn_allocationmethod
PAYMENTFREQUENCYUNITS ><
day : 806380000
month : 806380001
year : 806380002		 msdyn_paymentfrequencyunit
PAYMENTFREQUENCY = msdyn_paymentfrequency
NUMBEROFPAYMENTS = msdyn_numberofpayments
FIXEDPAYMENTAMOUNT = msdyn_fixedpaymentamount
MINIMUMPAYMENTAMOUNT = msdyn_minimumpaymentamount
SALESTAXALLOCATIONMETHOD ><
proportional : 806380000
firstRate : 806380001
lastRate : 806380002		 msdyn_salestaxallocationmethod
NOTES = msdyn_note

Maksuaikataulun rivit (msdyn_paymentschedulelines)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
PAYMENTSCHEDULENAME = msdyn_paymentschedule.msdyn_name
LINENUMBER = msdyn_linenumber
PERIODSAFTERDUEDATE = msdyn_periodsafterduedate
PERCENTORAMOUNT ><
percent : 806380000
amount : 806380001		 msdyn_percentoramount
PERCENTORAMOUNTVALUE = msdyn_percentoramountvalue

Henkilökohtaiset merkkityypit (msdyn_personalcharactertypes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
TYPEDESCRIPTION = msdyn_typedescription
TYPENAME = msdyn_typename

Toimityyppi (cdm_positiontypes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
POSITIONTYPEID = cdm_name
DESCRIPTION = cdm_description
CLASSIFICATION ><
fulltime : 754400000
parttime : 754400001
aihio: 754400002		 cdm_classification

Sijoita työntekijätehtävät (cdm_positionworkerassignmentmaps)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
PERSONNELNUMBER = cdm_workerid.cdm_workernumber
POSITIONID = cdm_jobpositionid.cdm_jobpositionnumber
VALIDFROM = cdm_validfrom
VALIDTO = cdm_validto

Sijainnit V2 (cdm_jobpositions)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
POSITIONID = cdm_jobpositionnumber
DESCRIPTION = cdm_description
ACTIVATION = cdm_activation
AVAILABLEFORASSIGNMENT = cdm_availableforassignment
FULLTIMEEQUIVALENT = cdm_fulltimeequivalent
DETAILEFFECTIVE = cdm_validfrom
DETAILEXPIRATION = cdm_validto
RETIREMENT = cdm_retirement
POSITIONTYPEID = cdm_positiontypeid.cdm_name
JOBID = cdm_jobid.cdm_name

Hintaasiakasryhmät (msdyn_pricecustomergroups)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
GROUPCODE = msdyn_groupcode
GROUPNAME = msdyn_groupname

Tuotenumero tunnistettu viivakoodi (msdyn_productbarcodes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
PRODUCTNUMBER > msdyn_productnumberid.msdyn_productnumber
BARCODE > msdyn_name
BARCODE > msdyn_barcode
PRODUCTQUANTITY > msdyn_productquantity
PRODUCTDESCRIPTION > msdyn_productdescription
BARCODESETUPID > msdyn_barcodesetupid
PRODUCTQUANTITYUNITSYMBOL > msdyn_unitofmeasureid.msdyn_symbol
ISDEFAULTSCANNEDBARCODE >>
no : False
yes : True		 msdyn_isdefaultscannedbarcode
ISDEFAULTPRINTEDBARCODE >>
no : False
yes : True		 msdyn_isdefaultprintedbarcode
ISDEFAULTDISPLAYEDBARCODE >>
no : False
yes : True		 msdyn_isdefaultdisplayedbarcode

Tuoteluokat (msdyn_productcategories)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
PRODUCTCATEGORYHIERARCHYNAME = msdyn_hierarchy.msdyn_name
ISCATEGORYINHERITINGPARENTPRODUCTATTRIBUTES ><
no : False
yes : True		 msdyn_isinheritingparentproductattributes
PROJECTCATEGORYNAME = msdyn_projectcategoryname
ISTANGIBLEPRODUCT ><
no : False
yes : True		 msdyn_istangibleproduct
ISCATEGORYINHERITINGPARENTCATEGORYATTRIBUTES ><
no : False
yes : True		 msdyn_isinheritingparentcategoryattributes
CATEGORYCODE = msdyn_code
CATEGORYDESCRIPTION = msdyn_description
CATEGORYKEYWORDS = msdyn_keywords
CATEGORYNAME = msdyn_name
FRIENDLYCATEGORYNAME = msdyn_friendlycategoryname
PARENTPRODUCTCATEGORYNAME = msdyn_parentproductcategory.msdyn_name
PARENTPRODUCTCATEGORYHIERARCHYNAME > msdyn_parentproductcategory.msdyn_hierarchy.msdyn_name
CATEGORYRECORDID > msdyn_externalproductcategoryid
EXTERNALID = msdyn_integrationid

Tuoteluokan määritykset (msdyn_productcategoryassignments)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
PRODUCTNUMBER = msdyn_globalproduct.msdyn_productnumber
PRODUCTCATEGORYNAME = msdyn_productcategory.msdyn_name
PRODUCTCATEGORYHIERARCHYNAME = msdyn_productcategory.msdyn_hierarchy.msdyn_name
PRODUCTNUMBER > msdyn_name

Tuoteluokkahierarkiat (msdyn_productcategoryhierarchies)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
HIERARCHYNAME = msdyn_name
HIERARCHYDESCRIPTION = msdyn_description

Tuoteluokan hierarkiaroolit (msdyn_productcategoryhierarchyroles)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
PRODUCTCATEGORYHIERARCHYNAME = msdyn_hierarchy.msdyn_name
HIERARCHYROLE ><
procurement : 192350000
sales : 192350001
retail : 192350002
commodity : 192350003
financials : 192350004
retailSpecialGroup : 192350005
retailVendorProductHierarchy : 192350006
retailChannelNavigation : 192350007
packingMaterials_W : 192350008
commonDataService : 192350009
costManagement : 192350010
engineeringProduct : 192350011		 msdyn_hierarchyrole

Tuotteen oletustilausasetukset V2 (msdyn_productspecificdefaultordersettings)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Tuotteen dimensioryhmät (msdyn_productdimensiongroups)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
WILLSALESPRICESEARCHUSEPRODUCTSTYLE ><
no : false
yes : true		 msdyn_willsalespricesearchuseproductstyle
WILLPURCHASEPRICESEARCHUSEPRODUCTSIZE ><
no : false
yes : true		 msdyn_willpurchasepricesearchuseproductsize
WILLSALESPRICESEARCHUSEPRODUCTCONFIGURATION ><
no : false
yes : true		 msdyn_willsalespricesearchuseprodconfig
WILLSALESPRICESEARCHUSEPRODUCTCOLOR ><
no : false
yes : true		 msdyn_willsalespricesearchuseproductcolor
WILLPURCHASEPRICESEARCHUSEPRODUCTSTYLE ><
no : false
yes : true		 msdyn_willpurchasepricesearchuseproductstyle
WILLPURCHASEPRICESEARCHUSEPRODUCTCONFIGURATION ><
no : false
yes : true		 msdyn_willpurchpricesearchuseprodconfig
WILLPURCHASEPRICESEARCHUSEPRODUCTCOLOR ><
no : false
yes : true		 msdyn_willpurchpricesearchuseproductcolor
ISPRODUCTSTYLEACTIVE ><
no : false
yes : true		 msdyn_isproductstyleactive
ISPRODUCTSIZEACTIVE ><
no : false
yes : true		 msdyn_isproductsizeactive
ISPRODUCTCONFIGURATIONACTIVE ><
no : false
yes : true		 msdyn_isproductconfigurationactive
ISPRODUCTCOLORACTIVE ><
no : false
yes : true		 msdyn_isproductcoloractive
GROUPNAME = msdyn_groupname
GROUPDESCRIPTION = msdyn_groupdescription
PRODUCTVARIANTNOMENCLATURENAME = msdyn_productvariantnomenclaturename
WILLSALESPRICESEARCHUSEPRODUCTSIZE ><
yes : true
no : false		 msdyn_willsalespricesearchuseproductsize

Tuotteen päävärit (msdyn_sharedproductcolors)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
PRODUCTCOLORID > msdyn_productcolor.msdyn_productcolorname
PRODUCTMASTERNUMBER > msdyn_globalproduct.msdyn_productnumber
REPLENISHMENTWEIGHT > msdyn_replenishmentweight
DISPLAYSEQUENCENUMBER > msdyn_displaysequencenumber

Tuotteen päämääritykset (msdyn_sharedproductconfigurations)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
CONTAINERUNITSYMBOL > msdyn_containerunit.msdyn_symbol
PRODUCTCONFIGURATIONID > msdyn_productconfiguration.msdyn_productconfiguration
PRODUCTMASTERNUMBER > msdyn_globalproduct.msdyn_productnumber
REPLENISHMENTWEIGHT > msdyn_replenishmentweight
DISPLAYSEQUENCENUMBER > msdyn_displaysequencenumber

Tuotteen pääkoot (msdyn_sharedproductsizes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
PRODUCTMASTERNUMBER > msdyn_globalproduct.msdyn_productnumber
PRODUCTSIZEID > msdyn_productsize.msdyn_productsize
REPLENISHMENTWEIGHT > msdyn_replenishmentweight
DISPLAYSEQUENCENUMBER > msdyn_displaysequencenumber

Tuotteiden päätyylit (msdyn_sharedproductstyles)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
PRODUCTMASTERNUMBER > msdyn_globalproduct.msdyn_productnumber
PRODUCTSTYLEID > msdyn_productstyle.msdyn_productstyle
REPLENISHMENTWEIGHT > msdyn_replenishmentweight
DISPLAYSEQUENCENUMBER > msdyn_displaysequencenumber

Tuotekuittauksen otsikko (msdyn_purchaseorderreceipts)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Tuotteen vastaanottorivi (msdyn_purchaseorderreceiptproducts)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Tuotekohtaiset yksikkömuunnokset (msdyn_productspecificunitofmeasureconversions)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DENOMINATOR = msdyn_denominator
NUMERATOR = msdyn_numerator
FACTOR = msdyn_factor
FROMUNITSYMBOL = msdyn_fromunit.msdyn_symbol
TOUNITSYMBOL = msdyn_tounit.msdyn_symbol
PRODUCTNUMBER = msdyn_globalproduct.msdyn_productnumber
INNEROFFSET = msdyn_inneroffset
OUTEROFFSET = msdyn_outeroffset
ROUNDING ><
nearest : 192350000
up : 192350001
down : 192350002		 msdyn_rounding

Prospects (leads)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Lähdesuodatin: (IsB2BProspect == 1)

Käänteinen lähdesuodatin: (msdyn_b2bcommerceprospect eq true)

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

Ostotilauksen otsikkoasiakirjan liitteet (huomautukset)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Lähdesuodatin: ((DocumentAttachmentTypeCode == "Huomautus") || (DocumentAttachmentTypeCode == "URL"))

Käänteinen lähdesuodatin: objecttypecode eq 'msdyn_purchaseorder'

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DOCUMENTID = msdyn_notesid
NOTES = notetext
ATTACHMENTDESCRIPTION = subject
PURCHASEORDERNUMBER = msdyn_relatedentityid
DOCUMENTATTACHMENTTYPECODE << none Note
none >> objecttypecode msdyn_purchaseorder
ACCESSRESTRICTION ><
internal : 0
external : 1		 msdyn_restriction

Tilausotsikoiden V2 (msdyn_purchaseorders)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DELIVERYADDRESSNAME > msdyn_addressname
REQUESTEDDELIVERYDATE = msdyn_dateexpected
PURCHASEORDERNUMBER = msdyn_name
PAYMENTTERMSNAME = msdyn_paymentterm.msdyn_name
DEFAULTRECEIVINGWAREHOUSEID = msdyn_receivetowarehouse.msdyn_warehouseidentifier
ACCOUNTINGDATE = msdyn_accountingdate
AREPRICESINCLUDINGSALESTAX ><
yes : True
no : False		 msdyn_arepriceincludingsalestax
ATTENTIONINFORMATION > msdyn_attentioninformation
CASHDISCOUNTCODE = msdyn_cashdiscountcode
CASHDISCOUNTPERCENTAGE = msdyn_cashdiscountpercentage
CONTACTPERSONID = msdyn_contactpersonid.msdyn_contactpersonid
CURRENCYCODE = transactioncurrencyid.isocurrencycode
DEFAULTRECEIVINGSITEID = msdyn_defaultreceivingsiteid.msdyn_siteid
DELIVERYTERMSID = msdyn_deliveryterm.msdyn_termscode
EMAIL = msdyn_email
ISCHANGEMANAGEMENTACTIVE >>
yes : True
no : False		 msdyn_ischangemanagementactive
ISDELIVEREDDIRECTLY >>
yes : True
no : False		 msdyn_isdeliverydirectly
LANGUAGEID ><
ar : 192350000
ar-ae : 192350001
cs : 192350002
da : 192350003
de : 192350004
de-at : 192350005
de-ch : 192350006
en-au : 192350007
en-gb : 192350009
en-ie : 192350010
en-in : 192350011
en-ca : 192350008
en-my : 192350012
en-nz : 192350013
en-sg : 192350014
en-us : 192350015
en-za : 192350016
es : 192350017
es-mx : 192350018
et : 192350019
fi : 192350020
fr : 192350021
fr-be : 192350022
fr-ca : 192350023
fr-ch : 192350024
hu : 192350025
is : 192350026
it : 192350027
it-ch : 192350028
ja : 192350029
lt : 192350030
lv : 192350031
nb-no : 192350032
nl : 192350033
nl-be : 192350034
pl : 192350035
pt-br : 192350036
ru : 192350037
sv : 192350038
th : 192350039
tr : 192350040
zh-hans : 192350041		 msdyn_language
ORDERERPERSONNELNUMBER = msdyn_ordererpersonnelnumber.cdm_workernumber
REASONCODE = msdyn_reasoncode
REASONCOMMENT = msdyn_reasoncomment
TOTALDISCOUNTPERCENTAGE = msdyn_totaldiscountpercentage
osoite = 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

Julkaistut tuotteet V2 (msdyn_sharedproductdetails)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Myyntilaskun otsikot V2 (invoices)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Lähdesuodatin: (SalesOrderNumber != "")

Käänteinen lähdesuodatin: msdyn_ordertype eq 192350000

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

Myyntilaskurivit V2 (invoicedetails)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
CONFIRMEDSHIPPINGDATE > msdyn_confirmedshippingdate
CURRENCYCODE > transactioncurrencyid.isocurrencycode
INVENTORYSITEID > msdyn_inventorysite.msdyn_siteid
INVENTORYWAREHOUSEID > msdyn_inventorywarehouse.msdyn_warehouseidentifier
INVOICEDATE > invoiceid.msdyn_invoicedate
INVOICEDQUANTITY > quantity
INVOICENUMBER > invoiceid.msdyn_invoicenumber
LEDGERVOUCHER > invoiceid.msdyn_ledgervoucher
LINEAMOUNT > extendedamount
LINECREATIONSEQUENCENUMBER > sequencenumber
LINETOTALCHARGEAMOUNT > msdyn_totalchargeamount
LINETOTALDISCOUNTAMOUNT > manualdiscountamount
LINETOTALTAXAMOUNT > vero
PRODUCTNAME > description
PRODUCTNUMBER > productid.msdyn_productnumber
SALESPRICE > priceperunit
SALESPRODUCTCATEGORYHIERARCHYNAME > msdyn_salesproductcategory.msdyn_hierarchy.msdyn_name
SALESPRODUCTCATEGORYNAME > msdyn_salesproductcategory.msdyn_name
SALESUNITSYMBOL > uomid.msdyn_symbol
none >> producttypecode 1
none >> propertyconfigurationstatus 2
none >> ispriceoverridden True

Myyntitilauksen otsikkoasiakirjan liitteet (huomautukset)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Lähdesuodatin: ((DocumentAttachmentTypeCode == "Huomautus") || (DocumentAttachmentTypeCode == "URL"))

Käänteinen lähdesuodatin: objecttypecode eq 'salesorder'

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DOCUMENTID = msdyn_notesid
NOTES = notetext
ATTACHMENTDESCRIPTION = subject
SALESORDERNUMBER = msdyn_relatedentityid
DOCUMENTATTACHMENTTYPECODE << none Note
none >> objecttypecode salesorder
ACCESSRESTRICTION ><
internal : 0
external : 1		 msdyn_restriction

Myyntitilauksen alkuperäkoodit (msdyn_salesorderorigins)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
ORIGINCODE = msdyn_origincode
ORIGINDESCRIPTION = msdyn_origindescription

Arvonlisäveroviranomaiset (msdyn_taxauthorities)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
TAXAUTHORITYCODE = msdyn_taxauthoritycode
TAXAUTHORITYIDENTIFICATION = msdyn_taxauthorityidentificator
DESCRIPTION = msdyn_description
REPORTLAYOUT ><
default : 192350000
norway : 192350001
unitedKingdom : 192350002
sweden : 192350003
germany : 192350004
austria : 192350005
netherlands : 192350006
usa : 192350007
italy : 192350008
belgium : 192350009
singapore : 192350010
japan : 192350011
finland : 192350012
estonia : 192350013
uae : 192350014		 msdyn_taxreportlayout
ROUNDOFFTYPE ><
ordinary : 192350000
roundDown : 192350001
roundUp : 192350002
advantage : 192350003		 msdyn_roundofftype
ROUNDOFF = msdyn_roundoff
EMAIL = msdyn_email
PHONE = msdyn_phone
osoite = msdyn_url

Arvonlisäverosta vapautettu koodientiteetti CDS (msdyn_taxexemptcodes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
NAME = msdyn_name
DESCRIPTION = msdyn_description

Arvonlisäveroryhmät (msdyn_taxgroups)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
TAXGROUPCODE = msdyn_name
DESCRIPTION = msdyn_description

Arvonlisäveron kirjanpitokirjausten kirjausryhmät V2 (msdyn_taxpostinggroups)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
TAXPOSTINGGROUPCODE = msdyn_name
DESCRIPTION = msdyn_description

Salutations (msdyn_salutations)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
SALUTATIONPHRASE = msdyn_salutationphrase

Sites (msdyn_operationalsites)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Sizes (msdyn_productsizes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
SIZEID > msdyn_productsize

Tallennustilan dimensioryhmät (msdyn_productstoragedimensiongroups)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
WILLSALESPRICESEARCHUSEWAREHOUSE ><
no : false
yes : true		 msdyn_willsalespricesearchusewarehouse
WILLSALESPRICESEARCHUSESITE ><
no : false
yes : true		 msdyn_willsalespricesearchusesite
WILLSALESPRICESEARCHUSEINVENTORYSTATUS ><
no : false
yes : true		 msdyn_willsalespricesearchuseinventorystatus
WILLPURCHASEPRICESEARCHUSEWAREHOUSE ><
no : false
yes : true		 msdyn_willpurchasepricesearchusewarehouse
WILLPURCHASEPRICESEARCHUSESITE ><
no : false
yes : true		 msdyn_willpurchasepricesearchusesite
WILLPURCHASEPRICESEARCHUSEINVENTORYSTATUS ><
no : false
yes : true		 msdyn_willpurchpricesearchuseinventstatus
WILLCOVERAGEPLANNINGUSEWAREHOUSE ><
no : false
yes : true		 msdyn_willcoverageplanusewarehouse
WILLCOVERAGEPLANNINGUSELOCATION ><
no : false
yes : true		 msdyn_iscoverageplanenabledforlocation
WILLCOVERAGEPLANNINGUSEINVENTORYSTATUS ><
no : false
yes : true		 msdyn_willcoverageplanuseinventorystatus
AREADVANCEDWAREHOUSEMANAGEMENTPROCESSESENABLED ><
no : false
yes : true		 msdyn_areadvancedwmprocessesenabled
ISWAREHOUSEPRIMARYSTORAGEDIMENSION ><
no : false
yes : true		 msdyn_iswarehouseprimarystoragedimension
ISWAREHOUSEMANDATORY ><
no : false
yes : true		 msdyn_iswarehousemandatory
ISPHYSICALINVENTORYENABLEDFORWAREHOUSE ><
no : false
yes : true		 msdyn_isphysicalinventoryenabledforwarehouse
ISPHYSICALINVENTORYENABLEDFORLOCATION ><
no : false
yes : true		 msdyn_isphysicalinventoryenabledforlocation
ISLOCATIONACTIVE ><
no : false
yes : true		 msdyn_islocationactive
ISFINANCIALINVENTORYENABLEDFORWAREHOUSE ><
no : false
yes : true		 msdyn_isfinancialinventoryenabledforwarehouse
GROUPNAME = msdyn_groupname
GROUPDESCRIPTION = msdyn_groupdescription
ISBLANKRECEIPTALLOWEDFORLOCATION ><
no : false
yes : true		 msdyn_isblankreceiptallowedforlocation
ISBLANKISSUEALLOWEDFORLOCATION ><
no : false
yes : true		 msdyn_isblankissueallowedforlocation

Styles (msdyn_productstyles)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
STYLEID > msdyn_productstyle

Toimitusehdot (msdyn_termsofdeliveries)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Maksuehdot (msdyn_paymentterms)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Dimensioryhmien seuranta (msdyn_producttrackingdimensiongroups)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Yksikkömuunnokset (msdyn_unitofmeasureconversions)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DENOMINATOR = msdyn_denominator
NUMERATOR = msdyn_numerator
FACTOR = msdyn_factor
INNEROFFSET = msdyn_inneroffset
OUTEROFFSET = msdyn_outeroffset
ROUNDING ><
nearest : 192350000
up : 192350001
down : 192350002		 msdyn_rounding
TOUNITSYMBOL = msdyn_tounit.msdyn_symbol
FROMUNITSYMBOL = msdyn_fromunit.msdyn_symbol

Units (uoms)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
UNITSYMBOL > msdyn_symbol
UNITCLASS > msdyn_externalunitclassname
DECIMALPRECISION > msdyn_decimalprecision
ISBASEUNIT >>
no : false
yes : true		 msdyn_isbaseunit
ISSYSTEMUNIT >>
no : false
yes : true		 msdyn_issystemunit
SYSTEMOFUNITS >>
none : 192350000
metric : 192350001
us : 192350002		 msdyn_systemofunits
UNITSYMBOL > name
UNITDESCRIPTION > msdyn_description

Toimittaja-asiakirjan liitteet (huomautukset)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Lähdesuodatin: ((DocumentAttachmentTypeCode == "Huomautus") || (DocumentAttachmentTypeCode == "URL"))

Käänteinen lähdesuodatin: (objecttypecode eq 'msdyn_vendor' ja msdyn_relatedentityid2 ne null) tai (objecttypecode eq 'account' and msdyn_relatedentityid2 ne null) tai (objecttypecode eq 'contact' and msdyn_relatedentityid2 ne null)

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DOCUMENTID = msdyn_notesid
NOTES = notetext
ATTACHMENTDESCRIPTION = subject
VENDORACCOUNTNUMBER = msdyn_relatedentityid2
DOCUMENTATTACHMENTTYPECODE << none Note
none >> objecttypecode msdyn_vendor
ACCESSRESTRICTION ><
internal : 0
external : 1		 msdyn_restriction

Toimittajaryhmät (msdyn_vendorgroups)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
DEFAULTPAYMENTTERMNAME = msdyn_paymentterms.msdyn_name
DESCRIPTION = msdyn_description
VENDORGROUPID = msdyn_vendorgroup
CLEARINGPERIODPAYMENTTERMNAME = msdyn_clearingperiodpaymentpermname.msdyn_name

Toimittajan maksutapa (msdyn_vendorpaymentmethods)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Toimittajat V2 (msdyn_vendors)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Lähdesuodatin: ((VendorPartyType == "Organisaatio") || (VendorPartyType == "Person"))

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

Veteraanin tila (cdm_veteranstatuses)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
VETERANSTATUSID = cdm_name
DESCRIPTION = cdm_description
ISPROTECTEDVETERAN ><
no : false
yes : true		 cdm_isprotectedveteran

Varastosijainnit (msdyn_inventorylocations)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Varaston työotsikot (msdyn_warehouseworkheaders)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Varaston työrivit (msdyn_warehouseworklines)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Varastovyöhykeryhmät (msdyn_warehousezonegroups)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
GROUPID = msdyn_groupid
GROUPNAME = msdyn_groupname

Varastovyöhykkeet (msdyn_warehousezones)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
WAREHOUSEZONEGROUPID = msdyn_warehousezonegroup.msdyn_groupid
ZONEID = msdyn_zoneid
ZONENAME = msdyn_zonename

Warehouses (msdyn_warehouses)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

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

Veronpidätyskoodit (msdyn_withholdingtaxcodes)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
WITHHOLDINGCODE = msdyn_name
WITHHOLDINGTAXNAME = msdyn_description
WITHHOLDINGTAXROUNDOFF = msdyn_roundoff
WITHHOLDINGTAXROUNDOFFTYPE ><
ordinary : 192350000
roundDown : 192350001
roundUp : 192350002		 msdyn_roundofftype
CURRENCYCODEID = msdyn_currency.isocurrencycode
WITHHOLDINGTAXBASE ><
pctPerNet : 192350000
pctPerGross : 192350001		 msdyn_taxableamountorigin

Veroryhmien pidättäminen (msdyn_withholdingtaxgroups)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
WITHHOLDINGTAXGROUPCODE = msdyn_name
DESCRIPTION = msdyn_description

Worker (cdm_workers)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
PERSONNELNUMBER = cdm_workernumber
FIRSTNAME = cdm_firstname
MIDDLENAME = cdm_middlename
LASTNAME = cdm_lastname
WORKERTYPE >>
employee : 754400000
contractor : 754400001
both : 754400000		 cdm_type
WORKERSTATUS >>
employed : 754400000
pending : 754400001
terminated : 754400001		 cdm_status
PRIMARYCONTACTEMAIL = cdm_primaryemailaddress
PRIMARYCONTACTPHONE = cdm_primarytelephone
PRIMARYCONTACTFACEBOOK = cdm_facebookidentity
PRIMARYCONTACTTWITTER = cdm_twitteridentity
PRIMARYCONTACTLINKEDIN = cdm_linkedinidentity
PRIMARYCONTACTURL = cdm_websiteurl
GENDER ><
male : 754400000
female : 754400001
nonSpecific : 754400003
none : 754400002		 cdm_gender
BIRTHDATE = cdm_birthdate
NAME > cdm_fullname

CDS:n sijaintiroolit (msdyn_addressroles)

Tämä malli synkronoi tiedot talous- ja toimintosovellusten sekä Dataversen välillä.

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
ISCONTACTINFORMATION ><
yes : true
no : false		 msdyn_iselectronicaddressrole
ISPOSTALADDRESS ><
yes : true
no : false		 msdyn_ispostaladdressrole
PURPOSE = msdyn_name

Siirtotilauksen otsikot

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

Siirtotilauksen tuotteet

Rahoitus ja toiminnot -kenttä Map type Customer Engagement -sarake Default value
ITEMNUMBER = msdyn_product.msdyn_productnumber
LINENUMBER = msdyn_lineorder
ALLOWEDOVERDELIVERYPERCENTAGE = msdyn_allowedoverdeliverypercentage
RECEIVEDCATCHWEIGHTQUANTITY > msdyn_catchweightquantityreceived
SCRAPPEDCATCHWEIGHTQUANTITY > msdyn_catchweightquantityscrapped
SHIPPEDCATCHWEIGHTQUANTITY > msdyn_catchweightquantityshipped
TRANSFERCATCHWEIGHTQUANTITY = msdyn_catchweightquantity
RECEIVEDQUANTITY > msdyn_quantityreceived
SCRAPPEDQUANTITY > msdyn_quantityscrapped
SHIPPEDQUANTITY > msdyn_quantityshipped
TRANSFERQUANTITY > msdyn_quantity
REQUESTEDRECEIPTDATE = msdyn_receivedate
LINESTATUS >> msdyn_linestatus
REQUESTEDSHIPPINGDATE = msdyn_shipdate
TRANSFERORDERNUMBER = msdyn_transferorder.msdyn_name
ALLOWEDUNDERDELIVERYPERCENTAGE = msdyn_allowedunderdeliverypercentage
INVENTORYUNITSYMBOL > msdyn_unit
SHIPPINGWAREHOUSEID = msdyn_shippingwarehouse
SHIPPINGSITEID = msdyn_shippingsite
SHIPPINGWAREHOUSELOCATIONID = msdyn_shippinglocation
  • Last updated on