TR_CASH_POS_CFG(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 3 | WORKSHEET_ID | Character(20) | VARCHAR2(20) NOT NULL |
Cash Flows Worksheet ID
Prompt Table: WORKSHEET_DEFN |
| 4 | 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 |
| 5 | SOURCE_SET | Character(20) | VARCHAR2(20) NOT NULL |
A field name describing a group od position sources.
Prompt Table: SOURCE_SET_DEFN |
| 6 | POSITION_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
The transaction currency of a given position or exposure.
Prompt Table: POS_CURR_VW |
| 7 | TR_AMOUNT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Amount Type
O=Original Amount W=Weighted Amount Default Value: O |
| 8 | 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 |
| 9 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 10 | TR_TERM | Signed Number(6,0) | DECIMAL(5) NOT NULL | "Negotiated length of a deal transaction; also |
| 11 | TR_ROUND_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Rounding Type
BN=Billions K=Thousands MN=Millions |
| 12 | RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
Prompt Table: RT_TYPE_TBL |
| 13 | RT_RATE_INDEX | Character(10) | VARCHAR2(10) NOT NULL |
Market Rate Index
Prompt Table: RT_INDEX_FX_VW |
| 14 | PMT_SRCH_NAME | Character(30) | VARCHAR2(30) NOT NULL | Use Saved Searches |