Item_group

Columns

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

Primary key

PK Column Name
item_group_id

Foreign keys in this table

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