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 Name (type)
dbo NameStyle (type)
dbo Phone (type)
dbo ufnGetContactInformation (function)
dbo uspGetEmployeeManagers (procedure)
dbo uspGetManagerEmployees (procedure)
HumanResources Employee (table)
HumanResources vEmployee (view)
HumanResources vEmployeeDepartment (view)
HumanResources vEmployeeDepartmentHistory (view)
Person (schema)
Person AdditionalContactInfoSchemaCollection (xml schema collection)
Person vAdditionalContactInfo (view)
Purchasing VendorContact (table)
Purchasing vVendor (view)
Sales ContactCreditCard (table)
Sales Individual (table)
Sales SalesOrderHeader (table)
Sales StoreContact (table)
Sales vIndividualCustomer (view)
Sales vSalesPerson (view)
Sales vSalesPersonSalesByFiscalYears (view)
Sales vStoreWithDemographics (view)
OE PRODUCT_INFORMATION (table)
OE WAREHOUSES (table)
dbo Name (type)
dbo NameStyle (type)
dbo Phone (type)
dbo ufnGetContactInformation (function)
dbo uspGetEmployeeManagers (procedure)
dbo uspGetManagerEmployees (procedure)
HumanResources Employee (table)
HumanResources vEmployee (view)
HumanResources vEmployeeDepartment (view)
HumanResources vEmployeeDepartmentHistory (view)
Person (schema)
Person AdditionalContactInfoSchemaCollection (xml schema collection)
Person vAdditionalContactInfo (view)
Purchasing VendorContact (table)
Purchasing vVendor (view)
Sales ContactCreditCard (table)
Sales Individual (table)
Sales SalesOrderHeader (table)
Sales StoreContact (table)
Sales vIndividualCustomer (view)
Sales vSalesPerson (view)
Sales vSalesPersonSalesByFiscalYears (view)
Sales vStoreWithDemographics (view)
»
Person Contact (table)
»
OE INVENTORIES (table)
[X]
»
Person Contact (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
.