INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4984, 1, 152, 1, 0, NULL, 0, '2024-05-03 09:13:09', '2024-05-03 09:13:32', '2024-05-03', 'P4658', '', '', 0.00, 85.80, 18.02, 0.00, 0, 0.00, 0.00, 'PUNTALA 12 A', 'Hondarrabía', 'Guipúzcoa', '20280', 'España', 103.82, 0, '2024-05-03 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-030524-XOS1WUfGLRN+J-074', 'a2e4d5aa-29d7-4ed0-9a8a-98b8bdc1d51c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030524-XOS1WUfGLRN%2BJ-074&s=KOL2024&nf=P4658&i=103.82&cr=168', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4985, 1, 1255, 2, 0, NULL, 0, '2024-05-03 10:11:00', '2024-05-03 12:18:14', '2024-05-03', 'P4659', '24-06310-05-03', 'Llamar antes de entregar por teléfono.', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Plaza Rinconada de san Miguel 3 ', 'Palencia', 'Palencia', '34005', 'España', 17.50, 0, '2024-05-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-030524-D1POtYdQwCDcM-208', 'c3a532cb-67e2-418b-9b47-3fac6a7f979a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-030524-D1POtYdQwCDcM-208&s=KOL2024&nf=P4659&i=17.50&cr=176', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4986, 1, 397, 2, 0, NULL, 0, '2024-05-03 10:28:59', '2024-05-06 09:37:58', '2024-05-06', 'P4660', '24-06311-05-03', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Alberga 69 1° Izda', 'Errenteria', 'Gipuzkoa', '20100', 'España', 28.39, 0, '2024-05-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060524-i7pC78aJ0FKbO-222', '786f211a-0aee-41b8-a393-f09bb86e77ba', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060524-i7pC78aJ0FKbO-222&s=KOL2024&nf=P4660&i=28.39&cr=185', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4987, 1, 306, 2, 0, NULL, 0, '2024-05-03 13:25:55', '2024-05-06 09:38:28', '2024-05-06', 'P4661', '24-06312-05-03', '', 0.00, 285.00, 59.85, 0.00, 0, 0.00, 0.00, 'Carrer Puigmoltó, 9-11, Vilafranca del Penedès', 'Vilafranca del Pened', 'Barcelona', '08720', 'España', 344.85, 0, '2024-05-03 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060524-TsxZlQxqPVBrU-032', '9654f3ed-0455-45e9-a151-0a1d03671531', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060524-TsxZlQxqPVBrU-032&s=KOL2024&nf=P4661&i=344.85&cr=250', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4988, 1, 145, 2, 0, NULL, 0, '2024-05-03 18:28:26', '2024-05-06 09:38:55', '2024-05-06', 'P4665', '24-06313-05-03', '', 0.00, 142.50, 30.36, 0.00, 0, 0.00, 2.50, 'España 5 local 2', 'Ciempozuelos', 'Madrid', '28350', 'España', 174.93, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-060524-R7MQcSNxa1M60-152', '1a4298d9-714e-4e71-b906-7df9a13de270', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060524-R7MQcSNxa1M60-152&s=KOL2024&nf=P4665&i=174.93&cr=065', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4989, 1, 121, 2, 0, NULL, 0, '2024-05-04 22:29:06', '2024-05-06 09:39:24', '2024-05-06', 'P4662', '24-06315-05-04', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'Blas de Otero,19bajo. 48014 bilbao', 'Bilbao', 'Bizkaia', '48915', 'España', 275.88, 0, '2024-05-04 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-060524-aVEMZl78XokJd-212', '975d78aa-677a-4a14-b402-d9f979a731b1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060524-aVEMZl78XokJd-212&s=KOL2024&nf=P4662&i=275.88&cr=078', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4990, 1, 1256, 2, 0, NULL, 0, '2024-05-05 09:58:11', '2024-05-06 09:39:41', '2024-05-06', 'P4663', '24-06316-05-05', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Zarzamora 22', 'Alcobendas', 'Madrid', '28109', 'España', 17.50, 0, '2024-05-05 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060524-Ebed5l/VQNoh5-023', 'eed8d11d-3b82-4ea6-b3d9-1baaf1ac2de5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060524-Ebed5l%2FVQNoh5-023&s=KOL2024&nf=P4663&i=17.50&cr=194', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4991, 1, 1257, 2, 0, NULL, 0, '2024-05-05 13:03:46', '2024-05-06 09:39:58', '2024-05-06', 'P4664', '24-06318-05-05', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Urbanización Los Alisos, 32', 'Ciudad Real', 'Ciudad Real', '13002', 'España', 28.39, 0, '2024-05-05 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-060524-Jk/MpP0YgrEvg-165', '0d300999-aba7-465c-a69a-255aebe638c1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060524-Jk%2FMpP0YgrEvg-165&s=KOL2024&nf=P4664&i=28.39&cr=114', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4992, 1, 4, 2, 0, NULL, 0, '2024-05-06 08:44:49', '2024-05-06 11:02:06', '2024-05-06', 'P4666', '24-06319-05-06', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'PLAZA DE SAN MARTIN DE ABENDAÑO Nº4, BAJO', 'Vitoria-Gasteiz', 'Álava', '01009', 'España', 275.88, 0, '2024-05-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-060524-D6G399fG96iXm-120', '419d1f98-17b8-4296-b4a9-e5425aa9a1bd', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060524-D6G399fG96iXm-120&s=KOL2024&nf=P4666&i=275.88&cr=003', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4993, 1, 686, 1, 0, NULL, 0, '2024-05-06 11:09:24', '2024-05-06 11:09:37', '2024-05-06', 'P4667', '', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'Parke kalea 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 34.48, 0, '2024-05-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060524-PVEbJlqkR2rst-121', '405297f3-3260-4d4a-a71f-2309d0ea5305', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060524-PVEbJlqkR2rst-121&s=KOL2024&nf=P4667&i=34.47&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4994, 1, 686, 1, 1, 'FALTA LOTE DE PRODUCTO', 4993, '2024-05-06 11:10:55', '2024-05-06 11:10:55', '2024-05-06', 'R77', 'P4667 RECT.', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 34.48, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-060524-KpGtujYkoy5Lu-204', '8a1534ad-87d9-4d64-878f-04ce513386b7', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060524-KpGtujYkoy5Lu-204&s=KOL2024&nf=R77&i=-34.47&cr=151', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(4995, 1, 686, 1, 0, NULL, 0, '2024-05-06 11:12:27', '2024-05-06 11:12:27', '2024-05-06', 'P4668', '', '', 0.00, 28.50, 5.98, 0.00, 0, 0.00, 0.00, 'Parke kalea 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 34.48, 0, '2024-05-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060524-LbdSckv7kLO/x-209', '5a751290-91a7-48ad-8b16-0b42b42cd199', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060524-LbdSckv7kLO%2Fx-209&s=KOL2024&nf=P4668&i=34.47&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(4996, 1, 76, 1, 0, NULL, 0, '2024-05-06 12:41:11', '2024-05-06 12:41:11', '2024-05-06', 'P4669', '', '', 0.00, 167.31, 35.14, 0.00, 0, 0.00, 0.00, 'CAMI DEL FUS 54', 'VALENCIA', 'VALENCIA', '46470', 'ESPAÑA', 202.45, 0, '2024-05-06 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-060524-T2N7HE6gEIcDa-080', 'eb2e05e1-e494-4aa8-b031-4b83ae440c3d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-060524-T2N7HE6gEIcDa-080&s=KOL2024&nf=P4669&i=202.45&cr=169', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4997, 1, 676, 2, 0, NULL, 0, '2024-05-06 14:38:00', '2024-05-07 09:25:08', '2024-05-07', 'P4670', '24-06320-05-06', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Paseo de Gracia 98, piso 5 Beyond', 'Barcelona', 'Barcelona', '08008', 'España', 17.50, 0, '2024-05-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070524-P+98V1NmlgQFJ-106', '2a1396fa-fd8a-4f52-9cf8-423aa9a4474b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070524-P%2B98V1NmlgQFJ-106&s=KOL2024&nf=P4670&i=17.50&cr=060', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4998, 1, 167, 2, 0, NULL, 0, '2024-05-06 17:08:09', '2024-05-07 09:25:31', '2024-05-07', 'P4671', '24-06321-05-06', '', 0.00, 244.28, 51.30, 0.00, 0, 0.00, 0.00, 'Calle Barcelona 23', 'Manresa', 'Barcelona', '08242', 'España', 295.58, 0, '2024-05-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070524-MDI9p60eSiYwz-108', '95682112-fe15-4bab-b315-c0f316f9e1d3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070524-MDI9p60eSiYwz-108&s=KOL2024&nf=P4671&i=295.58&cr=043', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(4999, 1, 1258, 2, 0, NULL, 0, '2024-05-06 18:56:13', '2024-05-07 09:25:45', '2024-05-07', 'P4672', '24-06322-05-06', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Carrer Santa Eulàlia, num 5, 1º 1ª', 'Rubí', 'Barcelona', '08191', 'España', 17.50, 0, '2024-05-06 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070524-kBTL6XIF3Pfp+-057', 'e60b6eea-365f-43ea-876b-fe768bf44bb9', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070524-kBTL6XIF3Pfp%2B-057&s=KOL2024&nf=P4672&i=17.50&cr=174', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5000, 1, 98, 2, 0, NULL, 0, '2024-05-07 08:16:03', '2024-05-07 10:39:51', '2024-05-07', 'P4674', '24-06323-05-07', '', 0.00, 89.56, 18.81, 0.00, 0, 0.00, 0.00, 'calle eduard maristany 54,local 1,san pere de ribes 08810', 'Sant Pere de Ribes', 'Barcelona', '08810', 'España', 108.37, 0, '2024-05-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070524-XTtfoxEUwXwJf-216', '0ebe8a33-face-48bb-bcb7-671157511a65', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070524-XTtfoxEUwXwJf-216&s=KOL2024&nf=P4674&i=108.37&cr=094', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5001, 1, 391, 2, 0, NULL, 0, '2024-05-07 08:45:09', '2024-05-07 10:49:16', '2024-05-07', 'P4675', '24-06324-05-07', 'Peluquería Mi cabello &Moi', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'Paseo Santxiki num14/Mutilva ', 'Pamplona/Iruña', 'Navarra', '31192', 'España', 103.46, 0, '2024-05-07 00:00:00', '', '', 3, 5, 1, 'TBAI-B20930640-070524-MWKHr4XALnua5-092', 'ad398d4b-1691-41f3-a625-56a9ae97bcf5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070524-MWKHr4XALnua5-092&s=KOL2024&nf=P4675&i=103.46&cr=125', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(5002, 1, 1104, 2, 0, NULL, 0, '2024-05-07 09:11:58', '2024-05-07 11:49:08', '2024-05-07', 'P4676', '24-06325-05-07', '', 0.00, 30.66, 7.20, 0.00, 0, 0.00, 4.40, 'Gran Via 53 1-izquierda', 'Bilbao', 'Bizkaia', '48011', 'España', 41.50, 0, '2024-05-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070524-bIOk2My4B+3Il-117', 'b0c6c16c-f43d-4250-933d-2924cc73a087', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070524-bIOk2My4B%2B3Il-117&s=KOL2024&nf=P4676&i=41.50&cr=127', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5003, 1, 1259, 2, 0, NULL, 0, '2024-05-07 10:04:58', '2024-05-07 12:12:55', '2024-05-07', 'P4677', '24-06326-05-07', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Doctor Pedro Barceló 18, Bloque 4, bajo izquierda', 'Málaga', 'Málaga', '29016', 'España', 17.50, 0, '2024-05-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-070524-k3WZRrrvK+Xsj-220', 'a11a429e-030f-4c47-bd08-dd9e4b170674', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-070524-k3WZRrrvK%2BXsj-220&s=KOL2024&nf=P4677&i=17.50&cr=047', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5004, 1, 190, 3, 0, NULL, 0, '2024-05-07 13:45:50', '2024-10-15 16:08:18', '2024-05-07', '', 'Consumo interno', '', 0.00, 1538.46, 323.08, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 1861.54, 0, '2024-05-07 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5005, 1, 1050, 2, 0, NULL, 0, '2024-05-07 12:45:02', '2024-05-08 09:18:36', '2024-05-08', 'P4680', '24-06327-05-07', '', 0.00, 57.00, 12.40, 0.00, 1, 3.07, 2.50, 'Carlos caamaño,3', 'Madrid', 'Madrid', '28016', 'España', 74.54, 0, '0000-00-00 00:00:00', '', '', 3, 4, 1, 'TBAI-B20930640-080524-M9IY3DbE2FJuP-154', '1c1ac3c6-9366-468e-a010-444b8b9fcf2a', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080524-M9IY3DbE2FJuP-154&s=KOL2024&nf=P4680&i=74.54&cr=051', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5006, 1, 57, 2, 0, NULL, 0, '2024-05-07 13:06:05', '2024-05-08 09:21:00', '2024-05-08', 'P4678', '24-06328-05-07', '', 0.00, 199.50, 41.90, 0.00, 0, 0.00, 0.00, 'Plaza kontxa etxebgerria, bajo 4', 'Astigarraga', 'Gipuzkoa', '20115', 'España', 241.40, 0, '2024-05-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080524-c9SURjvWlrNJA-229', '06786781-7779-422a-b1ca-b9dad6c402a3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080524-c9SURjvWlrNJA-229&s=KOL2024&nf=P4678&i=241.40&cr=128', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5007, 1, 108, 2, 0, NULL, 0, '2024-05-07 14:57:00', '2024-05-08 09:22:36', '2024-05-08', 'P4681', '24-06329-05-07', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Aurora Infante 9 -5 D', 'Logroño', 'La Rioja', '26005', 'España', 137.94, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080524-RtSLVziNrMvvF-041', '16d43c63-bb13-46d5-a06f-9514035f15e8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080524-RtSLVziNrMvvF-041&s=KOL2024&nf=P4681&i=137.94&cr=003', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5008, 1, 1260, 2, 0, NULL, 0, '2024-05-07 20:26:44', '2024-05-08 09:24:28', '2024-05-08', 'P4679', '24-06332-05-07', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Pedro I 25, carnicería Mazo', 'Pamplona/Iruña', 'Navarra', '31007', 'España', 30.61, 0, '2024-05-07 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080524-QDtFfkH7OofBb-097', '45d12a54-f18b-4919-8b6f-0fa1895e949b', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080524-QDtFfkH7OofBb-097&s=KOL2024&nf=P4679&i=30.61&cr=180', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(5009, 1, 714, 2, 0, NULL, 0, '2024-05-08 09:06:02', '2024-05-08 11:37:23', '2024-05-08', 'P4682', '24-06333-05-08', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'carrer Cantallops 19', 'Avinyonet del Penedè', 'Barcelona', '08793', 'España', 30.61, 0, '2024-05-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080524-H2bmoiDJoBiUI-126', '2e8629a9-ffb9-4980-a87e-85e17c164f70', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080524-H2bmoiDJoBiUI-126&s=KOL2024&nf=P4682&i=30.61&cr=050', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5010, 1, 1261, 2, 0, NULL, 0, '2024-05-08 09:59:16', '2024-05-08 12:02:05', '2024-05-08', 'P4683', '24-06334-05-08', '', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'Calle Hurtado, nº 8, 2ºA', 'Jaén', 'Jaén', '23001', 'España', 17.50, 0, '2024-05-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-080524-M/xRt2odXWYJE-196', '7237b605-fcd6-450c-aedc-5d49fcdb09d5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080524-M%2FxRt2odXWYJE-196&s=KOL2024&nf=P4683&i=17.50&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5011, 1, 1262, 2, 0, NULL, 0, '2024-05-08 10:53:41', '2024-05-08 13:03:25', '2024-05-08', 'P4684', '24-06335-05-08', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Baltasar Echave 2-bajo', 'Zumaia', 'Gipuzkoa', '20750', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-080524-nHgz7T65Q94LB-164', '65ce4955-dbc9-45fa-9b56-1bc0c9e8c4b1', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-080524-nHgz7T65Q94LB-164&s=KOL2024&nf=P4684&i=30.61&cr=147', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5012, 1, 1262, 2, 0, NULL, 0, '2024-05-08 11:21:20', '2024-05-08 11:21:20', '2024-05-08', '', '24-06335-05-08', 'PIZZERIA MARINA', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Baltasar Echave 2-bajo', 'Zumaia', 'Gipuzkoa', '20750', 'España', 30.61, 0, '0000-00-00 00:00:00', '', '', 1, 3, 0, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 0),
(5013, 1, 114, 2, 0, NULL, 0, '2024-05-08 13:24:14', '2024-05-09 09:30:26', '2024-05-09', 'P4689', '24-06338-05-08', '', 0.00, 256.50, 53.87, 0.00, 0, 0.00, 0.00, 'Catalina de Erauso 10 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20010', 'España', 310.37, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090524-IMadbHYvlwUqk-150', '7449215b-1ed2-42aa-8c9e-5ec75a94a2c5', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090524-IMadbHYvlwUqk-150&s=KOL2024&nf=P4689&i=310.37&cr=156', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5014, 1, 1263, 2, 0, NULL, 0, '2024-05-08 18:20:59', '2024-05-09 09:33:08', '2024-05-09', 'P4685', '24-06339-05-08', 'Pueden dejar el paquete en la puerta de casa. ', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'sagardia 41', 'Urdiain', 'Navarra', '31830', 'España', 28.39, 0, '2024-05-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090524-R/w1ngcgojBkl-199', '39bd45b1-d764-4463-9ce0-e22f7260d158', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090524-R%2Fw1ngcgojBkl-199&s=KOL2024&nf=P4685&i=28.39&cr=234', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5015, 1, 144, 2, 0, NULL, 0, '2024-05-08 21:07:35', '2024-05-09 09:36:15', '2024-05-09', 'P4686', '24-06340-05-08', '', 0.00, 171.00, 35.91, 0.00, 0, 0.00, 0.00, 'Calle gloria 7 bajo', 'Donostia-San Sebasti', 'Gipuzkoa', '20001', 'España', 206.91, 0, '2024-05-08 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090524-TqPik6NAZDLFM-095', '5f91400c-0dfe-4077-9b85-2b5e7dcce945', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090524-TqPik6NAZDLFM-095&s=KOL2024&nf=P4686&i=206.91&cr=211', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(5016, 1, 1264, 2, 0, NULL, 0, '2024-05-09 06:02:43', '2024-05-09 09:40:26', '2024-05-09', 'P4687', '24-06342-05-09', 'La entrega por la tarde a partir de las 15:00 horas', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Calle Santiago Rusiñol, 14-16, 3º1ª', 'Esplugues de Llobreg', 'Barcelona', '08950', 'España', 28.39, 0, '2024-05-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090524-kbALFAGxZIyrh-164', 'a3952f60-a63b-4f9f-bec1-5dbae8f2db87', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090524-kbALFAGxZIyrh-164&s=KOL2024&nf=P4687&i=28.39&cr=179', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5017, 1, 215, 2, 0, NULL, 0, '2024-05-09 06:39:57', '2024-05-09 09:45:28', '2024-05-09', 'P4688', '24-06343-05-09', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Jaime primero 10 ', 'Monzón', 'Huesca', '22400', 'España', 137.94, 0, '2024-05-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090524-bK0BgiOjQc7uk-188', 'f55bad4d-7d84-4b0a-ac2c-c0f0fd741389', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090524-bK0BgiOjQc7uk-188&s=KOL2024&nf=P4688&i=137.94&cr=070', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5018, 1, 687, 1, 0, NULL, 0, '2024-05-09 09:49:36', '2024-05-09 09:51:20', '2024-05-09', 'P4690', '', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'Avenida Universidad 2, local C', 'Leganés', 'Madrid', '28911', 'España', 137.94, 0, '2024-05-09 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090524-GOfQ1LauH4MXn-011', '9dc62865-b090-44ef-914e-bfa27607e923', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090524-GOfQ1LauH4MXn-011&s=KOL2024&nf=P4690&i=137.94&cr=221', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5019, 1, 77, 1, 0, NULL, 0, '2024-05-09 10:07:23', '2024-05-09 10:16:24', '2024-05-09', 'P4691', '', '', 0.00, 973.83, 204.50, 0.00, 0, 0.00, 0.00, 'Gipuzkoa Kalea 1', 'Ordizia', 'Gipuzkoa', '20240', 'España', 1178.33, 0, '2024-05-09 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-090524-EYz6nINIebD7y-221', '99054d06-078e-4d31-9208-d72c1c9ab325', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090524-EYz6nINIebD7y-221&s=KOL2024&nf=P4691&i=1178.33&cr=235', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5020, 1, 1265, 2, 0, NULL, 0, '2024-05-09 08:10:45', '2024-05-09 10:24:05', '2024-05-09', 'P4692', '24-06344-05-09', 'Palacio Ezpeleta (oficina Administración. Entrando a mano derecha) ', 0.00, 10.83, 3.04, 0.00, 0, 0.00, 4.40, 'C/mayor, 65', 'Pamplona/Iruña', 'Navarra', '31001', 'España', 17.50, 0, '2024-05-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090524-oGh/GADnIEl6k-048', '99496f25-e04a-4631-8ba1-4a769b77e756', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090524-oGh%2FGADnIEl6k-048&s=KOL2024&nf=P4692&i=17.50&cr=191', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5021, 1, 80, 2, 0, NULL, 0, '2024-05-09 08:18:40', '2024-05-09 10:27:03', '2024-05-09', 'P4693', '24-06345-05-09', '', 0.00, 342.00, 71.82, 0.00, 0, 0.00, 0.00, 'Rua vella 3 palmeira', 'Ribeira', 'A Coruña', '15959', 'España', 413.82, 0, '2024-05-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090524-W7iG4i8RMcwGr-223', '738030dc-65d3-430f-90e2-db9d7325126c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090524-W7iG4i8RMcwGr-223&s=KOL2024&nf=P4693&i=413.82&cr=213', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(5022, 1, 1266, 2, 0, NULL, 0, '2024-05-09 08:37:34', '2024-05-09 10:44:52', '2024-05-09', 'P4694', '24-06346-05-09', 'Bajo del edificio Hay un taller de motos Motoflames. ', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Avenida uno de Mayo número 4 puerta 1', 'Alfara del Patriarca', 'Valencia', '46115', 'España', 52.39, 0, '2024-05-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090524-mg1ETjmSxDei5-231', 'be9302b1-ccb7-427f-b4ff-bc1e91700d12', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090524-mg1ETjmSxDei5-231&s=KOL2024&nf=P4694&i=52.39&cr=243', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5023, 1, 1047, 2, 0, NULL, 0, '2024-05-09 09:08:49', '2024-05-09 11:48:22', '2024-05-09', 'P4695', '24-06347-05-09', 'Es una empresa (PASCH) horario de 8-13h y de 14-17h viernes  15h', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Gran Vía de les Corts Catalanes, 645, 2º-1', 'Barcelona', 'Barcelona', '08010', 'España', 30.61, 0, '2024-05-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090524-mryh3kS1BO45U-208', 'd7d1b74f-12a1-4b66-a007-aa95de48ca47', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090524-mryh3kS1BO45U-208&s=KOL2024&nf=P4695&i=30.61&cr=226', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5024, 1, 1267, 2, 0, NULL, 0, '2024-05-09 11:13:50', '2024-05-09 13:33:38', '2024-05-09', 'P4696', '24-06348-05-09', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Katazpegi auzoa,3', 'Lesaka', 'Navarra', '31770', 'España', 28.39, 0, '2024-05-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-090524-ABTkxuoyFepgl-213', '3e7857ce-ac54-4dc1-aae3-1a564392afea', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-090524-ABTkxuoyFepgl-213&s=KOL2024&nf=P4696&i=28.39&cr=031', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5025, 1, 65, 2, 0, NULL, 0, '2024-05-09 12:04:23', '2024-07-17 13:18:07', '2024-05-10', 'P4701', '24-06349-05-09', '', 0.00, 513.00, 107.73, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 620.73, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100524-GK+tbbLgR4W7o-032', '1b2e7b7a-2a62-4da2-aefe-4f12db7918c6', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100524-GK%2BtbbLgR4W7o-032&s=KOL2024&nf=P4701&i=620.73&cr=222', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5026, 1, 75, 2, 0, NULL, 0, '2024-05-09 13:06:10', '2024-05-10 09:31:31', '2024-05-10', 'P4697', '24-06350-05-09', 'Horario de martes a viernes de 10 a 19 h', 0.00, 142.50, 29.93, 0.00, 0, 0.00, 0.00, 'Calle Beato Gálvez 9, bajo', 'Valencia', 'Valencia', '46007', 'España', 172.43, 0, '2024-05-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100524-XlNNgbivPhXLP-036', '9cf6f5f3-9318-406b-8ba3-6c9a3c8a17e3', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100524-XlNNgbivPhXLP-036&s=KOL2024&nf=P4697&i=172.43&cr=073', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5027, 1, 444, 2, 0, NULL, 0, '2024-05-09 15:45:58', '2024-05-10 09:35:54', '2024-05-10', 'P4698', '24-06351-05-09', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'Antziola 9,3ºdcha', 'Hernani', 'Gipuzkoa', '20120', 'España', 28.39, 0, '2024-05-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100524-RntF3kKAmbl3i-200', '53769c47-6f5c-4579-82d9-dde42d8693b8', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100524-RntF3kKAmbl3i-200&s=KOL2024&nf=P4698&i=28.39&cr=087', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(5028, 1, 587, 2, 0, NULL, 0, '2024-05-09 17:23:40', '2024-05-10 09:42:11', '2024-05-10', 'P4699', '24-06352-05-09', '', 0.00, 108.30, 29.34, 0.00, 0, 0.00, 38.00, 'Hoofdweg 2', 'Godlinze', '', '9908PB', 'Países Bajos', 169.39, 0, '2024-05-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100524-Ndvt3MByc5iW2-197', '05329c84-abc0-4360-967b-1b078ffb19c0', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100524-Ndvt3MByc5iW2-197&s=KOL2024&nf=P4699&i=169.39&cr=138', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5029, 1, 373, 2, 0, NULL, 0, '2024-05-09 22:12:02', '2024-05-10 09:45:38', '2024-05-10', 'P4700', '24-06353-05-09', '', 0.00, 19.83, 4.93, 0.00, 0, 0.00, 4.40, 'MANZANEDO 55 1C', 'Don Benito', 'Badajoz', '06400', 'España', 28.39, 0, '2024-05-09 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100524-XzAIEc2rCEtuL-159', 'b6319484-cbbe-4683-bf92-495372895457', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100524-XzAIEc2rCEtuL-159&s=KOL2024&nf=P4700&i=28.39&cr=090', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5030, 1, 65, 2, 1, 'falta lote de un producto', 5025, '2024-05-10 09:26:13', '2024-07-17 13:18:16', '2024-05-10', 'R78', 'P4701 RECT.', '', 0.00, 513.00, 107.73, 0.00, 0, 0.00, 0.00, '', '', '', '', '', 620.73, 0, '0000-00-00 00:00:00', '', '', 0, 1, 1, 'TBAI-B20930640-100524-jBaJxLQqlqchR-230', 'e454a086-65b2-4495-b04a-3a800e54c37c', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100524-jBaJxLQqlqchR-230&s=KOL2024&nf=R78&i=-620.73&cr=015', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '0', 0, 0, 0, 0, 0, '', 0, 1),
(5031, 1, 40, 2, 0, NULL, 0, '2024-05-10 07:27:10', '2024-05-10 09:48:07', '2024-05-10', 'P4703', '24-06354-05-10', 'el martes cerrado ,y el lunes por la mañana tambien', 0.00, 85.50, 17.96, 0.00, 0, 0.00, 0.00, 'plaza valencia 7 intxaurrondo ,donostia ', 'Donostia-San Sebasti', 'Gipuzkoa', '20015', 'España', 103.46, 0, '2024-05-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-100524-bwQXlVuYE0b29-201', '470cc88a-7347-465b-8dac-38dc700fc932', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100524-bwQXlVuYE0b29-201&s=KOL2024&nf=P4703&i=103.46&cr=008', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5032, 1, 65, 1, 0, NULL, 0, '2024-05-10 09:28:51', '2024-07-17 13:18:25', '2024-05-10', 'P4702', '', '', 0.00, 513.00, 107.73, 0.00, 0, 0.00, 0.00, 'Calle Balmes 133', 'BARCELONA', 'BARCELONA', '08008', 'ESPAÑA', 620.73, 0, '2024-05-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100524-g+NR/rkTUsKwm-187', '76b28d69-ee49-46f6-964c-ebf561b4114d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100524-g%2BNR%2FrkTUsKwm-187&s=KOL2024&nf=P4702&i=620.73&cr=162', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5033, 1, 696, 1, 0, NULL, 0, '2024-05-10 10:33:06', '2024-05-10 10:33:47', '2024-05-10', 'P4704', '', '', 0.00, 489.06, 102.70, 0.00, 0, 0.00, 0.00, 'CALLE TITANIO 28B', 'VALLADOLID', 'VALLADOLID', '47012', 'ESPAÑA', 591.76, 0, '2024-05-10 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-100524-YoWcAhTHzucV3-249', '33f06578-519a-4f73-ba8c-b504fdc36965', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-100524-YoWcAhTHzucV3-249&s=KOL2024&nf=P4704&i=591.76&cr=216', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5034, 1, 190, 3, 0, NULL, 0, '2024-05-10 10:36:15', '2024-07-23 11:40:52', '2024-05-10', '', 'Consumo interno', '', 0.00, 89.56, 18.81, 0.00, 0, 0.00, 0.00, 'Illumbe 3', 'Donostia-San Sebasti', 'Gipuzkoa', '20011', 'España', 108.37, 0, '2024-05-10 00:00:00', '', '', 1, 1, 1, '', NULL, '', '', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
INSERT INTO `orders` (`id_order`, `gid`, `id_customer`, `order_type`, `corrective`, `corrective_description`, `id_order_parent`, `creation_date`, `modification_date`, `order_date`, `code`, `name`, `description`, `discount`, `subtotal`, `vat`, `total_discount`, `surcharge`, `surcharge_total`, `shipping_costs`, `address`, `city`, `province`, `pc`, `country`, `total`, `payd`, `payment_date`, `payment_code`, `payment_form`, `order_status`, `payment_method`, `status`, `tbai`, `tbai_kubibai`, `tbai_url`, `tbai_qr`, `tbai_cancelled`, `correos_id`, `correos_creation_date`, `correos_etiqueta`, `correos_etiqueta_tipo`, `correos_mensaje`, `correos_recogida`, `correos_producto`, `correos_largo`, `correos_ancho`, `correos_alto`, `correos_peso`, `correos_estado`, `correos_estado_text`, `restocking`, `closed`) VALUES
(5035, 1, 810, 2, 0, NULL, 0, '2024-05-10 14:22:28', '2024-05-13 09:08:33', '2024-05-13', 'P4705', '24-06355-05-10', '', 0.00, 63.15, 13.26, 0.00, 0, 0.00, 0.00, 'Calle El Sol 14 1C', 'Tordesillas', 'Valladolid', '47100', 'España', 76.41, 0, '2024-05-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130524-USKgqxQJIKF3a-199', '5c59f9bb-f7bb-49af-8ac1-41dfb7b04b78', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130524-USKgqxQJIKF3a-199&s=KOL2024&nf=P4705&i=76.41&cr=046', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5036, 1, 533, 2, 0, NULL, 0, '2024-05-10 16:28:54', '2024-05-13 09:12:03', '2024-05-13', 'P4706', '24-06356-05-10', '', 0.00, 39.66, 9.09, 0.00, 0, 0.00, 4.40, 'Clara campoamor, num 2 esc. C  1-4', 'Gavà', 'Barcelona', '08850', 'España', 52.39, 0, '2024-05-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130524-BHz4In08DF3yA-210', 'abe6bd5c-5a63-4dba-a2c3-1843891a8888', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130524-BHz4In08DF3yA-210&s=KOL2024&nf=P4706&i=52.39&cr=048', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5037, 1, 174, 2, 0, NULL, 0, '2024-05-10 20:38:27', '2024-05-13 09:15:15', '2024-05-13', 'P4707', '24-06357-05-10', '', 0.00, 228.00, 47.88, 0.00, 0, 0.00, 0.00, 'C/Cervantes 13', 'Santander', 'Cantabria', '39001', 'España', 275.88, 0, '2024-05-10 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130524-BenM12uJTCRvb-038', '7fa5c842-30ba-4ae3-9bd0-6d6fb23c186d', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130524-BenM12uJTCRvb-038&s=KOL2024&nf=P4707&i=275.88&cr=096', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5038, 1, 111, 2, 0, NULL, 0, '2024-05-11 08:47:59', '2024-05-13 09:17:20', '2024-05-13', 'P4708', '24-06358-05-11', '', 0.00, 114.00, 23.94, 0.00, 0, 0.00, 0.00, 'c/ Loza, nº1 piso 7b', 'Ansoáin', 'Navarra', '31013', 'España', 137.94, 0, '2024-05-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130524-FfMeL1kP/U4rR-053', 'd29e0066-3ba3-4ac0-bf7e-f567f09ca514', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130524-FfMeL1kP%2FU4rR-053&s=KOL2024&nf=P4708&i=137.94&cr=233', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5039, 1, 71, 2, 0, NULL, 0, '2024-05-11 13:53:45', '2024-05-13 09:23:07', '2024-05-13', 'P4713', '24-06359-05-11', '', 0.00, 101.78, 21.37, 0.00, 0, 0.00, 0.00, 'Lugar de Lagarei 13 vilalonga', 'Sanxenxo', 'Pontevedra', '36990', 'España', 123.15, 0, '0000-00-00 00:00:00', '', '', 3, 3, 1, 'TBAI-B20930640-130524-oMSDaTaiYquxD-206', '6bf3db76-df42-4447-a5a9-b4c23eddda75', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130524-oMSDaTaiYquxD-206&s=KOL2024&nf=P4713&i=123.15&cr=082', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1),
(5040, 1, 1268, 2, 0, NULL, 0, '2024-05-11 15:59:13', '2024-05-13 09:32:19', '2024-05-13', 'P4709', '24-06360-05-11', '', 0.00, 21.66, 5.31, 0.00, 0, 0.00, 4.40, 'Calle Playa de Bolonia 9', 'Jerez de la Frontera', 'Cádiz', '11406', 'España', 30.61, 0, '2024-05-11 00:00:00', '', '', 3, 1, 1, 'TBAI-B20930640-130524-NztoinjEJEoww-169', '9be02181-7979-4d61-8682-c60d91c466e4', 'https://tbai.egoitza.gipuzkoa.eus/qr/?id=TBAI-B20930640-130524-NztoinjEJEoww-169&s=KOL2024&nf=P4709&i=30.61&cr=131', '[BLOB]', 0, '', '0000-00-00 00:00:00', '', 1, '', '0000-00-00', '61', 0, 0, 0, 0, 0, '', 1, 1);
