Skilgreina samþættingu við Dataverse töflur
Til að samþætta Microsoft Dynamics 365 Human Resources við Dataverse geturðu notað Data Integrator. Mannauður-til-sniðmátDataverse gerir gögnum fyrir störf, stöður, starfsmenn og aðra kleift að flæða frá mannauði inn Dataverse í og frá Dataverse inn í mannauð, þannig að skrif eru skrifuð í báðum kerfum.
Kerfiskröfur vegna Human Resources
Samþættingarlausnin krefst eftirfarandi útgáfu af mannauði og Dynamics 365 Finance:
- Dynamics 365 Finance, útgáfa 7.2 og nýrri
- Dynamics CRM umhverfi þar sem gagnagrunnur hefur verið búinn til og Dynamics 365-forrit eru leyfð
Sniðmát og verkefni
Fylgið þessum skrefum til að fá aðgang að sniðmátinu Mannauður–til-Fjármál.
- Opnaðu Power Apps admin center.
- Undir umhverfinu þínu skaltu velja Dynamics 365 Apps og veljasíðan Uppruni forrits á tækjastikunni.
- Til setja í embætti the sniðmát, leita að “Dual- skrifa Mannauður†eða fara beint til the hópur stuðningsmanna heimilisfang: https://appsource.microsoft.com/product/dynamics-365/mscrm.hcm_dualwrite.
- Eftir að uppsetningu er lokið skaltu opna Dynamics 365 Finance.
- Opnið vinnusvæðið Gagnastjórnun .
- Veldu Dual Write.
- Fylgið ferlinu til að tengja umhverfið fyrir að minnsta kosti eitt fyrirtæki í fyrirtækinu.
- Þegar þú hefur lokið við að setja upp tengil í umhverfið þitt Dataverse skaltu velja Nota lausn. Lausninni er beitt og kortlagningin er sett upp í samþættingarforritið.
Nóta
Það eru þrír lausnarpakkar sem þarf fyrir Dual-skrifa Human Resources. Frekari upplýsingar er að finna í Aðskilinn tvískriftarpakki forrita.
Varpanir sniðmáta
Í eftirfarandi sniðmátsvörpunartöflum gefur heiti verkefnisins til kynna einingarnar sem eru notaðar í hverju forriti. Fjármálaeftirlitið er til vinstri og Dataverse til hægri.
Útgreiðslur bankareiknings (Dual-write) til Útgreiðsla bankareiknings
Fjármálafyrirtæki | Dataverse tafla |
---|---|
ACCOUNTIDENTIFICATIONID | cdm_bankaccountid.cdm_accountidentification |
UPPHÆÐ | cdm_amount |
FORGANGUR | cdm_disbursementpriority |
PERSONNELNUMBER | cdm_bankaccountid.cdm_workerid.cdm_workernumber |
AFGANGUR | cdm_isremainder |
Sundurliðun útreikningshlutfalls fríðinda (tvískrift) til Upplýsingar um útreikningshlutfall fríðinda
Fjármálafyrirtæki | Dataverse tafla |
---|---|
FRAMLAG | cdm_contributionmethod |
SKILVIRKUR | cdm_effective |
FRAMLAG VINNUVEITANDA | cdm_employercontribution |
ENDIR | cdm_expiration |
FRÁDRÁTTUR STARFSMANNS | cdm_workerdeduction |
HEITI | cdm_calculationrateid.cdm_name |
Haus útreikningshlutfalls fríðinda í útreikningshlutfall fríðinda
Fjármálafyrirtæki | Dataverse tafla |
---|---|
LÝSING | cdm_description |
HEITI | cdm_name |
TIERTYPE | cdm_tiertype |
Ávinningur valkostur til hagsbóta valkostur
Fjármálafyrirtæki | Dataverse tafla |
---|---|
TILNEFNINGAR STYRKÞEGA | cdm_allowbeneficiarydesignations |
ALLOWDEPENDENTCOVERAGE | cdm_allowdependentcoverage |
BENEFITOPTIONID | cdm_name |
LÝSING | cdm_description |
UNDANÞÁGA | cdm_iswaived |
Gerð fríðinda til Gerð fríðinda
Fjármálafyrirtæki | Dataverse tafla |
---|---|
BENEFITTYPEID | cdm_name |
SAMHLIÐA INNSKRÁNING | cdm_concurrentenrollment |
LÝSING | cdm_description |
LAUNAFLOKKUR | cdm_payrollcategory |
Viðskiptadagatal í viðskiptaferlidagatal
Fjármálafyrirtæki | Dataverse tafla |
---|---|
CALENDARID | cdm_name |
HEITI | cdm_calendarname |
STARTDATE | cdm_startdate |
ENDDATE | cdm_enddate |
ISOPENMÁNUDAGUR | cdm_ismondayopen |
ISOPENTUESDAY | cdm_istuesdayopen |
ISOPENMIÐVIKUDAGUR | cdm_iswednesdayopen |
ISOPENFIMMTUDAGUR | cdm_isthursdayopen |
ISOPENFRIDAY | cdm_isfridayopen |
ISOPENLAUGARDAGUR | cdm_issaturdayopen |
ISOPENSUNNUDAGUR | cdm_issundayopen |
Viðskiptaferli í haus viðskiptaferlis
Fjármálafyrirtæki | Dataverse tafla |
---|---|
PROCESSID | cdm_processid |
GERÐ FERLIS | cdm_processtype |
GENERICSUBTYPE | cdm_genericsubtype |
HEITI | cdm_name |
LÝSING | cdm_description |
STAÐA | cdm_status |
DAGSETNING MARKMIÐS | cdm_targetdate |
STARTDATETIME | cdm_startdatetime |
ENDDATETIME | cdm_enddatetime |
RESOLVEDBYPERSONNELNUMBER | cdm_resolvedbyid.cdm_workernumber |
PROCESSOWNERPERSONNELNUMBER | cdm_processownerid.cdm_workernumber |
SOURCETEMPLATENAME | cdm_sourcetemplateid.cdm_name |
SOURCETEMPLATEPROCESSTYPE | cdm_sourcetemplateid.cdm_businessprocesstype |
SOURCETEMPLATEGENERICSUBTYPE | cdm_sourcetemplateid.cdm_genericsubtype |
Verkefnaflokkur viðskiptaferlissafns fyrir verkefnahóp viðskiptaferlissafns
Fjármálafyrirtæki | Dataverse tafla |
---|---|
GERÐ FERLIS | cdm_processtype |
HEITI | cdm_name |
LÝSING | cdm_description |
Stig viðskiptaferlis að stigi viðskiptaferlis
Fjármálafyrirtæki | Dataverse tafla |
---|---|
GERÐ FERLIS | cdm_businessprocesstype |
HEITI | cdm_name |
LÝSING | cdm_description |
RAÐNÚMER | cdm_sequencenumber |
Verk viðskiptaferlis í verk viðskiptaferlis
Fjármálafyrirtæki | Dataverse tafla |
---|---|
LÝSING | cdm_description |
DUEDATE | cdm_duedate |
KENNI VERKS | cdm_taskid |
FYRIRMÆLI | cdm_instructions |
COMPLETIONDATETIME | cdm_completiondatetime |
ASSIGNMENTTYPE | cdm_assignmenttype |
ISVALFRJÁLST | cdm_isoptional |
HEITI | cdm_name |
STAÐA | cdm_status |
RESOLVEDBY_PERSONNELNUMBER | cdm_resolvedbyid.cdm_workernumber |
TEMPLATETASKID | cdm_templatetaskid.cdm_taskid |
ASSIGNEDWORKER_PERSONNELNUMBER | cdm_assignedworkerid.cdm_workernumber |
PROCESSID | cdm_processheaderid.cdm_processid |
ASSIGNEDGROUP_NAME | cdm_assignedgroupid.cdm_name |
ASSIGNEDPOSITION_POSITIONID | cdm_assignedposition.cdm_jobpositionnumber |
Sniðmát viðskiptaferlis í haus gátlistasniðmáts
Fjármálafyrirtæki | Dataverse tafla |
---|---|
GERÐ FERLIS | cdm_businessprocesstype |
GENERICSUBTYPE | cdm_genericsubtype |
HEITI | cdm_name |
LÝSING | cdm_description |
CALENDARID | cdm_businessprocesscalendarid.cdm_name |
PERSONNELNUMBER | cdm_processownerid.cdm_workernumber |
ISACTIVE | cdm_isactive |
Sniðmátsverk viðskiptaferlis í gátlistasniðmátsverkefni
Fjármálafyrirtæki | Dataverse tafla |
---|---|
KENNI VERKS | cdm_taskid |
HEITI | cdm_name |
TEMPLATEHEADER_PROCESSTYPE | cdm_businessprocesstemplateheaderid.cdm_businessprocesstype |
TEMPLATEHEADER_GENERICSUBTYPE | cdm_businessprocesstemplateheaderid.cdm_genericsubtype |
TEMPLATEHEADER_NAME | cdm_businessprocesstemplateheaderid.cdm_name |
LÝSING | cdm_description |
DUEDATEOFFSETDAYS | cdm_duedateoffsetdays |
MENUITEMTYPE | cdm_tasklinktype |
VALMYNDARATRIÐI | cdm_tasklink |
CONTACTPERSON_PERSONNELNUMBER | cdm_contactpersonid.cdm_workernumber |
ASSIGNMENTTYPE | cdm_assignmenttype |
ASSIGNEDWORKER_PERSONNELNUMBER | cdm_assignedworkerid.cdm_workernumber |
ASSIGNEDPOSITION_POSITIONID | cdm_assignedpositionid.cdm_jobpositionnumber |
ASSIGNEDGROUP_NAME | cdm_assignedgroupid.cdm_name |
ISVALFRJÁLST | cdm_isoptional |
FYRIRMÆLI | cdm_instructions |
Útreikningstíðni til fríðindaútreikningstíðni
Fjármálafyrirtæki | Dataverse tafla |
---|---|
LÝSING | cdm_description |
FREQUENCY | cdm_name |
TÍÐNISTJÓRNUN | cdm_frequencycontrol |
ÍSÓBREYTANLEGT | cdm_isimmutable |
Tíðni útreiknings launatímabils til Tíðni fríðindaútreikninga Launatímabil
Fjármálafyrirtæki | Dataverse tafla |
---|---|
CALCULATIONFREQUENCYID | cdm_benefitcalculationfrequencyid.cdm_name |
DAGSETNING TÍMABILS | cdm_payperiodid.cdm_periodstartdate |
PAYCYCLEID | cdm_payperiodid.cdm_paycycleid.cdm_name |
Dagatal til vinnudagatals
Fjármálafyrirtæki | Dataverse tafla |
---|---|
CALENDARID | cdm_name |
HEITI DAGATALS | cdm_description |
WORKCALENDARHOLIDAYID | cdm_workcalendarholidayid.cdm_name |
Launatafla fastra launa fyrir tilvik fastra launa
Fjármálafyrirtæki | Dataverse tafla |
---|---|
AÐGERÐ | cdm_name |
VIRKUR | cdm_isactive |
LÝSING | cdm_description |
GERÐ | cdm_eventtype |
Launaáætlun föst í launaáætlun
Fjármálafyrirtæki | Dataverse tafla |
---|---|
ÁÆTLUN | cdm_name |
LÝSING | cdm_description |
GERÐ | cdm_type |
GILDISTÖKUDAGUR | cdm_effectivedate |
GILDISTÍMI: | cdm_expirationdate |
GJALDMIÐILL | cdm_transactioncurrencyid.isocurrencycode |
GREIÐSLUTÍÐNI | cdm_payfrequency.cdm_name |
HIRERULE | cdm_hirerule |
OUTOFRANGETOLERANCE | cdm_outofrangetolerance |
TILMÆLI. | cdm_recommendationallowed |
UPPBYGGING LAUNA | cdm_compensationgrid.cdm_name |
REFPOINTSETUPID | cdm_referencepointsetupline.cdm_referencepointsetupid.cdm_name |
STÝRIPUNKTUR | cdm_referencepointsetupline.cdm_name |
Launanet í launanet
Fjármálafyrirtæki | Dataverse tafla |
---|---|
GRÍDÓ | cdm_name |
LÝSING | cdm_description |
GILDISTÖKUDAGUR | cdm_effectivedate |
GILDISTÍMI: | cdm_expirationdate |
REFERENCESETUP | cdm_referencepointsetupid.cdm_name |
GERÐ | cdm_type |
GJALDMIÐILL | cdm_transactioncurrencyid.isocurrencycode |
Starfshlutverk launa í starfshlutverk
Fjármálafyrirtæki | Dataverse tafla |
---|---|
JOBFUNCTIONID | cdm_name |
LÝSING | cdm_description |
Vinnslugerð uppbótar fyrir vinnslugerð vinnslu
Fjármálafyrirtæki | Dataverse tafla |
---|---|
JOBTYPEID | cdm_name |
LÝSING | cdm_description |
EXEMPTSTATUS | cdm_exemptstatus |
Launatíðni launa til launatíðni launa
Fjármálafyrirtæki | Dataverse tafla |
---|---|
PAYRATECONVERSION | cdm_name |
TÍMABIL | cdm_period |
LÝSING | cdm_description |
ÁRLEGUR BREYTISTUÐULL | cdm_annualconversionfactor |
HOURLYCONVERSIONFACTOR | cdm_hourlyconversionfactor |
MONTHLYCONVERSIONFACTOR | cdm_monthlyconversionfactor |
WEEKLYCONVERSIONFACTOR | cdm_weeklyconversionfactor |
Bótasvæði til bótasvæðis
Fjármálafyrirtæki | Dataverse tafla |
---|---|
LÝSING | cdm_description |
STAÐSETNING | cdm_name |
Launabreytuáætlun V2 í launabreytuáætlun
Fjármálafyrirtæki | Dataverse tafla |
---|---|
BREYTILEGUR GRUNDVÖLLUR | cdm_awardbasis |
ÚTREIKNINGUR VERÐLAUNA | cdm_awardbasiscalculation |
GERÐ ÚTREIKNINGS | cdm_calculationtype |
LÝSING | cdm_description |
ENABLEENROLLMENT | cdm_enableenrollment |
VIRKJAR STIG | cdm_enablelevels |
ENABLERECOMMENDATION | cdm_enablerecommendation |
HIRERULE | cdm_hirerule |
LEVERAGE100PERCENT | cdm_leverage100percent |
MIKIL ÁVÖXTUN | cdm_leveragemaximum |
LÁGMARK VOGUN | cdm_leverageminimum |
LEVERAGEOVEROBJECTIVE | cdm_leverageoverobjective |
LVERAGEUNDEROBJECTIVE | cdm_leverageunderobjective |
PRÓSENTUGRUNNUR | cdm_percentofbasis |
SVIF | cdm_name |
VARIABLECOMPENSATIONTYPE | cdm_variablecompensationtypeid.cdm_name |
UNITCURRENCYCODE | transactioncurrencyid.isocurrencycode |
UNITRELATIONSHIP | cdm_unitrelationship |
UNITVALUE | cdm_unitvalue |
NUMBEROFUNITSREAL | cdm_numberofunits |
GILDISTÖKUDAGUR | cdm_effectivedate |
GILDISTÍMI: | cdm_expirationdate |
VESTINGRULE | cdm_vestingruleid.cdm_name |
LVERAGETOLERANCEMAX | cdm_leveragetolerancemax |
LVERAGETOLERANCEMIN | cdm_leveragetolerancemin |
Gerð launabreytu í áætlunargerð uppbótarbreytu
Fjármálafyrirtæki | Dataverse tafla |
---|---|
LÝSING | cdm_description |
GERÐ | cdm_awardtype |
VARIABLECOMPENSATIONTYPE | cdm_name |
Reglur um ávinnslu launa samkvæmt ávinnslureglu
Fjármálafyrirtæki | Dataverse tafla |
---|---|
LÝSING | cdm_description |
ATHUGASEMD | cdm_notes |
VESTINGRULE | cdm_name |
Deild V2 til deildar
Fjármálafyrirtæki | Dataverse tafla |
---|---|
REKSTRAREININGNÚMER | cdm_departmentnumber |
HEITI | cdm_name |
LEITARHEITI | cdm_description |
PARTYTYPE | cdm_partytype |
Tvöfalt skattsvæði á skattsvæði
Fjármálafyrirtæki | Dataverse tafla |
---|---|
BORG | cdm_city |
COUNTRYORREGION | cdm_countryorregion |
SÝSLA | cdm_county |
RÍKI | cdm_stateorprovince |
TAXREGIONNAME | cdm_name |
Tvískiptur skrifari Kennitala starfsmanns á kennitölu starfsmanns
Fjármálafyrirtæki | Dataverse tafla |
---|---|
LÝSING | cdm_description |
TEGUND FÆRSLU | cdm_entrytype |
GILDISTÍMI: | cdm_expirationdate |
IDENTIFICATIONNUMBER | cdm_identificationnumber |
IDENTIFICATIONTYPEID | cdm_identificationtypeid.cdm_name |
ÍSLAND | cdm_isprimary |
ÚTGÁFUDAGUR | cdm_issuedate |
ÚTGÁFUSTOFNUNIN | cdm_issuingagencyid.cdm_name |
NÚMER STARFSMANNS | cdm_workerid.cdm_workernumber |
Launaskipulag til launakerfis
Fjármálafyrirtæki | Dataverse tafla |
---|---|
UPPHÆÐ | cdm_amount |
RIST | cdm_compensationgridid.cdm_name |
LEVELID | cdm_compensationlevelid.cdm_name |
REFERENCEPOINTLINENUMBER | cdm_referencepointid.cdm_linenumber |
REFERENCESETUP | cdm_referencepointid.cdm_referencepointsetupid.cdm_name |
VIÐMIÐUNARPUNKTUR | cdm_referencepointid.cdm_name |
Að vinna sér inn kóða í launatekjukóða
Fjármálafyrirtæki | Dataverse tafla |
---|---|
EARNINGCODE | cdm_name |
LÝSING | cdm_description |
INCLUDEINPAYMENTTYPE | cdm_includeinpaymenttype |
MAGNEINING | cdm_quantityunit |
TRACKFMLAHOURS | cdm_trackfmlahours |
ER AFKASTAMIKILL | cdm_isproductive |
Föst laun starfsmanns í föst laun starfsmanns
Fjármálafyrirtæki | Dataverse tafla |
---|---|
COMPENSATIONLEVELID | cdm_compensationlevelid.cdm_name |
GERÐ | cdm_compensationtype |
GILDISTÖKUDAGUR | cdm_effectivedate |
GILDISTÍMI: | cdm_expirationdate |
LINENUMBER | cdm_linenumber |
GREIÐSLUTÍÐNI | cdm_payfrequencyid.cdm_name |
LAUNATAXTI | cdm_payrate |
ÁÆTLUN | cdm_planid.cdm_name |
KENNI STÖÐU | cdm_positionid.cdm_jobpositionnumber |
GERÐ FERLIS | cdm_processtype |
PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
AÐGERÐ | cdm_eventid.cdm_name |
ÞREP | cdm_referencepointsetuplineid.cdm_name |
REFPOINTSETUPID | cdm_referencepointsetuplineid.cdm_referencepointsetupid.cdm_name |
Atvinna á hvert fyrirtæki til Atvinna
Fjármálafyrirtæki | Dataverse tafla |
---|---|
DAGSETNING RÁÐNINGAR | cdm_employmentenddate |
PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
STARFSBYRJUNARDAGSETNING | cdm_employmentstartdate |
GERÐ STARFSMANNS | cdm_workertype |
DIMENSIONDISPLAYVALUE | cdm_dimensiondisplayvalue |
ADJUSTEDWORKERSTARTDATE | cdm_adjustedworkerstartdate |
TILKYNNING VINNUVEITANDA | cdm_employernoticeamount |
VINNUVEITANDI TILKYNNING | cdm_employerunitofnotice |
WORKERUNITOFNOTICE | cdm_workerunitofnotice |
WORKERNOTICEAMOUNT | cdm_workernoticeamount |
LASTDATEWORKED | cdm_lastdateworked |
PROBATIONENDDATE | cdm_probationenddate |
AÐLÖGUNARDAGUR | cdm_transitiondate |
TRANSITIONREASONCODENAME | cdm_transitionreasoncode.cdm_name |
WORKERSTARTDATE | cdm_workerstartdate |
VALIDTO | cdm_validto |
VALIDFROM | cdm_validfrom |
Þjóðernislegur uppruni til þjóðernis
Fjármálafyrirtæki | Dataverse tafla |
---|---|
ETHNICORIGINID | cdm_name |
LÝSING | cdm_description |
Hópúthlutun í flokksverkefni viðskiptaferlis
Fjármálafyrirtæki | Dataverse tafla |
---|---|
HEITI | cdm_name |
LÝSING | cdm_description |
ISACTIVE | cdm_isactive |
Auðkennisgerð fyrir auðkennisgerð starfsmanns
Fjármálafyrirtæki | Dataverse tafla |
---|---|
LÝSING | cdm_description |
IDENTIFICATIONTYPEID | cdm_name |
ALLOWEDVALUES | cdm_allowedvalues |
FÖST LENGD | cdm_fixedlength |
IDENTIFICATIONNUMBERFORMAT | cdm_identificationnumberformat |
Umboðsskrifstofa sem gefur út auðkenni einstaklinga
Fjármálafyrirtæki | Dataverse tafla |
---|---|
NETFANG | cdm_email |
FRAMLENGING | cdm_extension |
SÍMBRÉF | cdm_fax |
ÚTGÁFUSTOFNUN | cdm_name |
FARSÍMI | cdm_mobilephone |
VEFFANG | cdm_websiteurl |
HEITI | cdm_description |
PAGER | cdm_pager |
SMS | cdm_sms |
SÍMI | cdm_telephone |
TELEXNÚMER | cdm_telex |
ADDRESSCITY | cdm_city |
ADDRESSCOUNTY | cdm_county |
ADDRESSDESCRIPTION | cdm_addressdescription |
ADDRESSSTATE | cdm_stateorprovince |
ADDRESSSTREET | cdm_street |
ADDRESSZIPCODE | cdm_postalcode |
ADDRESSCOUNTRYREGIONISOCODE | cdm_countryregion |
Starfsstöður Tvöfalt Skrifa í starfsstöðu
Fjármálafyrirtæki | Dataverse tafla |
---|---|
KENNI STÖÐU | cdm_jobpositionnumber |
VIRKJUN | cdm_activation |
AVAILABLEFORASSIGNMENT | cdm_availableforassignment |
COMPENSATIONREGIONID | cdm_compensationregionid.cdm_name |
DEILDARKENNI | cdm_departmentid.cdm_deildarnúmer |
LÝSING | cdm_description |
FULLT STARF | cdm_fulltimeequivalent |
JOBID | cdm_jobid.cdm_name |
PARENTPOSITIONID | cdm_parentjobpositionid.cdm_jobpositionnumber |
POSITIONTYPEID | cdm_positiontypeid.cdm_name |
STARFSLOK SÖKUM ALDURS | cdm_retirement |
TITLEID | cdm_titleid.cdm_name |
VALIDFROM | cdm_validfrom |
VALIDTO | cdm_validto |
Verk Tvískrifað í Verk
Fjármálafyrirtæki | Dataverse tafla |
---|---|
JOBID | cdm_name |
LÝSING | cdm_description |
STARFSLÝSING | cdm_jobdescription |
ALLOWUNLIMITEDPOSITIONS | cdm_allowunlimitedpositions |
MAXIMUMNUMBEROFPOSITIONS | cdm_maximumnumberofpositions |
JOBFUNCTIONID | cdm_jobfunctionid.cdm_name |
JOBTYPEID | cdm_jobtypeid.cdm_name |
TITLEID | cdm_titleid.cdm_name |
VALIDFROM | cdm_validfrom |
VALIDTO | cdm_validto |
DEFAULTFULLTIMEEQUIVALENCY | cdm_defaultfulltimeequivalent |
Tungumálakóðar á tungumál
Fjármálafyrirtæki | Dataverse tafla |
---|---|
LANGUAGECODEID | cdm_name |
LÝSING | cdm_description |
Leyfi og fjarvistir bankafærslu V2 til að yfirgefa bankafærslu
Fjármálafyrirtæki | Dataverse tafla |
---|---|
UPPHÆÐ | cdm_amount |
LEAVETYPEID | cdm_leavetypeid.cdm_type |
LEAVEPLANID | cdm_leaveplanid.cdm_name |
DAGSETNING VIÐSKIPTA | cdm_transactiondate |
FÆRSLUNÚMER | cdm_transactionnumber |
PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
TRANSACTIONTYPE | cdm_transactiontype |
Skráning í leyfi og fjarvistir V2 til að yfirgefa innritun
Fjármálafyrirtæki | Dataverse tafla |
---|---|
STARTDATE | cdm_startdate |
ENDDATE | cdm_enddate |
CUSTOMDATE | cdm_customdate |
ACCRUALSTARTDATE | cdm_accrualstartdate |
ACCRUALDATEBASIS | cdm_accrualdatebasis |
ÍSASÖFNUN í bið | cdm_isaccrualsuspended |
LEAVEPLANID | cdm_leaveplanid.cdm_name |
ÞREP | cdm_tierbasis |
PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
Orlofs- og fjarvistaráætlun V2 til að yfirgefa áætlun
Fjármálafyrirtæki | Dataverse tafla |
---|---|
ACCRUALFREQUENCY | cdm_accrualfrequency |
HEITI | cdm_name |
LÝSING | cdm_description |
STARTDATE | cdm_startdate |
LEAVETYPEID | cdm_leavetypeid.cdm_type |
Gerð leyfis og fjarvistar til að fara frá
Fjármálafyrirtæki | Dataverse tafla |
---|---|
LÝSING | cdm_description |
GERÐ | cdm_type |
EARNINGCODEID | cdm_earningcodeid.cdm_name |
Ástæðukóti orlofs- og fjarvistargerðar til að skilja tegund eftir Ástæðukóti
Fjármálafyrirtæki | Dataverse tafla |
---|---|
TEGUND LAUFS | cdm_typeid.cdm_type |
REASONCODEID | cdm_reasoncodeid.cdm_name |
Skilja upplýsingar um tímafrestsbeiðni eftir til að skilja eftir upplýsingar um beiðni
Fjármálafyrirtæki | Dataverse tafla |
---|---|
UPPHÆÐ | cdm_amount |
DAGSETNING LEYFIS | cdm_leavedate |
REQUESTID | cdm_leaverequestid.cdm_leaverequestnumber |
GERÐ | cdm_leavetypeid.cdm_type |
Skilja eftir haus beiðni um tímalokun til að skilja beiðni eftir
Fjármálafyrirtæki | Dataverse tafla |
---|---|
REQUESTID | cdm_leaverequestnumber |
DAGSETNING BEIÐNI | cdm_requestdate |
STAÐA | cdm_status |
ATHUGASEMD | cdm_comment |
PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
Stig að launastigi
Fjármálafyrirtæki | Dataverse tafla |
---|---|
GERÐ | cdm_type |
LÝSING | cdm_description |
STIG | cdm_name |
Haus inngönguferlis í haus Onboard Process
Fjármálafyrirtæki | Dataverse tafla |
---|---|
PROCESSID | cdm_processheaderid.cdm_processid |
ONBOARDEDEMPLOYEEPERSONNELNUMBER | cdm_onboardedemployeeid.cdm_workernumber |
STARFSMENN: | cdm_employmentid.cdm_workerid.cdm_workernumber |
LEGALENTITYID | cdm_employmentid.cdm_companyid.cdm_companycode |
STARFSBYRJUNARDAGSETNING | cdm_employmentid.cdm_employmentstartdate |
Launaferli í launalotu
Fjármálafyrirtæki | Dataverse tafla |
---|---|
PAYCYCLEID | cdm_name |
LÝSING | cdm_description |
PAYCYCLEFREQUENCY | cdm_frequency |
Launatímabil til launatímabils
Fjármálafyrirtæki | Dataverse tafla |
---|---|
COMMENTS | cdm_description |
DEFAULTPAYMENTDATE | cdm_defaultpaymentdate |
PAYCYCLEID | cdm_paycycleid.cdm_name |
DAGSETNING TÍMABILS | cdm_periodenddate |
DAGSETNING TÍMABILS | cdm_periodstartdate |
STAÐA | cdm_status |
Launaupplýsingar fyrir stöður til Upplýsingar um launastöðu
Fjármálafyrirtæki | Dataverse tafla |
---|---|
PAYCYCLEID | cdm_paycycle.cdm_name |
KENNI STÖÐU | cdm_position.cdm_jobpositionnumber |
VALIDFROM | cdm_validfrom |
VALIDTO | cdm_validto |
ÁRLEGIR REGLULEGIR tímar | cdm_annualregularhours |
PAIDBYLEGALENTITY | cdm_paidby.cdm_companycode |
Staðsetning Sjálfgefnar víddir Tvískipt skrifa í vinnslustöðu Vídd stöðu
Fjármálafyrirtæki | Dataverse tafla |
---|---|
DIMENSIONDISPLAYVALUE | cdm_dimensiondisplayvalue |
KENNI STÖÐU | cdm_jobpositionid.cdm_jobpositionnumber |
Gerð stöðu til Gerð stöðu
Fjármálafyrirtæki | Dataverse tafla |
---|---|
POSITIONTYPEID | cdm_name |
LÝSING | cdm_description |
FLOKKUN | cdm_classification |
Verkefni stöðustarfsmanns V2 til Verkefni stöðustarfsmanns
Fjármálafyrirtæki | Dataverse tafla |
---|---|
PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
KENNI STÖÐU | cdm_jobpositionid.cdm_jobpositionnumber |
VALIDFROM | cdm_validfrom |
VALIDTO | cdm_validto |
IsPrimaryPosition | cdm_isprimaryposition |
Ástæðukóðar fyrir ástæðukóða
Fjármálafyrirtæki | Dataverse tafla |
---|---|
REASONCODEID | cdm_name |
LÝSING | cdm_description |
ISABSENCE. | cdm_isabsenceapplicable |
ISUMSÓKN | cdm_isapplicationapplicable |
SKAÐABÆTUR. | cdm_iscompensationapplicable |
ISCREATENEWPOSITIONAPPLICABLE | cdm_iscreatenewpositionapplicable |
ISEDITPOSITIONAPPLICABLE | cdm_iseditpositionapplicable |
ÍSLAND | cdm_ishireapplicable |
ISSKILLMAPPINGAPPLICABLE | cdm_isskillmappingapplicable |
UPPSÖGN. | cdm_isterminationapplicable |
ISTRANSFERAPPLICABLE | cdm_istransferapplicable |
Uppsetningarlína tilvísunarpunkts (tvískrift) í uppsetningarlínu tilvísunarpunkts launa
Fjármálafyrirtæki | Dataverse tafla |
---|---|
LÝSING | cdm_description |
LÍN | cdm_linenumber |
REFPOINTID | cdm_name |
REFPOINTSETUPID | cdm_referencepointsetupid.cdm_name |
Uppsetning tilvísunarpunkta í uppsetningu tilvísunarpunkts launa
Fjármálafyrirtæki | Dataverse tafla |
---|---|
REFERENCESETUP | cdm_name |
LÝSING | cdm_description |
GERÐ | cdm_compensationtype |
Hæfnisgerðir til hæfnisgerðar
Fjármálafyrirtæki | Dataverse tafla |
---|---|
HÆFNI | cdm_name |
LÝSING | cdm_description |
Titlar á titil
Fjármálafyrirtæki | Dataverse tafla |
---|---|
TITLEID | cdm_name |
Breytilegt uppbótarstig V2 í uppbótarbreytilegt áætlunarstig
Fjármálafyrirtæki | Dataverse tafla |
---|---|
VERÐLAUNAUPPHÆÐ | cdm_awardamount |
VERÐLAUN | cdm_awardpercent |
AWARDUNITSREAL | cdm_awardunits |
COMPENSATIONLEVELID | cdm_compensationlevelid.cdm_name |
SVIF | cdm_compensationvariableplanid.cdm_name |
Veteran stöðu til Veteran Status
Fjármálafyrirtæki | Dataverse tafla |
---|---|
VETERANSTATUSID | cdm_name |
LÝSING | cdm_description |
ISPROTECTEDVETERAN | cdm_isprotectedveteran |
Innskráningar á vinnudagatal í vinnudagatal
Fjármálafyrirtæki | Dataverse tafla |
---|---|
STARTDATE | cdm_employmentid.cdm_employmentstartdate |
PERSONNELNUMBER | cdm_employmentid.cdm_workerid.cdm_workernumber |
CALENDARID | cdm_workcalendarid.cdm_name |
KENNI FYRIRTÆKIS | cdm_employmentid.cdm_companyid.cdm_companycode |
Vinnudagatal frí til vinnudagatals Holiday
Fjármálafyrirtæki | Dataverse tafla |
---|---|
KENNI | cdm_name |
LÝSING | cdm_description |
Frílína vinnudagatals í frílínu vinnudagatals
Fjármálafyrirtæki | Dataverse tafla |
---|---|
FRÍDAGUR | cdm_workcalendarholidayid.cdm_name |
HEITI | cdm_name |
FRÍDAGUR | cdm_holidaydate |
Starfsmaður til starfsmanns
Fjármálafyrirtæki | Dataverse tafla |
---|---|
PERSONNELNUMBER | cdm_workernumber |
FIRSTNAME | cdm_firstname |
MIDDLENAME | cdm_middlename |
EFTIRNAFN | cdm_lastname |
GERÐ STARFSMANNS | cdm_type |
STAÐA STARFSMANNS | cdm_status |
PRIMARYCONTACTEMAIL | cdm_primaryemailaddress |
PRIMARYCONTACTPHONE | cdm_primarytelephone |
PRIMARYCONTACTFACEBOOK | cdm_facebookidentity |
PRIMARYCONTACTTWITTER | cdm_twitteridentity |
PRIMARYCONTACTLINKEDIN | cdm_linkedinidentity |
PRIMARYCONTACTURL | cdm_websiteurl |
GENDER | cdm_gender |
FÆÐINGARDAGUR | cdm_birthdate |
HEITI | cdm_fullname |
Bankareikningar starfsmanns á bankareikning starfsmanns
Fjármálafyrirtæki | Dataverse tafla |
---|---|
AUÐKENNING REIKNINGS | cdm_accountidentification |
ADDRESSCITY | cdm_city |
ADDRESSCOUNTRYREGIONID | cdm_countryorregion |
ADDRESSCOUNTY | cdm_county |
ADDRESSDESCRIPTION | cdm_addressdescription |
ADDRESSDISTRICTNAME | cdm_districtname |
ADDRESSPOSTBOX | cdm_postofficebox |
ADDRESSSTATE | cdm_stateorprovince |
ADDRESSZIPCODE | cdm_postalcode |
PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
NÚMER BANKAREIKNINGS | cdm_bankaccountnumber |
GERÐ BANKAREIKNINGS | cdm_bankaccounttype |
NETFANG | cdm_email |
FRAMLENGING | cdm_extension |
SÍMBRÉF | cdm_fax |
VEFFANG | cdm_websiteurl |
FARSÍMI | cdm_mobilephone |
LEIÐARNÚMER | cdm_routingnumber |
SÍMI | cdm_telephone |
TELEXNÚMER | cdm_telexnumber |
BANKI | cdm_iban |
SWIFTNO | cdm_swiftcode |
BANKLOCATIONCODE | cdm_banklocationcode |
HEITI ÚTIBÚS | cdm_branchname |
NÚMER ÚTIBÚS | cdm_branchnumber |
ROUTINGNUMBERTYPE | cdm_routingnumbertype |
REIKNINGSHAFI | cdm_accountholder |
NAFN EINSTAKLINGS | cdm_nameofperson |
HEITI | cdm_description |
ADDRESSSTREET | cdm_line1 |
ADDRESSSTREETNUMBER | cdm_line2 |
Persónulegar upplýsingar starfsmanns til starfsmanns Persónulegar upplýsingar
Fjármálafyrirtæki | Dataverse tafla |
---|---|
PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
FÆÐINGARDAGUR | cdm_birthdate |
PERSONBIRTHCITY | cdm_birthcity |
GENDER | cdm_gender |
EXPATRIATEENDDATE | cdm_expatriateenddate |
EXPATRIATESTARTDATE | cdm_expatriatestartdate |
FATLAÐUR ÖLDUNGUR | cdm_isdisabledveteran |
LÁTINNDAGS | cdm_deceaseddate |
DISABLEDVERIFICATIONDATE | cdm_disabledveteranverificationdate |
MENNTUN | cdm_education |
ETHNICORIGINID | cdm_ethnicoriginid.cdm_name |
ÓVIRKT | cdm_isdisabled |
ISFULLTIMESTUDENT | cdm_isfulltimestudent |
ISEXPATRIATERULINGAPPLICABLE | cdm_isexpatriaterulingapplicable |
MARITALSTATUS | cdm_maritalstatus |
MILITARYSERVICESTARTDATE | cdm_militaryservicestartdate |
MILITARYSERVICEENDDATE | cdm_militaryserviceenddate |
NUMBEROFDEPENDENTS | cdm_numberofdependents |
NATIVELANGUAGEID | cdm_nativelanguageidid.cdm_name |
NATIONALITYCOUNTRYREGION | cdm_nationalitycountryregion |
PERSONBIRTHCOUNTRYREGION | cdm_birthcountryregion |
FÆÐINGARLANDIÐ | cdm_fatherbirthcountryregion |
FÆÐINGARLAND | cdm_motherbirthcountryregion |
RÍKISFANGCOUNTRYREGION | cdm_citizenshipcountryregion |
VETERANSTATUSID | cdm_veteranstatusid.cdm_name |
Póstföng starfsmanns tvískrifuð í aðsetur starfsmanns
Fjármálafyrirtæki | Dataverse tafla |
---|---|
PERSONNELNUMBER | cdm_workerid.cdm_workernumber |
ADDRESSLOCATIONID | cdm_addressnumber |
ADDRESSLOCATIONROLES | cdm_addresstype |
SKILVIRKUR | cdm_effectivedate |
ENDIR | cdm_expirationdate |
ADDRESSSTREET | cdm_street |
ADDRESSSTREETNUMBER | cdm_streetnumber |
ADDRESSCITY | cdm_city |
ADDRESSCOUNTRYREGIONISOCODE | cdm_countryregion |
ADDRESSSTATE | cdm_stateorprovince |
ADDRESSCOUNTYID | cdm_county |
ADDRESSDESCRIPTION | cdm_description |
ADDRESSLATITUDE | cdm_latitude |
ADDRESSLONGITUDE | cdm_longitude |
ADDRESSZIPCODE | cdm_postalcode |
ADDRESSPOSTBOX | cdm_postofficebox |
ÍSLAND | cdm_ispreferred |
Tímabil vinnutíma í vinnudagatal
Fjármálafyrirtæki | Dataverse tafla |
---|---|
LOKATÍMI | cdm_endtime |
UPPHAFSTÍMI | cdm_starttime |
VINNUDAGATALDAGSETNING | cdm_workcalendardayid.cdm_calendardate |
WORKCALENDARID | cdm_workcalendarid.cdm_name |
WORKCALENDARID | cdm_workcalendardayid.cdm_workcalendarid.cdm_name |
Vinnutími að vinnudagatali Dagur
Fjármálafyrirtæki | Dataverse tafla |
---|---|
DAGATAL | cdm_calendardate |
WORKCALENDARID | cdm_workcalendarid.cdm_name |
VINNUDAGURSKILGREINING | cdm_status |
Hvað skal hafa í huga við samþættingu
- Allar breytingar sem gerðar eru á gögnum í öðru hvoru kerfinu verða háðar staðfestingu hins kerfisins. Ef bilun kemur upp verða gögn ekki skrifuð í hvorugu kerfinu.
- Öll skrif eru háð sjálfgefnum gögnum (ef sérsniðin rökfræði á sér stað í fjármálum).
- Tvískriftarsamþættingarforritið notar samþættingarlykla til að kortleggja á milli kerfanna tveggja. Stundum er erfitt að velja réttan samþættingarlykil, sérstaklega ef margir samþættingarlyklar uppfylla kröfurnar. Til að hjálpa við þetta val er eftirfarandi tafla listi yfir tillögur að samþættingarlykla fyrir kortanir þínar.
Dataverse tafla | Samþættingarlyklar |
---|---|
Bankareikningsgreiðslur | cdm_bankaccountid.cdm_accountidentification, cdm_bankaccountid.cdm_workerid.cdm_workernumber, cdm_companyid.cdm_companycode |
Útreikningstíðni fríðinda | cdm_name |
Útreikningsíðni fríðinda á launatímabili | cdm_payperiodid.cdm_periodstartdate, cdm_payperiodid.cdm_paycycleid.cdm_name, cdm_benefitcalculationfrequencyid.cdm_name |
Hlutfall útreikninga fyrir fríðindi | cdm_name |
Upplýsingar um hlutfall útreikninga fyrir fríðindi | cdm_workerdeduction, cdm_effective, cdm_calculationrateid.cdm_name |
Fríðindavalkostur | cdm_name |
Gerð fríðinda | cdm_name |
Dagatal viðskiptaferlis | cdm_name |
Hópverkefni viðskiptaferlis | cdm_name |
Viðskiptaferlishaus | cdm_processid |
Verkhópur viðskiptaferlissafns | cdm_processtype, cdm_name |
Stig viðskiptaferlis | cdm_name, cdm_businessprocesstype, cdm_companyid.cdm_companycode |
Viðskiptaferli verkefni | cdm_taskid |
Fyrirtækiseining | |
Haus gátlistasniðmáts | cdm_businessprocesstype, cdm_name, cdm_genericsubtype |
Verkefni gátlistasniðmáts | cdm_taskid |
Fyrirt. | cdm_companycode |
Fyrirkomulag fastra launa | cdm_name, cdm_company.cdm_companycode |
Launanet | cdm_name, cdm_companyid.cdm_companycode |
Launastig | cdm_name |
Greiðslutíðni launa | cdm_name, cdm_companyid.cdm_companycode |
Uppsetning á tilvísunarpunkti launa | cdm_name, cdm_companyid.cdm_companycode |
Setja upp línu tilvísunarpunkts launa | cdm_name, cdm_referencepointsetupid.cdm_name, cdm_referencepointsetupid.cdm_companyid.cdm_companycode |
Launasvæði | cdm_name |
Launaskipulag | cdm_compensationlevelid.cdm_name, cdm_referencepointid.cdm_name, cdm_referencepointid.cdm_referencepointsetupid.cdm_name, cdm_referencepointid.cdm_referencepointsetupid.cdm_companyid.cdm_company_company.comy d.cdm_name, cdm_compensationgridid.cdm_companyid.cdm_companycode |
Fyrirkomulag breytilegra uppbóta | cdm_name, cdm_companyid.cdm_companycode |
Fyrirkomulagsstig breytilegra uppbóta | cdm_companyid.cdm_companycode, cdm_compensationvariableplanid.cdm_name, cdm_compensationvariableplanid.cdm_companyid.cdm_companycode, cdm_compensationlevelid.cdm_name |
Fyrirkomulagsgerð breytilegra uppbóta | cdm_name, cdm_companyid.cdm_companycode |
Gjaldmiðill | isocurrencycode |
Deild | cdm_departmentnumber |
Ráðning | cdm_employmentstartdate, cdm_workerid.cdm_workernumber, cdm_companyid.cdm_companycode |
Þjóðernisuppruni | cdm_name |
Fast launatilvik | cdm_name, cdm_companyid.cdm_companycode |
Vinnsla | cdm_name |
Starfshlutverk | cdm_name |
Staða starfs | cdm_jobpositionnumber |
Vídd stöðu starfs | cdm_jobpositionid.cdm_jobpositionnumber, cdm_companyid.cdm_companycode |
Starfsgerð | cdm_name |
Tungumál | cdm_name |
Orlofsbankafærsla | cdm_transactiondate, cdm_transactiontype, cdm_transactionnumber, cdm_leavetypeid.cdm_type, cdm_leavetypeid.cdm_companyid.cdm_companycode, cdm_companyid.cdm_companycode, cdm_workerid.cdm_ |
Orlofsskráning | cdm_upphafsdagur, cdm_leaveplanid.cdm_name, cdm_leaveplanid.cdm_companyid.cdm_companycode, cdm_companyid.cdm_companycode, cdm_workerid.cdm_workernumber |
Leyfisáætlun | cdm_name, cdm_companyid.cdm_companycode |
Orlofsbeiðni | cdm_leaverequestnumber, cdm_companyid.cdm_companycode |
Upplýsingar um orlofsbeiðni | cdm_leavedate, cdm_leavetypeid.cdm_type, cdm_leavetypeid.cdm_companyid.cdm_companycode, cdm_leaverequestid.cdm_leaverequestnumber, cdm_leaverequestid.cdm_companyid.cdm_company |
Gerð leyfis | cdm_type, cdm_companyid.cdm_companycode |
Ástæðukóði orlofsgerðar | cdm_reasoncodeid.cdm_name, cdm_typeid.cdm_type, cdm_typeid.cdm_companyid.cdm_companycode |
Innbyggður ferlihaus | cdm_processheaderid.cdm_processid |
Stofnun/fyrirtæki | |
Greiðsluferli | cdm_name |
Launatímabil | cdm_periodstartdate, cdm_paycycleid.cdm_name, cdm_periodenddate |
Tekjukóði launa | cdm_name |
Upplýsingar um launastöðu | cdm_validfrom, cdm_validto, cdm_position.cdm_jobpositionnumber |
Útgáfustofnun persónuskilríkja | cdm_name |
Gerð stöðu | cdm_name |
Stöðuúthlutun starfskrafts | cdm_validfrom, cdm_jobpositionid.cdm_jobpositionnumber |
Ástæðukóði | cdm_name |
Gerð hæfni | cdm_name |
Skattumdæmi | cdm_stateorprovince, cdm_name, cdm_countryorregion, cdm_county, cdm_city |
Teymi | Azureactivedirectoryobjectid, aðildargerð |
Titill | cdm_name |
Notandi | azureactivedirectoryobjectid |
Veitiregla | cdm_name, cdm_companyid.cdm_companycode |
Uppgjafahermaður | cdm_name |
Vinnudagatal | cdm_name, cdm_companyid.cdm_companycode |
Dagur í vinnudagatali | cdm_calendardate, cdm_companyid.cdm_companycode, cdm_workcalendarid.cdm_name, cdm_workcalendarid.cdm_companyid.cdm_companycode |
Skráning vinnudagatals | cdm_employmentid.cdm_employmentstartdate, cdm_employmentid.cdm_workerid.cdm_workernumber, cdm_employmentid.cdm_companyid.cdm_companycode |
Frídagur í vinnudagatali | cdm_name |
Frídagslína í vinnudagatali | cdm_holidaydate, cdm_workcalendarholidayid.cdm_name |
Tímabil vinnudagatals | cdm_starttime, cdm_workcalendardayid.cdm_calendardate, cdm_workcalendardayid.cdm_companyid.cdm_companycode, cdm_workcalendardayid.cdm_workcalendarid.cdm_name, cdm_workcalendardayid.comrid.comrid_work _fyrirtækjanúmer.cdm_fyrirtækjakóði, cdm_vinnudagatal.cdm_nafn, cdm_vinnudagatal.cdm_fyrirtækisnúmer.cdm_fyrirtækiskóði |
Vinna | cdm_workernumber |
Aðsetur starfskrafts | cdm_addressnumber, cdm_addresstype, cdm_workerid.cdm_workernumber |
Bankareikningur starfskrafts | cdm_accountidentification, cdm_workerid.cdm_workernumber |
Föst laun starfskrafts | cdm_linenumber, cdm_effectivedate, cdm_companyid.cdm_companycode, cdm_positionid.cdm_jobpositionnumber, cdm_workerid.cdm_workernumber, cdm_eventid.cdm_name, cdm_eventid.cdm_eventid.cdm_company_company.cdm_company. planid.cdm_company.cdm_companycode |
Kennitala starfskrafts | cdm_auðkennisnúmer, cdm_workerid.cdm_workernumber, cdm_identificationtypeid.cdm_name |
Persónukennisgerð starfskrafts | cdm_name |
Persónuupplýsingar starfskrafts | cdm_workerid.cdm_workernumber |
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir