knsubject_kns01: AFAS Profit itgen_aoe_knsubject_kns01
insert REST
- Catalog:
AfasOnline - Schema:
UpdateConnector - Label: itgen_aoe_knsubject_kns01
Dossier: KnS01
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_kns01 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 |
||
u26bce64a414fb3cd7e8332aa75732253 |
varchar2 |
Betrouwbaarheid | fetched only when named, U26 |
||
u4e02023a4cc678f6cf4c098bbe47e285 |
varchar2 |
Goede offertes | fetched only when named, U4 |
||
u4f086960466954a58a65118e7bc7b5ac |
varchar2 |
Gedrag medewerkers | fetched only when named, U4 |
||
u5cd8b152436f62a3caa2aca46aa99ca4 |
varchar2 |
Correcte facturen | fetched only when named, U5 |
||
u65cf69864c7b09a3116d9b90da582079 |
varchar2 |
Advies | fetched only when named, U65 |
||
u7395db8a4911de7296395b82b8354698 |
char |
Niet meer inkopen? | fetched only when named, U7395 |
||
u74d0e75f42dbf068dbd0fab0846c3f8b |
varchar2 |
Eindoordeel | fetched only when named, U74 |
||
u83a447af418016fc3af82e9ceaccb4d6 |
varchar2 |
Flexibiliteit | fetched only when named, U83 |
||
u8a61599b49039db2e80e11a0f120a18e |
varchar2 |
Toegevoegde waarde | fetched only when named, U8 |
||
u9032154643d25465fb7d78d01fd6f9e3 |
varchar2 |
Kwaliteit levering | fetched only when named, U9032154643 |
||
u9484c2bd4898084bf43a6dba42b86326 |
varchar2 |
Wijze van reageren | fetched only when named, U9484 |
||
ub22e52b949f474751b9a5d9c5a2837ad |
varchar2 |
Prijs/ kwaliteit | fetched only when named, UB22 |
||
ue5cce3d4401be61bfbf29cbcee09c0cb |
varchar2 |
Responsetijd | fetched only when named, UE5 |
||
ue8d5db3e4649cf2b5d63e29fc56edc69 |
varchar2 |
Overige opmerking | fetched only when named, UE8 |