slot: Odoo itgen_odoo_slot
read only per partition
- Catalogo:
Odoo - Schema:
planning - Etichetta: itgen_odoo_slot
Planning Shift
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella slot. 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 |
|---|---|---|---|---|---|
access_ |
varchar2 |
Security Token | |||
allocated_ |
numeric |
Allocated Time | |||
allocated_ |
numeric |
Allocated Time % | |||
allocation_ |
varchar2 |
Allocation Type | |||
allow_ |
boolean |
Let Employee Unassign Themselves | |||
allow_ |
boolean |
Allow Template Creation | |||
color |
int32 |
Color | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
confirm_ |
boolean |
Confirm Slots Deletion | |||
conflicting_ |
varchar2 |
||||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
department_ |
varchar2 |
||||
department_ |
varchar2 |
||||
display_ |
varchar2 |
Nome visualizzato | |||
duration |
numeric |
Duration | |||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
employee_ |
varchar2 |
||||
end_ |
datetime |
Data di fine | |||
id |
int32 |
ID | |||
is_ |
boolean |
Employees on Time Off | |||
is_ |
boolean |
Is This Shift Assigned To The Current User | |||
is_ |
boolean |
Is Hatched | |||
is_ |
boolean |
Is This Shift In The Past? | |||
is_ |
boolean |
Is unassignement deadline not past | |||
is_ |
boolean |
Is the shifts role one of the current user roles | |||
job_ |
varchar2 |
Professione | |||
leave_ |
varchar2 |
Leave Warning | |||
manager_ |
varchar2 |
||||
manager_ |
varchar2 |
||||
name |
varchar2 |
Note | |||
overlap_ |
int32 |
Overlapping Slots | |||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
previous_ |
varchar2 |
||||
previous_ |
varchar2 |
||||
publication_ |
boolean |
Modified Since Last Publication | If checked, it means that the shift contains has changed since its last publish. | ||
recurrency_ |
varchar2 |
||||
recurrency_ |
varchar2 |
||||
repeat |
boolean |
Repeat | Modifications made to a shift only impact the current shift and not the other ones that are part of the recurrence.The same goes when deleting a recurrent shift.Disable this option to stop the recurrence.To avoid polluting your database and performance issues, shifts are only created for the next 6 months.They are then gradually created as time passes by in order to always get shifts 6 months ahead.This value can be modified from the settings of Planning, in debug mode. | ||
repeat_ |
int32 |
Repeat every | |||
repeat_ |
int32 |
Repetitions | |||
repeat_ |
varchar2 |
Repeat Type | |||
repeat_ |
varchar2 |
Repeat Unit | |||
repeat_ |
datetime |
Repeat Until | |||
request_ |
boolean |
Has there been a request to switch on this shift slot? | |||
resource_ |
varchar2 |
||||
resource_ |
varchar2 |
||||
resource_ |
varchar2 |
Type | |||
role_ |
varchar2 |
Define the roles your resources perform (e.g.Chef, Bartender, Waiter...).Create open shifts for the roles you need to complete a mission.Then, assign those open shifts to the resources that are available. | |||
role_ |
varchar2 |
Define the roles your resources perform (e.g.Chef, Bartender, Waiter...).Create open shifts for the roles you need to complete a mission.Then, assign those open shifts to the resources that are available. | |||
role_ |
varchar2 |
||||
sale_ |
varchar2 |
Sales order item for which this shift will be performed.When sales orders are automatically planned, the remaining hours of the sales order item, as well as the role defined on the service, are taken into account. | |||
sale_ |
varchar2 |
Sales order item for which this shift will be performed.When sales orders are automatically planned, the remaining hours of the sales order item, as well as the role defined on the service, are taken into account. | |||
sale_ |
boolean |
Plan Services | If enabled, a shift will automatically be generated for the selected role when confirming the Sales Order.Only employees with this role will automatically be assigned shifts for Sales Orders containing this service. | ||
sale_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
self_ |
int32 |
Days before shift for unassignment | Deadline in days for shift unassignment | ||
start_ |
datetime |
Data di inizio | |||
state |
varchar2 |
Status | |||
template_ |
varchar2 |
||||
template_ |
boolean |
Save as Template | |||
template_ |
varchar2 |
||||
template_ |
varchar2 |
||||
template_ |
boolean |
Template Reset | |||
unassign_ |
datetime |
Deadline for unassignment | |||
user_ |
varchar2 |
Related user name for the resource to manage its access. | |||
user_ |
varchar2 |
Related user name for the resource to manage its access. | |||
was_ |
boolean |
This Shift Was Copied From Previous Week | |||
work_ |
varchar2 |
||||
work_ |
varchar2 |
||||
work_ |
varchar2 |
Email di lavoro | |||
work_ |
varchar2 |
||||
work_ |
varchar2 |
||||
working_ |
numeric |
Giorni lavorativi | |||
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: