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_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
analytic_ |
varchar2 |
||||
analytic_ |
varchar2 |
||||
calendar_ |
boolean |
Calendar Changed | Whether the previous or next contract has a different schedule or not | ||
calendar_ |
boolean |
Calendar Mismatch | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
contract_ |
varchar2 |
||||
contract_ |
varchar2 |
||||
contract_ |
numeric |
Contract Wage | |||
contracts_ |
int32 |
Contract Count | |||
country_ |
varchar2 |
Código del País | The ISO country code in two chars.You can use this field for quick search. | ||
create_ |
datetime |
Creado en | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
date_ |
datetime |
Fecha Final | End date of the contract (if it's a fixed-term contract). | ||
date_ |
datetime |
Generated From | |||
date_ |
datetime |
Generated To | |||
date_ |
datetime |
Fecha Inicial | |||
department_ |
varchar2 |
||||
department_ |
varchar2 |
||||
display_ |
varchar2 |
Nombre para mostrar | |||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
first_ |
datetime |
First Contract Date | |||
full_ |
numeric |
Fulltime Hours | Number of hours to work to be considered as fulltime. | ||
has_ |
boolean |
Has Message | |||
hourly_ |
numeric |
Salario por Hora | Employee's hourly gross wage. | ||
hours_ |
numeric |
Horas por Semana | |||
hr_ |
varchar2 |
Person responsible for validating the employee's contracts. | |||
hr_ |
varchar2 |
Person responsible for validating the employee's contracts. | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is Full Time | |||
job_id |
varchar2 |
||||
job_ |
varchar2 |
||||
kanban_ |
varchar2 |
Kanban State | |||
last_ |
datetime |
Last Generation Date | |||
message_ |
int32 |
Número de archivos adjuntos | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Número de acciones | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Referencia del contrato | |||
notes |
varchar2 |
Notes | |||
payslips_ |
int32 |
# Payslips | |||
permit_ |
varchar2 |
Work Permit No | |||
resource_ |
varchar2 |
Employee's working schedule. | |||
resource_ |
varchar2 |
Employee's working schedule. | |||
schedule_ |
varchar2 |
Scheduled Pay | Defines the frequency of the wage payment. | ||
sign_ |
int32 |
Sign Request Count | |||
sign_ |
varchar2 |
||||
standard_ |
varchar2 |
||||
standard_ |
varchar2 |
||||
state |
varchar2 |
Status | Estado del contrato | ||
structure_ |
varchar2 |
||||
structure_ |
varchar2 |
||||
time_ |
boolean |
Part Time | |||
time_ |
varchar2 |
The work entry type used when generating work entries to fit full time working schedule. | |||
time_ |
varchar2 |
The work entry type used when generating work entries to fit full time working schedule. | |||
trial_ |
datetime |
End of Trial Period | End date of the trial period (if there is one). | ||
visa_ |
datetime |
Visa Expire Date | |||
visa_ |
varchar2 |
Visa No | |||
wage |
numeric |
Wage | Employee's monthly gross wage. | ||
wage_ |
varchar2 |
Wage Type | |||
website_ |
varchar2 |
Website communication history | |||
work_ |
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_ |
numeric |
Work time rate | Work time rate versus full time working schedule. | ||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: