JRNL_IU_NPST_VW (SQL View)	Index Back
SrchRec Unposted Journal Hdrs

JRNL_IU_NPST_VW

(SQL View)

SrchRec Unposted Journal Hdrs

SELECT BUSINESS_UNIT ,JOURNAL_ID ,JOURNAL_DATE ,UNPOST_SEQ ,JRNL_HDR_STATUS ,FISCAL_YEAR ,ACCOUNTING_PERIOD ,LEDGER_GROUP ,SOURCE ,TRANS_REF_NUM ,POSTED_DATE ,JRNL_TOTAL_LINES ,JRNL_TOTAL_DEBITS ,JRNL_NET_UNITS ,CURRENCY_CD ,DESCR FROM PS_JRNL_HEADER A WHERE (JRNL_HDR_STATUS IN ('N','E','V') OR (BUSINESS_UNIT = BUSINESS_UNIT_IU AND EXISTS ( SELECT 'X' FROM PS_JRNL_HEADER WHERE BUSINESS_UNIT_IU = A.BUSINESS_UNIT_IU AND JOURNAL_ID=A.JOURNAL_ID AND JOURNAL_DATE=A.JOURNAL_DATE AND UNPOST_SEQ=A.UNPOST_SEQ AND JRNL_HDR_STATUS IN ('N','E','V')))) AND 'JRNL_LN'=( SELECT T.RECNAME_JRNL_LN FROM PS_LED_TMPLT_TBL T , PS_LED_GRP_TBL D , PS_SET_CNTRL_REC E WHERE T.LEDGER_TEMPLATE=D.LEDGER_TEMPLATE AND D.LEDGER_GROUP = A.LEDGER_GROUP AND D.SETID=E.SETID AND E.SETCNTRLVALUE=A.BUSINESS_UNIT AND E.RECNAME = 'LED_GRP_TBL')

# 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.
Default Value: NEXT

3 JOURNAL_DATE Date(10) DATE NOT NULL Specifies the date the journal was created.
Default Value: %date

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 JRNL_IU_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL Journal Header Status
E=Journal Has Errors
N=No Status - Needs to be Edited
P=Main Jrnl Posted (InterUnit)
U=Main Jrnl Unposted (InterUnit)
V=Valid Journal - Edits Complete

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

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

8 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

9 SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
Default Value: OPR_DEF_TBL_FS.SOURCE

10 TRANS_REF_NUM Character(8) VARCHAR2(8) NOT NULL Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal entry. The journal reference is helpful if you need to trace back to the source of the transaction.

11 POSTED_DATE Date(10) DATE Specifies the date that a journal entry is posted. This field is maintained by the posting program of PeopleSoft General Ledger.

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

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

14 JRNL_NET_UNITS Signed Number(27,2) DECIMAL(25,2) NOT NULL Represents a running total of the statistical units in a journal entry. It is a hash total since there may be different types of units of measure reflected in a single journal. It is maintained by PeopleSoft General Ledger as lines are entered.

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

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

#	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. Default Value: NEXT
3	JOURNAL_DATE	Date(10)	DATE NOT NULL	Specifies the date the journal was created. Default Value: %date
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	JRNL_IU_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Journal Header Status E=Journal Has Errors N=No Status - Needs to be Edited P=Main Jrnl Posted (InterUnit) U=Main Jrnl Unposted (InterUnit) V=Valid Journal - Edits Complete
6	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
7	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.
8	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
9	SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual. Default Value: OPR_DEF_TBL_FS.SOURCE
10	TRANS_REF_NUM	Character(8)	VARCHAR2(8) NOT NULL	Identifies a document, person, invoice, date, or any other piece of information that is associated with a journal entry. The journal reference is helpful if you need to trace back to the source of the transaction.
11	POSTED_DATE	Date(10)	DATE	Specifies the date that a journal entry is posted. This field is maintained by the posting program of PeopleSoft General Ledger.
12	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.
13	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.
14	JRNL_NET_UNITS	Signed Number(27,2)	DECIMAL(25,2) NOT NULL	Represents a running total of the statistical units in a journal entry. It is a hash total since there may be different types of units of measure reflected in a single journal. It is maintained by PeopleSoft General Ledger as lines are entered.
15	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
16	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description