knsubject_knsubjectlink: AFAS Profit itgen_aoe_knsubject_knsubjectlink
insert REST
- Katalog:
AfasOnline - Schema:
UpdateConnector - Bezeichnung: itgen_aoe_knsubject_knsubjectlink
Dossier: KnSubjectLink
Mit insert können Daten abgerufen und geändert werden.
API-Quelle
- Endpunkt:
/connectors/KnSubject - Metadaten:
metainfo/update/KnSubject
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 knsubject_knsubjectlink 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 |
|---|---|---|---|---|---|
abid |
int32 |
Verzuimmelding | fetched only when named, AbId |
||
apid |
int32 |
Sollicitatie | fetched only when named, ApId |
||
batc |
varchar2 |
Partijnummer | fetched only when named, Batc |
||
bcid |
varchar2 |
Organisatie/persoon | fetched only when named, BcId |
||
biid |
varchar2 |
Itemcode | fetched only when named, BiId |
||
caid |
int32 |
Campagne | fetched only when named, CaId |
||
ccsn |
int32 |
Vervoermiddel | fetched only when named, CcSn |
||
cdid |
int32 |
Contact | fetched only when named, CdId |
||
cfid |
int32 |
Control framework regel | fetched only when named, CfId |
||
cfmi |
varchar2 |
Beheersmaatregel | fetched only when named, CfMI |
||
cfri |
int32 |
Rapportage-eis | fetched only when named, CfRI |
||
cono |
varchar2 |
Contract | fetched only when named, CoNo |
||
crid |
int32 |
Cursusevenement | fetched only when named, CrId |
||
dcid |
varchar2 |
Declaratienummer | fetched only when named, DcId |
||
docrm |
char |
Save in CRM Subject | fetched only when named, DoCRM |
||
dvsn |
int32 |
Dienstverband | fetched only when named, DvSn |
||
fasn |
int32 |
Actief | fetched only when named, FaSn |
||
fiye |
int32 |
Fiscaal jaar | fetched only when named, FiYe |
||
fosn |
int32 |
Forecast | fetched only when named, FoSn |
||
gore |
varchar2 |
Ontvangst | fetched only when named, GoRe |
||
loid |
varchar2 |
Locatie | fetched only when named, LoId |
||
olnu |
varchar2 |
Optiekeuzelijst | fetched only when named, OlNu |
||
ornu |
varchar2 |
Pakbon | fetched only when named, OrNu |
||
ou |
varchar2 |
Organisatorische eenheid | fetched only when named, Ou |
||
paid |
varchar2 |
Prijsafspraak | fetched only when named, PAId |
||
pcid |
varchar2 |
Plaatsing | fetched only when named, PcId |
||
piid |
varchar2 |
Inkoopfactuur | fetched only when named, PiId |
||
pitp |
int32 |
Factuurtype (inkoop) | fetched only when named, PiTp |
||
piun |
int32 |
Administratie (Inkoop) | fetched only when named, PiUn |
||
pjid |
varchar2 |
Project | fetched only when named, PjId |
||
plid |
int32 |
Salarisverwerkingsplan | fetched only when named, PlId |
||
pnid |
int32 |
Periodeafsluitingsregel | fetched only when named, PnId |
||
por |
varchar2 |
Inkooporder | fetched only when named, Por |
||
pqu |
varchar2 |
Inkoopofferte | fetched only when named, Pqu |
||
quid |
varchar2 |
Voorcalculatie | fetched only when named, QuId |
||
rlid |
varchar2 |
Rol | fetched only when named, RlId |
||
sbid |
int32 |
Dossieritem | fetched only when named, SbId |
||
scid |
varchar2 |
Budgetscenario | fetched only when named, ScId |
||
seid |
int32 |
Sessie | fetched only when named, SeId |
||
seri |
varchar2 |
Serienummer | fetched only when named, Seri |
||
sfid |
varchar2 |
Bestemming | fetched only when named, SfId |
||
sftp |
int32 |
Type bestemming | fetched only when named, SfTp |
||
siid |
varchar2 |
Verkoopfactuur | fetched only when named, SiId |
||
sitp |
int32 |
Factuurtype (verkoop) | fetched only when named, SiTp |
||
siun |
int32 |
Administratie (Verkoop) | fetched only when named, SiUn |
||
sjid |
int32 |
Dossieritem | fetched only when named, SjId |
||
sor |
varchar2 |
Verkooporder | fetched only when named, Sor |
||
squ |
varchar2 |
Verkoopofferte | fetched only when named, Squ |
||
sunr |
int32 |
Abonnement | fetched only when named, SuNr |
||
toap |
char |
Sollicitant | fetched only when named, ToAp |
||
tobc |
char |
Organisatie/persoon | fetched only when named, ToBC |
||
tocl |
char |
Cliënt IB | fetched only when named, ToCl |
||
tocv |
char |
Cliënt Vpb | fetched only when named, ToCV |
||
toem |
char |
Medewerker | fetched only when named, ToEm |
||
toer |
char |
Werkgever | fetched only when named, ToEr |
||
toob |
char |
Cliënt OB | fetched only when named, ToOb |
||
topr |
char |
Inkooprelatie | fetched only when named, ToPR |
||
tosr |
char |
Verkooprelatie | fetched only when named, ToSR |
||
unsc |
int32 |
Adm. budgetscenario | fetched only when named, UnSc |
||
vait |
varchar2 |
Type item | fetched only when named, VaIt |
||
year |
int32 |
Jaar | fetched only when named, Year |