Hitachi
- Lauren Strang
There are 4 different ratebook mappings required for the Hitachi ratebooks due to the different formats that this funder use. These cover maintained and non-maintained, but also whether there is one rate or two in the csv file. For each mapping you need to add a column with the heading Product and the value should be the product type, matching the value available in Accelerate. For the ratebooks that have two different rates in them, there are a number of columns that are duplicated for the second rate. The headers for these columns need to be appended with 2 so that the header names are unique.The full mapping of these ratebooks are detailed below:
Non-Maintained - Single rate
Column Header | Used | Value |
|---|---|---|
Variant | No | Although this column is not used a value must be present for the row to be detected |
CAP Code | Yes | Alphanumeric - The CAP Code |
Make | No |
|
Model | No |
|
Variant Full Description | No |
|
Model Year | No |
|
Doors | No |
|
Fuel | No |
|
Body | No |
|
Seats | No |
|
Gearbox | No |
|
Gears | No |
|
BHP | No |
|
Eng CC | No |
|
CO2 | No |
|
Com-bined MPG | No |
|
Vehicle List Price | No |
|
Vehicle Total Disc | No |
|
Vehicle OTR Price | No |
|
VRB Bonus | No |
|
P11D Price | No |
|
POL | Yes | Numeric - The finance term |
Mileage | Yes | Numeric - The annual mileage |
Finance Rental | Yes | Numeric - The finance payment amount without any other characters e.g. 123.45 |
Dis-allowed VAT | No |
|
Total inc Disallow VAT | No |
|
Excess Rate | Yes | Numeric - The excess mileage ppm |
Product | Yes | Alphanumeric - The product type description. This must match the value in Accelerate. |
Non-Maintained - Two rates
Column Header | Used | Value |
|---|---|---|
Variant | No | Although this column is not used a value must be present for the row to be detected |
CAP Code | Yes | Alphanumeric - The CAP Code |
Make | No |
|
Model | No |
|
Variant Full Description | No |
|
Model Year | No |
|
Doors | No |
|
Fuel | No |
|
Body | No |
|
Seats | No |
|
Gearbox | No |
|
Gears | No |
|
BHP | No |
|
Eng CC | No |
|
CO2 | No |
|
Com-bined MPG | No |
|
Vehicle List Price | No |
|
Vehicle Total Disc | No |
|
Vehicle OTR Price | No |
|
VRB Bonus | No |
|
P11D Price | No |
|
POL | Yes | Numeric - The finance term for the first rate |
Mileage | Yes | Numeric - The annual mileage for the first rate |
Finance Rental | Yes | Numeric - The finance payment amount for the first rate without any other characters e.g. 123.45 |
Dis-allowed VAT | No |
|
Total inc Disallow VAT | No |
|
Excess Rate | Yes | Numeric - The excess mileage ppm for the first rate |
POL 2 | Yes | Numeric - The finance term for the second rate |
Mileage 2 | Yes | Numeric - The annual mileage for the second rate |
Finance Rental 2 | Yes | Numeric - The finance payment amount for the second rate without any other characters e.g. 123.45 |
Dis-allowed VAT 2 | No |
|
Total inc Disallow VAT 2 | No |
|
Excess Rate 2 | Yes | Numeric - The excess mileage ppm for the second rate |
Product | Yes | Alphanumeric - The product type description. This must match the value in Accelerate. |
Maintained - Single rate
Column Header | Used | Value |
|---|---|---|
Variant | No | Although this column is not used a value must be present for the row to be detected |
CAP Code | Yes | Alphanumeric - The CAP Code |
Make | No |
|
Model | No |
|
Variant Full Description | No |
|
Model Year | No |
|
Doors | No |
|
Fuel | No |
|
Body | No |
|
Seats | No |
|
Gearbox | No |
|
Gears | No |
|
BHP | No |
|
Eng CC | No |
|
CO2 | No |
|
Com-bined MPG | No |
|
Vehicle List Price | No |
|
Vehicle Total Disc | No |
|
Vehicle OTR Price | No |
|
VRB Bonus | No |
|
P11D Price | No |
|
POL | Yes | Numeric - The finance term |
Mileage | Yes | Numeric - The annual mileage |
Finance Rental | Yes | Numeric - The finance payment amount without any other characters e.g. 123.45 |
Service Rental | Yes | Numeric - The maintenance payment amount without any other characters e.g. 123.45 |
Net Rental | No |
|
Dis-allowed VAT | No |
|
Total inc Disallow VAT | No |
|
Excess Rate | Yes | Numeric - The excess mileage ppm |
Product | Yes | Alphanumeric - The product type description. This must match the value in Accelerate. |
Maintained - Two rates
Column Header | Used | Value |
|---|
Column Header | Used | Value |
|---|---|---|
Variant | No | Although this column is not used a value must be present for the row to be detected |
CAP Code | Yes | Alphanumeric - The CAP Code |
Make | No |
|
Model | No |
|
Variant Full Description | No |
|
Model Year | No |
|
Doors | No |
|
Fuel | No |
|
Body | No |
|
Seats | No |
|
Gearbox | No |
|
Gears | No |
|
BHP | No |
|
Eng CC | No |
|
CO2 | No |
|
Com-bined MPG | No |
|
Vehicle List Price | No |
|
Vehicle Total Disc | No |
|
Vehicle OTR Price | No |
|
VRB Bonus | No |
|
P11D Price | No |
|
POL | Yes | Numeric - The finance term for the first rate |
Mileage | Yes | Numeric - The annual mileage for the first rate |
Finance Rental | Yes | Numeric - The finance payment amount for the first rate without any other characters e.g. 123.45 |
Service Rental | Yes | Numeric - The maintenance payment amount for the first rate without any other characters e.g. 123.45 |
Net Rental | No |
|
Dis-allowed VAT | No |
|
Total inc Disallow VAT | No |
|
Excess Rate | Yes | Numeric - The excess mileage ppm for the first rate |
POL 2 | Yes | Numeric - The finance term for the second rate |
Mileage 2 | Yes | Numeric - The annual mileage for the second rate |
Finance Rental 2 | Yes | Numeric - The finance payment amount for the second rate without any other characters e.g. 123.45 |
Service Rental 2 | Yes | Numeric - The maintenance payment amount for the second rate without any other characters e.g. 123.45 |
Net Rental 2 | No |
|
Dis-allowed VAT 2 | No |
|
Total inc Disallow VAT 2 | No |
|
Excess Rate 2 | Yes | Numeric - The excess mileage ppm for the second rate |
Product | Yes | Alphanumeric - The product type description. This must match the value in Accelerate. |