invantive documentation
Invantive Support ForumsLog In / Sign Up

knsubject_kns46: AFAS Profit itgen_aoe_knsubject_kns46

insert REST

  • Catalog: AfasOnline
  • Schema: UpdateConnector
  • Label: itgen_aoe_knsubject_kns46

Dossier: KnS46

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_kns46 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
u293b1a95ba3a47d0a200d681480b41a3 varchar2(16) Autogarage fetched only when named, U293B1A95BA3A47D0A200D681480B41A3
ud1a7d83023994f24b78e1c03cbe8309a datetime Uitvoerdatum fetched only when named, UD1A7D83023994F24B78E1C03CBE8309A
ud6c9f411df7b41ad91a8335cf24d7581 datetime Factuurdatum fetched only when named, UD6C9F411DF7B41AD91A8335CF24D7581