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_CMP

Product:	GMI - Process Manufacturing Inventory
Description:	Completed inventory transactions
Implementation/DBA Data:	GMI.IC_TRAN_CMP

Primary Key: IC_TRAN_CMP_PK

TRANS_ID

Foreign Keys

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