EE_JAD_JRNLS_VW (SQL View)	Index Back
EE Adjust Jrnls to process Entry Event Adjustment Journals that are ready for EVENTGEN to Post

EE_JAD_JRNLS_VW

(SQL View)

EE Adjust Jrnls to process

Entry Event Adjustment Journals that are ready for EVENTGEN to Post

SELECT DISTINCT A.BUSINESS_UNIT , A.KK_JOURNAL_ID , A.KK_JOURNAL_DATE , A.UNPOST_SEQ FROM PS_EE_JAD_ACCTG_VW A

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

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