RTBL_JRCPY1_VW

(SQL View)
Index Back

SELECT business_unit_iu ,journal_id ,journal_date ,sce_id ,unpost_seq ,business_unit ,jrnl_hdr_status ,ledger_group ,source ,oprid ,descr ,jrnl_total_lines ,jrnl_total_debits ,reversal_cd FROM PS_JRNL_HEADER a WHERE EXISTS ( SELECT 'X' FROM PS_JRNL_HEADER B WHERE B.BUSINESS_UNIT_IU=A.BUSINESS_UNIT_IU AND B.BUSINESS_UNIT=A.BUSINESS_UNIT_IU AND B.JOURNAL_ID=A.JOURNAL_ID AND B.JOURNAL_DATE=A.JOURNAL_DATE AND A.UNPOST_SEQ=B.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 SCE_ID Character(10) VARCHAR2(10) NOT NULL ID
5 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".
6 BUSINESS_UNIT_LN Character(5) VARCHAR2(5) NOT NULL Line Business Unit
7 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

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

Prompt Table: SP_BULGRP_NONVW

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.

Prompt Table: SOURCE_TBL

10 OPRID_ENTERED_BY Character(30) VARCHAR2(30) NOT NULL Entered By 07/25/2011 MRAD 12383033 :Ensured that OPRID_ENTERED_BY is set with format type of MixedCase. 03/22/2013 GL 16482301: Switched OPRID_ENTERED_BY back to MixedCase again. Please don't change it to UpperCase!!! FYI - The alternatives to use a User ID as uppercase: 1) Create your own User ID, add comments in the Field Properties, and fill out the Owner ID 2) Use %Upper meta-SQL in SQL statements 3) Use Upper function in peoplecodes
11 DESCR Character(30) VARCHAR2(30) NOT NULL Description

Default Value: JRNL_HEADER.DESCR254

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