PowerCenter
- PowerCenter 10.5
- All Products
Type of Costs
| Datatype
| Description
|
---|---|---|
ProductID | varchar | A unique number that identifies the product to update. |
WUnitPrice | number | Wholesale unit price. |
WPkgPrice | number | Wholesale package price. |
RUnitPrice | number | Retail unit price. |
RPkgPrice | number | Retail package price. |
MUnitPrice | number | Manufacturers unit price. |
MPkgPrice | number | Manufacturers package price. |
Create table Prod_Cost (ProductId varchar (10), WUnitPrice number, WPkgPrice number, RUnitPrice number, RPkgPrice number,MUnitPrice number, MPkgPrice number ); insert into Prod_Cost values('100',0,0,0,0,0,0); insert into Prod_Cost values('200',0,0,0,0,0,0); insert into Prod_Cost values('300',0,0,0,0,0,0); commit;