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 |
|---|---|---|---|---|---|
ATF |
double |
itgen_fnx_atfvalue | filters on the platform, writable, ::ancestor. |
||
ATK |
double |
itgen_fnx_atkvalue | filters on the platform, writable, ::ancestor. |
||
Absence |
double |
itgen_fnx_absencehoursnonvacationbased | filters on the platform, writable, ::ancestor. |
||
Absence |
double |
itgen_fnx_absencehoursvacationbased | filters on the platform, writable, ::ancestor. |
||
Absence |
double |
itgen_fnx_absenceworkdaysnonvacationbased | filters on the platform, writable, ::ancestor. |
||
Absence |
double |
itgen_fnx_absenceworkdaysvacationbased | filters on the platform, writable, ::ancestor. |
||
Address1 |
varchar2 |
Address Line 1 | filters on the platform, writable, ::ancestor. |
||
Address2 |
varchar2 |
Address Line 2 | filters on the platform, writable, ::ancestor. |
||
Approved |
int32 |
Approved Days | writable, Approved |
||
Auto |
char |
Auto Non Recurring Tax | filters on the platform, writable, ::ancestor. |
||
Average |
varchar2 |
Average Hourly Wage | filters on the platform, writable, ::ancestor. |
||
Average |
varchar2 |
Average Weekly Hours | filters on the platform, writable, ::ancestor. |
||
Bank |
varchar2 |
Bank Account No | filters on the platform, writable, ::ancestor. |
||
Child |
varchar2 |
Child | writable, Child |
||
City |
varchar2 |
City | filters on the platform, writable, ::ancestor. |
||
Clearing |
varchar2 |
Clearing No | filters on the platform, writable, ::ancestor. |
||
Cost |
varchar2 |
Cost Centre | filters on the platform, writable, ::ancestor. |
||
Country |
varchar2 |
Country | filters on the platform, writable, ::ancestor. |
||
Current |
double |
itgen_fnx_currentcompbalance | filters on the platform, writable, ::ancestor. |
||
Current |
double |
itgen_fnx_currentflexbalance | filters on the platform, writable, ::ancestor. |
||
Email |
varchar2 |
filters on the platform, writable, ::ancestor. |
|||
Employed |
datetime |
Employed To | filters on the platform, writable, ::ancestor. |
||
Employee |
varchar2 |
Employee ID | writable, Employee |
||
Employee |
varchar2 |
Employeeid 2 | filters on the platform, writable, ::ancestor. |
||
Employment |
datetime |
Employment Date | filters on the platform, writable, ::ancestor. |
||
Employment |
varchar2 |
Employment Form | filters on the platform, writable, ::ancestor. |
||
First |
varchar2 |
First Name | filters on the platform, writable, ::ancestor. |
||
Fora |
varchar2 |
For Type | filters on the platform, writable, ::ancestor. |
||
Full |
varchar2 |
Full Name | filters on the platform, writable, ::ancestor. |
||
Full |
double |
itgen_fnx_fulltimeequivalent | filters on the platform, writable, ::ancestor. |
||
Hourly |
varchar2 |
Hourly Pay | filters on the platform, writable, ::ancestor. |
||
Id |
varchar2 |
ID | writable, Id |
||
Inactive |
char |
Inactive | filters on the platform, writable, ::ancestor. |
||
Ingoing |
int32 |
In Going Withdrawn Days | writable, Ingoing |
||
Initial |
double |
itgen_fnx_initialcomp | filters on the platform, writable, ::ancestor. |
||
Initial |
double |
itgen_fnx_initialflex | filters on the platform, writable, ::ancestor. |
||
Job |
varchar2 |
Job Title | filters on the platform, writable, ::ancestor. |
||
Last |
varchar2 |
Last Name | filters on the platform, writable, ::ancestor. |
||
Monthly |
varchar2 |
Monthly Salary | filters on the platform, writable, ::ancestor. |
||
Non |
varchar2 |
Non Recurring Tax | filters on the platform, writable, ::ancestor. |
||
Non |
double |
itgen_fnx_nonvacationbasedcalendardayspartial | filters on the platform, writable, ::ancestor. |
||
Non |
double |
itgen_fnx_nonvacationbasedcalendardayswhole | filters on the platform, writable, ::ancestor. |
||
Payslip |
varchar2 |
itgen_fnx_paysliptype | filters on the platform, writable, ::ancestor. |
||
Personal |
varchar2 |
Personal Identity Number | filters on the platform, writable, ::ancestor. |
||
Personel |
varchar2 |
Personnel Type | filters on the platform, writable, ::ancestor. |
||
Phone1 |
varchar2 |
Phone 1 | filters on the platform, writable, ::ancestor. |
||
Phone2 |
varchar2 |
Phone 2 | filters on the platform, writable, ::ancestor. |
||
Post |
varchar2 |
Postal Code | filters on the platform, writable, ::ancestor. |
||
Preliminary |
double |
itgen_fnx_preliminarytaxdeducted | filters on the platform, writable, ::ancestor. |
||
Project |
varchar2 |
Project | filters on the platform, writable, ::ancestor. |
||
Salary |
varchar2 |
Salary Form | filters on the platform, writable, ::ancestor. |
||
Schedule |
varchar2 |
Schedule ID | filters on the platform, writable, ::ancestor. |
||
Tax |
varchar2 |
Tax Allowance | filters on the platform, writable, ::ancestor. |
||
Tax |
int32 |
Tax Column | filters on the platform, writable, ::ancestor. |
||
Tax |
varchar2 |
Tax Table | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationbasedattendancedays | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationbasedattendancehours | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationbasedcalendardayswhole | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationbasedsalarytotal | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationbasedsalaryvariableaddition | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationbasedsalaryworkedtime | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationcalculationadvancevacationdebt | filters on the platform, writable, ::ancestor. |
||
Vacation |
char |
itgen_fnx_vacationcalculationincludeincalculation | filters on the platform, writable, ::ancestor. |
||
Vacation |
char |
itgen_fnx_vacationcalculationsamewagepercent | filters on the platform, writable, ::ancestor. |
||
Vacation |
char |
itgen_fnx_vacationcalculationsolecustody | filters on the platform, writable, ::ancestor. |
||
Vacation |
char |
itgen_fnx_vacationcalculationsumonlynodays | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationcalculationtotalvacationsalarysum | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationcalculationvacationentitlement | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
itgen_fnx_vacationcalculationvariableadditionsum | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Paid | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Paid | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Prepaid | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved Year 1 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved Year 2 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved Year 3 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved Year 4 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved Year 5 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Saved Year 6 Plus | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Pending Unpaid | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Prepaid | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Paid | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Prepaid | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved Year 1 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved Year 2 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved Year 3 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved Year 4 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved Year 5 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Saved Year 6 Plus | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Registered Unpaid | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Employment Rate Year 1 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Employment Rate Year 2 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Employment Rate Year 3 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Employment Rate Year 4 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Employment Rate Year 5 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Employment Rate Year 6 Plus | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Year 1 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Year 2 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Year 3 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Year 4 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Year 5 | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Saved Year 6 Plus | filters on the platform, writable, ::ancestor. |
||
Vacation |
double |
Vacation Days Unpaid | filters on the platform, writable, ::ancestor. |
||
Withdrawn |
double |
Withdrawn Days | writable, Withdrawn |
||
Working |
varchar2 |
itgen_fnx_workingtimeenumeration | filters on the platform, writable, ::ancestor. |
||
c_url |
varchar2 |
Call URL | filters on the platform, writable, ::ancestor. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: