Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
bom_quantity | NUMBER | 18 | 8 | BOM quantity | |||
component_yield | NUMBER | 39 | 0 | Component yield | |||
effective_date | TIMESTAMP | Effective date | |||||
effective_revision | NUMBER | 39 | 0 | Effective revision | |||
item_group_id | NUMBER | 39 | 0 | Item Group ID | |||
item_source | VARCHAR2 | 30 | Item source | ||||
line_id | NUMBER | 39 | 0 | Line ID | |||
member_id | NUMBER | 39 | 0 | Member ID | |||
obsolete_date | TIMESTAMP | Obsolete day | |||||
obsolete_revision | NUMBER | 39 | 0 | Obsolete revision | |||
parent_id | NUMBER | 39 | 0 | Parent ID | |||
quantity | NUMBER | 18 | 8 | Quantity | |||
rate_plan_id | NUMBER | 39 | 0 | Rate plan ID. This field is no longer supported. | |||
unit_of_measure_id | NUMBER | 39 | 0 |
uom_id |
Uom |
PK Column Name |
---|
item_group_id |
FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
---|---|---|---|---|
item_group_uom_fk | unit_of_measure_id | Uom | uom_id | 1 |