PV_MOB_DEC_VW (SQL View)	Index Back
Currency decimal positions.

PV_MOB_DEC_VW

(SQL View)

Currency decimal positions.

SELECT A.CURRENCY_CD , A.DECIMAL_POSITIONS FROM PS_CURRENCY_CD_TBL A WHERE A.EFFDT = ( SELECT MAX(I.EFFDT) FROM PS_CURRENCY_CD_TBL I WHERE I.CURRENCY_CD = A.CURRENCY_CD AND I.EFFDT <= %CurrentDateIn AND I.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

2 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	Currency Code
2	DECIMAL_POSITIONS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions