picking |
Transfer
Catalog: Odoo
Schema: stock
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table picking are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
activity_calendar_event_id_label |
string |
|
☐ |
|
activity_calendar_event_id |
string |
|
☐ |
|
activity_date_deadline |
datetime |
Next Activity Deadline |
☐ |
|
activity_exception_decoration |
string |
Activity Exception Decoration |
☐ |
Type of the exception activity on record. |
activity_exception_icon |
string |
Icon |
☐ |
Icon to indicate an exception activity. |
activity_ids |
string |
|
☐ |
|
activity_state |
string |
Activity State |
☐ |
Status based on activitiesOverdue: Due date is already passedToday: Activity date is todayPlanned: Future activities. |
activity_summary |
string |
Next Activity Summary |
☐ |
|
activity_type_icon |
string |
Activity Type Icon |
☐ |
Font awesome icon e.g. fa-tasks |
activity_type_id_label |
string |
|
☐ |
|
activity_type_id |
string |
|
☐ |
|
activity_user_id_label |
string |
|
☐ |
|
activity_user_id |
string |
|
☐ |
|
amazon_sync_pending |
boolean |
Amazon Sync Pending |
☐ |
Whether the picking must be notified to Amazon or not. |
backorder_id_label |
string |
|
☐ |
If this shipment was split, then this field links to the shipment which contains the already processed part. |
backorder_id |
string |
|
☐ |
If this shipment was split, then this field links to the shipment which contains the already processed part. |
backorder_ids |
string |
|
☐ |
|
carrier_id_label |
string |
|
☐ |
|
carrier_id |
string |
|
☐ |
|
carrier_price |
decimal |
Shipping Cost |
☐ |
|
carrier_tracking_ref |
string |
Tracking Reference |
☐ |
|
carrier_tracking_url |
string |
Tracking URL |
☐ |
|
check_ids |
string |
|
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
country_code |
string |
Country Code |
☐ |
The ISO country code in two chars. You can use this field for quick search. |
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
date_deadline |
datetime |
Deadline |
☐ |
Date Promise to the customer on the top level document (SO/PO) |
date_done |
datetime |
Date of Transfer |
☐ |
Date at which the transfer has been processed or cancelled. |
date |
datetime |
Creation Date |
☐ |
Creation Date, usually the time of the order |
delay_alert_date |
datetime |
Delay Alert Date |
☐ |
|
delivery_type |
string |
Provider |
☐ |
|
destination_country_code |
string |
Destination Country |
☐ |
The ISO country code in two chars. You can use this field for quick search. |
display_name |
string |
Display Name |
☐ |
|
ep_order_ref |
string |
Easypost Order Reference |
☐ |
|
group_id_label |
string |
|
☐ |
|
group_id |
string |
|
☐ |
|
has_deadline_issue |
boolean |
Is late |
☐ |
Is late or will be late depending on the deadline and scheduled date |
has_kits |
boolean |
Has Kits |
☐ |
|
has_message |
boolean |
Has Message |
☐ |
|
has_packages |
boolean |
Has Packages |
☐ |
Check the existence of destination packages on move lines |
has_scrap_move |
boolean |
Has Scrap Moves |
☐ |
|
has_tracking |
boolean |
Has Tracking |
☐ |
|
hide_picking_type |
boolean |
Hide Picking Type |
☐ |
|
id |
int32 |
ID |
☐ |
|
immediate_transfer |
boolean |
Immediate Transfer |
☐ |
|
is_locked |
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_repairable |
boolean |
Create Repair Orders from Returns |
☐ |
If ticked, you will be able to directly create repair orders from a return. |
is_return_picking |
boolean |
Is Return Picking |
☐ |
|
is_signed |
boolean |
Is Signed |
☐ |
|
json_popover |
string |
JSON data for the popover widget |
☐ |
|
location_dest_id_label |
string |
|
☐ |
|
location_dest_id |
string |
|
☐ |
|
location_id_label |
string |
|
☐ |
|
location_id |
string |
|
☐ |
|
message_attachment_count |
int32 |
Attachment Count |
☐ |
|
message_follower_ids |
string |
|
☐ |
|
message_has_error_counter |
int32 |
Number of errors |
☐ |
Number of messages with delivery error |
message_has_error |
boolean |
Message Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_has_sms_error |
boolean |
SMS Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_ids |
string |
|
☐ |
|
message_is_follower |
boolean |
Is Follower |
☐ |
|
message_main_attachment_id_label |
string |
|
☐ |
|
message_main_attachment_id |
string |
|
☐ |
|
message_needaction_counter |
int32 |
Number of Actions |
☐ |
Number of messages which requires an action |
message_needaction |
boolean |
Action Needed |
☐ |
If checked, new messages require your attention. |
message_partner_ids |
string |
|
☐ |
|
move_ids_without_package |
string |
|
☐ |
|
move_ids |
string |
|
☐ |
|
move_line_exist |
boolean |
Has Pack Operations |
☐ |
Check the existence of pack operation on the picking |
move_line_ids_without_package |
string |
|
☐ |
|
move_line_ids |
string |
|
☐ |
|
move_line_nosuggest_ids |
string |
|
☐ |
|
move_type |
string |
Shipping Policy |
☑ |
It specifies goods to be deliver partially or all at once |
my_activity_date_deadline |
datetime |
My Activity Deadline |
☐ |
|
name |
string |
Reference |
☐ |
|
nbr_repairs |
int32 |
Number of repairs linked to this picking |
☐ |
|
note |
string |
Notes |
☐ |
|
origin |
string |
Source Document |
☐ |
Reference of the document |
owner_id_label |
string |
|
☐ |
When validating the transfer, the products will be assigned to this owner. |
owner_id |
string |
|
☐ |
When validating the transfer, the products will be assigned to this owner. |
package_ids |
string |
|
☐ |
|
package_level_ids_details |
string |
|
☐ |
|
package_level_ids |
string |
|
☐ |
|
partner_id_label |
string |
|
☐ |
|
partner_id |
string |
|
☐ |
|
picking_type_code |
string |
Type of Operation |
☐ |
|
picking_type_entire_packs |
boolean |
Move Entire Packages |
☐ |
If ticked, you will be able to select entire packages to move |
picking_type_id_label |
string |
|
☐ |
|
picking_type_id |
string |
|
☐ |
|
pos_order_id_label |
string |
|
☐ |
|
pos_order_id |
string |
|
☐ |
|
pos_session_id_label |
string |
|
☐ |
|
pos_session_id |
string |
|
☐ |
|
printed |
boolean |
Printed |
☐ |
|
priority |
string |
Priority |
☐ |
Products will be reserved first for the transfers with the highest priorities. |
product_id_label |
string |
|
☐ |
|
product_id |
string |
|
☐ |
|
products_availability_state |
string |
Products Availability State |
☐ |
|
products_availability |
string |
Product Availability |
☐ |
Latest product availability status of the picking |
purchase_id_label |
string |
|
☐ |
|
purchase_id |
string |
|
☐ |
|
quality_alert_count |
int32 |
Quality Alert Count |
☐ |
|
quality_alert_ids |
string |
|
☐ |
|
quality_check_fail |
boolean |
Quality Check Fail |
☐ |
|
quality_check_todo |
boolean |
Pending checks |
☐ |
|
repair_ids |
string |
|
☐ |
|
return_label_ids |
string |
|
☐ |
|
sale_id_label |
string |
|
☐ |
|
sale_id |
string |
|
☐ |
|
scheduled_date |
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_parcel_ref |
string |
Sendcloud Parcel Reference |
☐ |
|
sendcloud_return_parcel_ref |
string |
Sendcloud Return Parcel Ref |
☐ |
|
shipping_weight |
decimal |
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_allocation |
boolean |
Show Allocation |
☐ |
Technical Field used to decide whether the button "Allocation" should be displayed. |
show_check_availability |
boolean |
Show Check Availability |
☐ |
Technical field used to compute whether the button "Check Availability" should be displayed. |
show_clear_qty_button |
boolean |
Show Clear Qty Button |
☐ |
|
show_lots_text |
boolean |
Show Lots Text |
☐ |
|
show_mark_as_todo |
boolean |
Show Mark As Todo |
☐ |
Technical field used to compute whether the button "Mark as Todo" should be displayed. |
show_operations |
boolean |
Show Operations |
☐ |
|
show_reserved |
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_set_qty_button |
boolean |
Show Set Qty Button |
☐ |
|
show_validate |
boolean |
Show Validate |
☐ |
Technical field used to decide whether the button "Validate" should be displayed. |
signature |
byte[] |
Signature |
☐ |
Signature |
state |
string |
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_create_lots |
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_existing_lots |
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_id_label |
string |
|
☐ |
|
user_id |
string |
|
☐ |
|
website_id_label |
string |
|
☐ |
Website where this order has been placed, for eCommerce orders. |
website_id |
string |
|
☐ |
Website where this order has been placed, for eCommerce orders. |
website_message_ids |
string |
|
☐ |
Website communication history |
weight_bulk |
decimal |
Bulk Weight |
☐ |
Total weight of products which are not in a package. |
weight_uom_name |
string |
Weight unit of measure label |
☐ |
|
weight |
decimal |
Weight |
☐ |
Total weight of the products in the picking. |
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826