OE INVENTORIES (table)

Modified on 2011/08/27 12:10 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| 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
| &nbsp;
| Part of concatenated primary key, references product_information.product_id.
|- valign="top"
| WAREHOUSE_ID
| NUMBER(3, 0)
| not null
| &nbsp;
| Part of concatenated primary key, references warehouses.warehouse_id.
|- valign="top"
| QUANTITY_ON_HAND
| NUMBER(8, 0)
| not null
| &nbsp;
| &nbsp;
|}

=== 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
| &nbsp;
| 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
| &nbsp;
|- valign="top"
| INVENTORY_WAREHOUSE_ID_NN
| "WAREHOUSE_ID" IS NOT NULL
| &nbsp;
|}

=== 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
|}
devio dbscript ScrewTurn Wiki

Navigation¶

OE INVENTORIES (table)
