|
select business_unit,
journal_id,
journal_date,
unpost_seq,
ledger_group,
ledger,
reversal_cd,
jrnl_total_lines,
jrnl_total_debits,
source,
jrnl_balance_stat,
control_total_stat,
jrnl_edit_err_stat,
jrnl_hdr_status,
jrnl_process_reqst,
event_occurrence,
currency_cd,
descr
from PS_JRNL_HEADER
where sje_type <> ' '
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
SJE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Standard Journal
|
| 3 |
JOURNAL_DATE |
Date(10) |
DATE |
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 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 6 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 7 |
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
|
| 8 |
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.
|
| 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 |
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.
|
| 11 |
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
|
| 12 |
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
|
| 13 |
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
|
| 14 |
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
|
| 15 |
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
|
| 16 |
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.
|
| 17 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 18 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|