FND Design Data [Home] [Help]

Table: IC_ITEM_CNV

Product: GMI - Process Manufacturing Inventory
Description: This table contains the Item/lot conversion factors.
Implementation/DBA Data: TableGMI.IC_ITEM_CNV
Primary Key: IC_ITEM_CNV_PK
  1. ColumnCONVERSION_ID
Primary Key: IC_ITEM_CNV_U1
  1. ColumnITEM_ID
  2. ColumnLOT_ID
  3. ColumnUM_TYPE
Foreign Keys
Table
Foreign Table Foreign Key Column
IC_ITEM_CNV FK Joins to TableIC_LOTS_MST IC_ITEM_CNV.ITEM_ID
IC_ITEM_CNV.LOT_ID
IC_ITEM_CNV FK Joins to TableIC_TEXT_HDR IC_ITEM_CNV.TEXT_CODE
IC_ITEM_CNV FK Joins to TableSY_UOMS_TYP IC_ITEM_CNV.UM_TYPE