Table: IC_LOTS_MST

Product:	GMI - Process Manufacturing Inventory
Description:	This is the lot master table. This table stores data about individual lots for an item.
Implementation/DBA Data:	GMI.IC_LOTS_MST

Primary Key: IC_LOTS_MST_I1

1. LOT_NO
2. SUBLOT_NO
3. ITEM_ID

Primary Key: IC_LOTS_MST_PK

1. ITEM_ID
2. LOT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
IC_LOTS_MST		GMD_GRADES_B	IC_LOTS_MST.QC_GRADE
IC_LOTS_MST		IC_ITEM_MST_B	IC_LOTS_MST.ITEM_ID
IC_LOTS_MST		IC_ITEM_MST	IC_LOTS_MST.ITEM_ID
IC_LOTS_MST		IC_TEXT_HDR	IC_LOTS_MST.TEXT_CODE
IC_LOTS_MST		PO_VEND_MST	IC_LOTS_MST.SHIPVEND_ID
IC_LOTS_MST		QC_ACTN_MST	IC_LOTS_MST.EXPACTION_CODE
IC_LOTS_MST		QC_GRAD_MST	IC_LOTS_MST.QC_GRADE
IC_ADJS_JNL		IC_LOTS_MST	IC_ADJS_JNL.ITEM_ID IC_ADJS_JNL.LOT_ID
IC_CYCL_DTL		IC_LOTS_MST	IC_CYCL_DTL.ITEM_ID IC_CYCL_DTL.LOT_ID
IC_ITEM_CNV		IC_LOTS_MST	IC_ITEM_CNV.ITEM_ID IC_ITEM_CNV.LOT_ID
IC_LOCT_INV		IC_LOTS_MST	IC_LOCT_INV.ITEM_ID IC_LOCT_INV.LOT_ID
IC_PERD_BAL		IC_LOTS_MST	IC_PERD_BAL.ITEM_ID IC_PERD_BAL.LOT_ID
IC_STAT_RPT		IC_LOTS_MST	IC_STAT_RPT.ITEM_ID IC_STAT_RPT.LOT_ID
IC_TRAN_ARC		IC_LOTS_MST	IC_TRAN_ARC.ITEM_ID IC_TRAN_ARC.LOT_ID
IC_TRAN_CMP		IC_LOTS_MST	IC_TRAN_CMP.ITEM_ID IC_TRAN_CMP.LOT_ID
IC_TRAN_PND		IC_LOTS_MST	IC_TRAN_PND.ITEM_ID IC_TRAN_PND.LOT_ID
IC_XFER_MST		IC_LOTS_MST	IC_XFER_MST.ITEM_ID IC_XFER_MST.LOT_ID
LM_ITEM_DAT		IC_LOTS_MST	LM_ITEM_DAT.ITEM_ID LM_ITEM_DAT.LOT_ID
QC_RSLT_MST		IC_LOTS_MST	QC_RSLT_MST.ITEM_ID QC_RSLT_MST.LOT_ID
QC_SMPL_MST		IC_LOTS_MST	QC_SMPL_MST.ITEM_ID QC_SMPL_MST.LOT_ID
QC_SPEC_MST		IC_LOTS_MST	QC_SPEC_MST.ITEM_ID QC_SPEC_MST.LOT_ID