KK_AF_SRCH_VW (SQL View)	Index Back
Journal Header Data For AF Journal Header Data For AF Not on-page fields: CURRENCY_CD for amount currency control OPRID & GL_APPR_STATUS for search criteria ATTACHMENT_EXIST

KK_AF_SRCH_VW

(SQL View)

Journal Header Data For AF

Journal Header Data For AF Not on-page fields: CURRENCY_CD for amount currency control OPRID & GL_APPR_STATUS for search criteria ATTACHMENT_EXIST

SELECT DISTINCT H.BUSINESS_UNIT , H.JOURNAL_ID , H.JOURNAL_DATE , H.LEDGER_GROUP , H.FISCAL_YEAR , H.ACCOUNTING_PERIOD , H.KK_APPR_STATUS , H.JRNL_TOTAL_DEBITS , H.JRNL_TOT_CREDITS , H.DESCR , X.EOAWREQUESTOR_ID , H.CURRENCY_CD , U.OPRID , U.EOAWSTEP_STATUS , H.ATTACHMENT_EXIST , H.KK_BUDG_TRANS_TYPE FROM PS_KK_BUDGET_HDR H , PS_KK_AF_XREF X , PS_EOAW_STEPINST S , PS_EOAW_USERINST U WHERE H.BUSINESS_UNIT = X.BUSINESS_UNIT AND H.JOURNAL_ID = X.JOURNAL_ID AND H.JOURNAL_DATE = X.JOURNAL_DATE AND X.EOAWPARENT_THREAD = ( SELECT MAX(X1.EOAWPARENT_THREAD) FROM PS_KK_AF_XREF X1 WHERE X1.BUSINESS_UNIT=X.BUSINESS_UNIT AND X1.JOURNAL_ID=X.JOURNAL_ID AND X1.JOURNAL_DATE=X.JOURNAL_DATE ) AND X.EOAWTHREAD_ID = S.EOAWTHREAD_ID AND X.EOAWPRCS_ID = S.EOAWPRCS_ID AND X.EOAWDEFN_ID = S.EOAWDEFN_ID AND S.EOAWSTEP_INSTANCE = U.EOAWSTEP_INSTANCE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

5 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year

6 ACCOUNTING_PERIOD Number(3,0) SMALLINT NOT NULL Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.

7 KK_APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
0=Not Required
1=Not Submitted
2=Pending
3=Approved
4=Denied
5=Pushed Back
6=Canceled
7=Resubmittable

8 JRNL_TOTAL_DEBITS Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents a running total of the debit amounts in a journal entry. It is maintained by PeopleSoft General Ledger as lines are entered.

9 JRNL_TOT_CREDITS Signed Number(28,3) DECIMAL(26,3) NOT NULL Represents a running total of the credit amounts in a journal entry. It is maintained by PeopleSoft General Ledger as lines are entered.

10 JRNL_DESCR Character(30) VARCHAR2(30) NOT NULL Journal Description

11 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

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

13 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

14 GL_APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval Status
A=Approved
B=Pushed Back
D=Denied
H=On Hold
P=Pending

15 ATTACHMENT_EXIST Character(1) VARCHAR2(1) NOT NULL Attachments Exist
N=N
Y=Y

16 KK_BUDG_TRANS_TYPE Character(1) VARCHAR2(1) NOT NULL Budget Entry Type
0=Original
1=Adjustment
2=Transfer Adjustment
3=Transfer Original
4=Closing
5=Roll Forward

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	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	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
5	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
6	ACCOUNTING_PERIOD	Number(3,0)	SMALLINT NOT NULL	Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
7	KK_APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval Status 0=Not Required 1=Not Submitted 2=Pending 3=Approved 4=Denied 5=Pushed Back 6=Canceled 7=Resubmittable
8	JRNL_TOTAL_DEBITS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents a running total of the debit amounts in a journal entry. It is maintained by PeopleSoft General Ledger as lines are entered.
9	JRNL_TOT_CREDITS	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Represents a running total of the credit amounts in a journal entry. It is maintained by PeopleSoft General Ledger as lines are entered.
10	JRNL_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Journal Description
11	REQUESTOR_ID	Character(30)	VARCHAR2(30) NOT NULL	Requestor id
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
13	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
14	GL_APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval Status A=Approved B=Pushed Back D=Denied H=On Hold P=Pending
15	ATTACHMENT_EXIST	Character(1)	VARCHAR2(1) NOT NULL	Attachments Exist N=N Y=Y
16	KK_BUDG_TRANS_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Budget Entry Type 0=Original 1=Adjustment 2=Transfer Adjustment 3=Transfer Original 4=Closing 5=Roll Forward