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_ARC

Product:	GMI - Process Manufacturing Inventory
Description:	Inventory transaction archive
Implementation/DBA Data:	GMI.IC_TRAN_ARC

Primary Key: IC_TRAN_ARC_PK

TRANS_ID

Foreign Keys

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