CFS_LED_LBL_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 , D.LONGNAME , C.RECNAME_NO_EFFDT , C.FIELD_SEQUENCE FROM PS_LED_DEFN_TBL A , PS_LED_GRP_LED_TBL B , PS_LED_GRP_FLD_TBL C , PSDBFLDLABL_VW D , PSDBFIELD E 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

  • Related Language Record: CFS_LED_LNG_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 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name
    6 RECNAME_NO_EFFDT Character(15) VARCHAR2(15) NOT NULL View - No Effective Date
    7 FIELD_SEQUENCE Number(3,0) SMALLINT NOT NULL Field Sequence Number