IMPLEMENTACION

TABLA DESPACHO
Id despacho cliente fecha fecha llegada Placa conductor Vehiculo destino costo
1
1
ene-09-2012
ene-11-2012
psk-321
1
jac
6
             550,000.00
2
1
ene-09-2012
ene-11-2012
tpu-142
2
mitsubishi
4
             450,000.00
3
2
ene-09-2012
ene-11-2012
nwj-432
3
chevrolet
2
             650,000.00
4
3
ene-09-2012
ene-10-2012
sdk-300
4
chevrolet
7
             300,000.00
5
4
ene-09-2012
ene-10-2012
sdk-420
5
chevrolet
8
             300,000.00
6
5
ene-09-2012
ene-11-2012
nca-214
6
chevrolet
2
             650,000.00
7
6
ene-09-2012
ene-11-2012
psk-147
7
international
6
             550,000.00
8
7
ene-09-2012
ene-13-2012
psk-437
8
kenworth
5
          3,100,000.00
9
8
ene-09-2012
ene-10-2012
sdk-341
9
nissan
10
             350,000.00
10
3
ene-12-2012
ene-14-2012
psk-321
1
jac
7
             300,000.00
11
4
ene-12-2012
ene-14-2012
tpu-142
2
mitsubishi
6
             550,000.00
12
5
ene-12-2012
ene-14-2012
nwj-432
3
chevrolet
3
             650,000.00
13
6
ene-11-2012
ene-12-2012
sdk-300
4
chevrolet
7
             300,000.00
14
8
ene-11-2012
ene-12-2012
sdk-420
5
chevrolet
8
             300,000.00
15
8
ene-12-2012
ene-14-2012
nca-214
6
chevrolet
1
             600,000.00
16
1
ene-12-2012
ene-14-2012
psk-147
7
international
2
             650,000.00
17
1
ene-14-2012
ene-16-2012
psk-437
8
kenworth
11
          1,300,000.00
18
2
ene-11-2012
ene-12-2012
sdk-341
9
nissan
17
                70,000.00
19
2
ene-16-2012
ene-18-2012
psk-321
1
jac
14
             450,000.00
20
3
ene-16-2012
ene-17-2012
tpu-142
2
mitsubishi
7
             300,000.00
21
3
ene-16-2012
ene-18-2012
nwj-432
3
chevrolet
6
             550,000.00
22
4
ene-13-2012
ene-14-2012
sdk-300
4
chevrolet
7
             300,000.00
23
4
ene-13-2012
ene-14-2012
sdk-420
5
chevrolet
8
             300,000.00
24
5
ene-16-2012
ene-18-2012
nca-214
6
chevrolet
6
             550,000.00
25
5
ene-16-2012
ene-17-2012
psk-147
7
international
7
             300,000.00
26
6
ene-16-2012
ene-18-2012
psk-437
8
kenworth
17
                70,000.00
27
6
ene-13-2012
ene-14-2012
sdk-341
9
nissan
17
                70,000.00
28
7
ene-19-2012
ene-21-2012
psk-321
1
jac
7
             300,000.00
29
7
ene-18-2012
ene-21-2012
tpu-142
2
mitsubishi
4
             450,000.00
30
8
ene-19-2012
ene-21-2012
nwj-432
3
chevrolet
2
             650,000.00
31
8
ene-16-2012
ene-18-2012
sdk-300
4
chevrolet
1
             600,000.00
32
1
ene-16-2012
ene-18-2012
sdk-420
5
chevrolet
1
             600,000.00
33
2
ene-19-2012
ene-20-2012
nca-214
6
chevrolet
8
             300,000.00
34
3
ene-19-2012
ene-21-2012
psk-147
7
international
6
             550,000.00
35
4
ene-19-2012
ene-23-2012
psk-437
8
kenworth
5
          3,100,000.00
36
5
ene-16-2012
ene-17-2012
sdk-341
9
nissan
17
                70,000.00
37
6
ene-23-2012
ene-25-2012
psk-321
1
jac
17
                70,000.00
38
7
ene-23-2012
ene-25-2012
tpu-142
2
mitsubishi
17
                70,000.00
39
8
ene-23-2012
ene-25-2012
nwj-432
3
chevrolet
4
             450,000.00
40
8
ene-19-2012
ene-21-2012
sdk-300
4
chevrolet
16
             450,000.00
41
7
ene-19-2012
ene-20-2012
sdk-420
5
chevrolet
17
                70,000.00
