| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
SOURCE_INSTANCE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Identifies a Process Instance (PROCESS_INSTANCE), and is used by the PeopleSoft Process Scheduler to save this identifier.
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 4 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 5 |
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.
|
| 6 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
|
| 7 |
PROC_PART_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Partition ID
|
| 8 |
JOURNAL_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Range From Journal ID
|
| 9 |
JOURNAL_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Range to Journal ID
|
| 10 |
JOURNAL_DATE_FROM |
Date(10) |
DATE |
Journal Date From
|
| 11 |
JOURNAL_DATE_TO |
Date(10) |
DATE |
To Journal Date
|
| 12 |
JRNL_BGTCHK_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Budget Check option. Used in Journal Edit request or other GL processes (e.g. Allocations, Closing, Revaluation, ...) to flag if journals will be budget checked after they are edited valid.
|
| 13 |
JRNL_POST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Journal(s)
|
| 14 |
JRNL_REEDIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Edit Previously Edited
|
| 15 |
MARK_POST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
|
| 16 |
RECALC_EXCHNG_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
|
| 17 |
RETURN_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Return Code
0=Return OK
1=Return error
|
| 18 |
PROCESS_INSTANCE2 |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 19 |
EDIT_CHARTFIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit ChartField Values
Y/N Table Edit
Default Value: Y
|
| 20 |
WHERE_TXT_LONG |
Long Character(4000) |
CLOB |
Where clause
|
| 21 |
JRNL_PROC_NAME |
Character(2) |
VARCHAR2(2) NOT NULL |
Journal process name for audit trail.
01=Journal Entry
02=Mark Journal for Posting
03=Mark Journal for Unposting
04=Journal Suspense Correction
05=Copy Journal
06=Create Standard Entry
07=External Flat File
08=Spreadsheet Import Batch
09=Edit Journal
10=Spreadsheet Import Online
11=Generate Journals
12=Allocation
13=Post Journal
14=Request Ledger Close
15=Process Multi-Currency
16=Consolidation
17=Equitization
18=Reversal Journals
19=BookCode Journals
20=Unpost Journals
21=Amortization Generate Journals
22=Mass Delete Journals
|
| 22 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| 23 |
RECNAME_JRNL_HDR |
Character(15) |
VARCHAR2(15) NOT NULL |
Journal Header
|
| 24 |
RECNAME_JRNL_LN |
Character(15) |
VARCHAR2(15) NOT NULL |
Journal Line
|
| 25 |
GLJE_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Entry Mode
|
| 26 |
RECNAME_HEADER |
Character(15) |
VARCHAR2(15) NOT NULL |
Header Record
|
| 27 |
RECNAME_LINE |
Character(15) |
VARCHAR2(15) NOT NULL |
Line Record
|
| 28 |
SCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Scenario ID
|
| 29 |
RTBL_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
RTBL Mode
Y/N Table Edit
Default Value: N
|
| 30 |
RTBL_COMBO_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
RTBL Combination Edit Flag
Y/N Table Edit
Default Value: N
|
| 31 |
USE_GTT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Global Temp Table Flag
Y/N Table Edit
Default Value: N
|