GL_AUD_JRNL_VW (SQL View)	Index Back
Journal Log Audit view

GL_AUD_JRNL_VW

(SQL View)

Journal Log Audit view

SELECT DISTINCT A.BUSINESS_UNIT , A.JOURNAL_ID FROM PS_GL_AUD_JRNL A WHERE EXISTS ( SELECT 'X' FROM PS_JRNL_HEADER B WHERE B.BUSINESS_UNIT_IU=A.BUSINESS_UNIT AND B.BUSINESS_UNIT=A.BUSINESS_UNIT AND B.JOURNAL_ID=A.JOURNAL_ID AND B.JOURNAL_DATE=A.JOURNAL_DATE AND A.UNPOST_SEQ=B.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.

#	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.