Welcome
Guest
, you are in:
<root>
•
Login
devio dbscript ScrewTurn Wiki
Navigation
¶
Main Page
Random Page
Create a new Page
All Pages
Categories
Navigation Paths
Administration
File Management
Create Account
Search the wiki
»
Discuss (0)
View Page Code
History
OE INVENTORIES (table)
Print
RSS
Modified on 2011/08/27 12:10
by
wikibot
Categorized as
Uncategorized
OE PRODUCT_INFORMATION (table)
OE WAREHOUSES (table)
dbo ufnGetContactInformation (function)
Person Contact (table)
Person ContactType (table)
Sales (schema)
Sales Store (table)
Sales vStoreWithDemographics (view)
Person Address (table)
Person AddressType (table)
Person Contact (table)
Person ContactType (table)
Person CountryRegion (table)
Person StateProvince (table)
Sales (schema)
Sales Customer (table)
Sales CustomerAddress (table)
Sales Store (table)
Sales StoreContact (table)
public application_service_map (table)
dbo Name (type)
dbo uspLogError (procedure)
dbo uspPrintError (procedure)
Sales (schema)
Sales Customer (table)
Sales Individual (table)
Sales SalesPerson (table)
Sales StoreContact (table)
Sales StoreSurveySchemaCollection (xml schema collection)
Sales vStoreWithDemographics (view)
public alarms (table)
HR EMPLOYEES (table)
HR JOB_HISTORY (table)
HR LOCATIONS (table)
HumanResources Employee (table)
Sales (schema)
Sales SalesOrderHeader (table)
Sales SalesPersonQuotaHistory (table)
Sales SalesTerritory (table)
Sales SalesTerritoryHistory (table)
Sales Store (table)
Sales vSalesPerson (view)
Sales vSalesPersonSalesByFiscalYears (view)
dbo Name (type)
HumanResources vEmployee (view)
Person (schema)
Person StateProvince (table)
Person vStateProvinceCountryRegion (view)
Purchasing vVendor (view)
Sales CountryRegionCurrency (table)
Sales vIndividualCustomer (view)
Sales vSalesPerson (view)
Sales vStoreWithDemographics (view)
Sales (schema)
Sales SpecialOfferProduct (table)
OE PRODUCT_INFORMATION (table)
OE WAREHOUSES (table)
dbo ufnGetContactInformation (function)
Person Contact (table)
Person ContactType (table)
Sales (schema)
Sales Store (table)
Sales vStoreWithDemographics (view)
Person Address (table)
Person AddressType (table)
Person Contact (table)
Person ContactType (table)
Person CountryRegion (table)
Person StateProvince (table)
Sales (schema)
Sales Customer (table)
Sales CustomerAddress (table)
Sales Store (table)
Sales StoreContact (table)
(10)
»
Sales vStoreWithDemographics (view)
»
Sales StoreContact (table)
»
OE INVENTORIES (table)
[X]
»
Sales SpecialOffer (table)
»
Person CountryRegion (table)
»
Sales SalesPerson (table)
»
HR DEPARTMENTS (table)
»
public alarm_attributes (table)
»
Sales Store (table)
»
public applications (table)
»
Sales vStoreWithDemographics (view)
»
Sales StoreContact (table)
»
OE INVENTORIES (table)
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
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.