LM_MTRL_TYPE_VW

(SQL View)
Index Back

Material Type View

Material Type View

SELECT LM_MTRL_TYPE_ID , LM_MTRL_TYPE , LM_MTRL_TYPE_SHORT FROM PS_LM_MTRL_TYPE

  • Related Language Record: LM_MTRL_TYP_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_MTRL_TYPE_ID Number(10,0) DECIMAL(10) NOT NULL Material Type ID
    2 LM_MTRL_TYPE Character(50) VARCHAR2(50) NOT NULL Material Type
    3 LM_MTRL_TYPE_SHORT Character(10) VARCHAR2(10) NOT NULL Material Type Short Descr