CURR_QUOTE_VW1 (SQL View)	Index Back
Currency Quotation (TR Deals) Currency Quotation Basis for Treasury Deal Capture (Leg 1 of "Triangle") Note reversed key fields

CURR_QUOTE_VW1

(SQL View)

Currency Quotation (TR Deals)

Currency Quotation Basis for Treasury Deal Capture (Leg 1 of "Triangle") Note reversed key fields

select to_cur ,from_cur ,rate_decimals ,quote_units ,rate_direct from ps_curr_quote_tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ANCHOR_CURRENCY Character(3) VARCHAR2(3) NOT NULL The base currency of the business unit that generates a given deal transaction.

2 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ANCHOR_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	The base currency of the business unit that generates a given deal transaction.
2	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
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