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

contract: Odoo itgen_odoo_contract

read only per partition

  • Catálogo: Odoo
  • Esquema: hr
  • Etiqueta: itgen_odoo_contract

Employee Contract

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla contract. 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
active boolean Active
activity_calendar_event_id varchar2
activity_calendar_event_id_label varchar2
activity_date_deadline datetime Next Activity Deadline
activity_exception_decoration varchar2 Activity Exception Decoration Type of the exception activity on record.
activity_exception_icon varchar2 Icon Icon to indicate an exception activity.
activity_ids varchar2
activity_state varchar2 Activity State Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities.
activity_summary varchar2 Next Activity Summary
activity_type_icon varchar2 Activity Type Icon Font awesome icon e.g. fa-tasks
activity_type_id varchar2
activity_type_id_label varchar2
activity_user_id varchar2
activity_user_id_label varchar2
analytic_account_id varchar2
analytic_account_id_label varchar2
calendar_changed boolean Calendar Changed Whether the previous or next contract has a different schedule or not
calendar_mismatch boolean Calendar Mismatch
company_country_id varchar2
company_country_id_label varchar2
company_id varchar2
company_id_label varchar2
contract_type_id varchar2
contract_type_id_label varchar2
contract_wage numeric Contract Wage
contracts_count int32 Contract Count
country_code varchar2 Código del País The ISO country code in two chars.You can use this field for quick search.
create_date datetime Creado en
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
date_end datetime Fecha Final End date of the contract (if it's a fixed-term contract).
date_generated_from datetime Generated From
date_generated_to datetime Generated To
date_start datetime Fecha Inicial
department_id varchar2
department_id_label varchar2
display_name varchar2 Nombre para mostrar
employee_id varchar2
employee_id_label varchar2
first_contract_date datetime First Contract Date
full_time_required_hours numeric Fulltime Hours Number of hours to work to be considered as fulltime.
has_message boolean Has Message
hourly_wage numeric Salario por Hora Employee's hourly gross wage.
hours_per_week numeric Horas por Semana
hr_responsible_id varchar2 Person responsible for validating the employee's contracts.
hr_responsible_id_label varchar2 Person responsible for validating the employee's contracts.
id int32 ID
is_fulltime boolean Is Full Time
job_id varchar2
job_id_label varchar2
kanban_state varchar2 Kanban State
last_generation_date datetime Last Generation Date
message_attachment_count int32 Número de archivos adjuntos
message_follower_ids varchar2
message_has_error boolean Message Delivery error If checked, some messages have a delivery error.
message_has_error_counter int32 Number of errors Number of messages with delivery error
message_has_sms_error boolean SMS Delivery error If checked, some messages have a delivery error.
message_ids varchar2
message_is_follower boolean Is Follower
message_main_attachment_id varchar2
message_main_attachment_id_label varchar2
message_needaction boolean Action Needed If checked, new messages require your attention.
message_needaction_counter int32 Número de acciones Number of messages which requires an action
message_partner_ids varchar2
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Referencia del contrato
notes varchar2 Notes
payslips_count int32 # Payslips
permit_no varchar2 Work Permit No
resource_calendar_id varchar2 Employee's working schedule.
resource_calendar_id_label varchar2 Employee's working schedule.
schedule_pay varchar2 Scheduled Pay Defines the frequency of the wage payment.
sign_request_count int32 Sign Request Count
sign_request_ids varchar2
standard_calendar_id varchar2
standard_calendar_id_label varchar2
state varchar2 Status Estado del contrato
structure_type_id varchar2
structure_type_id_label varchar2
time_credit boolean Part Time
time_credit_type_id varchar2 The work entry type used when generating work entries to fit full time working schedule.
time_credit_type_id_label varchar2 The work entry type used when generating work entries to fit full time working schedule.
trial_date_end datetime End of Trial Period End date of the trial period (if there is one).
visa_expire datetime Visa Expire Date
visa_no varchar2 Visa No
wage numeric Wage Employee's monthly gross wage.
wage_type varchar2 Wage Type
website_message_ids varchar2 Website communication history
work_entry_source varchar2 Work Entry Source Defines the source for work entries generation Working Schedule: Work entries will be generated from the working hours below.Attendances: Work entries will be generated from the employee's attendances.(requires Attendance app) Planning: Work entries will be generated from the employee's planning.(requires Planning app)
work_time_rate numeric Work time rate Work time rate versus full time working schedule.
write_date datetime Last Updated on
write_uid varchar2
write_uid_label varchar2

Notas de la Versión

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