SCE_IDSETIDEFFDTDefault Value: %date
FIN=Final
FST=First
INT=Intermediate
M=Translate Within Ledger
R=Currency Revaluation
T=Currency Translation
RTBL_MULSTP_VW(SQL View) |
Index Back |
|---|
| SELECT sce.sce_id , setid , curr_step , version_num , effdt , rownum , step_type FROM PS_CURR_STEP_TBL A , PS_RTBL_SCENARIO sce WHERE A.EFF_STATUS = 'A' AND (a.version_num = 0 AND a.effdt = ( SELECT MAX(a_ed.effdt) FROM PS_CURR_STEP_TBL a_ed WHERE a.setid = a_ed.setid AND a.curr_step = a_ed.curr_step AND a.version_num = a_ed.version_num AND a_ed.EFF_STATUS = 'A' AND a_ed.effdt <= sce.asofdate2) OR a.version_num > 0) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCE_ID |
Character(10) | VARCHAR2(10) NOT NULL | ID |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | CURR_STEP | Character(10) | VARCHAR2(10) NOT NULL | Process Step |
| 4 | VERSION_NUM | Number(3,0) | SMALLINT NOT NULL | Version Number |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | ROW_NUMBER_5 | Number(5,0) | INTEGER NOT NULL | Row Number |
| 7 | STEP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Currency Processing Step Type
FIN=Final FST=First INT=Intermediate M=Translate Within Ledger R=Currency Revaluation T=Currency Translation |