APS_RT_TYPE_VW (SQL View)	Index Back
APS Integ Rate Type View

APS_RT_TYPE_VW

(SQL View)

APS Integ Rate Type View

SELECT DISTINCT A.TO_CUR , A.RT_TYPE FROM PS_RT_RATE_TBL A , PS_RT_INDEX_TBL B WHERE %EffdtCheck(RT_RATE_TBL, A, %CurrentDateIn) AND A.RT_RATE_INDEX = B.RT_RATE_INDEX AND B.DEFAULT_INDEX = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BASE_CURRENCY Character(3) VARCHAR2(3) NOT NULL "Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "

2 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BASE_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
2	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.