invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

knsubject: AFAS Profit itgen_aoe_knsubject

insert update delete REST

  • Catálogo: AfasOnline
  • Esquema: UpdateConnector
  • Etiqueta: itgen_aoe_knsubject

Dossier

Permite recuperar y modificar datos utilizando insert, update y delete.

Fuente de la API

  • Punto final: /connectors/KnSubject
  • Metadatos: metainfo/update/KnSubject

Características de rendimiento

Characteristic Value
Latencia media de acceso (ms) 353
Número de filas escaneadas por minuto 65,100
Número de filas de queries puntuales por minuto 169

El resultado se puede almacenar en la Caché del cliente.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla knsubject. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos 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 ID de perfil 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