RMC18_CFNAM_VW

(SQL View)
 Index Back

SELECT A.FIELDNAME , C.LONGNAME FROM PSRECFIELDDB A , PSDBFLDLABL_VW C , PSDBFIELD D WHERE A.RECNAME = 'RMC18_INQ_TBL' AND A.FIELDNAME=C.FIELDNAME AND C.FIELDNAME = D.FIELDNAME AND D.FLDNOTUSED = 0 AND A.FIELDNAME <> 'OPRID' AND A.FIELDNAME <> 'INQUIRY' AND A.FIELDNAME <> 'BUSINESS_UNIT_GL' AND A.FIELDNAME <> 'FISCAL_YEAR' AND A.FIELDNAME <> 'PROJECT_ID' AND A.FIELDNAME <> 'LEDGER'

  • Related Language Record: RMC18_CFNAM_LVW

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