report |
Manufacturing Report
Catalog: Odoo
Schema: mrp
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table report are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
byproduct_cost |
decimal |
By-Products Total Cost |
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
component_cost |
decimal |
Total Component Cost |
☐ |
Total cost of components for manufacturing order |
currency_id_label |
string |
|
☐ |
|
currency_id |
string |
|
☐ |
|
date_finished |
datetime |
End Date |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
duration |
decimal |
Total Duration of Operations |
☐ |
Total duration (minutes) of operations for manufacturing order |
id |
int32 |
ID |
☐ |
|
operation_cost |
decimal |
Total Operation Cost |
☐ |
Total cost of operations for manufacturing order |
product_id_label |
string |
|
☐ |
|
product_id |
string |
|
☐ |
|
production_id_label |
string |
|
☐ |
|
production_id |
string |
|
☐ |
|
qty_produced |
decimal |
Quantity Produced |
☐ |
Total quantity produced in product's UoM |
total_cost |
decimal |
Total Cost |
☐ |
Total cost of manufacturing order (component + operation costs) |
unit_component_cost |
decimal |
Component Cost / Unit |
☐ |
Component cost per unit produced (in product UoM) of manufacturing order |
unit_cost |
decimal |
Cost / Unit |
☐ |
Cost per unit produced (in product UoM) of manufacturing order |
unit_duration |
decimal |
Duration of Operations / Unit |
☐ |
Operation duration (minutes) per unit produced of manufacturing order |
unit_operation_cost |
decimal |
Total Operation Cost / Unit |
☐ |
Operation cost per unit produced (in product UoM) of manufacturing order |
01-03-2023 15:29 Version 22.1.135-BETA+3826