JRNL_UP_HFLD_VW (SQL View)	Index Back
Journal Header Fields For AF This View contains GL actuals/standard budget journal header fields by selecting data from JRNL_HEADER table. User can pick up the fields in this view to set up the rules on journal header fields to be used by GL Journal Unpost Approval process. The key-structure matches the search-key-structure of Journal Entry Component JOURNAL_ENTRY_IE.

JRNL_UP_HFLD_VW

(SQL View)

Journal Header Fields For AF

This View contains GL actuals/standard budget journal header fields by selecting data from JRNL_HEADER table. User can pick up the fields in this view to set up the rules on journal header fields to be used by GL Journal Unpost Approval process. The key-structure matches the search-key-structure of Journal Entry Component JOURNAL_ENTRY_IE.

SELECT H.BUSINESS_UNIT_IU , H.JOURNAL_ID , H.JOURNAL_DATE , H.BUSINESS_UNIT , H.ADJUSTING_ENTRY , H.FISCAL_YEAR , H.ACCOUNTING_PERIOD , H.ADB_DATE , H.LEDGER_GROUP , H.JRNL_TOTAL_DEBITS , H.JRNL_TOT_CREDITS , H.SOURCE , H.CURRENCY_CD , H.DOC_TYPE , H.DOC_SEQ_NBR , H.DOC_SEQ_DATE , H.DOC_SEQ_STATUS , H.GL_ADJUST_TYPE , H.JOURNAL_CLASS FROM PS_JRNL_HEADER H WHERE H.JRNL_HDR_STATUS='P' AND H.JRNL_PROCESS_REQST NOT IN ('U','W') AND EXISTS ( SELECT 'X' FROM PS_JRNL_HEADER H1 WHERE H1.BUSINESS_UNIT_IU=H.BUSINESS_UNIT_IU AND H1.BUSINESS_UNIT=H.BUSINESS_UNIT_IU AND H1.JOURNAL_ID=H.JOURNAL_ID AND H1.JOURNAL_DATE=H.JOURNAL_DATE AND H1.UNPOST_SEQ=H.UNPOST_SEQ)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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 BUSINESS_UNIT_LN Character(5) VARCHAR2(5) NOT NULL Line Business Unit

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

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

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

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

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

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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

14 DOC_TYPE Character(8) VARCHAR2(8) NOT NULL Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.

15 DOC_SEQ_NBR Character(12) VARCHAR2(12) NOT NULL Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.

16 DOC_SEQ_DATE Date(10) DATE Specifies the date that a document sequence number is assigned to a document or the date the document was created.

17 DOC_SEQ_STATUS Character(1) VARCHAR2(1) NOT NULL A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting.
1=Document Sequencing Disabled
A=GL BU Undefined
B=GL BU Blank
C=Accounting Date blank
D=Doc Type Blank
E=Jrnl Type, Code, Doc Undefine
F=Sequence Range Undefine
G=Max. Sequence Number Reached
H=Manual Nbr for Auto Doc Type
I=No Manual Number Entered
J=Duplicate Manual Number
K=Invalid Ledger
L=Invalid Ledger Group
N=No Status

18 GL_ADJUST_TYPE Character(4) VARCHAR2(4) NOT NULL Adjustment Type

19 JOURNAL_CLASS Character(10) VARCHAR2(10) NOT NULL Journal Class

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
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	BUSINESS_UNIT_LN	Character(5)	VARCHAR2(5) NOT NULL	Line Business Unit
5	ADJUSTING_ENTRY	Character(1)	VARCHAR2(1) NOT NULL	Adjusting Entry C=Fiscal Year Close N=Non-Adjusting Entry Y=Adjusting Entry
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	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).
9	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
10	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.
11	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.
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	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
14	DOC_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Specifies the business purpose of a financial transaction in countries that require all financial transactions to be tracked as "documents". A Document Type is associated with one and only one Journal Code.
15	DOC_SEQ_NBR	Character(12)	VARCHAR2(12) NOT NULL	Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
16	DOC_SEQ_DATE	Date(10)	DATE	Specifies the date that a document sequence number is assigned to a document or the date the document was created.
17	DOC_SEQ_STATUS	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates a document sequencing error. If there is no error the field is blank and document is considered valid for posting. 1=Document Sequencing Disabled A=GL BU Undefined B=GL BU Blank C=Accounting Date blank D=Doc Type Blank E=Jrnl Type, Code, Doc Undefine F=Sequence Range Undefine G=Max. Sequence Number Reached H=Manual Nbr for Auto Doc Type I=No Manual Number Entered J=Duplicate Manual Number K=Invalid Ledger L=Invalid Ledger Group N=No Status
18	GL_ADJUST_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Adjustment Type
19	JOURNAL_CLASS	Character(10)	VARCHAR2(10) NOT NULL	Journal Class