Nepton voidaan määrittää tuottamaan kirjatuista tapahtumista tulkittu palkka-aineisto Lemonsoft järjestelmään.
Määrittäminen
1. Henkilöiden tunnusten määrittäminen
Henkilöiden henkilötunnisteet voidaan määrittää muokkaamalla henkilötietoja Työsuhde > Henkilön tiedot > Tunnisteet -näkymässä.
2. Sääntöjoukon luominen
Liittymää varten pitää luoda integraation sääntöjoukko. Sääntöjoukon poiminnan ohje löytyy artikkelista Sääntöjoukon poimintasääntöjen käsittely.
Tiedostomuoto
Siirtotiedosto on puolipisteellä (;) erotettua tekstimuotoista dataa. Jos jokin kenttä sisältää erikoismerkkejä, kyseinen kenttä ympäröidään pystysuorilla lainausmerkeillä ("). Rivinvaihto on CR & LF ja merkistökoodauksena on UTF-8.
Aineisto sisältää seuraavan otsikkorivin:
Person_number;Workhour_date;Workhour_state;Workhour_hours;Workhour_header;Workhour_description;Project_number;Formofsalary_number;Workhour_worknumber;Transaction_id;Workhour_source;Workhour_amount;Workhour_phase_id;Workhour_fail_amount;Workhour_failcode_id;Workhour_failcode_description;Workhour_money;Workhour_workshift;Project_phase_id;Workhour_salary_id;Workhour_costcenter;Workhour_wcc;Formofsalary_contract;Workhour_weekhour_id;Edit_date;Workhour_invoice_bit;Invoice_number;Job_id;Workhour_enddate;Editor_number;Workhour_comments;Object_id;Workhour_invoicehours;Customer_number;Machine_id;Workhour_production_comments
Rajaukset
Henkilöt henkilönumerolla 0 eivät tule osaksi aineistoa
Aineiston tietueet
| Lemonsoft file output column | Field name | Default value |
|---|---|---|
| Workhour_date | LemonsoftWorkHourDate | UserSalaryData.BeginDatetime. The default formatting is YYYY-MM-DDThh:mm:ss, however when overriding, no formatting happens |
| Workhour_state | LemonsoftWorkHourState | 0 |
| Workhour_hours | LemonsoftWorkHourHours | The amount column, when the unit is hours |
| Workhour_header | LemonsoftWorkHourHeader | The salary type name, currently empty by default |
| Workhour_description | LemonsoftWorkHourDescription | The salary type description, currently empty by default |
| Workhour_worknumber | LemonsoftWorkHourWorkNumber | Empty |
| Workhour_source | LemonsoftWorkHourSource | 0 |
| Workhour_phase_id | LemonsoftWorkHourPhaseId | Empty |
| Workhour_amount | LemonsoftWorkHourAmount | If a row has unit type (i.e. not hours but countable integers), the amount will show up here |
| Workhour_fail_amount | LemonsoftWorkHourFailAmount | 0 |
| Workhour_failcode_id | LemonsoftWorkHourFailCodeId | 0 |
| Workhour_failcode_description | LemonsoftWorkHourFailCodeDescription | Empty |
| Workhour_money | LemonsoftWorkHourMoney | 0 |
| Workhour_workshift | LemonsoftWorkHourWorkShift | 0 |
| Workhour_salary_id | LemonsoftWorkHourSalaryId | 0 |
| Workhour_costcenter | LemonsoftWorkHourCostCenter | UserSalaryData.UserCostGroup |
| Workhour_wcc | LemonsoftWorkHourWcc | 0 |
| Workhour_weekhour_id | LemonsoftWorkHourWeekHourId | 0 |
| Workhour_invoice_bit | LemonsoftWorkHourInvoiceBit | False |
| Workhour_enddate | LemonsoftWorkHourEndDate | UserSalaryData.EndDateTime. The default formatting is YYYY-MM-DDThh:mm:ss, however when overriding, no formatting happens |
| Workhour_comments | LemonsoftWorkHourInvoiceComments | UserSalaryData.comment |
| Workhour_invoicehours | LemonsoftWorkHourInvoiceHours | 0 |
| Workhour_production_comments | LemonsoftWorkHourProductionComments | UserSalaryData.comment |
| Person_number | LemonsoftPersonnelNumber | Personnel number from WRM |
| Project_number | LemonsoftProjectNumber | UserSalaryData.projectCode1 |
| Formofsalary_number | LemonsoftFormOfSalaryNumber | Salary type code |
| Transaction_id | LemonsoftTransactionId | 0 |
| Project_phase_id | LemonsoftProjectPhaseId | Empty |
| Formofsalary_contract | LemonsoftFormOfSalaryContract | 0 |
| Edit_date | LemonsoftEditDate | UserSalaryData.ModifiedDateTime. The default formatting is YYYY-MM-DDThh:mm:ss, however when overriding, no formatting happens |
| Invoice_number | LemonsoftInvoiceNumber | 0 |
| Job_id | LemonsoftJobId | 0 |
| Editor_number | LemonsoftEditorNumber | Empty |
| Object_id | LemonsoftObjectId | 0 |
| Customer_number | LemonsoftCustomerNumber | 0 |
| Machine_id | LemonsoftMachineId | 0 |
Esimerkki
Person_number;Workhour_date;Workhour_state;Workhour_hours;Workhour_header;Workhour_description;Project_number;Formofsalary_number;Workhour_worknumber;Transaction_id;Workhour_source;Workhour_amount;Workhour_phase_id;Workhour_fail_amount;Workhour_failcode_id;Workhour_failcode_description;Workhour_money;Workhour_workshift;Project_phase_id;Workhour_salary_id;Workhour_costcenter;Workhour_wcc;Formofsalary_contract;Workhour_weekhour_id;Edit_date;Workhour_invoice_bit;Invoice_number;Job_id;Workhour_enddate;Editor_number;Workhour_comments;Object_id;Workhour_invoicehours;Customer_number;Machine_id;Workhour_production_comments
41459;2017-11-13T10:00:00;0;2,5;"Työ; muualla";;1234;123;;0;0;0;;0;0;;0;0;6;0;5555;0;0;0;2017-11-15T14:00:00;False;0;0;2017-11-14T23:00:00;;Comment;0;0;0;0;Comment
41459;2017-11-14T10:00:00;0;0,0;Työlisät;;1234;125;;0;0;9001;;0;0;;0;0;6;0;7777;0;0;0;2017-11-15T14:00:00;False;0;0;2017-11-14T23:00:00;;Comment;0;0;0;0;Comment