TRANSACT_CURRENCYPrompt Table: CURRENCY_CD_TBL
TO_CURPrompt Table: CURRENCY_CD_TBL
Default Value: 4
Default Value: 1
D=Direct
I=Indirect
CURR_QUOTE_VW0(SQL View) |
Index Back |
|---|---|
Currency Quotation (TR Deals)Currency Quotation Basis for Treasury Deal Capture (Top & Leg 1 of "Triangle") - Used by related display |
| select from_cur ,to_cur ,rate_decimals ,quote_units ,rate_direct from ps_curr_quote_tbl |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRANSACT_CURRENCY |
Character(3) | VARCHAR2(3) NOT NULL |
"The nominal
Prompt Table: CURRENCY_CD_TBL |
| 2 | TO_CUR |
Character(3) | VARCHAR2(3) NOT NULL |
To Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 3 | RATE_DECIMALS | Number(1,0) | SMALLINT NOT NULL |
Rate Decimal Positions
Default Value: 4 |
| 4 | QUOTE_UNITS | Number(4,0) | SMALLINT NOT NULL |
Quote Units
Default Value: 1 |
| 5 | RATE_DIRECT | Character(1) | VARCHAR2(1) NOT NULL |
Rate Quotation Basis
D=Direct I=Indirect |