Please enable JavaScript to view this site.

Made in EU
Odoo Forums

Navigation: Schema: stock > Tables

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

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer