EX_AUTO_RT_DTL(SQL Table) |
Index Back |
|---|---|
Expenses Distance Rate DetailExpenses Distance Rate Detail |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: EX_AUTO_RT_TBL.SETID Prompt Table: SP_SETID_NONVW |
| 2 | EXPENSE_TYPE |
Character(7) | VARCHAR2(7) NOT NULL |
Expense Type
Default Value: EX_AUTO_RT_TBL.EXPENSE_TYPE Prompt Table: EX_TYPES_TBL |
| 3 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL |
Country
Default Value: EX_AUTO_RT_TBL.COUNTRY Prompt Table: COUNTRY_TBL |
| 4 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: EX_AUTO_RT_TBL.EFFDT |
| 5 | TRANSPORT_TYPE |
Character(5) | VARCHAR2(5) NOT NULL |
Transportation Type
Prompt Table: EX_TRNSPT_TYPES |
| 6 | FROM_DISTANCE |
Number(8,0) | INTEGER NOT NULL | From Distance |
| 7 | THRU_DISTANCE | Number(8,0) | INTEGER NOT NULL | Through Distance |
| 8 | DISTANCE_RT | Number(9,4) | DECIMAL(8,4) NOT NULL | Standard Distance Rate |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: EX_AUTO_RT_TBL.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
| 10 | FACTOR_RATE_ADJ | Signed Number(11,4) | DECIMAL(9,4) NOT NULL | Rate Adjustment Factor |