EX_AUTO_RT_VW(SQL View) |
Index Back |
|---|---|
Expenses Distance Rate TableExpenses Distance Rate Table for mapping during Upgrades. |
| SELECT A.SETID , A.EXPENSE_TYPE , A.COUNTRY , A.EFFDT , A.EFF_STATUS , A.DISTANCE_TYPE , A.DISTANCE_RT , A.CURRENCY_CD , A.RATE_CALC_TYPE , A.SPLIT_RATE FROM PS_EX_AUTO_RT_TBL A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | EXPENSE_TYPE |
Character(7) | VARCHAR2(7) NOT NULL |
Expense Type
Prompt Table: EX_TYPES_TBL |
| 3 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 6 | DISTANCE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Distance Type
3=Metres K=Kilometers M=Miles |
| 7 | DISTANCE_RT | Number(9,4) | DECIMAL(8,4) NOT NULL | Standard Distance Rate |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table: CURRENCY_CD_TBL |
| 9 | RATE_CALC_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Distance Rate Type
S=Standard Rate V=Varied Rate Default Value: S |
| 10 | SPLIT_RATE | Character(1) | VARCHAR2(1) NOT NULL |
Split Rate
Y/N Table Edit Default Value: N |