JRNL_XFER_SRCH (SQL View)	Index Back
Journal Search Xfer Journal Search Xfer

JRNL_XFER_SRCH

(SQL View)

Journal Search Xfer

SELECT A.BUSINESS_UNIT_IU ,A.JOURNAL_ID ,A.JOURNAL_DATE ,' ' FROM PS_JRNL_HEADER A WHERE EXISTS ( SELECT 'X' FROM PS_JRNL_HEADER B WHERE B.BUSINESS_UNIT_IU = A.BUSINESS_UNIT_IU AND B.BUSINESS_UNIT = A.BUSINESS_UNIT_IU AND B.JOURNAL_ID = A.JOURNAL_ID AND B.JOURNAL_DATE = A.JOURNAL_DATE AND A.UNPOST_SEQ = B.UNPOST_SEQ) AND A.UNPOST_SEQ = 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUNGL_NONVW

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 PARAM_NAME Character(50) VARCHAR2(50) NOT NULL Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUNGL_NONVW
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	PARAM_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name