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

TimeTables: Tablas horarias de Simplicate

insert REST

  • Catálogo: Simplicate
  • Esquema: HRM
  • Etiqueta: Tablas horarias

Obtiene todos los horarios disponibles

Permite recuperar y modificar datos mediante insert.

Fuente de la API

  • Punto final: /hrm/timetable
  • Operación: get /hrm/timetable

Columnas de la Tabla

A continuación se muestran las columnas de la tabla TimeTables. 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
created_at varchar2 Creado en
employee_amount double Monto del empleado
employee_declarable varchar2 Empleado declarable
employee_employee_id varchar2 Identificación del Empleado
employee_id varchar2 Identificación del Empleado
employee_name varchar2 Nombre del empleado
employee_person_id varchar2 ID de persona del empleado Añadido para cumplir con la respuesta original de ventas/ventas responsible_employee
employee_tariff double Tarifa para empleados
end_date varchar2 Fecha Final
even_week_day_1_end_time double itgen_spe_even_week_day_1_end_time
even_week_day_1_hours double itgen_spe_even_week_day_1_hours
even_week_day_1_start_time double itgen_spe_even_week_day_1_start_time
even_week_day_2_end_time double itgen_spe_even_week_day_2_end_time
even_week_day_2_hours double itgen_spe_even_week_day_2_hours
even_week_day_2_start_time double itgen_spe_even_week_day_2_start_time
even_week_day_3_end_time double itgen_spe_even_week_day_3_end_time
even_week_day_3_hours double itgen_spe_even_week_day_3_hours
even_week_day_3_start_time double itgen_spe_even_week_day_3_start_time
even_week_day_4_end_time double itgen_spe_even_week_day_4_end_time
even_week_day_4_hours double itgen_spe_even_week_day_4_hours
even_week_day_4_start_time double itgen_spe_even_week_day_4_start_time
even_week_day_5_end_time double itgen_spe_even_week_day_5_end_time
even_week_day_5_hours double itgen_spe_even_week_day_5_hours
even_week_day_5_start_time double itgen_spe_even_week_day_5_start_time
even_week_day_6_end_time double itgen_spe_even_week_day_6_end_time
even_week_day_6_hours double itgen_spe_even_week_day_6_hours
even_week_day_6_start_time double itgen_spe_even_week_day_6_start_time
even_week_day_7_end_time double itgen_spe_even_week_day_7_end_time
even_week_day_7_hours double itgen_spe_even_week_day_7_hours
even_week_day_7_start_time double itgen_spe_even_week_day_7_start_time
hourly_cost_tariff double Tarifa de costo por hora
hourly_sales_tariff double Tarifa de venta por hora
id varchar2 ID employee_id, ver /hrm/employee
odd_week_day_1_end_time double itgen_spe_odd_week_day_1_end_time
odd_week_day_1_hours double itgen_spe_odd_week_day_1_hours
odd_week_day_1_start_time double itgen_spe_odd_week_day_1_start_time
odd_week_day_2_end_time double itgen_spe_odd_week_day_2_end_time
odd_week_day_2_hours double itgen_spe_odd_week_day_2_hours
odd_week_day_2_start_time double itgen_spe_odd_week_day_2_start_time
odd_week_day_3_end_time double itgen_spe_odd_week_day_3_end_time
odd_week_day_3_hours double itgen_spe_odd_week_day_3_hours
odd_week_day_3_start_time double itgen_spe_odd_week_day_3_start_time
odd_week_day_4_end_time double itgen_spe_odd_week_day_4_end_time
odd_week_day_4_hours double itgen_spe_odd_week_day_4_hours
odd_week_day_4_start_time double itgen_spe_odd_week_day_4_start_time
odd_week_day_5_end_time double itgen_spe_odd_week_day_5_end_time
odd_week_day_5_hours double itgen_spe_odd_week_day_5_hours
odd_week_day_5_start_time double itgen_spe_odd_week_day_5_start_time
odd_week_day_6_end_time double itgen_spe_odd_week_day_6_end_time
odd_week_day_6_hours double itgen_spe_odd_week_day_6_hours
odd_week_day_6_start_time double itgen_spe_odd_week_day_6_start_time
odd_week_day_7_end_time double itgen_spe_odd_week_day_7_end_time
odd_week_day_7_hours double itgen_spe_odd_week_day_7_hours
odd_week_day_7_start_time double itgen_spe_odd_week_day_7_start_time
productivity_target int64 Objetivo de productividad
should_write_hours char itgen_spe_should_write_hours
start_date varchar2 Fecha Inicial
updated_at varchar2 Actualizado en

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: