invantive documentation
Invantive Support ForumsLog In / Sign Up

knsubject_kns09: AFAS Profit itgen_aoe_knsubject_kns09

insert REST

  • Catalog: AfasOnline
  • Schema: UpdateConnector
  • Label: itgen_aoe_knsubject_kns09

Dossier: KnS09

Can retrieve data and change data using insert.

API Source

  • Endpoint: /connectors/KnSubject
  • Metadata: metainfo/update/KnSubject

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 knsubject_kns09 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
sbid int32 Dossieritem fetched only when named, SbId
ua218a6ca4b08ec55297018c083f2d4e5 varchar2 Ervaring medewerker fetched only when named, UA218A6CA4B08EC55297018C083F2D4E5
ubcf141b641fefa0b998edfbfaca4196d datetime Datum gesprek fetched only when named, UBCF141B641FEFA0B998EDFBFACA4196D
ud13c2f574796c23637b2deabd2549685 varchar2 Reden van vertrek fetched only when named, UD13C2F574796C23637B2DEABD2549685
udbbb0d134277eb8c52e15be0bfc6c80d varchar2 Verbeterpunten fetched only when named, UDBBB0D134277EB8C52E15BE0BFC6C80D