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 |
ALiAcNc | fetched only when named, A |
||
aupa |
char |
Automatisch betalen | fetched only when named, AuPa |
||
baac |
varchar2 |
Voorkeur bank-/gironummer | fetched only when named, BaAc |
||
bcby |
varchar2 |
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 |
Voorkeur bank-/gironummer land code | fetched only when named, CoId |
||
cola |
varchar2 |
Verzamelrekening | fetched only when named, ColA |
||
cosu |
char |
Facturering via voorfactuur | fetched only when named, CoSu |
||
crid |
varchar2 |
Nummer crediteur | fetched only when named, CrId |
||
csda |
datetime |
Leverancier sinds | fetched only when named, CsDa |
||
csty |
varchar2 |
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 |
Valuta | fetched only when named, CuId |
||
dble |
varchar2 |
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 |
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 |
Bedrijfs-Id eVerbinding | fetched only when named, EnId |
||
fico |
varchar2 |
Landcode fiche 281.50 | fetched only when named, FiCo |
||
ib47 |
char |
UBD - Uitbetaalde Bedragen aan Derden | fetched only when named, IB47 |
||
iban |
varchar2 |
Voorkeur Iban nummer | fetched only when named, Iban |
||
inpv |
varchar2 |
Voorkeur verstrekkingswijze | fetched only when named, InPv |
||
iscr |
char |
Is crediteur | fetched only when named, IsCr |
||
ivju |
varchar2 |
Beoordelaar | fetched only when named, IvJu |
||
kbon |
varchar2 |
KBO-nummer | fetched only when named, KBOn |
||
krli |
number |
Kredietlimiet | fetched only when named, Krli |
||
lgid |
varchar2 |
Taal | fetched only when named, LgId |
||
orid |
varchar2 |
Besteller | fetched only when named, OrId |
||
pacd |
varchar2 |
Betaalvoorwaarde | fetched only when named, PaCd |
||
paco |
char |
Verdichten | fetched only when named, PaCo |
||
pasp |
char |
Betaalspecificatie | fetched only when named, PaSp |
||
paym |
varchar2 |
Betaalwijze | fetched only when named, PayM |
||
pedr |
number |
Opslag/korting % | fetched only when named, PeDR |
||
pfid |
varchar2 |
Profiel | fetched only when named, PfId |
||
poco |
varchar2 |
POP-code | fetched only when named, PoCo |
||
preaxpcma |
number |
PReAxPcMa | fetched only when named, P |
||
preaxunid |
int32 |
PReAxUnId | fetched only when named, P |
||
preaxvaid |
varchar2 |
PReAxVaId | fetched only when named, P |
||
preaxvbc2 |
varchar2 |
PReAxVbC2 | fetched only when named, P |
||
preaxvbc4 |
varchar2 |
PReAxVbC4 | fetched only when named, P |
||
prfc |
number |
Factuurkorting (%) | fetched only when named, PrFc |
||
prli |
number |
% Regelkorting | fetched only when named, PrLi |
||
prls |
varchar2 |
Voorkeur prijslijst | fetched only when named, PrLs |
||
prof |
varchar2 |
Beroep | fetched only when named, Prof |
||
prpt |
number |
Betalingskorting (%) | fetched only when named, PrPt |
||
prvn |
varchar2 |
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 |
Voorkeur tegenrekening | fetched only when named, ToAc |
||
vaa1 |
varchar2 |
VaA1 | fetched only when named, VaA1 |
||
vaa2 |
varchar2 |
VaA2 | fetched only when named, VaA2 |
||
vaa3 |
varchar2 |
VaA3 | fetched only when named, VaA3 |
||
vaa4 |
varchar2 |
VaA4 | fetched only when named, VaA4 |
||
vaa5 |
varchar2 |
VaA5 | fetched only when named, VaA5 |
||
vadu |
varchar2 |
Btw-plicht | fetched only when named, VaDu |
||
vaid |
varchar2 |
Btw-identificatienummer | fetched only when named, VaId |
||
vaig |
varchar2 |
Code groepsadministratie | fetched only when named, VaIg |
||
vatp |
varchar2 |
Type inkooprelatie | fetched only when named, VaTp |
||
vayn |
char |
Afwijkende btw-tariefgroep | fetched only when named, VaYN |
||
veid |
varchar2 |
Inkoper | fetched only when named, VeId |
||
vifc |
varchar2 |
Categorie fiche 281.50 | fetched only when named, ViFc |
||
vifs |
varchar2 |
Fiche 281.50 subcategorie | fetched only when named, ViFs |
||
vkma |
varchar2 |
Voorkeur magazijn | fetched only when named, VkMa |
||
waor |
char |
Waarschuwing bij order/offerte | fetched only when named, WaOr |
||
watx |
varchar2 |
Tekst waarschuwing | fetched only when named, WaTx |
||
wiof |
varchar2 |
Echtgenote van | fetched only when named, WiOf |