JRNL_HEADER_FVW (SQL View)	Index Back
SrchRec Journal Hdr FS Inq

JRNL_HEADER_FVW

(SQL View)

SrchRec Journal Hdr FS Inq

SELECT BUSINESS_UNIT ,JOURNAL_ID ,JOURNAL_DATE ,UNPOST_SEQ ,DOC_SEQ_NBR ,JRNL_HDR_STATUS ,BUDGET_HDR_STATUS ,LEDGER_GROUP FROM PS_JRNL_HEADER_FS A WHERE 'JRNL_LN'=( SELECT T.RECNAME_JRNL_LN FROM PS_LED_TMPLT_TBL T , PS_LED_GRP_TBL D , PS_SET_CNTRL_REC E WHERE T.LEDGER_TEMPLATE=D.LEDGER_TEMPLATE AND D.LEDGER_GROUP = A.LEDGER_GROUP AND D.SETID=E.SETID AND E.SETCNTRLVALUE=A.BUSINESS_UNIT AND E.RECNAME = 'LED_GRP_TBL') OR 'JRNL_LN_FS'=( SELECT T.RECNAME_JRNL_LN FROM PS_LED_TMPLT_TBL T , PS_LED_GRP_TBL D , PS_SET_CNTRL_REC E WHERE T.LEDGER_TEMPLATE=D.LEDGER_TEMPLATE AND D.LEDGER_GROUP = A.LEDGER_GROUP AND D.SETID=E.SETID AND E.SETCNTRLVALUE=A.BUSINESS_UNIT AND E.RECNAME = 'LED_GRP_TBL')

# 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.
Default Value: NEXT

3 JOURNAL_DATE Date(10) DATE NOT NULL Specifies the date the journal was created.
Default Value: %date

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 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.

6 JRNL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates the processing status of a journal entry.
D=Deleted
E=Journal Has Errors
I=Posting Incomplete
M=Valid SJE Model -- Do Not Post
N=No Status - Needs to be Edited
P=Posted to Ledger(s)
T=Journal Entry Incomplete
U=Unposted
V=Valid Journal - Edits Complete
X=Cancelled
Z=Upgrade Journal - Can't Unpost

7 BUDGET_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid

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

#	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. Default Value: NEXT
3	JOURNAL_DATE	Date(10)	DATE NOT NULL	Specifies the date the journal was created. Default Value: %date
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	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
6	JRNL_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates the processing status of a journal entry. D=Deleted E=Journal Has Errors I=Posting Incomplete M=Valid SJE Model -- Do Not Post N=No Status - Needs to be Edited P=Posted to Ledger(s) T=Journal Entry Incomplete U=Unposted V=Valid Journal - Edits Complete X=Cancelled Z=Upgrade Journal - Can't Unpost
7	BUDGET_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Checking Header Status E=Error in Budget Check I=Document In Processing N=Not Budget Checked P=Provisionally Valid V=Valid
8	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group