| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table:
OPRID_VW
|
| 2 |
RUNLOCATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Location
0=Both
1=Client
2=Server
Default Value: 2
|
| 3 |
SERVERNAME |
Character(8) |
VARCHAR2(8) NOT NULL |
Server Name
Prompt Table:
SERVERDEFN
|
| 4 |
CHANGE_DATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Change JRNL Date
Y/N Table Edit
Default Value: N
|
| 5 |
JOURNAL_ID_NEXT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Next Journal ID
Y/N Table Edit
Default Value: N
|
| 6 |
CHANGE_JRNLGEN |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Change JrnlGen Journal
Y/N Table Edit
Default Value: N
|
| 7 |
ENTER_ADJ_JRNL |
Character(1) |
VARCHAR2(1) NOT NULL |
Enter Adjustment Type Journal
Y/N Table Edit
Default Value: N
|
| 8 |
ENTER_TRADE_ADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
Enter Adjustment Type Journal
|
| 9 |
SAVE_INC_JRNL |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit
Default Value: N
|
| 10 |
EE_GL_BYPASS |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator - Allow GL Entry Event Bypass
Y/N Table Edit
Default Value: N
|
| 11 |
JRNL_REEDIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Edit Previously Edited
Y/N Table Edit
Default Value: N
|
| 12 |
MARK_POST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit
Default Value: N
|
| 13 |
RECALC_EXCHNG_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit
Default Value: N
|
| 14 |
SKIP_OPEN_ITEM_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit
Default Value: N
|
| 15 |
SKIP_SUMLED_UPD_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
Y/N Table Edit
Default Value: Y
|
| 16 |
SKIP_ESSBASE_LOAD |
Character(1) |
VARCHAR2(1) NOT NULL |
Skip Essbase Incremental Load
Y/N Table Edit
Default Value: Y
|
| 17 |
EDIT_IU_JRNL |
Character(1) |
VARCHAR2(1) NOT NULL |
Option to edit non-anchor journals when editing a journal which is the anchor of an interunit journal
Y/N Table Edit
Default Value: N
|
| 18 |
EE_SKIP |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator - Skip Entry Event processing
Y/N Table Edit
Default Value: N
|
| 19 |
KK_GEN_PRNT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Parent Budget Generation
0=Never Generate
1=Always Generate
2=User Specified
Default Value: 2
|
| 20 |
COPY |
Character(1) |
VARCHAR2(1) NOT NULL |
Copy Down
Y/N Table Edit
Default Value: Y
|
| 21 |
DELETE_CONTROL |
Character(1) |
VARCHAR2(1) NOT NULL |
DELETE_CONTROL
Y/N Table Edit
Default Value: Y
|
| 22 |
UNPOST_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Unpost Flag
Y/N Table Edit
Default Value: Y
|
| 23 |
ONLINE_POST |
Character(1) |
VARCHAR2(1) NOT NULL |
Online Post process option
Y/N Table Edit
Default Value: N
|
| 24 |
KK_LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Control Budget Ledger Group
Prompt Table:
SP_LGRPKK_NONVW
|
| 25 |
AMR_UPD_CF |
Character(1) |
VARCHAR2(1) NOT NULL |
update CFs for Amortization Journals
Y/N Table Edit
Default Value: N
|