BASE_CURRENCYLANGUAGE_CDEFFDTDefault Value: %date
Default Value: CURRENCY_CD_TBL.DESCR
CURR_BSE_VW_LG(SQL View) |
Index Back |
|---|---|
Currency Code Bse Eff View Lg |
| SELECT A.CURRENCY_CD , B.LANGUAGE_CD , A.EFFDT , B.DESCR , B.DESCRSHORT , A.CUR_SYMBOL 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 | 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 | 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 |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: CURRENCY_CD_TBL.DESCR |
| 6 | CUR_SYMBOL | Character(4) | VARCHAR2(4) NOT NULL | Currency Symbol |