42
6
ene-21-2012
ene-22-2012
nca-214
6
chevrolet
7
             300,000.00
43
5
ene-23-2012
ene-25-2012
psk-147
7
international
1
             600,000.00
44
4
ene-24-2012
ene-27-2012
psk-437
8
kenworth
18
          2,500,000.00
45
3
ene-18-2012
ene-19-2012
sdk-341
9
nissan
17
                70,000.00
46
2
ene-26-2012
ene-28-2012
psk-321
1
jac
9
             400,000.00
47
1
ene-26-2012
ene-28-2012
tpu-142
2
mitsubishi
6
             550,000.00
48
1
ene-26-2012
ene-28-2012
nwj-432
3
chevrolet
2
             650,000.00
49
3
ene-23-2012
ene-25-2012
sdk-300
4
chevrolet
1
             600,000.00
50
5
ene-21-2012
ene-23-2012
sdk-420
5
chevrolet
7
             300,000.00
51
7
ene-23-2012
ene-25-2012
nca-214
6
chevrolet
4
             450,000.00
52
2
ene-26-2012
ene-28-2012
psk-147
7
international
3
             650,000.00
53
4
ene-28-2012
feb-01-2012
psk-437
8
kenworth
5
          3,100,000.00
54
6
ene-20-2012
ene-21-2012
sdk-341
9
nissan
17
                70,000.00
55
8
ene-30-2012
feb-01-2012
psk-321
1
jac
6
             550,000.00
56
1
ene-30-2012
ene-31-2012
tpu-142
2
mitsubishi
17
                70,000.00
57
1
ene-30-2012
feb-01-2012
nwj-432
3
chevrolet
6
             550,000.00
58
2
ene-26-2012
ene-28-2012
sdk-300
4
chevrolet
10
             350,000.00
59
2
ene-24-2012
ene-27-2012
sdk-420
5
chevrolet
1
             600,000.00
60
3
ene-26-2012
ene-28-2012
nca-214
6
chevrolet
2
             650,000.00
61
3
ene-30-2012
ene-31-2012
psk-147
7
international
7
             300,000.00
62
4
ene-23-2012
ene-25-2012
sdk-341
9
nissan
9
             400,000.00
63
4
ene-30-2012
ene-31-2012
sdk-300
4
chevrolet
7
             300,000.00
64
5
ene-28-2012
ene-31-2012
sdk-420
5
chevrolet
6
             550,000.00
65
5
ene-30-2012
ene-31-2012
nca-214
6
chevrolet
8
             300,000.00
66
6
ene-26-2012
ene-28-2012
sdk-341
9
nissan
10
             350,000.00
67
6
ene-30-2012
ene-31-2012
sdk-341
9
nissan
7
             300,000.00
68
7
feb-09-2012
feb-11-2012
psk-321
1
jac
4
             450,000.00
69
7
feb-09-2012
feb-11-2012
tpu-142
2
mitsubishi
2
             650,000.00
70
8
feb-09-2012
feb-11-2012
nwj-432
3
chevrolet
3
             650,000.00
71
8
feb-09-2012
feb-10-2012
sdk-300
4
chevrolet
7
             300,000.00
72
1
feb-09-2012
feb-10-2012
sdk-420
5
chevrolet
9
             400,000.00
73
3
feb-09-2012
feb-11-2012
nca-214
6
chevrolet
6
             550,000.00
74
5
feb-09-2012
feb-11-2012
psk-147
7
international
6
             550,000.00
75
7
feb-09-2012
feb-13-2012
psk-437
8
kenworth
5
          3,100,000.00
76
1
feb-09-2012
feb-10-2012
sdk-341
9
nissan
17
                70,000.00
77
2
feb-13-2012
feb-15-2012
psk-321
1
jac
6
             550,000.00
78
3
feb-13-2012
feb-14-2012
tpu-142
2
mitsubishi
7
             300,000.00
79
4
feb-13-2012
feb-15-2012
nwj-432
3
chevrolet
1
             600,000.00
80
5
feb-11-2012
feb-13-2012
sdk-300
4
chevrolet
8
             300,000.00
81
6
feb-11-2012
feb-13-2012
sdk-420
5
chevrolet
9
             400,000.00
82
7
feb-13-2012
feb-15-2012
nca-214
6
chevrolet
2
             650,000.00
83
8
feb-13-2012
feb-14-2012
psk-147
7
international
7
             300,000.00
