SALES_ORDER

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   SALES_ORDER

Columns

Name	Datatype	Precision	Allow Null	Identity	Description
CUST_ID			NULL		Virtual column
FIN_CODE_ID			NULL		Virtual column
ID	number		NOT NULL		Column
ORDER_DATE			NULL		Virtual column
REGION			NULL		Virtual column
SALES_REP	number		NOT NULL		Column
TOTAL_HT			NULL		Virtual column

Indexes

No Data

Check Constraints

No Data

Triggers

No Data

References
     The items listed in the matrix below are called / used by the Table “SALES_ORDER”

Name	Types	Description
<DEFAULT SCHEMA>.EMPLOYEE	Table	Table
NUMBER	PL/SQL System type	PL/SQL System Object
<DEFAULT SCHEMA>.EMPLOYEE.EMP_ID	Primary Key	Column

Impact Analysis
     The items listed in the matrix below are using / calling the Table “SALES_ORDER”

Name	Types	Description
<DEFAULT SCHEMA>.SALES_ORDER_ITEMS	Table	Table
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE	View	View
<DEFAULT SCHEMA>.ALL_ORDERS_BY_MANAGER	View	View
<DEFAULT SCHEMA>.ALL_SALES_ORDER_ITEMS_DETAILS	View	View
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.c1	Cursor	PLSQL Cursor defined in PRODUCTS.ProductsByCustomer
<DEFAULT SCHEMA>.SALEORDER.DeleteOrderById.Delete	Delete Statement	DELETE SALES_ORDER where id = orderId
<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>.EMPLOYEES.OrdersByEmployee2.Select	Select Statement	SELECT sales_order.id Oid, sales_order.order_date Odate, DECODE(sales_order.fi
<DEFAULT SCHEMA>.PRODUCTS.ProductsByCustomer.Select	Select Statement	SELECT Count(*) into Prod_num FROM customer, product, sales_order_items,
<DEFAULT SCHEMA>.ALL_ORDERS_BY_MANAGER.Select	Select Statement	SELECT SO.Id, SO.Cust_id, SO.Fin_Code_Id, SO.order_date, SO.region, SO.Sales_Rep,
<DEFAULT SCHEMA>.ALL_ORDERS_BY_EMPLOYEE.Select	Select Statement	SELECT SO.Id, SO.Cust_id, SO.Fin_Code_Id, SO.order_date, SO.region, SO.Sales_Rep,
<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_ff_sales_order.sales_order_cust_id	Datawindow Column UI
d_ff_sales_order.sales_order_fin_code_id	Datawindow Column UI
d_tab_sales_order.sales_order_fin_code_id	Datawindow Column UI
d_ff_sales_order.sales_order_id	Datawindow Column UI
d_tab_sales_order.sales_order_id	Datawindow Column UI
d_ff_sales_order.sales_order_order_date	Datawindow Column UI
d_tab_sales_order.sales_order_order_date	Datawindow Column UI
d_tab_sales_order.sales_order_region	Datawindow Column UI
d_ff_sales_order.sales_order_region	Datawindow Column UI
d_ff_sales_order.sales_order_sales_rep	Datawindow Column UI
d_ff_sales_order.sales_order_total_ht	Datawindow Column UI
d_ff_sales_order.table.update	Datawindow Attribute
d_ff_sales_order.Retrieve SQL	Datawindow DataSource
d_tab_sales_order.Retrieve SQL	Datawindow DataSource