Lex Autolease
- Lauren Strang
There are two different mappings available for Lex Autolease as both appear to be in use. No changes to the csv files are needed for either mapping, but you need to ensure that the headers are correct. We've seen some ratebooks from Lex Autolease with the correct content but with slightly different column headings.
The complete mapping for the simplified Lex Autolease mapping is:
Note the space at the start of all column headings except Cap Code.
Column Header | Used | Value |
|---|---|---|
Cap Code | Yes | Alphanumeric - The CAP Code |
Manufacturer | No |
|
Model Name | No |
|
Variant | No |
|
Commercial | No |
|
CO2 | No |
|
P11D | No |
|
Term | Yes | Numeric - The finance term |
Mileage | Yes | Numeric - The annual mileage |
Rental | No |
|
Payment Plan | Yes | Alphanumeric - Used to determine the number of months initial payment. E.g. Spread Rentals with 3 down, gives 3 months initial payment. |
Contract Type | Yes | Alphanumeric - The short description for the product e.g. CH |
Fuel Type Description | No |
|
Creation Date | No |
|
David Henley Code | No |
|
Model Year | No |
|
Euro 4 | No |
|
Basic List Price | No |
|
Ex Works Delivery | No |
|
Registration Fee | No |
|
RFL 1 Year | No |
|
Extras Count | No |
|
Lease 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. This is also used to determine the maintenance flag. If non-maintained then this must be 0. |
Non Recoverable Vat | No |
|
Excess Mileage | Yes | Numeric - The excess mileage ppm |
Fuel Eco Combined | No |
|
Body Style | No |
|
Discount | No |
|
Sales Code | No |
|
Is Preferred Option | No |
|
The complete mapping for the extended Lex Autolease mapping is:
Column Header | Used | Value |
|---|---|---|
CAP_Code | Yes | Alphanumeric - The CAP Code |
Manufacturer | No |
|
Model_Name | No |
|
Variant | No |
|
Commercial | No |
|
CO2_g_per_km | No |
|
P11D | No |
|
Term | Yes | Numeric - The finance term |
Mileage | Yes | Numeric - The annual mileage |
Rental | No |
|
Payment_Plan | Yes | Alphanumeric - Used to determine the number of months initial payment. E.g. Spread Rentals with 3 down, gives 3 months initial payment. |
Contract_Type | Yes | Alphanumeric - The short description for the product e.g. CH |
Fuel_Type | No |
|
Creation_Date | No |
|
David_Henley_Code | No |
|
Model_Year | No |
|
Euro_4 | No |
|
Basic_List_Price | No |
|
Ex_Works_Delivery | No |
|
Registration_Fee | No |
|
RFL_1_Year | No |
|
Extras_Count | No |
|
Lease_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. This is also used to determine the maintenance flag. If non-maintained then this must be 0. |
Non_Recoverable_VAT | No |
|
Excess_Mileage | Yes | Numeric - The total excess mileage ppm |
Fuel_Eco_Combined | No |
|
Body_Style | No |
|
Discount | No |
|
Sales_Code | No |
|
Is_Preferred_Option | No |
|
Whole_Life_Cost | No |
|
Estimated_Sale_Value | No |
|
Finance_Emc_Ppm | No | Numeric - The finance excess mileage ppm |
Service_Emc_Ppm | No | Numeric - The maintenance excess mileage ppm |
Network
No changes are required to the Network csv file.The full mapping for Network is:
Column Header | Used | Value |
|---|
Column Header | Used | Value |
|---|---|---|
CAP_Id | Yes | Numeric - The CAP ID |
CAP_Code | No |
|
VehicleType | Yes | Alphanumeric - The product type description. This must match the value in Accelerate. |
Manufacturer | No |
|
Range | No |
|
Model | No |
|
Variant | No |
|
ProductionStatus | No |
|
P11D | No |
|
CO2 | No |
|
BasicListPrice | No |
|
Product | Yes | Alphanumeric - The product type description. This must match the value in Accelerate. |
Term | Yes | Numeric - The finance term |
Mileage | Yes | Numeric - The annual mileage |
Advance | Yes | Numeric - The number of months rental upfront. |
Deposit | No |
|
DealerCode | No |
|
FinanceRental | Yes | Numeric - The finance payment amount without any other characters e.g. 123.45 |
ServiceRental | 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. |
EffectiveRentalValue | No |
|
Balloon | Yes | Numeric - The final payment amount without any other characters |
ModelYear | Yes | Numeric - The model year |
BodyStyle | No |
|
Doors | No |
|
Seats | No |
|
FuelType | No |
|
TransmissionType | No |
|
MPG | No |
|
InsuranceGroup50 | No |
|
InsuranceGroup20 | No |
|