invantive documentation
Invantive Support ForumsLog In / Sign Up

profit_timetable: AFAS Profit itgen_aoe_profit_timetable

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: itgen_aoe_profit_timetable

Can only retrieve data.

Summary

Profit_Timetable

API Source

  • Endpoint: /connectors/Profit_Timetable
  • Metadata: metainfo/get/Profit_Timetable

Performance Characteristics

Characteristic Value
Average access latency (ms) 353
Full scan rows per minute 65,100
Point query rows per minute 169

The result can be cached on the client.

Table Columns

The columns of the table profit_timetable 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 and update.

Name Data Type Label Required Marks Documentation
daysperweek number Aantal dagen per week fetched only when named, DaysPerWeek
employeeid varchar2(15) Medewerker fetched only when named, EmployeeId
employerid varchar2(15) Werkgever fetched only when named, EmployerId
enddate datetime Einddatum rooster fetched only when named, EndDate
hoursperweek number Aantal uren per week fetched only when named, HoursPerWeek
maxhours number Maximum uren per week fetched only when named, MaxHours
minhours number Minimum uren per week fetched only when named, MinHours
modifieddate datetime Gewijzigd op fetched only when named, ModifiedDate
parttime number Parttime (%) fetched only when named, PartTime
seqno int32 Volgnummer rooster fetched only when named, SeqNo
startdate datetime Begindatum rooster fetched only when named, StartDate
variable char Wisselend arbeidspatroon fetched only when named, Variable
variablepattern char Wisselend arbeidspatroon met werkrooster fetched only when named, VariablePattern