84
2
feb-14-2012
feb-16-2012
psk-437
8
kenworth
11
          1,300,000.00
85
4
feb-11-2012
feb-13-2012
sdk-341
9
nissan
17
                70,000.00
86
6
feb-16-2012
feb-18-2012
psk-321
1
jac
14
             450,000.00
87
8
feb-15-2012
feb-17-2012
tpu-142
2
mitsubishi
6
             550,000.00
88
8
feb-16-2012
feb-18-2012
nwj-432
3
chevrolet
3
             650,000.00
89
7
feb-14-2012
feb-15-2012
sdk-300
4
chevrolet
7
             300,000.00
90
6
feb-14-2012
feb-15-2012
sdk-420
5
chevrolet
8
             300,000.00
91
5
feb-16-2012
feb-18-2012
nca-214
6
chevrolet
6
             550,000.00
92
4
feb-15-2012
feb-17-2012
psk-147
7
international
2
             650,000.00
93
3
feb-17-2012
feb-20-2012
psk-437
8
kenworth
5
          3,100,000.00
94
2
feb-14-2012
feb-16-2012
sdk-341
9
nissan
10
             350,000.00
95
1
feb-20-2012
feb-22-2012
psk-321
1
jac
4
             450,000.00
96
2
feb-18-2012
feb-20-2012
tpu-142
2
mitsubishi
1
             600,000.00
97
2
feb-20-2012
feb-22-2012
nwj-432
3
chevrolet
17
                70,000.00
98
4
feb-16-2012
feb-18-2012
sdk-300
4
chevrolet
6
             550,000.00
99
4
feb-16-2012
feb-17-2012
sdk-420
5
chevrolet
9
             400,000.00
100
6
feb-20-2012
feb-22-2012
nca-214
6
chevrolet
3
             650,000.00
101
6
feb-18-2012
feb-20-2012
psk-147
7
international
6
             550,000.00
102
8
feb-21-2012
feb-24-2012
psk-437
8
kenworth
15
          2,700,000.00
103
8
feb-17-2012
feb-18-2012
sdk-341
9
nissan
10
             350,000.00
104
8
feb-23-2012
feb-25-2012
psk-321
1
jac
17
                70,000.00
105
7
feb-21-2012
feb-22-2012
tpu-142
2
mitsubishi
17
                70,000.00
106
6
feb-23-2012
feb-25-2012
nwj-432
3
chevrolet
3
             650,000.00
107
5
feb-20-2012
feb-22-2012
sdk-300
4
chevrolet
4
             450,000.00
108
4
feb-18-2012
feb-20-2012
sdk-420
5
chevrolet
7
             300,000.00
109
3
feb-23-2012
feb-25-2012
nca-214
6
chevrolet
6
             550,000.00
110
2
feb-21-2012
feb-23-2012
psk-147
7
international
14
             450,000.00
111
1
feb-25-2012
feb-28-2012
psk-437
8
kenworth
5
          3,100,000.00
112
1
feb-20-2012
feb-22-2012
sdk-341
9
nissan
13
             700,000.00
113
3
feb-27-2012
feb-29-2012
psk-321
1
jac
6
             550,000.00
114
5
feb-23-2012
feb-25-2012
tpu-142
2
mitsubishi
1
             600,000.00
115
7
feb-27-2012
feb-29-2012
nwj-432
3
chevrolet
4
             450,000.00
116
3
feb-23-2012
feb-25-2012
sdk-300
4
chevrolet
6
             550,000.00
117
5
feb-21-2012
feb-23-2012
sdk-420
5
chevrolet
13
             700,000.00
118
7
feb-27-2012
feb-29-2012
nca-214
6
chevrolet
2
             650,000.00
119
8
feb-24-2012
feb-27-2012
psk-147
7
international
17
                70,000.00
120
4
feb-29-2012
mar-02-2012
psk-437
8
kenworth
18
          2,500,000.00
121
2
feb-23-2012
feb-24-2012
sdk-341
9
nissan
17
                70,000.00
122
1
mar-05-2012
mar-07-2012
psk-321
1
jac
3
             650,000.00
123
5
feb-27-2012
feb-29-2012
tpu-142
2
mitsubishi
6
             550,000.00
124
8
mar-05-2012
mar-07-2012
nwj-432
3
chevrolet
11
          1,300,000.00
125
2
feb-27-2012
feb-28-2012
sdk-300
4
chevrolet
17
                70,000.00
