FND Design Data [Home] [Help]

Table: CM_CMPT_MTL

Product: GMF - Process Manufacturing Financials
Description: This table contains the item or item cost class specific material cost component and material analysis code. Used by the Actual Cost Process.
Implementation/DBA Data: TableGMF.CM_CMPT_MTL
Primary Key: CM_CMPT_MTLI0
  1. ColumnCO_CODE
  2. ColumnITEM_ID
  3. ColumnITEMCOST_CLASS
  4. ColumnEFF_START_DATE
Primary Key: CM_CMPT_MTL_PK
  1. ColumnCMPTMTL_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
CM_CMPT_MTL FK Joins to TableCM_ALYS_MST CM_CMPT_MTL.MTL_ANALYSIS_CODE
CM_CMPT_MTL FK Joins to TableCM_CMPT_MST_B CM_CMPT_MTL.MTL_CMPNTCLS_ID
CM_CMPT_MTL FK Joins to TableCM_CMPT_MST CM_CMPT_MTL.MTL_CMPNTCLS_ID
CM_CMPT_MTL FK Joins to TableCM_TEXT_HDR CM_CMPT_MTL.TEXT_CODE
CM_CMPT_MTL FK Joins to TableIC_COST_CLS CM_CMPT_MTL.ITEMCOST_CLASS
CM_CMPT_MTL FK Joins to TableIC_ITEM_MST_B CM_CMPT_MTL.ITEM_ID
CM_CMPT_MTL FK Joins to TableIC_ITEM_MST CM_CMPT_MTL.ITEM_ID
CM_CMPT_MTL FK Joins to TableSY_ORGN_MST_B CM_CMPT_MTL.CO_CODE
CM_CMPT_MTL FK Joins to TableSY_ORGN_MST CM_CMPT_MTL.CO_CODE