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_EFF

Product:	GML - Process Manufacturing Logistics
Description:	Pricing effectivities to establish active price lists, contracts or charges.
Implementation/DBA Data:	GML.OP_PRCE_EFF

Primary Key: OP_PRCE_EFFI1

ORGN_CODE
CUSTPRICE_CLASS
CUST_ID
TERRITORY
START_DATE
END_DATE
PREFERENCE
EFFECTIVITY_TYPE
PRICELIST_ID
CONTRACT_ID
CHARGE_ID

Primary Key: OP_PRCE_EFF_PK

PRICEFF_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
OP_PRCE_EFF	OP_CHRG_MST	OP_PRCE_EFF.CHARGE_ID
OP_PRCE_EFF	OP_CNTR_HDR	OP_PRCE_EFF.CONTRACT_ID
OP_PRCE_EFF	OP_CPRC_CLS	OP_PRCE_EFF.CUSTPRICE_CLASS
OP_PRCE_EFF	OP_CUST_MST	OP_PRCE_EFF.CUST_ID
OP_PRCE_EFF	OP_PRCE_MST	OP_PRCE_EFF.PRICELIST_ID
OP_PRCE_EFF	OP_TEXT_HDR	OP_PRCE_EFF.TEXT_CODE
OP_PRCE_EFF	SY_ORGN_MST_B	OP_PRCE_EFF.ORGN_CODE
OP_PRCE_EFF	SY_ORGN_MST	OP_PRCE_EFF.ORGN_CODE
OP_ORDR_DTL	OP_PRCE_EFF	OP_ORDR_DTL.PRICEFF_ID