invantive documentation
Invantive Support ForumsLog In / Sign Up

profit_organizationchart: AFAS Profit itgen_aoe_profit_organizationchart

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: itgen_aoe_profit_organizationchart

Can only retrieve data.

Summary

Profit_OrganizationChart

API Source

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

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_organizationchart 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
enddate datetime Einddatum organigram fetched only when named, EndDate
level varchar2(10) Laag fetched only when named, Level
level0 varchar2(10) Laag 0 fetched only when named, Level0
level1 varchar2(10) Laag 1 fetched only when named, Level1
level2 varchar2(10) Laag 2 fetched only when named, Level2
level3 varchar2(10) Laag 3 fetched only when named, Level3
level4 varchar2(10) Laag 4 fetched only when named, Level4
level5 varchar2(10) Laag 5 fetched only when named, Level5
level6 varchar2(10) Laag 6 fetched only when named, Level6
level7 varchar2(10) Laag 7 fetched only when named, Level7
level8 varchar2(10) Laag 8 fetched only when named, Level8
level9 varchar2(10) Laag 9 fetched only when named, Level9
manager varchar2(54) Actuele hoofdleidinggevende fetched only when named, Manager
startdate datetime Begindatum organigram fetched only when named, StartDate
unitd varchar2(10) Organisatorische eenheid fetched only when named, Unitd
unitdesc varchar2(50) Omschrijving fetched only when named, UnitDesc
upperunit varchar2(10) Bovenliggende org. eenheid fetched only when named, UpperUnit