invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

checkin_appointments: AFAS Profit itgen_aoe_checkin_appointments

read only REST

  • Catálogo: AfasOnline
  • Esquema: GetConnector
  • Etiqueta: itgen_aoe_checkin_appointments

Solo puede recuperar datos.

Resumen

CheckIn_Appointments

Fuente de la API

  • Punto final: /connectors/CheckIn_Appointments
  • Metadatos: metainfo/get/CheckIn_Appointments

Características de rendimiento

Characteristic Value
Latencia media de acceso (ms) 353
Número de filas escaneadas por minuto 65,100
Número de filas de queries puntuales por minuto 169

El resultado se puede almacenar en la Caché del cliente.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla checkin_appointments. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos 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