invantive documentation
Forum di supporto InvantiveAccedi / Registrati

picking: Odoo itgen_odoo_picking

read only per partition

  • Catalogo: Odoo
  • Schema: stock
  • Etichetta: itgen_odoo_picking

Transfer

È possibile solo recuperare i dati.

Colonne della tabella

Di seguito sono riportate le colonne della tabella picking. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.

Name Tipo di dati 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 URL di tracciamento
check_ids varchar2
company_id varchar2
company_id_label varchar2
country_code varchar2 Codice della nazione The ISO country code in two chars.You can use this field for quick search.
create_date datetime Creato il
create_uid varchar2
create_uid_label varchar2
date datetime Data di creazione 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 Nome visualizzato
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 È bloccato 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 Numero di allegati
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 Numero di azioni 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 Data programmata 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

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: