JRNL_AF_LBU_VW

(SQL View)
 Index Back

Journal Line BUs For AF

This View selects all the BUs in an inter unit journal.

SELECT H.BUSINESS_UNIT_IU , H.JOURNAL_ID , H.JOURNAL_DATE , H.BUSINESS_UNIT , H2.BUSINESS_UNIT FROM PS_JRNL_HEADER H , PS_JRNL_HEADER H2 WHERE H.JRNL_HDR_STATUS='V' AND H.BUDGET_HDR_STATUS='V' AND H.JRNL_PROCESS_REQST NOT IN ('P','W') AND H.BUSINESS_UNIT=H.BUSINESS_UNIT_IU AND H2.BUSINESS_UNIT_IU=H.BUSINESS_UNIT_IU AND H2.JOURNAL_ID=H.JOURNAL_ID AND H2.JOURNAL_DATE=H.JOURNAL_DATE AND H2.UNPOST_SEQ=H.UNPOST_SEQ

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
3 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
4 BUSINESS_UNIT_LN Character(5) VARCHAR2(5) NOT NULL Line Business Unit
5 BUSINESS_UNIT2 Character(5) VARCHAR2(5) NOT NULL Business Unit