Custom Mappings
- Lauren Strang
These mappings have been provided to meet different customers needs, but are available to everyone.
Column Header | Used | Value |
|---|---|---|
MANUFACTURER | No | Although this column is not used a value must be present. |
MODEL | No |
|
DERIVATIVE | No |
|
UPFRONT | Yes | Numeric - The number of initial rentals paid upfront for the first rate. |
PAYMENTS | Yes | Numeric - The number of payments for the first rate (finance term minus 1) |
TYPE | No |
|
MILEAGE | Yes | Numeric - The annual mileage for the first rate. |
PRICE | Yes | Numeric - The finance payment amount for the first rate without any other characters e.g. 123.45 |
UPFRONT_2 | Yes | Numeric - The number of initial rentals paid upfront for the second rate |
PAYMENTS_2 | Yes | Numeric - The number of payments for the second rate (finance term minus 1) |
TYPE_2 | No |
|
MILEAGE_2 | Yes | Numeric - The annual mileage for the second rate |
PRICE_2 | Yes | Numeric - The finance payment amount for the second rate without any other characters e.g. 123.45 |
CAPCODE | Yes | Alphanumeric - The CAP Code |
CAPID | No |
|
PRODUCT | Yes | Alphanumeric - The product type description. This must match the value in Accelerate. |
Column Header | Used | Value |
|---|
Column Header | Used | Value |
|---|---|---|
Code | No | Although this column is not used a value must be present. |
Manufacturer | No |
|
Model | No |
|
Variant | No |
|
Payment Plan | Yes | Alphanumeric - Used to determine the number of months initial payment. E.g. Spread Rentals - Three Initial, gives 3 months initial payment or Spread Rentals - Six Initial, gives 6 months initial payment |
MY | No |
|
Term | 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 |
Cap Code | Yes | Alphanumeric - The CAP Code |
Product | Yes | Alphanumeric - The product type description. This must match the value in Accelerate. |