invantive documentation
Invantive Support ForumsLog In / Sign Up

knappointment: AFAS Profit itgen_aoe_knappointment

insert update delete REST

  • Catalog: AfasOnline
  • Schema: UpdateConnector
  • Label: itgen_aoe_knappointment

Afspraak

Can retrieve data and change data using insert, update and delete.

API Source

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

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 knappointment 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
apid int32 Afspraak fetched only when named, ApId
apit varchar2(20) Technische type afspraak fetched only when named, ApIt
appe char Persoonlijk fetched only when named, ApPe
apty int32 Type afspraak fetched only when named, ApTy
body varchar2 Inhoud fetched only when named, Body
dafr datetime Vanaf fetched only when named, DaFr
dati datetime Tot fetched only when named, DaTi
fri char Vrijdag fetched only when named, Fri
isre char Repeterende afspraak fetched only when named, IsRe
link varchar2(255) Link fetched only when named, Link
loid varchar2(25) Locatie fetched only when named, LoId
lotx varchar2(255) Locatie anders fetched only when named, LoTx
mon char Maandag fetched only when named, Mon
rein int32 Terugkeerpatroon interval fetched only when named, ReIn
reti datetime Einddatum reeks fetched only when named, ReTi
sat char Zaterdag fetched only when named, Sat
sbid int32 Dossieritem fetched only when named, SbId
sbj varchar2(100) Onderwerp fetched only when named, Sbj
stem char Notificatie e-mail naar interne genodigden sturen fetched only when named, StEm
sun char Zondag fetched only when named, Sun
thu char Donderdag fetched only when named, Thu
tue char Dinsdag fetched only when named, Tue
wed char Woensdag fetched only when named, Wed