Sign In
Create Account
This topic is locked
Website - opendatacenter.com.br
Format - .SQL
Size - 1.7GB
Date - 2023
All Rows - 1kk
Headers :
INSERT INTO `payment` (`Id`, `ServiceId`, `CardNumber`, `AuthorizationCode`, `Gateway`, `BrandName`, `NSU`, `TotalCurrency`, `TotalPaid`, `ReturnCode`, `TransactionDate`, `TransactionId`, `HolderDocument`, `ExpirationMonth`, `ExpirationYear`, `Installments`, `HolderAddress`, `HolderAddressCity`, `HolderAddressComplement`, `HolderAddressDistrict`, `HolderAddressNumber`, `HolderAddressState`, `HolderAddressZipCode`, `HolderName`, `HolderPhoneDDI`, `HolderPhoneDDD`, `HolderPhoneNumber`, `PaymentMessage`) VALUES
INSERT INTO `service` (`Id`, `BookingId`, `ReservationId`, `ServiceId`, `ServiceType`, `ServiceDate`, `FinalServiceDate`, `ReservationDate`, `Title`, `SystemStatus`, `SupplierStatus`, `SupplierCurrency`, `SupplierPrice`, `SellingCurrency`, `SellingPrice`, `Markup`, `ComissionCurrency`, `ComissionValue`, `IsComissionRetained`, `ConversionRate`, `DestinationId`, `DestinationName`, `CountryCode`, `BookingDescription`, `SupplierId`, `SupplierName`, `SupplierReservationCode`, `PaymentDeadLine`, `PaymentDate`, `PaymentStatus`, `VoucherObservation`, `VoucherUrl`, `IsOffline`, `CreationUserId`, `CreationUserName`, `CreationUserLogin`, `CreationUserEmail`, `Peculiarities`) VALUES
Sample :
INSERT INTO `service` (`Id`, `BookingId`, `ReservationId`, `ServiceId`, `ServiceType`, `ServiceDate`, `FinalServiceDate`, `ReservationDate`, `Title`, `SystemStatus`, `SupplierStatus`, `SupplierCurrency`, `SupplierPrice`, `SellingCurrency`, `SellingPrice`, `Markup`, `ComissionCurrency`, `ComissionValue`, `IsComissionRetained`, `ConversionRate`, `DestinationId`, `DestinationName`, `CountryCode`, `BookingDescription`, `SupplierId`, `SupplierName`, `SupplierReservationCode`, `PaymentDeadLine`, `PaymentDate`, `PaymentStatus`, `VoucherObservation`, `VoucherUrl`, `IsOffline`, `CreationUserId`, `CreationUserName`, `CreationUserLogin`, `CreationUserEmail`, `Peculiarities`) VALUES (10, 8, '30065', '39090', 0, '2022-05-21 00:00:00', '2022-05-22 00:00:00', '2022-05-21 11:43:07', 'Ibis São José SC - Rua Domingos André Zanini 333 ', 0, 0, 'BRL', '161.44', 'BRL', '168.17', '0.040000', 'BRL', '0.00', 0, '1.00', '1060828', 'Sao Jose', 'BR', '', '101', 'Omnibees', 'RES003051-8969|8969#2022-05-21#2022-05-22', '2022-05-21 21:00:00', '2022-05-21 11:50:31', 1, ' \r\n SERVIÇO DE EMERGENCIA EXCLUSIVO CLIENTE EUROPLUS:\r\nSábados, Domingos, Feriados e fora do horário de expediente \r\nemergências são através do Número Emergencial: (51) 4042-1990\r\n\r\n**Atenção podem ser cobradas taxas governamentais, taxas de resort, turismo ou meio ambiente diretamente pelo hotel no check-out**', 'http://europluscash.cangooroo.net/Voucher/VoucherNovo.aspx?ReservaID=PFPvpdf%2fCAXZBvabsbFSRkE3ioAXn3m1tuW%2bFrVu8rs%3d&ServicoId=Ul9uq9lXSzP4JYLsl%2frS0n4svHwA3UrMtveQwJerxCI%3d&TipoServico=f%2fn7aDWZSOC%2bmRKOYhrhrDXDosrsQTdj2IxGEPJpJ9o%3d&u=GodwMsneKN7RkmtxEB8NRpB%2bQENIU0fK8%2f%2bJa5DFYnc%3d&s=L6Jj63/lqNZmiymC9c6vGlUAvq4g43/lLKXpE+sAc34=', 0, 33803, 'Gaston Di Filippo Menendez', 'gaston.europlus', '[email protected]', '{\"HotelId\":\"300559\",\"HotelName\":\"Ibis São José SC\",\"HotelCategory\":\"\",\"HotelAddress\":\"Rua Domingos André Zanini 333 \",\"BoardDescription\":\"n/d-RA1\",\"RoomDescription\":\"DBC\",\"HotelPhone\":\"55 48/32111200\",\"HotelConfirmationNumber\":null,\"SupplierHotelId\":\"8969\",\"CountryId\":\"BR\",\"CheckinHour\":\"12h00\",\"CheckoutHour\":\"12h00\"}'), (11, 9, '30064', '39089', 0, '2022-05-24 00:00:00', '2022-05-26 00:00:00', '2022-05-21 11:23:46', 'B Hotel Brasília - SHN Q. 5 BL J Lote L ', 0, 0, 'BRL', '1390.42', 'BRL', '1448.35', '0.040000', 'BRL', '0.00', 0, '1.00', '1262440', 'Brasilia', 'BR', '', '101', 'Omnibees', 'RES019111-6873|6873#2022-05-24#2022-05-26', '2022-05-21 00:00:00', '2022-05-21 11:30:08', 1, ' \r\n SERVIÇO DE EMERGENCIA EXCLUSIVO CLIENTE EUROPLUS:\r\nSábados, Domingos, Feriados e fora do horário de expediente \r\nemergências são através do Número Emergencial: (51) 4042-1990\r\n\r\n**Atenção podem ser cobradas taxas governamentais, taxas de resort, turismo ou meio ambiente diretamente pelo hotel no check-out**', 'http://europluscash.cangooroo.net/Voucher/VoucherNovo.aspx?ReservaID=puim13gZfBLUox9aKY4apiWIRRFm71Qyo%2f26KGBzzLY%3d&ServicoId=TWw8bB6E3gfKOMowBbPvoUbHmu7RLJCPK8kT63cXdUM%3d&TipoServico=f%2fn7aDWZSOC%2bmRKOYhrhrDXDosrsQTdj2IxGEPJpJ9o%3d&u=GodwMsneKN7RkmtxEB8NRpB%2bQENIU0fK8%2f%2bJa5DFYnc%3d&s=L6Jj63/lqNZmiymC9c6vGlUAvq4g43/lLKXpE+sAc34=', 0, 31735, 'Tamara Feldman', '[email protected]', '[email protected]', '{\"HotelId\":\"1387057\",\"HotelName\":\"B Hotel Brasília\",\"HotelCategory\":\"\",\"HotelAddress\":\"SHN Q. 5 BL J Lote L \",\"BoardDescription\":\"Bed and Breakfast-Operadoras\",\"RoomDescription\":\"B Room Twin\",\"HotelPhone\":\"+556139622000\",\"HotelConfirmationNumber\":null,\"SupplierHotelId\":\"6873\",\"CountryId\":\"BR\",\"CheckinHour\":\"15h00\",\"CheckoutHour\":\"12h00\"}'), (14, 12, '30061', '39086', 0, '2022-05-27 00:00:00', '2022-05-28 00:00:00', '2022-05-20 17:43:16', 'FAST SLEEP GUARULHOS By Slaviero Hotéis - ROD HELIO SMITH s n ', 0, 0, 'BRL', '288.19', 'BRL', '300.20', '0.040000', 'BRL', '0.00', 0, '1.00', '1021952', 'Guarulhos', 'BR', '', '351', 'Iterpec', '417473-449943', '2022-05-20 21:00:00', '2022-05-20 17:48:36', 1, 'Ref. Number:RES002043-13740|13740#2022-05-27#2022-05-28 \r\n SERVIÇO DE EMERGENCIA EXCLUSIVO CLIENTE EUROPLUS:\r\nSábados, Domingos, Feriados e fora do horário de expediente \r\nemergências são através do Número Emergencial: (51) 4042-1990\r\n\r\n**Atenção podem ser cobradas taxas governamentais, taxas de resort, turismo ou meio ambiente diretamente pelo hotel no check-out**', 'http://europluscash.cangooroo.net/Voucher/VoucherNovo.aspx?ReservaID=3nirw2wM7a%2fMm3K%2baqFTpWObqK4rYPUjNjYHuj1NDm0%3d&ServicoId=NigB8sgpwZEt7%2foTjQou8hhjXHsmU69qZReFbNvQU28%3d&TipoServico=f%2fn7aDWZSOC%2bmRKOYhrhrDXDosrsQTdj2IxGEPJpJ9o%3d&u=GodwMsneKN7RkmtxEB8NRpB%2bQENIU0fK8%2f%2bJa5DFYnc%3d&s=L6Jj63/lqNZmiymC9c6vGlUAvq4g43/lLKXpE+sAc34=', 0, 33803, 'Gaston Di Filippo Menendez', 'gaston.europlus', '[email protected]', '{\"HotelId\":\"536765\",\"HotelName\":\"FAST SLEEP GUARULHOS By Slaviero Hotéis \",\"HotelCategory\":\"\",\"HotelAddress\":\"ROD HELIO SMITH s n \",\"BoardDescription\":\"Sem café da manhã\",\"RoomDescription\":\"Cabine Cama Beliche 24 horas -\",\"HotelPhone\":\"11 2445 2356\",\"HotelConfirmationNumber\":null,\"SupplierHotelId\":\"536765\",\"CountryId\":\"BR\",\"CheckinHour\":\"12h00\",\"CheckoutHour\":\"12h00\"}'), (15, 13, '30060', '39085', 0, '2022-05-21 00:00:00', '2022-05-22 00:00:00', '2022-05-20 16:34:00', 'Palace Praia Hotel - Praça Republica do Libano n 40', 0, 0, 'BRL', '256.15', 'BRL', '266.82', '0.040000', 'BRL', '0.00', 0, '1.00', '1030693', 'Florianopolis', 'BR', '', '185', 'HotelDo', '18085158402', '2022-05-20 21:00:00', '2022-05-20 17:39:20', 1, ' \r\n **Atenção podem ser cobradas taxas governamentais, taxas de resort, turismo ou meio ambiente diretamente pelo hotel no check-out**\r\n\r\nSERVIÇO DE EMERGENCIA EXCLUSIVO CLIENTE EUROPLUS:\r\nSábados, Domingos, Feriados e fora do horário de expediente\r\nemergências são através do Número Emergencial: 4003-4484\r\n\r\n**TARIFA CONFIDENCIAL**\r\n\r\n**Attention government fees, resort fees, tourism or the environment may be charged directly by the hotel at check-out**\r\n\r\nEUROPLUS EXCLUSIVE EMERGENCY SERVICE:\r\nSaturdays, Sundays, Holidays and outside office hours\r\nemergencies are through the Emergency Number: (005551) 4003-4484\r\n\r\n**CONFIDENTIAL RATE**\r\nSpecial offer: YesAté 15 de desconto \r\n', 'http://europluscash.cangooroo.net/Voucher/VoucherNovo.aspx?ReservaID=57gIGBbAcfH%2b6tcTUsm9rFwVV56BRIglqiEG7GnLjZU%3d&ServicoId=tGgyDA6MP9atW8RRHoowNpNwJvne0F%2fqln0cpSBbalg%3d&TipoServico=f%2fn7aDWZSOC%2bmRKOYhrhrDXDosrsQTdj2IxGEPJpJ9o%3d&u=GodwMsneKN7RkmtxEB8NRpB%2bQENIU0fK8%2f%2bJa5DFYnc%3d&s=L6Jj63/lqNZmiymC9c6vGlUAvq4g43/lLKXpE+sAc34=', 0, 36747, 'RAISSA OLIVEIRA MACHADO', 'raissa.europlus', '[email protected]', '{\"HotelId\":\"1062078\",\"HotelName\":\"Palace Praia Hotel\",\"HotelCategory\":\"\",\"HotelAddress\":\"Praça Republica do Libano n 40\",\"BoardDescription\":\"Café da manhã com buffet incluido\",\"RoomDescription\":\"Quarto de Luxo com Vista Lateral ao Mar\",\"HotelPhone\":\"00554832664111\",\"HotelConfirmationNumber\":null,\"SupplierHotelId\":\"10424964\",\"CountryId\":\"BR\",\"CheckinHour\":\"14h00\",\"CheckoutHour\":\"11h00\"}'), (16, 14, '30059', '39084', 0, '2022-06-09 00:00:00', '2022-06-13 00:00:00', '2022-05-20 16:20:01', 'Windsor Copa Hotel - Avenida N. S. de Copacabana 335 Copacabana', 0, 0, 'BRL', '1286.67', 'BRL', '1340.28', '0.040000', 'BRL', '0.00', 0, '1.00', '1003960', 'Rio de Janeiro BR', 'BR', '', '308', 'Expedia By Iterpec', '417313-449777', '2022-05-20 21:00:00', '2022-05-20 16:21:19', 1, 'Ref. Number:9168310992536-1945751199 \r\n SERVIÇO DE EMERGENCIA EXCLUSIVO CLIENTE EUROPLUS:\r\nSábados, Domingos, Feriados e fora do horário de expediente \r\nemergências são através do Número Emergencial: (51) 4042-1990\r\n\r\n**Atenção podem ser cobradas taxas governamentais, taxas de resort, turismo ou meio ambiente diretamente pelo hotel no check-out**\r\nSpecial offer: Yes', 'http://europluscash.cangooroo.net/Voucher/VoucherNovo.aspx?ReservaID=Mr%2fqoNQuleULw8883McMnAimycnCxDEbfbYnoUYVne0%3d&ServicoId=5vrEusyJSozygpkONpcgGmnS7SyFEOc1q9MNKWOKcKg%3d&TipoServico=f%2fn7aDWZSOC%2bmRKOYhrhrDXDosrsQTdj2IxGEPJpJ9o%3d&u=GodwMsneKN7RkmtxEB8NRpB%2bQENIU0fK8%2f%2bJa5DFYnc%3d&s=L6Jj63/lqNZmiymC9c6vGlUAvq4g43/lLKXpE+sAc34=', 0, 36747, 'RAISSA OLIVEIRA MACHADO', 'raissa.europlus', '[email protected]', '{\"HotelId\":\"267059\",\"HotelName\":\"Windsor Copa Hotel\",\"HotelCategory\":\"\",\"HotelAddress\":\"Avenida N. S. de Copacabana 335 Copacabana\",\"BoardDescription\":\"Café da manhã\",\"RoomDescription\":\"Standard com Cama Casal (1 cama de casal)\",\"HotelPhone\":\"(21) 2195-5300\",\"HotelConfirmationNumber\":null,\"SupplierHotelId\":\"267059\",\"CountryId\":\"BR\",\"CheckinHour\":\"14h00\",\"CheckoutHour\":\"12h00\"}'), (17, 15, '30058', '39083', 0, '2022-06-21 00:00:00', '2022-06-23 00:00:00', '2022-05-20 15:05:21', 'São Paulo Tatuapé Affiliated by Meliá TRYP Tatuape - Rua Serra de Juréa 351 ', 0, 0, 'BRL', '492.27', 'BRL', '512.78', '0.040000', 'BRL', '0.00', 0, '1.00', '1010502', 'Sao Paulo', 'BR', '', '101', 'Omnibees', 'RES020182-1876|1876#2022-06-21#2022-06-23', '2022-05-23 00:00:00', '2022-05-20 18:10:24', 1, ' \r\n SERVIÇO DE EMERGENCIA EXCLUSIVO CLIENTE EUROPLUS:\r\nSábados, Domingos, Feriados e fora do horário de expediente \r\nemergências são através do Número Emergencial: (51) 4042-1990\r\n\r\n**Atenção podem ser cobradas taxas governamentais, taxas de resort, turismo ou meio ambiente diretamente pelo hotel no check-out**\r\nSpecial offer: YesMais noites, mais Descontos! 5% \r\n', 'http://europluscash.cangooroo.net/Voucher/VoucherNovo.aspx?ReservaID=70hcRYo5byHf4L4PSyqGlTd5CHp8GEDSctMIsc4eMu4%3d&ServicoId=FtRTOjMgfbeUSMLR8HS9PnWuKK5DDyanYpeHAUXe0Mw%3d&TipoServico=f%2fn7aDWZSOC%2bmRKOYhrhrDXDosrsQTdj2IxGEPJpJ9o%3d&u=GodwMsneKN7RkmtxEB8NRpB%2bQENIU0fK8%2f%2bJa5DFYnc%3d&s=L6Jj63/lqNZmiymC9c6vGlUAvq4g43/lLKXpE+sAc34=', 0, 33746, 'Leandra', 'leandra.moveturismo', '[email protected]', '{\"HotelId\":\"80759\",\"HotelName\":\"São Paulo Tatuapé Affiliated by Meliá TRYP Tatuape \",\"HotelCategory\":\"\",\"HotelAddress\":\"Rua Serra de Juréa 351 \",\"BoardDescription\":\"Bed and Breakfast-Promocional Operadoras - Com Café\",\"RoomDescription\":\"STANDARD ROOM TWIN (SOMENTE 2 CAMAS SOLTEIRO)\",\"HotelPhone\":\"0055 1129424900\",\"HotelConfirmationNumber\":null,\"SupplierHotelId\":\"1876\",\"CountryId\":\"BR\",\"CheckinHour\":\"\",\"CheckoutHour\":\"\"}'),
(1652, 'BIATOUR VIAGENS E TURISMO - AIRMET ', '08178997000186', '[email protected]', '', '11 4152-3265', 24),
(1653, 'CAMPUS VIAGENS E TURISMO LTDA', '03905926000114', '[email protected]', '', '48-323-36525', 19),
(1654, 'AGENCIA DE VIAGENS TAMBAU TURISMO LTDA', '08469232000103', '[email protected]', '', '19-36731024', 26),
(1655, 'OESTUR PASSAGENS E TURISMO LTDA', '85188670000136', '[email protected]', '', '49-33220596', 16),
(1656, 'WL ZACARIOTTO VIAGENS ME- WWE', '68991116000173', '[email protected]', '', '19-38917043', 18),
(1657, 'MOREIRA E BECK- MBTUR AGENCIA DE VIAGENS', '07699140000149', 'mbtur@uol.com.br', '', '54-33431651', 7),
(1658, 'TITANIUM TURISMO LTDA', '01111569000197', '[email protected]', '', '41-32757977', 3),
(1659, 'CI CENTRAL DE INTERCAMBIO-MAIS INTERC.', '06255595000102', '[email protected]', '', '47-30357696', 33),
(1660, 'INTEX BRASIL ACESSORIA-W.INTEX TRAVEL', '05908923000160', '[email protected]', '', '44-30315907', 16),
(1661, 'M.M AGENCIA DE VIAGEM E TURISMO LTDA ME', '05727352000167', '[email protected]', '', '44-30311260', 16),
(1662, 'GUIA DO MUNDO TURISMO EIRELI', '57358723000184', '[email protected]', '', '12-303300011', 38),
(1663, 'HANAMIH TURISMO LTDA', '12824727000172', '[email protected]', '', '19-33683660', 18),
(1664, 'NMT VIAGENS E TURISMO LTDA', '74408287000120', '[email protected]', '', '19-32554524', 18),
(1665, 'EJH TURISMO-CLUBE TURISMO RJ CORP CENTRO', '16611255000120', '[email protected]', '', '21-22207569', 6),
(1666, 'MORESCO E GONÇALVES CONSUL.TUR.LTDA.', '13868289000107', '[email protected]', '', '46-32255211', 16),
(1667, 'FAVINE VIAGENS E TURISMO LTDA-ME', '05515321000142', '[email protected]', '', '44-32268044', 13),
(1668, 'MUNDI VIAGENS E TURISMO LTDA-VOOGUE TUR', '09626226000177', '[email protected]', '', '49-33290004', 19),
(1669, 'DESCUBRA VIAGENS E TURISMO LTDA', '12598607000102', '[email protected]', '', '11-35881002', 38),
(1670, 'CONTINENTAL TOUR TURISMO E VIAGENS LTDA', '82222944000178', '[email protected]', '', '43-33245530', 16),
(1671, 'VASTUR AGÊNCIA DE VIAGENS E TURISMO LTDA', '00582586000140', '[email protected]', '', '19-32432589', 18),
(1672, 'BENVENUTO AGÊNCIA DE VIAGENS E TURISMO', '12967653000123', '[email protected]', '', '48-33659296', 1),
(1673, 'PLANO 1 VIAGENS E TURISMO', '10818818000170', '[email protected]', '', '41-30921062', 3),
(1674, 'SATELITE VIAGENS E TURISMO LTDA', '05048133000151', '[email protected]', '', '19-33968944', 18),
(1676, 'AROMAS TURISMO LTDA ME', '15047755000119', '[email protected]', '', '19-33049840', 18),
(1677, 'NAVARRO & MARTIN-CLUBE TURISMO STO AMARO', '17855476000107', '[email protected]', '', '11-23054297', 24),
(1678, 'WEB INFO - VIRACOPOS VIAGENS', '10419496000196', '[email protected]', '', '19-32291945', 18),
(1679, 'TURITALIA VIAGENS E TURISMO LTDA', '00749011000179', '[email protected]', '', '51-32243081', 1),
(1680, 'LUFE TURISMO LTDA- VALTRACTUR', '12930951000149', '[email protected]', '', '44-32218550', 16),
(1681, 'TV RUGONI OPERADORA-GRANDTOUR TURISMO', '17138502000186', 'financeiro@GrandTour.tur.br', '', '44-30310123', 16),
(1682, 'VIAGGI E TURISMO- AGÊNCIA DE VIAGENS', '04607197000182', '[email protected]', '', '54-32932595', 7),
(1683, 'ESTUR VIAGENS E TURISMO - AIRMET', '04403532000120', 'estur@uol.com.br', '', '011-38684323', 24),
[/code]
