TL_SRCH_CRCD_VW

(SQL View)
Index Back

Currency Cd Rec for Srch Index


SELECT B.CURRENCY_CD ,'1' FROM PS_CURRENCY_CD_TBL B UNION SELECT B.CURRENCY_CD %Concat ' (Global)' ,'0' FROM PS_CURRENCY_CD_TBL B

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 TL_CURRENCY_CD Character(15) VARCHAR2(15) NOT NULL Currency Code
2 TL_CUR_ROW Character(1) VARCHAR2(1) NOT NULL Current Row