JRNL_HDR_APPR

(SQL View)
 Index Back

Journal approvals


SELECT HDR.BUSINESS_UNIT , HDR.JOURNAL_ID , HDR.JOURNAL_DATE , HDR.UNPOST_SEQ , HDR.BUSINESS_UNIT_IU , CASE WHEN (A.JRNL_APPRVL_OPTN = 'S' OR (A.JRNL_APPRVL_OPTN = 'D' AND B.JRNL_APPRVL_OPTN = 'S' ) OR(A.JRNL_APPRVL_OPTN = 'D' AND B.JRNL_APPRVL_OPTN = 'D' AND C.JRNL_APPRVL_OPTN = 'S' ) ) THEN 'Y' ELSE 'N' END FROM PS_JRNL_HEADER HDR , PS_SOURCE_TBL A , PS_BU_LED_GRP_TBL B , PS_BUS_UNIT_TBL_GL C , PS_SET_CNTRL_REC S WHERE HDR.UNPOST_SEQ = 0 AND HDR.JRNL_HDR_STATUS IN ('V','N') AND A.SETID=S.SETID AND S.SETCNTRLVALUE = HDR.BUSINESS_UNIT AND S.RECNAME = 'SOURCE_TBL' AND A.SOURCE=HDR.SOURCE AND A.EFFDT=( SELECT MAX(EFFDT) FROM PS_SOURCE_TBL WHERE SETID=A.SETID AND SOURCE=A.SOURCE AND EFFDT<=HDR.JOURNAL_DATE) AND A.EFF_STATUS='A' AND B.BUSINESS_UNIT=HDR.BUSINESS_UNIT AND B.LEDGER_GROUP=HDR.LEDGER_GROUP AND C.BUSINESS_UNIT=HDR.BUSINESS_UNIT

# 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 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
5 BUSINESS_UNIT_IU Character(5) VARCHAR2(5) NOT NULL Specifies the Business Unit for which InterUnit activity is being generated.
6 APPROV_REQUIRED Character(1) VARCHAR2(1) NOT NULL Approval Required for Demand