(48546,274,'Christopher Najar','006937-052025',45,3,'Aeropuerto de Cobano at 1:40pm','A la par de Banana Beach','99992',3,40.00,40.00,'2025-05-16','Cobrar $40 cliente ',NULL,1),(48547,15,'Sofia Yatsyuk','006938-052025',76,1,'Barcelo Palacio SJO at 6:00am','MTZ Anamaya Resort','0709',1,60.00,48.00,'2025-05-17','Credito',NULL,1),(48548,15,'Christine Wang','006939-052025',78,1,'Hampton by Hilton SJO Airport','MTZ Anamaya Resort','0710',2,120.00,96.00,'2025-05-17','Credito',NULL,1),(48550,16446,'Merrier  Benzakour','006940-052025',71,1,'Somos Hostel','SJO Airport','00100001040000023529',2,120.00,114.00,'2025-05-16','Paid CCAT Link',NULL,1),(48551,149,'Susanne Streidl','006941-052025',5,1,'El Patio Britt Cafe LIR Airport ','Nosara Sunrise Coffee ','00100001040000023530',2,100.00,95.00,'2025-05-22','Paid CCAT Link',NULL,1),(48552,16305,'Susanne Streidl','006942-052025',4,1,'Cabañas Lamaite','Santa Teresa Soul ','1001',1,60.00,48.00,'2025-05-15','Credito',NULL,1),(48553,149,'Angus Goodwin	','006943-052025',20,1,'Griss Lodge at 6:20am  ','LIR Municipal Bus Station','00100001040000023531',2,120.00,114.00,'2025-05-16','Paid CCAT Link',NULL,1),(48554,274,'Emanuel Delgado','006944-052025',20,1,'Cosechas ST','Santa Cruz BN','1102',2,60.00,60.00,'2025-05-15','Cobrar 30000 Cliente 8707-1782‬',NULL,1),(48555,16187,'Friederike Cloer','006945-052025',70,1,'Believe Surf & Yoga at 6:30am','SJO Gran Hotel Costa Rica','110096',1,60.00,48.00,'2025-05-16','Crédito ',NULL,1),(48556,149,'Asia Zrihen','006946-052025',60,2,'Arenal Rooms La Fortuna at 7:45am','SJO Airport','00100001040000023532',2,180.00,170.00,'2025-05-15','Paid CCAT Link',NULL,1),(48557,16462,'Lorrey Artavia','006947-052025',20,1,'Entrada Las Brisas San Isidro','Cafe de Paris Nosara','1400',1,60.00,57.00,'2025-05-25','Paid Office Cash',NULL,1),(48558,16462,'Lorrey Artavia','006948-052025',3,1,'Cafe de Paris','Las Brisas San Isidro ST','1405',1,60.00,57.00,'2025-05-27','Paid Office Cash',NULL,1),(48559,16424,'Brittney Escovedo','006949-052025',6,1,'Nandu Apartments','Entrance Botanika Suites Santa Teresa','165278',2,120.00,96.00,'2025-05-15','Credito',NULL,1),(48560,16462,'Christian Latuszek','006950-052025',6,1,'Gollo Villarreal Tama at 8:50am','Argdivan Beach Hostel Samara','00100001040000023533',1,50.00,47.00,'2025-05-15','Paid CCAT Link',NULL,1),(48561,82,'Miguel','006951-052025',20,1,'Oficina Tropical Tours','Tamarindo','006951',1,60.00,48.00,'2025-05-15','Cobrar $48 al cliente *pago cc en la oficina -w*',NULL,1),(48562,16462,'Guy Michalovich ','006952-052025',71,1,'Alamo Car Rental','SJO Airport','00100001040000023534',1,60.00,57.00,'2025-05-15','Paid CCAT Link',NULL,1),(48563,149,'MARIA GUADALUPE MARTINEZ','006953-052025',60,2,' Hotel Milan SJO at 8:00am','Manuel Antonio Wide Mouth Frog Hotel ','00100001040000023535',7,364.00,354.00,'2025-05-22','Paid by CCAT Link',NULL,1),(48564,16200,'Carlos Gomez','006954-052025',22,1,'Barcelo Tambor','SJO Airport ','006954',2,72.00,72.00,'2025-05-16','Credito',NULL,1),(48566,274,'Deisy','006956-052025',28,1,'Camping Victor Cordero','Liberia Centro','006956',2,60.00,60.00,'2025-05-15','Cobrar 30mil al cliente Reserva Oslin',NULL,1),(48567,16462,'Shauni Schoonbrood','006957-052025',3,1,'Become Nosara at 8am ','Hotel El Cerro Liberia','00100001040000023539',1,50.00,47.00,'2025-05-15','Paid by CCAT Link',NULL,1),(48569,16446,'Vahid Hedley Rezvani','006959-052025',20,1,'Osa santa teresa at 6:30 am ','Tamarindo center','00100001040000023540',2,120.00,114.00,'2025-05-16','Paid by CCAT Link',NULL,1),(48570,16132,'Mireia Blasco','006960-052025',78,1,'SJO Airport Restaurante El Malinche','Wild Sun Rescue Center Cabuya','006960',1,60.00,48.00,'2025-06-02','Cobrar $60 al cliente PEN COMMI ',NULL,1),(48571,16263,'Mattheus Mulder','006961-052025',70,1,'Sabores de mi Tierra ','SJO Airport ','006961',2,120.00,96.00,'2025-05-16','Cobrar $96 a Lost Boyz',NULL,1),(48572,16446,'Marisa Alpers','006962-052025',3,1,' The Nomadic Hotel at 8:00 am','ESO Santa Teresa ','00100001040000023542',1,60.00,57.00,'2025-05-16','Paid by CCAT Link',NULL,1),(48573,16446,'Victoriya Gortchakova','006963-052025',5,1,'Liberia Airport patio cafe',' Barcelo Tambor ','00100001040000023543',2,120.00,114.00,'2025-05-16','Paid by CCAT Link',NULL,1),(48574,274,'Lucas Salazar','006964-052025',9,1,'Tambor Airport','LIR Center ','0931',1,30.00,30.00,'2025-05-16','Cobrar 15.000 Cliente ',NULL,1),(48575,16300,'Cindy Jones','006965-052025',4,1,'Flor de Coco','LIR Airport ','006965',1,50.00,40.00,'2025-05-17','Cobrar $40 al cliente ',NULL,1),(48576,16446,'Taylor Budnik','006966-052025',60,2,'Casa Vitality Nosara at 7:30 am','Liberia Airport','00100001040000023544',2,180.00,170.00,'2025-05-16','Paid by CCAT Link',NULL,1),(48577,16446,'Alberto J Carballo Ali','006967-052025',6,1,'CASA MUBA TAMARINDO at 8:40 am','Hotel luz de luna  santa teresa','00100001040000023545',1,60.00,57.00,'2025-05-16','Paid by CCAT Link',NULL,1),(48578,558,'Lara Fink','006968-052025',4,1,'Tico Adventure Lodge Samara','ICO Living Hostel Entrance Santa Teresa','44036',1,60.00,48.00,'2025-05-16','Credito',NULL,1),(48579,149,'Avery Remillard','006969-052025',70,1,' Entrance out Zeneidas Surf Garden Santa Teresa at 6:30 am','SJO Costa Rica Backpackers Hostel ','00100001040000023547',1,60.00,57.00,'2025-05-19','Paid by CCAT Link',NULL,1),(48580,16200,'Diego Rodriguez tel. 85283203','006970-052025',76,1,'Teatro Nacional SJO','Barcelo Tambor ','006970',3,108.00,108.00,'2025-05-16','Credito',NULL,1),(48581,16200,'Diego Rodriguez tel. 85283203','006971-052025',119,1,'Barcelo Tambor','Teatro Nacional SJO','006971',3,108.00,108.00,'2025-05-19','Credito',NULL,1),(48582,16446,'Brice Underwood','006972-052025',60,2,'Roses playa pelada Nosara at 10:00 am ','Hotel Adventure Los ARCOS SAN JOSE','00100001040000023548',1,297.00,287.00,'2025-05-16','Paid by CCAT Link',NULL,1),(48583,16446,'Collin Crowe','006973-052025',20,1,'Entrance out Surf Paradise','Casa Pura Surf hostel Tamarindo','00100001040000023549',1,60.00,57.00,'2025-05-16','Paid by CCAT Link lleva tabla de 6th',NULL,1),(48584,16446,'Sarah Cruz','006974-052025',60,2,' Hotel Westin Reserva conchal GTE at 8:00 am','Liberia Airport','00100001040000023550',4,120.00,114.00,'2025-07-08','Paid by CCAT Link',NULL,1),(48585,16446,'Jasmine D Montrond Lopes','006975-052025',70,1,'Zeenidas surf garden hotel at 6:45 am','Hilton SJO Sabana ','00100001040000023551',1,60.00,57.00,'2025-05-17','Paid by CCAT Link',NULL,1),(48586,16462,'Joseph Kiracho Opio	','006976-052025',79,1,'Dennys alajuela at 2:30 pm','House of Somos Santa Teresa','00100001040000023552',1,60.00,57.00,'2025-05-27','Paid by CCAT Link',NULL,1),(48587,274,'Nicole Campos  +506 7282 9908','006977-052025',78,1,'SJO Airport Restaurante El Malinche','Santa Teresa Centro ','006977',1,30.00,30.00,'2025-05-16','Cobrar 15mil al cliente local',NULL,1),(48588,16446,'Taylor McAllister','006978-052025',45,3,'Tropico Latino santa teresa at 7am','Horse Project calle pura vida Montezuma','00100001040000023553',1,40.00,35.00,'2025-05-16','Paid by CCAT Link',NULL,1),(48589,16446,'Taylor McAllister','006979-052025',45,3,'Indiana Horse Project calle pura vida Montezuma at 1:00 pm','Santa Teresa Hotel Tropico Latino','00100001040000023553',1,40.00,35.00,'2025-05-16','Paid by CCAT Link',NULL,1),(48590,16446,'Catalina Claus','006980-052025',60,2,'Liberia Airport flight west jest 2002 at 1:00 pm','Casa Terra hostel samara','00100001040000023554',1,140.00,130.00,'2025-05-16','Paid by CCAT Link',NULL,1),(48591,22,'Frede Hoyes ','006981-052025',4,1,'Argdivan Beach Hostel','ESO Santa Teresa','006981',1,60.00,48.00,'2025-05-16','Credito',NULL,1),(48592,16462,'Tess Kienberger','006982-052025',71,1,'Entrance out Zeneidas Surf Garden','Costa Rica Backpackers SJO','00100001040000023555',1,60.00,57.00,'2025-05-16','Paid CCAT Link',NULL,1),(48593,16462,'Madeleine Goulet','006983-052025',79,1,'Dennys Rest. Alajuela at 2:45pm','Salty Enthusiasts Santa Teresa','00100001040000023556',1,60.00,57.00,'2025-05-31','Paid CCAT Link',NULL,1),(48594,16462,' Elina Sundqvist','006984-052025',70,1,'Super Ronnys 1','SJO Airport','00100001040000023557',1,60.00,57.00,'2025-05-17','Paid CCAT Link',NULL,1),(48595,16462,'John DiPrinzio','006985-052025',71,1,'Outsite Santa Teresa','SJO Airport','00100001040000023558',1,60.00,57.00,'2025-05-16','Paid Paypal',NULL,1),(48596,16446,'Lia Gerig','006986-052025',20,1,'Salty Enthusiasts','Nicaraguan Border','00100001040000023559',3,225.00,214.00,'2025-05-16','Paid CCAT Link',NULL,1),(48597,274,'Roberro','006987-052025',20,1,'Frente hotel Franks Place','Liberia ','9103',1,30.00,30.00,'2025-05-16','Cobrar 15mil al cliente ',NULL,1),(48599,16462,' Loek van Etten','006989-052025',6,1,'Hotel Botella de Leche','Zeneidas Surf Garden, Santa Teresa','00100001040000023560',1,60.00,57.00,'2025-05-16','Paid CCAT Link',NULL,1),(48600,16462,'Audrey Lammers','006990-052025',60,2,'Liberia Airport Flight at XX ','Lagarta Lodge Nosara','00100001040000023561',2,180.00,170.00,'2025-06-02','Paid Paypal',NULL,1),(48601,16446,'Alexandra Wester','006991-052025',6,1,'Pangas Beach Club at 8:45am','Hotel Green Sanctuary Nosara','00100001040000023562',1,50.00,47.00,'2025-05-17','Paid Paypal',NULL,1),(48602,16446,' David Campbell','006992-052025',60,2,'Soil samara at 9:00 am','Liberia Airport','00100001040000023563',1,140.00,130.00,'2025-05-20','Paid CCAT Link',NULL,1),(48603,16446,'Camile Jade','006993-052025',20,1,'Anis Bowls & Salad','10 Pies Nosara','00100001040000023564',2,120.00,114.00,'2025-05-31','Paid CCAT Link',NULL,1),(48605,16424,'Jed Varnedoe','006995-052025',45,3,'Cobano Airport at 3:45pm Vuelo: PEN','Laloon Luxury Suites Santa Teresa','166468',2,60.00,60.00,'2025-08-01','Credito',NULL,1),(48606,16424,'Jed Varnedoe','006996-052025',45,3,'Laloon Luxury Suites Santa Teresa at 8:30 am','Cobano Airport','166470',2,60.00,60.00,'2025-08-10','Credito',NULL,1),(48607,16462,'Michael San Felipe','006997-052025',3,1,'Casa Vitality','Hotel Mar Rey Tamarindo','00100001040000023565',2,100.00,95.00,'2025-05-17','Paid CCAT Link',NULL,1),(48608,16462,'Fredy Carmona ','006998-052025',9,1,'Entrada Panica','Gollo Villareal Tamarindo','1006',1,60.00,57.00,'2025-05-17','Cobrar 30mil al Cliente',NULL,1),(48609,16200,'Carlos Ramos tel+525541260761','006999-052025',59,2,'SJO Airport at 11:26 am Vuelo: Volaris 3938','Barcelo Tambor ','006999',2,220.00,220.00,'2025-05-17','Credito',NULL,1),(48610,16200,' Carlos Ramos tel+525541260761','007000-052025',22,1,'Barcelo Tambor','Radisson San Jose','007000',2,72.00,72.00,'2025-05-23','Credito',NULL,1),(48611,274,'Mayli Moya','007001-052025',70,1,'Casa Zorro San Isidro','SJO Airport ','007001',1,30.00,30.00,'2025-05-17','Cobrar 15mil al cliente local Reserva Leandro',NULL,1),(48612,4,'David ','007002-052025',74,1,'Frente a Horse Spirit Healing','Casa Aldea Hotel SJO','007002',3,180.00,144.00,'2025-05-18','Cobrar $180 al Cliente PEN COMMI',NULL,1),(48613,16462,'Krystal Horta','007003-052025',59,2,'Blue Mist Santa Teresa at 4:45am','SJO Airport','00100001040000023566',2,265.00,255.00,'2025-05-17','Paid Paypal',NULL,1),(48614,16462,'Jason Powell','007004-052025',60,2,'Beach Front Bahia Samara at 7:15am ','Liberia Airport','00100001040000023567',2,140.00,130.00,'2025-05-17','Paid CCAT Link',NULL,1),(48615,16462,'Jacob Li','007005-052025',60,2,'Dreamcatcher Hotel Santa Teresa at 5am','Liberia Airport','00100001040000023568',2,290.00,280.00,'2025-05-17','Paid CCAT Link',NULL,1),(48616,16187,'Julian Melles','007006-052025',20,1,'Believe Surf and Yoga Santa Teresa ','Tamarindo Sunshine','110094',1,60.00,48.00,'2025-05-17','PAID by CCAT $67.80 PEN COMMI',NULL,1),(48617,16462,'Hariel Concepcion ','007007-052025',20,1,'Super Muralla','Pura Pizza Nosara','1212',1,60.00,57.00,'2025-05-17','Paid Office Cash',NULL,1),(48618,16462,'Hariel Concepcion','007008-052025',3,1,'Hostel Nosara','Super Muralla Santa Teresa','1215',1,60.00,57.00,'2025-05-18','Paid Office Cash',NULL,1),(48619,16505,'Stefano','007009-052025',70,1,'Entrance out Casa Chachalaca MP','SJO Airport','007009',1,60.00,48.00,'2025-05-19','Cobrar $48 Cliente',NULL,1),(48620,16512,'Nathalie Merrin','007010-052025',20,1,'Eat Street Restaurante ','Hostel Dodero Liberia','007010',2,120.00,96.00,'2025-06-05','PEN Deposit $108,48',NULL,1),(48621,16462,'Celine Primiceri','007011-052025',3,1,'Organico Bakery','Taco Corner Rest, Santa Teresa','00100001040000023569',2,120.00,114.00,'2025-05-17','Paid CCAT Link',NULL,1),(48622,16462,'Tana Ososki','007012-052025',60,2,'Liberia Airport El Patio Cafe Britt ( SW 691 ) at 3pm','Hotel entre dos aguas Samara ','00100001040000023570',1,140.00,130.00,'2025-05-20','Paid CCAT Link',NULL,1),(48623,274,'Brittany Castrillo ','007013-052025',76,1,'Barcelo Palacio SJO at 6:00am','Santa Teresa Centro ','007013',1,0.00,0.00,'2025-05-18','CPL Aut. Oslin',NULL,1),(48624,274,'Vanessa','007014-052025',124,1,'Banco nacional Cobano','Liberia','3131',1,20.00,20.00,'2025-05-17','Cobrar 10 mil cliente reserva Leandro',NULL,1),(48625,15,'Emily De Souza','007015-052025',72,1,'Anamaya Resort at 6:50am','Tamarindo In the Shade Hotel','1501',1,60.00,48.00,'2025-05-17','Credito',NULL,1),(48626,16132,'Marena Kraft','007016-052025',78,1,'Fairfield by Marriott SJO Airport','Cabuya Wild Sun Rescue','1503',1,60.00,48.00,'2025-06-15','Cobrar $60 Cliente & Pend Comi',NULL,1),(48627,149,'Janaya Elizabeth Slack	','007017-052025',5,1,'El Patio Britt Cafe LIR Airport ','Nosara Casa Emilia ','00100001040000023571',2,100.00,95.00,'2025-05-23','Paid CCAT Link',NULL,1),(48628,149,'Dylan Carter','007018-052025',70,1,'Entrance out Alma Tropical MP','Alajuela Holiday Inn Express','00100001040000023572',2,120.00,114.00,'2025-05-19','Paid CCAT Link',NULL,1),(48629,16462,'Nora Gombrii','007019-052025',60,2,'Good Life Lodge Samara at 12:00pm ','Nosara Airport','00100001040000023573',1,70.00,65.00,'2025-05-17','Paid CCAT Link',NULL,1),(48630,149,'Audrey Lammers	','007020-052025',3,1,'Lagarta Lodge at 7:45am ','Mal Pais Casa Chameleon','00100001040000023574',2,130.00,123.00,'2025-06-05','Paid Paypal',NULL,1),(48631,149,'Audrey Lammers	','007021-052025',45,3,'Casa Chamaleon Malpais at X:00am/pm','Cobano Airport COB','00100001040000023574',2,130.00,123.00,'2025-06-08','Paid Paypal',NULL,1),(48632,16200,'Guillermo Cabrer','007022-052025',60,2,'Barcelo Tambor Resort at 12:00pm','Tamarindo Occidental','1640',2,200.00,200.00,'2025-05-17','Credito Directores Barcelo VIP Prado Aut Oslin',NULL,1),(48633,149,'Michaela Nahum ','007023-052025',70,1,'Entrance out Banana Beach ','La Fortuna Tabacon Resort & Spa','00100001040000023575',3,225.00,210.00,'2025-06-15','Paid CCAT Link',NULL,1),(48634,149,'Vahid Hedley','007024-052025',20,1,'ESO Hostel','Tamarindo La Oveja Negra ','00100001040000023576',2,120.00,114.00,'2025-05-17','Paid CCAT Link',NULL,1),(48635,274,'Yorleni Vargas ','007025-052025',72,1,'Hostel El Parque','LIR Subway Rest.','1845',2,60.00,60.00,'2025-08-19','Cobrar 30.000 Cliente Reserva Oslin',NULL,1),(48636,16446,'Benjamin Gabin	','007026-052025',79,1,'Dennys Rest. Alajuela at 2:30pm ','Mal Pais Entrance down Casa Chameleon','00100001040000023577',2,120.00,114.00,'2025-05-21','Paid CCAT Link',NULL,1),(48637,149,'Aleksandra Kat','007027-052025',45,3,'Cobano Airport COB at 4:45pm','Santa Teresa Drift Bar ','00100001040000023578',1,40.00,35.00,'2025-05-17','Paid CCAT Link',NULL,1),(48638,149,'Malena Castillo	','007028-052025',3,1,'Rinde Mas Nosara at 7:40am','LIR Municipal Bus Station','00100001040000023579',1,50.00,47.00,'2025-05-18','Paid CCAT Link',NULL,1),(48639,16424,'Brittney Escovedo','007029-052025',45,3,'Banana Beach Hotel Santa Teresa at 1:30pm','Cobano Airport COB','166510',2,40.00,40.00,'2025-05-18','Credito',NULL,1),(48640,149,'Eden Rachkovsky','007030-052025',8,1,'La Alianza Gas Station','Santa Teresa Cabinas Playa Sta Teresa','00100001040000023580',1,50.00,47.00,'2025-05-17','Paid CCAT Link',NULL,1),(48641,149,'Sarah Cull','007031-052025',20,1,'Somos Hostel','LIR Airport','00100001040000023581',1,60.00,57.00,'2025-05-17','Paid CCAT Link',NULL,1),(48642,149,'Maurits Koomen','007032-052025',6,1,'Mai Ke Kai Surf House','Samara Patio Colonial ','00100001040000023582',2,100.00,95.00,'2025-05-17','Paid Paypal',NULL,1),(48643,149,'Marisa Alpers	','007033-052025',70,1,'ESO Hostel','SJO Hotel Casa 69','00100001040000023583',1,60.00,57.00,'2025-05-18','Paid Paypal',NULL,1),(48644,16424,'Sydney','007034-052025',59,2,'Casa Privada Delicias COB at 10:00am','Jaco Tres Almendros','0919',1,240.00,240.00,'2025-05-17','Credito',NULL,1),(48645,149,'Imke Weerning','007035-052025',76,1,'Hotel Trianon ','MTZ Luminosa Hostel ','00100001040000023584',1,60.00,57.00,'2025-08-31','Paid CCAT Link',NULL,1),(48646,149,'Emma Charles	','007036-052025',60,2,'El Jardin del Eden Hotel Tamarindo at 9:45am','LIR Airport','00100001040000023585',1,120.00,110.00,'2025-05-18','Paid CCAT Link',NULL,1),(48647,16458,'Bennett Pickhardt','007037-052025',76,1,'Radisson Hotel SJO at 5:20am','Santa Teresa Super Muralla','1025',2,120.00,96.00,'2025-05-18','Paid Deposit Net ',NULL,1),(48648,149,'Raymond Rogers','007038-052025',3,1,'La Negra Surf Hotel ','LIR Airport','00100001040000023586',1,50.00,47.00,'2025-05-19','Paid CCAT Link',NULL,1),(48649,16132,'Noelia Sánchez ','007039-052025',78,1,'Malinche Rest. SJO Airport','Cabuya Wild Sun Rescue','1145',2,80.00,80.00,'2025-05-18','Cobrar $80 Cliente Staff Directors',NULL,1),(48650,22,'Emilie','007040-052025',4,1,'Argdivan Beach Hostel','Santa Teresa Somos Cafe','1147',1,60.00,48.00,'2025-05-18','Credito',NULL,1),(48651,16424,'Simran Patel ','007041-052025',60,2,'Casa de Playa Selva Mar Jaco at 8:30am','SJO Airport','167076',7,220.00,220.00,'2025-05-18','Credito',NULL,1),(48652,149,'Oscar Back','007042-052025',11,2,'SJO Airport Flight UA 2312 at 7:15am ','Santa Teresa OSA Rest.','00100001040000023587',2,340.00,330.00,'2025-05-24','Paid CCAT Link',NULL,1),(48653,16200,'Jimena Campos','007043-052025',76,1,'Barcelo Palacio SJO at 6:00am','Tambor Barcelo Resort','1308',2,90.00,72.00,'2025-05-18','Paid CCAT Link',NULL,1),(48654,16200,'Jimena Campos','007044-052025',22,1,'Barcelo Tambor Resort','SJO Barcelo Palacio','1308',2,90.00,72.00,'2025-05-23','Credito',NULL,1),(48655,4,'Virgit','007045-052025',72,1,'Tree Monkeys Hotel','LIR Airport','1357',1,60.00,48.00,'2025-05-28','Cobrar $48 MTZ Tours Alex',NULL,1),(48656,149,'Xanthe Campbell	','007046-052025',6,1,'Oro Del Sol 14 at 8:30am ','Samara Lofts ','00100001040000023588',1,50.00,47.00,'2025-05-18','Paid CCAT Link',NULL,1),(48657,16159,'Antonio Costa','007047-052025',6,1,'Casa Pura Vida Surf Hostel','Santa Teresa Somos Cafe','1433',1,60.00,48.00,'2025-05-18','Cobrar $48 Hostel CPVSH',NULL,1),(48658,246,'Julia Roberts','007048-052025',6,1,'Villas Macondo','Santa Teresa El Gato Rojas Hostel','1453',1,60.00,48.00,'2025-05-19','Cobrar $48 Villas Macondo',NULL,1),(48659,16424,'Vinicius','007049-052025',70,1,'ESO Hostel','SJO Airport','167081',1,60.00,48.00,'2025-05-18','Credito',NULL,1),(48660,149,'Shauni Schoonbrood','007050-052025',5,1,'Hotel El Cerro LIR at 8:30am','Nosara Become ','00100001040000023589',1,50.00,47.00,'2025-05-18','Paid CCAT Link',NULL,1),(48661,4,'Maria','007051-052025',72,1,'MTZ Tours Office','Nosara Verde - Casa Selva','1613',2,120.00,96.00,'2025-05-19','Cobrar $96 MTZ Tours Alex',NULL,1),(48662,149,'Daniella Lerner	','007052-052025',70,1,'Cabinas Playa Santa Teresa','SJO Airport','00100001040000023590',1,60.00,57.00,'2025-05-20','Paid CCAT Link',NULL,1),(48663,149,'Thomas Maheras','007053-052025',59,2,'SJO Airport Flight UA 1080 at 11:45am ','Santa Teresa Alma Villas','00100001040000023591',1,240.00,230.00,'2025-05-18','Paid CCAT Link',NULL,1),(48664,274,'Krissya Rojas ','007054-052025',6,1,'Bar La Media Vuelta','Santa Teresa Kooks Bar','1718',1,30.00,30.00,'2025-05-18','Cobrar 15.000 Cliente 8903-5959‬',NULL,1),(48665,149,'Alizee Arbo','007055-052025',70,1,'Entrance out Zeneidas Surf Garden','SJO Costa Rica Backpackers','00100001040000023592',1,60.00,57.00,'2025-05-19','Paid CCAT Link',NULL,1),(48666,22,'Enrico','007056-052025',20,1,'Lapoint Surfcamp','Tamarindo Center','1911',1,60.00,48.00,'2025-05-19','Credito',NULL,1),(48667,149,'Hailey Fedus	','007057-052025',6,1,'Gollo Villarreal Tama at 8:50am','Samara Apartamento Matapalo','00100001040000023593',1,50.00,47.00,'2025-05-18','Paid CCAT Link',NULL,1),(48668,2,'Philip Yes','007058-052025',72,1,'Hotel El Jardin','Tamarindo Boho Hotel','21909',1,60.00,48.00,'2025-05-18','Credito',NULL,1),(48669,149,'Loek van Etten	','007059-052025',20,1,'Entrance out Zeneidas Surf Garden','Tamarindo La Botella de Leche','00100001040000023594',1,60.00,57.00,'2025-05-18','Paid CCAT Link',NULL,1),(48670,16159,'Shahan Flaksman','007060-052025',6,1,'Casa Pura Vida Surf Hostel','Santa Teresa Somos Cafe','2006',1,60.00,48.00,'2025-05-18','Cobrar $48 Hostel CPVSH',NULL,1),(48671,149,'Sylvain Duguay	','007061-052025',72,1,'Luminosa MTZ Hotel ','LIR Dodero Hostel ','00100001040000023595',2,120.00,114.00,'2025-05-24','Paid CCAT Link',NULL,1),(48672,149,'Avigail Felsenshtein','007062-052025',70,1,'Super Ronnys 2 ','SJO Embajada Espana','00100001040000023596',1,60.00,57.00,'2025-05-20','Paid CCAT Link',NULL,1),(48673,16436,'Annalena Bruno ','007063-052025',4,1,'Police Station','MTZ Luminosa Hostel','0742',1,60.00,50.00,'2025-05-18','Cobrar $60 Cliente & Pend Comi',NULL,1),(48674,149,'Miguel Loures','007064-052025',45,3,'Riverside Apartments Santa Teresa at 9:45am ','Cobano Airport COB ','00100001040000023597',2,40.00,35.00,'2025-05-20','Paid CCAT Link',NULL,1),(48675,149,'Josie Petersen','007065-052025',60,2,'Casa Surf Playa Grande GTE at 8:45am ','LIR Airport','00100001040000023598',8,220.00,210.00,'2025-05-19','Paid CCAT Link Address Pick Up by Email',NULL,1),(48676,149,'Olivia Weale	','007066-052025',60,2,'SJO Airport Flight LA650 at 3:35pm','Nosara Villa de Pacifico ','00100001040000023599',2,295.00,285.00,'2025-06-19','Paid CCAT Link',NULL,1),(48677,149,'Mathilde Garandeau','007067-052025',20,1,'Eat Street Rest.  ','LIR Hampton by Hilton GTE ','00100001040000023600',2,120.00,114.00,'2025-05-19','Paid CCAT Link',NULL,1),(48678,274,'Nahomy Hurtado','007068-052025',20,1,'Mini Super Las Palmeras','Nosara Cafe de Paris','0956',2,80.00,80.00,'2025-05-19','Cobrar 40.000 Cliente Reserva Big Boss',NULL,1),(48679,149,'Saminas Saleheen	','007069-052025',60,2,'El Patio Cafe LIR Airport at 12:00pm','Samara Bahia Hotel ','00100001040000023601',2,140.00,130.00,'2025-05-18','Paid Paypal',NULL,1),(48680,16446,'Kurt Douglas Kueffner +1 (612) 325-3293','007070-052025',70,1,'Mal Pais Surf Camp main entrance ','Hampton by Hilton, SJO','00100001040000023602',1,60.00,57.00,'2025-05-27','pay cc in the office Quiere servicio de la tarde a las 12:15 pm.',NULL,1),(48681,16446,'Alberto Carballo','007071-052025',70,1,'hotel luz de luna santa teresa Main entrance AT 6:45 am','Terminal MEPE San Jose','00100001040000023603',1,60.00,57.00,'2025-05-20','Paid by CCAT Link',NULL,1),(48682,16159,'Kaylee','007072-052025',6,1,'Casa Pura Vida Surf Hostel','Santa Teresa Centro','007072',1,60.00,48.00,'2025-05-19','Crédito ',NULL,1),(48683,16598,'Chris','007073-052025',45,3,'Banana Beach at 9:30am','Aeropuerto Cobano ','881',3,40.00,40.00,'2025-05-19','Cobrar $40 al cliente',NULL,1),(48684,16446,'Kiera Campbell','007074-052025',60,2,'villa Nova Tamarindo at 8:00 am','Liberia Airport','00100001040000023604',2,120.00,114.00,'2025-05-19','Paid by CCAT Link',NULL,1),(48685,16570,'José Luis Junes','007075-052025',8,1,'Bomba Alianza ','Lifeguard Santa Teresa ','98',1,20.00,20.00,'2025-05-19','Crédito ',NULL,1);

