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_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
datetime |
Next Activity Deadline | |||
activity_ |
varchar2 |
Activity Exception Decoration | Type of the exception activity on record. | ||
activity_ |
varchar2 |
Icon | Icon to indicate an exception activity. | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
Activity State | Status based on activities Overdue: Due date is already passed Today: Activity date is today Planned: Future activities. | ||
activity_ |
varchar2 |
Next Activity Summary | |||
activity_ |
varchar2 |
Activity Type Icon | Font awesome icon e.g. fa-tasks | ||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
activity_ |
varchar2 |
||||
address_ |
varchar2 |
||||
address_ |
varchar2 |
||||
allowed_ |
varchar2 |
||||
amount_ |
numeric |
Taxes | |||
amount_ |
numeric |
Total | |||
amount_ |
numeric |
Untaxed Amount | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
currency_ |
varchar2 |
||||
default_ |
varchar2 |
||||
default_ |
varchar2 |
||||
description |
varchar2 |
Repair Description | |||
display_ |
varchar2 |
Display Name | |||
fees_ |
varchar2 |
||||
guarantee_ |
datetime |
Warranty Expiration | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
internal_ |
varchar2 |
Internal Notes | |||
invoice_ |
varchar2 |
||||
invoice_ |
varchar2 |
||||
invoice_ |
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_ |
varchar2 |
Invoice State | |||
invoiced |
boolean |
Invoiced | |||
is_ |
boolean |
Returned | True if this repair is linked to a Return Order and the order is 'Done'. False otherwise. | ||
location_ |
varchar2 |
This is the location where the product to repair is located. | |||
location_ |
varchar2 |
This is the location where the product to repair is located. | |||
lot_id |
varchar2 |
Products repaired are all belonging to this lot | |||
lot_ |
varchar2 |
Products repaired are all belonging to this lot | |||
message_ |
int32 |
Attachment Count | |||
message_ |
varchar2 |
||||
message_ |
boolean |
Message Delivery error | If checked, some messages have a delivery error. | ||
message_ |
int32 |
Number of errors | Number of messages with delivery error | ||
message_ |
boolean |
SMS Delivery error | If checked, some messages have a delivery error. | ||
message_ |
varchar2 |
||||
message_ |
boolean |
Is Follower | |||
message_ |
varchar2 |
||||
message_ |
varchar2 |
||||
message_ |
boolean |
Action Needed | If checked, new messages require your attention. | ||
message_ |
int32 |
Number of Actions | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
move_ |
varchar2 |
||||
move_ |
varchar2 |
||||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Repair Reference | |||
operations |
varchar2 |
||||
partner_ |
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_ |
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_ |
varchar2 |
||||
partner_ |
varchar2 |
||||
picking_ |
varchar2 |
Return Order from which the product to be repaired comes from. | |||
picking_ |
varchar2 |
Return Order from which the product to be repaired comes from. | |||
pricelist_ |
varchar2 |
Pricelist of the selected partner. | |||
pricelist_ |
varchar2 |
Pricelist of the selected partner. | |||
priority |
varchar2 |
Priority | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
numeric |
Product Quantity | |||
product_ |
varchar2 |
||||
product_ |
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_ |
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_ |
varchar2 |
||||
quotation_ |
varchar2 |
Quotation Notes | |||
repaired |
boolean |
Repaired | |||
sale_ |
varchar2 |
Sale Order from which the product to be repaired comes from. | |||
sale_ |
varchar2 |
Sale Order from which the product to be repaired comes from. | |||
schedule_ |
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_ |
varchar2 |
||||
tracking |
varchar2 |
Product Tracking | Ensure the traceability of a storable product in your warehouse. | ||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: