invantive documentation
Invantive Support ForumsLog In / Sign Up

hrempcourse: AFAS Profit itgen_aoe_hrempcourse

insert update delete REST

  • Catalog: AfasOnline
  • Schema: UpdateConnector
  • Label: itgen_aoe_hrempcourse

Cursus

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

API Source

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

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 hrempcourse 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 Deelnemer fetched only when named, CdId
coin varchar2(255) Opleidingsinstituut fetched only when named, CoIn
cosn int32 Volgnummer fetched only when named, CoSn
crid int32 Cursusevenement fetched only when named, CrId
dabc datetime Begindatum cursus fetched only when named, DaBc
daec datetime Einddatum cursus fetched only when named, DaEc
ds varchar2(255) Omschrijving fetched only when named, Ds
dtvf datetime Geldig van fetched only when named, DtVf
dtvt datetime Geldig tot fetched only when named, DtVt
dura int32 Cursusduur fetched only when named, Dura
emid varchar2(15) Medewerker fetched only when named, EmId
fla char Valt onder wettelijk opleidingsrecht fetched only when named, FLA
flal varchar2(20) Locatie fetched only when named, FLAL
flap varchar2(20) Deelname fetched only when named, FLAP
flar varchar2(20) Resultaat fetched only when named, FLAR
flat varchar2(20) Type fetched only when named, FLAT
grat char Certificaat behaald fetched only when named, Grat
meid int32 Organisatie/persoon fetched only when named, MeId
re varchar2 Opmerking fetched only when named, Re
u133f7ad64c9c2b7b357bab975c5450e2 number Werknemer fetched only when named, U133F7AD64C9C2B7B357BAB975C5450E2
u679fade749e04c227b4427b37b06cb9d number Werkgever fetched only when named, U679FADE749E04C227B4427B37B06CB9D
u6b8a4e14449e3009121cc7bc22b2e4b8 char Vergoeding fetched only when named, U6B8A4E14449E3009121CC7BC22B2E4B8
uadfd842344da62b3f63c83a0fae963b6 datetime Einde terugbetaling fetched only when named, UADFD842344DA62B3F63C83A0FAE963B6
ubd2ee38a4490e197f2cb5198887c5fac char Studieovereenkomst fetched only when named, UBD2EE38A4490E197F2CB5198887C5FAC
ud74bf0e74a5f755bf87f3aba4909f8e4 varchar2(20) Terugbetalingstermij fetched only when named, UD74BF0E74A5F755BF87F3ABA4909F8E4
vico varchar2(20) Soort fetched only when named, ViCo
virc varchar2(20) Status cursus fetched only when named, ViRc