SUMLD_CF2SL_VW

(SQL View)
Index Back

Selected Values in Summ Ledger

This View is used to prompt the valid values for certain Summary Ledger Chartfield. The values are stored in LED_SUMV_TBL table. The first three keys (SETID, LEDGER, CHARTFIELD) are matched with the values on the panel.

SELECT F.SETID ,F.LEDGER ,F.CHARTFIELD ,D.SETID , %Sql(CHARTFIELD2, D.) ,D.EFFDT ,D.DESCR FROM PS_LED_FLDS_TBL F ,PS_LED_SUMV_TBL V ,PS_%Sql(CHARTFIELD2_TBL, D) WHERE V.LEDGER=F.LEDGER AND V.SETID=F.SETID AND V.FIELD_SEQUENCE=F.FIELD_SEQUENCE AND %Sql(CHARTFIELD2, D.) = V.SELECT_VALUE

  • Related Language Record: SUMLD_CF2SL_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    4 DTL_SETID Character(5) VARCHAR2(5) NOT NULL Tree Structure Summary Detail Tree SetId
    5 CHARTFIELD_VALUE Character(30) VARCHAR2(30) NOT NULL ChartField Value
    6 EFFDT Date(10) DATE Effective Date
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description