knpurchaserelationorg: AFAS Profit itgen_aoe_knpurchaserelationorg
insert update delete REST
- Catálogo:
AfasOnline - Esquema:
UpdateConnector - Etiqueta: itgen_aoe_knpurchaserelationorg
Inkooprelatie organisatie
Permite recuperar y modificar datos utilizando insert, update y delete.
Fuente de la API
- Punto final:
/connectors/KnPurchaseRelationOrg - Metadatos:
metainfo/update/KnPurchaseRelationOrg
Características de rendimiento
| Characteristic | Value |
|---|---|
| Latencia media de acceso (ms) | 353 |
| Número de filas escaneadas por minuto | 65,100 |
| Número de filas de queries puntuales por minuto | 169 |
El resultado se puede almacenar en la Caché del cliente.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla knpurchaserelationorg. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | 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 |