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 name	Shorthand
`vehicle_id`	`c1`
`cap_code`	`c2`
`cap_id`	`c3`
`make`	`c4`
`model`	`c5`
`derivative`	`c6`
`model_year`	`c7`
`grade`	`c8`
`co2_comb`	`c9`
`co2_comb_min`	`c10`
`co2_comb_max`	`c11`
`co2_weighted_comb`	`c12`
`co2_weighted_comb_min`	`c13`
`co2_weighted_comb_max`	`c14`
`combined_mpg_wltp`	`c15`
`combined_mpg_wltp_min`	`c16`
`combined_mpg_wltp_max`	`c17`
`weighted_mpg_wltp`	`c18`
`weighted_mpg_wltp_min`	`c19`
`weighted_mpg_wltp_max`	`c20`
`bhp`	`c21`
`bodytype`	`c22`
`engine_size`	`c23`
`fuel_type`	`c24`
`num_doors`	`c25`
`num_seats`	`c26`
`p11d_value`	`c27`
`transmission`	`c28`
`dim_length`	`c29`
`dim_height`	`c30`
`dim_width`	`c31`
`weight`	`c32`
`acceleration`	`c33`
`top_speed`	`c34`
`ncap_rating`	`c35`
`insurance_group`	`c36`
`all_electric_range`	`c37`
`all_electric_range_min`	`c38`
`all_electric_range_max`	`c39`
`equivalent_all_electric_range`	`c40`
`equivalent_all_electric_range_min`	`c41`
`equivalent_all_electric_range_max`	`c42`
`pure_electric_range`	`c43`
`pure_electric_range_min`	`c44`
`pure_electric_range_max`	`c45`
`wltp_ec_comb`	`c46`
`wltp_ec_comb_min`	`c47`
`wltp_ec_comb_max`	`c48`
`battery_type`	`c49`
`battery_capacity`	`c50`
`max_charge_rate`	`c51`
`connector_type`	`c52`
`rde_certification_level`	`c53`
`alternative_fuel_qualifying`	`c54`
`rate_id`	`c55`
`term_months`	`c56`
`advance_payment`	`c57`
`monthly_payments`	`c58`
`contract_mileage_total`	`c59`
`periodic_finance_payment`	`c60`
`periodic_service_payment`	`c61`
`residual_value`	`c62`
`purchase_price`	`c63`
`sales_category`	`c64`
`delivery_date`	`c65`
`vehicle_homologation`	`c66`
`tag_line`	`c67`
`rank`	`c68`
`standard_emissions`	`c69`

Import channels CAP fuel mappings