|
SELECT A.BUSINESS_UNIT_IU , A.LEDGER_GROUP , A.FISCAL_YEAR , A.ACCOUNTING_PERIOD , A.JRNL_HDR_STATUS , A.BUDGET_HDR_STATUS , A.BUSINESS_UNIT , A.JRNL_CREATE_DTTM , A.OPRID , A.CURRENCY_CD , A.JRNL_TOTAL_DEBITS , A.JRNL_TOT_CREDITS , A.LEDGER , A.ADB_DATE , A.REVERSAL_CD , A.REVERSAL_ADJ_PER , A.REVERSAL_CD_ADB , A.REVERSAL_DATE_ADB , A.UNPOST_JRNL_DATE , A.DOC_SEQ_NBR , A.SJE_TYPE , A.DATE_CODE_JRNL , A.JRNL_TOTAL_LINES , A.JOURNAL_DATE , A.SOURCE , A.JOURNAL_ID , A.DESCR , B.GL_APPR_STATUS , B.REQUESTOR_ID FROM PS_JRNL_HEADER A , PS_JRNL_AF_SRCH_VW B WHERE A.BUSINESS_UNIT_IU=B.BUSINESS_UNIT AND A.JOURNAL_ID=B.JOURNAL_ID AND A.JOURNAL_DATE=B.JOURNAL_DATE AND A.BUSINESS_UNIT=B.BUSINESS_UNIT_LN
|
| # |
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
Prompt Table:
SP_BULGRP_NONVW
|
| 3 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
Prompt Table:
CAL_FY_VW
|
| 4 |
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.
Prompt Table:
CAL_AP_VW
|
| 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 |
BUDGET_HDR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Checking Header Status
E=Error in Budget Check
I=Document In Processing
N=Not Budget Checked
P=Provisionally Valid
V=Valid
|
| 7 |
BUSINESS_UNIT_LN |
Character(5) |
VARCHAR2(5) NOT NULL |
Line Business Unit
Prompt Table:
SP_BU_GL_NONVW
|
| 8 |
JRNL_CREATE_DTTM |
DateTime(26) |
TIMESTAMP |
Journal Creation Date Time
|
| 9 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 10 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 11 |
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.
|
| 12 |
JRNL_TOT_CREDITS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents a running total of the credit amounts in a journal entry. It is maintained by PeopleSoft General Ledger as lines are entered.
|
| 13 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 14 |
ADB_DATE |
Date(10) |
DATE |
Specifies the daily date to use when Average Daily Balancing is activated. The date is determined by the daily calendar associated with the General Ledger Business Unit to which the journal is posted. When ADB processing is not activated, the ADB_Date defaults to the date on the Journal Header (JOURNAL_DATE).
|
| 15 |
REVERSAL_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates if a journal entry should be automatically reversed, and if so, with what date. When associated with a reversal entry, it indicates that the entry was created automatically by the reversal process.
B=Beginning of Next Period
D=On Date Specified By User
E=End of Next Period
N=Do Not Generate Reversal
R=Created by Reversal Process
U=Adjustment Period
X=Next Day
|
| 16 |
REVERSAL_ADJ_PER |
Number(3,0) |
SMALLINT NOT NULL |
Adjustment Period
|
| 17 |
REVERSAL_CD_ADB |
Character(1) |
VARCHAR2(1) NOT NULL |
ADB Reversal Code
D=On Date Specified By User
S=Same As Journal Reversal
|
| 18 |
REVERSAL_DATE_ADB |
Date(10) |
DATE |
ADB Reversal Date
|
| 19 |
UNPOST_JRNL_DATE |
Date(10) |
DATE |
Unpost Date
|
| 20 |
DOC_SEQ_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Specifies the sequence number assigned to each financial transaction (a document). The sequence number may be manually entered or system-generated.
|
| 21 |
SJE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates the type of Standard Journal Entry (SJE), which can be either Template or Recurring. If the type is Recurring you must also specify a schedule (SCHEDULE).
M=Model -- Do Not Post
P=Spread Daily Proration
R=Recurring on a Schedule
S=Spread Amounts from SJE Model
T=Template to be Completed
|
| 22 |
DATE_CODE_JRNL |
Character(1) |
VARCHAR2(1) NOT NULL |
This field defines codes for Date field used in Journal lines record.
The Different date fields can be used as the basis for alternate Posting to satisfy Trade Date/Settlement date requirements.
|
| 23 |
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.
|
| 24 |
JOURNAL_DATE |
Date(10) |
DATE |
Specifies the date the journal was created.
|
| 25 |
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
|
| 26 |
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.
|
| 27 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 28 |
GL_APPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval Status
A=Approved
B=Pushed Back
D=Denied
H=On Hold
P=Pending
|
| 29 |
REQUESTOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Requestor id
|