Alphabet
- Lauren Strang
You need to add an extra column at the end of the existing columns. The header is Product and the value should be the product name e.g. “Contract Hire”. This text must match the product type description in Accelerate, so please double check this.
The complete mapping for the Alphabet ratebook is:
Column Header | Used | Value |
|---|---|---|
Term | Yes | Numeric - The finance term |
Mileage | Yes | Numeric - The annual mileage |
Initial Payments | Yes | Numeric - The number of initial rentals |
Manufacturer | No |
|
Model | No |
|
CAP Code | Yes | Alphanumeric - The CAP Code |
| No |
|
P11D Value | No |
|
Finance | Yes | Numeric - The finance payment amount without any other characters e.g. 123.45 |
Services | Yes | Numeric - The maintenance payment amount without any other characters. This is also used to determine the maintenance flag. If non-maintained then this must be 0. |
Insurance | No |
|
Total | No |
|
Effective Rental | No |
|
Fuel/Energy | No |
|
Effective Rental | No |
|
XS | Yes | Numeric - The excess mileage ppm |
Product | Yes | Alphanumeric - The product type description. This must match the value in Accelerate. |