scrap |
Scrap
Catalog: Odoo
Schema: stock
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 scrap are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
_barcode_scanned |
string |
Barcode Scanned |
☐ |
Value of the last barcode scanned. |
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
date_done |
datetime |
Date |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
has_message |
boolean |
Has Message |
☐ |
|
id |
int32 |
ID |
☐ |
|
location_id_label |
string |
|
☐ |
|
location_id |
string |
|
☐ |
|
lot_id_label |
string |
|
☐ |
|
lot_id |
string |
|
☐ |
|
message_attachment_count |
int32 |
Attachment Count |
☐ |
|
message_follower_ids |
string |
|
☐ |
|
message_has_error_counter |
int32 |
Number of errors |
☐ |
Number of messages with delivery error |
message_has_error |
boolean |
Message Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_has_sms_error |
boolean |
SMS Delivery error |
☐ |
If checked, some messages have a delivery error. |
message_ids |
string |
|
☐ |
|
message_is_follower |
boolean |
Is Follower |
☐ |
|
message_main_attachment_id_label |
string |
|
☐ |
|
message_main_attachment_id |
string |
|
☐ |
|
message_needaction_counter |
int32 |
Number of Actions |
☐ |
Number of messages which requires an action |
message_needaction |
boolean |
Action Needed |
☐ |
If checked, new messages require your attention. |
message_partner_ids |
string |
|
☐ |
|
move_id_label |
string |
|
☐ |
|
move_id |
string |
|
☐ |
|
name |
string |
Reference |
☑ |
|
origin |
string |
Source Document |
☐ |
|
owner_id_label |
string |
|
☐ |
|
owner_id |
string |
|
☐ |
|
package_id_label |
string |
|
☐ |
|
package_id |
string |
|
☐ |
|
picking_id_label |
string |
|
☐ |
|
picking_id |
string |
|
☐ |
|
product_barcode |
string |
Barcode |
☐ |
International Article Number used for product identification. |
product_id_label |
string |
|
☐ |
|
product_id |
string |
|
☐ |
|
product_uom_category_id_label |
string |
|
☐ |
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 |
string |
|
☐ |
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_id_label |
string |
|
☐ |
|
product_uom_id |
string |
|
☐ |
|
production_id_label |
string |
|
☐ |
|
production_id |
string |
|
☐ |
|
scrap_location_id_label |
string |
|
☐ |
|
scrap_location_id |
string |
|
☐ |
|
scrap_qty |
decimal |
Quantity |
☑ |
|
state |
string |
Status |
☐ |
|
tracking |
string |
Product Tracking |
☐ |
Ensure the traceability of a storable product in your warehouse. |
website_message_ids |
string |
|
☐ |
Website communication history |
workorder_id_label |
string |
|
☐ |
|
workorder_id |
string |
|
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826