Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: OE INVENTORIES (table)

Compare Page Revisions



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


Page Revision: 2010/02/11 09:19


wikibot

TableOE.INVENTORIES
DescriptionTracks availability of products by product_it and warehouse_id.

Columns

ColumnData TypeNullableDefaultDescription
PRODUCT_IDNUMBER(6, 0)not null Part of concatenated primary key, references product_information.product_id.
WAREHOUSE_IDNUMBER(3, 0)not null Part of concatenated primary key, references warehouses.warehouse_id.
QUANTITY_ON_HANDNUMBER(8, 0)not null  

Primary Key

Primary KeyColumns
INVENTORY_IXWAREHOUSE_ID, PRODUCT_ID

Indexes

IndexTypeColumns
INV_PRODUCT_IX PRODUCT_ID

Check Constraints

Check ConstraintExpressionDescription
INVENTORY_QOH_NN"QUANTITY_ON_HAND" IS NOT NULL 
INVENTORY_WAREHOUSE_ID_NN"WAREHOUSE_ID" IS NOT NULL 

Foreign Keys

RelationColumnReferenced Column
OE.PRODUCT_INFORMATIONPRODUCT_IDPRODUCT_ID
OE.WAREHOUSESWAREHOUSE_IDWAREHOUSE_ID

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewOE.BOMBAY_INVENTORY
SelectViewOE.OC_INVENTORIES
SelectViewOE.SYDNEY_INVENTORY
SelectViewOE.TORONTO_INVENTORY

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.