LM_MTRL_TYPE

(SQL Table)
Index Back

Material Type Table

Material Type Table

  • Related Language Record: LM_MTRLTY_LANG
  • # 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
    4 LM_ROW_ADDED_DTTM DateTime(26) TIMESTAMP Datetime Added
    5 LM_ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL Added By
    6 LM_ROW_MAINT_DTTM DateTime(26) TIMESTAMP Row Maintainted DateTime
    7 LM_ROW_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Row Maintained Oprid