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_GNRC_ITM

Product:	GML - Process Manufacturing Logistics
Description:	Customer and generic (alternate) names for items.
Implementation/DBA Data:	GML.OP_GNRC_ITM

Primary Key: OP_GNRC_ITMI1

GENERIC_ITEM
CUST_ID
VENDOR_ID
ITEM_ID

Primary Key: OP_GNRC_ITM_PK

GENERIC_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
OP_GNRC_ITM	IC_ITEM_MST_B	OP_GNRC_ITM.ITEM_ID
OP_GNRC_ITM	IC_ITEM_MST	OP_GNRC_ITM.ITEM_ID
OP_GNRC_ITM	OP_CUST_MST	OP_GNRC_ITM.CUST_ID
OP_GNRC_ITM	OP_TEXT_HDR	OP_GNRC_ITM.TEXT_CODE
OP_GNRC_ITM	PO_VEND_MST	OP_GNRC_ITM.VENDOR_ID
OP_ORDR_DTL	OP_GNRC_ITM	OP_ORDR_DTL.GENERIC_ID
OP_PRSL_DTL	OP_GNRC_ITM	OP_PRSL_DTL.GENERIC_ID
PO_BPOS_DTL	OP_GNRC_ITM	PO_BPOS_DTL.GENERIC_ID
PO_ORDR_DTL	OP_GNRC_ITM	PO_ORDR_DTL.GENERIC_ID