CNAO_ACCTFLD_VW

(SQL View)
 Index Back

Prompt view for CNAO GL Rule

Prompt view for CNAO GL Rule

SELECT F.FIELDNAME , B.LONGNAME FROM PSDBFLDLABL B , PSDBFIELD F , PS_FS_CF_TEMPLATE T WHERE F.FIELDNAME = B.FIELDNAME AND B.DEFAULT_LABEL = 1 AND F.FLDNOTUSED = 0 AND T.ORIG_CF_NAME = F.FIELDNAME AND F.FIELDNAME IN ('ACCOUNT', 'ALTACCT') AND T.CF_ACTIVE_STATUS = 'A'

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