CF_PROMPT_VW

(SQL View)
 Index Back

SELECT A.FIELDNAME FROM PS_FS_CF_TEMPLATE A , PSRECFIELDDB B WHERE A.CF_ACTIVE_STATUS = 'A' AND A.DELETE_CF = 'N' AND A.AFFILIATE_TYPE NOT IN ('A', 'I') AND A.FIELDNAME = B.FIELDNAME AND B.RECNAME = 'LEDGER'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).