Schedules: Exact Online Schema's |
Catalogus: ExactOnlineREST
Schema: HRM
Primaire Sleutels: ID
Label: Schema's
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel Schedules worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
Active |
int16 |
Actief |
☐ |
Obsolete. |
AverageHours |
double |
Gemiddelde Uren |
☐ |
Average hours per week in a schedule. |
BillabilityTarget |
double |
Facturabiliteitsdoelstelling |
☐ |
|
Code |
string |
Code |
☑ |
Schedule code. |
Created |
datetime |
Gemaakt |
☐ |
Creation date. |
CreatedUtc |
datetime |
Aangemaakt (UTC) |
☐ |
Creation date in UTC. |
Creator |
guid |
Aanmaker |
☐ |
User ID of creator. |
CreatorFullName |
string(240) |
Aanmaker Volledige Naam |
☐ |
Name of creator. |
Days |
double |
{res:itgen_eol_days} |
☐ |
Average days per week in the schedule. |
Description |
string |
Omschrijving |
☐ |
Description of the schedule. |
Division |
int32 |
Divisie |
☐ |
Division code. |
DivisionCompanyCoCNumber |
string(60) |
Divisie Kamer van Koophandel Nummer |
☐ |
Chamber of commerce number of the Exact Online division. |
DivisionCompanyIBANNumber |
string(50) |
Divisie IBAN Nummer |
☐ |
IBAN number of the Exact Online division. |
DivisionCompanyName |
string(50) |
Divisie Bedrijfsnaam |
☑ |
Company name of the Exact Online division. |
DivisionCompanyRSINNumber |
string(9) |
Divisie RSIN Nummer |
☐ |
RSIN number of the Exact Online division. |
DivisionCompanyVATNumber |
string(35) |
Divisie BTW Nummer |
☐ |
VAT number of the Exact Online division. |
DivisionCompanyWageTaxNumber |
string(60) |
Divisie Loonbelastingnummer |
☐ |
Wage tax number of the Exact Online division. |
DivisionLabel |
string(128) |
Divisie Label |
☑ |
Label of the Exact Online division. |
DivisionName |
string(50) |
Administratie Naam |
☑ |
Name of the Exact Online division. |
DivisionOwnerCompanyName |
string(50) |
Naam Abonnementhouder |
☑ |
Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionOwnerCompanyNumber |
string(18) |
Abonnementhoudernummer |
☑ |
Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionShortName |
int64 |
Divisie Korte Naam |
☑ |
Short name of the Exact Online division. |
Employee |
guid |
Medewerker |
☐ |
|
EmployeeFullName |
string |
Medewerker Volledige Naam |
☐ |
|
Employment |
guid |
Dienstverband |
☐ |
Employment ID for schedule. |
EmploymentCLA |
guid |
{res:itgen_eol_employmentcla} |
☐ |
|
EmploymentHID |
int32 |
Dienstverbandnummer |
☐ |
Employment number. |
EmploymentNumber |
int32 |
{res:itgen_eol_employmentnumber} |
☑ |
|
EndDate |
datetime |
Einddatum |
☐ |
End date of the schedule. |
Hours |
double |
Uren |
☐ |
Number of hours per week in a CLA for which the schedule is built. |
ID |
guid |
ID |
☑ |
Primary key. |
LeaveHoursCompensation |
double |
Verlaat Compensatie (uren) |
☐ |
Number of hours which are built up each week for later leave. |
Main |
int16 |
Hoofd |
☐ |
Indication if the schedule is a main schedule for a CLA. 1 = Yes, 0 = No. |
Modified |
datetime |
Gewijzigd |
☐ |
Last modified date. |
ModifiedUtc |
datetime |
Gewijzigd (UTC) |
☐ |
Last modified date in UTC. |
Modifier |
guid |
Wijziger |
☐ |
User ID of modifier. |
ModifierFullName |
string(240) |
Gewijzigd Volledige Naam |
☐ |
Name of modifier. |
PaymentParttimeFactor |
double |
Betaling Parttime Factor |
☐ |
Part-time factor for payroll calculation. Value between 0 and 1. |
ScheduleType |
int32 |
Planning 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) |
Plan Type Omschrijving |
☐ |
Description of the schedule type. |
StartDate |
datetime |
Startdatum |
☐ |
Week in the schedule which is used to start with. By default the number will be 1. |
StartWeek |
int32 |
Startweek |
☐ |
Week to start the schedule from for an employee. |
24-06-2025 18:54 Versie 24.1.116-BETA+5455