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
OE.ORDER_ITEMS_(table)
Print
RSS
Modified: 2009/08/29 21:04 by
wikibot
-
Uncategorized
»
HumanResources.EmployeePayHistory_(table)
»
OE.ORDER_ITEMS_(table)
[X]
»
HumanResources.EmployeePayHistory_(table)
»
OE.ORDER_ITEMS_(table)
Edit
wikibot
Table
OE.ORDER_ITEMS
Column
Data Type
Nullable
Default
PK
Index
ORDER_ID
NUMBER(12, 0)
not null
ORDER_ITEMS_PK
ITEM_ORDER_IXORDER_ITEMS_UK
LINE_ITEM_ID
NUMBER(3, 0)
not null
ORDER_ITEMS_PK
PRODUCT_ID
NUMBER(6, 0)
not null
ITEM_PRODUCT_IXORDER_ITEMS_UK
UNIT_PRICE
NUMBER(8, 2)
null
QUANTITY
NUMBER(8, 0)
null
Relation
Column
Referenced Column
OE.ORDERS
ORDER_ID
ORDER_ID
OE.PRODUCT_INFORMATION
PRODUCT_ID
PRODUCT_ID
ScrewTurn Wiki
version 2.0.36. Some of the icons created by
FamFamFam
.