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: IC_TRAN_PND

Product:	GMI - Process Manufacturing Inventory
Description:	Pending inventory transactions
Implementation/DBA Data:	GMI.IC_TRAN_PND

Primary Key: IC_TRAN_PND_PK

TRANS_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
IC_TRAN_PND	GMD_GRADES_B	IC_TRAN_PND.QC_GRADE
IC_TRAN_PND	IC_ITEM_MST_B	IC_TRAN_PND.ITEM_ID
IC_TRAN_PND	IC_ITEM_MST	IC_TRAN_PND.ITEM_ID
IC_TRAN_PND	IC_LOTS_MST	IC_TRAN_PND.ITEM_ID IC_TRAN_PND.LOT_ID
IC_TRAN_PND	IC_LOTS_STS	IC_TRAN_PND.LOT_STATUS
IC_TRAN_PND	IC_TEXT_HDR	IC_TRAN_PND.TEXT_CODE
IC_TRAN_PND	IC_WHSE_MST	IC_TRAN_PND.WHSE_CODE
IC_TRAN_PND	QC_GRAD_MST	IC_TRAN_PND.QC_GRADE
IC_TRAN_PND	SY_DOCS_MST	IC_TRAN_PND.DOC_TYPE
IC_TRAN_PND	SY_ORGN_MST_B	IC_TRAN_PND.ORGN_CODE
IC_TRAN_PND	SY_ORGN_MST_B	IC_TRAN_PND.CO_CODE
IC_TRAN_PND	SY_ORGN_MST	IC_TRAN_PND.ORGN_CODE
IC_TRAN_PND	SY_ORGN_MST	IC_TRAN_PND.CO_CODE
IC_TRAN_PND	SY_REAS_CDS_B	IC_TRAN_PND.REASON_CODE
IC_TRAN_PND	SY_REAS_CDS	IC_TRAN_PND.REASON_CODE
IC_TRAN_PND	SY_UOMS_MST	IC_TRAN_PND.TRANS_UM2
IC_TRAN_PND	SY_UOMS_MST	IC_TRAN_PND.TRANS_UM
IC_STAT_RPT	IC_TRAN_PND	IC_STAT_RPT.TRANS_ID