Difference between revisions of "OE.ORDERS (table)"

From dbscript Online Help
Jump to: navigation, search
 
Line 90: Line 90:
 
| '''Columns
 
| '''Columns
  
|- valign="top"
 
| ORD_SALES_REP_IX
 
|
 
| SALES_REP_ID
 
 
|- valign="top"
 
|- valign="top"
 
| ORD_CUSTOMER_IX
 
| ORD_CUSTOMER_IX
Line 102: Line 98:
 
|  
 
|  
 
| ORDER_DATE
 
| ORDER_DATE
 +
|- valign="top"
 +
| ORD_SALES_REP_IX
 +
|
 +
| SALES_REP_ID
 
|}
 
|}
  
Line 157: Line 157:
 
| ORDER_ID
 
| ORDER_ID
 
| ORDER_ID
 
| ORDER_ID
|}
 
 
=== Dependencies ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
| '''Reference Type
 
| '''Object Type
 
| '''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
 
| View
 
| [[OE.ORDERS_VIEW_(view)|OE.ORDERS_VIEW]]
 
 
|- valign="top"
 
| Insert
 
| Trigger
 
| [[OE.ORDERS_TRG_()|OE.ORDERS_TRG]]
 
 
 
|}
 
|}

Latest revision as of 10:35, 27 August 2011

wikibot[edit]

Table OE.ORDERS
Description Contains orders entered by a salesperson as well as over the Web.

Columns[edit]

Column Data Type Nullable Default Description
ORDER_ID NUMBER(12, 0) not null PRIMARY KEY column.
ORDER_DATE TIMESTAMP(6) WITH LOCAL TIME ZONE not null TIMESTAMP WITH LOCAL TIME ZONE column, NOT NULL constraint.
ORDER_MODE VARCHAR2(8) null CHECK constraint.
CUSTOMER_ID NUMBER(6, 0) not null
ORDER_STATUS NUMBER(2, 0) null 0: Not fully entered, 1: Entered, 2: Canceled - bad credit, -

3: Canceled - by customer, 4: Shipped - whole order, - 5: Shipped - replacement items, 6: Shipped - backlog on items, - 7: Shipped - special delivery, 8: Shipped - billed, 9: Shipped - payment plan,- 10: Shipped - paid

ORDER_TOTAL NUMBER(8, 2) null CHECK constraint.
SALES_REP_ID NUMBER(6, 0) null References hr.employees.employee_id.
PROMOTION_ID NUMBER(6, 0) null Sales promotion ID. Used in SH schema

Primary Key[edit]

Primary Key Columns
ORDER_PK ORDER_ID

Indexes[edit]

Index Type Columns
ORD_CUSTOMER_IX CUSTOMER_ID
ORD_ORDER_DATE_IX ORDER_DATE
ORD_SALES_REP_IX SALES_REP_ID

Check Constraints[edit]

Check Constraint Expression Description
ORDER_CUSTOMER_ID_NN "CUSTOMER_ID" IS NOT NULL
ORDER_DATE_NN "ORDER_DATE" IS NOT NULL
ORDER_MODE_LOV order_mode in ('direct','online')
ORDER_TOTAL_MIN order_total >= 0

Foreign Keys[edit]

Relation Column Referenced Column
OE.CUSTOMERS CUSTOMER_ID CUSTOMER_ID
HR.EMPLOYEES SALES_REP_ID EMPLOYEE_ID

Detail Tables[edit]

Detail Table Column Referencing Column
OE.ORDER_ITEMS ORDER_ID ORDER_ID