From dbscript Online Help
|
|
| Line 94: |
Line 94: |
| | | WAREHOUSE_ID | | | WAREHOUSE_ID |
| | | WAREHOUSE_ID | | | WAREHOUSE_ID |
| − | |}
| |
| − |
| |
| − | === Dependencies ===
| |
| − | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
| − | |- style="background:silver"
| |
| − | | '''Reference Type
| |
| − | | '''Object Type
| |
| − | | '''Referencing Object
| |
| − |
| |
| − | |- valign="top"
| |
| − | | Select
| |
| − | | View
| |
| − | | [[OE.BOMBAY_INVENTORY_(view)|OE.BOMBAY_INVENTORY]]
| |
| − |
| |
| − | |- valign="top"
| |
| − | | Select
| |
| − | | View
| |
| − | | [[OE.OC_INVENTORIES_(view)|OE.OC_INVENTORIES]]
| |
| − |
| |
| − | |- valign="top"
| |
| − | | Select
| |
| − | | View
| |
| − | | [[OE.SYDNEY_INVENTORY_(view)|OE.SYDNEY_INVENTORY]]
| |
| − |
| |
| − | |- valign="top"
| |
| − | | Select
| |
| − | | View
| |
| − | | [[OE.TORONTO_INVENTORY_(view)|OE.TORONTO_INVENTORY]]
| |
| − |
| |
| | |} | | |} |
Latest revision as of 11: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]
