OE.ORDER ITEMS (table) - Revision history

Bot at 09:35, 27 August 2011

2011-08-27T09:35:02Z

Bot at 05:15, 24 June 2010

2010-06-24T05:15:34Z

Bot at 07:28, 11 February 2010

2010-02-11T07:28:17Z

Bot at 19:00, 24 August 2009

2009-08-24T19:00:59Z

Bot at 18:57, 24 August 2009

2009-08-24T18:57:17Z

Bot: 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...

2009-05-02T17:06:05Z

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...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''Table
| 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
|}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | OE.ORDER_ITEMS
@@ Line 8: / Line 8: @@
 | '''Description
 | Example of many-to-many resolution.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
-|-
+|- valign="top"
 | ORDER_ID
 | NUMBER(12, 0)
@@ Line 27: / Line 25: @@
+|
 | Part of concatenated primary key, references orders.order_id.
-|-
+|- valign="top"
 | LINE_ITEM_ID
 | NUMBER(3, 0)
@@ Line 33: / Line 31: @@
+|
 | Part of concatenated primary key.
-|-
+|- valign="top"
 | PRODUCT_ID
 | NUMBER(6, 0)
@@ Line 39: / Line 37: @@
+|
 | References product_information.product_id.
-|-
+|- valign="top"
 | UNIT_PRICE
 | NUMBER(8, 2)
@@ Line 45: / Line 43: @@
+|
+|
-|-
+|- valign="top"
 | QUANTITY
 | NUMBER(8, 0)
@@ Line 58: / Line 56: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | ORDER_ITEMS_PK
 | ORDER_ID, LINE_ITEM_ID
@@ Line 69: / Line 67: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | ITEM_ORDER_IX
+|
 | ORDER_ID
-|-
+|- valign="top"
 | ITEM_PRODUCT_IX
+|
 | PRODUCT_ID
-|-
+|- valign="top"
 | ORDER_ITEMS_UK
+|
@@ Line 90: / Line 88: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | SYS_C005039
 | "LINE_ITEM_ID" IS NOT NULL
+|
-|-
+|- valign="top"
 | SYS_C005040
 | "PRODUCT_ID" IS NOT NULL
@@ Line 107: / Line 105: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[OE.ORDERS_(table)|OE.ORDERS]]
 | ORDER_ID
 | ORDER_ID
-|-
+|- valign="top"
 | [[OE.PRODUCT_INFORMATION_(table)|OE.PRODUCT_INFORMATION]]
 | PRODUCT_ID
@@ Line 125: / Line 123: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Select
 | View
 | [[OE.OC_CORPORATE_CUSTOMERS_(view)|OE.OC_CORPORATE_CUSTOMERS]]
-|-
+|- valign="top"
 | Select
 | View
 | [[OE.OC_CUSTOMERS_(view)|OE.OC_CUSTOMERS]]
-|-
+|- valign="top"
 | Select
 | View
 | [[OE.OC_ORDERS_(view)|OE.OC_ORDERS]]
-|-
+|- valign="top"
 | Select
 | Trigger
-| [[OE.INSERT_ORD_LINE|OE.INSERT_ORD_LINE]]
+| [[OE.INSERT_ORD_LINE_()|OE.INSERT_ORD_LINE]]
 |}