SJ_ADB_FLDVW (SQL View)	Index Back
ADV View View to fetch Average Daily Balance fields

SJ_ADB_FLDVW

(SQL View)

ADV View

View to fetch Average Daily Balance fields

SELECT DISTINCT 0 ,FIELDNAME , LONGNAME ,'Y' ,'N' ,'N' FROM PS_RECFLD_LABEL_VW WHERE RECNAME IN ('JRNL_HEADER', 'JRNL_PANELS_WRK') AND FIELDNAME IN ('ADB_DATE', 'REVERSAL_CD_ADB','REVERSAL_DATE_ADB')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name

4 DISPLAY_FIELDS Character(1) VARCHAR2(1) NOT NULL Display Catalog Search Fields
Default Value: Y

5 REQUIRED_FIELD Character(1) VARCHAR2(1) NOT NULL * Required Field

6 DISPLAY_ONLY Character(1) VARCHAR2(1) NOT NULL Display Only
N=No
Y=Yes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SEQUENCENO	Number(10,0)	DECIMAL(10) NOT NULL	Sequence Number
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
3	LONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Long Name
4	DISPLAY_FIELDS	Character(1)	VARCHAR2(1) NOT NULL	Display Catalog Search Fields Default Value: Y
5	REQUIRED_FIELD	Character(1)	VARCHAR2(1) NOT NULL	* Required Field
6	DISPLAY_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Display Only N=No Y=Yes