invantive documentation
Invantive Support ForumsLog In / Sign Up

afaspocket_timesheets: AFAS Profit Timesheets

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: Timesheets

Can only retrieve data.

Summary

AFASPocket_Timesheets

API Source

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

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_timesheets 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
activity_id varchar2(40) Itemcode fetched only when named, activity_id
date datetime Datum fetched only when named, date
id int32 Regelnummer fetched only when named, id
medewerker varchar2(15) Medewerker fetched only when named, Medewerker
project_id varchar2(15) Project fetched only when named, project_id
quantity number Aantal fetched only when named, quantity