invantive documentation
Invantive Support ForumsLog In / Sign Up

knsubject_kns48: AFAS Profit itgen_aoe_knsubject_kns48

insert REST

  • Catalog: AfasOnline
  • Schema: UpdateConnector
  • Label: itgen_aoe_knsubject_kns48

Dossier: KnS48

Can retrieve data and change data using insert.

API Source

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

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 knsubject_kns48 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
sbid int32 Dossieritem fetched only when named, SbId
u065f61d671f049ed98409b217aaa5b49 number Verwachte partneromzet 2024 fetched only when named, U065F61D671F049ED98409B217AAA5B49
u116b28ab8a5e4d14b91ad1c0b9bf8b67 int32 Direct contact fetched only when named, U116B28AB8A5E4D14B91AD1C0B9BF8B67
u141e0df39b3542b8b711e97628eca027 number Verwachte omzet 2025 fetched only when named, U141E0DF39B3542B8B711E97628ECA027
u14e1f43aec914a6cb8cf2db178fce253 varchar2(50) Servicepartn./Contractlev. fetched only when named, U14E1F43AEC914A6CB8CF2DB178FCE253
u2232688cecfc4b3ea03aa666380a2af8 varchar2(50) Partnerpiramide 2023 fetched only when named, U2232688CECFC4B3EA03AA666380A2AF8
u320387bb5d054d48afcae1977b17e938 int32 Indirect contact fetched only when named, U320387BB5D054D48AFCAE1977B17E938
u37ccce6d6e844d588823aa43a30d6edb number Verwachte omzet 2024 fetched only when named, U37CCCE6D6E844D588823AA43A30D6EDB
u3aadc80da1e8480b94d970e25db13cf2 number Partneromzet potentieel fetched only when named, U3AADC80DA1E8480B94D970E25DB13CF2
u40f8f6c419354c4f9c2bedff5e082dc9 varchar2 Onderbouwing verwachting partneromzet fetched only when named, U40F8F6C419354C4F9C2BEDFF5E082DC9
u5c327552046f4bdc8a60e3655b1eeed1 varchar2(50) Partnerpiramide doel fetched only when named, U5C327552046F4BDC8A60E3655B1EEED1
u61e100b7ee634c72b48d57c248587ee9 number Omzet 2024 fetched only when named, U61E100B7EE634C72B48D57C248587EE9
u64251febf9784d2784a4259a891606cc varchar2(20) Voortgang salesforecast fetched only when named, U64251FEBF9784D2784A4259A891606CC
u7a0952d2875144a792042a5f77be7acf varchar2(50) Klantstrategie fetched only when named, U7A0952D2875144A792042A5F77BE7ACF
u8ad217d1091646629e1835e25a5c35c3 number Omzetpotentieel fetched only when named, U8AD217D1091646629E1835E25A5C35C3
u97399cb6c6c74d4dbc680ef42170e85b number Omzet 2023 fetched only when named, U97399CB6C6C74D4DBC680EF42170E85B
u9758c08f4d434aab8d67cec689aa06bb varchar2(50) Klantpiramide 2024 fetched only when named, U9758C08F4D434AAB8D67CEC689AA06BB
ua1d9c7bf18be489c9177791b5f5ec56a varchar2(50) Partnerstrategie fetched only when named, UA1D9C7BF18BE489C9177791B5F5EC56A
ua2c4a7b03aa14166a3c41d784baef10b varchar2 Onderbouwing verwachting fetched only when named, UA2C4A7B03AA14166A3C41D784BAEF10B
uc20865bcdcda4c47b14336af78a25778 int32 Accountmanager SP fetched only when named, UC20865BCDCDA4C47B14336AF78A25778
uc9aff594500843599a550ee56e2ad809 varchar2(50) Doelgroep fetched only when named, UC9AFF594500843599A550EE56E2AD809
ude0a5b09edca4810930b94205f0385c8 varchar2(50) Klantpiramide 2023 fetched only when named, UDE0A5B09EDCA4810930B94205F0385C8
ue2e8daebe35742deaf53a435bede4fcd varchar2(15) Klantforecast profiel fetched only when named, UE2E8DAEBE35742DEAF53A435BEDE4FCD
ue64a124a9ef944ff9371b988c845a927 number Partneromzet 2023 fetched only when named, UE64A124A9EF944FF9371B988C845A927
uf28ac07fd68048afa492202c2fd85b93 varchar2(50) Klantpiramide doel fetched only when named, UF28AC07FD68048AFA492202C2FD85B93