picking_type: Odoo itgen_odoo_picking_type
read only per partition
- Catálogo:
Odoo - Esquema:
stock - Etiqueta: itgen_odoo_picking_type
Picking Type
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla picking_type. 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 | |||
auto_ |
boolean |
Show Reception Report at Validation | If this checkbox is ticked, Odoo will automatically show the reception report (if there are moves to allocate to) when validating. | ||
barcode |
varchar2 |
Barcode | |||
barcode_ |
boolean |
Force a destination on all products | |||
barcode_ |
boolean |
Force all products to be packed | |||
barcode_ |
boolean |
Allow full picking validation | Allow to validate a picking even if nothing was scanned yet (and so, do an immediate transfert) | ||
code |
varchar2 |
Type of Operation | |||
color |
int32 |
Color | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
count_ |
int32 |
Number of Manufacturing Orders Late | |||
count_ |
int32 |
Number of Manufacturing Orders to Process | |||
count_ |
int32 |
Number of Manufacturing Orders Waiting | |||
count_ |
int32 |
Count Picking | |||
count_ |
int32 |
Count Picking Backorders | |||
count_ |
int32 |
Count Picking Draft | |||
count_ |
int32 |
Count Picking Late | |||
count_ |
int32 |
Count Picking Ready | |||
count_ |
int32 |
Count Picking Waiting | |||
create_ |
varchar2 |
Create Backorder | When validating a transfer: * Ask: users are asked to choose if they want to make a backorder for remaining products * Always: a backorder is automatically created for the remaining products * Never: remaining products are cancelled | ||
create_ |
datetime |
Creado en | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
default_ |
varchar2 |
This is the default destination location when you create a picking manually with this operation type.It is possible however to change it or that the routes put another location.If it is empty, it will check for the customer location on the partner. | |||
default_ |
varchar2 |
This is the default destination location when you create a picking manually with this operation type.It is possible however to change it or that the routes put another location.If it is empty, it will check for the customer location on the partner. | |||
default_ |
varchar2 |
This is the default source location when you create a picking manually with this operation type.It is possible however to change it or that the routes put another location.If it is empty, it will check for the supplier location on the partner. | |||
default_ |
varchar2 |
This is the default source location when you create a picking manually with this operation type.It is possible however to change it or that the routes put another location.If it is empty, it will check for the supplier location on the partner. | |||
display_ |
varchar2 |
Nombre para mostrar | |||
hide_ |
boolean |
Hide Reservation Method | |||
id |
int32 |
ID | |||
iot_ |
varchar2 |
Automatically print the shipping labels using this printer. | |||
iot_ |
varchar2 |
Automatically print the shipping labels using this printer. | |||
iot_ |
varchar2 |
Choose the scales you want to use for this operation type.Those scales can be used to weigh the packages created. | |||
is_ |
boolean |
Create Repair Orders from Returns | If ticked, you will be able to directly create repair orders from a return. | ||
name |
varchar2 |
Tipo de operación | |||
print_ |
boolean |
Print Label | If this checkbox is ticked, label will be print in this operation. | ||
reservation_ |
int32 |
Days | Maximum number of days before scheduled date that products should be reserved. | ||
reservation_ |
int32 |
Days when starred | Maximum number of days before scheduled date that priority picking products should be reserved. | ||
reservation_ |
varchar2 |
Reservation Method | How products in transfers of this operation type should be reserved. | ||
restrict_ |
varchar2 |
Force put in pack? | Does the picker have to put in a package the scanned products?If yes, at which rate? | ||
restrict_ |
varchar2 |
Force Destination Location scan? | Does the picker have to scan the destination?If yes, at which rate? | ||
restrict_ |
boolean |
Force Product scan? | Line's product must be scanned before the line can be edited | ||
restrict_ |
varchar2 |
Force Source Location scan? | |||
restrict_ |
varchar2 |
Force Lot/Serial scan? | |||
return_ |
varchar2 |
||||
return_ |
varchar2 |
||||
return_ |
varchar2 |
||||
sequence |
int32 |
Sequence | Used to order the 'All Operations' kanban view | ||
sequence_ |
varchar2 |
Sequence Prefix | |||
sequence_ |
varchar2 |
||||
sequence_ |
varchar2 |
||||
show_ |
boolean |
Show Barcode Validation | Technical field used to compute whether the "Final Validation" group should be displayed, solving combined groups/invisible complexity. | ||
show_ |
boolean |
Move Entire Packages | If ticked, you will be able to select entire packages to move | ||
show_ |
boolean |
Show Detailed Operations | If this checkbox is ticked, the pickings lines will represent detailed stock operations.If not, the picking lines will represent an aggregate of detailed stock operations. | ||
show_ |
boolean |
Pre-fill Detailed Operations | If this checkbox is ticked, Odoo will automatically pre-fill the detailed operations with the corresponding products, locations and lot/serial numbers. | ||
use_ |
boolean |
Consume Reserved Lots/Serial Numbers automatically | Allow automatic consumption of tracked components that are reserved | ||
use_ |
boolean |
Create New Lots/Serial Numbers for Components | Allow to create new lot/serial numbers for the components | ||
use_ |
boolean |
Create New Lots/Serial Numbers | If this is checked only, it will suppose you want to create new Lots/Serial Numbers, so you can provide them in a text field. | ||
use_ |
boolean |
Use Existing Lots/Serial Numbers | If this is checked, you will be able to choose the Lots/Serial Numbers.You can also decide to not put lots in this operation type.This means it will create stock with no lot or not put a restriction on the lot taken. | ||
warehouse_ |
varchar2 |
||||
warehouse_ |
varchar2 |
||||
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: