Welcome Guest, you are in: <root> • Login

Page History: OE INVENTORIES (table)

Compare Page Revisions

1 0 Current 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2010/02/11 09:19

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