PC_JRNL_FT_VW(SQL View) |
Index Back |
|---|---|
Project Journals Filter ViewProject Journals Filter View |
| SELECT HDR.BUSINESS_UNIT ,HDR.JOURNAL_ID ,HDR.JRNL_HDR_STATUS , PRJ.BUSINESS_UNIT ,PRJ.PROJECT_ID ,JNL.JOURNAL_DATE FROM PS_JRNL_LN JNL , PS_JRNL_HEADER HDR ,PS_PROJECT PRJ ,PS_PROJ_ACTIVITY ACT WHERE HDR.BUSINESS_UNIT = JNL.BUSINESS_UNIT AND HDR.JOURNAL_ID = JNL.JOURNAL_ID AND HDR.JOURNAL_DATE = JNL.JOURNAL_DATE AND HDR.UNPOST_SEQ = JNL.UNPOST_SEQ AND 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.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 | 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 |
| 4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 5 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 6 | ACCOUNTING_DT | Date(10) | DATE | The accounting entry construction date for a given transaction (a generic field that crosses multiple |