RatebooksHeader shorthands

Header shorthands

If the export method for your ratebook data does not allow descriptive column names, you can use the following shortened names within the header of your ratebooks to make the column names shorter:

These shorthands are case sensitive and must be in lowercase. If you use shorthands, you must use them for all columns in the header—do not combine them with the full column names.

Column nameShorthand
vehicle_idc1
cap_codec2
cap_idc3
makec4
modelc5
derivativec6
model_yearc7
gradec8
co2_combc9
co2_comb_minc10
co2_comb_maxc11
co2_weighted_combc12
co2_weighted_comb_minc13
co2_weighted_comb_maxc14
combined_mpg_wltpc15
combined_mpg_wltp_minc16
combined_mpg_wltp_maxc17
weighted_mpg_wltpc18
weighted_mpg_wltp_minc19
weighted_mpg_wltp_maxc20
bhpc21
bodytypec22
engine_sizec23
fuel_typec24
num_doorsc25
num_seatsc26
p11d_valuec27
transmissionc28
dim_lengthc29
dim_heightc30
dim_widthc31
weightc32
accelerationc33
top_speedc34
ncap_ratingc35
insurance_groupc36
all_electric_rangec37
all_electric_range_minc38
all_electric_range_maxc39
equivalent_all_electric_rangec40
equivalent_all_electric_range_minc41
equivalent_all_electric_range_maxc42
pure_electric_rangec43
pure_electric_range_minc44
pure_electric_range_maxc45
wltp_ec_combc46
wltp_ec_comb_minc47
wltp_ec_comb_maxc48
battery_typec49
battery_capacityc50
max_charge_ratec51
connector_typec52
rde_certification_levelc53
alternative_fuel_qualifyingc54
rate_idc55
term_monthsc56
advance_paymentc57
monthly_paymentsc58
contract_mileage_totalc59
periodic_finance_paymentc60
periodic_service_paymentc61
residual_valuec62
purchase_pricec63
sales_categoryc64
delivery_datec65
vehicle_homologationc66
tag_linec67
rankc68
standard_emissionsc69