PC_JRNL_HEADER (SQL Table)	Index Back
PC Allocations Journal Header PC Allocations Journal Header

PC_JRNL_HEADER

(SQL Table)

PC Allocations Journal Header

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

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 Character(10) VARCHAR2(10) NOT NULL Ledger
Default Value: OPR_DEF_TBL_FS.LEDGER
Prompt Table: SP_BULEDD_NONVW

9 REVERSAL_CD Character(1) VARCHAR2(1) NOT NULL A flag that indicates if a journal entry should be automatically reversed, and if so, with what date. When associated with a reversal entry, it indicates that the entry was created automatically by the reversal process.
B=Beginning of Next Period
D=On Date Specified By User
E=End of Next Period
N=Do Not Generate Reversal
R=Created by Reversal Process
U=Adjustment Period
X=Next Day
Default Value: N

10 REVERSAL_DATE Date(10) DATE Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date.

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

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

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

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 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
Prompt Table: SOURCE_TBL

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

17 JRNL_BALANCE_STAT Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not a journal is in balance. A balanced journal is one in which the debit and credit lines net to zero. This field is maintained by the journal edit program of PeopleSoft General Ledger.
E=Error - Journal Out of Balance
V=Valid - Journal in Balance
Default Value: V

18 CONTROL_TOTAL_STAT Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not the control totals match the entry totals for a journal entry. The status is either (E) indicating an error or (V) indicating that the match is OK.
E=Error - Control Totals
V=Valid - Control Totals
Default Value: V

19 JRNL_EDIT_ERR_STAT Character(1) VARCHAR2(1) NOT NULL A flag that indicates whether or not there are edit errors in a journal entry.
E=Error - Edit Error(s)
N=No Status
V=Valid - No Edit Errors
Default Value: V

20 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
Default Value: N

21 JRNL_PROCESS_REQST Character(1) VARCHAR2(1) NOT NULL A flag that determines when a journal is ready for posting. Some examples of the request flag are Approved to Post, Denied, and Pending Approval.
D=Default
E=Denied
G=Pending Approval
N=None
P=Approved to Post
Q=Pending for Unpost Approval
R=Replace
S=Security Denied
T=Terminated
U=Pending Request to Unpost
W=Approved to Post
X=Delete
Default Value: N

22 JRNL_SUMLED_REQST Character(1) VARCHAR2(1) NOT NULL Post to Summary Ledger
Y/N Table Edit
Default Value: N

23 SJE_TYPE Character(1) VARCHAR2(1) NOT NULL A flag that indicates the type of Standard Journal Entry (SJE), which can be either Template or Recurring. If the type is Recurring you must also specify a schedule (SCHEDULE).
M=Model -- Do Not Post
P=Spread Daily Proration
R=Recurring on a Schedule
S=Spread Amounts from SJE Model
T=Template to be Completed

24 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID
Prompt Table: SCHEDULE_TBL

25 EVENT_OCCURRENCE Number(3,0) SMALLINT NOT NULL Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal.
Prompt Table: EVENTS_TBL

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

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

28 TRANSACTION_DATE Date(10) DATE Transaction Date
Default Value: JRNL_HEADER_FS.JOURNAL_DATE

29 LAST_LN_COMMITTED Number(6,0) INTEGER NOT NULL Last Line Committed

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

31 DTTM_STAMP_SEC DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

32 DESCR Character(30) VARCHAR2(30) NOT NULL Description
Default Value: JRNL_HEADER_FS.DESCR254

33 FOREIGN_CURRENCY Character(3) VARCHAR2(3) NOT NULL Foreign Currency Code
Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY
Prompt Table: FRGN_CURR_VW

34 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
Prompt Table: CUR_RT_TYPE_TBL

35 CUR_EFFDT Date(10) DATE Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header.
Default Value: JRNL_HEADER_FS.JOURNAL_DATE

36 CUR_EXCHNG_RT Number(16,8) DECIMAL(15,8) NOT NULL Currency Exchange Rate

37 SYSTEM_SOURCE Character(3) VARCHAR2(3) NOT NULL Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.

38 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

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

