SJE_JRNL_VW

(SQL View)
Index Back

SJE View

SJE View

SELECT BUSINESS_UNIT , SJE_ID , SEQ_NUM , NEW_JOURNAL_ID FROM PS_SJE_DETAIL

# 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 STNDRD_JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Standard Journal ID