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_ITEM_MST

Product:	GMI - Process Manufacturing Inventory
Description:	This is the Item definition table. It contains all information relating to an item, such as lot/sublot control, unit of measure information, and all class and type designations.
Implementation/DBA Data:	Not implemented in this database

Primary Key: IC_ITEM_MST_PK

ITEM_ID

Primary Key: IC_ITEM_MST_UNQ1

ITEM_NO

Foreign Keys

Table	Foreign Table	Foreign Key Column
IC_ITEM_MST	IC_COMD_CDS	IC_ITEM_MST.COMMODITY_CODE
IC_ITEM_MST	CR_SQDT_CLS	IC_ITEM_MST.SEQ_DPND_CLASS
IC_ITEM_MST	IC_ALLC_CLS	IC_ITEM_MST.ALLOC_CLASS
IC_ITEM_MST	IC_COST_CLS	IC_ITEM_MST.ITEMCOST_CLASS
IC_ITEM_MST	IC_CTMS_CLS	IC_ITEM_MST.CUSTOMS_CLASS
IC_ITEM_MST	IC_FRGT_CLS	IC_ITEM_MST.FRT_CLASS
IC_ITEM_MST	IC_GLED_CLS	IC_ITEM_MST.GL_CLASS
IC_ITEM_MST	IC_INVN_CLS	IC_ITEM_MST.INV_CLASS
IC_ITEM_MST	IC_INVN_TYP	IC_ITEM_MST.INV_TYPE
IC_ITEM_MST	IC_ITEM_MST	IC_ITEM_MST.WHSE_ITEM_ID
IC_ITEM_MST	IC_ITEM_MST	IC_ITEM_MST.BULK_ID
IC_ITEM_MST	IC_ITEM_MST	IC_ITEM_MST.QCITEM_ID
IC_ITEM_MST	IC_LOTS_STS	IC_ITEM_MST.LOT_STATUS
IC_ITEM_MST	IC_PKGS_MST	IC_ITEM_MST.PKG_ID
IC_ITEM_MST	IC_PRCE_CLS	IC_ITEM_MST.PRICE_CLASS
IC_ITEM_MST	IC_PRCH_CLS	IC_ITEM_MST.PURCH_CLASS
IC_ITEM_MST	IC_SALE_CLS	IC_ITEM_MST.SALES_CLASS
IC_ITEM_MST	IC_SHIP_CLS	IC_ITEM_MST.SHIP_CLASS
IC_ITEM_MST	IC_STOR_CLS	IC_ITEM_MST.STORAGE_CLASS
IC_ITEM_MST	IC_TAXN_CLS	IC_ITEM_MST.TAX_CLASS
IC_ITEM_MST	IC_TEXT_HDR	IC_ITEM_MST.TEXT_CODE
IC_ITEM_MST	PS_PLNG_CLS	IC_ITEM_MST.PLANNING_CLASS
IC_ITEM_MST	QC_ACTN_MST	IC_ITEM_MST.EXPACTION_CODE
IC_ITEM_MST	QC_GRAD_MST	IC_ITEM_MST.QC_GRADE
IC_ITEM_MST	QC_HRES_MST	IC_ITEM_MST.QCHOLD_RES_CODE
IC_ITEM_MST	SY_UOMS_MST	IC_ITEM_MST.ITEM_UM
IC_ITEM_MST	SY_UOMS_MST	IC_ITEM_MST.ITEM_UM2
IC_ITEM_MST	SY_UOMS_MST	IC_ITEM_MST.FILL_UM
CM_ACST_LED	IC_ITEM_MST	CM_ACST_LED.ITEM_ID
CM_ADJS_DTL	IC_ITEM_MST	CM_ADJS_DTL.ITEM_ID
CM_BRDN_DTL	IC_ITEM_MST	CM_BRDN_DTL.ITEM_ID
CM_CMPT_DTL	IC_ITEM_MST	CM_CMPT_DTL.ITEM_ID
CM_CMPT_MTL	IC_ITEM_MST	CM_CMPT_MTL.ITEM_ID
CM_SCST_LED	IC_ITEM_MST	CM_SCST_LED.ITEM_ID
CM_WHSE_EFF	IC_ITEM_MST	CM_WHSE_EFF.ITEM_ID
CM_WHSE_SRC	IC_ITEM_MST	CM_WHSE_SRC.ITEM_ID
CR_SQDS_TBL	IC_ITEM_MST	CR_SQDS_TBL.FROM_ITEM_ID
CR_SQDS_TBL	IC_ITEM_MST	CR_SQDS_TBL.TO_ITEM_ID
FC_FCST_DTL	IC_ITEM_MST	FC_FCST_DTL.ITEM_ID
FM_FORM_EFF	IC_ITEM_MST	FM_FORM_EFF.ITEM_ID
FM_MATL_DTL	IC_ITEM_MST	FM_MATL_DTL.ITEM_ID
GL_ACCT_MAP	IC_ITEM_MST	GL_ACCT_MAP.ITEM_ID
GL_ALOC_BAS	IC_ITEM_MST	GL_ALOC_BAS.ITEM_ID
GL_ITEM_CST	IC_ITEM_MST	GL_ITEM_CST.ITEM_ID
GMP_ITEM_APS	IC_ITEM_MST	GMP_ITEM_APS.ITEM_ID
GMP_ITEM_APS	IC_ITEM_MST	GMP_ITEM_APS.ITEM_NO
IC_ADJS_JNL	IC_ITEM_MST	IC_ADJS_JNL.ITEM_ID
IC_CYCL_MSC	IC_ITEM_MST	IC_CYCL_MSC.ITEM_ID
IC_ITEM_MST	IC_ITEM_MST	IC_ITEM_MST.WHSE_ITEM_ID
IC_ITEM_MST	IC_ITEM_MST	IC_ITEM_MST.BULK_ID
IC_ITEM_MST	IC_ITEM_MST	IC_ITEM_MST.QCITEM_ID
IC_ITEM_WHS	IC_ITEM_MST	IC_ITEM_WHS.ITEM_ID
IC_LOTS_MST	IC_ITEM_MST	IC_LOTS_MST.ITEM_ID
IC_PLNT_INV	IC_ITEM_MST	IC_PLNT_INV.ITEM_ID
IC_STAT_RPT	IC_ITEM_MST	IC_STAT_RPT.ITEM_ID
IC_SUMM_INV	IC_ITEM_MST	IC_SUMM_INV.ITEM_ID
IC_TAXN_ASC	IC_ITEM_MST	IC_TAXN_ASC.ITEM_ID
IC_TRAN_ARC	IC_ITEM_MST	IC_TRAN_ARC.ITEM_ID
IC_TRAN_CMP	IC_ITEM_MST	IC_TRAN_CMP.ITEM_ID
IC_TRAN_PND	IC_ITEM_MST	IC_TRAN_PND.ITEM_ID
IC_WHSE_INV	IC_ITEM_MST	IC_WHSE_INV.ITEM_ID
IC_WHSE_REL	IC_ITEM_MST	IC_WHSE_REL.ITEM_ID
IC_XFER_MST	IC_ITEM_MST	IC_XFER_MST.ITEM_ID
LM_FORM_DTL	IC_ITEM_MST	LM_FORM_DTL.ITEM_ID
LM_ITEM_DAT	IC_ITEM_MST	LM_ITEM_DAT.ITEM_ID
LM_SPRD_DTL	IC_ITEM_MST	LM_SPRD_DTL.ITEM_ID
MR_ACTN_TBL	IC_ITEM_MST	MR_ACTN_TBL.ITEM_ID
MR_MESG_TBL	IC_ITEM_MST	MR_MESG_TBL.ITEM_ID1
MR_MESG_TBL	IC_ITEM_MST	MR_MESG_TBL.ITEM_ID2
MR_TRAN_TBL	IC_ITEM_MST	MR_TRAN_TBL.ITEM_ID
OP_CHRG_ITM	IC_ITEM_MST	OP_CHRG_ITM.ITEM_ID
OP_CNTR_DTL	IC_ITEM_MST	OP_CNTR_DTL.ITEM_ID
OP_CUST_ITM	IC_ITEM_MST	OP_CUST_ITM.ITEM_ID
OP_GNRC_ITM	IC_ITEM_MST	OP_GNRC_ITM.ITEM_ID
OP_ORDR_DTL	IC_ITEM_MST	OP_ORDR_DTL.ITEM_ID
OP_PKGD_ITM	IC_ITEM_MST	OP_PKGD_ITM.BULK_ITEM_ID
OP_PRCE_ITM	IC_ITEM_MST	OP_PRCE_ITM.ITEM_ID
OP_PRSL_DTL	IC_ITEM_MST	OP_PRSL_DTL.ITEM_ID
PM_MATL_DTL	IC_ITEM_MST	PM_MATL_DTL.ITEM_ID
PO_BPOS_DTL	IC_ITEM_MST	PO_BPOS_DTL.ITEM_ID
PO_DIST_DTL	IC_ITEM_MST	PO_DIST_DTL.ITEM_ID
PO_ORDR_DTL	IC_ITEM_MST	PO_ORDR_DTL.ITEM_ID
PO_RECV_DTL	IC_ITEM_MST	PO_RECV_DTL.ITEM_ID
PO_RTRN_DTL	IC_ITEM_MST	PO_RTRN_DTL.ITEM_ID
PO_VNIT_MST	IC_ITEM_MST	PO_VNIT_MST.ITEM_ID
PS_WHSE_EFF	IC_ITEM_MST	PS_WHSE_EFF.WHSE_ITEM_ID
QC_RSLT_MST	IC_ITEM_MST	QC_RSLT_MST.ITEM_ID
QC_SMPL_MST	IC_ITEM_MST	QC_SMPL_MST.ITEM_ID
QC_SPEC_MST	IC_ITEM_MST	QC_SPEC_MST.ITEM_ID