#	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	BUSINESS_UNIT_IU	Character(5)	VARCHAR2(5) NOT NULL	Specifies the Business Unit for which InterUnit activity is being generated. Default Value: JRNL_HEADER_FS.BUSINESS_UNIT
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	Character(10)	VARCHAR2(10) NOT NULL	Ledger Default Value: OPR_DEF_TBL_FS.LEDGER Prompt Table: SP_BULEDD_NONVW
9	REVERSAL_CD	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates if a journal entry should be automatically reversed, and if so, with what date. When associated with a reversal entry, it indicates that the entry was created automatically by the reversal process. B=Beginning of Next Period D=On Date Specified By User E=End of Next Period N=Do Not Generate Reversal R=Created by Reversal Process U=Adjustment Period X=Next Day Default Value: N
10	REVERSAL_DATE	Date(10)	DATE	Specifies the date for an automatic reversal journal entry. The date must be within the calendar of the target (posting) ledger. PeopleSoft General Ledger automatically creates and populates a journal entry with this date.
11	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.
12	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.
13	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.
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	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 Prompt Table: SOURCE_TBL
16	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.
17	JRNL_BALANCE_STAT	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not a journal is in balance. A balanced journal is one in which the debit and credit lines net to zero. This field is maintained by the journal edit program of PeopleSoft General Ledger. E=Error - Journal Out of Balance V=Valid - Journal in Balance Default Value: V
18	CONTROL_TOTAL_STAT	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not the control totals match the entry totals for a journal entry. The status is either (E) indicating an error or (V) indicating that the match is OK. E=Error - Control Totals V=Valid - Control Totals Default Value: V
19	JRNL_EDIT_ERR_STAT	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates whether or not there are edit errors in a journal entry. E=Error - Edit Error(s) N=No Status V=Valid - No Edit Errors Default Value: V
20	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 Default Value: N
21	JRNL_PROCESS_REQST	Character(1)	VARCHAR2(1) NOT NULL	A flag that determines when a journal is ready for posting. Some examples of the request flag are Approved to Post, Denied, and Pending Approval. D=Default E=Denied G=Pending Approval N=None P=Approved to Post Q=Pending for Unpost Approval R=Replace S=Security Denied T=Terminated U=Pending Request to Unpost W=Approved to Post X=Delete Default Value: N
22	JRNL_SUMLED_REQST	Character(1)	VARCHAR2(1) NOT NULL	Post to Summary Ledger Y/N Table Edit Default Value: N
23	SJE_TYPE	Character(1)	VARCHAR2(1) NOT NULL	A flag that indicates the type of Standard Journal Entry (SJE), which can be either Template or Recurring. If the type is Recurring you must also specify a schedule (SCHEDULE). M=Model -- Do Not Post P=Spread Daily Proration R=Recurring on a Schedule S=Spread Amounts from SJE Model T=Template to be Completed
24	SCHEDULE	Character(10)	VARCHAR2(10) NOT NULL	Schedule ID Prompt Table: SCHEDULE_TBL
25	EVENT_OCCURRENCE	Number(3,0)	SMALLINT NOT NULL	Identifies a user-defined event on a schedule for automatically creating standard and recurring journal entries. Event Occurrence is a number associated with a date for creation of the journal. Prompt Table: EVENTS_TBL
26	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.
27	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
28	TRANSACTION_DATE	Date(10)	DATE	Transaction Date Default Value: JRNL_HEADER_FS.JOURNAL_DATE
29	LAST_LN_COMMITTED	Number(6,0)	INTEGER NOT NULL	Last Line Committed
30	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
31	DTTM_STAMP_SEC	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
32	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description Default Value: JRNL_HEADER_FS.DESCR254
33	FOREIGN_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Foreign Currency Code Default Value: BUS_UNIT_TBL_GL.BASE_CURRENCY Prompt Table: FRGN_CURR_VW
34	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Prompt Table: CUR_RT_TYPE_TBL
35	CUR_EFFDT	Date(10)	DATE	Specifies the effective date associated with the currency used as the base currency for the Business Unit on the Journal Entry Header. Default Value: JRNL_HEADER_FS.JOURNAL_DATE
36	CUR_EXCHNG_RT	Number(16,8)	DECIMAL(15,8) NOT NULL	Currency Exchange Rate
37	SYSTEM_SOURCE	Character(3)	VARCHAR2(3) NOT NULL	Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
38	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
39	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code