Item_group
An item group is sold as a single unit, but are made up of several individual items.
An item group is a short cut for entering a group of items on a sales or purchase order that need to be sold or purchased together. The item group itself is not fulfilled, received or stocked, but rather the components of the group are. However, the item group is available in the item list on a sales or purchase order and can be added to those transactions.
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 |
item_id
|
Items
|
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
|
Unit of measure ID |
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_items_fk |
parent_id |
Items |
item_id |
1 |
item_group_uom_fk |
unit_of_measure_id |
Uom |
uom_id |
1 |