KK_JLN_FS_VW5

(SQL View)

SELECT A.BUSINESS_UNIT , A.JOURNAL_ID , A.JOURNAL_DATE , A.UNPOST_SEQ , A.LEDGER_GROUP , C.FUND_SOURCE , SUM(C.MONETARY_AMOUNT) , C.CURRENCY_CD FROM PS_KK_BUDGET_HDR A , PS_KK_BUDGET_HDR B , PS_KK_BUDGET_LN C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.LEDGER_GROUP = B.LEDGER_GROUP AND ((B.BD_HDR_STATUS IN ('P','U')) OR (A.JOURNAL_ID = B.JOURNAL_ID AND A.JOURNAL_DATE = B.JOURNAL_DATE AND A.UNPOST_SEQ=B.UNPOST_SEQ)) AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.JOURNAL_ID = C.JOURNAL_ID AND B.JOURNAL_DATE = C.JOURNAL_DATE AND B.UNPOST_SEQ = C.UNPOST_SEQ AND C.FUND_SOURCE <> ' ' GROUP BY A.BUSINESS_UNIT, A.JOURNAL_ID, A.JOURNAL_DATE, A.UNPOST_SEQ , A.LEDGER_GROUP, C.FUND_SOURCE, C.CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
6	FUND_SOURCE	Character(6)	VARCHAR2(6) NOT NULL	Funding Source
7	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.
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code