--
-- Table structure for table `unit_type`
--

CREATE TABLE `unit_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `status` tinyint(1) DEFAULT 1,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='TRIAL';

--
-- Dumping data for table `unit_type`
--

INSERT INTO `unit_type` VALUES (1,'Servicios Profesionales','Sp',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(2,'Metro','m',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(3,'Kilogramo','kg',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(4,'Segundo','s',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(5,'Ampere','A',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(6,'Mol','mol',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(7,'Candela','cd',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(8,'metro cuadrado','m²',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(9,'metro cúbico','m³',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(10,'metro por segundo','m/s',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(11,'metro por segundo cuadrado','m/s²',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(12,'1 por metro','1/m',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(13,'kilogramo por metro cúbico','kg/m³',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(14,'ampere por metro cuadrado','A/m²',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(15,'ampere por metro','A/m',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(16,'mol por metro cúbico','mol/m³',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(17,'candela por metro cuadrado','cd/m²',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(18,'uno (indice de refracción)','1',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(19,'radián','rad',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(20,'estereorradián','sr',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(21,'hertz','Hz',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(22,'newton','N',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(23,'pascal','Pa',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(24,'Joule','J',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(25,'Watt','W',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(26,'coulomb','C',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(27,'volt','V',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(28,'farad','F',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(29,'ohm','?',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(30,'siemens','S',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(31,'weber','Wb',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(32,'tesla','T',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(33,'henry','H',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(34,'grado Celsius','°C',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(35,'lumen','lm',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(36,'lux','lx',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(37,'Becquerel','Bq',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(38,'gray','Gy',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(39,'sievert','Sv',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(40,'katal','kat',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(41,'pascal segundo','Pa·s',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(42,'newton metro','N·m',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(43,'newton por metro','N/m',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(44,'radián por segundo','rad/s',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(45,'radián por segundo cuadrado','rad/s²',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(46,'watt por metro cuadrado','W/m²',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(47,'joule por kelvin','J/K',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(48,'joule por kilogramo kelvin','J/(kg·K)',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(49,'joule por kilogramo','J/kg',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(50,'watt por metro kevin','W/(m·K)',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(51,'joule por metro cúbico','J/m³',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(52,'volt por metro','V/m',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(53,'coulomb por metro cúbico','C/m³',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(54,'coulomb por metro cuadrado','C/m²',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(55,'farad por metro','F/m',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(56,'henry por metro','H/m',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(57,'joule por mol','J/mol',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(58,'joule por mol kelvin','J/(mol·K)',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(59,'coulomb por kilogramo','C/kg',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(60,'gray por segundo','Gy/s',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(61,'watt por estereorradián','W/sr',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(62,'watt por metro cuadrado estereorradián','W/(m²·sr)',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(63,'katal por metro cúbico','kat/m³',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(64,'minuto','min',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(65,'hora','h',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(66,'día','d',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(67,'grado','º',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(68,'minuto','min',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(69,'segundo','s',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(70,'litro','L',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(71,'tonelada','t',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(72,'neper','Np',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(73,'bel','B',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(74,'electronvolt','eV',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(75,'unidad de masa atómica unificada','u',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(76,'unidad astronómica','ua',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(77,'Unidad','Unid',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(78,'Galón','Gal',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(79,'Gramo','g',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(80,'Kilometro','km',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(81,'pulgada','ln',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(82,'centímetro','cm',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(83,'mililitro','mL',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(84,'Milímetro','mm',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(85,'Onzas','Oz',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(86,'Se debe indicar la descripción de la medida a utilizar','Otros',NULL,1,'2021-01-05 11:44:17','2021-01-05 11:44:17'),(87,'PIC','PIC',NULL,1,'2021-01-28 08:49:04','2021-01-28 08:49:04'),(88,'PAQ','PAQ',NULL,1,'2021-01-28 08:49:04','2021-01-28 08:49:04'),(89,'UND','UND',NULL,1,'2021-01-28 08:49:04','2021-01-28 08:49:04'),(90,'BULT','BULT',NULL,1,'2021-01-28 08:49:04','2021-01-28 08:49:04'),(91,'CJ','CJ',NULL,1,'2021-01-28 18:30:40','2021-01-28 18:30:40'),(92,'CAJ','CAJ',NULL,1,'2021-01-29 14:16:38','2021-01-29 14:16:38'),(93,'UN','UN',NULL,1,'2021-02-19 19:33:25','2021-02-19 19:33:25');

--
-- Table structure for table `vehicles`
--

CREATE TABLE `vehicles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `placa` varchar(15) NOT NULL,
  `year` varchar(4) NOT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `placa` (`placa`),
  KEY `estado_id` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `vehicles`
