Difference between revisions of "OE.INVENTORIES (table)"

From dbscript Online Help
Jump to: navigation, search
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
−
| '''table
+
| '''Table
 
| OE.INVENTORIES
 
| OE.INVENTORIES
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Tracks availability of products by product_it and warehouse_id.
 +
|}
 +
 
 +
=== Columns ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
 
 +
|- valign="top"
 +
| PRODUCT_ID
 +
| NUMBER(6, 0)
 +
| not null
 +
|
 +
| Part of concatenated primary key, references product_information.product_id.
 +
|- valign="top"
 +
| WAREHOUSE_ID
 +
| NUMBER(3, 0)
 +
| not null
 +
|
 +
| Part of concatenated primary key, references warehouses.warehouse_id.
 +
|- valign="top"
 +
| QUANTITY_ON_HAND
 +
| NUMBER(8, 0)
 +
| not null
 +
|
 +
|
 +
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| INVENTORY_IX
 +
| WAREHOUSE_ID, PRODUCT_ID
 +
|}
 +
 
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 
 +
|- valign="top"
 +
| INV_PRODUCT_IX
 +
|
 +
| PRODUCT_ID
 +
|}
 +
 
 +
=== Check Constraints ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Check Constraint
 +
| '''Expression
 +
| '''Description
 +
 
 +
|- valign="top"
 +
| INVENTORY_QOH_NN
 +
| "QUANTITY_ON_HAND" IS NOT NULL
 +
|
 +
|- valign="top"
 +
| INVENTORY_WAREHOUSE_ID_NN
 +
| "WAREHOUSE_ID" IS NOT NULL
 +
|
 +
|}
 +
 
 +
=== Foreign Keys ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 
 +
|- valign="top"
 +
| [[OE.PRODUCT_INFORMATION_(table)|OE.PRODUCT_INFORMATION]]
 +
| PRODUCT_ID
 +
| PRODUCT_ID
 +
|- valign="top"
 +
| [[OE.WAREHOUSES_(table)|OE.WAREHOUSES]]
 +
| WAREHOUSE_ID
 +
| WAREHOUSE_ID
 
|}
 
|}

Latest revision as of 10:34, 27 August 2011

wikibot[edit]

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

Columns[edit]

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[edit]

Primary Key Columns
INVENTORY_IX WAREHOUSE_ID, PRODUCT_ID

Indexes[edit]

Index Type Columns
INV_PRODUCT_IX PRODUCT_ID

Check Constraints[edit]

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

Foreign Keys[edit]

Relation Column Referenced Column
OE.PRODUCT_INFORMATION PRODUCT_ID PRODUCT_ID
OE.WAREHOUSES WAREHOUSE_ID WAREHOUSE_ID
Retrieved from "http://dbshelp.devio.at/index.php?title=OE.INVENTORIES_(table)&oldid=3070"