SP_TRLED_CLSVW

(SQL View)
 Index Back

Journal Line Data View


SELECT DISTINCT L.OPRCLASS , A.LEDGER FROM PS_JRNL_LN A , PS_JRNL_HEADER B , PS_SEC_LEDGER_CLS 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 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger