CFS_TMPLT_VW

(SQL View)
 Index Back

Chartfields by Ledger Template

Excluding Business Unit, Currency Code, and Statistics Code

SELECT /*+NO_MERGE*/ DISTINCT A.LEDGER_TEMPLATE ,B.CHARTFIELD ,C.LONGNAME FROM PS_LED_TMPLT_TBL A ,PS_LED_GRP_FLD_VW2 B ,PSDBFLDLABL_VW C WHERE ((A.LEDGER_TYPE='D' AND EXISTS ( SELECT 'X' FROM PS_LED_GRP_TBL WHERE LEDGER_TEMPLATE = A.LEDGER_TEMPLATE AND LEDGER_GROUP = B.LEDGER_GROUP AND SETID = B.SETID)) OR (A.LEDGER_TYPE = 'S' AND EXISTS ( SELECT 'X' FROM PS_LED_DEFN_TBL WHERE LEDGER_TEMPLATE = A.LEDGER_TEMPLATE AND LEDGER = B.LEDGER_GROUP AND SETID = B.SETID))) AND C.FIELDNAME = B.CHARTFIELD AND B.CHARTFIELD<>'CURRENCY_CD' AND B.CHARTFIELD<>'STATISTICS_CODE'

  • Related Language Record: CFS_TMPLT_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LEDGER_TEMPLATE Character(10) VARCHAR2(10) NOT NULL Ledger Template
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name