production: Odoo itgen_odoo_production
read only per partition
- Catalog:
Odoo - Schema:
mrp - Label: itgen_odoo_production
Production Order
Can only retrieve data.
Summary
Manufacturing Orders
Table Columns
The columns of the table production 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 |
||||
allow_ |
boolean |
Allow Work Order Dependencies | |||
analytic_ |
varchar2 |
Analytic account in which cost and revenue entries will take place for financial management of the manufacturing order. | |||
analytic_ |
varchar2 |
Analytic account in which cost and revenue entries will take place for financial management of the manufacturing order. | |||
backorder_ |
int32 |
Backorder Sequence | Backorder sequence, if equals to 0 means there is not related backorder | ||
bom_id |
varchar2 |
Bills of Materials, also called recipes, are used to autocomplete components and work order instructions. | |||
bom_ |
varchar2 |
Bills of Materials, also called recipes, are used to autocomplete components and work order instructions. | |||
check_ |
varchar2 |
||||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
components_ |
varchar2 |
Component Status | Latest component availability status for this MO. If green, then the MO's readiness status is ready, as per BOM configuration. | ||
components_ |
varchar2 |
Components Availability State | |||
confirm_ |
boolean |
Confirm Cancel | |||
consumption |
varchar2 |
Consumption | |||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
date_ |
datetime |
Deadline | Informative date allowing to define when the manufacturing order should be processed at the latest to fulfill delivery on time. | ||
date_ |
datetime |
End Date | |||
date_ |
datetime |
Scheduled End Date | Date at which you plan to finish the production. | ||
date_ |
datetime |
Scheduled Date | Date at which you plan to start the production. | ||
date_ |
datetime |
Start Date | |||
delay_ |
datetime |
Delay Alert Date | |||
delivery_ |
int32 |
Delivery Orders | |||
display_ |
varchar2 |
Display Name | |||
extra_ |
numeric |
Extra Unit Cost | |||
finished_ |
varchar2 |
||||
forecasted_ |
boolean |
Forecasted Issue | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is Locked | |||
is_ |
boolean |
Its Operations are Planned | |||
json_ |
varchar2 |
JSON data for the popover widget | |||
latest_ |
varchar2 |
||||
latest_ |
varchar2 |
||||
location_ |
varchar2 |
Location where the system will stock the finished products. | |||
location_ |
varchar2 |
Location where the system will stock the finished products. | |||
location_ |
varchar2 |
Location where the system will look for components. | |||
location_ |
varchar2 |
Location where the system will look for components. | |||
lot_ |
varchar2 |
||||
lot_ |
varchar2 |
||||
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 |
||||
move_ |
varchar2 |
||||
move_ |
varchar2 |
||||
mrp_ |
int32 |
Count of linked backorder | |||
mrp_ |
int32 |
Number of generated MO | |||
mrp_ |
int32 |
Number of source MO | |||
my_ |
datetime |
My Activity Deadline | |||
name |
varchar2 |
Reference | |||
orderpoint_ |
varchar2 |
||||
orderpoint_ |
varchar2 |
||||
origin |
varchar2 |
Source | Reference of the document that generated this production order request. | ||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
picking_ |
varchar2 |
||||
priority |
varchar2 |
Priority | Components will be reserved first for the MO with the highest priorities. | ||
procurement_ |
varchar2 |
||||
procurement_ |
varchar2 |
||||
product_ |
varchar2 |
Custom Description | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
numeric |
Quantity To Produce | |||
product_ |
varchar2 |
||||
product_ |
varchar2 |
||||
product_ |
varchar2 |
Tracking | Ensure the traceability of a storable product in your warehouse. | ||
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 |
||||
product_ |
varchar2 |
||||
product_ |
numeric |
Total Quantity | |||
product_ |
varchar2 |
||||
production_ |
numeric |
Production Capacity | Quantity that can be produced with the current stock of components | ||
production_ |
numeric |
Expected Duration | Total expected duration (in minutes) | ||
production_ |
varchar2 |
||||
production_ |
varchar2 |
||||
production_ |
numeric |
Real Duration | Total real duration (in minutes) | ||
propagate_ |
boolean |
Propagate cancel and split | If checked, when the previous move of the move (which was generated by a next procurement) is cancelled or split, the move generated by this move will too | ||
purchase_ |
int32 |
Count of generated PO | |||
qty_ |
numeric |
Quantity Produced | |||
qty_ |
numeric |
Quantity Producing | |||
quality_ |
int32 |
Quality Alert Count | |||
quality_ |
varchar2 |
||||
quality_ |
boolean |
Quality Check Fail | |||
quality_ |
boolean |
Quality Check Todo | |||
reservation_ |
varchar2 |
MO Readiness | Manufacturing readiness for this MO, as per bill of material configuration: * Ready: The material is available to start the production. * Waiting: The material is not available to start the production. | ||
reserve_ |
boolean |
Allowed to Reserve Production | Technical field to check when we can reserve quantities | ||
sale_ |
int32 |
Count of Source SO | |||
scrap_ |
int32 |
Scrap Move | |||
scrap_ |
varchar2 |
||||
show_ |
boolean |
Show Allocation | Technical Field used to decide whether the button "Allocation" should be displayed. | ||
show_ |
boolean |
Show Final Lots | |||
show_ |
boolean |
Show Lock/unlock buttons | |||
show_ |
boolean |
Display the serial number shortcut on the moves | |||
show_ |
boolean |
Show Produce | Technical field to check if produce button can be shown | ||
show_ |
boolean |
Show Produce All | Technical field to check if produce all button can be shown | ||
show_ |
boolean |
Display the serial mass produce wizard action | |||
show_ |
boolean |
Show Valuation | |||
state |
varchar2 |
State | * Draft: The MO is not confirmed yet. * Confirmed: The MO is confirmed, the stock rules and the reordering of the components are trigerred. * In Progress: The production has started (on the MO or on the WO). * To Close: The production is done, the MO has to be closed. * Done: The MO is closed, the stock moves are posted. * Cancelled: The MO has been cancelled, can't be confirmed anymore. | ||
unbuild_ |
int32 |
Number of Unbuilds | |||
unbuild_ |
varchar2 |
||||
unreserve_ |
boolean |
Allowed to Unreserve Production | Technical field to check when we can unreserve | ||
use_ |
boolean |
Consume Reserved Lots/Serial Numbers automatically | Allow automatic consumption of tracked components that are reserved | ||
use_ |
boolean |
Create New Lots/Serial Numbers for Components | Allow to create new lot/serial numbers for the components | ||
user_ |
varchar2 |
||||
user_ |
varchar2 |
||||
warehouse_ |
varchar2 |
||||
warehouse_ |
varchar2 |
||||
website_ |
varchar2 |
Website communication history | |||
workorder_ |
varchar2 |
||||
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: