invantive documentation
Invantive Support ForumsLog In / Sign Up

kncoursegrouplines: AFAS Profit itgen_aoe_kncoursegrouplines

insert update delete REST

  • Catalog: AfasOnline
  • Schema: UpdateConnector
  • Label: itgen_aoe_kncoursegrouplines

Cursusplanning

Can retrieve data and change data using insert, update and delete.

API Source

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

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 kncoursegrouplines 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
cdid int32 Contact fetched only when named, CdId
cgid varchar2(15) Cursustraject fetched only when named, CgId
id int32 Volgnummer fetched only when named, Id
itcd varchar2(40) Cursus fetched only when named, ItCd
mayn char Verplicht fetched only when named, MaYN
stda datetime Gewenste startdatum fetched only when named, StDa