PYCYCL_DAT_VWLG(SQL View) |
Index Back |
---|---|
Currency Code Effective Vw Lg |
SELECT A.CURRENCY_CD , B.LANGUAGE_CD , A.EFFDT , B.DESCR FROM PS_CURRENCY_CD_TBL A , PS_CURRCD_TBL_LANG B 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') AND A.CURRENCY_CD = B.CURRENCY_CD AND A.EFFDT = B.EFFDT |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | CURRENCY_PYMNT | Character(3) | VARCHAR2(3) NOT NULL | Payment Currency |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | EFFDT | Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |