BASE_CURRENCYEFFDTDefault Value: %date
Default Value: CURRENCY_CD_TBL.DESCR
Prompt Table: COUNTRY_TBL
CURR_BSE_EFF_VW(SQL View) |
Index Back |
|---|---|
Currency Code Bse Eff View |
| SELECT A.CURRENCY_CD , A.EFFDT , A.DESCR , A.DESCRSHORT , A.COUNTRY , A.CUR_SYMBOL , A.DECIMAL_POSITIONS , A.SCALE_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 | 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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: CURRENCY_CD_TBL.DESCR |
| 5 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 6 | CUR_SYMBOL | Character(4) | VARCHAR2(4) NOT NULL | Currency Symbol |
| 7 | DECIMAL_POSITIONS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 8 | SCALE_POSITIONS | Number(1,0) | SMALLINT NOT NULL | Scale Positions |