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