KK_JHDR_VW

(SQL View)

SELECT JOURNAL_ID , JOURNAL_DATE , BD_HDR_STATUS FROM PS_KK_BUDGET_HDR WHERE BD_HDR_STATUS IN ('N','V','E', 'C')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

3 BD_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Budget Header Status: N - Posting has not been run against the journal E - The journal has failed edits V - The journal has passed edits but cannot be posted due to monetary related issues S - One ore more journal lines have failed the security edits P - The journal has been posted the ledger U - The journal has been unposted I - Incomplete journal pending SaveEdit to validate Security
B=Not Balanced
C=Checked Only
E=Error
I=Incomplete
N=None
P=Posted
S=Security Error
U=Unposted
V=Errors

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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.
2	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
3	BD_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Budget Header Status: N - Posting has not been run against the journal E - The journal has failed edits V - The journal has passed edits but cannot be posted due to monetary related issues S - One ore more journal lines have failed the security edits P - The journal has been posted the ledger U - The journal has been unposted I - Incomplete journal pending SaveEdit to validate Security B=Not Balanced C=Checked Only E=Error I=Incomplete N=None P=Posted S=Security Error U=Unposted V=Errors