PC_WC_MJATFT_VW

(SQL View)
 Index Back

Missing Journal Analysis Type

Missing General Journal Analysis Type Filter View

SELECT JNL.BUSINESS_UNIT ,JNL.JOURNAL_ID ,PRJ.BUSINESS_UNIT ,PRJ.PROJECT_ID ,JNL.DEPTID ,JNL.JOURNAL_DATE FROM PS_JRNL_LN JNL ,PS_PROJECT PRJ ,PS_PROJ_ACTIVITY ACT WHERE PRJ.BUSINESS_UNIT = ACT.BUSINESS_UNIT AND PRJ.PROJECT_ID = ACT.PROJECT_ID AND JNL.BUSINESS_UNIT_PC = PRJ.BUSINESS_UNIT AND JNL.PROJECT_ID = PRJ.PROJECT_ID AND JNL.ACTIVITY_ID = ACT.ACTIVITY_ID AND JNL.ANALYSIS_TYPE = ' ' AND JNL.BUSINESS_UNIT_PC <> ' ' AND JNL.PROJECT_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

Default Value: JRNL_LN.BUSINESS_UNIT

Prompt Table: SP_BU_GL_NONVW

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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PC_NONVW

4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
5 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
6 ACCOUNTING_DT Date(10) DATE The accounting entry construction date for a given transaction (a generic field that crosses multiple