ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Discuss (0)
View Page Code
History
SH.PRODUCTS_(table)
Print
RSS
Modified: 2009/08/29 21:04 by
wikibot
-
Uncategorized
(5)
»
dbo.ErrorLog_(table)
»
OE.STYLESHEET_TAB_(table)
»
SH.PRODUCTS_(table)
[X]
»
Production.ProductModelIllustration_(table)
»
public.vlan_(table)
»
dbo.ErrorLog_(table)
»
OE.STYLESHEET_TAB_(table)
»
SH.PRODUCTS_(table)
Edit
wikibot
Table
SH.PRODUCTS
Column
Data Type
Nullable
Default
PK
Index
PROD_ID
NUMBER(6, 0)
not null
PRODUCTS_PK
PROD_NAME
VARCHAR2(50)
not null
PROD_DESC
VARCHAR2(4000)
not null
PROD_SUBCATEGORY
VARCHAR2(50)
not null
PRODUCTS_PROD_SUBCAT_IX
PROD_SUBCATEGORY_ID
NUMBER
not null
PROD_SUBCATEGORY_DESC
VARCHAR2(2000)
not null
PROD_CATEGORY
VARCHAR2(50)
not null
PRODUCTS_PROD_CAT_IX
PROD_CATEGORY_ID
NUMBER
not null
PROD_CATEGORY_DESC
VARCHAR2(2000)
not null
PROD_WEIGHT_CLASS
NUMBER(3, 0)
not null
PROD_UNIT_OF_MEASURE
VARCHAR2(20)
null
PROD_PACK_SIZE
VARCHAR2(30)
not null
SUPPLIER_ID
NUMBER(6, 0)
not null
PROD_STATUS
VARCHAR2(20)
not null
PRODUCTS_PROD_STATUS_BIX
PROD_LIST_PRICE
NUMBER(8, 2)
not null
PROD_MIN_PRICE
NUMBER(8, 2)
not null
PROD_TOTAL
VARCHAR2(13)
not null
PROD_TOTAL_ID
NUMBER
not null
PROD_SRC_ID
NUMBER
null
PROD_EFF_FROM
DATE(7)
null
PROD_EFF_TO
DATE(7)
null
PROD_VALID
VARCHAR2(1)
null
Detail Table
Column
Referencing Column
SH.COSTS
PROD_ID
PROD_ID
SH.SALES
PROD_ID
PROD_ID
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.