Causa | A cliente solicitou que o pagamento da operação de transporte fosse paga da seguinte forma: Quando o equipamento (ônibus, Kombi) rodar até 85 km a Usina pagaria uma diária de R$ 200,00 reais ao prestador, se o equipamento ultrapassar 85 km rodados no dia ele pagaria uma diária de R$ 200,00km mais R$ 1,80 o km excedente. • Até 85km --------> R$ 200,00 • Acima 85 km ---> R$ 200, 00 + R$1,80 o km excedente. |
---|
Solução | - Fazer a configuração da tabela de Evento de Faturamento.
- Fazer a configuração da tabela de Atributo da Operação.
- Fazer a configuração da tabela de Distancias.
- Fazer a configuração da tabela de Preço por Distancia.
A tabela de Preço por Distancia foi configurada da seguinte forma: Distância | Prestador | Descrição | Modelo | Equipamento | Descrição | Tipo | Descrição | Upnivel1 | Descrição | Dt.Validade | Vlr.Unitário | Máxima | Serviços | | | | | Propriedade | | | | | a Pagar | 1 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 200,00000 | 2 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 100,00000 | 3 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 66,66667 | 4 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 50,00000 | 5 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 40,00000 | 6 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 33,33333 | 7 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 28,57143 | 8 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 25,00000 | 9 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 22,22222 | 10 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 20,00000 | 11 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 18,18182 | 12 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 16,66667 | 13 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 15,38462 | 14 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 14,28571 | 15 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 13,33333 | 16 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 12,50000 | 17 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 11,76471 | 18 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 11,11111 | 19 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 10,52632 | 20 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 10,00000 | 21 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 9,52381 | 22 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 9,09091 | 23 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 8,69565 | 24 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 8,33333 | 25 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 8,00000 | 26 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 7,69231 | 27 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 7,40741 | 28 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 7,14286 | 29 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 6,89655 | 30 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 6,66667 | 31 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 6,45161 | 32 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 6,25000 | 33 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 6,06061 | 34 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 5,88235 | 35 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 5,71429 | 36 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 5,55556 | 37 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 5,40541 | 38 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 5,26316 | 39 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 5,12821 | 40 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 5,00000 | 41 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 4,87805 | 42 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 4,76190 | 43 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 4,65116 | 44 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 4,54545 | 45 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 4,44444 | 46 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 4,34783 | 47 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 4,25532 | 48 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 4,16667 | 49 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 4,08163 | 50 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 4,00000 | 51 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,92157 | 52 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,84615 | 53 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,77358 | 54 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,70370 | 55 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,63636 | 56 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,57143 | 57 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,50877 | 58 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,44828 | 59 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,38983 | 60 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,33333 | 61 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,27869 | 62 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,22581 | 63 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,17460 | 64 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,12500 | 65 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,07692 | 66 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 3,03030 | 67 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,98507 | 68 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,94118 | 69 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,89855 | 70 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,85714 | 71 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,81690 | 72 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,77778 | 73 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,73973 | 74 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,70270 | 75 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,66667 | 76 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,63158 | 77 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,59740 | 78 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,56410 | 79 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,53165 | 80 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,50000 | 81 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,46914 | 82 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,43902 | 83 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,40964 | 84 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,38095 | 85 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,35294 | 86 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,34651 | 87 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,34023 | 88 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,33409 | 89 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,32809 | 90 | 99999999 | | 999 | 99999999 | | 999 | | 99999 | | 01/08/2010 | 2,32222 |
|
---|