Expense Mileage Data Import
The expense mileage data integration loader uses only a single set of header columns.
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 |