CFS_CONS_BU_VW

(SQL View)
 Index Back

Chartfields by Ledger Template

Excluding Currency Code and Statistics Code

SELECT DISTINCT B.CHARTFIELD ,C.LONGNAME FROM PS_LED_GRP_FLD_VW2 B ,PSDBFLDLABL_VW C WHERE C.FIELDNAME = B.CHARTFIELD AND B.CHARTFIELD<>'CURRENCY_CD' AND B.CHARTFIELD<>'STATISTICS_CODE'

  • Related Language Record: FIELDNAME_LANG

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