BI_RATE_SRC_VW

(SQL View)
 Index Back

Payment Method Prompt view

Mass Update - Payment Method prompt view for Error 0115

SELECT DISTINCT a.fieldvalue , a.xlatlongname FROM PSXLATITEM a WHERE a.fieldname = 'CUR_RT_SOURCE' AND a.eff_status = 'A' AND a.effdt = ( SELECT MAX(b.effdt) FROM PSXLATITEM b WHERE b.fieldname = a.fieldname AND b.eff_status = a.eff_status AND b.effdt <=%CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CUR_RT_SOURCE Character(1) VARCHAR2(1) NOT NULL Exchange Rate Source
T=Use Exchange Rate Tables
U=User Specified
2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name