KK_BD_HDR_VW2

(SQL View)

SELECT BUSINESS_UNIT , JOURNAL_ID , JOURNAL_DATE , UNPOST_SEQ , LEDGER_GROUP , BD_HDR_STATUS , DESCR , OPRID FROM PS_KK_BUDGET_HDR WHERE (KK_BUDG_TRANS_TYPE='0' OR KK_BUDG_TRANS_TYPE = '1' OR KK_BUDG_TRANS_TYPE = '4' OR KK_BUDG_TRANS_TYPE = '5' )

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

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

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description

8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
Prompt Table: OPRID_VW

#	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.
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	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
7	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
8	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN). Prompt Table: OPRID_VW