Overview
The expense mileage data import process reads files from the ./Incoming/ExpenseMileageData/ in the SFTP. These files will be moved to the archive folder located at ./Incoming/Archive/ExpenseMileageData/ before being processed in Alpha-Numeric order.
Expense mileage data columns
| Column Name |
Description |
Req'd |
Unique |
Type |
Allowable Values |
| Country |
Country |
No |
No |
string(100) |
any |
| Region |
Region |
No |
No |
string(255) |
any |
| Vehicle Type |
Vehicle Type |
No |
No |
string(255) |
any |
| Effective Date |
Effective Date |
No |
No |
datetime |
any |
| Currency |
Currency |
No |
No |
string(100) |
any |
| Base Rate |
Base Rate |
No |
No |
decimal(32,4) |
any |
| Rate 2 |
Rate 2 |
No |
No |
decimal(32,4) |
any |
| Rate 3 |
Rate 3 |
No |
No |
decimal(32,4) |
any |
| Rate 4 |
Rate 4 |
No |
No |
decimal(32,4) |
any |
| Rate 5 |
Rate 5 |
No |
No |
decimal(32,4) |
any |
| Passenger Rate |
Passenger Rate |
No |
No |
decimal(32,4) |
any |
| Expiry Date |
Expiry Date |
No |
No |
datetime |
any |
