FT_RUN_IDCURRENCY_CDFT_SAL_CUR_VW(SQL View) |
Index Back |
|---|---|
View used for Fusion Coex CWBView used for Fusion Coex CWB |
| SELECT DISTINCT STG.FT_RUN_ID , STG.CURRENCY_CD , CUR.DESCR FROM %Table(FT_SALARY_STG) STG , %Table(CURRENCY_CD_TBL) CUR WHERE STG.CURRENCY_CD = CUR.CURRENCY_CD AND %EffdtCheck(CURRENCY_CD_TBL CUR2, CUR, %CurrentDateIn) AND CUR.EFF_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FT_RUN_ID |
Number(18,0) | DECIMAL(18) NOT NULL | LEGAL_ENTITY_ID |
| 2 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |