JRNL_POSTD_E_VW(SQL View) |
Index Back |
---|---|
SrchRec Posted Journal Headers |
SELECT business_unit , ledger_group , source , fiscal_year , accounting_period , journal_id , journal_date , unpost_seq , jrnl_process_reqst , jrnl_total_lines , descr FROM PS_JRNL_HEADER WHERE jrnl_hdr_status = 'P' AND unpost_seq = 0 AND system_source <> 'AMR' |
# | 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 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL |
Ledger Group
Default Value: OPR_DEF_TBL_FS.LEDGER_GROUP Prompt Table: SP_BULGRP_NONVW |
3 | 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 |
4 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
5 | ACCOUNTING_PERIOD | Number(3,0) | SMALLINT NOT NULL | Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table. |
6 | 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. |
7 | JOURNAL_DATE | Date(10) | DATE NOT NULL | Specifies the date the journal was created. |
8 | 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". |
9 | JRNL_PROCESS_REQST | Character(1) | VARCHAR2(1) NOT NULL |
A flag that determines when a journal is ready for posting. Some examples of the request flag are Approved to Post, Denied, and Pending Approval.
D=Default E=Denied G=Pending Approval N=None P=Approved to Post Q=Pending for Unpost Approval R=Replace S=Security Denied T=Terminated U=Pending Request to Unpost W=Approved to Post X=Delete |
10 | 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. |
11 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |