SP_LGRPNS_OPRVW

(SQL View)
 Index Back

Sec Vw-All Ledg Grps-No SetID


SELECT DISTINCT s.oprid ,a.ledger_group ,a.descr ,b.ledger_type FROM ps_led_grp_tbl a ,PS_LED_TMPLT_TBL b ,ps_sec_ledger_opr s WHERE b.ledger_template = a.ledger_template AND s.ledger_group = a.ledger_group

  • Related Language Record: LED_GRP_NS_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_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 LEDGER_TYPE Character(1) VARCHAR2(1) NOT NULL Ledger Type
    D=Detail Ledger
    K=Commitment Control Ledger
    S=Summary Ledger