| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SP_SETID_NONVW
|
| 2 |
WORKSHEET_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Cash Flows Worksheet ID
|
| 3 |
LINE_ITEM_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Line Item Type categorizes worksheet line items into cash flow items, non-cash flow items and totals.
1=Cash
2=Non-Cash
|
| 4 |
LINE_NBR |
Number(5,0) |
INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
|
| 5 |
WRKSHEET_LINE_ITEM |
Character(30) |
VARCHAR2(30) NOT NULL |
Cash Forecast Worksheet Line item
|
| 6 |
SOURCE_SET |
Character(20) |
VARCHAR2(20) NOT NULL |
A field name describing a group od position sources.
|
| 7 |
VALUE_DT |
Date(10) |
DATE NOT NULL |
Equivalent to a deal transaction's settlement date.
|
| 8 |
CALC_DT |
Date(10) |
DATE NOT NULL |
The calculation date for a given data set within the Position tools.
|
| 9 |
POSITION_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
The transaction currency of a given position or exposure.
|
| 10 |
GROUP_BY_FIELD |
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=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
WKS=Worksheet
|
| 11 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 12 |
BUSINESS_UNIT_BANK |
Character(5) |
VARCHAR2(5) NOT NULL |
The general ledger business unit associated with a given bank/counterparty.
|
| 13 |
BANK_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
The PeopleSoft tableset ID associated with a given bank/counterparty.
|
| 14 |
BANK_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Bank Code
|
| 15 |
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
|
| 16 |
GRP_BY_FIELD_1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic Group By Field for Cash Forecast summary totals.
|
| 17 |
GRP_BY_FIELD_2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic Group By Field for Cash Forecast summary totals.
|
| 18 |
GRP_BY_FIELD_3 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic Group By Field for Cash Forecast summary totals.
|
| 19 |
GRP_BY_FIELD_4 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic Group By Field for Cash Forecast summary totals.
|
| 20 |
GRP_BY_FIELD_5 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic Group By Field for Cash Forecast summary totals.
|
| 21 |
GRP_BY_FIELD_6 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic Group By Field for Cash Forecast summary totals.
|
| 22 |
GRP_BY_FIELD_7 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic Group By Field for Cash Forecast summary totals.
|
| 23 |
POS_HIST_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
An internal field utilized in order to determine whether the subject cash position worksheet is based up
Y=History-based
Y/N Table Edit
|
| 24 |
DISPLAY_VALUES |
Character(30) |
VARCHAR2(30) NOT NULL |
The concatenated values for the Cash Forecast Summary group by field records 'BAC' and 'BNK'.
BANK_SETID, BANK_CD and BANK_ACCT_KEY when the translate value for group by field is �BAC� .
BANK_SETID and BANK_CD when the translate value for group by field is �BNK�.
|
| 25 |
CALC_TM |
Time(15) |
TIMESTAMP |
The calculation time for a given data set within the Position tools.
|
| 26 |
POS_IMPCT_ORIG |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Represents the calculated monetary value for a specific position tree node; the result
|
| 27 |
POS_IMPCT_WEIGHT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Pos Impact Weight Amt Value
|
| 28 |
BNK_ACCT_DFLT_CURR |
Character(1) |
VARCHAR2(1) NOT NULL |
A flag that indicates whether or not (Y or N) the position currency specified on the Cash Forecast summary data is the bank account default currency. This only applies to bank account summary rows - GROUP_BY_FIELD of 'BAC'.
Default Value: N
|
| 29 |
POS_DEF_SRC_SET |
Character(1) |
VARCHAR2(1) NOT NULL |
a checkbox that identifies the default position source set.
Default Value: N
|
| 30 |
LOCK_VALUE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
A field which will Lock/Unlock a value on the CPW.
Default Value: N
|
| 31 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 32 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 33 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|