Exact Online API Data Model
Employments: Exact Online Employments |
Catalog: ExactOnlineREST
Schema: Payroll
Primary Keys: ID
Label: Employments
The data in this table is partitioned per value of the Division column.
Can retrieve data and change data using insert, update and delete.
Select Exact Online API URL: /api/v1/{division}/payroll/Employments
Insert Exact Online API URL: /api/v1/{division}/payroll/Employments
Update Exact Online API URL: /api/v1/{division}/payroll/Employments
Delete Exact Online API URL: /api/v1/{division}/payroll/Employments
Exact Online API Metadata URL: /api/v1/{division}/payroll/$metadata
Field Selection Method: Required
Table Columns
The columns of the table Employments 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 or update.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
Created |
datetime |
Created |
☐ |
Creation date. |
CreatedUtc |
datetime |
Created (UTC) |
☐ |
Creation date in UTC. |
Creator |
guid |
Creator |
☐ |
User ID of creator. |
CreatorFullName |
string(240) |
Creator Full Name |
☐ |
Name of creator. |
Division |
int32 |
Division |
☐ |
Division code. |
DivisionCompanyCoCNumber |
string(20) |
Division Chamber of Commerce Number |
☐ |
Chamber of commerce number of the Exact Online division. |
DivisionCompanyIBANNumber |
string(50) |
Division IBAN Number |
☐ |
IBAN number of the Exact Online division. |
DivisionCompanyName |
string(50) |
Division Company Name |
☑ |
Company name of the Exact Online division. |
DivisionCompanyRSINNumber |
string(9) |
Division RSIN Number |
☐ |
RSIN number of the Exact Online division. |
DivisionCompanyVATNumber |
string(35) |
Division VAT Number |
☐ |
VAT number of the Exact Online division. |
DivisionCompanyWageTaxNumber |
string(60) |
Division Wage Tax Number |
☐ |
Wage tax number of the Exact Online division. |
DivisionLabel |
string(128) |
Division Label |
☑ |
Label of the Exact Online division. |
DivisionName |
string(50) |
Administration Name |
☑ |
Name of the Exact Online division. |
DivisionOwnerCompanyName |
string(50) |
Subscription Holder Name |
☑ |
Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionOwnerCompanyNumber |
string(18) |
Subscription Holder Number |
☑ |
Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionShortName |
int64 |
Division Short Name |
☑ |
Short name of the Exact Online division. |
Employee |
guid |
Employee |
☐ |
Employee ID. |
EmployeeFullName |
string(240) |
Employee Full Name |
☐ |
Name of employee. |
EmployeeHID |
int32 |
Employee HID |
☐ |
Numeric number of Employee. |
EndDate |
datetime |
End Date |
☐ |
End date of employment. |
HID |
int32 |
HID |
☐ |
Numeric ID of the employment. |
ID |
guid |
ID |
☑ |
Primary key. |
Modified |
datetime |
Modified |
☐ |
Last modified date. |
ModifiedUtc |
datetime |
Modified (UTC) |
☐ |
Last modified date in UTC. |
Modifier |
guid |
Modifier |
☐ |
User ID of modifier. |
ModifierFullName |
string(240) |
Modified Full Name |
☐ |
Name of modifier. |
ReasonEnd |
int32 |
|
☐ |
ID of employment ended. |
ReasonEndDescription |
string |
|
☐ |
Reason of end of employment. |
ReasonEndFlex |
int32 |
|
☐ |
Reason of ended flexible employment. |
ReasonEndFlexDescription |
string |
|
☐ |
Other reason for end of employment. |
StartDate |
datetime |
Start Date |
☐ |
Start date of employment. |
StartDateOrganization |
datetime |
|
☐ |
Start date of the employee in the organization. This field is used to count the years in service. |
15-06-2022 19:32 Version 22.0.232-PROD+3445
