Table: IC_ITEM_MST_B

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:	GMI.IC_ITEM_MST_B

Primary Key: IC_ITEM_MST_B_PK

1. ITEM_ID

Primary Key: IC_ITEM_MST_B_UNQ1

1. ITEM_NO

Foreign Keys

Table		Foreign Table	Foreign Key Column
IC_ITEM_MST_B		IC_COMD_CDS	IC_ITEM_MST_B.COMMODITY_CODE
IC_ITEM_MST_B		GMD_GRADES_B	IC_ITEM_MST_B.QC_GRADE
IC_ITEM_MST_B		IC_INVN_TYP	IC_ITEM_MST_B.INV_TYPE
IC_ITEM_MST_B		IC_LOTS_STS	IC_ITEM_MST_B.LOT_STATUS
IC_ITEM_MST_B		IC_PKGS_MST	IC_ITEM_MST_B.PKG_ID
IC_ITEM_MST_B		IC_TEXT_HDR	IC_ITEM_MST_B.TEXT_CODE
IC_ITEM_MST_B		QC_ACTN_MST	IC_ITEM_MST_B.EXPACTION_CODE
IC_ITEM_MST_B		QC_GRAD_MST	IC_ITEM_MST_B.QC_GRADE
IC_ITEM_MST_B		QC_HRES_MST	IC_ITEM_MST_B.QCHOLD_RES_CODE
IC_ITEM_MST_B		IC_ITEM_MST_B	IC_ITEM_MST_B.WHSE_ITEM_ID
IC_ITEM_MST_B		IC_ITEM_MST_B	IC_ITEM_MST_B.BULK_ID
IC_ITEM_MST_B		IC_ITEM_MST_B	IC_ITEM_MST_B.QCITEM_ID
CM_ACST_LED		IC_ITEM_MST_B	CM_ACST_LED.ITEM_ID
CM_ADJS_DTL		IC_ITEM_MST_B	CM_ADJS_DTL.ITEM_ID
CM_BRDN_DTL		IC_ITEM_MST_B	CM_BRDN_DTL.ITEM_ID
CM_CMPT_DTL		IC_ITEM_MST_B	CM_CMPT_DTL.ITEM_ID
CM_CMPT_MTL		IC_ITEM_MST_B	CM_CMPT_MTL.ITEM_ID
CM_SCST_LED		IC_ITEM_MST_B	CM_SCST_LED.ITEM_ID
CM_WHSE_EFF		IC_ITEM_MST_B	CM_WHSE_EFF.ITEM_ID
CM_WHSE_SRC		IC_ITEM_MST_B	CM_WHSE_SRC.ITEM_ID
CR_SQDS_TBL		IC_ITEM_MST_B	CR_SQDS_TBL.FROM_ITEM_ID
CR_SQDS_TBL		IC_ITEM_MST_B	CR_SQDS_TBL.TO_ITEM_ID
FC_FCST_DTL		IC_ITEM_MST_B	FC_FCST_DTL.ITEM_ID
FM_MATL_DTL		IC_ITEM_MST_B	FM_MATL_DTL.ITEM_ID
GL_ACCT_MAP		IC_ITEM_MST_B	GL_ACCT_MAP.ITEM_ID
GL_ALOC_BAS		IC_ITEM_MST_B	GL_ALOC_BAS.ITEM_ID
GL_ITEM_CST		IC_ITEM_MST_B	GL_ITEM_CST.ITEM_ID
GMF_BURDEN_PERCENTAGES		IC_ITEM_MST_B	GMF_BURDEN_PERCENTAGES.ITEM_ID
GMP_ITEM_APS		IC_ITEM_MST_B	GMP_ITEM_APS.ITEM_ID
GMP_ITEM_APS		IC_ITEM_MST_B	GMP_ITEM_APS.ITEM_NO
GMP_ITEM_WPS		IC_ITEM_MST_B	GMP_ITEM_WPS.ITEM_ID
GMP_ITEM_WPS		IC_ITEM_MST_B	GMP_ITEM_WPS.ITEM_NO
GR_GENERIC_ITEMS_B		IC_ITEM_MST_B	GR_GENERIC_ITEMS_B.ITEM_NO
IC_ADJS_JNL		IC_ITEM_MST_B	IC_ADJS_JNL.ITEM_ID
IC_CYCL_MSC		IC_ITEM_MST_B	IC_CYCL_MSC.ITEM_ID
IC_ITEM_MST_B		IC_ITEM_MST_B	IC_ITEM_MST_B.WHSE_ITEM_ID
IC_ITEM_MST_B		IC_ITEM_MST_B	IC_ITEM_MST_B.BULK_ID
IC_ITEM_MST_B		IC_ITEM_MST_B	IC_ITEM_MST_B.QCITEM_ID
IC_ITEM_WHS		IC_ITEM_MST_B	IC_ITEM_WHS.ITEM_ID
IC_LOTS_MST		IC_ITEM_MST_B	IC_LOTS_MST.ITEM_ID
IC_PLNT_INV		IC_ITEM_MST_B	IC_PLNT_INV.ITEM_ID
IC_STAT_RPT		IC_ITEM_MST_B	IC_STAT_RPT.ITEM_ID
IC_TAXN_ASC		IC_ITEM_MST_B	IC_TAXN_ASC.ITEM_ID
IC_TRAN_ARC		IC_ITEM_MST_B	IC_TRAN_ARC.ITEM_ID
IC_TRAN_CMP		IC_ITEM_MST_B	IC_TRAN_CMP.ITEM_ID
IC_TRAN_PND		IC_ITEM_MST_B	IC_TRAN_PND.ITEM_ID
IC_WHSE_INV		IC_ITEM_MST_B	IC_WHSE_INV.ITEM_ID
IC_WHSE_REL		IC_ITEM_MST_B	IC_WHSE_REL.ITEM_ID
IC_XFER_MST		IC_ITEM_MST_B	IC_XFER_MST.ITEM_ID
LM_ITEM_DAT		IC_ITEM_MST_B	LM_ITEM_DAT.ITEM_ID
LM_SPRD_DTL		IC_ITEM_MST_B	LM_SPRD_DTL.ITEM_ID
MR_ACTN_TBL		IC_ITEM_MST_B	MR_ACTN_TBL.ITEM_ID
MR_MESG_TBL		IC_ITEM_MST_B	MR_MESG_TBL.ITEM_ID1
MR_MESG_TBL		IC_ITEM_MST_B	MR_MESG_TBL.ITEM_ID2
MR_TRAN_TBL		IC_ITEM_MST_B	MR_TRAN_TBL.ITEM_ID
OP_CHRG_ITM		IC_ITEM_MST_B	OP_CHRG_ITM.ITEM_ID
OP_CNTR_DTL		IC_ITEM_MST_B	OP_CNTR_DTL.ITEM_ID
OP_CUST_ITM		IC_ITEM_MST_B	OP_CUST_ITM.ITEM_ID
OP_GNRC_ITM		IC_ITEM_MST_B	OP_GNRC_ITM.ITEM_ID
OP_ORDR_DTL		IC_ITEM_MST_B	OP_ORDR_DTL.ITEM_ID
OP_PKGD_ITM		IC_ITEM_MST_B	OP_PKGD_ITM.BULK_ITEM_ID
OP_PRCE_ITM		IC_ITEM_MST_B	OP_PRCE_ITM.ITEM_ID
OP_PRSL_DTL		IC_ITEM_MST_B	OP_PRSL_DTL.ITEM_ID
PO_BPOS_DTL		IC_ITEM_MST_B	PO_BPOS_DTL.ITEM_ID
PO_DIST_DTL		IC_ITEM_MST_B	PO_DIST_DTL.ITEM_ID
PO_ORDR_DTL		IC_ITEM_MST_B	PO_ORDR_DTL.ITEM_ID
PO_RECV_DTL		IC_ITEM_MST_B	PO_RECV_DTL.ITEM_ID
PO_RTRN_DTL		IC_ITEM_MST_B	PO_RTRN_DTL.ITEM_ID
PO_VNIT_MST		IC_ITEM_MST_B	PO_VNIT_MST.ITEM_ID
PS_WHSE_EFF		IC_ITEM_MST_B	PS_WHSE_EFF.WHSE_ITEM_ID
QC_RSLT_MST		IC_ITEM_MST_B	QC_RSLT_MST.ITEM_ID
QC_SMPL_MST		IC_ITEM_MST_B	QC_SMPL_MST.ITEM_ID
QC_SPEC_MST		IC_ITEM_MST_B	QC_SPEC_MST.ITEM_ID