NMBRS API Data Model
EmployeeFunctions: Employees |
https://online-sql-editor.com/nmbrs/nl/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Nmbrs.Employees.EmployeeFunctions%0D%0Alimit++1000
Name: EmployeeFunctions
Catalog: Nmbrs
Schema: Employees
Label: Employees
Partition-specific: true
Select: true
Insert: false
Update: false
Delete: false
Service URL (XML-specific): EmployeeService.asmx
Topic (XML-specific): Function_GetAll_AllEmployeesByCompany
Base XPath (XML-specific): /soap:Envelope/soap:Body/nes:Function_GetAll_AllEmployeesByCompanyResponse/nes:Function_GetAll_AllEmployeesByCompanyResult/nes:EmployeeFunctionItem
XPath (XML-specific): /nes:EmployeeFunctions/nes:Function_V2
Server-side Filters (XML-specific): CompanyID
Default Namespace Prefix (XML-specific): nes
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
CODE |
string |
Code |
☐ |
|
CREATIONDATE |
datetime |
Creation Date |
☐ |
|
DESCRIPTION |
string |
Description |
☐ |
|
EMPLOYEEID |
int32 |
Employee ID |
☐ |
|
ID |
int32 |
ID |
☐ |
|
PARTITIONID |
int64 |
Company ID |
☑ |
|
STARTPERIOD |
int32 |
Start Period |
☐ |
|
STARTYEAR |
int32 |
Start Year |
☐ |
|
14-05-2020 17:1320.1.36-BETA+2798
