| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 5 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 6 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
|
| 7 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
|
| 8 |
FROM_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
From Date Option
C=Current Date
F=Begin Date - From Period
N=No From Date
P=Process Date
S=Specify Date
T=Begin Date - To Period
|
| 9 |
FROM_DT |
Date(10) |
DATE |
From Date
|
| 10 |
TO_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
To Date Option
C=Current Date
F=End Date - From Period
P=Process Date
S=Specify Date
T=End Date - To Period
|
| 11 |
TO_DT |
Date(10) |
DATE |
To Date
|
| 12 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 13 |
ACCTG_DEF_NAME |
Character(10) |
VARCHAR2(10) NOT NULL |
Defines the content and source of the accounting transactions that the Journal Generator program of PeopleSoft General Ledger uses to create journal entries. Accounting transactions are populated by PeopleSoft applications or third-party systems for input to the general ledger.
|
| 14 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 15 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 16 |
APPL_JRNL_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Journal Template
|
| 17 |
APPL_JRNL_ID_DFLT |
Character(10) |
VARCHAR2(10) NOT NULL |
Default Journal Template
|
| 18 |
JRNL_EDIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Journal(s)
|
| 19 |
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.
|
| 20 |
JRNL_POST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Journal(s)
|
| 21 |
RTM_PRCS_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
On-Demand Process Flag
|
| 22 |
RECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
|
| 23 |
RECNAME_UPDATE |
Character(15) |
VARCHAR2(15) NOT NULL |
Record to Update
|
| 24 |
FIELDNAME_MON_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Monetary Amount
|
| 25 |
FIELDNAME_FRN_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Foreign Amount
|
| 26 |
FIELDNAME_STAT_AMT |
Character(18) |
VARCHAR2(18) NOT NULL |
Statistical Amount
|
| 27 |
FIELDNAME_JRNL_REF |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname Journal Reference
|
| 28 |
FIELDNAME_DESCR |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname Journal Line Descr
|
| 29 |
FIELDNAME_OPEN_KEY |
Character(18) |
VARCHAR2(18) NOT NULL |
Fieldname Open Item Key
|
| 30 |
FIELDNAME_ACCTDATE |
Character(18) |
VARCHAR2(18) NOT NULL |
Accounting Date field name
|
| 31 |
FIELDNAME_STLMT_DT |
Character(18) |
VARCHAR2(18) NOT NULL |
Settlement Date
Default Value: SETTLEMENT_DT
Prompt Table:
RECFLDDB_VW
|
| 32 |
FIELDNAME_DT_STAMP |
Character(18) |
VARCHAR2(18) NOT NULL |
Last Update DateTime
|
| 33 |
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.
|
| 34 |
BUDGET_AMT_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Budget Amount Type
EN=Encumbrance
OT=Other
PR=Pre-Encumbrance
|
| 35 |
DRILL_DOWN_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Cross Product Drill Down
N=No Drill Down
Y=Drill Down
|
| 36 |
KK_SKIP |
Character(1) |
VARCHAR2(1) NOT NULL |
The field is used in Journal Header record. If its value is '1', the journal will skip commitment control budget checking. Usually, the journal created from Journal Generator for accounting entries which have been budget checked already will have '1' populated in this field.
0=Commitment Control in GL
1=Skip Commitment Control in GL
|
| 37 |
JGEN_KK_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Amount Type Option
A=All Amount Type
V=Specific Amount Type
|
| 38 |
KK_AMOUNT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control Amount Type
0=Budget
1=Actuals and Recognized
2=Encumbrance
3=Pre-Encumbrance
4=Collected Revenue
5=Planned
7=Actuals, Recognize and Collect
9=Dynamic
|
| 39 |
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.
|
| 40 |
LEDGER_GROUP_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Ledger Group Option
A=All Ledger Group Values
V=Single Ledger Group Value
|
| 41 |
LEDGER_GROUP_LAST |
Character(10) |
VARCHAR2(10) NOT NULL |
Last Ledger Group
|
| 42 |
SOURCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Source Option
A=All Sources
V=Single Source Value
|
| 43 |
SOURCE_LAST |
Character(3) |
VARCHAR2(3) NOT NULL |
Last Source
|
| 44 |
SYSTEM_SOURCE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
System Source Option
A=All System Sources
V=Single System Source Value
|
| 45 |
SYSTEM_SOURCE_LAST |
Character(3) |
VARCHAR2(3) NOT NULL |
Last System Source
|
| 46 |
JOURNAL_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Range From Journal ID
|
| 47 |
JOURNAL_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Range to Journal ID
|
| 48 |
JOURNAL_DATE_FROM |
Date(10) |
DATE |
Journal Date From
|
| 49 |
JOURNAL_DATE_TO |
Date(10) |
DATE |
To Journal Date
|
| 50 |
NBR_JOURNALS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Number of Journals
|
| 51 |
PUBLISH |
Character(1) |
VARCHAR2(1) NOT NULL |
Publish Data
|
| 52 |
GL |
Character(1) |
VARCHAR2(1) NOT NULL |
General Ledger
|
| 53 |
ACTIVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Flag
A=Active
I=Inactive
|
| 54 |
UPDATE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Select Clause
|
| 55 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|