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

# knpurchaserelationorg: AFAS Profit itgen_aoe_knpurchaserelationorg

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

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

Inkooprelatie organisatie

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

## API-Quelle

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

## 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 `knpurchaserelationorg` 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 |
|---|---|---|:---:|---|---|
| `aliacnc` | `varchar2(16)` | ALiAcNc | [ ] | fetched only when named, `ALiAcNc` |  |
| `aupa` | `char` | Automatisch betalen | [ ] | fetched only when named, `AuPa` |  |
| `baac` | `varchar2(40)` | Voorkeur bank-/gironummer | [ ] | fetched only when named, `BaAc` |  |
| `bcby` | `varchar2(15)` | Aangebracht door | [ ] | fetched only when named, `BcBy` |  |
| `bl` | `char` | Tijdelijk blokkeren | [ ] | fetched only when named, `Bl` |  |
| `bltl` | `char` | Volledig blokkeren, niet meer zichtbaar | [ ] | fetched only when named, `BlTl` |  |
| `clpc` | `number` | Kredietbeperking (%) | [ ] | fetched only when named, `ClPc` |  |
| `coid` | `varchar2(3)` | Voorkeur bank-/gironummer land code | [ ] | fetched only when named, `CoId` |  |
| `cola` | `varchar2(16)` | Verzamelrekening | [ ] | fetched only when named, `ColA` |  |
| `cosu` | `char` | Facturering via voorfactuur | [ ] | fetched only when named, `CoSu` |  |
| `crid` | `varchar2(16)` | Nummer crediteur | [ ] | fetched only when named, `CrId` |  |
| `csda` | `datetime` | Leverancier sinds | [ ] | fetched only when named, `CsDa` |  |
| `csty` | `varchar2(1)` | CBS-typen | [ ] | fetched only when named, `CsTy` |  |
| `cti1` | `int32` | Voorkeur contact | [ ] | fetched only when named, `CtI1` |  |
| `ctp1` | `int32` | Contactpersoon | [ ] | fetched only when named, `CtP1` |  |
| `ctp2` | `int32` | Extra contactpersoon | [ ] | fetched only when named, `CtP2` |  |
| `cuid` | `varchar2(3)` | Valuta | [ ] | fetched only when named, `CuId` |  |
| `dble` | `varchar2(14)` | Nr. debiteur (leverancier) | [ ] | fetched only when named, `DbLe` |  |
| `dda1` | `char` | Besteldag maandag | [ ] | fetched only when named, `DDa1` |  |
| `dda2` | `char` | Besteldag dinsdag | [ ] | fetched only when named, `DDa2` |  |
| `dda3` | `char` | Besteldag woensdag | [ ] | fetched only when named, `DDa3` |  |
| `dda4` | `char` | Besteldag donderdag | [ ] | fetched only when named, `DDa4` |  |
| `dda5` | `char` | Besteldag vrijdag | [ ] | fetched only when named, `DDa5` |  |
| `dda6` | `char` | Besteldag zaterdag | [ ] | fetched only when named, `DDa6` |  |
| `dda7` | `char` | Besteldag zondag | [ ] | fetched only when named, `DDa7` |  |
| `dde1` | `int32` | Aantal leverdagen maandag | [ ] | fetched only when named, `DDe1` |  |
| `dde2` | `int32` | Aantal leverdagen dinsdag | [ ] | fetched only when named, `DDe2` |  |
| `dde3` | `int32` | Aantal leverdagen woensdag | [ ] | fetched only when named, `DDe3` |  |
| `dde4` | `int32` | Aantal leverdagen donderdag | [ ] | fetched only when named, `DDe4` |  |
| `dde5` | `int32` | Aantal leverdagen vrijdag | [ ] | fetched only when named, `DDe5` |  |
| `dde6` | `int32` | Aantal leverdagen zaterdag | [ ] | fetched only when named, `DDe6` |  |
| `dde7` | `int32` | Aantal leverdagen zondag | [ ] | fetched only when named, `DDe7` |  |
| `deca` | `char` | Bestel- en leverkalender toepassen | [ ] | fetched only when named, `DeCa` |  |
| `dsgr` | `varchar2(5)` | Kortingsgroep | [ ] | fetched only when named, `DsGr` |  |
| `dti1` | `datetime` | Bestellen voor maandag | [ ] | fetched only when named, `DTi1` |  |
| `dti2` | `datetime` | Bestellen voor dinsdag | [ ] | fetched only when named, `DTi2` |  |
| `dti3` | `datetime` | Bestellen voor woensdag | [ ] | fetched only when named, `DTi3` |  |
| `dti4` | `datetime` | Bestellen voor donderdag | [ ] | fetched only when named, `DTi4` |  |
| `dti5` | `datetime` | Bestellen voor vrijdag | [ ] | fetched only when named, `DTi5` |  |
| `dti6` | `datetime` | Bestellen voor zaterdag | [ ] | fetched only when named, `DTi6` |  |
| `dti7` | `datetime` | Bestellen voor zondag | [ ] | fetched only when named, `DTi7` |  |
| `enid` | `varchar2(50)` | Bedrijfs-Id eVerbinding | [ ] | fetched only when named, `EnId` |  |
| `fico` | `varchar2(20)` | Landcode fiche 281.50 | [ ] | fetched only when named, `FiCo` |  |
| `ib47` | `char` | UBD - Uitbetaalde Bedragen aan Derden | [ ] | fetched only when named, `IB47` |  |
| `iban` | `varchar2(40)` | Voorkeur Iban nummer | [ ] | fetched only when named, `Iban` |  |
| `inpv` | `varchar2(20)` | Voorkeur verstrekkingswijze | [ ] | fetched only when named, `InPv` |  |
| `iscr` | `char` | Is crediteur | [ ] | fetched only when named, `IsCr` |  |
| `ivju` | `varchar2(15)` | Beoordelaar | [ ] | fetched only when named, `IvJu` |  |
| `kbon` | `varchar2(12)` | KBO-nummer | [ ] | fetched only when named, `KBOn` |  |
| `krli` | `number` | Kredietlimiet | [ ] | fetched only when named, `Krli` |  |
| `lgid` | `varchar2(5)` | Taal | [ ] | fetched only when named, `LgId` |  |
| `orid` | `varchar2(15)` | Besteller | [ ] | fetched only when named, `OrId` |  |
| `pacd` | `varchar2(5)` | Betaalvoorwaarde | [ ] | fetched only when named, `PaCd` |  |
| `paco` | `char` | Verdichten | [ ] | fetched only when named, `PaCo` |  |
| `pasp` | `char` | Betaalspecificatie | [ ] | fetched only when named, `PaSp` |  |
| `paym` | `varchar2(20)` | Betaalwijze | [ ] | fetched only when named, `PayM` |  |
| `pedr` | `number` | Opslag/korting % | [ ] | fetched only when named, `PeDR` |  |
| `pfid` | `varchar2(16)` | Profiel | [ ] | fetched only when named, `PfId` |  |
| `poco` | `varchar2(50)` | POP-code | [ ] | fetched only when named, `PoCo` |  |
| `preaxpcma` | `number` | PReAxPcMa | [ ] | fetched only when named, `PReAxPcMa` |  |
| `preaxunid` | `int32` | PReAxUnId | [ ] | fetched only when named, `PReAxUnId` |  |
| `preaxvaid` | `varchar2(3)` | PReAxVaId | [ ] | fetched only when named, `PReAxVaId` |  |
| `preaxvbc2` | `varchar2(16)` | PReAxVbC2 | [ ] | fetched only when named, `PReAxVbC2` |  |
| `preaxvbc4` | `varchar2(16)` | PReAxVbC4 | [ ] | fetched only when named, `PReAxVbC4` |  |
| `prfc` | `number` | Factuurkorting (%) | [ ] | fetched only when named, `PrFc` |  |
| `prli` | `number` | % Regelkorting | [ ] | fetched only when named, `PrLi` |  |
| `prls` | `varchar2(5)` | Voorkeur prijslijst | [ ] | fetched only when named, `PrLs` |  |
| `prof` | `varchar2(80)` | Beroep | [ ] | fetched only when named, `Prof` |  |
| `prpt` | `number` | Betalingskorting (%) | [ ] | fetched only when named, `PrPt` |  |
| `prvn` | `varchar2(16)` | Prijzen van | [ ] | fetched only when named, `PrVn` |  |
| `rm` | `varchar2` | Opmerking | [ ] | fetched only when named, `Rm` |  |
| `spiv` | `char` | Verkoopprijs inclusief btw | [ ] | fetched only when named, `SpIV` |  |
| `toac` | `varchar2(16)` | Voorkeur tegenrekening | [ ] | fetched only when named, `ToAc` |  |
| `vaa1` | `varchar2(10)` | VaA1 | [ ] | fetched only when named, `VaA1` |  |
| `vaa2` | `varchar2(10)` | VaA2 | [ ] | fetched only when named, `VaA2` |  |
| `vaa3` | `varchar2(10)` | VaA3 | [ ] | fetched only when named, `VaA3` |  |
| `vaa4` | `varchar2(10)` | VaA4 | [ ] | fetched only when named, `VaA4` |  |
| `vaa5` | `varchar2(10)` | VaA5 | [ ] | fetched only when named, `VaA5` |  |
| `vadu` | `varchar2(3)` | Btw-plicht | [ ] | fetched only when named, `VaDu` |  |
| `vaid` | `varchar2(21)` | Btw-identificatienummer | [ ] | fetched only when named, `VaId` |  |
| `vaig` | `varchar2(20)` | Code groepsadministratie | [ ] | fetched only when named, `VaIg` |  |
| `vatp` | `varchar2(20)` | Type inkooprelatie | [ ] | fetched only when named, `VaTp` |  |
| `vayn` | `char` | Afwijkende btw-tariefgroep | [ ] | fetched only when named, `VaYN` |  |
| `veid` | `varchar2(16)` | Inkoper | [ ] | fetched only when named, `VeId` |  |
| `vifc` | `varchar2(20)` | Categorie fiche 281.50 | [ ] | fetched only when named, `ViFc` |  |
| `vifs` | `varchar2(20)` | Fiche 281.50 subcategorie | [ ] | fetched only when named, `ViFs` |  |
| `vkma` | `varchar2(15)` | Voorkeur magazijn | [ ] | fetched only when named, `VkMa` |  |
| `waor` | `char` | Waarschuwing bij order/offerte | [ ] | fetched only when named, `WaOr` |  |
| `watx` | `varchar2(255)` | Tekst waarschuwing | [ ] | fetched only when named, `WaTx` |  |
| `wiof` | `varchar2(80)` | Echtgenote van | [ ] | fetched only when named, `WiOf` |  |
