SETIDDefault Value: CURR_STEP_TBL.SETID
CURR_STEPDefault Value: CURR_STEP_TBL.CURR_STEP
VERSION_NUMDefault Value: CURR_STEP_TBL.VERSION_NUM
EFFDTDefault Value: CURR_STEP_TBL.EFFDT
TRANS_RULEPrompt Table: %EDITTABLE
Prompt Table: CURR_RULE_VE_VW
CURR_STPRL_TBL(SQL Table) |
Index Back |
|---|---|
MultiCurr Trans Rules in Step |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: CURR_STEP_TBL.SETID |
| 2 | CURR_STEP |
Character(10) | VARCHAR2(10) NOT NULL |
Process Step
Default Value: CURR_STEP_TBL.CURR_STEP |
| 3 | VERSION_NUM |
Number(3,0) | SMALLINT NOT NULL |
Version Number
Default Value: CURR_STEP_TBL.VERSION_NUM |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: CURR_STEP_TBL.EFFDT |
| 5 | TRANS_RULE |
Character(10) | VARCHAR2(10) NOT NULL |
Translation Rule
Prompt Table: %EDITTABLE |
| 6 | VERSION_RULE | Number(3,0) | SMALLINT NOT NULL |
Version Rule
Prompt Table: CURR_RULE_VE_VW |