invantive documentation
Invantive Support ForumsLog In / Sign Up

afaspocket_leaves: AFAS Profit Leaves

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: Leaves

Can only retrieve data.

Summary

AFASPocket_Leaves

API Source

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

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 afaspocket_leaves 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
comment varchar2 comment fetched only when named, comment
employment_id int32 Dienstverband fetched only when named, employment_id
end_time datetime Einddatum/-tijd fetched only when named, end_time
leave_reason_id varchar2(20) leave_reason_id fetched only when named, leave_reason_id
leave_type_id varchar2(20) leave_type_id fetched only when named, leave_type_id
mutation_id varchar2(32) Mutatie-Id fetched only when named, mutation_id
start_time datetime Begindatum/-tijd fetched only when named, start_time
status_code varchar2(20) Codetabelwaarde code fetched only when named, status_code
user_id varchar2(15) Medewerker fetched only when named, user_id