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 |