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