EmployeeSalaries2ByEmployeeYearPeriod |
Catalog: Nmbrs
Schema: Employees
This is a read-only table function. The NMBRS API may not support changing the data or the Invantive SQL driver for NMBRS does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the NMBRS API.
NMBRS API URL: EmployeeService.asmx
Topic: Salary_GetList
Base XPath: /soap:Envelope/soap:Body/nes:Salary_GetListResponse/nes:Salary_GetListResult
XPath: /nes:Salary
Filters on API Server: EmployeeId- Year- Period
Default Namespace Prefix: nes
Table Function Columns
The columns of the table function EmployeeSalaries2ByEmployeeYearPeriod are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
STARTDATE |
datetime |
Start Date |
☐ |
|
TYPE |
string |
Type |
☐ |
One of 'None', 'Bruto_Salaris_Fulltime', 'Bruto_Salaris_Partime', 'Bruto_Uurloon', 'Netto_Salaris_Partime_incl_looncomp', 'Netto_Salaris_Partime_excl_looncomp', 'Netto_Uurloon_excl_looncomp', 'Werkgerverslasten', 'Netto_Uurloon_incl_looncomp'. |
VALUE |
decimal |
Value |
☐ |
|
27-12-2021 10:56 Version 20.2.169-PROD+3633