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_ADJS_JNL

Product:	GMI - Process Manufacturing Inventory
Description:	Inventory adjustment detail
Implementation/DBA Data:	GMI.IC_ADJS_JNL

Primary Key: IC_ADJS_JNL_PK

TRANS_TYPE
TRANS_FLAG
DOC_ID
DOC_LINE

Foreign Keys

Table	Foreign Table	Foreign Key Column
IC_ADJS_JNL	GMD_GRADES_B	IC_ADJS_JNL.QC_GRADE
IC_ADJS_JNL	IC_ITEM_MST_B	IC_ADJS_JNL.ITEM_ID
IC_ADJS_JNL	IC_ITEM_MST	IC_ADJS_JNL.ITEM_ID
IC_ADJS_JNL	IC_JRNL_MST	IC_ADJS_JNL.JOURNAL_ID
IC_ADJS_JNL	IC_LOTS_MST	IC_ADJS_JNL.ITEM_ID IC_ADJS_JNL.LOT_ID
IC_ADJS_JNL	IC_LOTS_STS	IC_ADJS_JNL.LOT_STATUS
IC_ADJS_JNL	IC_WHSE_MST	IC_ADJS_JNL.WHSE_CODE
IC_ADJS_JNL	QC_GRAD_MST	IC_ADJS_JNL.QC_GRADE
IC_ADJS_JNL	SY_DOCS_MST	IC_ADJS_JNL.TRANS_TYPE
IC_ADJS_JNL	SY_ORGN_MST_B	IC_ADJS_JNL.ORGN_CODE
IC_ADJS_JNL	SY_ORGN_MST_B	IC_ADJS_JNL.CO_CODE
IC_ADJS_JNL	SY_ORGN_MST	IC_ADJS_JNL.ORGN_CODE
IC_ADJS_JNL	SY_ORGN_MST	IC_ADJS_JNL.CO_CODE
IC_ADJS_JNL	SY_REAS_CDS_B	IC_ADJS_JNL.REASON_CODE
IC_ADJS_JNL	SY_REAS_CDS	IC_ADJS_JNL.REASON_CODE
IC_ADJS_JNL	SY_UOMS_MST	IC_ADJS_JNL.ITEM_UM
IC_ADJS_JNL	SY_UOMS_MST	IC_ADJS_JNL.ITEM_UM2