FND Design Data [Home] [Help]

Table: LM_ITEM_DAT

Product: GMD - Process Manufacturing Product Development
Description: Laboratory management item data
Implementation/DBA Data: Not implemented in this database
Primary Key: LM_ITEM_DAT_PK
  1. ColumnLM_ITEM_DAT_ID
Primary Key: LM_ITEM_DAT_U1
  1. ColumnORGN_CODE
  2. ColumnITEM_ID
  3. ColumnLOT_ID
  4. ColumnFORMULA_ID
  5. ColumnTECH_PARM_NAME
Foreign Keys
Table
Foreign Table Foreign Key Column
LM_ITEM_DAT FK Joins to TableIC_ITEM_MST_B LM_ITEM_DAT.ITEM_ID
LM_ITEM_DAT FK Joins to TableIC_ITEM_MST LM_ITEM_DAT.ITEM_ID
LM_ITEM_DAT FK Joins to TableIC_LOTS_MST LM_ITEM_DAT.ITEM_ID
LM_ITEM_DAT.LOT_ID
LM_ITEM_DAT FK Joins to TableLM_FORM_MST LM_ITEM_DAT.FORMULA_ID
LM_ITEM_DAT FK Joins to TableLM_TECH_HDR LM_ITEM_DAT.LAB_TYPE
LM_ITEM_DAT.TECH_PARM_NAME
LM_ITEM_DAT FK Joins to TableLM_TEXT_HDR LM_ITEM_DAT.TEXT_CODE