RT_DEF_DFLT_VW

(SQL View)
 Index Back

Market Rate Definition Default

Market Rate Definition Default

SELECT a.from_cur , a.to_cur , a.max_variance , a.error_type , a.int_basis FROM ps_rt_rate_def_tbl a , ps_rt_index_tbl b WHERE a.rt_rate_index = b.rt_rate_index AND a.term = 0 AND b.default_index = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code

Prompt Table: CURRENCY_CD_TBL

2 TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code

Prompt Table: CURRENCY_CD_TBL

3 MAX_VARIANCE Number(6,2) DECIMAL(5,2) NOT NULL Maximum Variance
4 ERROR_TYPE Character(3) VARCHAR2(3) NOT NULL Error Type
ERR=Stop
NON=None
WAR=Warning

Default Value: WAR

5 INT_BASIS Character(2) VARCHAR2(2) NOT NULL Day Count Basis
30=30/360
3E=30E/360
A0=Actual/360
A5=Actual/365
AA=Actual/Actual