SJE_STND_MDL_VW (SQL View)	Index Back
Standard Journals Created

SJE_STND_MDL_VW

(SQL View)

Standard Journals Created

SELECT A.BUSINESS_UNIT_IU ,A.SJE_ID ,A.SEQ_NUM ,A.MODEL_JOURNAL_ID ,A.MODEL_JOURNAL_DATE ,A.MODEL_UNPOST_SEQ ,A.BUSINESS_UNIT ,A.STNDRD_JOURNAL_ID ,A.STNDRD_JOURNAL_DT ,A.STNDRD_UNPOST_SEQ ,B.SJE_DETAIL_TYPE ,C.CURRENCY_CD ,C.JRNL_TOTAL_DEBITS ,C.JRNL_TOT_CREDITS 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.MODEL_JOURNAL_ID = C.JOURNAL_ID AND A.MODEL_JOURNAL_DATE = C.JOURNAL_DATE AND A.MODEL_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 MODEL_JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Model GL Journal ID

5 MODEL_JOURNAL_DATE Date(10) DATE Model Journal Date

6 MODEL_UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Model UnPost Sequence

7 BUSINESS_UNIT_IU Character(5) VARCHAR2(5) NOT NULL Specifies the Business Unit for which InterUnit activity is being generated.

8 STNDRD_JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Standard Journal ID

9 STNDRD_JOURNAL_DT Date(10) DATE NOT NULL Standard Journal Date

10 STNDRD_UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Standard UnPost Sequence

11 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

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

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

#	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	MODEL_JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Model GL Journal ID
5	MODEL_JOURNAL_DATE	Date(10)	DATE	Model Journal Date
6	MODEL_UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Model UnPost Sequence
7	BUSINESS_UNIT_IU	Character(5)	VARCHAR2(5) NOT NULL	Specifies the Business Unit for which InterUnit activity is being generated.
8	STNDRD_JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Standard Journal ID
9	STNDRD_JOURNAL_DT	Date(10)	DATE NOT NULL	Standard Journal Date
10	STNDRD_UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Standard UnPost Sequence
11	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
12	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
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	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.