picking: Odoo itgen_odoo_picking
read only per partition
- Catalog:
Odoo - Schema:
stock - Label: itgen_odoo_picking
Transfer
Can only retrieve data.
Table Columns
The columns of the table picking are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | 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 |
Tracking URL | |||
check_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
country_ |
varchar2 |
Country Code | The ISO country code in two chars. You can use this field for quick search. | ||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date |
datetime |
Creation Date | 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 |
Display Name | |||
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 |
Is Locked | 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 |
Attachment Count | |||
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 |
Number of Actions | 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 |
Scheduled Date | 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 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: