invantive documentation
Invantive Support ForumsLog In / Sign Up

profit_hourtype: AFAS Profit Hour Types

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: Hour Types

Can only retrieve data.

Summary

Profit_Hourtype

API Source

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

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_hourtype 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
createdate datetime Aangemaakt op fetched only when named, CreateDate
description varchar2(30) Omschrijving fetched only when named, Description
modifieddate datetime Gewijzigd op fetched only when named, ModifiedDate
timecode varchar2(5) Urensoort fetched only when named, TimeCode
timetype varchar2(100) Uurtype fetched only when named, TimeType