RTBL_JHDR_VW

(SQL View)

SELECT A.SCE_ID ,A.PROCESS_INSTANCE , A.BUSINESS_UNIT ,A.JOURNAL_ID , A.JOURNAL_DATE ,A.JRNL_HDR_STATUS ,A.JRNL_TOTAL_LINES ,A.CURRENCY_CD , A.JRNL_TOTAL_DEBITS ,A.JRNL_TOT_CREDITS ,A.DESCR FROM PS_RTBL_JHDR A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID

2 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

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

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

5 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

6 JOURNAL_STATUS Character(1) VARCHAR2(1) NOT NULL Journal Status
E=Journal Has Errors
J=Posted (by journal dates)
N=No Status - Needs to be Edited
P=Posted (by posting dates)
U=Unposted
V=Valid Journal - Edits Complete

7 JRNL_TOTAL_LINES Number(9,0) DECIMAL(9) NOT NULL Represents a running total of the number of lines in a journal entry. It is maintained by PeopleSoft General Ledger as lines are entered.

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCE_ID	Character(10)	VARCHAR2(10) NOT NULL	ID
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	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.
5	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.
6	JOURNAL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Journal Status E=Journal Has Errors J=Posted (by journal dates) N=No Status - Needs to be Edited P=Posted (by posting dates) U=Unposted V=Valid Journal - Edits Complete
7	JRNL_TOTAL_LINES	Number(9,0)	DECIMAL(9) NOT NULL	Represents a running total of the number of lines in a journal entry. It is maintained by PeopleSoft General Ledger as lines are entered.
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	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.
10	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.
11	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description