Bill_of_materials
This table stores the Bill of Materials (BOM) records. BOMs list the Revisions, which contains quantities of raw materials, assemblies, sub-components, and parts needed to manufacture a product.
A BOM can have defined multiple revisions. BOM Revision records help determine the correct version for a given effective date.
The Advanced Bill of Materials feature must be enabled.
Columns
Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
available_for_all_assemblies |
VARCHAR2 |
3 |
|
|
|
|
Available for all Assemblies |
available_for_all_locations |
VARCHAR2 |
3 |
|
|
|
|
Available for all Locations |
bill_of_materials_extid |
VARCHAR2 |
255 |
|
|
|
|
BOM External ID |
bill_of_materials_id |
NUMBER |
|
39 |
0 |
|
|
Bill of Materials ID |
date_created |
TIMESTAMP |
|
|
|
|
|
Date created |
exclude_child_subsidiaries |
VARCHAR2 |
3 |
|
|
|
|
Exclude child subsidiaries |
form_template_component_id |
VARCHAR2 |
16 |
|
|
|
|
Form template component ID |
form_template_id |
NUMBER |
|
39 |
0 |
|
|
Form template ID |
is_inactive |
VARCHAR2 |
3 |
|
|
|
|
Is inactive |
memo |
VARCHAR2 |
1024 |
|
|
|
|
Memo |
name |
VARCHAR2 |
600 |
|
|
|
|
Name |
original_assembly_id |
NUMBER |
|
39 |
0 |
item_id
|
Items
|
Original assembly ID |
use_component_yield |
VARCHAR2 |
3 |
|
|
|
|
Use component yield |
Primary key
PK Column Name |
bill_of_materials_id |
Foreign keys in this table
FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
bill_of_materials_items_fk |
original_assembly_id |
Items |
item_id |
1 |
Foreign keys referencing this table
FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
Assembly_boms_bill_of_materials_fk |
bill_of_materials_id |
Assembly_boms |
bill_of_materials_id |
1 |
Bom_revisions_bill_of_materials_fk |
bill_of_materials_id |
Bom_revisions |
bill_of_materials_id |
1 |