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

EmployeeExpenseAttachments: Simplicate itgen_spe_employeeexpenseattachments_plural

read only REST

  • Catálogo: Simplicate
  • Esquema: Hours
  • Etiqueta: itgen_spe_employeeexpenseattachments_plural

Obtiene los gastos de los empleados

Solo puede recuperar datos.

Fuente de la API

  • Punto final: /hours/employeeexpense
  • Operación: get /hours/employeeexpense

Columnas de la Tabla

A continuación se muestran las columnas de la tabla EmployeeExpenseAttachments. 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
amount double Amount
approval_status_description varchar2 Descripción del Estado de Aprobación
approval_status_label varchar2 Etiqueta de estado de aprobación
costtype_budgeted_amount double Tipo de costo Importe presupuestado
costtype_costtype_blocked char Tipo de costo bloqueado
costtype_costtype_id varchar2 ID del tipo de coste
costtype_costtype_is_attachment_allowed char itgen_spe_costtype_costtype_is_attachment_allowed
costtype_costtype_is_unit_tariff char itgen_spe_costtype_costtype_is_unit_tariff
costtype_costtype_label varchar2 itgen_spe_costtype_costtype_label
costtype_costtype_tariff double itgen_spe_costtype_costtype_tariff
costtype_costtype_unit_name varchar2 itgen_spe_costtype_costtype_unit_name
costtype_id varchar2 ID del tipo de coste
costtype_label varchar2 Etiqueta de tipo de costo
costtype_purchase_margin double Tipo de costo Margen de compra
costtype_purchase_tariff double Tipo de costo Tarifa de compra
costtype_tariff double Tarifa de tipo de costo
date varchar2 Date
default_costtype_blocked char itgen_spe_default_costtype_blocked
default_costtype_id varchar2 itgen_spe_default_costtype_id
default_costtype_is_attachment_allowed char itgen_spe_default_costtype_is_attachment_allowed
default_costtype_is_unit_tariff char itgen_spe_default_costtype_is_unit_tariff
default_costtype_label varchar2 itgen_spe_default_costtype_label
default_costtype_tariff double itgen_spe_default_costtype_tariff
default_costtype_unit_name varchar2 itgen_spe_default_costtype_unit_name
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
file_hash varchar2 itgen_spe_file_hash
file_name varchar2 itgen_spe_file_name
id varchar2 ID
invoice_comments varchar2 Comentarios sobre la factura
invoice_composition_type varchar2 Tipo de composición de factura
invoice_contact_id varchar2 ID de contacto de la factura
invoice_created varchar2 Factura creada
invoice_created_at varchar2 Factura creada en
invoice_date varchar2 Fecha de la Factura
invoice_id varchar2 ID de la Factura
invoice_invoice_number varchar2 Número de factura
invoice_my_organization_profile_id varchar2 itgen_spe_invoice_my_organization_profile_id
invoice_my_organization_profile_id_2 varchar2 itgen_spe_invoice_my_organization_profile_id_2
invoice_my_organization_profile_organization_id varchar2 itgen_spe_invoice_my_organization_profile_organization_id
invoice_my_organization_profile_organization_name varchar2 itgen_spe_invoice_my_organization_profile_organization_name
invoice_my_organization_profile_organization_relation_number varchar2 itgen_spe_invoice_my_organization_profile_organization_relation_number
invoice_organization_id varchar2 itgen_spe_invoice_organization_id
invoice_organization_id_2 varchar2 itgen_spe_invoice_organization_id_2
invoice_organization_name varchar2 itgen_spe_invoice_organization_name
invoice_organization_relation_number varchar2 itgen_spe_invoice_organization_relation_number
invoice_payment_term_days int64 itgen_spe_invoice_payment_term_days
invoice_payment_term_id varchar2 itgen_spe_invoice_payment_term_id
invoice_payment_term_method varchar2 itgen_spe_invoice_payment_term_method
invoice_payment_term_name varchar2 itgen_spe_invoice_payment_term_name
invoice_person_full_name varchar2 itgen_spe_invoice_person_full_name
invoice_person_id varchar2 itgen_spe_invoice_person_id
invoice_person_id_2 varchar2 itgen_spe_invoice_person_id_2
invoice_person_relation_number varchar2 itgen_spe_invoice_person_relation_number
invoice_project_has_register_mileage_enabled char itgen_spe_invoice_project_has_register_mileage_enabled
invoice_project_id varchar2 itgen_spe_invoice_project_id
invoice_project_id_2 varchar2 itgen_spe_invoice_project_id_2
invoice_project_name varchar2 itgen_spe_invoice_project_name
invoice_project_organization_id varchar2 itgen_spe_invoice_project_organization_id
invoice_project_organization_name varchar2 itgen_spe_invoice_project_organization_name
invoice_project_organization_relation_number varchar2 itgen_spe_invoice_project_organization_relation_number
invoice_project_person_full_name varchar2 itgen_spe_invoice_project_person_full_name
invoice_project_person_id varchar2 itgen_spe_invoice_project_person_id
invoice_project_person_relation_number varchar2 itgen_spe_invoice_project_person_relation_number
invoice_project_project_manager_amount double itgen_spe_invoice_project_project_manager_amount
invoice_project_project_manager_declarable varchar2 itgen_spe_invoice_project_project_manager_declarable
invoice_project_project_manager_employee_id varchar2 itgen_spe_invoice_project_project_manager_employee_id
invoice_project_project_manager_id varchar2 itgen_spe_invoice_project_project_manager_id
invoice_project_project_manager_name varchar2 itgen_spe_invoice_project_project_manager_name
invoice_project_project_manager_person_id varchar2 itgen_spe_invoice_project_project_manager_person_id Añadido para cumplir con la respuesta original de ventas/ventas responsible_employee
invoice_project_project_manager_tariff double itgen_spe_invoice_project_project_manager_tariff
invoice_project_project_number varchar2 itgen_spe_invoice_project_project_number
invoice_reference varchar2 Referencia de factura
invoice_reminder_next_action varchar2 itgen_spe_invoice_reminder_next_action
invoice_reminder_paused char itgen_spe_invoice_reminder_paused
invoice_reminder_set_disabled char itgen_spe_invoice_reminder_set_disabled
invoice_reminder_set_label varchar2 itgen_spe_invoice_reminder_set_label
invoice_reminder_status varchar2 itgen_spe_invoice_reminder_status
invoice_sending_method varchar2 itgen_spe_invoice_sending_method
invoice_simplicate_url varchar2 itgen_spe_invoice_simplicate_url
invoice_status varchar2 Estatus de la Factura
invoice_status_2 varchar2 itgen_spe_invoice_status_2
invoice_subject varchar2 Asunto de la factura
invoice_subscription_cycle_end_date varchar2 itgen_spe_invoice_subscription_cycle_end_date
invoice_subscription_cycle_is_invoiced char itgen_spe_invoice_subscription_cycle_is_invoiced
invoice_subscription_cycle_start_date varchar2 itgen_spe_invoice_subscription_cycle_start_date
invoice_timeline_email_address varchar2 itgen_spe_invoice_timeline_email_address
invoice_total_excluding_vat double itgen_spe_invoice_total_excluding_vat
invoice_total_including_vat double itgen_spe_invoice_total_including_vat
invoice_total_outstanding double itgen_spe_invoice_total_outstanding
invoice_total_vat double itgen_spe_invoice_total_vat
invoice_updated_at varchar2 itgen_spe_invoice_updated_at
is_billable char Es facturable
note varchar2 Note
project_has_register_mileage_enabled char itgen_spe_project_has_register_mileage_enabled
project_id varchar2 Identificación del Proyecto
project_name varchar2 Nombre del Proyecto
project_organization_id varchar2 ID de organización del proyecto
project_organization_name varchar2 Nombre de la organización del proyecto
project_organization_relation_number varchar2 itgen_spe_project_organization_relation_number
project_person_full_name varchar2 Nombre completo de la persona del proyecto
project_person_id varchar2 ID de persona del proyecto
project_person_relation_number varchar2 itgen_spe_project_person_relation_number
project_project_manager_amount double Monto del gerente de proyecto
project_project_manager_declarable varchar2 Gestor de proyectos declarable
project_project_manager_employee_id varchar2 ID de empleado del gerente de proyecto
project_project_manager_id varchar2 ID de gerente de proyecto
project_project_manager_name varchar2 Nombre del Administrador del Proyecto
project_project_manager_person_id varchar2 ID de persona del gerente del proyecto Añadido para cumplir con la respuesta original de ventas/ventas responsible_employee
project_project_manager_tariff double Tarifa de gerente de proyecto
project_project_number varchar2 Número de proyecto
purchase_margin double Margen de compra
purchase_price_total double Precio total de compra
purchase_price_unit double Precio unitario de compra
service_id varchar2 ID de servicio
service_purchase_end_date varchar2 itgen_spe_service_purchase_end_date
service_purchase_start_date varchar2 itgen_spe_service_purchase_start_date
tariff double Tariff
total_price double Precio Total

Notas de la Versión

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