bom: Odoo itgen_odoo_bom
read only per partition
- Catalogo:
Odoo - Schema:
mrp - Etichetta: itgen_odoo_bom
Distinta base
È possibile solo recuperare i dati.
Riepilogo
Defines bills of material for a product or a product template
Colonne della tabella
Di seguito sono riportate le colonne della tabella bom. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
active |
boolean |
Production Ready | |||
allow_ |
boolean |
Operation Dependencies | Create operation level dependencies that will influence both planning and the status of work orders upon MO confirmation.If this feature is ticked, and nothing is specified, Odoo will assume that all operations can be started simultaneously. | ||
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. | |||
bom_ |
varchar2 |
||||
byproduct_ |
varchar2 |
||||
code |
varchar2 |
Reference | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
consumption |
varchar2 |
Flexible Consumption | Defines if you can consume more or less components than the quantity defined on the BoM: * Allowed: allowed for all manufacturing users. * Allowed with warning: allowed for all manufacturing users with summary of consumption differences when closing the manufacturing order.Note that in the case of component Manual Consumption, where consumption is registered manually exclusively, consumption warnings will still be issued when appropriate also. * Blocked: only a manager can close a manufacturing order when the BoM consumption is not respected. | ||
create_ |
datetime |
Creato il | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Nome visualizzato | |||
eco_ |
int32 |
# ECOs | |||
eco_ |
varchar2 |
||||
eco_ |
int32 |
# ECOs in progress | |||
has_ |
boolean |
Has Message | |||
id |
int32 |
ID | |||
image_ |
varbinary |
Image 128 | |||
message_ |
int32 |
Numero di allegati | |||
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 |
Numero di azioni | Number of messages which requires an action | ||
message_ |
varchar2 |
||||
operation_ |
varchar2 |
||||
picking_ |
varchar2 |
When a procurement has a ‘produce’ route with a operation type set, it will try to create a Manufacturing Order for that product using a BoM of the same operation type.That allows to define stock rules which trigger different manufacturing orders with different BoMs. | |||
picking_ |
varchar2 |
When a procurement has a ‘produce’ route with a operation type set, it will try to create a Manufacturing Order for that product using a BoM of the same operation type.That allows to define stock rules which trigger different manufacturing orders with different BoMs. | |||
possible_ |
varchar2 |
||||
previous_ |
varchar2 |
||||
previous_ |
varchar2 |
||||
product_ |
varchar2 |
If a product variant is defined the BOM is available only for this product. | |||
product_ |
varchar2 |
If a product variant is defined the BOM is available only for this product. | |||
product_ |
numeric |
Quantity | This should be the smallest quantity that this product can be produced in.If the BOM contains operations, make sure the work center capacity is accurate. | ||
product_ |
varchar2 |
||||
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 |
Unit of Measure (Unit of Measure) is the unit of measurement for the inventory control | |||
product_ |
varchar2 |
Unit of Measure (Unit of Measure) is the unit of measurement for the inventory control | |||
ready_ |
varchar2 |
Manufacturing Readiness | |||
sequence |
int32 |
Sequence | |||
type |
varchar2 |
BoM Type | |||
version |
int32 |
Version | |||
website_ |
varchar2 |
Website communication history | |||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: