picking: Odoo itgen_odoo_picking
read only per partition
- Catalogo:
Odoo - Schema:
stock - Etichetta: itgen_odoo_picking
Transfer
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella picking. 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 |
|---|---|---|---|---|---|
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 |
||||
amazon_ |
boolean |
Amazon Sync Pending | Whether the picking must be notified to Amazon or not. | ||
backorder_ |
varchar2 |
If this shipment was split, then this field links to the shipment which contains the already processed part. | |||
backorder_ |
varchar2 |
If this shipment was split, then this field links to the shipment which contains the already processed part. | |||
backorder_ |
varchar2 |
||||
carrier_ |
varchar2 |
||||
carrier_ |
varchar2 |
||||
carrier_ |
numeric |
Shipping Cost | |||
carrier_ |
varchar2 |
Tracking Reference | |||
carrier_ |
varchar2 |
URL di tracciamento | |||
check_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
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 |
||||
date |
datetime |
Data di creazione | Creation Date, usually the time of the order | ||
date_ |
datetime |
Deadline | Date Promise to the customer on the top level document (SO/PO) | ||
date_ |
datetime |
Date of Transfer | Date at which the transfer has been processed or cancelled. | ||
delay_ |
datetime |
Delay Alert Date | |||
delivery_ |
varchar2 |
Provider | |||
destination_ |
varchar2 |
Destination Country | The ISO country code in two chars.You can use this field for quick search. | ||
display_ |
varchar2 |
Nome visualizzato | |||
ep_ |
varchar2 |
Easypost Order Reference | |||
group_ |
varchar2 |
||||
group_ |
varchar2 |
||||
has_ |
boolean |
Is late | Is late or will be late depending on the deadline and scheduled date | ||
has_ |
boolean |
Has Kits | |||
has_ |
boolean |
Has Message | |||
has_ |
boolean |
Has Packages | Check the existence of destination packages on move lines | ||
has_ |
boolean |
Has Scrap Moves | |||
has_ |
boolean |
Has Tracking | |||
hide_ |
boolean |
Hide Picking Type | |||
id |
int32 |
ID | |||
immediate_ |
boolean |
Immediate Transfer | |||
is_ |
boolean |
È bloccato | When the picking is not done this allows changing the initial demand.When the picking is done this allows changing the done quantities. | ||
is_ |
boolean |
Create Repair Orders from Returns | If ticked, you will be able to directly create repair orders from a return. | ||
is_ |
boolean |
Is Return Picking | |||
is_ |
boolean |
Is Signed | |||
json_ |
varchar2 |
JSON data for the popover widget | |||
location_ |
varchar2 |
||||
location_ |
varchar2 |
||||
location_ |
varchar2 |
||||
location_ |
varchar2 |
||||
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 |
||||
move_ |
varchar2 |
||||
move_ |
varchar2 |
||||
move_ |
boolean |
Has Pack Operations | Check the existence of pack operation on the picking | ||
move_ |
varchar2 |
||||
move_ |
varchar2 |
||||
move_ |
varchar2 |
||||
move_ |
varchar2 |
Shipping Policy | It specifies goods to be deliver partially or all at once | ||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Reference | |||
nbr_ |
int32 |
Number of repairs linked to this picking | |||
note |
varchar2 |
Notes | |||
origin |
varchar2 |
Source Document | Reference of the document | ||
owner_ |
varchar2 |
When validating the transfer, the products will be assigned to this owner. | |||
owner_ |
varchar2 |
When validating the transfer, the products will be assigned to this owner. | |||
package_ |
varchar2 |
||||
package_ |
varchar2 |
||||
package_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
picking_ |
varchar2 |
Type of Operation | |||
picking_ |
boolean |
Move Entire Packages | If ticked, you will be able to select entire packages to move | ||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
pos_ |
varchar2 |
||||
pos_ |
varchar2 |
||||
pos_ |
varchar2 |
||||
pos_ |
varchar2 |
||||
printed |
boolean |
Printed | |||
priority |
varchar2 |
Priority | Products will be reserved first for the transfers with the highest priorities. | ||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
products_ |
varchar2 |
Product Availability | Latest product availability status of the picking | ||
products_ |
varchar2 |
Products Availability State | |||
purchase_ |
varchar2 |
||||
purchase_ |
varchar2 |
||||
quality_ |
int32 |
Quality Alert Count | |||
quality_ |
varchar2 |
||||
quality_ |
boolean |
Quality Check Fail | |||
quality_ |
boolean |
Pending checks | |||
repair_ |
varchar2 |
||||
return_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
sale_ |
varchar2 |
||||
scheduled_ |
datetime |
Data programmata | Scheduled time for the first part of the shipment to be processed.Setting manually a value here would set it as expected date for all the stock moves. | ||
sendcloud_ |
varchar2 |
Sendcloud Parcel Reference | |||
sendcloud_ |
varchar2 |
Sendcloud Return Parcel Ref | |||
shipping_ |
numeric |
Weight for Shipping | Total weight of packages and products not in a package.Packages with no shipping weight specified will default to their products' total weight.This is the weight used to compute the cost of the shipping. | ||
show_ |
boolean |
Show Allocation | Technical Field used to decide whether the button "Allocation" should be displayed. | ||
show_ |
boolean |
Show Check Availability | Technical field used to compute whether the button "Check Availability" should be displayed. | ||
show_ |
boolean |
Show Clear Qty Button | |||
show_ |
boolean |
Show Lots Text | |||
show_ |
boolean |
Show Mark As Todo | Technical field used to compute whether the button "Mark as Todo" should be displayed. | ||
show_ |
boolean |
Show 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. | ||
show_ |
boolean |
Show Set Qty Button | |||
show_ |
boolean |
Show Validate | Technical field used to decide whether the button "Validate" should be displayed. | ||
signature |
varbinary |
Signature | Signature | ||
state |
varchar2 |
Status | * Draft: The transfer is not confirmed yet.Reservation doesn't apply. * Waiting another operation: This transfer is waiting for another operation before being ready. * Waiting: The transfer is waiting for the availability of some products.(a) The shipping policy is "As soon as possible": no product could be reserved.(b) The shipping policy is "When all products are ready": not all the products could be reserved. * Ready: The transfer is ready to be processed.(a) The shipping policy is "As soon as possible": at least one product has been reserved.(b) The shipping policy is "When all products are ready": all product have been reserved. * Done: The transfer has been processed. * Cancelled: The transfer has been cancelled. | ||
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. | ||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
website_ |
varchar2 |
Website where this order has been placed, for eCommerce orders. | |||
website_ |
varchar2 |
Website where this order has been placed, for eCommerce orders. | |||
website_ |
varchar2 |
Website communication history | |||
weight |
numeric |
Weight | Total weight of the products in the picking. | ||
weight_ |
numeric |
Bulk Weight | Total weight of products which are not in a package. | ||
weight_ |
varchar2 |
Weight unit of measure label | |||
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: