---
title: "knsubject (AFAS Profit)"
description: "itgen_aoe_knsubject"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/afas/AfasOnline.UpdateConnector.knsubject
original: https://documentation.invantive.eu/en/datamodels/afas/AfasOnline.UpdateConnector.knsubject
updated: 2026-11-17T12:41:32Z
license: https://documentation.invantive.eu/de/
---

# knsubject: AFAS Profit itgen_aoe_knsubject

`insert` `update` `delete` `REST`

- Katalog: `AfasOnline`
- Schema: `UpdateConnector`
- Bezeichnung: itgen_aoe_knsubject

Dossier

Mit `insert`, `update` und `delete` können Daten abgerufen und geändert werden.

## API-Quelle

- Endpunkt: `/connectors/KnSubject`
- Metadaten: `metainfo/update/KnSubject`

## Leistungsmerkmale

| Characteristic | Value |
|---|---:|
| Durchschnittliche Zugriffsverzögerung (ms) | 353 |
| Anzahl der Vollscan-Zeilen pro Minute | 65,100 |
| Anzahl der Query-Zeilen pro Minute | 169 |

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

## Tabellenspalten

Die Spalten der Tabelle `knsubject` sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

| Name | Datentyp | 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` | Profil-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` |  |
