invantive documentation
Invantive Support ForumsLog In / Sign Up

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 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: