Bom_revisions
This table stores the Bill of Materials (BOM) Revision record which represents a version of the BOM record for a given effective date range. BOM Revision cannot exist without a BOM record.
The Advanced Bill of Materials feature must be enabled.
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| bill_of_materials_id |
NUMBER |
|
39 |
0 |
bill_of_materials_id
|
Bill_of_materials
|
Bill of Materials ID |
| bom_revision_extid |
VARCHAR2 |
255 |
|
|
|
|
BOM Revision External ID |
| bom_revision_id |
NUMBER |
|
39 |
0 |
|
|
Bill of Materials Revision ID |
| date_created |
TIMESTAMP |
|
|
|
|
|
Date created |
| date_effective |
TIMESTAMP |
|
|
|
|
|
Date effective |
| date_obsolete |
TIMESTAMP |
|
|
|
|
|
Date obsolete |
| 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 |
128 |
|
|
|
|
Name |
Primary key
| PK Column Name |
| bom_revision_id |
Foreign keys in this table
| FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
| bom_revisions_bill_of_materials_fk |
bill_of_materials_id |
Bill_of_materials |
bill_of_materials_id |
1 |
Foreign keys referencing this table
| FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
| Bom_revision_components_bom_revisions_fk |
bom_revision_id |
Bom_revision_components |
bom_revision_id |
1 |