---
title: "picking (Odoo)"
description: "itgen_odoo_picking"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.stock.picking
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.stock.picking
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# 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_calendar_event_id` | `varchar2` |  | [ ] |  |  |
| `activity_calendar_event_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_date_deadline` | `datetime` | Next Activity Deadline | [ ] |  |  |
| `activity_exception_decoration` | `varchar2` | Activity Exception Decoration | [ ] |  | Type of the exception activity on record. |
| `activity_exception_icon` | `varchar2` | Icon | [ ] |  | Icon to indicate an exception activity. |
| `activity_ids` | `varchar2` |  | [ ] |  |  |
| `activity_state` | `varchar2` | Activity State | [ ] |  | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. |
| `activity_summary` | `varchar2` | Next Activity Summary | [ ] |  |  |
| `activity_type_icon` | `varchar2` | Activity Type Icon | [ ] |  | Font awesome icon e.g. fa-tasks |
| `activity_type_id` | `varchar2` |  | [ ] |  |  |
| `activity_type_id_label` | `varchar2` |  | [ ] |  |  |
| `activity_user_id` | `varchar2` |  | [ ] |  |  |
| `activity_user_id_label` | `varchar2` |  | [ ] |  |  |
| `amazon_sync_pending` | `boolean` | Amazon Sync Pending | [ ] |  | Whether the picking must be notified to Amazon or not. |
| `backorder_id` | `varchar2` |  | [ ] |  | If this shipment was split, then this field links to the shipment which contains the already processed part. |
| `backorder_id_label` | `varchar2` |  | [ ] |  | If this shipment was split, then this field links to the shipment which contains the already processed part. |
| `backorder_ids` | `varchar2` |  | [ ] |  |  |
| `carrier_id` | `varchar2` |  | [ ] |  |  |
| `carrier_id_label` | `varchar2` |  | [ ] |  |  |
| `carrier_price` | `numeric` | Shipping Cost | [ ] |  |  |
| `carrier_tracking_ref` | `varchar2` | Tracking Reference | [ ] |  |  |
| `carrier_tracking_url` | `varchar2` | Tracking URL | [ ] |  |  |
| `check_ids` | `varchar2` |  | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `country_code` | `varchar2` | Country Code | [ ] |  | The ISO country code in two chars.  You can use this field for quick search. |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `date` | `datetime` | Creation Date | [ ] |  | Creation Date, usually the time of the order |
| `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. |
| `delay_alert_date` | `datetime` | Delay Alert Date | [ ] |  |  |
| `delivery_type` | `varchar2` | Provider | [ ] |  |  |
| `destination_country_code` | `varchar2` | Destination Country | [ ] |  | The ISO country code in two chars.  You can use this field for quick search. |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `ep_order_ref` | `varchar2` | Easypost Order Reference | [ ] |  |  |
| `group_id` | `varchar2` |  | [ ] |  |  |
| `group_id_label` | `varchar2` |  | [ ] |  |  |
| `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` | `varchar2` | JSON data for the popover widget | [ ] |  |  |
| `location_dest_id` | `varchar2` |  | [ ] |  |  |
| `location_dest_id_label` | `varchar2` |  | [ ] |  |  |
| `location_id` | `varchar2` |  | [ ] |  |  |
| `location_id_label` | `varchar2` |  | [ ] |  |  |
| `message_attachment_count` | `int32` | Attachment Count | [ ] |  |  |
| `message_follower_ids` | `varchar2` |  | [ ] |  |  |
| `message_has_error` | `boolean` | Message Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_has_error_counter` | `int32` | Number of errors | [ ] |  | Number of messages with delivery error |
| `message_has_sms_error` | `boolean` | SMS Delivery error | [ ] |  | If checked, some messages have a delivery error. |
| `message_ids` | `varchar2` |  | [ ] |  |  |
| `message_is_follower` | `boolean` | Is Follower | [ ] |  |  |
| `message_main_attachment_id` | `varchar2` |  | [ ] |  |  |
| `message_main_attachment_id_label` | `varchar2` |  | [ ] |  |  |
| `message_needaction` | `boolean` | Action Needed | [ ] |  | If checked, new messages require your attention. |
| `message_needaction_counter` | `int32` | Number of Actions | [ ] |  | Number of messages which requires an action |
| `message_partner_ids` | `varchar2` |  | [ ] |  |  |
| `move_ids` | `varchar2` |  | [ ] |  |  |
| `move_ids_without_package` | `varchar2` |  | [ ] |  |  |
| `move_line_exist` | `boolean` | Has Pack Operations | [ ] |  | Check the existence of pack operation on the picking |
| `move_line_ids` | `varchar2` |  | [ ] |  |  |
| `move_line_ids_without_package` | `varchar2` |  | [ ] |  |  |
| `move_line_nosuggest_ids` | `varchar2` |  | [ ] |  |  |
| `move_type` | `varchar2` | Shipping Policy | [x] |  | It specifies goods to be deliver partially or all at once |
| `my_activity_date_deadline` | `datetime` | My Activity Deadline | [ ] |  |  |
| `name` | `varchar2` | Reference | [ ] |  |  |
| `nbr_repairs` | `int32` | Number of repairs linked to this picking | [ ] |  |  |
| `note` | `varchar2` | Notes | [ ] |  |  |
| `origin` | `varchar2` | Source Document | [ ] |  | Reference of the document |
| `owner_id` | `varchar2` |  | [ ] |  | When validating the transfer, the products will be assigned to this owner. |
| `owner_id_label` | `varchar2` |  | [ ] |  | When validating the transfer, the products will be assigned to this owner. |
| `package_ids` | `varchar2` |  | [ ] |  |  |
| `package_level_ids` | `varchar2` |  | [ ] |  |  |
| `package_level_ids_details` | `varchar2` |  | [ ] |  |  |
| `partner_id` | `varchar2` |  | [ ] |  |  |
| `partner_id_label` | `varchar2` |  | [ ] |  |  |
| `picking_type_code` | `varchar2` | 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` | `varchar2` |  | [ ] |  |  |
| `picking_type_id_label` | `varchar2` |  | [ ] |  |  |
| `pos_order_id` | `varchar2` |  | [ ] |  |  |
| `pos_order_id_label` | `varchar2` |  | [ ] |  |  |
| `pos_session_id` | `varchar2` |  | [ ] |  |  |
| `pos_session_id_label` | `varchar2` |  | [ ] |  |  |
| `printed` | `boolean` | Printed | [ ] |  |  |
| `priority` | `varchar2` | Priority | [ ] |  | Products will be reserved first for the transfers with the highest priorities. |
| `product_id` | `varchar2` |  | [ ] |  |  |
| `product_id_label` | `varchar2` |  | [ ] |  |  |
| `products_availability` | `varchar2` | Product Availability | [ ] |  | Latest product availability status of the picking |
| `products_availability_state` | `varchar2` | Products Availability State | [ ] |  |  |
| `purchase_id` | `varchar2` |  | [ ] |  |  |
| `purchase_id_label` | `varchar2` |  | [ ] |  |  |
| `quality_alert_count` | `int32` | Quality Alert Count | [ ] |  |  |
| `quality_alert_ids` | `varchar2` |  | [ ] |  |  |
| `quality_check_fail` | `boolean` | Quality Check Fail | [ ] |  |  |
| `quality_check_todo` | `boolean` | Pending checks | [ ] |  |  |
| `repair_ids` | `varchar2` |  | [ ] |  |  |
| `return_label_ids` | `varchar2` |  | [ ] |  |  |
| `sale_id` | `varchar2` |  | [ ] |  |  |
| `sale_id_label` | `varchar2` |  | [ ] |  |  |
| `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` | `varchar2` | Sendcloud Parcel Reference | [ ] |  |  |
| `sendcloud_return_parcel_ref` | `varchar2` | Sendcloud Return Parcel Ref | [ ] |  |  |
| `shipping_weight` | `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_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` | `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_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` | `varchar2` |  | [ ] |  |  |
| `user_id_label` | `varchar2` |  | [ ] |  |  |
| `website_id` | `varchar2` |  | [ ] |  | Website where this order has been placed, for eCommerce orders. |
| `website_id_label` | `varchar2` |  | [ ] |  | Website where this order has been placed, for eCommerce orders. |
| `website_message_ids` | `varchar2` |  | [ ] |  | Website communication history |
| `weight` | `numeric` | Weight | [ ] |  | Total weight of the products in the picking. |
| `weight_bulk` | `numeric` | Bulk Weight | [ ] |  | Total weight of products which are not in a package. |
| `weight_uom_name` | `varchar2` | Weight unit of measure label | [ ] |  |  |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Odoo](/en/release-notes/drivers?driver=odoo)

