| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PMT_SRCH_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Use Saved Searches
|
| 2 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 3 |
WORKSHEET_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Cash Flows Worksheet ID
|
| 4 |
GROUP_BY_FIELD_SRC |
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
POS=Position Currency
SRC=Source Set
TIM=Time set
TRC=Transaction Currency
|
| 5 |
POSITION_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
The transaction currency of a given position or exposure.
Prompt Table:
POS_CURR_VW
|
| 6 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 7 |
SOURCE_SET |
Character(20) |
VARCHAR2(20) NOT NULL |
A field name describing a group od position sources.
Prompt Table:
WRKSHT_SRCESET
|
| 8 |
SELECT_DT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Type
1=Specific Dates
2=Relative Dates
|
| 9 |
POS_SHIFT_DAYS |
Signed Number(4,0) |
DECIMAL(3) NOT NULL |
Represents the number of days by which a cash position worksheet may be copied forward.
|
| 10 |
VALUE_DT |
Date(10) |
DATE |
Equivalent to a deal transaction's settlement date.
|
| 11 |
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
|
| 12 |
BANK_ACCT_DEF_CUR |
Character(3) |
VARCHAR2(3) NOT NULL |
Bank Account Currency
BNK=Bank Account Default Currency
POS=Position Currency
|
| 13 |
BANKACC_GRP_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether to show the Cash Position for a Business Unit Group in the report.
|
| 14 |
CASHSWEEP_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
Default Value: N
|
| 15 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
Prompt Table:
SP_SETID_NONVW
|
| 16 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
Prompt Table:
BANK_CD_EXT_VW2
|
| 17 |
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
|
| 18 |
BU_GRP_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Determines whether to show the Cash Position for a Business Unit Group in the report.
|
| 19 |
SEARCH_BU_BY |
Character(3) |
VARCHAR2(3) NOT NULL |
Fetch the business unit information either by entering the BU group or by a specific BU.
BU=Business Unit
GBU=Group Business Unit
|
| 20 |
BUSINESS_UNIT_BANK |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit associated with a given bank/counterparty.
Prompt Table:
SP_BU_FS_NONVW
|
| 21 |
BUS_UNIT_GROUP_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
A unique key identifier that represents a grouping of general ledger business units.
|
| 22 |
BUSINESS_UNIT_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Group Business Unit
|
| 23 |
TIME_SET |
Character(10) |
VARCHAR2(10) NOT NULL |
A unique key identifier that represents a time horizon definition dataset.
Prompt Table:
POS_T_SPAN_TBL
|
| 24 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 25 |
TO_DATE |
Date(10) |
DATE |
To Date
|
| 26 |
VARIANCE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Variance
Y/N Table Edit
|
| 27 |
VARIANCE_OPTIONS |
Character(30) |
VARCHAR2(30) NOT NULL |
Variance Description
Prompt Table:
WRKSHEET_VAR_VW
|