126
8
feb-24-2012
feb-25-2012
sdk-420
5
chevrolet
17
                70,000.00
127
7
mar-05-2012
mar-07-2012
nca-214
6
chevrolet
14
             450,000.00
128
6
feb-28-2012
mar-01-2012
psk-147
7
international
3
             650,000.00
129
5
mar-03-2012
mar-05-2012
psk-437
8
kenworth
5
          3,100,000.00
130
4
feb-25-2012
feb-27-2012
sdk-341
9
nissan
17
                70,000.00
131
3
mar-08-2012
mar-10-2012
psk-321
1
jac
13
             700,000.00
132
2
mar-05-2012
mar-07-2012
tpu-142
2
mitsubishi
4
             450,000.00
133
1
mar-08-2012
mar-10-2012
nwj-432
3
chevrolet
17
                70,000.00
134
6
mar-05-2012
mar-06-2012
sdk-300
4
chevrolet
7
             300,000.00
135
3
feb-27-2012
feb-29-2012
sdk-420
5
chevrolet
10
             350,000.00
136
8
mar-08-2012
mar-10-2012
nca-214
6
chevrolet
6
             550,000.00
137
2
mar-05-2012
mar-07-2012
psk-147
7
international
2
             650,000.00
138
6
mar-06-2012
mar-08-2012
psk-437
8
kenworth
12
          2,800,000.00
139
4
feb-28-2012
feb-29-2012
sdk-341
9
nissan
17
                70,000.00
140
5
mar-12-2012
mar-14-2012
psk-321
1
jac
4
             450,000.00
141
1
mar-08-2012
mar-10-2012
tpu-142
2
mitsubishi
3
             650,000.00
142
1
mar-12-2012
mar-14-2012
nwj-432
3
chevrolet
6
             550,000.00
143
3
mar-07-2012
mar-08-2012
sdk-300
4
chevrolet
8
             300,000.00
144
3
mar-05-2012
mar-07-2012
sdk-420
5
chevrolet
16
             450,000.00
145
5
mar-12-2012
mar-14-2012
nca-214
6
chevrolet
6
             550,000.00
146
5
mar-08-2012
mar-10-2012
psk-147
7
international
14
             450,000.00
147
7
mar-09-2012
mar-12-2012
psk-437
8
kenworth
18
          2,500,000.00
148
7
mar-05-2012
mar-06-2012
sdk-341
9
nissan
7
             300,000.00
149
8
mar-15-2012
mar-17-2012
psk-321
1
jac
2
             650,000.00
150
7
mar-12-2012
mar-13-2012
tpu-142
2
mitsubishi
17
                70,000.00
151
6
mar-15-2012
mar-17-2012
nwj-432
3
chevrolet
1
             600,000.00
152
5
mar-09-2012
mar-10-2012
sdk-300
4
chevrolet
9
             400,000.00
153
4
mar-08-2012
mar-10-2012
sdk-420
5
chevrolet
6
             550,000.00
154
3
mar-15-2012
mar-17-2012
nca-214
6
chevrolet
4
             450,000.00
155
2
mar-12-2012
mar-13-2012
psk-147
7
international
17
                70,000.00
156
1
mar-13-2012
mar-15-2012
psk-437
8
kenworth
11
          1,300,000.00
157
1
mar-07-2012
mar-09-2012
sdk-341
9
nissan
10
             350,000.00
158
1
mar-20-2012
mar-22-2012
psk-321
1
jac
3
             650,000.00
159
7
mar-14-2012
mar-16-2012
tpu-142
2
mitsubishi
6
             550,000.00
160
7
mar-20-2012
mar-22-2012
nwj-432
3
chevrolet
4
             450,000.00
161
4
mar-12-2012
mar-13-2012
sdk-300
4
chevrolet
7
             300,000.00
162
4
mar-12-2012
mar-14-2012
sdk-420
5
chevrolet
14
             450,000.00
163
7
mar-20-2012
mar-21-2012
nca-214
6
chevrolet
17
                70,000.00
164
3
mar-14-2012
mar-16-2012
psk-147
7
international
2
             650,000.00
165
2
mar-16-2012
mar-19-2012
psk-437
8
kenworth
5
          3,100,000.00
166
8
mar-10-2012
mar-12-2012
sdk-341
9
nissan
17
                70,000.00
167
7
mar-17-2012
mar-20-2012
tpu-142
2
mitsubishi
1
             600,000.00
