JRNL_LN_TR_VW

(SQL View)
 Index Back

Journal Line Data View


SELECT DISTINCT A.LEDGER FROM PS_JRNL_LN A , PS_JRNL_HEADER B WHERE 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 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger