RBW_GRIDFLD_V_L (SQL View)	Index Back
View to display Grid Name This view is the related language view of the original view used to prompt against the asset/liability grid view

RBW_GRIDFLD_V_L

(SQL View)

View to display Grid Name

This view is the related language view of the original view used to prompt against the asset/liability grid view

SELECT a.RECNAME ,a.PNLFIELDNAME ,b.LANGUAGE_CD ,b.LBLTEXT FROM PSPNLFIELD a , PSPNLFIELDLANG b WHERE a.PNLNAME = b.PNLNAME AND a.PNLFLDID = b.PNLFLDID AND a.PNLNAME = 'RBW_BAL_SHEET_SBP' AND a.OCCURSLEVEL = 2 AND a.FIELDTYPE <>19 AND PNLFIELDNAME <> ' '

Related Language Record for RBW_GRIDFLD_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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 LBLTEXT Character(60) VARCHAR2(60) NOT NULL Label Text

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	LBLTEXT	Character(60)	VARCHAR2(60) NOT NULL	Label Text