GL_WC_UP_COMM

(SQL View)
 Index Back

Unpost date view

To display unpost date and comments on approval page

SELECT COMM.BUSINESS_UNIT ,COMM.JOURNAL_ID ,COMM.JOURNAL_DATE , COMM.BUSINESS_UNIT_LN , COMM.UNPOST_SEQ ,COMM.UNPOST_JRNL_DATE ,COMM.COMMENTS FROM PS_JRNL_AF_H_UP_VW HDR , PS_GL_WC_UNPOST_DT COMM WHERE COMM.BUSINESS_UNIT = HDR.BUSINESS_UNIT AND COMM.JOURNAL_ID=HDR.JOURNAL_ID AND COMM.JOURNAL_DATE=HDR.JOURNAL_DATE AND COMM.BUSINESS_UNIT_LN=HDR.BUSINESS_UNIT_LN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
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 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.
4 BUSINESS_UNIT_LN Character(5) VARCHAR2(5) NOT NULL Line Business Unit
5 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".
6 UNPOST_JRNL_DATE Date(10) DATE Unpost Date
7 COMMENTS Long Character CLOB Comment