XPYM_RSN_SY_VW

(SQL View)
 Index Back

Payment Reasons System Define


SELECT A.SETID , A.PYMNT_REASON_CD , A.DESCR , B.XLATLONGNAME FROM PS_PYMNT_REASON A , PSXLATITEM B WHERE A.USER_CODE_OPT = 'S' AND B.FIELDNAME = 'REASON_CD_TYPE' AND B.FIELDVALUE = A.REASON_CD_TYPE AND B.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM C, B, %CurrentDateIn)

  • Related Language Record: XPYM_RSN_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 PYMNT_REASON_CD Character(4) VARCHAR2(4) NOT NULL Payment Reason Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 CODE_TYPE Character(30) VARCHAR2(30) NOT NULL Code Type