invantive documentation
Invantive Support ForumsLog In / Sign Up

knsubject_kns49: AFAS Profit itgen_aoe_knsubject_kns49

insert REST

  • Catalog: AfasOnline
  • Schema: UpdateConnector
  • Label: itgen_aoe_knsubject_kns49

Dossier: KnS49

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_kns49 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
u54f73168ea27456fabbfda7433615b22 varchar2(20) Reden contactmoment fetched only when named, U54F73168EA27456FABBFDA7433615B22
u7b279263feff41649bf6174523d7af22 varchar2(20) Type contact fetched only when named, U7B279263FEFF41649BF6174523D7AF22
u7caac728b7de468c808ace401b497d9d char Collega aanwezig fetched only when named, U7CAAC728B7DE468C808ACE401B497D9D
u84e1ade4ea464891811546c70a90019a varchar2(20) Soort contact fetched only when named, U84E1ADE4EA464891811546C70A90019A
u92632e052d724071b5b8725141aca9ca datetime Datum contact fetched only when named, U92632E052D724071B5B8725141ACA9CA
ub70ebb1096054cb0919714719f4b6113 varchar2(255) Korte omschrijving fetched only when named, UB70EBB1096054CB0919714719F4B6113
ue67007e7ef6f45a3b4a5a709b76fb990 datetime Volgend contactmoment fetched only when named, UE67007E7EF6F45A3B4A5A709B76FB990
ued10c58f961a4a7f93bbf4a95221e8a1 varchar2 Extra toelichting fetched only when named, UED10C58F961A4A7F93BBF4A95221E8A1