eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: OP_PRCE_ITM

Product:	GML - Process Manufacturing Logistics
Description:	Item prices on a pricelist.
Implementation/DBA Data:	GML.OP_PRCE_ITM

Primary Key: OP_PRCE_ITMI1

PRICELIST_ID
PRICE_CLASS
ITEM_ID
WHSE_CODE
QC_GRADE
PRICE_UM
FRTBILL_MTHD
LINE_NO

Primary Key: OP_PRCE_ITM_PK

PRICE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
OP_PRCE_ITM	GMD_GRADES_B	OP_PRCE_ITM.QC_GRADE
OP_PRCE_ITM	IC_ITEM_MST_B	OP_PRCE_ITM.ITEM_ID
OP_PRCE_ITM	IC_ITEM_MST	OP_PRCE_ITM.ITEM_ID
OP_PRCE_ITM	IC_PRCE_CLS	OP_PRCE_ITM.PRICE_CLASS
OP_PRCE_ITM	IC_WHSE_MST	OP_PRCE_ITM.WHSE_CODE
OP_PRCE_ITM	OP_FRGT_MTH	OP_PRCE_ITM.FRTBILL_MTHD
OP_PRCE_ITM	OP_PRCE_MST	OP_PRCE_ITM.PRICELIST_ID
OP_PRCE_ITM	OP_TEXT_HDR	OP_PRCE_ITM.TEXT_CODE
OP_PRCE_ITM	QC_GRAD_MST	OP_PRCE_ITM.QC_GRADE
OP_PRCE_ITM	SY_UOMS_MST	OP_PRCE_ITM.PRICE_UM
OP_PRCE_BRK	OP_PRCE_ITM	OP_PRCE_BRK.PRICE_ID