invantive documentation
Invantive SupportforenAnmelden / Eintragen

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(100) Partijnummer fetched only when named, Batc
bcid varchar2(15) Organisatie/persoon fetched only when named, BcId
biid varchar2(40) 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(14) Beheersmaatregel fetched only when named, CfMI
cfri int32 Rapportage-eis fetched only when named, CfRI
cono varchar2(16) Contract fetched only when named, CoNo
crid int32 Cursusevenement fetched only when named, CrId
dcid varchar2(16) 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(12) Ontvangst fetched only when named, GoRe
loid varchar2(25) Locatie fetched only when named, LoId
olnu varchar2(12) Optiekeuzelijst fetched only when named, OlNu
ornu varchar2(12) Pakbon fetched only when named, OrNu
ou varchar2(10) Organisatorische eenheid fetched only when named, Ou
paid varchar2(15) Prijsafspraak fetched only when named, PAId
pcid varchar2(12) Plaatsing fetched only when named, PcId
piid varchar2(12) 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(15) Project fetched only when named, PjId
plid int32 Salarisverwerkingsplan fetched only when named, PlId
pnid int32 Periodeafsluitingsregel fetched only when named, PnId
por varchar2(12) Inkooporder fetched only when named, Por
pqu varchar2(12) Inkoopofferte fetched only when named, Pqu
quid varchar2(21) Voorcalculatie fetched only when named, QuId
rlid varchar2(25) Rol fetched only when named, RlId
sbid int32 Dossieritem fetched only when named, SbId
scid varchar2(6) Budgetscenario fetched only when named, ScId
seid int32 Sessie fetched only when named, SeId
seri varchar2(100) Serienummer fetched only when named, Seri
sfid varchar2(50) Bestemming fetched only when named, SfId
sftp int32 Type bestemming fetched only when named, SfTp
siid varchar2(12) 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(12) Verkooporder fetched only when named, Sor
squ varchar2(12) 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(20) Type item fetched only when named, VaIt
year int32 Jaar fetched only when named, Year