SP_LEDGER_OPRVW

(SQL View)
Index Back

Ledger Security view


SELECT DISTINCT S.OPRID , L.LEDGER_TEMPLATE ,L.LEDGER ,L.DESCR FROM PS_LED_DEFN_TBL L , PS_SEC_LEDGER_OPR S WHERE S.LEDGER = L.LEDGER

  • Related Language Record: SP_LEDGER_LANG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 LEDGER_TEMPLATE Character(10) VARCHAR2(10) NOT NULL Ledger Template
    3 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description