RBW_GRIDFLD_VW

(SQL View)
 Index Back

View to display Grid Name

This view is used to prompt against the asset/liabilitiy grid view

SELECT RECNAME ,PNLFIELDNAME ,LBLTEXT FROM PSPNLFIELD WHERE PNLNAME = 'RBW_BAL_SHEET_SBP' AND OCCURSLEVEL = 2 AND FIELDTYPE <>19 AND PNLFIELDNAME <> ' '

  • Related Language Record: RBW_GRIDFLD_V_L

  • Parent record: RBW_GRIDNM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 PNLFIELDNAME Character(18) VARCHAR2(18) NOT NULL Panel Field Name
    3 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text