SJ_JRNL_HDR_VW (SQL View)	Index Back
Simp Jrnl Entry - Search View Search view for the Simple Journal

SJ_JRNL_HDR_VW

(SQL View)

Simp Jrnl Entry - Search View

Search view for the Simple Journal

SELECT DISTINCT a.business_unit_iu ,a.journal_id ,a.journal_date ,a.unpost_seq ,( SELECT X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'JRNL_HDR_STATUS' AND X.FIELDVALUE = a.JRNL_HDR_STATUS) ,( SELECT X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'BUDGET_HDR_STATUS' AND X.FIELDVALUE = a.BUDGET_HDR_STATUS) ,a.ledger_group ,a.source ,a.descr ,a.oprid 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 EXISTS ( SELECT 'X' FROM PS_SJ_HEADER_TMPLT SA WHERE A.BUSINESS_UNIT_IU = SA.BUSINESS_UNIT AND A.JOURNAL_ID = SA.JOURNAL_ID AND A.JOURNAL_DATE_ORIG = SA.JOURNAL_DATE )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table: SP_BU_GL_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 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 DESCR100 Character(100) VARCHAR2(100) NOT NULL Length 100 Description

6 DESCR100A Character(100) VARCHAR2(100) NOT NULL Description

7 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

8 SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
Default Value: OPR_DEF_TBL_FS.SOURCE
Prompt Table: SOURCE_TBL

9 JRNL_DESCR Character(30) VARCHAR2(30) NOT NULL Journal Description

10 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
Prompt Table: OPRID_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_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	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	DESCR100	Character(100)	VARCHAR2(100) NOT NULL	Length 100 Description
6	DESCR100A	Character(100)	VARCHAR2(100) NOT NULL	Description
7	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
8	SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual. Default Value: OPR_DEF_TBL_FS.SOURCE Prompt Table: SOURCE_TBL
9	JRNL_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Journal Description
10	OPRID_ENTERED_BY	Character(30)	VARCHAR2(30) NOT NULL	Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes Prompt Table: OPRID_VW