invantive documentation
Invantive Support ForumsLog In / Sign Up

afaspocket_leave_balance: AFAS Profit Leave Balances

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: Leave Balances

Can only retrieve data.

Summary

AFASPocket_Leave_Balance

API Source

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

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_leave_balance 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
balance_days number Saldo (dagen) fetched only when named, balance_days
balance_hours number Saldo fetched only when named, balance_hours
leave_type varchar2(100) Type verlof fetched only when named, leave_type
username varchar2(15) Medewerker fetched only when named, username
year int32 Boekjaar fetched only when named, year