RSF_OPP_SORTREC

(SQL View)
 Index Back

Sort Record for Opportunity

View to build the Sort Fields for Opportunuty Homepage

SELECT R.FIELDNAME , P.LBLTEXT FROM PSRECFIELD R , PSPNLFIELD P WHERE R.RECNAME = 'RSF_OPPORTUNITY' AND P.PNLNAME='RSF_OPP_HOMEPAGE' AND R.RECNAME=P.RECNAME AND R.FIELDNAME=P.FIELDNAME AND P.FIELDLEFT = 0

  • Related Language Record: RSF_OPP_SRT_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text