SJ_HEADER_FLDVW (SQL View)	Index Back
Header Fields View View to fetch the Journal Header fields

SJ_HEADER_FLDVW

(SQL View)

Header Fields View

View to fetch the Journal Header fields

SELECT DISTINCT FIELDNAME , LONGNAME ,'Y' ,'N' ,'N' FROM PS_RECFLD_LABEL_VW WHERE RECNAME IN ('JRNL_HEADER', 'JRNL_PANELS_WRK') AND FIELDNAME IN ('LEDGER_GROUP','LEDGER', 'SOURCE','TRANS_REF_NUM','JOURNAL_CLASS','IU_TRAN_CD','DESCR254', 'AUTO_GEN_LINES', 'DATE_CODE_JRNL','SAVE_INC_JRNL','BAL_0AMTLINE')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

5 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	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
2	LONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Long Name
3	DISPLAY_FIELDS	Character(1)	VARCHAR2(1) NOT NULL	Display Catalog Search Fields Default Value: Y
4	REQUIRED_FIELD	Character(1)	VARCHAR2(1) NOT NULL	* Required Field
5	DISPLAY_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Display Only N=No Y=Yes