Assembly_boms
Mapping table between Assembly and Bill of Materials. The Bill of Materials feature must be enabled.
Columns
Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
assembly_id |
NUMBER |
|
39 |
0 |
item_id
|
Items
|
Assembly ID |
bill_of_materials_id |
NUMBER |
|
39 |
0 |
bill_of_materials_id
|
Bill_of_materials
|
Bill of Materials ID |
Primary key (Composite)
PK Column Name |
assembly_id |
bill_of_materials_id |
Foreign keys in this table
FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
assembly_boms_bill_of_materials_fk |
bill_of_materials_id |
Bill_of_materials |
bill_of_materials_id |
1 |
assembly_boms_items_fk |
assembly_id |
Items |
item_id |
1 |