RECFLD_ACT_VW

(SQL View)
Index Back

SELECT F.FIELDNAME , L.LONGNAME FROM PSRECFIELD F , PSDBFLDLABL_VW L WHERE F.RECNAME='GL_ACCOUNT_TBL' AND F.FIELDNAME NOT LIKE '%VAT%' AND F.FIELDNAME NOT LIKE 'OPEN_ITEM%' AND F.FIELDNAME NOT IN ('SETID','ACCOUNT','EFFDT','EFF_STATUS','DESCR','DESCRSHORT') AND F.FIELDNAME = L.FIELDNAME

  • Related Language Record: RECFLD_ACT_L_VW
  • # 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