invantive documentation
Invantive Support ForumsLog In / Sign Up

order: Odoo itgen_odoo_order

read only per partition

  • Catalog: Odoo
  • Schema: repair
  • Label: itgen_odoo_order

Repair Order

Can only retrieve data.

Table Columns

The columns of the table order 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
address_id varchar2
address_id_label varchar2
allowed_picking_type_ids varchar2
amount_tax numeric Taxes
amount_total numeric Total
amount_untaxed numeric Untaxed Amount
company_id varchar2
company_id_label varchar2
create_date datetime Created on
create_uid varchar2
create_uid_label varchar2
currency_id varchar2
currency_id_label varchar2
default_address_id varchar2
default_address_id_label varchar2
description varchar2 Repair Description
display_name varchar2 Display Name
fees_lines varchar2
guarantee_limit datetime Warranty Expiration
has_message boolean Has Message
id int32 ID
internal_notes varchar2 Internal Notes
invoice_id varchar2
invoice_id_label varchar2
invoice_method varchar2 Invoice Method Selecting 'Before Repair' or 'After Repair' will allow you to generate invoice before or after the repair is done respectively. 'No invoice' means you don't want to generate invoice for this repair order.
invoice_state varchar2 Invoice State
invoiced boolean Invoiced
is_returned boolean Returned True if this repair is linked to a Return Order and the order is 'Done'. False otherwise.
location_id varchar2 This is the location where the product to repair is located.
location_id_label varchar2 This is the location where the product to repair is located.
lot_id varchar2 Products repaired are all belonging to this lot
lot_id_label varchar2 Products repaired are all belonging to this lot
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_id varchar2
move_id_label varchar2
my_activity_date_deadline datetime My Activity Deadline
name varchar2 Repair Reference
operations varchar2
partner_id varchar2 Choose partner for whom the order will be invoiced and delivered. You can find a partner by its Name, TIN, Email or Internal Reference.
partner_id_label varchar2 Choose partner for whom the order will be invoiced and delivered. You can find a partner by its Name, TIN, Email or Internal Reference.
partner_invoice_id varchar2
partner_invoice_id_label varchar2
picking_id varchar2 Return Order from which the product to be repaired comes from.
picking_id_label varchar2 Return Order from which the product to be repaired comes from.
pricelist_id varchar2 Pricelist of the selected partner.
pricelist_id_label varchar2 Pricelist of the selected partner.
priority varchar2 Priority
product_id varchar2
product_id_label varchar2
product_qty numeric Product Quantity
product_uom varchar2
product_uom_category_id varchar2 Conversion between Units of Measure can only occur if they belong to the same category. The conversion will be made based on the ratios.
product_uom_category_id_label varchar2 Conversion between Units of Measure can only occur if they belong to the same category. The conversion will be made based on the ratios.
product_uom_label varchar2
quotation_notes varchar2 Quotation Notes
repaired boolean Repaired
sale_order_id varchar2 Sale Order from which the product to be repaired comes from.
sale_order_id_label varchar2 Sale Order from which the product to be repaired comes from.
schedule_date datetime Scheduled Date
state varchar2 Status * The 'Draft' status is used when a user is encoding a new and unconfirmed repair order. * The 'Confirmed' status is used when a user confirms the repair order. * The 'Ready to Repair' status is used to start to repairing, user can start repairing only after repair order is confirmed. * The 'Under Repair' status is used when the repair is ongoing. * The 'To be Invoiced' status is used to generate the invoice before or after repairing done. * The 'Done' status is set when repairing is completed. * The 'Cancelled' status is used when user cancel repair order.
tag_ids varchar2
tracking varchar2 Product Tracking Ensure the traceability of a storable product in your warehouse.
user_id varchar2
user_id_label varchar2
website_message_ids varchar2 Website communication history
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: