knpurchaserelationper: AFAS Profit itgen_aoe_knpurchaserelationper
insert update delete REST
- Catalogo:
AfasOnline - Schema:
UpdateConnector - Etichetta: itgen_aoe_knpurchaserelationper
Inkooprelatie persoon
È possibile recuperare e modificare i dati utilizzando insert, update e delete.
Codice sorgente dell'API
- Punto finale:
/connectors/KnPurchaseRelationPer - Metadati:
metainfo/update/KnPurchaseRelationPer
Caratteristiche prestazionali
| Characteristic | Value |
|---|---|
| Latenza media di accesso (ms) | 353 |
| Righe di scansione completa al minuto | 65,100 |
| Numero di righe di Query al minuto | 169 |
Il risultato può essere memorizzato nella memoria cache sul client.
Colonne della tabella
Di seguito sono riportate le colonne della tabella knpurchaserelationper. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
alcr |
char |
Afwijkende crediteurnaam | fetched only when named, AlCr |
||
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 |
||
crnm |
varchar2 |
Crediteurnaam | fetched only when named, CrNm |
||
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 |
||
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 |
||
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 |
||
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 |
||
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 |