invantive documentation
Invantive SupportforenAnmelden / Eintragen

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