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