CFS_TMPLT_LANG

(SQL View)
 Index Back

CFs by Ledger Template - RLR

Excluding Business Unit, Currency Code, and Statistics Code

SELECT DISTINCT A.LEDGER_TEMPLATE ,B.CHARTFIELD ,C.LANGUAGE_CD ,C.LONGNAME FROM PS_LED_TMPLT_TBL A ,PS_LED_GRP_FLD_VW2 B ,PSDBFLDLBLLNG_V 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

  • Related Language Record for CFS_TMPLT_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name