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 |
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 |
|
|
|