SALES_ORDER_ITEMS


<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   SALES_ORDER_ITEMS   

Name Datatype Precision Allow Null Identity Description
ID number NOT NULL Column
LINE_ID number NOT NULL Column
PROD_ID number NOT NULL Column
QUANTITY NULL Virtual column
SALES_ORDER_ID number NOT NULL Column
SHIP_DATE NULL

Name Columns Unique Description
SALES_ORDER_ITEMS_LINEID LINE_ID

No Data

Name ANSI Nulls On Quoted Identifier On On Description
TRG_ORDER before ; insert
TRG_SALE_ORDER_ITEMS before ; delete

     
Name Types Description
<DEFAULT SCHEMA>.PRODUCT Table Table
<DEFAULT SCHEMA>.SALES_ORDER Table Table
NUMBER PL/SQL System type PL/SQL System Object
<DEFAULT SCHEMA>.SALES_ORDER.ID Primary Key Column
<DEFAULT SCHEMA>.PRODUCT.ID Primary Key Column

     
Name Types Description
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS View View
<DEFAULT SCHEMA>.TRG_ORDER Trigger Simple Trigger of BEFORE "INSERT on sales_order_items"
<DEFAULT SCHEMA>.TRG_SALE_ORDER_ITEMS Trigger Simple Trigger of BEFORE "DELETE on sales_order_items"
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.c1 Cursor PLSQL Cursor defined in PRODUCTS.ProductsByCustomer
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS_LINEID Index
<DEFAULT SCHEMA>.TRG_SALE_ORDER_ITEMS.NEW PseudoRecord SALES_ORDER_ITEMS
<DEFAULT SCHEMA>.TRG_ORDER.NEW PseudoRecord SALES_ORDER_ITEMS
<DEFAULT SCHEMA>.TRG_ORDER.OLD PseudoRecord SALES_ORDER_ITEMS
<DEFAULT SCHEMA>.TRG_SALE_ORDER_ITEMS.OLD PseudoRecord SALES_ORDER_ITEMS
<DEFAULT SCHEMA>.SALEORDER.DeleteOrderItemById.Delete Delete Statement DELETE sales_order_items where id = orderId
<DEFAULT SCHEMA>.EMPLOYEES.OrdersByEmployee2.Select Select Statement SELECT sales_order.id Oid, sales_order.order_date Odate, DECODE(sales_order.fi
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.c1.Select Select Statement SELECT product.id Pid, product.name prod_name, sum (sales_order_items.quantity*unit_price) P
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select Select Statement SELECT Count(*) into Prod_num FROM customer, product, sales_order_items,
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS.Select Select Statement SELECT sales_order.id, sales_order.order_date, sales_order.fin_code_id, sales_
<DEFAULT SCHEMA>.PRODUCTSBYCUSTOMER.Select Select Statement SELECT product.* FROM SALES_ORDER_ITEMS join customer c on customerId = c.id join SALES_
d_tab_sales_order_items.sales_order_items_id Datawindow Column UI
d_tab_sales_order_items.sales_order_items_line_id Datawindow Column UI
d_tab_sales_order_items.sales_order_items_prod_id Datawindow Column UI
d_tab_sales_order_items.sales_order_items_quantity Datawindow Column UI
d_tab_sales_order_items.sales_order_items_ship_date Datawindow Column UI
d_tab_sales_order_items.table.update Datawindow Attribute
d_tab_sales_order_items.Retrieve SQL Datawindow DataSource
d_tab_sales_order.Retrieve SQL Datawindow DataSource