invantive documentation
Invantive Support ForumsLog In / Sign Up

knpurchaserelationper: AFAS Profit itgen_aoe_knpurchaserelationper

insert update delete REST

  • Catalog: AfasOnline
  • Schema: UpdateConnector
  • Label: itgen_aoe_knpurchaserelationper

Inkooprelatie persoon

Can retrieve data and change data using insert, update and delete.

API Source

  • Endpoint: /connectors/KnPurchaseRelationPer
  • Metadata: metainfo/update/KnPurchaseRelationPer

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 knpurchaserelationper 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
alcr char Afwijkende crediteurnaam fetched only when named, AlCr
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
crnm varchar2(80) Crediteurnaam fetched only when named, CrNm
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
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
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
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
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