knsubject_kns48: AFAS Profit itgen_aoe_knsubject_kns48
insert REST
- Catalogus:
AfasOnline - Schema:
UpdateConnector - Label: itgen_aoe_knsubject_kns48
Dossier: KnS48
Met insert kun je gegevens ophalen en wijzigen.
API-bron
- Eindpunt:
/connectors/KnSubject - Metagegevens:
metainfo/update/KnSubject
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 353 |
| Aantal rijen per minuut bij volledige scan | 65,100 |
| Aantal rijen per minuut in een Query | 169 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel knsubject_kns48 worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
sbid |
int32 |
Dossieritem | fetched only when named, SbId |
||
u065f61d671f049ed98409b217aaa5b49 |
number |
Verwachte partneromzet 2024 | fetched only when named, U065 |
||
u116b28ab8a5e4d14b91ad1c0b9bf8b67 |
int32 |
Direct contact | fetched only when named, U116 |
||
u141e0df39b3542b8b711e97628eca027 |
number |
Verwachte omzet 2025 | fetched only when named, U141 |
||
u14e1f43aec914a6cb8cf2db178fce253 |
varchar2 |
Servicepartn./Contractlev. | fetched only when named, U14 |
||
u2232688cecfc4b3ea03aa666380a2af8 |
varchar2 |
Partnerpiramide 2023 | fetched only when named, U2232688 |
||
u320387bb5d054d48afcae1977b17e938 |
int32 |
Indirect contact | fetched only when named, U320387 |
||
u37ccce6d6e844d588823aa43a30d6edb |
number |
Verwachte omzet 2024 | fetched only when named, U37 |
||
u3aadc80da1e8480b94d970e25db13cf2 |
number |
Partneromzet potentieel | fetched only when named, U3 |
||
u40f8f6c419354c4f9c2bedff5e082dc9 |
varchar2 |
Onderbouwing verwachting partneromzet | fetched only when named, U40 |
||
u5c327552046f4bdc8a60e3655b1eeed1 |
varchar2 |
Partnerpiramide doel | fetched only when named, U5 |
||
u61e100b7ee634c72b48d57c248587ee9 |
number |
Omzet 2024 | fetched only when named, U61 |
||
u64251febf9784d2784a4259a891606cc |
varchar2 |
Voortgang salesforecast | fetched only when named, U64251 |
||
u7a0952d2875144a792042a5f77be7acf |
varchar2 |
Klantstrategie | fetched only when named, U7 |
||
u8ad217d1091646629e1835e25a5c35c3 |
number |
Omzetpotentieel | fetched only when named, U8 |
||
u97399cb6c6c74d4dbc680ef42170e85b |
number |
Omzet 2023 | fetched only when named, U97399 |
||
u9758c08f4d434aab8d67cec689aa06bb |
varchar2 |
Klantpiramide 2024 | fetched only when named, U9758 |
||
ua1d9c7bf18be489c9177791b5f5ec56a |
varchar2 |
Partnerstrategie | fetched only when named, UA1 |
||
ua2c4a7b03aa14166a3c41d784baef10b |
varchar2 |
Onderbouwing verwachting | fetched only when named, UA2 |
||
uc20865bcdcda4c47b14336af78a25778 |
int32 |
Accountmanager SP | fetched only when named, UC20865 |
||
uc9aff594500843599a550ee56e2ad809 |
varchar2 |
Doelgroep | fetched only when named, UC9 |
||
ude0a5b09edca4810930b94205f0385c8 |
varchar2 |
Klantpiramide 2023 | fetched only when named, UDE0 |
||
ue2e8daebe35742deaf53a435bede4fcd |
varchar2 |
Klantforecast profiel | fetched only when named, UE2 |
||
ue64a124a9ef944ff9371b988c845a927 |
number |
Partneromzet 2023 | fetched only when named, UE64 |
||
uf28ac07fd68048afa492202c2fd85b93 |
varchar2 |
Klantpiramide doel | fetched only when named, UF28 |