PC_GL_RUN_VW (SQL View)	Index Back
SQL View FROM PS_JRNL_HEADER A , PS_JRNL_LN B

PC_GL_RUN_VW

(SQL View)

SQL View

FROM PS_JRNL_HEADER A , PS_JRNL_LN B

SELECT A.BUSINESS_UNIT , A.JOURNAL_ID FROM PS_JRNL_HEADER A , PS_JRNL_LN 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 = B.UNPOST_SEQ AND B.PC_DISTRIB_STATUS = 'N' AND A.JRNL_HDR_STATUS IN ('P','U') AND B.BUSINESS_UNIT_PC <> ' ' AND B.PROJECT_ID <> ' ' AND B.ACTIVITY_ID <> ' ' GROUP BY A.BUSINESS_UNIT, A.JOURNAL_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL 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_GL	Character(5)	VARCHAR2(5) NOT NULL	GL 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.