- Joined
- Jun 14, 2024
- Messages
- 2,590
- Reaction score
- 22,385
- Points
- 113
- Thread Author
- #1
srpsolucoes.com.br
srpsolucoes.com.br
Format - .SQL
Date - 04/2024
All Rows - 1.6kk
Website - srpsolucoes.com.br
Code:
INSERT INTO `cotacao` (`id`, `tipo_documento`, `id_modal`, `id_modal_minuta`, `faturar`, `id_servico`, `id_unidade`, `validade`, `id_pagador`, `pagador`, ` telefone`, `solicitante`, `email`, `id_centro_custo`, `id_projeto`, `id_especie`, `id_mercadoria`, `id_forma_pagamento`, `id_cidade_origem`, `id_cidade_des tino`, `id_cidade_polo`, `km_destino`, `km_polo`, `km_despacho`, `receita`, `despesa`, `resultado`, `margem`, `status`, `total_documento`, `total_valor_doc `, `total_volume`, `total_peso`, `total_metro_cubico`, `total_cubado`, `total_peso_taxado`, `id_remetente`, `telefone_remetente`, `procurar_remetente`, `da ta_coleta`, `hora_inicial_coleta`, `hora_final_coleta`, `id_destinatario`, `telefone_destinatario`, `procurar_destinatario`, `data_saida`, `data_prevista`,
`hora_inicial_prevista`, `hora_final_prevista`, `solicitacao`, `bundle`, `email_site`, `id_taxa_outra`, `id_embalagem`, `id_tipo_veiculo`, `id_recurso`, ` id_recebedor`, `id_expedidor`, `id_local`, `observacao`, `observacao_interna`, `escolta`, `modo_calculo`, `cadastrado_por`, `dt_cadastro`, `modificado_por`
, `dt_modificacao`, `id_icms`) VALUES (6, 'NACIONAL', 0, 2, '0', 11, 1, '2018-04-03', 75, 'ITALTEL BRASIL LTDA', '1131408650', 'ANTENOR', '[email protected]', 0, 199, 0, 9, 1, 7591, 114
6, 0, '0', '0', '0', '616.48', '61.93', '554.55', '90.1', 'APROVADA', '1', '', '', '6.9', '', '', '', 2, '', 'LUCIANO', '2018-03-14', '10:25:00', '00:00:00 ', 0, '', '', '0000-00-00', '2018-03-14', '10:25:00', '00:00:00', '', 'COTAçãO DE FRETE BR 16030 SITE: FLA01_ NF 8140 _ RMA QCAR16_XR3180 _ XTERA', '', 0,
0, 0, 0, 0, 0, 0, '', '', '', 0, 'LUCIANO', '2018-03-14 08:38:00', 'SEM REGISTRO', 'SEM REGISTRO', 0),
(7, 'NACIONAL', 0, 2, '0', 11, 1, '2018-04-03', 75, 'ITALTEL BRASIL LTDA (SP)', '1131408650', 'ANTENOR/SERGIO/LARISSA', '[email protected]', 0, 199
, 0, 9, 1, 7591, 4912, 4912, '2704', '2704', '0', '619.13', '146.06', '473.07', '76.41', 'APROVADA', '1', '124455.9', '1', '6.9', '0.026', '6.9', '6.9', 2,
'', 'LUCIANO', '2018-03-14', '00:00:00', '00:00:00', 0, '', '', '0000-00-00', '2018-03-14', '00:00:00', '00:00:00', '', 'COTAçãO DE FRETE BR 16030 SITE: R CE01_ NF 8141 _ RMA QCAR16_XR3213 _ XTERA', '', 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 'LUCIANO', '2018-03-14 15:43:00', 'SEM REGISTRO', 'SEM REGISTRO', 0),
(10, 'NACIONAL', 0, 1, '0', 10, 1, '2018-04-04', 0, 'ITALTEL BRASIL LTDA', '1131408650', 'SERGIO', '[email protected]', 0, 235, 0, 9, 1, 8094, 7591
, 0, '0', '0', '0', '908.96', '91.31', '817.65', '89.98', 'APROVADA', '1', '', '', '71.366', '', '', '', 83, '', '', '2018-03-15', '00:00:00', '00:00:00',
0, '', '', '0000-00-00', '2018-03-15', '00:00:00', '00:00:00', '', '', '', 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 'LUCIANO', '2018-03-15 13:13:00', 'SEM REGIS TRO', 'SEM REGISTRO', 0),
(11, 'NACIONAL', 0, 2, '0', 11, 1, '2018-04-04', 75, 'ITALTEL BRASIL LTDA', '1131408650', 'SERGIO', '[email protected]', 0, 209, 0, 9, 1, 7591, 640
1, 6360, '0', '0', '170', '1282.3', '128.81', '1153.49', '90.02', 'CANCELADA', '1', '', '', '15.264', '', '', '', 2, '', '', '2018-03-15', '16:38:00', '16: 40:00', 0, '', '', '0000-00-00', '2018-03-15', '16:38:00', '16:40:00', '', '', '', 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 'LUCIANO', '2018-03-15 16:38:00', 'S EM REGISTRO', 'SEM REGISTRO', 0),
(12, 'NACIONAL', 0, 2, '0', 11, 1, '2018-04-04', 75, 'ITALTEL BRASIL LTDA (SP)', '1131408650', 'LARISSA', '[email protected]', 0, 214, 0, 9, 1, 759
1, 6360, 6360, '437', '437', '1', '1285.91', '148.36', '1137.55', '88.46', 'APROVADA', '1', '163.35', '6', '92.7', '0.303', '92.7', '92.7', 2, '', '', '201 8-03-16', '00:00:00', '00:00:00', 0, '', '', '0000-00-00', '2018-03-16', '00:00:00', '00:00:00', '', '', '', 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 'LUCIANO',
'2018-03-15 17:34:00', 'SEM REGISTRO', 'SEM REGISTRO', 0),
(13, 'NACIONAL', 0, 2, '0', 11, 1, '2018-04-05', 75, 'ITALTEL BRASIL LTDA', '1131408650', 'SERGIO', '[email protected]', 0, 214, 0, 1, 1, 7591, 640
1, 6360, '0', '0', '170', '4562.95', '458.35', '4104.6', '89.96', 'CANCELADA', '1', '', '', '361.92', '', '', '', 2, '', 'LUCIANO', '0000-00-00', '00:00:00 ', '00:00:00', 0, '', '', '0000-00-00', '0000-00-00', '00:00:00', '00:00:00', '', 'TESTE DE SISTEMA ', '', 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 'SISTEMA', ' 2018-03-16 18:05:00', 'SEM REGISTRO', 'SEM REGISTRO', 0),
(14, 'NACIONAL', 0, 1, '0', 10, 1, '2018-04-08', 75, 'ITALTEL BRASIL LTDA', '1131408650', 'ANTENOR', '[email protected]', 0, 213, 0, 1, 1, 7591, 75
91, 7591, '0', '0', '0', '250', '25.11', '224.89', '90', 'EM ABERTO', '1', '', '', '105.235', '', '', '', 0, '', '', '2018-03-18', '15:00:00', '15:10:00',
0, '', '', '0000-00-00', '2018-03-18', '15:00:00', '15:10:00', '', '', '', 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 'LUCIANO', '2018-03-19 08:57:00', 'SEM REGIS TRO', 'SEM REGISTRO', 0),
(15, 'NACIONAL', 0, 2, '0', 11, 1, '2018-04-09', 75, 'ITALTEL BRASIL LTDA (SP)', '1131408650', 'SERGIO', '[email protected]', 0, 214, 0, 2, 1, 7591
, 2750, 2702, '0', '0', '442', '3184.35', '373.26', '2811.09', '88.28', 'APROVADA', '1', '10175.78', '2', '27', '0.148', '27', '27', 2, '', 'LUCIANO', '201 8-03-21', '10:50:00', '00:00:00', 0, '', '', '0000-00-00', '2018-03-21', '10:50:00', '00:00:00', '', 'COTAÇ??O DE FRETE - BR 17221 - SITE TX.CMA01 - SC 556 7 ENTREGA DE MT', '', 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 'LUCIANO', '2018-03-20 10:48:00', 'SEM REGISTRO', 'SEM REGISTRO', 0),
(16, 'NACIONAL', 0, 2, '0', 11, 1, '2018-04-09', 75, 'ITALTEL BRASIL LTDA', '1131408650', 'ANTENOR', '[email protected]', 0, 214, 0, 1, 0, 5545, 43
74, 4374, '0', '0', '0', '957.82', '96.72', '861.1', '89.97', 'REPROVADA', '1', '', '', '34', '', '', '', 0, '', 'ANTENOR', '0000-00-00', '00:00:00', '00:0 0:00', 0, '', '', '0000-00-00', '0000-00-00', '00:00:00', '00:00:00', '', 'COTAçãO DE FRETE - BR 17221_SITE: TX.CDLBLM_NF_767_768', '', 0, 0, 0, 0, 0, 0, 0
, '', '', '', 0, 'LUCIANO', '2018-03-20 17:29:00', 'SEM REGISTRO', 'SEM REGISTRO', 0),
(17, 'NACIONAL', 0, 2, '0', 11, 1, '2018-04-10', 75, 'ITALTEL BRASIL LTDA', '1131408650', 'SERGIO', '[email protected]', 0, 200, 0, 1, 0, 7591, 636
0, 6360, '0', '0', '0', '1352.21', '135.83', '1216.38', '90.01', 'EM ABERTO', '1', '', '', '89.701', '', '', '', 2, '', 'LUCIANO', '0000-00-00', '00:00:00'
, '00:00:00', 0, '', '', '0000-00-00', '0000-00-00', '00:00:00', '00:00:00', '', '', '', 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 'LUCIANO', '2018-03-21 11:14:0 0', 'SEM REGISTRO', 'SEM REGISTRO', 0),
(18, 'NACIONAL', 0, 2, '0', 11, 1, '2018-04-11', 75, 'ITALTEL BRASIL LTDA', '1131408650', 'ANTENOR', '[email protected]', 0, 232, 0, 1, 1, 5545, 77
01, 7591, '0', '0', '100', '4588.13', '460.88', '4127.26', '89.97', 'REPROVADA', '1', '', '', '369.98', '', '', '', 0, '', '', '0000-00-00', '00:00:00', '0 0:00:00', 0, '', '', '0000-00-00', '0000-00-00', '00:00:00', '00:00:00', '', '', '', 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 'LUCIANO', '2018-03-22 15:45:00',
'SEM REGISTRO', 'SEM REGISTRO', 0),
(19, 'NACIONAL', 0, 2, '0', 11, 1, '2018-04-12', 75, 'ITALTEL BRASIL LTDA', '1131408650', 'LARISSA', '[email protected]', 0, 208, 0, 2, 1, 7591, 63
60, 6360, '0', '0', '0', '319.48', '32.09', '287.38', '89.97', 'EM ABERTO', '1', '', '', '3.25', '', '', '', 2, '', 'LUCIANO', '0000-00-00', '00:00:00', '0 0:00:00', 0, '', '', '0000-00-00', '0000-00-00', '00:00:00', '00:00:00', '', 'COTAÇ??O DE FRETE BR17063 - AGENDAMENTO PARA ENTREGA DE HARDARE E MATRERIAL D O BUNDLE PROJETO DOAç', '', 0, 0, 0, 0, 0, 0, 0, '', '', '', 0, 'LUCIANO', '2018-03-23 09:26:00', 'SEM REGISTRO', 'SEM REGISTRO', 0),
(20, 'NACIONAL', 0, 1, '0', 10, 1, '2018-04-12', 75, 'ITALTEL BRASIL LTDA', '1131408650', 'SERGIO', '[email protected]', 0, 229, 0, 1, 1, 6360, 636
0, 6360, '0', '0', '0', '926.2', '93.04', '833.16', '89.96', 'EM ABERTO', '1', '', '', '232.426', '', '', '', 0, '', '', '0000-00-00', '00:00:00', '00:00:0 0', 0, '', '', '0000-00-00', '0000-00-00', '00:00:00', '00:00:00', '', 'ENC: BR 17366 - REMANEJAMENTO WAREHOUSE ', '', 0, 0, 0, 0, 0, 0, 0, '', '', '', 0,
'LUCIANO', '2018-03-23 09:37:00', 'SEM REGISTRO', 'SEM REGISTRO', 0),
(3879, 1, 'CADASTRO', '47.383.971/0010-12', '', 'ISENTO', 'PLANOVA PLANEJAMENTO E CONSTRUCOES S.A.', 'PLANOVA PLANEJAMENTO E CONSTRUCOES S.A.', '(11) 3165-5000', '', '', '', '', '', '', '', '45960000', 'EST NOVA ZELANDIA', 'S/N', 'ZONA RURAL', 455, 0, 'MEDEIROS NETO', 'BA', '', '', 'BRASIL', 'ATIVO', 'ATIVO', 'ATIVO', '', '', '', '', '', '', 0, 0, 'ALEX', '2023-08-21 13:53:03', 'SEM REGISTRO', 'SEM REGISTRO', '', 0, 0, 0),
(3880, 1, 'CADASTRO', '068.886.475-95', '', 'ISENTO', 'MAURO ALVES DA ROCHA', 'MAURO ALVES DA ROCHA', '', '', '', '', '', '', '', '', '45055-485', 'RUA JOSE FERREIRA ROCHA', '142', 'FELICIA', 613, 0, 'VITORIA DA CONQUISTA', 'BA', '', '', 'BRASIL', 'ATIVO', 'ATIVO', 'ATIVO', '', '', '', '', '', '', 0, 0, 'ALEX', '2023-08-21 14:08:39', 'SEM REGISTRO', 'SEM REGISTRO', '', 0, 0, 0),
(3881, 1, 'CADASTRO', '074.424.364-55', '', 'ISENTO', 'DINIELA MACHADO DE ALMEIDA', 'DINIELA MACHADO DE ALMEIDA', '', '', '', '', '', '', '', '', '44001-550', 'RUA BARAO DE COTEGIPE', '906', 'CENTRO', 330, 0, 'FEIRA DE SANTANA', 'BA', '', '', 'BRASIL', 'ATIVO', 'ATIVO', 'ATIVO', '', '', '', '', '', '', 0, 0, 'ALEX', '2023-08-22 13:54:27', 'SEM REGISTRO', 'SEM REGISTRO', '', 0, 0, 0),
(3882, 1, 'CADASTRO', '32.606.634/0001-89', '', 'SIM', 'PUCCY CALCADOS LTDA', 'PUCCY CALCADOS LTDA', '', '', '', '', '', '', '', '', '44002168', 'PC JOAO PEDREIRA', '72', 'CENTRO', 330, 0, 'FEIRA DE SANTANA', 'BA', '', '', 'BRASIL', 'ATIVO', 'ATIVO', 'ATIVO', '', '', '', '', '', '', 0, 0, 'ALEX', '2023-08-22 13:58:04', 'SEM REGISTRO', 'SEM REGISTRO', '', 0, 0, 0),
(3883, 1, 'CADASTRO', '07.976.147/0009-18', '', 'ISENTO', 'MOVIDA RENT A CAR', 'MOVIDA RENT A CAR', '(11) 2377-7000/ (11)', '', '', '', '', '', '', '', '44076130', 'AV PRESIDENTE DUTRA', '2850', 'CAPUCHINHOS', 330, 0, 'FEIRA DE SANTANA', 'BA', '', '', 'BRASIL', 'ATIVO', 'ATIVO', 'ATIVO', '', '', '', '', '', '', 0, 0, 'ALEX', '2023-08-22 14:10:22', 'SEM REGISTRO', 'SEM REGISTRO', '', 0, 0, 0),
(3884, 1, 'CADASTRO', '04.298.106/0001-74', '', 'ISENTO', 'SIN - SISTEMA DE IMPLANTE NACIONAL S.A.', 'SIN - SISTEMA DE IMPLANTE NACIONAL S.A.', '(11) 2169-3000', '', '', '', '', '', '', '', '03348060', 'R SOLDADO OCIMAR GUIMARAES DA SILVA', '421', 'VILA RIO BRANCO', 5353, 0, 'SAO PAULO', 'SP', '', '', 'BRASIL', 'ATIVO', 'ATIVO', 'ATIVO', '', '', '', '', '', '', 0, 0, 'ALEX', '2023-08-22 14:40:28', 'SEM REGISTRO', 'SEM REGISTRO', '', 0, 0, 0),
(3885, 1, 'CADASTRO', '210.313.175-73', '', 'ISENTO', 'DIEGO NUNES MIGUEL DE OLIVEIRA', 'DIEGO NUNES MIGUEL DE OLIVEIRA', '', '', '', '', '', '', '', '', '42701-420', 'RUA LEONARDO R DA SILVA', '248', 'PITANGUEIRAS', 431, 0, 'LAURO DE FREITAS', 'BA', '', '', 'BRASIL', 'ATIVO', 'ATIVO', 'ATIVO', '', '', '', '', '', '', 0, 0, 'ALEX', '2023-08-22 14:45:00', 'SEM REGISTRO', 'SEM REGISTRO', '', 0, 0, 0),
(3886, 1, 'CADASTRO', '60.042.686/0001-05', '', 'SIM', 'HERCULES EQUIPAMENTOS DE PROTECAO LTDA.', 'HERCULES EQUIPAMENTOS DE PROTECAO LTDA.', '(11) 4391-6640', '', '', '', '', '', '', '', '09895003', 'AV ROBERT KENNEDY', '675', 'PIRAPORINHA', 5335, 0, 'SAO BERNARDO DO CAMPO', 'SP', '', '', 'BRASIL', 'ATIVO', 'ATIVO', 'ATIVO', '', '', '', '', '', '', 0, 0, 'ALEX', '2023-08-22 14:49:11', 'SEM REGISTRO', 'SEM REGISTRO', '', 0, 0, 0),
(3887, 1, 'CADASTRO', '06.913.480/0004-00', '', 'SIM', 'DIMENSIONAL', 'DIMENSIONAL', '(21) 2195-9238/ (21)', '', '', '', '', '', '', '', '42701340', 'R PELICANO', '277', 'PITANGUEIRAS', 431, 0, 'LAURO DE FREITAS', 'BA', '', '', 'BRASIL', 'ATIVO', 'ATIVO', 'ATIVO', '', '', '', '', '', '', 0, 0, 'ALEX', '2023-08-22 14:50:09', 'SEM REGISTRO', 'SEM REGISTRO', '', 0, 0, 0),
(3888, 1, 'CADASTRO', '13.511.118/0001-26', '', 'SIM', 'LOJA BARRETO DE DEPARTAMENTO', 'LOJA BARRETO DE DEPARTAMENTO', '(75) 3423-8500', '', '', '', '', '', '', '', '48010140', 'PRACA JOSE JOAQUIM SEABRA', '56', 'CENTRO', 618, 0, 'ALAGOINHAS', 'BA', '', '', 'BRASIL', 'ATIVO', 'ATIVO', 'ATIVO', '', '', '', '', '', '', 0, 0, 'ALEX', '2023-08-22 14:54:02', 'SEM REGISTRO', 'SEM REGISTRO', '', 0, 0, 0),
(3889, 1, 'CADASTRO', '34.885.138/0001-37', '', 'ISENTO', 'ECOINFLAVEIS INDUSTRIA E COMERCIO DE TENDAS E INFLAVEIS LTDA', 'ECOINFLAVEIS INDUSTRIA E COMERCIO DE TENDAS E INFLAVEIS LTDA', '(11) 2575-1800', '', '', '', '', '', '', '', '04766001', 'RUA OLIVIA GUEDES PENTEADO', '371', 'SOCORRO', 5353, 0, 'SAO PAULO', 'SP', '', '', 'BRASIL', 'ATIVO', 'ATIVO', 'ATIVO', '', '', '', '', '', '', 0, 0, 'ALEX', '2023-08-22 14:59:49', 'SEM REGISTRO', 'SEM REGISTRO', '', 0, 0, 0),
(3890, 0, 'CADASTRO', '09.317.243/0002-03', '', 'SIM', 'FORTEFARMA ITABERABA', 'FORTEFARMA ITABERABA', '(77) 3025-0910', '', '', '', '', '', '', '', '46880000', 'R RAMIRO PIMENTEL', '58', 'CENTRO', 376, 0, 'ITABERABA', 'BA', '', '', 'BRASIL', '', '', '', '', '', '', '', '', '', 0, 0, '', '2023-08-22 15:00:40', 'SEM REGISTRO', 'SEM REGISTRO', '', 0, 0, 0),
(3891, 1, 'CADASTRO', '12.432.329/0007-04', '', 'SIM', 'ANCHIETA PECAS DISTRIBUIDORA DE PECAS PARA CAMINHOES E ONIBU', 'ANCHIETA PECAS DISTRIBUIDORA DE PECAS PARA CAMINHOES E ONIBU', '(11) 2764-2577', '', '', '', '', '', '', '', '09380000', 'AV ALBERTO SOARES SAMPAIO', '1764', 'CAPUAVA', 5120, 0, 'MAUA', 'SP', '', '', 'BRASIL', 'ATIVO', 'ATIVO', 'ATIVO', '', '', '', '', '', '', 0, 0, 'ALEX', '2023-08-22 15:04:32', 'SEM REGISTRO', 'SEM REGISTRO', '', 0, 0, 0),