JRNL_HDR_IU_VW2(SQL View) |
Index Back |
|---|---|
SrchRec Journal Hdrs |
| select business_unit_iu ,journal_id ,journal_date ,unpost_seq ,jrnl_hdr_status ,ledger_group ,source ,currency_cd ,sum(jrnl_total_lines) ,sum(jrnl_total_debits) ,sum(jrnl_net_units) ,descr from PS_JRNL_HEADER a group by business_unit_iu ,journal_id ,journal_date ,unpost_seq ,jrnl_hdr_status ,ledger_group ,source ,currency_cd ,descr |
| # | 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.
Default Value: NEXT |
| 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 |