invantive documentation
Invantive Support ForumsLog In / Sign Up

knsubject_kns50: AFAS Profit itgen_aoe_knsubject_kns50

insert REST

  • Catalog: AfasOnline
  • Schema: UpdateConnector
  • Label: itgen_aoe_knsubject_kns50

Dossier: KnS50

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_kns50 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
u7b586b86d08249deac04f706e190678e varchar2(100) URL voorzieningsnr. fetched only when named, U7B586B86D08249DEAC04F706E190678E
ud45e0f62bd9b4286b50ce62342751535 varchar2(100) Medipoint matras vz.nr fetched only when named, UD45E0F62BD9B4286B50CE62342751535
udc995fde58f2481c8740dafebd2e1e32 varchar2(100) Vegro matras vz.nr fetched only when named, UDC995FDE58F2481C8740DAFEBD2E1E32
uf116159d63d145afa34e494a30d203a2 varchar2(40) Artikelnr matras fetched only when named, UF116159D63D145AFA34E494A30D203A2