contract: Odoo itgen_odoo_contract
read only per partition
- Catalogo:
Odoo - Schema:
hr - Etichetta: itgen_odoo_contract
Employee Contract
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella contract. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | 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 |
Codice della nazione | The ISO country code in two chars.You can use this field for quick search. | ||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
date_ |
datetime |
Data di fine | End date of the contract (if it's a fixed-term contract). | ||
date_ |
datetime |
Generated From | |||
date_ |
datetime |
Generated To | |||
date_ |
datetime |
Data di inizio | |||
department_ |
varchar2 |
||||
department_ |
varchar2 |
||||
display_ |
varchar2 |
Nome visualizzato | |||
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 |
Retribuzione oraria | Employee's hourly gross wage. | ||
hours_ |
numeric |
Ore alla settimana | |||
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 |
Numero di allegati | |||
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 |
Numero di azioni | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Riferimento del contratto | |||
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 | Stato del contratto | ||
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 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: