Difference between revisions of "OE.ORDER ITEMS (table)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | OE.ORDER_ITEMS |- |} {| border="1" cellpadding="5" cellspacing="0" style="bo...)
 
Line 3: Line 3:
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|-
 
|-
| '''Table
+
| '''table
 
| OE.ORDER_ITEMS
 
| OE.ORDER_ITEMS
 
|-
 
|-
|}
 
 
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
| '''Column
 
| '''Data Type
 
| '''Nullable
 
| '''Default
 
| '''PK
 
| '''Index
 
 
|-
 
| ORDER_ID
 
| NUMBER
 
| not null
 
|
 
| ORDER_ITEMS_PK
 
| ITEM_ORDER_IXORDER_ITEMS_UK
 
|-
 
| LINE_ITEM_ID
 
| NUMBER
 
| not null
 
|
 
| ORDER_ITEMS_PK
 
|
 
|-
 
| PRODUCT_ID
 
| NUMBER
 
| not null
 
|
 
|
 
| ITEM_PRODUCT_IXORDER_ITEMS_UK
 
|-
 
| UNIT_PRICE
 
| NUMBER
 
| null
 
|
 
|
 
|
 
|-
 
| QUANTITY
 
| NUMBER
 
| null
 
|
 
|
 
|
 
|}
 
 
 
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
| '''Relation
 
| '''Column
 
| '''Referenced Column
 
 
|-
 
| [[OE.ORDERS_(table)|OE.ORDERS]]
 
| ORDER_ID
 
| ORDER_ID
 
|-
 
| [[OE.PRODUCT_INFORMATION_(table)|OE.PRODUCT_INFORMATION]]
 
| PRODUCT_ID
 
| PRODUCT_ID
 
 
|}
 
|}

Revision as of 20:57, 24 August 2009

wikibot

table OE.ORDER_ITEMS