invantive documentation
Invantive Support ForumsLog In / Sign Up

EmployeeChildren: Fortnox Employee Children

read only REST

  • Catalog: Fortnox
  • Schema: Employees
  • Label: Employee Children

Retrieve a list of employees ScheduleId, MonthlySalary and HourlyPay reflect current values, all ScheduleIds are returned in DatedSchedules and all MonthlySalary and HourlyPay pairs are returned in DatedWages.

Can only retrieve data.

Summary

ScheduleId, MonthlySalary and HourlyPay reflect current values, all ScheduleIds are returned in DatedSchedules and all MonthlySalary and HourlyPay pairs are returned in DatedWages.

API Source

  • Endpoint: /3/employees
  • Operation: get /3/employees

Performance Characteristics

Characteristic Value
Average access latency (ms) 356
Full scan rows per minute 85,000
Point query rows per minute 168

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
financialyear `` Selects what financial year that should be used (does not work on every table).
financialyeardate `` Selects by date, what financial year that should be used (does not work on every table).
fromdate `` Defines a selection based on a start date. Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).
lastmodified `` Retrieves all records since the provided timestamp (does not work on every table).
todate `` Defines a selection based on an end date. Only available for invoices, orders, offers, vouchers and supplierinvoices (does not work on every table).

Table Columns

