RBD_CURRENCY_VW (SQL View)	Index Back
Dashboard Currency Code This is the record for the Dashboard Currency Code view.

RBD_CURRENCY_VW

(SQL View)

Dashboard Currency Code

This is the record for the Dashboard Currency Code view.

SELECT A.CURRENCY_CD ,A.DESCR ,A.DECIMAL_POSITIONS FROM %Table(CURRENCY_CD_TBL) A WHERE %EffdtCheck(CURRENCY_CD_TBL B, A, %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 DECIMAL_POSITIONS Number(2,0) SMALLINT NOT NULL Decimal Positions

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions