FND Design Data [Home] [Help]

Table: GL_ITEM_CST

Product: GMF - Process Manufacturing Financials
Description: Item costs for transactions. Maintains accounting and current costs. Component cost details are available in GL_ITEM_DTL table.
Implementation/DBA Data: TableGMF.GL_ITEM_CST
Primary Key: GL_ITEM_CST_PK
  1. ColumnITEMCOST_ID
Primary Key: GL_ITEM_CST_U1
  1. ColumnORGN_CODE
  2. ColumnWHSE_CODE
  3. ColumnITEM_ID
  4. ColumnCOST_MTHD_CODE
  5. ColumnEND_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
GL_ITEM_CST FK Joins to TableCM_CLDR_DTL GL_ITEM_CST.CALENDAR_CODE
GL_ITEM_CST.PERIOD_CODE
GL_ITEM_CST FK Joins to TableCM_MTHD_MST GL_ITEM_CST.COST_MTHD_CODE
GL_ITEM_CST FK Joins to TableFM_FORM_EFF GL_ITEM_CST.FMEFF_ID
GL_ITEM_CST FK Joins to TableIC_ITEM_MST_B GL_ITEM_CST.ITEM_ID
GL_ITEM_CST FK Joins to TableIC_ITEM_MST GL_ITEM_CST.ITEM_ID
GL_ITEM_CST FK Joins to TableIC_WHSE_MST GL_ITEM_CST.WHSE_CODE
GL_ITEM_CST FK Joins to TableSY_ORGN_MST_B GL_ITEM_CST.ORGN_CODE
GL_ITEM_CST FK Joins to TableSY_ORGN_MST GL_ITEM_CST.ORGN_CODE
TableGL_ITEM_DTL FK Joins to GL_ITEM_CST GL_ITEM_DTL.ITEMCOST_ID