eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: FM_MATL_DTL

Product:	GMD - Process Manufacturing Product Development
Description:	Formula material details - contains products,byproducts and ingredient information
Implementation/DBA Data:	GMD.FM_MATL_DTL

Primary Key: FM_MATL_DTL_PK

FORMULALINE_ID

Primary Key: FM_MATL_DTL_U1

FORMULA_ID
LINE_TYPE
LINE_NO

Foreign Keys

Table	Foreign Table	Foreign Key Column
FM_MATL_DTL	FM_FORM_MST	FM_MATL_DTL.FORMULA_ID
FM_MATL_DTL	FM_TEXT_HDR	FM_MATL_DTL.TEXT_CODE
FM_MATL_DTL	IC_ITEM_MST_B	FM_MATL_DTL.ITEM_ID
FM_MATL_DTL	IC_ITEM_MST	FM_MATL_DTL.ITEM_ID
FM_MATL_DTL	SY_UOMS_MST	FM_MATL_DTL.ITEM_UM
FM_ROUT_MTL	FM_MATL_DTL	FM_ROUT_MTL.FORMULALINE_ID
QC_RSLT_MST	FM_MATL_DTL	QC_RSLT_MST.FORMULALINE_ID
QC_SMPL_MST	FM_MATL_DTL	QC_SMPL_MST.FORMULALINE_ID
QC_SPEC_MST	FM_MATL_DTL	QC_SPEC_MST.FORMULALINE_ID