SJ_LINE_FLDVW

(SQL View)
 Index Back

Simp Jrnl Tmplt - Jrnl Ln Fld

View to fetch the Journal Line fields

SELECT A.FIELDNAME ,A.LONGNAME ,'Y' ,'N' ,'N' FROM PS_RECFLD_LABEL_VW A WHERE A.RECNAME = 'JRNL_LN' AND A.FIELDNAME NOT IN ( SELECT B.FIELDNAME FROM PS_RECFLD_LABEL_VW B WHERE B.RECNAME IN ('CFS14_AN_SBR','PC_CF1_N_SBR') AND B.FIELDNAME <> 'ANALYSIS_TYPE') AND A.FIELDNAME IN ('BUSINESS_UNIT','LEDGER','ENTRY_EVENT','ANALYSIS_TYPE','BOOK_CODE','BUDGET_PERIOD','SCENARIO','FOREIGN_CURRENCY','FOREIGN_AMOUNT','RT_TYPE', 'CURRENCY_CD','MONETARY_AMOUNT','STATISTICS_CODE','STATISTIC_AMOUNT','BUDGET_DT','JRNL_LN_REF','LINE_DESCR','ANALYSIS_TYPE','PC_DISTRIB_STATUS','ACCOUNT_CODE') UNION SELECT A.FIELDNAME ,A.LONGNAME ,'Y' ,'N' ,'N' FROM PS_RECFLD_LABEL_VW A WHERE A.RECNAME = 'JRNL_PANELS_WRK' AND A.FIELDNAME IN ('VISUAL_RATE_2','UNIT_OF_MEASURE','OPEN_ITEM_KEY','CALC_OPTN','SPEEDTYPE_KEY')

# 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
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