SP_TRLED_OPRVW

(SQL View)
 Index Back

Journal Line Data View


SELECT DISTINCT L.OPRID , A.LEDGER FROM PS_JRNL_LN A , PS_JRNL_HEADER B , PS_SEC_LEDGER_OPR L WHERE A.LEDGER = L.LEDGER AND A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.JOURNAL_ID=B.JOURNAL_ID AND A.JOURNAL_DATE=B.JOURNAL_DATE AND A.UNPOST_SEQ=0 AND B.ACCTG_DEF_NAME='TRDEFN'

  • Parent record: JRNL_HEADER_FS

    • # 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 Character(10) VARCHAR2(10) NOT NULL Ledger