--

INSERT INTO `vehicles` VALUES (2,'PB3177','2019',1),(3,'PB3045','2018',1),(7,'PB2939','2017',1),(8,'PB3178','2019',1),(11,'BKG684','2016',1),(13,'PB3269','2020',1);

--
-- Table structure for table `xml_imported`
--

CREATE TABLE `xml_imported` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `currency_code` varchar(255) DEFAULT NULL,
  `currency_change_value` decimal(18,5) DEFAULT NULL,
  `invoice_key` varchar(255) DEFAULT NULL,
  `invoice_activity_code` varchar(255) DEFAULT NULL,
  `invoice_consecutive_number` varchar(255) DEFAULT NULL,
  `invoice_date` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `entry_id` int(11) DEFAULT NULL,
  `xml_file` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `supplier_identification` varchar(255) DEFAULT NULL,
  `supplier_identification_type` varchar(255) DEFAULT NULL,
  `supplier_name` varchar(255) DEFAULT NULL,
  `supplier_province_code` varchar(255) DEFAULT NULL,
  `supplier_canton_code` varchar(255) DEFAULT NULL,
  `supplier_district_code` varchar(255) DEFAULT NULL,
  `supplier_barrio_code` varchar(255) DEFAULT NULL,
  `supplier_other_signals` longtext DEFAULT NULL,
  `supplier_phone_country_code` varchar(255) DEFAULT NULL,
  `supplier_phone` varchar(255) DEFAULT NULL,
  `supplier_email` varchar(255) DEFAULT NULL,
  `invoice_condition_sale_code` varchar(255) DEFAULT NULL,
  `invoice_credit_time_code` varchar(255) DEFAULT NULL,
  `invoice_payment_method_code` varchar(255) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `branch_office_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_xml_imported_branch_office1` (`branch_office_id`),
  KEY `fk_xml_imported_entry1` (`entry_id`),
  KEY `fk_xml_imported_user1` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci COMMENT='TRIAL';

--
-- Dumping data for table `xml_imported`
--



