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