| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 WORKSHEET_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Cash Flows Worksheet ID
|
| 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 |
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
Default Value: N
|
| 5 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 6 |
FR_SHOW_LEVELS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Detail Levels
Y/N Table Edit
Default Value: N
|
| 7 |
FR_SHOW_DEPEND_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Cross Reference
Y/N Table Edit
Default Value: N
|
| 8 |
FR_DETAIL_LEVEL |
Number(3,0) |
SMALLINT NOT NULL |
Display Line Items of Level
Default Value: 1
|
| 9 |
FR_RESET_ALL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No - Reset all manual adjustment back to zero
Y/N Table Edit
Default Value: N
|
| 10 |
FR_BU_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Show results for single BU, BU under a node, or all BU's.
1=One Unit
2=Tree Node
Default Value: 1
|
| 11 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
Prompt Table:
SP_BU_GL_NONVW
|
| 12 |
TREE_NAME_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
TableSet
Prompt Table:
SP_SETID_NONVW
|
| 13 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
TREEDEFN_VW
|
| 14 |
TREE_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Node name
Prompt Table:
TREE_NODE_VW
|
| 15 |
FR_ELEMENT_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Element ID
Prompt Table:
FR_ELMT_TBL
|
| 16 |
LEDGER_SET |
Character(20) |
VARCHAR2(20) NOT NULL |
Ledger Set
Prompt Table:
FR_LEDGER_SET
|
| 17 |
RT_TYPE_BEGIN |
Character(5) |
VARCHAR2(5) NOT NULL |
Beginning balance rate type
Prompt Table:
RT_TYPE_TBL
|
| 18 |
RT_TYPE_VAR |
Character(5) |
VARCHAR2(5) NOT NULL |
Variation rate type
Prompt Table:
RT_TYPE_TBL
|
| 19 |
RT_TYPE_CLS |
Character(5) |
VARCHAR2(5) NOT NULL |
Closing rate type
Prompt Table:
RT_TYPE_TBL
|
| 20 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CUR_CD_ALL_VW
|
| 21 |
FR_REPORT_ENTITY |
Character(20) |
VARCHAR2(20) NOT NULL |
Report Entity
Prompt Table:
SP_FR_ENT_NONVW
|
| 22 |
MAX_WAIT_TIME |
Number(9,0) |
DECIMAL(9) NOT NULL |
Maximum Wait Time (Minutes)
Default Value: 5
|