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 |
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 |
Link | fetched only when named, Link |
||
loid |
varchar2 |
Locatie | fetched only when named, LoId |
||
lotx |
varchar2 |
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 |
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 |