LM_UI_DMH_FL_VW

(SQL View)
 Index Back

View of Deliv Meth TypeTable

View of Delivery Method Table LM_DMTH_TYP_TBL

SELECT LM_DMTHD_ID , LM_DM_LONG_NM FROM PS_LM_DMTH_TYP_VW UNION SELECT 9999999999 , A.MESSAGE_TEXT FROM PSMSGCATDEFN A WHERE A.MESSAGE_SET_NBR = 18101 AND A.MESSAGE_NBR = 10 UNION SELECT 9999999998 , A.MESSAGE_TEXT FROM PSMSGCATDEFN A WHERE A.MESSAGE_SET_NBR = 18092 AND A.MESSAGE_NBR = 1084 UNION SELECT 9999999997 , A.MESSAGE_TEXT FROM PSMSGCATDEFN A WHERE A.MESSAGE_SET_NBR = 18099 AND A.MESSAGE_NBR = 203

  • Related Language Record: LM_UI_DMTHF_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LM_DMTHD_ID Number(10,0) DECIMAL(10) NOT NULL Delivery Method ID - This is a system generated number used to uniquely identify each new Delivery Method
    2 LM_DM_LONG_NM Character(200) VARCHAR2(200) NOT NULL Long Name - the long name of a Delivery Method Type