RMA_RSNSRCH_LNG

(SQL View)
 Index Back

Reason Code srch Rel. Lang.

This view is the related language control record for the RMA_REASON_SRCH record. Date Initials Issue # Description 05/06/03 dms F-MO'CO-J2WL0 Change descr to descr50

SELECT DISTINCT a.setid , a.reason_cd , b.language_cd , b.descr50 FROM PS_REASON_CD a , PS_REASON_CD_lng b WHERE a.reason_type = '10' AND a.setid = b.setid AND a.reason_cd = b.reason_cd AND a.reason_type = b.reason_type

  • Related Language Record for RMA_REASON_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 REASON_CD Character(10) VARCHAR2(10) NOT NULL Reason Code

    Prompt Table: RMA_REASON_VW

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50