Exact Online API Data Model
Schedules: Exact Online Schedules |
Catalog: ExactOnlineREST
Schema: HRM
Primary Keys: ID
Label: Schedules
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}/HRM/Schedules
Insert Exact Online API URL: /api/v1/{division}/HRM/Schedules
Update Exact Online API URL: /api/v1/{division}/HRM/Schedules
Delete Exact Online API URL: /api/v1/{division}/HRM/Schedules
Exact Online API Metadata URL: /api/v1/{division}/hrm/$metadata
Field Selection Method: Required
Table Columns
The columns of the table Schedules 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 |
|---|---|---|---|---|
Active |
int16 |
Active |
☐ |
Obsolete. |
AverageHours |
double |
Average Hours |
☐ |
Average hours per week in a schedule. |
Code |
string |
Code |
☑ |
Schedule code. |
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. |
Days |
double |
|
☐ |
Average days per week in the schedule. |
Description |
string |
Description |
☐ |
Description of the schedule. |
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. |
Employment |
guid |
Employment |
☐ |
Employment ID for schedule. |
EmploymentHID |
int32 |
Employment Number |
☐ |
Employment number. |
EndDate |
datetime |
End Date |
☐ |
End date of the schedule. |
Hours |
double |
Hours |
☐ |
Number of hours per week in a CLA for which the schedule is built. |
ID |
guid |
ID |
☑ |
Primary key. |
LeaveHoursCompensation |
double |
Leave Compensation (hours) |
☐ |
Number of hours which are built up each week for later leave. |
Main |
int16 |
Main |
☐ |
Indication if the schedule is a main schedule for a CLA. 1 = Yes, 0 = No. |
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. |
PaymentParttimeFactor |
double |
Payment Part-time Factor |
☐ |
Part-time factor for payroll calculation. Value between 0 and 1. |
ScheduleType |
int32 |
Schedule Type |
☐ |
Type of schedule. 1 = Hours and average days, 2 = Hours and specific days, 3 = Hours per day, 4 = Time frames per day. |
ScheduleTypeDescription |
string(240) |
Schedule Type Description |
☐ |
Description of the schedule type. |
StartDate |
datetime |
Start Date |
☐ |
Week in the schedule which is used to start with. By default the number will be 1. |
StartWeek |
int32 |
Start Week |
☐ |
Week to start the schedule from for an employee. |
15-06-2022 19:32 Version 22.0.232-PROD+3445