168
6
mar-14-2012
mar-16-2012
sdk-300
4
chevrolet
6
             550,000.00
169
5
mar-15-2012
mar-17-2012
sdk-420
5
chevrolet
10
             350,000.00
170
4
mar-17-2012
mar-20-2012
psk-147
7
international
11
          1,300,000.00
171
3
mar-19-2012
mar-22-2012
psk-437
8
kenworth
18
          2,500,000.00
172
2
mar-13-2012
mar-15-2012
sdk-341
9
nissan
13
             700,000.00
173
1
mar-21-2012
mar-23-2012
tpu-142
2
mitsubishi
14
             450,000.00
174
1
mar-17-2012
mar-21-2012
sdk-300
4
chevrolet
4
             450,000.00
175
2
mar-20-2012
mar-22-2012
sdk-420
5
chevrolet
1
             600,000.00
176
3
mar-21-2012
mar-23-2012
psk-147
7
international
6
             550,000.00
177
4
mar-16-2012
mar-17-2012
sdk-341
9
nissan
17
                70,000.00
178
5
mar-19-2012
mar-21-2012
sdk-341
9
nissan
14
             450,000.00








     112,990,000.00


TABLA DE DESTINO

Id destino
ciudad o destino
valor
1
mocoa
 $        600,000
2
puerto asis
 $        650,000
3
san miguel
 $        650,000
4
orito
 $        600,000
5
bogota
 $    3,100,000
6
tumaco
 $        550,000
7
ipiales
 $        300,000
8
tuquerres
 $        300,000
9
sandona
 $        400,000
10
taminango
 $        350,000
11
cali
 $    1,300,000
12
medellin
 $    2,800,000
13
popayan
 $        700,000
14
san pablo
 $        450,000
15
barranquilla
 $    2,700,000
16
vuelta al galeras
 $        450,000
17
pasto
 $          70,000
18
Cartagena
 $    2,500,000


TABLA VEHICULO








id vehiculo
placa
marca
color
modelo
1
psk-321
jac
blanco
2007
2
tpu-142
mitsubishi
blanco
2004
3
nwj-432
chevrolet
verde
1998
4
sdk-300
chevrolet
rojo
1995
5
sdk-420
chevrolet
blanco
2007
6
nca-214
chevrolet
blanco
2009
7
psk-147
international
vinotinto
2004
8
psk-437
kenworth
lila
2007
9
sdk-341
nissan
vinotinto
1999



TABLA DE CONDUCTOR


















id conductor
documento
nombre
apellido
edad
direccion 
telefono
licencia
eps
arp
1
98543879
oscar
ruiz
35
k 25 # 12-46
3176188516
987654
cruz blanca 
liberty
2
98654865
jairo
caicedo
21
casa 123 anganoy
3152492621
123456
sura 
sura
3
5432098
jorge
delgado
36
mz u cs 12 cantarana
3148141711
654789
salud total
colpatria
4
12675009
remigio
insandara
45
mz 7 cs 6 brisas
3128612825
654321
cruz blanca 
sura
5
98342900
angel
lara
42
casa 74 anganoy
3174383501
980765
salucoop
sura
6
98123098
jhon
españa
39
apto 201 edif. Universo
3004077948
675844
cafesalud
liberty
7
12453896
orlando
matabanchoy
22
buesaquillo
3006173837
345216
sura 
liberty
8
5897543
artemio
zambrano
36
k 26 # 10-25
3014441981
567398
cruz blanca 
colpatria
9
98382805
wilson
leon
48
mz i cs 13 granada
3176188517
876543
cafesalud
colpatria










TABLA DE CLIENTE


















id cliente
razon
nit
contacto
direccion
ciudad
telefono
url


1
distribuidora tropipasto
9008764352
jesus pantoja
K 42 # 20-120
pasto
7332311


2
jhon restrepo y Cia
9001235462
alexander
cresemillas bod 1
pasto
7290001


3
distribuidora corbeta
9006785432
mario gomez
alkosto parque bolivar
pasto
7326543


4
distribuidora prisur
9000987652
libardo
catambuco
pasto
7316790


5
casa andina
9005643212
jose
salida al sur
pasto
7328080


6
cacharreria mundial
9003216542
sonia
clle 18 # 18-57
pasto
7334521


7
multialambres
9005432192
jaime
barrio las lunas
pasto
7315432


8
cyrgo 
9007864532
adriana
panamericana
pasto
7318989





No hay comentarios:

Publicar un comentario