APOP_RATE_VW (SQL View)	Index Back
Rate View Rate View

APOP_RATE_VW

(SQL View)

Rate View

SELECT B.OPRID , B.VCHR_SRC , B.APOP_VOUCHER_STYLE , B.APOP_BU_SELECTION , D.FROM_CUR , D.RATE_DIV , D.RATE_MULT , B.DISPLAY_CURRENCY , C.BUSINESS_UNIT FROM PS_APOP_OPR_DEF B LEFT OUTER JOIN PS_APOP_OPR_DEF_BU C ON C.OPRID = B.OPRID AND C.TILE_ID = 'VCHRAPPRL' , PS_RT_RATE_TBL D WHERE B.TILE_ID = 'VCHRAPPRL' AND D.RT_TYPE = B.RT_TYPE AND D.TO_CUR = B.DISPLAY_CURRENCY AND D.EFFDT = ( SELECT MAX(D_ED.EFFDT) FROM PS_RT_RATE_TBL D_ED WHERE D.RT_RATE_INDEX = D_ED.RT_RATE_INDEX AND D.TERM = D_ED.TERM AND D.FROM_CUR = D_ED.FROM_CUR AND D.TO_CUR = D_ED.TO_CUR AND D.RT_TYPE = D_ED.RT_TYPE AND D_ED.EFFDT <= %CurrentDateIn) AND EXISTS ( SELECT E.RT_RATE_INDEX FROM PS_RT_INDEX_TBL E WHERE E.RT_RATE_INDEX = D.RT_RATE_INDEX AND E.DEFAULT_INDEX = 'Y')

# 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 VCHR_SRC Character(4) VARCHAR2(4) NOT NULL Voucher Source

3 APOP_VOUCHER_STYLE Character(4) VARCHAR2(4) NOT NULL Voucher Style
ADJ=Adjustments
AMR=Amortization Voucher
CLBK=Claim Voucher
CORR=Reversal Voucher
JRNL=Journal Voucher
PPAY=Prepaid Voucher
REG=Regular Voucher
RGTR=Register Voucher
SGLP=Single Payment Voucher
THRD=Third Party Voucher

4 APOP_BU_SELECTION Character(1) VARCHAR2(1) NOT NULL BU Selection
N=All
Y=Specific

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

6 RATE_DIV Number(16,8) DECIMAL(15,8) NOT NULL Rate Divisor

7 RATE_MULT Signed Number(17,8) DECIMAL(15,8) NOT NULL Rate Multiplier

8 DISPLAY_CURRENCY Character(3) VARCHAR2(3) NOT NULL Display Currency

9 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

#	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	VCHR_SRC	Character(4)	VARCHAR2(4) NOT NULL	Voucher Source
3	APOP_VOUCHER_STYLE	Character(4)	VARCHAR2(4) NOT NULL	Voucher Style ADJ=Adjustments AMR=Amortization Voucher CLBK=Claim Voucher CORR=Reversal Voucher JRNL=Journal Voucher PPAY=Prepaid Voucher REG=Regular Voucher RGTR=Register Voucher SGLP=Single Payment Voucher THRD=Third Party Voucher
4	APOP_BU_SELECTION	Character(1)	VARCHAR2(1) NOT NULL	BU Selection N=All Y=Specific
5	FROM_CUR	Character(3)	VARCHAR2(3) NOT NULL	From Currency Code
6	RATE_DIV	Number(16,8)	DECIMAL(15,8) NOT NULL	Rate Divisor
7	RATE_MULT	Signed Number(17,8)	DECIMAL(15,8) NOT NULL	Rate Multiplier
8	DISPLAY_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	Display Currency
9	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit