Árvore de páginas

Produto

Datasul

Versões

 

Avaliação

1

Sintoma

Fazer o pagamento de operações de transporte quando pagas juntamente por diária e km.

Environment

Unspecified

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

 
  1. Fazer a configuração da tabela de Evento de Faturamento.
  2. Fazer a configuração da tabela de Atributo da Operação.
  3. Fazer a configuração da tabela de Distancias.
  4. 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

 

 

Observações