invantive documentation
Invantive Support ForumsLog In / Sign Up

knsubject: AFAS Profit itgen_aoe_knsubject

insert update delete REST

  • Catalog: AfasOnline
  • Schema: UpdateConnector
  • Label: itgen_aoe_knsubject

Dossier

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

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 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
da datetime Instuurdatum fetched only when named, Da
ds varchar2(255) Onderwerp fetched only when named, Ds
dtfr datetime Begindatum fetched only when named, DtFr
dtst datetime Datum afgehandeld fetched only when named, DtSt
dtto datetime Einddatum fetched only when named, DtTo
emid varchar2(80) Verantwoordelijke fetched only when named, EmId
feco int32 Betreft fetched only when named, FeCo
fileid varchar2(32) File Id fetched only when named, FileId
filestream blob File as byte-array fetched only when named, FileStream
filetrans char Save file with subject fetched only when named, FileTrans
fvf1 int32 Waarde kenmerk 1 fetched only when named, FvF1
fvf2 int32 Waarde kenmerk 2 fetched only when named, FvF2
fvf3 int32 Waarde kenmerk 3 fetched only when named, FvF3
markopened char Mark subject as opened fetched only when named, MarkOpened
profileid int32 Profiel ID fetched only when named, ProfileId
said varchar2(5) Type actie fetched only when named, SaId
sbbl char Geblokkeerd fetched only when named, SbBl
sbhi int32 Aanleiding fetched only when named, SbHi
sbid int32 Dossieritem fetched only when named, SbId
sbpa varchar2(255) FileName of the attachment fetched only when named, SbPa
sbtx varchar2 Toelichting fetched only when named, SbTx
scid varchar2(5) Bron fetched only when named, ScId
st char Afgehandeld fetched only when named, St
stid int32 Type dossieritem fetched only when named, StId
subjecthandler varchar2(38) HandlerId fetched only when named, SubjectHandler
usid varchar2(80) Instuurder fetched only when named, UsId
vipr varchar2(20) Prioriteit fetched only when named, ViPr