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 WAREHOUSES (table)
Print
RSS
Modified on 2011/08/27 12:10
by
wikibot
Categorized as
Uncategorized
HR LOCATIONS (table)
OE INVENTORIES (table)
public node (table)
Sales (schema)
Sales SalesPerson (table)
public assets (table)
public atinterface (table)
public category_node (table)
public datalinkinterface (table)
public distpoller (table)
public ifservices (table)
public inventory (table)
public ipinterface (table)
public iprouteinterface (table)
public notifications (table)
public outages (table)
public pathoutage (table)
public snmpinterface (table)
public stpinterface (table)
public stpnode (table)
public vlan (table)
HR LOCATIONS (table)
OE INVENTORIES (table)
public node (table)
Sales (schema)
Sales SalesPerson (table)
(4)
»
Sales SalesPersonQuotaHistory (table)
»
public stpinterface (table)
»
OE WAREHOUSES (table)
[X]
»
public node (table)
»
Sales SalesPersonQuotaHistory (table)
»
public stpinterface (table)
»
OE WAREHOUSES (table)
wikibot
¶
Table
OE.WAREHOUSES
Description
Warehouse data unspecific to any industry.
Columns
¶
Column
Data Type
Nullable
Default
Description
WAREHOUSE_ID
NUMBER(3, 0)
not null
Primary key column.
WAREHOUSE_SPEC
SYS.XMLTYPE
null
WAREHOUSE_NAME
VARCHAR2(35)
null
LOCATION_ID
NUMBER(4, 0)
null
WH_GEO_LOCATION
MDSYS.SDO_GEOMETRY
null
Primary key column, references hr.locations.location_id.
Primary Key
¶
Primary Key
Columns
WAREHOUSES_PK
WAREHOUSE_ID
Indexes
¶
Index
Type
Columns
WHS_LOCATION_IX
LOCATION_ID
Foreign Keys
¶
Relation
Column
Referenced Column
HR.LOCATIONS
LOCATION_ID
LOCATION_ID
Detail Tables
¶
Detail Table
Column
Referencing Column
OE.INVENTORIES
WAREHOUSE_ID
WAREHOUSE_ID
ScrewTurn Wiki
version 3.0.1.400. Some of the icons created by
FamFamFam
.