The columns of the table EmployeeChildren are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
ATFValue double itgen_fnx_atfvalue filters on the platform, writable, ::ancestor.ATFValue
ATKValue double itgen_fnx_atkvalue filters on the platform, writable, ::ancestor.ATKValue
AbsenceHoursNonVacationBased double itgen_fnx_absencehoursnonvacationbased filters on the platform, writable, ::ancestor.AbsenceHoursNonVacationBased
AbsenceHoursVacationBased double itgen_fnx_absencehoursvacationbased filters on the platform, writable, ::ancestor.AbsenceHoursVacationBased
AbsenceWorkdaysNonVacationBased double itgen_fnx_absenceworkdaysnonvacationbased filters on the platform, writable, ::ancestor.AbsenceWorkdaysNonVacationBased
AbsenceWorkdaysVacationBased double itgen_fnx_absenceworkdaysvacationbased filters on the platform, writable, ::ancestor.AbsenceWorkdaysVacationBased
Address1 varchar2 Address Line 1 filters on the platform, writable, ::ancestor.Address1
Address2 varchar2 Address Line 2 filters on the platform, writable, ::ancestor.Address2
ApprovedDays int32 Approved Days writable, ApprovedDays
AutoNonRecurringTax char Auto Non Recurring Tax filters on the platform, writable, ::ancestor.AutoNonRecurringTax
AverageHourlyWage varchar2 Average Hourly Wage filters on the platform, writable, ::ancestor.AverageHourlyWage
AverageWeeklyHours varchar2 Average Weekly Hours filters on the platform, writable, ::ancestor.AverageWeeklyHours
BankAccountNo varchar2 Bank Account No filters on the platform, writable, ::ancestor.BankAccountNo
Child varchar2 Child writable, Child
City varchar2 City filters on the platform, writable, ::ancestor.City
ClearingNo varchar2 Clearing No filters on the platform, writable, ::ancestor.ClearingNo
CostCenter varchar2 Cost Centre filters on the platform, writable, ::ancestor.CostCenter
Country varchar2 Country filters on the platform, writable, ::ancestor.Country
CurrentCompBalance double itgen_fnx_currentcompbalance filters on the platform, writable, ::ancestor.CurrentCompBalance
CurrentFlexBalance double itgen_fnx_currentflexbalance filters on the platform, writable, ::ancestor.CurrentFlexBalance
Email varchar2 Email filters on the platform, writable, ::ancestor.Email
EmployedTo datetime Employed To filters on the platform, writable, ::ancestor.EmployedTo
EmployeeId varchar2(15) Employee ID writable, EmployeeId
EmployeeId_2 varchar2(15) Employeeid 2 filters on the platform, writable, ::ancestor.EmployeeId
EmploymentDate datetime Employment Date filters on the platform, writable, ::ancestor.EmploymentDate
EmploymentForm varchar2 Employment Form filters on the platform, writable, ::ancestor.EmploymentForm
FirstName varchar2 First Name filters on the platform, writable, ::ancestor.FirstName
ForaType varchar2 For Type filters on the platform, writable, ::ancestor.ForaType
FullName varchar2 Full Name filters on the platform, writable, ::ancestor.FullName
FullTimeEquivalent double itgen_fnx_fulltimeequivalent filters on the platform, writable, ::ancestor.FullTimeEquivalent
HourlyPay varchar2 Hourly Pay filters on the platform, writable, ::ancestor.HourlyPay
Id varchar2 ID writable, Id
Inactive char Inactive filters on the platform, writable, ::ancestor.Inactive
IngoingWithdrawnDays int32 In Going Withdrawn Days writable, IngoingWithdrawnDays
InitialComp double itgen_fnx_initialcomp filters on the platform, writable, ::ancestor.InitialComp
InitialFlex double itgen_fnx_initialflex filters on the platform, writable, ::ancestor.InitialFlex
JobTitle varchar2(30) Job Title filters on the platform, writable, ::ancestor.JobTitle
LastName varchar2 Last Name filters on the platform, writable, ::ancestor.LastName
MonthlySalary varchar2 Monthly Salary filters on the platform, writable, ::ancestor.MonthlySalary
NonRecurringTax varchar2 Non Recurring Tax filters on the platform, writable, ::ancestor.NonRecurringTax
NonVacationBasedCalendarDaysPartial double itgen_fnx_nonvacationbasedcalendardayspartial filters on the platform, writable, ::ancestor.NonVacationBasedCalendarDaysPartial
NonVacationBasedCalendarDaysWhole double itgen_fnx_nonvacationbasedcalendardayswhole filters on the platform, writable, ::ancestor.NonVacationBasedCalendarDaysWhole
PayslipType varchar2 itgen_fnx_paysliptype filters on the platform, writable, ::ancestor.PayslipType
PersonalIdentityNumber varchar2 Personal Identity Number filters on the platform, writable, ::ancestor.PersonalIdentityNumber
PersonelType varchar2 Personnel Type filters on the platform, writable, ::ancestor.PersonelType
Phone1 varchar2 Phone 1 filters on the platform, writable, ::ancestor.Phone1
Phone2 varchar2 Phone 2 filters on the platform, writable, ::ancestor.Phone2
PostCode varchar2 Postal Code filters on the platform, writable, ::ancestor.PostCode
PreliminaryTaxDeducted double itgen_fnx_preliminarytaxdeducted filters on the platform, writable, ::ancestor.PreliminaryTaxDeducted
Project varchar2 Project filters on the platform, writable, ::ancestor.Project
SalaryForm varchar2 Salary Form filters on the platform, writable, ::ancestor.SalaryForm
ScheduleId varchar2 Schedule ID filters on the platform, writable, ::ancestor.ScheduleId
TaxAllowance varchar2 Tax Allowance filters on the platform, writable, ::ancestor.TaxAllowance
TaxColumn int32 Tax Column filters on the platform, writable, ::ancestor.TaxColumn
TaxTable varchar2 Tax Table filters on the platform, writable, ::ancestor.TaxTable
VacationBasedAttendanceDays double itgen_fnx_vacationbasedattendancedays filters on the platform, writable, ::ancestor.VacationBasedAttendanceDays
VacationBasedAttendanceHours double itgen_fnx_vacationbasedattendancehours filters on the platform, writable, ::ancestor.VacationBasedAttendanceHours
VacationBasedCalendarDaysWhole double itgen_fnx_vacationbasedcalendardayswhole filters on the platform, writable, ::ancestor.VacationBasedCalendarDaysWhole
VacationBasedSalaryTotal double itgen_fnx_vacationbasedsalarytotal filters on the platform, writable, ::ancestor.VacationBasedSalaryTotal
VacationBasedSalaryVariableAddition double itgen_fnx_vacationbasedsalaryvariableaddition filters on the platform, writable, ::ancestor.VacationBasedSalaryVariableAddition
VacationBasedSalaryWorkedTime double itgen_fnx_vacationbasedsalaryworkedtime filters on the platform, writable, ::ancestor.VacationBasedSalaryWorkedTime
VacationCalculationAdvanceVacationDebt double itgen_fnx_vacationcalculationadvancevacationdebt filters on the platform, writable, ::ancestor.VacationCalculationAdvanceVacationDebt
VacationCalculationIncludeInCalculation char itgen_fnx_vacationcalculationincludeincalculation filters on the platform, writable, ::ancestor.VacationCalculationIncludeInCalculation
VacationCalculationSameWagePercent char itgen_fnx_vacationcalculationsamewagepercent filters on the platform, writable, ::ancestor.VacationCalculationSameWagePercent
VacationCalculationSoleCustody char itgen_fnx_vacationcalculationsolecustody filters on the platform, writable, ::ancestor.VacationCalculationSoleCustody
VacationCalculationSumOnlyNoDays char itgen_fnx_vacationcalculationsumonlynodays filters on the platform, writable, ::ancestor.VacationCalculationSumOnlyNoDays
VacationCalculationTotalVacationSalarySum double itgen_fnx_vacationcalculationtotalvacationsalarysum filters on the platform, writable, ::ancestor.VacationCalculationTotalVacationSalarySum
VacationCalculationVacationEntitlement double itgen_fnx_vacationcalculationvacationentitlement filters on the platform, writable, ::ancestor.VacationCalculationVacationEntitlement
VacationCalculationVariableAdditionSum double itgen_fnx_vacationcalculationvariableadditionsum filters on the platform, writable, ::ancestor.VacationCalculationVariableAdditionSum
VacationDaysPaid double Vacation Days Paid filters on the platform, writable, ::ancestor.VacationDaysPaid
VacationDaysPendingPaid double Vacation Days Pending Paid filters on the platform, writable, ::ancestor.VacationDaysPendingPaid
VacationDaysPendingPrepaid double Vacation Days Pending Prepaid filters on the platform, writable, ::ancestor.VacationDaysPendingPrepaid
VacationDaysPendingSaved double Vacation Days Pending Saved filters on the platform, writable, ::ancestor.VacationDaysPendingSaved
VacationDaysPendingSavedYear1 double Vacation Days Pending Saved Year 1 filters on the platform, writable, ::ancestor.VacationDaysPendingSavedYear1
VacationDaysPendingSavedYear2 double Vacation Days Pending Saved Year 2 filters on the platform, writable, ::ancestor.VacationDaysPendingSavedYear2
VacationDaysPendingSavedYear3 double Vacation Days Pending Saved Year 3 filters on the platform, writable, ::ancestor.VacationDaysPendingSavedYear3
VacationDaysPendingSavedYear4 double Vacation Days Pending Saved Year 4 filters on the platform, writable, ::ancestor.VacationDaysPendingSavedYear4
VacationDaysPendingSavedYear5 double Vacation Days Pending Saved Year 5 filters on the platform, writable, ::ancestor.VacationDaysPendingSavedYear5
VacationDaysPendingSavedYear6Plus double Vacation Days Pending Saved Year 6 Plus filters on the platform, writable, ::ancestor.VacationDaysPendingSavedYear6Plus
VacationDaysPendingUnpaid double Vacation Days Pending Unpaid filters on the platform, writable, ::ancestor.VacationDaysPendingUnpaid
VacationDaysPrepaid double Vacation Days Prepaid filters on the platform, writable, ::ancestor.VacationDaysPrepaid
VacationDaysRegisteredPaid double Vacation Days Registered Paid filters on the platform, writable, ::ancestor.VacationDaysRegisteredPaid
VacationDaysRegisteredPrepaid double Vacation Days Registered Prepaid filters on the platform, writable, ::ancestor.VacationDaysRegisteredPrepaid
VacationDaysRegisteredSaved double Vacation Days Registered Saved filters on the platform, writable, ::ancestor.VacationDaysRegisteredSaved
VacationDaysRegisteredSavedYear1 double Vacation Days Registered Saved Year 1 filters on the platform, writable, ::ancestor.VacationDaysRegisteredSavedYear1
VacationDaysRegisteredSavedYear2 double Vacation Days Registered Saved Year 2 filters on the platform, writable, ::ancestor.VacationDaysRegisteredSavedYear2
VacationDaysRegisteredSavedYear3 double Vacation Days Registered Saved Year 3 filters on the platform, writable, ::ancestor.VacationDaysRegisteredSavedYear3
VacationDaysRegisteredSavedYear4 double Vacation Days Registered Saved Year 4 filters on the platform, writable, ::ancestor.VacationDaysRegisteredSavedYear4
VacationDaysRegisteredSavedYear5 double Vacation Days Registered Saved Year 5 filters on the platform, writable, ::ancestor.VacationDaysRegisteredSavedYear5
VacationDaysRegisteredSavedYear6Plus double Vacation Days Registered Saved Year 6 Plus filters on the platform, writable, ::ancestor.VacationDaysRegisteredSavedYear6Plus
VacationDaysRegisteredUnpaid double Vacation Days Registered Unpaid filters on the platform, writable, ::ancestor.VacationDaysRegisteredUnpaid
VacationDaysSaved double Vacation Days Saved filters on the platform, writable, ::ancestor.VacationDaysSaved
VacationDaysSavedEmploymentRateYear1 double Vacation Days Saved Employment Rate Year 1 filters on the platform, writable, ::ancestor.VacationDaysSavedEmploymentRateYear1
VacationDaysSavedEmploymentRateYear2 double Vacation Days Saved Employment Rate Year 2 filters on the platform, writable, ::ancestor.VacationDaysSavedEmploymentRateYear2
VacationDaysSavedEmploymentRateYear3 double Vacation Days Saved Employment Rate Year 3 filters on the platform, writable, ::ancestor.VacationDaysSavedEmploymentRateYear3
VacationDaysSavedEmploymentRateYear4 double Vacation Days Saved Employment Rate Year 4 filters on the platform, writable, ::ancestor.VacationDaysSavedEmploymentRateYear4
VacationDaysSavedEmploymentRateYear5 double Vacation Days Saved Employment Rate Year 5 filters on the platform, writable, ::ancestor.VacationDaysSavedEmploymentRateYear5
VacationDaysSavedEmploymentRateYear6Plus double Vacation Days Saved Employment Rate Year 6 Plus filters on the platform, writable, ::ancestor.VacationDaysSavedEmploymentRateYear6Plus
VacationDaysSavedYear1 double Vacation Days Saved Year 1 filters on the platform, writable, ::ancestor.VacationDaysSavedYear1
VacationDaysSavedYear2 double Vacation Days Saved Year 2 filters on the platform, writable, ::ancestor.VacationDaysSavedYear2
VacationDaysSavedYear3 double Vacation Days Saved Year 3 filters on the platform, writable, ::ancestor.VacationDaysSavedYear3
VacationDaysSavedYear4 double Vacation Days Saved Year 4 filters on the platform, writable, ::ancestor.VacationDaysSavedYear4
VacationDaysSavedYear5 double Vacation Days Saved Year 5 filters on the platform, writable, ::ancestor.VacationDaysSavedYear5
VacationDaysSavedYear6Plus double Vacation Days Saved Year 6 Plus filters on the platform, writable, ::ancestor.VacationDaysSavedYear6Plus
VacationDaysUnpaid double Vacation Days Unpaid filters on the platform, writable, ::ancestor.VacationDaysUnpaid
WithdrawnDays double Withdrawn Days writable, WithdrawnDays
WorkingTimeEnumeration varchar2 itgen_fnx_workingtimeenumeration filters on the platform, writable, ::ancestor.WorkingTimeEnumeration
c_url varchar2 Call URL filters on the platform, writable, ::ancestor.@url

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: