Bom_revision_components
This table stores the list of components which belong to one Bill of Materials (BOM) Revision. A BOM Revision Component cannot exist without a BOM Revision. In NetSuite UI it’s represented as a Component sublist.
The Advanced Bill of Materials feature must be enabled.
Columns
Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
bom_revision_component_id |
NUMBER |
|
39 |
0 |
|
|
Revision component ID |
bom_revision_id |
NUMBER |
|
39 |
0 |
bom_revision_id
|
Bom_revisions
|
Revision ID |
component_yield |
NUMBER |
|
39 |
0 |
|
|
Component Yield |
item_id |
NUMBER |
|
39 |
0 |
item_id
|
Items
|
Item ID |
item_source |
VARCHAR2 |
30 |
|
|
|
|
Item Source |
quantity |
NUMBER |
|
18 |
8 |
|
|
Quantity |
seq_num |
NUMBER |
|
39 |
0 |
|
|
Sequence Number |
unit_of_measure_id |
NUMBER |
|
39 |
0 |
uom_id
|
Uom
|
Unit of Measure ID |
Primary key
PK Column Name |
bom_revision_component_id |
Foreign keys in this table
FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
bom_revision_components_bom_revisions_fk |
bom_revision_id |
Bom_revisions |
bom_revision_id |
1 |
bom_revision_components_items_fk |
item_id |
Items |
item_id |
1 |
bom_revision_components_uom_fk |
unit_of_measure_id |
Uom |
uom_id |
1 |