---
title: "knsubject_knsubjectlink (AFAS Profit)"
description: "itgen_aoe_knsubject_knsubjectlink"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/afas/AfasOnline.UpdateConnector.knsubject_knsubjectlink
original: https://documentation.invantive.eu/en/datamodels/afas/AfasOnline.UpdateConnector.knsubject_knsubjectlink
updated: 2026-11-07T09:24:19Z
license: https://documentation.invantive.eu/en/
---

# knsubject_knsubjectlink: AFAS Profit itgen_aoe_knsubject_knsubjectlink

`insert` `REST`

- Catalog: `AfasOnline`
- Schema: `UpdateConnector`
- Label: itgen_aoe_knsubject_knsubjectlink

Dossier: KnSubjectLink

Can retrieve data and change data using `insert`.

## 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_knsubjectlink` 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 |
|---|---|---|:---:|---|---|
| `abid` | `int32` | Verzuimmelding | [ ] | fetched only when named, `AbId` |  |
| `apid` | `int32` | Sollicitatie | [ ] | fetched only when named, `ApId` |  |
| `batc` | `varchar2(100)` | Partijnummer | [ ] | fetched only when named, `Batc` |  |
| `bcid` | `varchar2(15)` | Organisatie/persoon | [ ] | fetched only when named, `BcId` |  |
| `biid` | `varchar2(40)` | Itemcode | [ ] | fetched only when named, `BiId` |  |
| `caid` | `int32` | Campagne | [ ] | fetched only when named, `CaId` |  |
| `ccsn` | `int32` | Vervoermiddel | [ ] | fetched only when named, `CcSn` |  |
| `cdid` | `int32` | Contact | [ ] | fetched only when named, `CdId` |  |
| `cfid` | `int32` | Control framework regel | [ ] | fetched only when named, `CfId` |  |
| `cfmi` | `varchar2(14)` | Beheersmaatregel | [ ] | fetched only when named, `CfMI` |  |
| `cfri` | `int32` | Rapportage-eis | [ ] | fetched only when named, `CfRI` |  |
| `cono` | `varchar2(16)` | Contract | [ ] | fetched only when named, `CoNo` |  |
| `crid` | `int32` | Cursusevenement | [ ] | fetched only when named, `CrId` |  |
| `dcid` | `varchar2(16)` | Declaratienummer | [ ] | fetched only when named, `DcId` |  |
| `docrm` | `char` | Save in CRM Subject | [ ] | fetched only when named, `DoCRM` |  |
| `dvsn` | `int32` | Dienstverband | [ ] | fetched only when named, `DvSn` |  |
| `fasn` | `int32` | Actief | [ ] | fetched only when named, `FaSn` |  |
| `fiye` | `int32` | Fiscaal jaar | [ ] | fetched only when named, `FiYe` |  |
| `fosn` | `int32` | Forecast | [ ] | fetched only when named, `FoSn` |  |
| `gore` | `varchar2(12)` | Ontvangst | [ ] | fetched only when named, `GoRe` |  |
| `loid` | `varchar2(25)` | Locatie | [ ] | fetched only when named, `LoId` |  |
| `olnu` | `varchar2(12)` | Optiekeuzelijst | [ ] | fetched only when named, `OlNu` |  |
| `ornu` | `varchar2(12)` | Pakbon | [ ] | fetched only when named, `OrNu` |  |
| `ou` | `varchar2(10)` | Organisatorische eenheid | [ ] | fetched only when named, `Ou` |  |
| `paid` | `varchar2(15)` | Prijsafspraak | [ ] | fetched only when named, `PAId` |  |
| `pcid` | `varchar2(12)` | Plaatsing | [ ] | fetched only when named, `PcId` |  |
| `piid` | `varchar2(12)` | Inkoopfactuur | [ ] | fetched only when named, `PiId` |  |
| `pitp` | `int32` | Factuurtype (inkoop) | [ ] | fetched only when named, `PiTp` |  |
| `piun` | `int32` | Administratie (Inkoop) | [ ] | fetched only when named, `PiUn` |  |
| `pjid` | `varchar2(15)` | Project | [ ] | fetched only when named, `PjId` |  |
| `plid` | `int32` | Salarisverwerkingsplan | [ ] | fetched only when named, `PlId` |  |
| `pnid` | `int32` | Periodeafsluitingsregel | [ ] | fetched only when named, `PnId` |  |
| `por` | `varchar2(12)` | Inkooporder | [ ] | fetched only when named, `Por` |  |
| `pqu` | `varchar2(12)` | Inkoopofferte | [ ] | fetched only when named, `Pqu` |  |
| `quid` | `varchar2(21)` | Voorcalculatie | [ ] | fetched only when named, `QuId` |  |
| `rlid` | `varchar2(25)` | Rol | [ ] | fetched only when named, `RlId` |  |
| `sbid` | `int32` | Dossieritem | [ ] | fetched only when named, `SbId` |  |
| `scid` | `varchar2(6)` | Budgetscenario | [ ] | fetched only when named, `ScId` |  |
| `seid` | `int32` | Sessie | [ ] | fetched only when named, `SeId` |  |
| `seri` | `varchar2(100)` | Serienummer | [ ] | fetched only when named, `Seri` |  |
| `sfid` | `varchar2(50)` | Bestemming | [ ] | fetched only when named, `SfId` |  |
| `sftp` | `int32` | Type bestemming | [ ] | fetched only when named, `SfTp` |  |
| `siid` | `varchar2(12)` | Verkoopfactuur | [ ] | fetched only when named, `SiId` |  |
| `sitp` | `int32` | Factuurtype (verkoop) | [ ] | fetched only when named, `SiTp` |  |
| `siun` | `int32` | Administratie (Verkoop) | [ ] | fetched only when named, `SiUn` |  |
| `sjid` | `int32` | Dossieritem | [ ] | fetched only when named, `SjId` |  |
| `sor` | `varchar2(12)` | Verkooporder | [ ] | fetched only when named, `Sor` |  |
| `squ` | `varchar2(12)` | Verkoopofferte | [ ] | fetched only when named, `Squ` |  |
| `sunr` | `int32` | Abonnement | [ ] | fetched only when named, `SuNr` |  |
| `toap` | `char` | Sollicitant | [ ] | fetched only when named, `ToAp` |  |
| `tobc` | `char` | Organisatie/persoon | [ ] | fetched only when named, `ToBC` |  |
| `tocl` | `char` | Cliënt IB | [ ] | fetched only when named, `ToCl` |  |
| `tocv` | `char` | Cliënt Vpb | [ ] | fetched only when named, `ToCV` |  |
| `toem` | `char` | Medewerker | [ ] | fetched only when named, `ToEm` |  |
| `toer` | `char` | Werkgever | [ ] | fetched only when named, `ToEr` |  |
| `toob` | `char` | Cliënt OB | [ ] | fetched only when named, `ToOb` |  |
| `topr` | `char` | Inkooprelatie | [ ] | fetched only when named, `ToPR` |  |
| `tosr` | `char` | Verkooprelatie | [ ] | fetched only when named, `ToSR` |  |
| `unsc` | `int32` | Adm. budgetscenario | [ ] | fetched only when named, `UnSc` |  |
| `vait` | `varchar2(20)` | Type item | [ ] | fetched only when named, `VaIt` |  |
| `year` | `int32` | Jaar | [ ] | fetched only when named, `Year` |  |

