NEWPRODUCT

Item Location

<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   NEWPRODUCT

Columns

Name	Datatype	Precision	Allow Null	Identity	Description
DESCRIPTION			NULL		Virtual column
ID	number		NOT NULL		Column
NAME	NVARCHAR2		NULL		Column
PROD_SIZE			NULL		Virtual column
QUANTITY			NULL		Virtual column
TOTAL_HT			NULL		Virtual column
UNIT_PRICE	FLOAT		NULL		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 “NEWPRODUCT”

Name	Types	Description
FLOAT	PL/SQL System type	PL/SQL System Object
NUMBER	PL/SQL System type	PL/SQL System Object
NVARCHAR2	PL/SQL System type	PL/SQL System Object

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

Name	Types	Description
<DEFAULT SCHEMA>.ALL_NEWPRODUCT	View	View
<DEFAULT SCHEMA>.ALL_NEWPRODUCT.Select	Select Statement	SELECT P.Name, P.Description, P.prod_size, P.Quantity, P.Total_HT, P.unit_price