JRNL_HDR_ATT_VW (SQL View)	Index Back
Journal Header Data Journal Header Data

JRNL_HDR_ATT_VW

(SQL View)

Journal Header Data

SELECT BUSINESS_UNIT , JOURNAL_ID , JOURNAL_DATE , UNPOST_SEQ , BUSINESS_UNIT_IU , ADJUSTING_ENTRY , FISCAL_YEAR , ACCOUNTING_PERIOD , ADB_DATE , LEDGER_GROUP , LEDGER , SOURCE ,JRNL_HDR_STATUS FROM PS_JRNL_HEADER WHERE BUSINESS_UNIT = BUSINESS_UNIT_IU AND JRNL_HDR_STATUS IN ('N','E','V','P','I','T')

# 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 NOT NULL 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 BUSINESS_UNIT_IU Character(5) VARCHAR2(5) NOT NULL Specifies the Business Unit for which InterUnit activity is being generated.

6 ADJUSTING_ENTRY Character(1) VARCHAR2(1) NOT NULL Adjusting Entry
C=Fiscal Year Close
N=Non-Adjusting Entry
Y=Adjusting Entry

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

8 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.
Prompt Table: GL_OPEN_ADJP_VW

9 ADB_DATE Date(10) DATE Specifies the daily date to use when Average Daily Balancing is activated. The date is determined by the daily calendar associated with the General Ledger Business Unit to which the journal is posted. When ADB processing is not activated, the ADB_Date defaults to the date on the Journal Header (JOURNAL_DATE).

10 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
Prompt Table: SP_BULGRP_NONVW

11 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
Prompt Table: LED_GRP_LED_TBL

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

13 JRNL_HDR_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates the processing status of a journal entry.
D=Deleted
E=Journal Has Errors
I=Posting Incomplete
M=Valid SJE Model -- Do Not Post
N=No Status - Needs to be Edited
P=Posted to Ledger(s)
T=Journal Entry Incomplete
U=Unposted
V=Valid Journal - Edits Complete
X=Cancelled
Z=Upgrade Journal - Can't Unpost

#	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 NOT NULL	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	BUSINESS_UNIT_IU	Character(5)	VARCHAR2(5) NOT NULL	Specifies the Business Unit for which InterUnit activity is being generated.
6	ADJUSTING_ENTRY	Character(1)	VARCHAR2(1) NOT NULL	Adjusting Entry C=Fiscal Year Close N=Non-Adjusting Entry Y=Adjusting Entry
7	FISCAL_YEAR	Number(4,0)	SMALLINT NOT NULL	Fiscal Year
8	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. Prompt Table: GL_OPEN_ADJP_VW
9	ADB_DATE	Date(10)	DATE	Specifies the daily date to use when Average Daily Balancing is activated. The date is determined by the daily calendar associated with the General Ledger Business Unit to which the journal is posted. When ADB processing is not activated, the ADB_Date defaults to the date on the Journal Header (JOURNAL_DATE).
10	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group Prompt Table: SP_BULGRP_NONVW
11	LEDGER	Character(10)	VARCHAR2(10) NOT NULL	Ledger Prompt Table: LED_GRP_LED_TBL
12	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.
13	JRNL_HDR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates the processing status of a journal entry. D=Deleted E=Journal Has Errors I=Posting Incomplete M=Valid SJE Model -- Do Not Post N=No Status - Needs to be Edited P=Posted to Ledger(s) T=Journal Entry Incomplete U=Unposted V=Valid Journal - Edits Complete X=Cancelled Z=Upgrade Journal - Can't Unpost