invantive documentation
Invantive SupportforenAnmelden / Eintragen

checkin_appointments: AFAS Profit itgen_aoe_checkin_appointments

read only REST

  • Katalog: AfasOnline
  • Schema: GetConnector
  • Bezeichnung: itgen_aoe_checkin_appointments

Es können nur Daten abgerufen werden.

Zusammenfassung

CheckIn_Appointments

API-Quelle

  • Endpunkt: /connectors/CheckIn_Appointments
  • Metadaten: metainfo/get/CheckIn_Appointments

Leistungsmerkmale

Characteristic Value
Durchschnittliche Zugriffsverzögerung (ms) 353
Anzahl der Vollscan-Zeilen pro Minute 65,100
Anzahl der Query-Zeilen pro Minute 169

Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.

Tabellenspalten

Die Spalten der Tabelle checkin_appointments sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
appointment_end_time varchar2(5) appointment_end_time fetched only when named, appointment_end_time
appointment_id int32 appointment_id fetched only when named, appointment_id
appointment_location_id varchar2(25) appointment_location_id fetched only when named, appointment_location_id
appointment_location_name varchar2(100) appointment_location_name fetched only when named, appointment_location_name
appointment_name varchar2(100) appointment_name fetched only when named, appointment_name
appointment_start_time varchar2(5) appointment_start_time fetched only when named, appointment_start_time
contact_barcode varchar2(30) contact_barcode fetched only when named, contact_barcode
contact_code varchar2(15) contact_code fetched only when named, contact_code
contact_company varchar2(255) contact_company fetched only when named, contact_company
contact_first_name varchar2(50) contact_first_name fetched only when named, contact_first_name
contact_full_name varchar2(255) contact_full_name fetched only when named, contact_full_name
contact_full_name_roep varchar2(255) contact_full_name_roep fetched only when named, contact_full_name_roep
contact_id int32 contact_id fetched only when named, contact_id
contact_image_full_id varchar2(32) contact_image_full_id fetched only when named, contact_image_full_id
contact_image_full_name varchar2(255) contact_image_full_name fetched only when named, contact_image_full_name
contact_image_thumb_id varchar2(32) contact_image_thumb_id fetched only when named, contact_image_thumb_id
contact_image_thumb_name varchar2(255) contact_image_thumb_name fetched only when named, contact_image_thumb_name
contact_initials varchar2(15) contact_initials fetched only when named, contact_initials
contact_org_id varchar2(15) contact_org_id fetched only when named, contact_org_id
contact_roep_name varchar2(80) contact_roep_name fetched only when named, contact_roep_name
contact_surname varchar2(255) contact_surname fetched only when named, contact_surname
event_end_time datetime event_end_time fetched only when named, event_end_time
event_id int32 event_id fetched only when named, event_id
event_location_id varchar2(25) event_location_id fetched only when named, event_location_id
event_location_name varchar2(100) event_location_name fetched only when named, event_location_name
event_name varchar2(100) event_name fetched only when named, event_name
event_print_badge char event_print_badge fetched only when named, event_print_badge
event_session_id int32 event_session_id fetched only when named, event_session_id
event_start_time datetime event_start_time fetched only when named, event_start_time
event_take_photo char event_take_photo fetched only when named, event_take_photo