CFS_TMPLT_DT_VW

(SQL View)
 Index Back

Chartfield by Detail Led Tmplt

Excluding Business Unit

SELECT DISTINCT A.LEDGER_TEMPLATE ,B.CHARTFIELD ,C.LONGNAME FROM PS_LED_GRP_TBL A ,PS_LED_GRP_FLD_VW2 B ,PSDBFLDLABL_VW C WHERE B.LEDGER_GROUP = A.LEDGER_GROUP AND B.SETID = A.SETID AND C.FIELDNAME = B.CHARTFIELD AND B.CHARTFIELD<>'BUSINESS_UNIT'

  • Related Language Record: CFS_TMPLTDT_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DETAIL_TMPLT Character(10) VARCHAR2(10) NOT NULL Detail Template
    2 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField
    3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name