Mileage policy for French legislation

Hi,

French legislation implies to create a mileage policy using different thresholds per vehicule type.

Example for Car :

- For first Threshold T1 (under 5000 KM): rate R1 x d

- For second Threshold T2 (from 5001 to 20000KM) : (rate R2 x d) + additional amount A2

- For third Threshold T3 (up to 20000) : rate R3 x d

Example for Motorcycle :

- For first Threshold T4 (under 2000 KM): rate R4 x d

- For second Threshold T5 (from 2001 to 5000KM) : (rate R5 x d) + additional amount A5

- For third Threshold T6 (up to 5000) : rate R6 x d

But in France, thresholds are not applied in the same way as Oracle does.