# knsubject_knsubjectlink
Dossier: KnSubjectLink
- Catalog: `AfasOnline`
- Schema: `UpdateConnector`
- Retrieve: False
- Insert: True
- Update: False
- Delete: False
## 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.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `abid` | `int32` | Verzuimmelding | | |
| `apid` | `int32` | Sollicitatie | | |
| `batc` | `varchar2(100)` | Partijnummer | | |
| `bcid` | `varchar2(15)` | Organisatie/persoon | | |
| `biid` | `varchar2(40)` | Itemcode | | |
| `caid` | `int32` | Campagne | | |
| `ccsn` | `int32` | Vervoermiddel | | |
| `cdid` | `int32` | Contact | | |
| `cfid` | `int32` | Control framework regel | | |
| `cfmi` | `varchar2(14)` | Beheersmaatregel | | |
| `cfri` | `int32` | Rapportage-eis | | |
| `cono` | `varchar2(16)` | Contract | | |
| `crid` | `int32` | Cursusevenement | | |
| `dcid` | `varchar2(16)` | Declaratienummer | | |
| `docrm` | `char` | Save in CRM Subject | | |
| `dvsn` | `int32` | Dienstverband | | |
| `fasn` | `int32` | Actief | | |
| `fiye` | `int32` | Fiscaal jaar | | |
| `fosn` | `int32` | Forecast | | |
| `gore` | `varchar2(12)` | Ontvangst | | |
| `loid` | `varchar2(25)` | Locatie | | |
| `olnu` | `varchar2(12)` | Optiekeuzelijst | | |
| `ornu` | `varchar2(12)` | Pakbon | | |
| `ou` | `varchar2(10)` | Organisatorische eenheid | | |
| `paid` | `varchar2(15)` | Prijsafspraak | | |
| `pcid` | `varchar2(12)` | Plaatsing | | |
| `piid` | `varchar2(12)` | Inkoopfactuur | | |
| `pitp` | `int32` | Factuurtype (inkoop) | | |
| `piun` | `int32` | Administratie (Inkoop) | | |
| `pjid` | `varchar2(15)` | Project | | |
| `plid` | `int32` | Salarisverwerkingsplan | | |
| `pnid` | `int32` | Periodeafsluitingsregel | | |
| `por` | `varchar2(12)` | Inkooporder | | |
| `pqu` | `varchar2(12)` | Inkoopofferte | | |
| `quid` | `varchar2(21)` | Voorcalculatie | | |
| `rlid` | `varchar2(25)` | Rol | | |
| `sbid` | `int32` | Dossieritem | | |
| `scid` | `varchar2(6)` | Budgetscenario | | |
| `seid` | `int32` | Sessie | | |
| `seri` | `varchar2(100)` | Serienummer | | |
| `sfid` | `varchar2(50)` | Bestemming | | |
| `sftp` | `int32` | Type bestemming | | |
| `siid` | `varchar2(12)` | Verkoopfactuur | | |
| `sitp` | `int32` | Factuurtype (verkoop) | | |
| `siun` | `int32` | Administratie (Verkoop) | | |
| `sjid` | `int32` | Dossieritem | | |
| `sor` | `varchar2(12)` | Verkooporder | | |
| `squ` | `varchar2(12)` | Verkoopofferte | | |
| `sunr` | `int32` | Abonnement | | |
| `toap` | `char` | Sollicitant | | |
| `tobc` | `char` | Organisatie/persoon | | |
| `tocl` | `char` | Cliënt IB | | |
| `tocv` | `char` | Cliënt Vpb | | |
| `toem` | `char` | Medewerker | | |
| `toer` | `char` | Werkgever | | |
| `toob` | `char` | Cliënt OB | | |
| `topr` | `char` | Inkooprelatie | | |
| `tosr` | `char` | Verkooprelatie | | |
| `unsc` | `int32` | Adm. budgetscenario | | |
| `vait` | `varchar2(20)` | Type item | | |
| `year` | `int32` | Jaar | | |