CFS_LED_LNG_VW2

(SQL View)
 Index Back

Detail Ledger CF View

Excludes BUSINESS_UNIT, CURRENCY_CD, STATISTICS_CODE, DATE_CODE

SELECT DISTINCT A.SETID , A.LEDGER , B.LEDGER_GROUP , C.CHARTFIELD , L.LANGUAGE_CD , L.LONGNAME FROM PS_LED_DEFN_TBL A , PS_LED_GRP_LED_TBL B , PS_LED_GRP_FLD_TBL C , PSDBFLDLABL_VW D , PSDBFIELD E , PSDBFLDLBLLNG_V L WHERE A.SETID = B.SETID AND A.LEDGER = B.LEDGER AND B.SETID = C.SETID AND B.LEDGER_GROUP = C.LEDGER_GROUP AND A.LEDGER_TYPE = 'D' AND C.CHARTFIELD NOT IN ('BUSINESS_UNIT', 'CURRENCY_CD', 'STATISTICS_CODE', 'DATE_CODE') AND C.CHARTFIELD = D.FIELDNAME AND D.FIELDNAME = E.FIELDNAME AND E.FLDNOTUSED = 0 AND L.FIELDNAME = D.FIELDNAME

  • Related Language Record for CFS_LED_LBL_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_LEDGER Character(5) VARCHAR2(5) NOT NULL Ledger Table Setid
    2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    3 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
    4 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name