invantive documentation
Invantive Support ForumsLog In / Sign Up

checkin_appointment: AFAS Profit itgen_aoe_checkin_appointment

read only REST

  • Catalog: AfasOnline
  • Schema: GetConnector
  • Label: itgen_aoe_checkin_appointment

Can only retrieve data.

Summary

CheckIn_Appointment

API Source

  • Endpoint: /connectors/CheckIn_Appointment
  • Metadata: metainfo/get/CheckIn_Appointment

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 checkin_appointment 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
appointment_id int32 appointment_id fetched only when named, appointment_id
appointment_name varchar2(100) appointment_name fetched only when named, appointment_name
company varchar2(255) company fetched only when named, company
first_name varchar2(50) first_name fetched only when named, first_name
given_name varchar2(80) given_name fetched only when named, given_name
initials varchar2(15) initials fetched only when named, initials
location_id varchar2(25) location_id fetched only when named, location_id
location_name varchar2(100) location_name fetched only when named, location_name
person_id int32 person_id fetched only when named, person_id
surname varchar2(255) surname fetched only when named, surname
time_from varchar2(5) time_from fetched only when named, time_from
time_to varchar2(5) time_to fetched only when named, time_to