JRNL_M_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT_IU ,A.JOURNAL_ID ,A.JOURNAL_DATE ,A.UNPOST_SEQ ,A.JRNL_HDR_STATUS ,A.LEDGER_GROUP ,A.SOURCE ,A.CURRENCY_CD ,A.JRNL_TOTAL_LINES ,A.JRNL_TOTAL_DEBITS ,A.JRNL_NET_UNITS ,A.DESCR FROM PS_JRNL_HEADER A WHERE A.JRNL_HDR_STATUS = 'M' AND A.UNPOST_SEQ = 0 |
| # | 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 | 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 NOT NULL |
Specifies the date the journal was created.
Default Value: %date |
| 4 | 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". |
| 5 | 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 Default Value: N |
| 6 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |
| 7 | SOURCE | Character(3) | VARCHAR2(3) NOT NULL |
Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
Default Value: OPR_DEF_TBL_FS.SOURCE Prompt Table: SOURCE_TBL |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 9 | JRNL_TOTAL_LINES | Number(9,0) | DECIMAL(9) NOT NULL | Represents a running total of the number of lines in a journal entry. It is maintained by PeopleSoft General Ledger as lines are entered. |
| 10 | 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. |
| 11 | JRNL_NET_UNITS | Signed Number(27,2) | DECIMAL(25,2) NOT NULL | Represents a running total of the statistical units in a journal entry. It is a hash total since there may be different types of units of measure reflected in a single journal. It is maintained by PeopleSoft General Ledger as lines are entered. |
| 12 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |