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