| # |
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:
OPR_DEF_TBL_FS
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 4 |
WORKSHEET_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Cash Flows Worksheet ID
Prompt Table:
WRKSHT_DEFN_VW
|
| 5 |
VALUE_DT |
Date(10) |
DATE |
Equivalent to a deal transaction's settlement date.
Prompt Table:
FCST_VAL_VW
|
| 6 |
POSITION_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
The transaction currency of a given position or exposure.
Prompt Table:
POS_CURR_VW
|
| 7 |
BUSINESS_UNIT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether to show the Cash Position for all the Business Units in the report.
Y/N Table Edit
|
| 8 |
BU_GRP_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether to show the Cash Position for a Business Unit Group in the report.
Y/N Table Edit
|
| 9 |
BUSINESS_UNIT_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Group Business Unit
Prompt Table:
BU_GRP_VW
|
| 10 |
BU_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether to show the Cash positon for a particular Business Unit or not.
Y/N Table Edit
|
| 11 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_FS_NONVW
|
| 12 |
ALL_BANK_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether to show the cash position for all Banks in the report.
Y/N Table Edit
|
| 13 |
ACC_GRP_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether to show the cash position for a particular Account Group in the report
Y/N Table Edit
|
| 14 |
BNK_ACCTGRP_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Account Group ID
Prompt Table:
ACC_GRP_VW
|
| 15 |
BNK_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether to show the cash position for a particular Bank or not in the report.
Y/N Table Edit
|
| 16 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table:
SP_SETID_NONVW
|
| 17 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_CD_EXT_VW2
|
| 18 |
ALL_ACC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether to show the cash position for all the Bank Account keys in the report.
Y/N Table Edit
|
| 19 |
ACC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether to show the cash position for a particular Bank Account key in the report.
Y/N Table Edit
|
| 20 |
ACCOUNT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Account SETID
Prompt Table:
SP_SETID_NONVW
|
| 21 |
BANK_CD2 |
Character(5) |
VARCHAR2(5) NOT NULL |
A unique key identifier that represents a bank or counterparty.
Prompt Table:
BANK_CD_EXT_VW3
|
| 22 |
BANK_ACCT_KEY |
Character(4) |
VARCHAR2(4) NOT NULL |
A user defined unique identifier that facilitates the identification of a given account with a given bank
Prompt Table:
BANK_ACCTKEY_V2
|
| 23 |
GROUP_BY_FIELD_VAR |
Character(3) |
VARCHAR2(3) NOT NULL |
Group By Field categorizes worksheet summary lines into various views. Example you can view the results by Business Unit, Bank Account and Currency (as delivered). We also provide generic fields for user defined values.
BAC=Bank Account
BNK=Bank
BU=Business Unit
GP1=Group By Field 1
GP2=Group By Field 2
GP3=Group By Field 3
GP4=Group By Field 4
GP5=Group By Field 5
GP6=Group By Field 6
GP7=Group By Field 7
|
| 24 |
GROUP_BY_FIELD_RPT |
Character(3) |
VARCHAR2(3) NOT NULL |
Group By Field categorizes worksheet summary lines into various views. Example you can view the results by Business Unit, Bank Account and Currency (as delivered). We also provide generic fields for user defined values.
BAC=Bank Account
BNK=Bank
BU=Business Unit
CUR=Position Currency
GP1=Group By Field 1
GP2=Group By Field 2
GP3=Group By Field 3
GP4=Group By Field 4
GP5=Group By Field 5
GP6=Group By Field 6
GP7=Group By Field 7
SRC=Source Set
VAL=Value Date
|
| 25 |
GROUP_BY_FIELD_VAL |
Character(30) |
VARCHAR2(30) NOT NULL |
Group by Field Value
Prompt Table:
%EDITTABLE
|
| 26 |
SOURCE_SET |
Character(20) |
VARCHAR2(20) NOT NULL |
A field name describing a group od position sources.
Prompt Table:
WRKSHT_SRCESET
|
| 27 |
AMOUNT_OPTN |
Character(3) |
VARCHAR2(3) NOT NULL |
Amount Option determines whether to select POS_IMPCT_ORIG or POS_IMPCT_WEIGHT for Cash Position reports
O=Original
W=Weighted
|
| 28 |
FROM_DT |
Date(10) |
DATE |
From Date
Prompt Table:
FCST_VAL_VW
|
| 29 |
TO_DT |
Date(10) |
DATE |
To Date
Prompt Table:
FCST_VAL_VW
|