KK_JLN_FS_VW3

(SQL View)

SELECT A.BUSINESS_UNIT , A.LEDGER_GROUP , B.FUND_SOURCE , SUM(B.MONETARY_AMOUNT) , B.CURRENCY_CD , A.BD_HDR_STATUS FROM PS_KK_BUDGET_LN B , PS_KK_BUDGET_HDR A 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.FUND_SOURCE <> ' ' GROUP BY A.BUSINESS_UNIT, A.LEDGER_GROUP, B.FUND_SOURCE, B.CURRENCY_CD, A.BD_HDR_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

3 FUND_SOURCE Character(6) VARCHAR2(6) NOT NULL Funding Source

4 MONETARY_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.

5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

6 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	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
3	FUND_SOURCE	Character(6)	VARCHAR2(6) NOT NULL	Funding Source
4	MONETARY_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account.
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	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