OE.INVENTORIES (table)

From dbscript Online Help
Revision as of 06:15, 24 June 2010 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table OE.INVENTORIES
Description Tracks availability of products by product_it and warehouse_id.

Columns

Column Data Type Nullable Default Description
PRODUCT_ID NUMBER(6, 0) not null Part of concatenated primary key, references product_information.product_id.
WAREHOUSE_ID NUMBER(3, 0) not null Part of concatenated primary key, references warehouses.warehouse_id.
QUANTITY_ON_HAND NUMBER(8, 0) not null

Primary Key

Primary Key Columns
INVENTORY_IX WAREHOUSE_ID, PRODUCT_ID

Indexes

Index Type Columns
INV_PRODUCT_IX PRODUCT_ID

Check Constraints

Check Constraint Expression Description
INVENTORY_QOH_NN "QUANTITY_ON_HAND" IS NOT NULL
INVENTORY_WAREHOUSE_ID_NN "WAREHOUSE_ID" IS NOT NULL

Foreign Keys

Relation Column Referenced Column
OE.PRODUCT_INFORMATION PRODUCT_ID PRODUCT_ID
OE.WAREHOUSES WAREHOUSE_ID WAREHOUSE_ID

Dependencies

Reference Type Object Type Referencing Object
Select View OE.BOMBAY_INVENTORY
Select View OE.OC_INVENTORIES
Select View OE.SYDNEY_INVENTORY
Select View OE.TORONTO_INVENTORY