SJE_STNDRD_VW

(SQL View)
 Index Back

Standard Journals Created


SELECT A.BUSINESS_UNIT_IU ,A.SJE_ID ,A.SEQ_NUM ,A.BUSINESS_UNIT ,A.STNDRD_JOURNAL_ID ,A.STNDRD_JOURNAL_DT ,A.STNDRD_UNPOST_SEQ ,B.SJE_DETAIL_TYPE ,C.LEDGER_GROUP ,C.LEDGER ,C.SOURCE ,C.JRNL_HDR_STATUS ,C.CURRENCY_CD ,C.JRNL_TOTAL_DEBITS ,C.JRNL_TOT_CREDITS ,C.JRNL_TOTAL_LINES ,C.JRNL_PROCESS_REQST ,A.RUN_DT FROM PS_SJE_STNDRD_JRNL A, PS_SJE_DETAIL B, PS_JRNL_HEADER C WHERE A.BUSINESS_UNIT_IU = B.BUSINESS_UNIT AND A.SJE_ID = B.SJE_ID AND A.SEQ_NUM = B.SEQ_NUM AND A.BUSINESS_UNIT_IU = C.BUSINESS_UNIT AND A.STNDRD_JOURNAL_ID = C.JOURNAL_ID AND A.STNDRD_JOURNAL_DT = C.JOURNAL_DATE AND A.STNDRD_UNPOST_SEQ = C.UNPOST_SEQ

# 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 SJE_ID Character(10) VARCHAR2(10) NOT NULL Standard Journal
3 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
4 BUSINESS_UNIT_IU Character(5) VARCHAR2(5) NOT NULL Specifies the Business Unit for which InterUnit activity is being generated.
5 STNDRD_JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Standard Journal ID
6 STNDRD_JOURNAL_DT Date(10) DATE NOT NULL Standard Journal Date
7 STNDRD_UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Standard UnPost Sequence
8 SJE_DETAIL_TYPE Character(1) VARCHAR2(1) NOT NULL Standard Journal Entry Type
P=Spread Daily Proration
R=Recurring on a Schedule
S=Spread Across Periods
T=Template to be Completed
9 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group
10 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
11 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.
12 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
13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
14 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.
15 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.
16 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.
17 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
18 RUN_DT Date(10) DATE NOT NULL Run Date