(38812,149,'Travis Spencer','013762-102024',78,1,'Holiday Inn Express SJO Airport','Santa Teresa Don Johns Hostel','00100001040000017894',2,120.00,114.00,'2025-01-19','Paid CCAT Link',NULL,1),(38813,149,'Riki Poore','013763-102024',4,1,'Residencias Samara','TamaHostel & Glamping Tamarindo','00100001040000017895',1,50.00,47.00,'2024-10-31','Paid Paypal',NULL,1),(38814,16200,'Karla Marten tel.7268-8842','013764-102024',76,1,'Barcelo San Jose ','Barcelo Tambor ','013764',2,72.00,72.00,'2024-10-30','Credito ',NULL,1),(38815,16200,'Karla Marten tel.7268-8842','013765-102024',22,1,'Barcelo Tambor ','Barcelo San Jose ','013765',2,72.00,72.00,'2024-11-01','Credito ',NULL,1),(38816,16212,'Elizabeth','013766-102024',6,1,'Hotel Mar Rey Tamarindo','Guiones Nosara','013766',2,100.00,80.00,'2024-10-30','Cobrar $80 a Hotel Mar Rey Tamarindo',NULL,1),(38817,16462,'Gaute Ryan','013767-102024',70,1,'Habitat surf glamp','SJO Airport','00100001040000017896',2,120.00,114.00,'2024-10-30','Paid CCAT Link',NULL,1),(38818,149,'Riki Poore','013768-102024',6,1,'Tamahostel & Hostel','Samara Residencias','00100001040000017897',1,50.00,47.00,'2024-10-30','Paid Paypal',NULL,1),(38819,16462,'Abbie Swainson','013769-102024',60,2,'Nicaragua Border at 3pm','Sangregado Lodge, La Fortuna','00100001040000017898',2,280.00,270.00,'2024-11-16','Paid CCAT Link',NULL,1),(38820,274,'Nicole Campos  +506 7282 9908','013770-102024',70,1,'Trópico Latino Santa Teresa','SJO Airport','013770',1,30.00,30.00,'2024-11-01','Cobrar 15mil al cliente local (No Show)',NULL,1),(38821,16462,'Christer Anderson','013771-102024',5,1,'Liberia Airport El Patio Cafe','Good Munchies Rest Santa Teresa','00100001040000017899',1,60.00,57.00,'2024-11-01','Paid CCAT Link',NULL,1),(38822,16462,'Lynn Santiago','013772-102024',60,2,'Liberia Airport El Patio Cafe Britt ( UA 1512 ) at 1:08pm','Oasis Samara','00100001040000017900',1,125.00,115.00,'2024-12-07','Paid CCAT Link',NULL,1),(38823,16462,'Lynn Santiago','013773-102024',60,2,'Cabinas El Colibri Carrillo at 7am','Liberia Airport','00100001040000017901',1,125.00,115.00,'2024-12-13','Paid CCAT Link',NULL,1),(38824,16462,'Daniel Pries','013774-102024',78,1,' Fairfield by Marriott','Santeria Lodge Santa Teresa','00100001040000017902',2,120.00,114.00,'2025-01-15','Paid CCAT Link',NULL,1),(38825,149,'Kris Dmytrenko','013775-102024',4,1,'Samara Palm Lodge','Liberia Airport','00100001040000017903',1,50.00,47.00,'2024-11-02','Paid CCAT Link',NULL,1),(38826,274,'Fabiola Aleman +506 8739 9114','013776-102024',20,1,'Oficina Tropical Tours','Bomba la Alianza Nicoya','013776',1,30.00,30.00,'2024-10-31','Cobrar 15mil al cliente local',NULL,1),(38827,274,'Chad','013777-102024',45,3,'OSA Restaurant Santa Teresa at 3pm','Cobano Airport ','013777',1,40.00,40.00,'2024-10-31','Cobrar $40 al cliente Reserva Livo',NULL,1),(38828,16159,'Steve','013778-102024',6,1,'Casa Pura Vida Surf Hostel','Zeneidas Surf Garden Santa Teresa ','013778',1,50.00,40.00,'2024-10-31','Cobrar $40 a Casa Pura Vida Surf Hostel',NULL,1),(38829,16462,'Sean McDonald','013779-102024',60,2,'Liberia Airport El Patio Cafe Britt ( UA 1512 ) at 12:30md','Cala Luna Botique Hotel Tamarindo','00100001040000017904',2,120.00,110.00,'2024-10-31','Paid CCAT Link',NULL,1),(38832,16462,'Oliviero Arrigo','013782-102024',4,1,'Hotel Belvedere','Ten North Tamarindo','00100001040000017905',1,50.00,47.00,'2024-10-31','Paid CCAT Link',NULL,1),(38833,16462,'Raven ','013783-102024',124,1,'Bomba Vieja','Liberia Airport','1340',1,60.00,57.00,'2024-11-01','Paid Office CC',NULL,1),(38834,16387,'Maurice','013784-102024',78,1,'Rosa de America Alajuela ','Super Muralla Santa Teresa','013784',1,60.00,48.00,'2024-11-16','Credito ',NULL,1),(38835,16200,'Victoria Gonzalez ','013785-102024',76,1,'Barcelo Palacio SJO at 6:00am','Tambor Barcelo Resort','1520',3,135.00,108.00,'2024-12-01','Credito 8318-1869',NULL,1),(38836,16200,'Victoria Gonzalez ','013786-102024',22,1,'Barcelo Tambor Beach','SJO Barcelo Palacio','1520',3,135.00,108.00,'2024-12-03','Credito 8318-1869',NULL,1),(38837,257,'Joséphine Lominet','013787-102024',6,1,'Bar La Media Vuelta at 9:00am','Santa Teresa Eat Streets Rest','1610',3,150.00,120.00,'2024-10-31','Credito',NULL,1),(38838,16462,'Taren Bernardini	','013788-102024',70,1,'Focaccia Rest MalPais at 6:30am ','SJO Airport','00100001040000017908',1,60.00,57.00,'2024-11-01','Paid CCAT Link',NULL,1),(38839,149,'Joshua Shier	','013789-102024',60,2,'LIR Airport Flight UA 1737 at 5:30pm','Nosara Garza AirBnB','00100001040000017909',1,140.00,130.00,'2024-10-31','Paid CCAT Link Address Drop Off by Email',NULL,1),(38840,563,'Daniel Oshri','013790-102024',6,1,'House of Nomad ','Santa Teresa Hotel Luz de Luna','1835',2,100.00,80.00,'2024-10-31','Cobrar $80 Marco BJE',NULL,1),(38841,149,'Derek Ross Fisher	','013791-102024',4,1,'Samara Pacific Lodge  ','Hermosa GTE Hotel El Velero ','00100001040000017910',2,120.00,114.00,'2025-03-15','Paid CCAT Link',NULL,1),(38842,16462,'Brendon Daugherty','013792-102024',79,1,'Malinche Rest. SJO Airport at 3:15pm','Santa Teresa Eat Streets Rest','00100001040000017911',4,240.00,228.00,'2024-11-01','Paid CCAT Link',NULL,1),(38843,149,'Mary Deas','013793-102024',60,2,'Marina Flamingo GTE at 7:00am','SJO Airport','00100001040000017912',4,297.00,287.00,'2025-01-06','Paid CCAT Link',NULL,1),(38844,149,'Garrett Brock','013794-102024',5,1,'La Espuelas Hotel LIR at 8:35am ','Santa Teresa Las Piedras Rest. ','00100001040000017913',2,120.00,114.00,'2024-11-01','Paid CCAT Link',NULL,1),(38845,149,'Ling Du','013795-102024',60,2,'LIR Airport Flight B62733 at 12:00 pm','Nosara Bodhi Tree Resort','00100001040000017939',1,140.00,130.00,'2024-11-02','Paid CCAT Link ',NULL,1),(38846,15,'Lauren Crowther','013796-102024',88,1,'Anamaya Resort at 6:50am','Alajuela Hampton By Hilton SJO Airport','1020',1,60.00,48.00,'2024-11-02','Credito',NULL,1),(38847,15,'Jennifer Sweezey','013797-102024',72,1,'Anamaya Resort at 6:50am','LIR Airport & Hotel Hampton Inn ','1055',3,180.00,144.00,'2024-11-02','Credito',NULL,1),(38848,149,'Diemle Nguyen	','013798-102024',60,2,'LIR Airport Flight UA 1512 at 1:08pm ','Matapalo GTE Riu Hotel ','00100001040000017915',4,100.00,90.00,'2024-12-01','Paid CCAT Link',NULL,1),(38849,149,'Diemle Nguyen	','013799-102024',60,2,'Riu Hotel Matapalo GTE at 12:30pm','La Fortuna Hotel Roca Negra del Arenal','00100001040000017915',4,260.00,250.00,'2024-12-04','Paid CCAT Link',NULL,1),(38850,149,'Diemle Nguyen	','013800-102024',60,2,'Hotel Roca Negra del Arenal La Fortuna at 12:00pm','LIR Hilton Garden Inn GTE','00100001040000017915',4,260.00,250.00,'2024-12-08','Paid CCAT Link',NULL,1),(38851,16387,'Simon Jonatan','013801-102024',78,1,'Hotel Rosa de las Americas ','Santa Teresa Super Muralla','1150',2,120.00,96.00,'2024-11-10','Credito',NULL,1),(38852,149,'Mathias Allemann	','013802-102024',30,1,'Ginana Rest. Paquera at 8:00am','Samara Hostel Las Mariposas','00100001040000017916',1,60.00,57.00,'2024-11-01','Paid CCAT Link',NULL,1),(38853,149,'Julie Lefebvre	','013803-102024',4,1,'Las Palmeras Condominium','LIR Airport','00100001040000017918',1,50.00,47.00,'2024-11-06','Paid CCAT Link',NULL,1),(38854,149,'Joseph Cowen','013804-102024',5,1,'El Patio Britt Cafe LIR Airport','Nosara Cafe de Paris','00100001040000017919',1,50.00,47.00,'2024-11-01','Paid CCAT Link (No Show)',NULL,1),(38855,149,'Simon Grupp	','013805-102024',76,1,'Bee Suites Escalante SJO at 5:15am ','Santa Teresa Griss Lodge & Villas ','00100001040000017920',2,120.00,114.00,'2024-11-01','Paid CCAT Link',NULL,1),(38856,57,'Charlotte Wodland','013806-102024',78,1,'La Casita Parrillera Alajuela ','Santa Teresa Cabinas Playa Sta Teresa','14170',2,120.00,96.00,'2024-11-02','hotel pago neto a Leandro',NULL,1),(38860,274,'Middalia','013810-102024',124,1,'Bomba Vieja','LIR Airport','1502',1,30.00,30.00,'2024-11-01','Cobrar 15000 Cliente Local ',NULL,1),(38861,149,'Toni Schatz','013811-102024',60,2,'LIR Airport Flight JetBlue B6 897 at 1:00pm','Nosara The Gilded Iguana ','00100001040000017922',4,140.00,130.00,'2024-11-02','Paid CCAT Link',NULL,1),(38863,22,'Yola ','013813-102024',5,1,'Subway Liberia 8:40am','MalPais','013813',1,60.00,48.00,'2024-11-01','Crédito ',NULL,1),(38864,149,'Jack Sloan	','013814-102024',20,1,'Eat Street Rest.','Papagayo GTE Hotel Bosque Del Mar ','00100001040000017924',2,120.00,114.00,'2024-11-11','Paid CCAT Link',NULL,1),(38865,274,'Valeria','013815-102024',8,1,'La Alianza Gas Station','Santa Teresa Eat Streets Rest','1755',1,30.00,30.00,'2024-11-01','Cobrar 15000 Cliente Aut. Leandro',NULL,1),(38866,149,'Linea Whitelaw','013816-102024',6,1,'Selina Hostel','Santa Teresa Kooks Bar','00100001040000017925',1,60.00,57.00,'2024-11-01','Paid CCAT Link',NULL,1),(38867,274,'Sandra Arguedas +506 8413 3813','013817-102024',7,1,'Banco Nacional de Santa Cruz','Rancho Esperanza San Isidro ','013817',1,20.00,20.00,'2024-11-01','Cobrar 10mil al cliente local Oslin Approved',NULL,1),(38868,16462,'Kayla Roy','013818-112024',6,1,'Numa appartements Tamarindo ','Eat Street Rest, Santa Teresa','0814',3,180.00,171.00,'2024-11-01','Cobrar $180 al cliente',NULL,1),(38869,149,'Sridhar P Katta','013819-112024',59,2,'SJO Airport Flight UA 2448 at 10:25am','Tambor Barcelo Beach Resort ','00100001040000017926',2,240.00,230.00,'2024-11-01','Paid by CCAT Link',NULL,1),(38870,16462,'Trent A McCrerey','013820-112024',11,2,'SJO Airport Malinche Rest ( UA 2448 ) at 1:00 pm ','Miramar Santa Teresa','00100001040000017927',3,340.00,330.00,'2024-11-02','Paid by CCAT Link (llevan 2 tablas)',NULL,1),(38871,16446,'Warren King','013821-112024',49,1,'Hotel Villas Vilma, La Fortuna','Hotel Santa Teresa ','00100001040000017928',2,130.00,124.00,'2024-11-28','Paid by Paypal',NULL,1),(38872,16446,'Philip Baratt','013822-112024',6,1,'Casa Boaz Tamarindo','Hotel El Ramal Nosara ','00100001040000017929',1,50.00,47.00,'2024-11-04','Paid by CCAT Link',NULL,1),(38873,16200,'Shirley Estrada ','013823-112024',119,1,'Barcelo Tambor ','SJO Airport','013823',4,200.00,144.00,'2024-11-03','Credito ',NULL,1),(38874,16446,'Evan Hauth','013824-112024',6,1,'Casa Aura Tamarindo','Zeneidas Surf Garden Teresa','00100001040000017930',1,60.00,57.00,'2024-11-02','Paid by CCAT Link',NULL,1),(38875,16446,'Annabelle Debattista','013825-112024',20,1,'Eat Street Rest  Santa Teresa ','Nomadic Hotel Nosara ','00100001040000017931',1,60.00,57.00,'2024-11-02','Paid by CCAT Link',NULL,1),(38876,16446,'Indrani talapatra','013826-112024',60,2,'BlancoNejo Montezuma at 10:00 am','Samara Blue Iguana Hostel','00100001040000017932',4,260.00,250.00,'2025-01-20','Paid by CCAT Link',NULL,1),(38877,16446,'Indrani talapatra','013827-112024',60,2,'Blue Iguana Hostel Samara at 10am','Congos Hostel Y Camping, Playa Hermosa GTE','00100001040000017933',4,155.00,145.00,'2025-01-26','Paid by CCAT Link',NULL,1),(38878,16446,'Razmig Sandrik','013828-112024',5,1,'Hampton by Hilton Liberia Airport ','Hotel Luz de Luna Sta Teresa','00100001040000017934',1,60.00,57.00,'2024-12-31','Paid by CCAT Link',NULL,1),(38879,16446,'JACK BURGESS MCINTOSH','013829-112024',78,1,'Fairfield by Marriott SJO Airport Alajuela','Super Muralla Santa teresa ','00100001040000017935',1,60.00,57.00,'2024-11-02','Paid by CCAT Link',NULL,1),(38880,16446,'Marlene Caron','013830-112024',3,1,'Norte Nosara Hotel','Katana Rest Santa Teresa','00100001040000017936',1,60.00,57.00,'2024-11-04','Paid by CCAT Link',NULL,1),(38881,274,'Pamela Cruz tel +506 8309 8271','013831-112024',3,1,'Restaurante Almendros Nosara','Selina Norte Santa Teresa','013831',1,60.00,48.00,'2024-11-05','Cobrar $50 al cliente',NULL,1),(38882,16446,'Joseph E Cowen','013832-112024',5,1,'Patio Cafe Liberia Airport ','Destiny Cafe Nosara ','00100001040000017937',1,50.00,47.00,'2024-11-02','Paid by CCAT Link',NULL,1),(38883,16132,'Denise Segundo','013833-112024',74,1,'Wild Sun Rescue Center Cabuya','Fairfield By Marriott Alajuela','013833',1,60.00,48.00,'2024-11-10','Cobrar $60 al cliente PEND COMI',NULL,1),(38884,16446,'Michelle Pinard','013834-112024',3,1,'Selina Nosara','Super Hacienda Santa Teresa ','00100001040000017938',1,60.00,57.00,'2024-11-02','Paid by CCAT Link',NULL,1),(38885,16462,'Michael ','013835-112024',20,1,'Hotel Tropico Latino','Ten North Tamarindo','1440',2,120.00,114.00,'2024-11-02','Paid Office Cash',NULL,1),(38886,274,'Kalleth Barrantes +506 8435 1397','013836-112024',124,1,'Servicentro Cobano','Santa Cruz ','013836',1,30.00,30.00,'2024-11-02','Cobrar 15mil al cliente local',NULL,1),(38887,16462,' Jesse Smith','013837-112024',45,3,'Cobano Airport at 11:30am','Gimnasio Guardavidas Santa Teresa','00100001040000017940',1,40.00,35.00,'2024-11-07','Paid CCAT Link',NULL,1),(38888,16518,'Enola','013838-112024',20,1,'Eat Street Santa Teresa','Sunrise Coffee Nosara','013838',2,120.00,96.00,'2024-11-02','Cobrar $120 al cliente PEN COMMI ',NULL,1),(38889,16462,'Filipa Martins','013839-112024',70,1,'Eat Street Rest','SJO Airport','00100001040000017942',1,60.00,57.00,'2024-11-02','Paid CCAT Link (No Show)',NULL,1),(38890,16462,'Razmig Sandrik','013840-112024',71,1,'Hotel Luz de Luna','SJO Airport','00100001040000017943',1,60.00,57.00,'2025-01-05','Paid CCAT Link',NULL,1),(38891,16462,'Israel Fortin','013841-112024',60,2,'Hotel Brilla Sol Alajuela at 7am','El Nido jungle lodge Puerto Viejo Limon','00100001040000017944',5,340.00,323.00,'2024-11-03','Paid CCAT Link',NULL,1),(38892,16462,'Nicole Cheung','013842-112024',60,2,'Balcones del Pacifico Tamarindo at 10am','Dreams Lodge Monteverde','00100001040000017945',4,250.00,240.00,'2024-12-26','Paid CCAT Link',NULL,1),(38893,16462,'Nicole Cheung','013843-112024',60,2,'Chepita’s de la Fortuna at 12md','Melrost Airport Alajuela','00100001040000017946',3,180.00,170.00,'2025-01-03','Paid CCAT Link',NULL,1),(38894,149,'Vivienne Raab','013844-112024',45,3,'COB Airport at 4:00pm','Santa Teresa Mar A Mar','00100001040000017947',2,40.00,35.00,'2024-11-03','Paid by CCAT Link',NULL,1),(38895,70,'Laura','013845-112024',4,1,'Hostel Mariposas','Santa Teresa Akih Pods Entrance','013845',2,120.00,96.00,'2024-11-03','Cobrar $96 a Hostel Mariposas',NULL,1),(38896,16462,'Ailen Marino Marconi','013846-112024',76,1,'Costa Rica Backpackers','Zeneidas Surf Garden Santa Teresa','00100001040000017948',1,60.00,57.00,'2024-11-03','Paid by CCAT Link WA ‪+54 9 2983 41‑7956‬',NULL,1),(38897,86,'Drew Trainor','013847-112024',6,1,'House of Nomad ','Nosara Nexus Institute Yoga & Wellness','013847',1,50.00,40.00,'2024-11-10','Credito ',NULL,1),(38898,274,'Alejandro +506 7113 7514','013848-112024',71,1,'Cafe Social Santa Teresa','SJO Airport','013848',2,120.00,96.00,'2024-11-03','Cobrar $96 al cliente',NULL,1),(38899,16132,'Gabriella Boka','013849-112024',74,1,'Wild Sun Rescue Center Cabuya','Hotel Park View Alajuela','013849',1,60.00,48.00,'2024-11-16','Cobrar $60 al cliente PEN COMMI ',NULL,1),(38900,16132,'Noelia Sánchez','013850-112024',76,1,'Stray Cat Hostel San Jose','Wild Sun Rescue Center Cabuya','013850',1,60.00,48.00,'2024-11-09','Cobrar $60 al cliente PEND COMI',NULL,1),(38901,149,'Gabriela Wimmer','013851-112024',72,1,'Casitas Sollevante Montezuma','Hotel Samara Chillout Lodge','00100001040000017949',1,60.00,57.00,'2024-11-03','Paid by CCAT Link',NULL,1),(38902,16462,'Oliviero Arrigo ','013852-112024',60,2,'Ten North Tamarindo at 9am','Liberia Airport','00100001040000017950',1,120.00,110.00,'2024-11-03','Paid CCAT Link',NULL,1),(38903,274,'Sonia Arce +506 8455 7788','013853-112024',8,1,'Bomba La Alianza Nicoya','Cobano','013853',1,30.00,30.00,'2024-11-03','Cobrar 15mil al cliente local',NULL,1),(38905,47,'Gema Gamboa','013855-112024',71,1,'Don Jons Lodge Santa Teresa','Alajuela Backpackers','013855',1,60.00,48.00,'2024-11-03','hotel pago neto a Leandro',NULL,1),(38907,16462,'Dylan Pegg','013857-112024',5,1,'Delta Gas Station Comunidad','Lifeguard Santa Teresa','00100001040000017951',1,60.00,57.00,'2024-11-04','Paid CCAT Link',NULL,1),(38908,16462,'Andres Barrantes','013858-112024',20,1,'Hotel Atrapasuenos','Hotel El Cerro Liberia','00100001040000017952',2,120.00,114.00,'2024-11-03','Paid CCAT Link',NULL,1),(38909,16462,'Frances Henly','013859-112024',20,1,'Entrance out Lost Boyz','Selina Tamarindo','00100001040000017953',2,120.00,114.00,'2024-11-03','Paid CCAT Link',NULL,1),(38910,274,'Jose +506 8966 6601','013860-112024',30,1,'Restaurante Ginana','Delta Gas Station Comunidad Liberia','013860',1,30.00,30.00,'2024-11-03','Cobrar 15mil al cliente local',NULL,1),(38911,149,'Kayla Roy','013861-112024',20,1,'Believe Surf & Yoga','Coco Beach GTE Center','00100001040000017954',3,180.00,171.00,'2024-11-05','Paid CCAT Link',NULL,1),(38912,16462,'Frederick Picher','013862-112024',5,1,'Hampton By Hilton Liberia','Griss Lodge Villas Santa Teresa','00100001040000017955',2,120.00,114.00,'2024-11-25','Paid CCAT Link',NULL,1),(38913,274,'Thais María Baltodano','013863-112024',5,1,'Subway Rest. at 8:40am','Montezuma Bus Stop','0830',2,60.00,60.00,'2024-11-06','Pago a Oslin ',NULL,1),(38914,16462,'Julia Eßlinger','013864-112024',6,1,'Tamahostel & Hostel','Tico Adventure Lodge Samara ','00100001040000017956',1,50.00,47.00,'2024-11-04','Paid Paypal',NULL,1),(38915,16462,'Lindsay Lopata','013865-112024',60,2,'Liberia Airport El Patio Cafe t 7:00 pm','Blue Spirit Retreat Nosara ','00100001040000017957',1,160.00,150.00,'2024-11-17','Paid Paypal no show',NULL,1),(38916,16462,'Carter Hendricks','013866-112024',71,1,'Believe Surf & Yoga','SJO Airport','00100001040000017958',1,60.00,57.00,'2024-11-03','Paid CCAT Link',NULL,1),(38917,16462,'Ariana Schldheisz','013867-112024',60,2,'Hotel Belvedere Samara at 6am','Liberia Airport on ','00100001040000017959',2,120.00,110.00,'2024-11-14','Paid CCAT Link',NULL,1),(38919,16462,'Dina Burstein','013869-112024',60,2,'Capitan Suizo Tamarindo at 9:30am','Liberia Airport','00100001040000017960',2,120.00,110.00,'2024-12-14','Paid CCAT Link',NULL,1),(38920,16462,'Juli Bergero','013870-112024',59,2,'SJO Airport Malinche Rest ( AV 698 ) at 4pm','Lost Boyz Santa Teresa ','00100001040000017961',1,240.00,230.00,'2024-11-03','Paid CCAT Link',NULL,1),(38921,16462,'Anne-Catherine Blais','013871-112024',20,1,'OSA Rest.','Liberia Airport','00100001040000017962',2,120.00,114.00,'2024-11-04','Paid CCAT Link',NULL,1),(38922,16462,'Lisa Iannuzziello','013872-112024',78,1,' SJO Airport Malinche Rest. at 6:30am',' Trebol Mar Apart Entrance Santa Teresa','00100001040000017963',1,60.00,57.00,'2024-11-04','Paid by CCAT Link',NULL,1),(38923,16462,'Carolyn Secor','013873-112024',45,3,'Cobano Airport at 5pm','Tropico Latino Santa Teresa ','00100001040000017964',2,40.00,35.00,'2024-11-04','Paid by CCAT Link',NULL,1),(38924,16446,'Ghislaine Geneau','013874-112024',6,1,'Gollovillareal Tamarindo at 8:50 am','Super la Hacienda Santa teresa','00100001040000017965',1,60.00,57.00,'2024-11-04','Paid by CCAT Link',NULL,1),(38925,16159,'Daniella','013875-112024',6,1,'Casa Pura Vida Surf Hostel','Santa Teresa','013875',1,60.00,48.00,'2024-11-04','Cobrar $48 a Casa Pura Vida ',NULL,1),(38926,16462,'Alon Shumskiy','013876-112024',3,1,' Rinde Mas Nosara at 7:50am','Liberia Airport','00100001040000017966',1,50.00,47.00,'2024-11-04','Paid by CCAT Link',NULL,1),(38927,149,'Cassandra Willms','013877-112024',60,2,'Liberia Airport arrivals area flight WS2170 at 3:00 pm','Guilded Iguana, playa Guiones, Nosara ','00100001040000017967',2,140.00,130.00,'2024-11-08','Paid by PayPal',NULL,1),(38928,16462,'Benjamin Gabin','013878-112024',20,1,'Katana Rest Santa Teresa at 6:30 am','Cafe de Paris nosara','00100001040000017968',1,60.00,57.00,'2024-11-04','Paid by CCAT Link',NULL,1),(38929,16462,'Laurent Juppe','013879-112024',76,1,'Fleur de Lyz SJO at 5:30am','Sano Banano Rest Montezuma ','00100001040000017969',1,60.00,57.00,'2024-12-07','Paid by CCAT Link',NULL,1),(38930,16462,'Rusty Owens','013880-112024',60,2,'Havana Lodge MalPais at 7:30am','Liberia Airport','00100001040000017970',4,260.00,250.00,'2024-11-30','Paid by CCAT Link',NULL,1),(38931,16462,'Rusty Owens','013881-112024',60,2,' Liberia Airport El Patio Cafe Britt ( AA 1393 ) at 2pm','Havana Lodge MalPais ','00100001040000017971',4,260.00,250.00,'2024-11-23','Paid by CCAT Link',NULL,1),(38932,16462,'David Lariviere','013882-112024',3,1,'Selina Nosara at 7:45am ','Santa Teresa Selina North','00100001040000017973',1,60.00,57.00,'2024-11-15','Paid by CCAT Link',NULL,1),(38933,70,'Mathias','013883-112024',4,1,'Hostel Mariposas ','Tamarindo ','013883',1,50.00,40.00,'2024-11-04','Cobrar $40 a Hostel Mariposas',NULL,1),(38934,16462,'Sandrine Demers','013884-112024',5,1,' Hostel El predal Liberia at 8:40 am ','Maramar Santa Teresa main entrance','00100001040000017974',1,60.00,57.00,'2024-11-08','Paid by CCAT Link',NULL,1),(38935,16200,'Julio Fonseca tel. 8921-4660','013885-112024',76,1,'Barcelo San Jose ','Barcelo Tambor ','013885',2,64.00,64.00,'2024-11-04','Credito ',NULL,1),(38936,16200,'Julio Fonseca tel. 8921-4660','013886-112024',22,1,'Barcelo Tambor ','Barcelo San Jose ','013886',2,90.00,72.00,'2024-11-07','Credito ',NULL,1),(38937,16200,'Andres Madrigal  tel. 8561-2111','013887-112024',76,1,'Barcelo San Jose ','Barcelo Tambor ','013887',4,180.00,144.00,'2024-11-04','Credito ',NULL,1),(38938,16200,'Andres Madrigal tel. 8561-2111','013888-112024',22,1,'Barcelo Tambor ','Barcelo San Jose ','013888',4,180.00,144.00,'2024-11-08','Credito ',NULL,1),(38939,274,'Vanessa','013889-112024',124,1,'Cruce Los Mangos','LIR Centro','1619',1,20.00,20.00,'2024-11-04','Cobrar 10.000 Local Aut. Leandro',NULL,1),(38940,274,'Geovanni Giacomin','013890-112024',78,1,'Hotel 1915','Santa Teresa Ritmo Tropical Hotel','1640',1,50.00,50.00,'2024-12-06','Cobrar $125 Cliente Aut Oslin',NULL,1),(38941,16536,'Mike Marty','013891-112024',45,3,'Ventura Hotel Santa Teresa at 2:15pm  ','COB Airport ','00100001040000017976',2,40.00,40.00,'2024-11-09','Paid Net CCAT Link ',NULL,1),(38942,16536,'Mike Marty','013892-112024',45,3,'Santa Teresa Ventura Hotel at 12:30pm','Cobano Airport','00100001040000017977',2,40.00,40.00,'2024-11-09','Paid Net CCAT Link ',NULL,1),(38943,149,'Gozlan Dantre','013893-112024',70,1,'Hotel Santa Teresa by the Beach','SJO Airport','1820',2,120.00,114.00,'2024-11-05','Paid Office CC',NULL,1),(38944,16462,'Anja De Vries','013894-112024',60,2,'LIR Airport Fligth WS 2170 at 3:30pm','Samara Casa Terra','00100001040000017978',2,125.00,115.00,'2024-11-06','Paid CCAT Link',NULL,1),(38945,16424,'Sarah Jarzombek','013895-112024',59,2,'Costa Rica Marriott Hotel Hacienda Belen SJO at 6:00am','Santa Teresa Laloon Luxury Suites','100720',1,260.00,240.00,'2024-11-04','Credito',NULL,1),(38946,16505,'Lea','013896-112024',20,1,'Kooks Smoke Bar ','Samara Woodstock Hostel','1832',2,120.00,96.00,'2024-11-04','Cobrar $96 Cliente',NULL,1),(38949,16462,'Katrina Schrod	','013899-112024',60,2,'Selina Hostel Nosara at 8:00am ','LIR Airport','00100001040000017982',1,140.00,130.00,'2024-12-08','Paid CCAT Link',NULL,1),(38950,16462,'Katrina Schrod	','013900-112024',20,1,'Don Jons Hostel','Nosara Beach Hostel ','00100001040000017982',1,60.00,57.00,'2024-12-06','Paid CCAT Link',NULL,1),(38951,16462,'Tatjana Rumpler','013901-112024',78,1,'Malinche Rest. SJO Airport','Santa Teresa Zeneidas Surf Garden','00100001040000017983',1,60.00,57.00,'2025-02-17','Paid Paypal',NULL,1),(38952,149,'Anna Malakhova','013902-112024',6,1,'Entrance Hotel Tama Lodge at 8:50am ','Santa Teresa Tropical Tours Office','00100001040000017984',1,60.00,57.00,'2024-11-05','Paid CCAT Link',NULL,1),(38953,149,'Gyana Gomar','013903-112024',60,2,'Hotel Macao Samara at 8:00am','LIR Airport','00100001040000017985',2,125.00,115.00,'2024-11-10','Paid CCAT Link',NULL,1),(38954,16462,'Sophia Lepsy','013904-112024',34,1,'OSA Rest.','La Fortuna Argdivan Hostel','00100001040000017986',2,130.00,123.00,'2024-11-17','Paid CCAT Link',NULL,1),(38955,16462,'Leilani Frazer','013905-112024',60,2,'Seekret Spot Gelateria Nosara at 6:00am ','LIR Airport','00100001040000017987',2,140.00,130.00,'2024-11-22','Paid CCAT Link',NULL,1),(38956,16462,'Leilani Frazer','013906-112024',5,1,'El Patio Britt Cafe Britt LIR Airport ','Nosara Seekret Spot Gelateria','00100001040000017987',2,100.00,95.00,'2024-11-16','Paid CCAT Link',NULL,1),(38957,149,'Karin Fuchs','013907-112024',20,1,'Entrance out Surf Paradise Hostel','Nosara Selina Hostel','1918',1,60.00,57.00,'2024-11-06','Paid Office CC',NULL,1),(38958,149,'Kirsten Cusack','013908-112024',3,1,'Salt Nosara','Tamarindo Pangas Beach Club','00100001040000017989',1,50.00,47.00,'2024-11-06','Paid CCAT Link',NULL,1),(38959,149,'Benjamin Bowden','013909-112024',60,2,'LIR Airport Flight AA 1495 at 2:02pm','Hermosa ST Casa Malibu','00100001040000017990',1,260.00,250.00,'2024-11-04','Paid CCAT Link',NULL,1),(38960,274,'Jonathan Reich','013910-112024',78,1,'Malinche Rest. SJO Airport','Santa Teresa Eat Streets Rest','1015',1,60.00,48.00,'2024-11-08','Cobrar $60 Cliente & Pend Comi ‪Vitamati Travels ‪+502 3049 5464‬',NULL,1),(38961,16536,'Alexandre Rosier','013911-112024',20,1,'Ventura Hotel ','Tamarindo Zulu Hotel','00100001040000017991',2,120.00,96.00,'2024-11-05','Paid Net CCAT Link',NULL,1),(38962,16462,'Sally Ross','013912-112024',5,1,'El Patio Cafe Britt LIR Airport','Nosara Blue Spirit Retreat Center','00100001040000017992',1,50.00,47.00,'2024-12-14','Paid CCAT Link',NULL,1),(38963,149,'Carrie Hebert	','013913-112024',60,2,'Surf Shack Nosara at 6:30am','LIR Airport','00100001040000017993',2,140.00,130.00,'2024-11-06','Paid CCAT Link',NULL,1),(38964,16446,'Jonas Baek','013914-112024',78,1,'Hampton by Hilton','Outside Santa Teresa','00100001040000017994',1,60.00,57.00,'2024-11-09','Paid CCAT Link',NULL,1),(38965,16436,'Xanthia Coulson','013915-112024',72,1,'Luminosa Montezuma Hostel','Hospedaje Dodero Liberia','013915',1,60.00,48.00,'2024-11-06','Cobrar $48 al cliente',NULL,1),(38966,16462,'Alessandro Isenschmid','013916-112024',20,1,'Entrance out Lost Boyz','Botella Leche Hostel Tamarindo','00100001040000017995',2,120.00,114.00,'2024-11-05','Paid CCAT Link',NULL,1),(38967,16462,'Ian ODonnell','013917-112024',60,2,' Liberia Airport El Patio Cafe Britt ( UA 1612 ) at 2:30 pm ','Hotel El Secreto Fortuna','00100001040000017996',5,290.00,280.00,'2024-12-22','Paid by CCAT Link',NULL,1),(38968,274,'Anabelle y Abigail','013918-112024',76,1,'Gran Hotel Costa Rica SJO ','Montezuma','68465',2,0.00,0.00,'2024-11-08','CPL aut pollo',NULL,1),(38969,16446,'Halina Tittmann','013919-112024',45,3,'Cobano Airport at 9:50am','Luna Villas, Santa Teresa','00100001040000017997',2,40.00,35.00,'2024-11-05','Paid by CCAT Link',NULL,1),(38970,16446,'Robert Howe Walker ','013920-112024',60,2,'El Establo Mountain hotel at 10:00 am ','Tamarindo Diria beach Resort','00100001040000017998',2,230.00,220.00,'2025-05-24','Paid by CCAT Link',NULL,1),(38971,16462,'Jennifer A Soule','013921-112024',5,1,'Hampton Inn by Hilton Liberia at 9:00 am',' Blue Spirit Nosara ','00100001040000017999',1,50.00,47.00,'2024-12-07','Paid by CCAT Link',NULL,1),(38972,16462,'David Song','013922-112024',60,2,'Liberia Airport El Patio Cafe Britt ( UA 1512 ) at 3pm',' OutBox Inn Monteverde ','00100001040000018000',1,230.00,220.00,'2024-11-05','Paid by CCAT Link',NULL,1),(38973,16446,'Kailey McKenna','013923-112024',5,1,'Liberia Airport Patio cafe at 9:00 am',' Living Hotel Nosara','00100001040000018001',2,100.00,95.00,'2024-11-05','Paid by CCAT Link',NULL,1),(38974,16446,'Annabelle Debattista','013924-112024',3,1,'nomadic hotel, nosara','wyndham hotel, tamarindo','00100001040000018002',1,50.00,47.00,'2024-11-08','Paid by CCAT Link',NULL,1),(38975,274,'Stefanie Luce ','013925-112024',72,1,'Hotel Nya MTZ','Liberia Aeropuerto ','013925',2,120.00,96.00,'2024-11-05','Pago neto -w en oficina Santa Teresa Adventures  +506 6063 4531 NO SHOW',NULL,1),(38976,16570,'José Luis Junes','013926-112024',5,1,'Patio Cafe','Santa Teresa','890',1,30.00,30.00,'2024-11-05','Credito',NULL,1),(38977,257,'Marina Alexander','013927-112024',5,1,'Hilton Garden Inn Liberia Airport','Griss Lodge & Villas Santa Teresa','013927',1,60.00,48.00,'2024-11-05','Credito ',NULL,1),(38978,16446,'Georgina Jackson ','013928-112024',60,2,'Hotel Guiones Nosara at 11:30am','Liberia Airport','00100001040000018003',1,140.00,130.00,'2024-11-09','Paid by PayPal',NULL,1),(38979,16462,'Max ascher','013929-112024',78,1,'SJO Airport Malinche restaurant at 6:30 am','SJO International Airport','00100001040000018004',1,60.00,57.00,'2024-11-05','Paid by CCAT Link',NULL,1),(38980,149,'Thomas a Ross','013930-112024',5,1,'El Patio Britt Cafe LIR ATO at 9:00am ','MTZ Zumatours Office ','00100001040000018005',2,120.00,114.00,'2024-11-07','Paid by CCAT Link',NULL,1),(38981,274,'Justin','013931-112024',5,1,'Liberia Airport El Patio Cafe Britt','Cobano Center','5478',1,30.00,30.00,'2024-11-05','Cobrar 20.000 colones al cliente',NULL,1),(38982,16446,'Natalia Tarjanyi','013932-112024',70,1,'Super Hacienda Sta Teresa at 6:25am','SJO International Airport','00100001040000018006',1,60.00,57.00,'2024-11-06','Paid by CCAT Link Hace Transporzuma',NULL,1),(38983,16305,'Mark','013933-112024',4,1,'Tico Adventure Lodge','Hotel El Jardín Montezuma','013933',2,120.00,96.00,'2024-11-06','Credito ',NULL,1),(38984,16446,'Deborah A Ohrtman','013934-112024',6,1,' Hotel Villas Macondo Tamarindo at 8:40 am','Ronnys 2 santa teresa (Fuego Lodge)','00100001040000018007',2,120.00,114.00,'2025-02-18','Paid by CCAT Link',NULL,1),(38985,274,'Sandra Arguedas +506 8413 3813','013935-112024',20,1,'Entrada Rancho Esperanza San Isidro','Santa Cruz ','013935',1,20.00,20.00,'2024-11-06','Cobrar 10mil al cliente local Oslin Approved',NULL,1),(38986,17,'Alexander Wachter ','013936-112024',72,1,'Hotel Amor de Mar Montezuma','Tico Adventure Lodge Samara ','013936',1,60.00,48.00,'2024-11-07','Cobrar $60 al cliente PEND COMI Leandro pago comi',NULL,1),(38987,149,'Marie Nyquist ','013937-112024',76,1,' Palma Real SJO at 5:30am ','Hotel ventura santa teresa','00100001040000018009',2,120.00,114.00,'2024-11-09','Paid by CCAT Link',NULL,1),(38988,16446,'Aira Ackermann','013938-112024',76,1,'Selina San Jose  at 5:30 am','Eat street santa teresa ','00100001040000018010',1,60.00,57.00,'2024-12-07','Paid by CCAT Link',NULL,1),(38989,16200,'Isaac Cabezas Molina tel.8779-8299','013939-112024',76,1,'Barcelo San Jose ','Barcelo Tambor ','013939',2,120.00,96.00,'2024-11-29','Credito ',NULL,1),(38990,16200,'Isaac Cabezas Molina tel.8779-8299','013940-112024',22,1,'Barcelo Tambor ','Barcelo San Jose ','013940',2,120.00,96.00,'2024-12-01','Credito ',NULL,1),(38991,16519,'Federica Giacomelli ','013941-112024',78,1,'Toucan Hostel Alajuela','Hotel Aves Montezuma','013941',2,120.00,96.00,'2024-11-17','Cobrar $96 a Hotel Aves MTZ',NULL,1),(38992,16446,'Morgan Campbell','013942-112024',60,2,' Liberia Airport flight AA417 at 1:30 PM','Norte Hotel Nosara','00100001040000018011',1,140.00,130.00,'2024-11-09','Paid by CCAT Link',NULL,1),(38993,16200,'Gerald Calero tel.8777-1460','013943-112024',76,1,'Barcelo San Jose ','Barcelo Tambor ','013943',2,90.00,72.00,'2024-11-06','Credito ',NULL,1),(38994,16200,'Gerald Calero tel.8777-1460','013944-112024',22,1,'Barcelo Tambor ','Barcelo San Jose ','013944',2,120.00,96.00,'2024-11-09','Credito ',NULL,1),(38995,149,'TIM WOCHESLANDER','013945-112024',78,1,'Sjo Airport malinche restaurant','Hermosa ST Zopilote Surfcamp','00100001040000018012',1,80.00,76.00,'2024-11-30','Paid by CCAT Link',NULL,1),(38996,149,'Linda Hill Blakley','013946-112024',60,2,'Casa Pakatoa Samara at 10:00am','LIR Hilton Garden Inn GTE','00100001040000018013',2,125.00,115.00,'2024-11-18','Paid by CCAT Link',NULL,1),(38997,149,'Linda Hill-Blakley','013947-112024',60,2,' LIR Airport Flight UA1917 at 5:00pm','Samara Casa Pakatoa ','00100001040000018014',2,125.00,115.00,'2024-11-08','Paid by CCAT Link',NULL,1),(38998,16446,'Milla Kuhlmann','013948-112024',6,1,'Vindi Tamarindo','Pura Vida Surfers Santa Teresa','00100001040000018015',2,120.00,114.00,'2024-11-22','Paid by CCAT Link',NULL,1),(38999,274,'Andrey Acosta','013949-112024',76,1,'Entrance out Gran Hotel CR','Santa Teresa Center','1316',2,70.00,70.00,'2024-11-21','Paid JC Local 8414-1249 ',NULL,1),(39000,16446,'Stephanie Gordon','013950-112024',20,1,'OSA Rest. at 6:25am','LIR Airport','00100001040000018016',1,60.00,57.00,'2024-11-09','Paid CCAT Link',NULL,1),(39001,16427,'Jose Porras','013951-112024',20,1,'Entrance out Zunya ','Liberia Center','1517',1,60.00,48.00,'2024-11-06','Cobrar $48 Cliente',NULL,1),(39002,274,'Amaya Aspillaga ','013952-112024',6,1,'El Fogon De Doña Luisa 27 de Abril at 8:55am','Santa Teresa Kikas Rest.','1520',2,120.00,96.00,'2024-11-07','Cobrar $120 Cliente & Pend Comi ‪Lucy 8668-2913',NULL,1),(39003,274,'Itamar','013953-112024',31,1,'Terminal Puntarenas at 8:30am','Santa Teresa Eat Streets Rest','1015',1,45.00,40.00,'2024-11-08','Cobrar $45 Cliente & Pend Comi ‪Vitamati Travels ‪+502 3049 5464‬',NULL,1),(39004,86,'Marek Zynel','013954-112024',6,1,'La Oveja Surf Hostel','Santa Teresa Ventura Hotel','1645',2,120.00,96.00,'2024-11-06','Credito',NULL,1),(39005,16518,'Enola Diznar','013955-112024',3,1,'Pelada Studios at 7:45am','Santa Teresa Eat Streets Rest','0038',2,120.00,96.00,'2024-11-06','Cobrar $120 Cliente & Pend Comi ‪',NULL,1),(39006,274,'Dylan Cortes','013956-112024',76,1,'Barcelo Palacio SJO ','Santa Teresa Center','1940',1,30.00,30.00,'2024-11-06','pago 15000 en la oficina -w',NULL,1),(39007,16462,'Genevieve Rowley','013957-112024',79,1,'Hampton by Hilton SJO Airport','Santa Teresa Below Hotel Horizon ','00100001040000018017',5,300.00,285.00,'2024-12-21','Paid CCAT Link',NULL,1),(39008,149,'Jeanne Thomason	','013958-112024',5,1,'Hilton Garden Inn GTE','Santa Teresa Katana Rest','00100001040000018018',1,60.00,57.00,'2024-12-07','Paid Paypal',NULL,1),(39009,149,'Lamiah Arnold ','013959-112024',5,1,'El Patio Britt Cafe LIR Airport ','Nosara Beach Break Bungalows ','00100001040000018019',2,100.00,95.00,'2024-12-06','Paid CCAT Link',NULL,1),(39010,149,'Conner Currie ','013960-112024',20,1,'Eat Street Rest','LIR Airport','00100001040000018020',1,60.00,57.00,'2024-11-08','Paid CCAT Link',NULL,1),(39011,149,'Olivia Stroz-Breton	','013961-112024',20,1,'Entrance Plaza Kahuna','LIR Airport','00100001040000018021',1,60.00,57.00,'2024-11-10','Paid CCAT Link',NULL,1),(39012,149,'Tim Gaskin','013962-112024',70,1,'Eat Street Rest at 6:30am','SJO Airport','00100001040000018022',1,60.00,57.00,'2024-11-08','Paid Paypal Hace Transporzuma',NULL,1),(39013,149,'Alexis Peladeau','013963-112024',4,1,'Hotel Macao ','Santa Teresa Entrance La Posada ','00100001040000018023',2,120.00,114.00,'2025-01-09','Paid CCAT Link',NULL,1),(39014,16446,'David Teichrob	','013964-112024',60,2,'LIR Airport Flight WS 2170 at 2:02pm','Nosara Pelada Condominio Las Palmas ','00100001040000018024',4,140.00,130.00,'2024-11-11','Paid CCAT Link',NULL,1),(39015,16446,'Lisa y Sebastian','013965-112024',20,1,'Hotel luz de Luna main entrance at 6:30 am','Liberia Bus Stop','57754',2,120.00,114.00,'2024-11-09','Pay cash in the office',NULL,1),(39016,16446,'Morgan Razi','013966-112024',60,2,'Hampton by Hilton Guanacaste Airport at 8:00 am','Samara Roots Bakery & Café','00100001040000018025',2,125.00,115.00,'2024-11-07','Paid by CCAT Link',NULL,1),(39017,23,'Sarah','013967-112024',20,1,'Hotel Santa Teresa','Liberia','013967',2,120.00,96.00,'2024-11-08','PAID by CCAT link $135.60 PENDING COMMI   ',NULL,1),(39018,149,'Jack Reisman','013968-112024',60,2,'LIR Airport Flight X at 3:30 pm','Santa Teresa patio cafe ','00100001040000018026',7,320.00,320.00,'2024-12-08','Paid by CCAT Link',NULL,1),(39019,149,'Jack Reisman','013969-112024',60,2,' Patio cafe Santa Teresa at 7:30am','Liberia Airport','00100001040000018026',7,320.00,310.00,'2024-12-14','Paid by CCAT Link',NULL,1),(39020,274,'Pamela Cruz ‪+506 8309 8271‬','013970-112024',20,1,'Selina Norte Santa Teresa','Restaurante Los Almendros Nosara','013970',1,50.00,50.00,'2024-11-07','Cobrar $50 al cliente (a fondo 6mil solones)ella pago 26 mil y si hubo viaje a nosara',NULL,1),(39021,16450,'Rahel Lisebach','013971-112024',4,1,'Intercultura Language School','Believe Surf & Yoga Santa Teresa','013971',2,120.00,96.00,'2024-11-10','Cobrar $96 al cliente',NULL,1),(39022,15,'Victoria Casanova','013972-112024',76,1,'DoubleTree Hilton Cariari 6am','Anamaya Montezuma','013972',1,60.00,48.00,'2024-11-09','Credito',NULL,1),(39023,15,'Ariel Carpenter','013973-112024',5,1,' Hampton By Hilton Guanacaste Airport','Anamaya Montezuma','013973',1,60.00,48.00,'2024-11-09','Credito',NULL,1),(39024,15,'Sarah DeMaere','013974-112024',5,1,'Hilton Garden Inn Guanacaste Liberia','Anamaya Montezuma','013974',2,120.00,96.00,'2024-11-09','Credito',NULL,1),(39025,16446,'Thomas  Saucedo Fontana','013975-112024',78,1,'Sjo Airport malinche restaurant','Santa Teresa HTB','00100001040000018027',1,60.00,57.00,'2024-11-10','Paid by CCAT Link',NULL,1),(39026,149,'Marco Patriarco','013976-112024',60,2,'Selina Tamarindo at 11:30 am','Liberia Airpot','00100001040000018028',1,120.00,110.00,'2024-11-08','Paid by PayPal',NULL,1),(39027,16446,'Michele Kleemann','013977-112024',6,1,'Selina Tamarindo at 8:40 am','Selina Sur Santa Teresa','00100001040000018029',3,180.00,170.00,'2024-11-10','Paid by CCAT Link',NULL,1),(39028,274,'Marjorie Perez','013978-112024',9,1,'Escuela la Abuela tambor ','Nicoya La Alianza Gas Station','1705',1,30.00,30.00,'2024-11-07','Cobrar 15000 Cliente Local',NULL,1),(39029,149,'Kathryn Craddock','013979-112024',70,1,'Soda Tiquicia','Alajuela Dennys Rest','00100001040000018030',1,60.00,57.00,'2024-11-10','Paid CCAT Link',NULL,1),(39030,2,'Anika','013980-112024',72,1,'Sano Banano MTZ','Hostel Dodero Liberia','18754',1,60.00,48.00,'2024-11-07','Crédito ',NULL,1),(39031,149,'Javan Wyker','013981-112024',60,2,'Liberia Airport El Patio cafe Britt ( Flight ?? ) at 12:55md ','Malpais TBD','00100001040000018031',6,300.00,290.00,'2024-12-07','Paid CCAT Link',NULL,1),(39032,245,'Nicole Lichtner.','013982-112024',6,1,'Cala Luna Boutique Hotel','Sendero Hotel & Villas Nosara','013982',2,100.00,80.00,'2024-11-08','PAID DEPOSIT $90,40',NULL,1),(39033,16462,'Evangeline Duclos','013983-112024',5,1,'Cafe Negro Liberia at 8:40am','Nosara B&B Retreat','00100001040000018032',1,50.00,47.00,'2024-11-07','Paid CCAT Link',NULL,1),(39034,16462,'Jimena Haderspock','013984-112024',76,1,' Hilton Garden Inn SJO La Sabana at 5:30am ','Santa Teresa Hotel Luz de Luna','00100001040000018033',3,180.00,171.00,'2024-11-09','Paid by CCAT Link',NULL,1),(39035,16462,'Jimena Haderspock','013985-112024',59,2,'Luz de luna santa teresa at 4:00 pm','Condominio Partal 5 Escazu ','00100001040000018034',3,240.00,230.00,'2024-11-10','Paid by CCAT Link +34 658 18 23 99',NULL,1),(39036,16462,' Dillon Geraghty','013986-112024',20,1,'Eat Street Rest Santa Teresa at 6:30am ',' 506 Tennis Center Nosara','00100001040000018035',1,100.00,95.00,'2024-11-07','Paid by CCAT Link',NULL,1),(39037,149,'Nirushan Mahendran','013987-112024',103,1,'Villas Uria: Casa Jazmin & Casa Isabel Tamarindo at 1:30pm',' Santa Elena MTV Cloud Forest Lodge ','00100001040000018036',2,130.00,121.00,'2024-11-11','Paid by CCAT Link / Opera Roca Verde',NULL,1),(39038,149,'Helen Schulz','013988-112024',72,1,' Hotel El Jardin MTZ at 7:00am','Potrero GTE Bahia del Sol Boutique Hotel','00100001040000018037',2,120.00,114.00,'2024-12-14','Paid by CCAT Link',NULL,1),(39039,149,'Helen Schulz','013989-112024',78,1,'Gardens House Alajuela at 6:30am','MTZ Hotel El Jardin ','00100001040000018038',2,120.00,114.00,'2024-12-09','Paid by CCAT Link',NULL,1),(39040,16446,'Caterina Doerr','013990-112024',70,1,'Zopilote surf camp hermosa at 6:10 am','Casa Garitas SJO Airport','00100001040000018039',1,80.00,76.00,'2025-03-11','Paid by CCAT Link',NULL,1),(39041,16446,'Caterina Doerr','013991-112024',76,1,'Natives Art Hostel San Jose  at 5:30 am','Hermosa ST Zopilote Surfcamp','00100001040000018040',1,80.00,76.00,'2025-03-01','Paid by CCAT Link',NULL,1),(39042,16446,'Ezequiel Santos','013992-112024',70,1,'Zeneidas Santa Teresa at 6:45 am ','SJO International Airport','00100001040000018042',1,60.00,57.00,'2024-11-10','Paid by CCAT Link',NULL,1),(39043,16446,'Elisabeth Hinteregger','013993-112024',20,1,'Kooks Santa Teresa at 6:30 am',' Nexus Yoga Institute Nosara','00100001040000018043',1,60.00,57.00,'2024-11-10','Paid by CCAT Link',NULL,1),(39044,16323,'Alan Marcillet','013994-112024',4,1,'Hotel Blue Iguana Samara','Luminosa Montezuma Hostel','013994',1,60.00,48.00,'2024-11-11','Cobrar $48 al Hotel Blue Iguana',NULL,1),(39045,16446,'Julie Davis','013995-112024',60,2,'Liberia Airport flight UA1737 at 6:00 PM ','Solaris Condominium Conchal','00100001040000018044',2,120.00,110.00,'2024-11-22','Paid by CCAT Link',NULL,1),(39046,16462,'Carolyn Secor','013996-112024',45,3,'Hotel Tropico Latino Santa Teresa at 7:45am','Cobano Airport','00100001040000018045',2,40.00,35.00,'2024-11-10','Paid by CCAT Link',NULL,1),(39047,16427,'Jose Porras +506 8666 7151','013997-112024',5,1,'Subway Liberia 8:40am','Hotel Zunya Mal Pais','013997',1,60.00,48.00,'2024-11-08','Cobrar $48 al cliente',NULL,1),(39048,16200,'Alexandra Prieto','013998-112024',22,1,'Barcelo Tambor ','Barcelo San Jose ','013998',2,72.00,72.00,'2024-11-07','Credito ',NULL,1),(39049,16462,'Mei Wen','013999-112024',60,2,'Casa Serena Nosara at 7:00 am','SJO International Airport','00100001040000018046',1,297.00,287.00,'2024-11-11','Paid CCAT Link',NULL,1),(39050,16462,'Linea Whitelaw','014000-112024',20,1,'Griss Lodge & Villas','Hilton Garden Inn Liberia','00100001040000018047',1,60.00,57.00,'2024-11-08','Paid CCAT Link',NULL,1),(39051,16462,'Marina Alexander','014001-112024',20,1,'Griss Lodge & Villas','Hilton Garden Inn Liberia','00100001040000018048',1,60.00,57.00,'2024-11-08','Paid CCAT Link',NULL,1),(39052,4,'Aurelie','014002-112024',72,1,'Sunshine Sanctuary MTZ','Liberia Aeropuerto ','014002',3,180.00,150.00,'2024-11-15','Cobrar $150 a MTZ Tours',NULL,1),(39053,149,'Jordan Ramsay','014003-112024',30,1,'Ginana Rest.','Samara Bahia Beachfront','00100001040000018049',2,120.00,114.00,'2024-12-30','Paid CCAT Link',NULL,1),(39054,149,'Jordan Ramsay','014004-112024',4,1,'Bahia Beachfront Samara','Tamarindo Perla de la Playa Hotel','00100001040000018049',2,100.00,95.00,'2025-01-03','Paid CCAT Link',NULL,1),(39055,149,'Laura White ','014005-112024',5,1,'Liberia Airport El Patio Cafe','Hotel Aves Montezuma','00100001040000018050',1,60.00,57.00,'2024-11-09','Paid CCAT Link',NULL,1),(39056,149,'Michelle Kinzel','014006-112024',5,1,'Liberia Airport El Patio Cafe',' Tambor Los Delfines','00100001040000018051',2,120.00,114.00,'2024-12-29','Paid CCAT Link',NULL,1),(39057,16462,'Martin Morasch','014007-112024',76,1,'Hilton Garden Inn SJO La Sabana','Santa Teresa Esencia Hotel','00100001040000018052',1,80.00,77.00,'2024-11-18','Paid Paypal 1Longboard ',NULL,1),(39058,16200,'Natalia Mendez','014008-112024',76,1,'Barcelo Palacio SJO at 6:00am','Tambor Barcelo Resort','1605',3,125.00,100.00,'2024-11-08','Credito 8865-6029 2+1',NULL,1),(39059,16200,'Natalia Mendez','014009-112024',22,1,'Barcelo Tambor Beach','SJO Barcelo Palacio','1605',3,125.00,100.00,'2024-11-10','Credito 8865-6029 2+1',NULL,1),(39060,16213,'Paradise Borromeo','014010-112024',6,1,'In The Shade Hotel','Santa Teresa Santeria Lodge','1615',1,60.00,48.00,'2024-11-09','Cobrar $48 Hotel',NULL,1),(39061,16462,'Vincent Constantino','014011-112024',5,1,'Subway Rest. at 8:40am','Santa Teresa Alamo Car Rental','00100001040000018053',2,130.00,123.00,'2024-12-23','Paid CCAT Link',NULL,1),(39062,16462,'Vincent Constantino','014012-112024',34,1,'Alamo Car Rental','LA Fortuna Villas Fortuna Boutique ','00100001040000018053',2,120.00,114.00,'2024-12-26','Paid CCAT Link',NULL,1),(39063,16462,'Edmund Thompson','014013-112024',3,1,'Guiones Hotel','Santa Teresa Somos Hostel','00100001040000018054',1,60.00,57.00,'2024-11-08','Paid CCAT Link',NULL,1),(39064,149,'Agustin Oliva	','014014-112024',60,2,'LIR Airport Flight AA 1377 at 2:00pm ','Samara LoCoworking Costa Rica ','00100001040000018055',1,125.00,115.00,'2024-11-08','Paid CCAT Link',NULL,1),(39065,149,'Daniel Rozental','014015-112024',6,1,'La Botella de Leche Hostel','Santa Teresa Somos Hostel','00100001040000018056',1,60.00,57.00,'2024-11-08','Paid CCAT Link',NULL,1),(39066,149,'Michelle Pinard	','014016-112024',20,1,'Believe Surf & Yoga','LIR Hotel Liberia','00100001040000018057',1,60.00,57.00,'2024-11-08','Paid CCAT Link',NULL,1),(39067,16446,'Lucinda Struch	','014017-112024',59,2,'SJO Airport Flight AV646 at 12:30pm ','Santa Teresa Lucero Retreats','00100001040000018058',1,240.00,230.00,'2024-11-09','Paid CCAT Link',NULL,1),(39068,16446,'Dennis Crane','014018-112024',72,1,'ASVO House','Tamarindo Pacific Coast Golf Cart Rentals','00100001040000018059',1,60.00,57.00,'2024-12-07','Paid CCAT Link',NULL,1),(39069,16446,'Dennis Crane','014019-112024',6,1,'Pacific Coast Golf Cart Rentals ','MTZ ASVO House','00100001040000018059',1,60.00,57.00,'2024-12-01','Paid CCAT Link',NULL,1),(39070,149,'Katherine Liden	','014020-112024',60,2,'LIR Airport Flight Southwest WN 691at 2:00pm ','Samara Hotel TBD','00100001040000018060',1,125.00,115.00,'2024-11-10','Paid Paypal',NULL,1),(39071,149,'Michael Eisner','014021-112024',20,1,'Somos Hostel','LIR Comunidad Delta El Coco','00100001040000018061',1,60.00,57.00,'2024-11-08','Paid CCAT Link',NULL,1),(39072,16446,'Ana Soto','014022-112024',76,1,'City Express Cariari SJO at 6:00am','Santa Teresa Selina South','1910',1,60.00,57.00,'2024-11-08','Cobrar $60 Cliente +56 9 7647 0925',NULL,1),(39073,149,'Shane Swiderek	','014023-112024',70,1,'Don Johns Hostel ','SJO Airport','00100001040000018062',1,60.00,57.00,'2024-11-22','Paid CCAT Link',NULL,1),(39074,274,'Alejandro ','014024-112024',6,1,'Gollo Store Villarreal at 8:55am','Cobano Center','2016',1,30.00,30.00,'2024-11-08','Cobrar 15000 Cliente Aut. Oslin',NULL,1),(39075,149,'Christopher Alford	','014025-112024',60,2,'LIR Airport Flight WJ2170 at 2:00pm','Tamarindo Selina Hostel ','00100001040000018063',1,120.00,110.00,'2024-11-08','Paid CCAT Link',NULL,1),(39076,274,'Sandra Arguedas ','014026-112024',7,1,'BN Santa Cruz','Cobano Center','0640',1,20.00,20.00,'2024-11-08','Cobrar 10.000 Cliente Local Aut Oslin',NULL,1),(39077,149,'Tegan Duong','014027-112024',60,2,'LIR Airport Flight UA 1512 at 1:30pm','Puerto Carrillo GTE Casa Isa Ilain ','00100001040000018064',2,125.00,115.00,'2024-11-09','Paid CCAT Link NO SHOW',NULL,1),(39078,149,'Valerie Gasparini	','014028-112024',60,2,'SJO Airport Flight AV47 at 9:20am ','Tamarindo Langosta Naxos Resort','00100001040000018065',2,295.00,285.00,'2024-11-09','Paid CCAT Link',NULL,1),(39079,149,'Murat Bosnak	','014029-112024',78,1,'Hilton Garden Inn SJO Airport City Mall ','Santa Teresa Entrance Outsite ','00100001040000018066',1,60.00,57.00,'2024-11-15','Paid CCAT Link',NULL,1),(39080,16446,'Pierrette Courtemanche	','014030-112024',3,1,'Cafe de Paris','LIR Airport','00100001040000018067',2,100.00,95.00,'2024-12-27','Paid CCAT Link',NULL,1),(39081,149,'Lisa Sandvold	','014031-112024',60,2,'LIR Airport Flight AC 1331 at 1:45pm ','Santa Teresa Selva Resort','00100001040000018068',2,260.00,250.00,'2024-11-16','Paid CCAT Link STAND BY',NULL,1),(39082,16424,'Sarah Jarzombek','014032-112024',59,2,'Lalon Luxury Suites Santa Teresa at 12:45pm','La Fortuna Lost Iguana Resort','0805',2,335.00,315.00,'2024-11-08','Credito',NULL,1),(39083,149,'Marlene Caron	','014033-112024',20,1,'Katana Rest.','LIR Airport','00100001040000018069',1,60.00,57.00,'2024-11-11','Paid CCAT Link',NULL,1),(39084,149,'Pierrette Courtemanche	','014034-112024',60,2,'LIR Airport Flight TS 600 at 3:00pm','Nosara El Chivo Rest.','00100001040000018070',2,140.00,130.00,'2024-12-11','Paid CCAT Link',NULL,1),(39085,4,'Vincent','014035-112024',72,1,'MTZ Tours Office','Nosara Chilamate Rainforest Eco Retreat','0952',2,120.00,96.00,'2024-11-09','Montezuma Tours Pago neto a Leandro',NULL,1),(39086,257,'Amy Takayoshi','014036-112024',6,1,'Tamarindo Bay Boutique Hotel','Santa Teresa Eat Streets Rest','1945',2,120.00,96.00,'2024-11-11','Credito',NULL,1),(39087,16213,'Angie Newton','014037-112024',6,1,'In The Shade Hotel','Samara Locanda Hotel','1003',3,150.00,120.00,'2024-11-09','Cobrar $80 Hotel SE DEBE COMI DE #1015 & 012863',NULL,1),(39088,149,'Vincenzo Carlese	','014038-112024',60,2,'Pasatiempo Hotel Tamarindo at 9:00am ','Jaco Cocal Hotel','00100001040000018071',2,300.00,290.00,'2024-11-12','Paid CCAT Link',NULL,1),(39089,63,'Lux Bernard','014039-112024',4,1,'Natural Center Office','LIR Airport','1034',2,100.00,80.00,'2024-11-25','Credito',NULL,1),(39090,63,'Andrew Bishop','014040-112024',4,1,'Pension Playa Samara ','MTZ Hotel El Jardín ','1316',1,60.00,48.00,'2024-11-09','Crédito ',NULL,1),(39091,16200,'Xinia Sibaja','014041-112024',78,1,'Malinche Rest. SJO AirPort ','Tambor Barcelo Beach','1445',4,180.00,144.00,'2024-11-09','Crédito 8386-5986',NULL,1),(39092,16200,'Xinia Sibaja','014042-112024',22,1,'Barceló Tambor Beach','SJO Airport ','1445',4,180.00,144.00,'2024-11-11','Crédito 8386-5986',NULL,1),(39093,15,'Bathoni Puplampu','014043-112024',76,1,'Hotel Adventure Inn SJO at 6:00am','MTZ Anamaya Resort','1456',1,60.00,48.00,'2024-11-13','Crédito ',NULL,1),(39094,16200,'Benjamin Barrios','014044-112024',59,2,'SJO Airport Flight AA 1053 at 2:20pm','Tambor Barceló Beach','1503',2,240.00,220.00,'2024-11-09','Crédito ',NULL,1),(39095,16200,'Ivan Savedra','014045-112024',78,1,'Malinche Rest. SJO Airport ','Tambor Barceló Beach','1510',2,90.00,72.00,'2024-11-10','Crédito ',NULL,1),(39096,16200,'Ivan Segreda ','014046-112024',22,1,'Barceló Tambor Beach ','SJO Airport ','1510',2,90.00,72.00,'2024-11-14','Crédito ',NULL,1),(39097,16462,'Sophie ravel','014047-112024',60,2,'Nosara Paradise Rental at 12md','Liberia Airport','00100001040000018072',2,140.00,130.00,'2024-12-26','Paid CCAT Link',NULL,1),(39098,274,'Jose Antonio Quesada','014048-112024',78,1,'Rosti Pollos Dennys Alajuela','Cabuya Center','1640',2,70.00,70.00,'2024-11-09','Cobrar $70 al cliente Resv Oslin',NULL,1),(39099,274,'Álvarez Barboza ','014049-112024',70,1,'Entrada Calle Vista Naranja ','SJO Gran Hotel CR ','1708',1,45.00,45.00,'2024-11-09','Pair Sinpe Leandro ',NULL,1),(39100,16462,'Julia Brunke','014050-112024',60,2,'Casa Playa Tamarindo at 10am','Liberia Airport','00100001040000018073',2,120.00,110.00,'2024-11-09','Paid CCAT Link',NULL,1),(39101,149,'Jasper Welling','014051-112024',70,1,'Perfect Sunset School Hermosa ST at 6:15am','SJO Airport','00100001040000018074',1,80.00,77.00,'2024-11-15','Paid CCAT Link',NULL,1),(39102,16462,'Hannes Ueck','014052-112024',76,1,'Selina SJO','Selina North Santa Teresa','00100001040000018075',1,60.00,57.00,'2024-11-09','Paid CCAT Link',NULL,1),(39103,16462,'Lauren Renee','014053-112024',20,1,'Soda Tiquicia','10 Pies Nosara','00100001040000018076',2,120.00,114.00,'2024-11-12','Paid CCAT Link',NULL,1),(39104,16446,'Teagan Litten','014054-112024',88,1,'El Sano Banano Rest.','SJO Airport','00100001040000018077',2,120.00,114.00,'2024-11-10','Paid CCAT Link',NULL,1),(39105,16462,'Audrey Mandaro','014055-112024',5,1,'Liberia Airport El Patio Cafe','Cafe de Paris Nosara','00100001040000018078',2,100.00,95.00,'2024-11-10','Paid CCAT Link',NULL,1),(39106,16446,'Sara Groom','014056-112024',60,2,'Hotel Las Tortuga\'s Playa Grande at 10:00am','Casa Kaiman Nosara','00100001040000018079',1,140.00,130.00,'2024-11-16','Paid CCAT Link',NULL,1),(39107,149,'Sidney Haga','014057-112024',70,1,'Believe Surf & Yoga','SJO Airport','00100001040000018080',1,60.00,57.00,'2024-12-22','Paid CCAT Link',NULL,1),(39108,16159,'Laurie Laberge ','014058-112024',6,1,'Casa Pura Vida Surf Hostel','Santa Teresa Zenaida Surf Garden','0917',1,60.00,48.00,'2024-11-10','Cobrar $48 Hotel',NULL,1),(39110,16462,'Stephanie Gordon','014060-112024',20,1,'OSA Rest.','Liberia Airport','00100001040000018081',1,60.00,57.00,'2024-11-12','Paid CCAT Link',NULL,1),(39111,16462,'Sophie Bouvier','014061-112024',71,1,'Plaza Royal Apart','Holiday Inn Express Alajuela ','00100001040000018082',1,60.00,57.00,'2024-11-10','Paid CCAT Link',NULL,1),(39112,16154,'Caroline Debons','014062-112024',4,1,'Tico Adventure Lodge','Santa Teresa Eat Street Rest.','1048',1,50.00,40.00,'2024-11-16','Cobrar $40 Cliente',NULL,1),(39113,245,'Nicole Lichtner','014063-112024',3,1,'Sendero Hotels and Villas','Santa Teresa Ventura Hotel','96163474',2,120.00,96.00,'2024-11-11','Paid Deposito 96163474',NULL,1),(39114,16462,'Karin Fuchs','014064-112024',3,1,'Selina Nosara','Mai ke Kai Surf House Tamarindo','00100001040000018083',1,50.00,47.00,'2024-11-10','Paid CCAT Link',NULL,1),(39115,16462,'Melodie Ramon','014065-112024',20,1,'Entrance out Surf Paradise','Selina Nosara','00100001040000018084',1,60.00,57.00,'2024-11-10','Paid CCAT Link',NULL,1),(39116,16462,'Phillip Borelli','014066-112024',4,1,'Hotel Bellavista suites','Liberia Airport','00100001040000018085',1,50.00,47.00,'2024-11-11','Paid CCAT Link',NULL,1),(39117,16462,'Noa Imhof','014067-112024',70,1,'Entrance out Zeneidas Surf Garden','SJO Airport','00100001040000018086',1,60.00,57.00,'2024-11-10','Paid CCAT Link',NULL,1),(39118,16462,'Cory Chilton','014068-112024',70,1,'Kooks Smoke Bar','SJO Airport','00100001040000018087',1,60.00,57.00,'2024-11-10','Paid CCAT Link',NULL,1),(39119,16462,'Karyn Eldredge','014069-112024',60,2,'Liberia Airport El Patio Cafe Britt ( JB 1691 ) at 3pm','Hotel Giada Samara','00100001040000018088',1,125.00,115.00,'2024-12-03','Paid CCAT Link',NULL,1),(39120,16462,'Karyn Eldredge','014070-112024',60,2,'Air Holistic Samara at 8am','Liberia Airport','00100001040000018089',1,125.00,115.00,'2024-12-12','Paid CCAT Link',NULL,1),(39121,16462,'Toni Schatz','014071-112024',60,2,'Nosara Beach Hotel at 9:00am','Liberia Airport','00100001040000018090',4,140.00,130.00,'2024-11-10','Paid CCAT Link',NULL,1),(39122,274,'Julia Bernard','014072-112024',3,1,'Rinde Más at 7:45am','Hermosa ST Center','1409',1,80.00,68.00,'2024-11-14','Cobrar $68 Cliente Reserva Dani Sta Teresa Advtures',NULL,1),(39123,16462,'Elon Peterson','014073-112024',6,1,'Zulu surf hotel','The Gilded Iguana, Nosara','00100001040000018091',1,50.00,47.00,'2024-11-12','Paid by CCAT Link',NULL,1),(39124,16462,'Molly Blauvelt','014074-112024',60,2,'Batsu Resto Bar Nosara at 7am','Liberia Airport','00100001040000018092',1,140.00,130.00,'2024-11-11','Paid by CCAT Link',NULL,1),(39125,16462,'Maya Visbeck','014075-112024',78,1,'Sjo Airport malinche restaurant','Focaccia Rest MalPais ','00100001040000018093',1,60.00,57.00,'2024-11-11','Paid by CCAT Link',NULL,1),(39126,47,'Matt Biggs','014076-112024',46,1,'Casa del Toro Hotel','Santa Teresa Don Jhon’s Hostel','1540',2,120.00,96.00,'2024-11-10','Cobrar $120 Cliente & Pend Comi Leandro pago comi',NULL,1),(39127,16446,'Avery Ross','014077-112024',5,1,'Hilton Garden Liberia','Nautilus Boutique Hotel Santa Teresa','00100001040000018094',1,60.00,57.00,'2024-11-10','Paid by CCAT Link',NULL,1),(39128,16462,'Tal Matzliah','014078-112024',6,1,'Selina Tamarindo at 8:40am','Somos Hostel Santa Teresa','00100001040000018095',1,60.00,57.00,'2024-11-10','Paid by PayPal',NULL,1),(39129,149,'Alissa Purdy','014079-112024',60,2,'LIR Airport Flight UA550 at 5:00pm ',' Tamarindo Wyndham Resort','00100001040000018096',3,120.00,110.00,'2025-01-19','Paid by PayPal',NULL,1),(39130,249,'Al McManaman ','014080-112024',4,1,'Samara Las Palmeras Condominium','Tamarindo Whitestone Parkview','26481',2,100.00,80.00,'2024-11-13','Crédito ',NULL,1),(39131,274,'Francesca ','014081-112024',123,1,'Bomba vieja ','San José','2929',1,0.00,0.00,'2024-11-10','Cpl',NULL,1),(39132,16462,'Jeffery S Johnson','014082-112024',3,1,'Organico Bakery Nosara at 8am','Eat Street, Santa Teresa','00100001040000018097',1,60.00,57.00,'2024-11-10','Paid by CCAT Link',NULL,1),(39133,16446,'Monica Marani','014083-112024',74,1,'Calala logde Cabuya at 6:30 am ','Gran Hotel Costa Rica SJO','00100001040000018098',1,60.00,57.00,'2024-11-22','Paid by CCAT Link +39 338 412 9138',NULL,1),(39134,16446,'Emily Johnson','014084-112024',72,1,'Amor de Mar montezuma at 7:00 am','Liberia Airport','00100001040000018099',2,120.00,114.00,'2025-01-24','Paid by CCAT Link',NULL,1),(39135,16446,'Emily Johnson','014085-112024',5,1,'Liberia Airport patio cafe at 9:00 am ','MTZ Hotel Amor de Mar','00100001040000018100',2,120.00,114.00,'2025-01-19','Paid by CCAT Link',NULL,1),(39136,16446,'Jenna Johns','014086-112024',20,1,'Eat Street Rest Santa Teresa at 6:30am','Liberia Airport','00100001040000018101',1,60.00,57.00,'2024-11-10','Paid by CCAT Link',NULL,1),(39137,16462,'Mark Delaney','014087-112024',3,1,'Casa Pochote Nosara at 8am','Somos Hostel Santa Teresa','00100001040000018102',1,60.00,57.00,'2024-11-10','Paid by CCAT Link',NULL,1),(39138,16505,'Melody','014088-112024',20,1,'Kooks Bar ','Tamarindo Coral Reef','1800',2,120.00,100.00,'2024-11-10','Cobrar $100 Cliente ',NULL,1),(39139,16446,'Ryan J Park','014089-112024',6,1,'Selina Tamarindo at 8:40 am','Santa Teresa HTB','00100001040000018103',1,60.00,57.00,'2024-12-03','Paid by CCAT Link',NULL,1),(39140,1,'FLOR TORRES','014090-112024',6,1,'Pasatiempo Hotel','Hotel El Jardín Montezuma ','9954021',1,60.00,48.00,'2024-11-11','Crédito ',NULL,1),(39141,16462,'Jason Camilo','014091-112024',60,2,'SJO Airport Malinche Rest ( UA 1080 ) at 1pm','Wyndham Resort, Tamarindo ','00100001040000018104',3,295.00,285.00,'2024-12-26','Paid by CCAT Link',NULL,1),(39142,16446,'Olivia Jill Roma Grabowski','014092-112024',6,1,'Selina Tamarindo ','Selina Sur Santa Teresa','00100001040000018105',1,60.00,57.00,'2024-11-12','Paid by CCAT Link cancelo de ultimo momento',NULL,1),(39143,274,'Joshua y Junior','014093-112024',28,1,'Panaderia Cabuya at 6:30 am','Liberia Airport','54684',2,60.00,60.00,'2024-11-10','Cobrar 30.000 colones al cliente',NULL,1),(39145,274,'María Yesca Torrentes','014095-112024',28,1,'Panaderia Cabuya at 6:30 am','Liberia Airport','654168',1,30.00,30.00,'2024-11-10','Cobrar 15.000 colones al cliente',NULL,1),(39146,16446,'Bethany Wentz','014096-112024',46,1,'Ticos restaurant Monteverde at 6:00 am',' Balcon Del Mar Montezuma ','00100001040000018108',2,130.00,121.00,'2024-12-31','Paid by CCAT Link',NULL,1),(39147,16446,'Bethany Wentz','014097-112024',72,1,'Amor de Mar montezuma at 7:00 am','Liberia Airport','00100001040000018109',2,120.00,114.00,'2025-01-04','Paid by CCAT Link',NULL,1),(39148,16446,'Uli Brodbeck','014098-112024',78,1,'Sjo Airport malinche restaurant','Santa Teresa HTB','00100001040000018110',1,60.00,57.00,'2024-11-10','Paid by PayPal',NULL,1),(39149,16519,'Diamond Care','014099-112024',60,2,'LIR Airport Flight X at 2:05pm','MTZ Aves Resort','0711',1,260.00,260.00,'2024-11-10','hotel pago neto a Leandro',NULL,1),(39150,16470,'Johanna','014100-112024',6,1,'TamaHostel & Glanping','Samara Hostel','0735',1,50.00,40.00,'2024-11-10','Cobrar $40 Hotel',NULL,1),(39151,16446,'Michael Sydor','014101-112024',60,2,'Liberia Airport flight United 3039 at 10:45 am','Nammbu in Carrillo','00100001040000018111',1,125.00,115.00,'2024-11-10','Paid by PayPal',NULL,1),(39152,16446,'Annika Knutsen','014102-112024',3,1,'selina nosara at 7:45 am','Selina Tamarindo','00100001040000018112',1,50.00,47.00,'2024-11-10','Paid by CCAT Link',NULL,1),(39153,16446,'Tony Audin','014103-112024',5,1,' Liberia Airport at 9:00 am','Nosara Rinde Mas','00100001040000018113',1,50.00,47.00,'2024-11-14','Paid by CCAT Link',NULL,1),(39154,16446,'Niklas Janz','014104-112024',4,1,'Superdelfin','ASVO Montezuma','00100001040000018115',2,120.00,114.00,'2024-11-10','Paid by CCAT Link',NULL,1),(39155,16462,'Carmen Lee','014105-112024',56,1,'Jardin de Orquideas Monteverde at 7:45am',' Hotel Tabasco, Potrero ','00100001040000018116',2,140.00,131.00,'2024-11-11','Paid by PayPal / Opera Roca Verde',NULL,1),(39156,16446,'Johan Sunden','014106-112024',49,1,'Selina La Fortuna','Buena Onda Bungalows','00100001040000018118',2,130.00,125.00,'2024-12-31','Paid by CCAT Link',NULL,1),(39157,16446,'Emile Pottier','014107-112024',78,1,'Toucan hostel Alajuela at 6:30 am ','Lost Boyz Santa teresa','00100001040000018119',1,60.00,57.00,'2024-12-01','Paid by CCAT Link',NULL,1),(39158,16446,'Yuki Kaneko','014108-112024',5,1,' Hampton by Hilton Liberia at 9:00 am','Cobano Center','00100001040000018120',1,60.00,57.00,'2024-11-11','Paid by CCAT Link',NULL,1),(39159,16446,'Tierza Leanne Eichner','014109-112024',78,1,'Holiday Inn Express San Jose Costa Rica Airport at 6:30 am','Tropico Latino Santa Teresa','00100001040000018121',1,60.00,57.00,'2024-11-11','Paid by CCAT Link +1 (541) 647-3339',NULL,1),(39160,16446,'Rosie Donnelly','014110-112024',70,1,'Eat street santa teresa at 6:45 am ','selina san jose','00100001040000018122',2,120.00,114.00,'2025-03-10','Paid by CCAT Link',NULL,1),(39161,16446,'Rosie Donnelly','014111-112024',49,1,'Cabanas del Lago, La Fortuna','Eat Street, Santa Teresa','00100001040000018123',2,130.00,121.00,'2025-03-04','Paid by CCAT Link',NULL,1),(39162,16446,'Hanne Christine Engelsen	','014112-112024',70,1,'Lapoint santa teresa at 6:45 am','Dennys Alajuela','00100001040000018124',1,60.00,57.00,'2024-11-11','Paid by CCAT Link',NULL,1),(39163,16446,'Armance Sherman','014113-112024',20,1,'Sabores de mi Tierra','LIR Airport','00100001040000018125',1,60.00,57.00,'2024-11-11','Paid by CCAT Link',NULL,1),(39164,16446,'Kyle Leahy','014114-112024',60,2,'Hampton hotel Liberia at 10:00 am ','Nosara HTB','00100001040000018126',4,140.00,130.00,'2025-01-08','Paid by CCAT Link',NULL,1),(39165,16446,'Katrine Samdal','014115-112024',20,1,'Cabinas surf hostel main entrance at 6:30 am ','ONDA Playa grande GTE ','00100001040000018127',2,120.00,110.00,'2024-11-11','Paid by CCAT Link',NULL,1),(39166,16446,'Russ Hoefer','014116-112024',60,2,'Liberia Airport flight AA2411 at 1:00 PM','Casa Blanca Nosara','00100001040000018128',9,240.00,230.00,'2024-12-23','Paid by CCAT Link',NULL,1),(39167,16446,'Stewart Fefer','014117-112024',60,2,'LIR Airport Flight Aa 1383 AT 3:00 pm','Wyndham tamarindo','00100001040000018129',2,120.00,110.00,'2024-12-10','Paid by CCAT Link',NULL,1),(39168,274,'Clever Diaz','014118-112024',8,1,'Cruce Pueblo Viejo','MTZ Center','1122',1,30.00,30.00,'2024-11-11','Cobrar 15.000 Cliente Local',NULL,1),(39169,16446,'Russ Hoefer','014119-112024',60,2,'Casa Blanca Nosara at 8:00 am','Liberia Airport','00100001040000018130',9,240.00,230.00,'2024-12-31','Paid by CCAT Link',NULL,1),(39170,16446,'Alexander Roth','014120-112024',34,1,'Zeneidas Surf Garden santa teresa at 6:45 am',' La Fortuna Poshtel','00100001040000018131',2,130.00,141.00,'2024-11-11','Paid by PayPal',NULL,1),(39171,16446,'Ella Dunthorne','014121-112024',95,1,'Hotel El Jardin','Casa Jungle Monteverde Bed & Breakfast','00100001040000018132',2,130.00,124.00,'2025-01-25','Paid CCAT Link',NULL,1),(39172,16446,'Lucas Beltram','014122-112024',78,1,'SJO Airport Malinche Rest','Hostel Casa del Sol Santa Teresa','00100001040000018133',2,120.00,114.00,'2024-12-21','Paid CCAT Link',NULL,1),(39173,16446,'Wendy Chaves','014123-112024',124,1,'Banco Nacional','Rinde Mas Nosara','00100001040000018134',1,60.00,57.00,'2024-11-11','Paid CCAT Link',NULL,1),(39174,16446,'Katrina Spencer','014124-112024',70,1,'Don Jons Hostel','SJO Airport','00100001040000018135',1,60.00,57.00,'2025-01-25','Paid CCAT Link',NULL,1),(39175,558,'Jasmin','014125-112024',4,1,'THE INNER LIGHT YOGA LODGE','Tamarindo Centro','42361',2,100.00,80.00,'2024-11-11','Crédito ',NULL,1),(39176,16200,'Luis Humberto Novoa tel. +573118485487','014126-112024',59,2,'SJO Airport at 9:20am Vuelo: AV 696','Barcelo Tambor','014126',2,220.00,220.00,'2024-11-11','Crédito ',NULL,1),(39177,16200,'Luis Humberto Novoa tel. +573118485487','014127-112024',22,1,'Barcelo Tambor','SJO Airport','014127',2,72.00,72.00,'2024-11-14','Crédito ',NULL,1),(39178,16446,'Deborah Adeney','014128-112024',63,1,'Acacia Villas Guanacaste','Montezuma Bus Stop','00100001040000018136',2,120.00,114.00,'2024-11-16','Paid CCAT Link stand by',NULL,1),(39179,16132,'Emma Williams','014129-112024',76,1,'DoubleTree Hilton Cariari 6:00am','Cabuya Wild Sun Center','1632',1,60.00,48.00,'2024-11-11','Cobrar $60 Cliente & Pend Comi ‪',NULL,1),(39180,257,'Annika Denzler','014130-112024',6,1,'Coral Reef Surf Hostel and Camp','Habitat Surf Glamp Santa Teresa','014130',2,120.00,96.00,'2024-11-11','Crédito ',NULL,1),(39181,149,'Cecilia Correa','014131-112024',33,1,'Perfect Sunset School Hermosa ST at 6:10am','Santa Elena MTV Posada Sta Elena','00100001040000018137',2,140.00,133.00,'2024-11-11','Paid CCAT Link',NULL,1),(39182,16588,'Laura Peretti','014132-112024',6,1,'Selina Tamarindo','Burnt Toast Surfcamp Nosara','014132',1,50.00,40.00,'2024-11-11','Paid Net CCAT Link',NULL,1),(39183,16462,'Emma Brown	','014133-112024',45,3,'Salty Enthusiasts Santa Teresa at 9:00am ','MTZ Waterfalls','00100001040000018138',3,40.00,35.00,'2024-11-11','Paid CCAT Link',NULL,1),(39184,149,'Emma Brown	','014134-112024',45,3,'Butterfly Brewing Co. MTZ at 6:00pm ','Santa Teresa Salty Enthusiasts','00100001040000018138',3,40.00,35.00,'2024-11-11','Paid CCAT Link',NULL,1),(39185,16446,'Emma Brown	','014135-112024',70,1,'Salty Enthusiasts','SJO Airport','00100001040000018138',1,60.00,57.00,'2024-12-05','Paid CCAT Link',NULL,1),(39186,16462,'Britt Dielemans','014136-112024',6,1,'La Botella de Leche Hostel','Santa Teresa Cafe Social ','00100001040000018139',1,60.00,57.00,'2024-11-11','Paid CCAT Link',NULL,1),(39187,274,'Abigail','014137-112024',71,1,'Servicentro de Cobano','SJO Airport','014137',2,0.00,0.00,'2024-11-11','CPL Pollo Approved',NULL,1),(39188,16462,'Christopher Alford	','014138-112024',60,2,'Selina Hostel Tamarindo at 10:30am','LIR Airport','00100001040000018140',1,120.00,110.00,'2024-11-11','Paid CCAT Link',NULL,1),(39189,149,'Benjamin Vega','014139-112024',60,2,'Condovac La Costa Hermosa GTE at 5:00pm ','SJO Hotel TBD','00100001040000018141',5,315.00,305.00,'2024-12-26','Paid CCAT Link',NULL,1),(39190,149,'Benjamin Vega','014140-112024',60,2,'SJO Hotel TBD at 7:00am','Hermosa GTE Condovac La Costa','00100001040000018141',5,315.00,305.00,'2024-12-25','Paid CCAT Link',NULL,1),(39191,149,'Celina Brander	','014141-112024',70,1,'Dream Surf House Hermosa ST at 6:10am ','SJO Airport','00100001040000018142',1,80.00,77.00,'2024-11-11','Paid CCAT Link',NULL,1),(39193,16462,'Jack Hemstreet','014143-112024',20,1,'Suna Rest.','LIR Airport','00100001040000018145',2,120.00,114.00,'2024-11-30','Paid CCAT Link',NULL,1),(39194,16446,'Jason Camilo	','014144-112024',60,2,'Wyndham Resort Tamarindo at 10:00am ','SJO Hilton Garden Hotel Costa Rica','00100001040000018146',2,295.00,285.00,'2025-01-01','Paid CCAT Link',NULL,1),(39195,16462,'Kaitlyn Dickie','014145-112024',20,1,'Soda Pura Vida','LIR Airport','00100001040000018147',2,120.00,114.00,'2024-12-09','Paid CCAT Link',NULL,1),(39196,149,'Cormac Ostrom	','014146-112024',72,1,'Amor de Mar Hotel','Nosara Selina Hostel ','00100001040000018148',1,60.00,57.00,'2024-11-11','Paid CCAT Link STAND BY',NULL,1),(39198,16446,'Valentina Jeske','014148-112024',70,1,'Entrance out El Gato Rojas Hostel','SJO Airport','00100001040000018150',1,60.00,57.00,'2024-11-25','Paid Paypal',NULL,1),(39199,149,'Ben Cecchini	','014149-112024',4,1,'Marisquería La Cabaña Nicoya at 9:30am','LIR Airport','00100001040000018151',1,45.00,42.00,'2024-11-25','Paid CCAT Link',NULL,1),(39200,16401,'Victoria','014150-112024',31,1,'Ferry Paquera 10:15am','Santa Teresa','014150',2,40.00,40.00,'2024-11-11','Crédito ',NULL,1),(39201,16446,'Gabrielle Spelman	','014151-112024',3,1,'Green Sanctuary Hotel ','Santa Teresa Somos Hostel','00100001040000018152',2,120.00,114.00,'2024-12-17','Paid CCAT Link',NULL,1),(39202,149,'Denise Halverson','014152-112024',6,1,'Sunrise Condos ','Nosara Verde','00100001040000018153',2,100.00,95.00,'2024-11-15','Paid CCAT Link',NULL,1),(39203,16462,'Dan Ivry	','014153-112024',20,1,'Anis Bowls & Salad','Nosara Moana Surf Resort','00100001040000018154',1,60.00,57.00,'2024-11-12','Paid CCAT Link',NULL,1),(39204,16563,'Gregor Buchmüller','014154-112024',60,2,'The Inner Light Yoga Lodge Samara at 11:00am','Nosara Blue Spirit Retreat Center','195030',2,70.00,70.00,'2025-03-29','Pend Deposit $79.10 ',NULL,1),(39205,16462,'Josua Harvey','014155-112024',60,2,'Hotel Lluvia de Oro SJO at 12:30pm','Manuel Antonio Hotel Villa Lirio','00100001040000018155',7,290.00,280.00,'2024-11-12','Paid CCAT Link',NULL,1),(39206,16187,'Agnes Almayrac','014156-112024',70,1,'Believe Surf & Yoga','SJO Airport','34980',1,60.00,48.00,'2024-11-13','Credito',NULL,1),(39207,16462,'Bailey Vernon','014157-112024',60,2,'LIR Airport Flight AC 1331 at 3:00pm','Santa Teresa Somos Rest.','00100001040000018156',3,260.00,250.00,'2024-11-21','Paid CCAT Link cliente avisado del cierre en el correo',NULL,1),(39208,16446,'Tom Winter','014158-112024',78,1,'Courtyard by Marriott SJO Airport','Santa Teresa Nantipa Resort','00100001040000018157',2,120.00,114.00,'2024-12-08','Paid CCAT Link',NULL,1),(39209,63,'Marjorie Garon','014159-112024',4,1,'Hotel Entre Dos Aguas','Hotel Tajalin Montezuma','014159',1,60.00,48.00,'2024-11-12','Credito ',NULL,1),(39210,246,'Sabrina','014160-112024',6,1,'Villas Macondo Tamarindo','Rinde Mas Nosara','014160',1,50.00,40.00,'2024-11-12','Cobrar $40 a Villas Macondo',NULL,1),(39211,305,'Bryan McKinlay','014161-112024',4,1,'Hotel El Pequeño Gecko Verde','Liberia  Hotel Hampton by Hilton','014161',1,50.00,40.00,'2024-11-15','PAID CCAT Link $45.20',NULL,1),(39212,139,'Hames lohr','014162-112024',6,1,'Coral Reef Surf Hostel and Camp','Entrance Lost Boyz Santa Teresa','014162',3,180.00,144.00,'2024-11-12','Cobrar $144 a Coral Reef',NULL,1),(39213,274,'Francini Elisondo +506 8706 9578','014163-112024',124,1,'Servicentro Cobano','Liberia ','014163',1,30.00,30.00,'2024-11-12','Cobrar 15mil al cliente local',NULL,1),(39214,16200,'Benjamin Barrios','014164-112024',59,2,'Barcelo Tambor at 5:30am','SJO Airport','014164',2,220.00,220.00,'2024-11-16','Credito ',NULL,1),(39215,16462,'Adam Getthings','014165-112024',45,3,'Cobano Airport at 5pm',' Hotel Casa Azul, Santa Teresa','00100001040000018158',1,40.00,35.00,'2024-12-07','Paid CCAT Link',NULL,1),(39216,16462,'Matthias Koch','014166-112024',78,1,'Holliday Inn Express Alajuela','Lapoint Surfcamp MalPais','00100001040000018159',1,60.00,57.00,'2024-11-16','Paid CCAT Link',NULL,1),(39217,16462,'Janice Reid','014167-112024',59,2,'Pension Santa Elena Monteverde at 9am','Cabinas Mar y Cielo Montezuma','00100001040000018160',4,240.00,230.00,'2024-12-17','Paid CCAT Link',NULL,1),(39218,149,'Dante Haques','014168-112024',70,1,'Sabores de mi Tierra ','Park Inn San Jose by Radisson','00100001040000018161',1,60.00,57.00,'2024-11-13','Paid CCAT Link',NULL,1),(39219,16462,'Paul Noetling','014169-112024',78,1,'Fairfield Marriott Alajuela','Escuela La Abuela Tambor','00100001040000018162',3,180.00,171.00,'2025-01-14','Paid CCAT Link',NULL,1),(39220,16462,'Paul Noetling','014170-112024',45,3,'Caseta guarda Tango Mar at 7am','Zuma Tours Offcce Montezuma','00100001040000018163',3,40.00,35.00,'2025-01-17','Paid CCAT Link',NULL,1),(39221,16462,'Isabelle Lenherr','014171-112024',59,2,'SJO Airport Malinche Rest ( AV 646 ) at 3pm','Zopilote Surf Camp Hermosa ST','00100001040000018165',1,240.00,230.00,'2024-11-12','Paid CCAT Link',NULL,1),(39222,149,'Stephen Shinopoulos','014172-112024',60,2,'Hampton by Hilton GTE LIR at 11:30am','SJO Stolas Coliving','00100001040000018166',1,260.00,250.00,'2024-12-01','Paid CCAT Link',NULL,1),(39223,16246,'Nives Baumann','014173-112024',6,1,'Selina Tamarindo','Blue Iguana Samara','014173',2,100.00,80.00,'2024-11-12','PAID by CCAT Link/ Pending Commision',NULL,1),(39224,16462,'Deborah B Schneider','014174-112024',88,1,' Hotel El Jardin MOntezuma at 7am',' SJO Airport','00100001040000018167',2,120.00,114.00,'2024-11-24','Paid by CCAT Link',NULL,1),(39225,257,'Maria José','014175-112024',6,1,'Correos de Costa Rica Villareal','Alma Tropical Santa Teresa','014175',1,0.00,0.00,'2024-11-12','CPL',NULL,1),(39226,257,'Maria José','014176-112024',20,1,'Entrance out Alma Tropical MP','Cobano Airport COB','014176',1,0.00,0.00,'2024-11-14','CPL',NULL,1),(39227,16462,'Bailey Howington','014177-112024',5,1,'Hotel Boyeros Liberia at 8:40am','Castillo de Arena Samara ','00100001040000018169',2,100.00,95.00,'2025-01-05','Paid by CCAT Link',NULL,1),(39228,16462,'Mollie Quasebarth','014178-112024',60,2,' LIR Airport El Patio Cafe Britt AA 1377 at 12:50pm','Casa Lumenez Samara','00100001040000018168',12,360.00,350.00,'2024-11-27','Paid CCAT Link',NULL,1),(39229,16462,'Nina Quasebarth','014179-112024',60,2,'Casa Lumenez Samara at 9:00am','Liberia Airport','00100001040000018168',12,360.00,350.00,'2024-12-02','Paid Paypal',NULL,1),(39230,149,'Andy Sestric','014180-112024',60,2,'LIR Airport Flight UA 1737 at 6:15pm','Nosara AirBnB Section K House ','00100001040000018170',2,140.00,130.00,'2024-11-13','Paid by CCAT Link',NULL,1),(39231,16446,'Alexandra Grauvogl','014181-112024',20,1,'Selina Sur santa teresa at 6:30 am ','Tamarindo Center','00100001040000018172',1,60.00,57.00,'2024-11-14','Paid by CCAT Link',NULL,1),(39232,16462,'Kate Malkinson','014182-112024',20,1,'Soda Tikicia Santa Teresa at 6:30am','Liberia Airport','00100001040000018173',1,60.00,57.00,'2024-11-13','Paid by CCAT Link',NULL,1),(39233,16446,'Anna Formankova','014183-112024',4,1,' Roots Bakery & Cafe Samara at 9:00 am',' La botella de Leche Tamarindo','00100001040000018174',1,50.00,47.00,'2024-11-14','Paid by CCAT Link',NULL,1),(39234,16446,'Molly Karp','014184-112024',33,1,' Atrapasueños Hotel ','Sloth hostel Monteverde ','00100001040000018175',2,130.00,121.00,'2024-11-13','Paid CCAT Link Hace Roca Verde',NULL,1),(39235,16462,'Christoffer','014185-112024',70,1,' Cafe Social, Santa Teresa  at 6:45 am ','Hilton Garden Inn, San Jose La Sabana ','00100001040000018176',2,120.00,114.00,'2024-11-12','Paid by CCAT Link',NULL,1),(39237,257,'Ellie Bousquet','014187-112024',3,1,'Living Hotel','The Beach Bungalows Tamarindo','014187',1,50.00,40.00,'2024-11-13','Credito ',NULL,1),(39238,16446,'Rosanvallon Bruno','014188-112024',76,1,'Autentico Hotel SJO at 5:30am',' Santeria Lodge Santa Teresa ','00100001040000018177',3,180.00,141.00,'2024-12-16','Paid by CCAT Link',NULL,1),(39239,149,'Sallie Hoefer','014189-112024',60,2,'Casa Blanca nosara at 10:00 am','Liberia Airport','00100001040000018178',3,140.00,130.00,'2024-12-31','Paid by CCAT Link cobrar $10 extra y llevar silla de beb 2 años',NULL,1),(39240,149,'Adriana Alva','014190-112024',60,2,'Canal Grande Lodge SJO at 10:00am',' Tamarindo Pacific Kalokairi ','00100001040000018179',2,297.00,287.00,'2024-11-13','Paid by CCAT Link',NULL,1),(39241,149,'Adriana Alva','014191-112024',60,2,'Pacific Kalokairi Tamarindo at 10:00am','La Fortuna Chachagua Rainforest Hotel ','00100001040000018180',2,280.00,270.00,'2024-11-15','Paid by CCAT Link',NULL,1),(39242,16462,'Larry Rusoff','014192-112024',60,2,'Liberia Aiport flight at AA37 AT 2:55 PM ',' Arenal Kioro hotel ','00100001040000018181',7,310.00,300.00,'2024-12-21','Paid by CCAT Link',NULL,1),(39243,16462,'Larry Rusoff','014193-112024',60,2,' Liberia Airport flight JetBlue at 12:03 pm','Arenal Kioro hotel ','00100001040000018181',4,250.00,240.00,'2024-12-21','Paid by CCAT Link',NULL,1),(39244,16424,'Ryan','014194-112024',5,1,'Liberia Airport ','Santa Teresa Eat Street ','101941',1,60.00,48.00,'2024-11-14','Credito ',NULL,1),(39245,16446,'James Brookes','014195-112024',20,1,'Zeneidas Santa Teresa ',' Mai Ke kai surfhouse Tamarindo','00100001040000018182',1,60.00,57.00,'2024-11-19','Paid by PayPal',NULL,1),(39246,16446,'Melodie Ramon','014196-112024',3,1,'Selina Nosara at 7:45 am','Luminosa hostel Montezuma','00100001040000018183',1,60.00,57.00,'2024-11-13','Paid by CCAT Link',NULL,1),(39247,16446,'Russel Surujbally	','014197-112024',9,1,'Los Delfines main entrance Tambor at 7:30 am','Liberia Airport','00100001040000018184',1,60.00,57.00,'2024-11-13','Paid by CCAT Link',NULL,1),(39248,257,'Caroline Hornum','014198-112024',6,1,'Refugio Lodge','Eat Street Santa Teresa ','014198',1,60.00,48.00,'2024-11-13','Credito ',NULL,1),(39249,16462,'Paul Noetling','014199-112024',60,2,'The Falls Hotel Manuel Antonio at 12md','Alajuela Fairfield by Marriott SJO Airport','00100001040000018185',3,230.00,220.00,'2025-01-20','Paid by CCAT Link',NULL,1),(39250,16446,'Keith Woloshun	','014200-112024',60,2,'Liberia Airport flight SAW 0691 at 3:00 PM ','Hotel Boutique Lagarta Lodge nosara','00100001040000018186',2,140.00,130.00,'2024-11-14','Paid by CCAT Link',NULL,1),(39251,257,'Avneen','014201-112024',6,1,'Wyndham Tamarindo','Selina Nosara','014201',1,50.00,40.00,'2024-11-13','Credito ',NULL,1),(39252,16446,'Vito Barrasso','014202-112024',3,1,'Hotel Guiones at 7:45 am','Liberia Airport','00100001040000018187',3,180.00,171.00,'2024-11-19','Paid by CCAT Link +1 (705) 888-2373 stand by',NULL,1),(39253,149,'Adriana Alva','014203-112024',60,2,' Chachagua Rainforest Hotel La Fortuna at 5:00pm',' SJO El  Rodeo Estancia Boutique Hotel','00100001040000018188',2,180.00,170.00,'2024-11-18','Paid by CCAT Link',NULL,1),(39254,16446,'Raphael Spero','014204-112024',20,1,'MarAmar main entrance at 6:30 am ','Hotel Villas Tangerine Samara','00100001040000018189',1,60.00,57.00,'2024-11-13','Paid by CCAT Link',NULL,1),(39255,16446,'Thomas Ross','014205-112024',72,1,'Zumatours Office','Potrero GTE Villas Pura Vibra','00100001040000018190',2,120.00,114.00,'2024-11-13','Paid by CCAT Link',NULL,1),(39256,22,'Megan','014206-112024',20,1,'Entrance Fuego Lodge Santa Teresa ','Green Sanctuary Hotel Nosara','014206',2,120.00,96.00,'2024-11-13','Credito ',NULL,1),(39257,16570,'José Arias','014207-112024',20,1,'Lifeguard por plaza futbol Santa Teresa','Lifeguard Nosara','6711',1,30.00,30.00,'2024-11-13','Crédito ',NULL,1),(39258,16213,'Daniel Brandenburger','014208-112024',6,1,'In The Shade Hotel Tamarindo','Samara','014208',1,50.00,40.00,'2024-11-13','Cobrar $40 a In the Shade Hotel ',NULL,1),(39259,16446,'Shai Siegel','014209-112024',20,1,'Plaza Royal','Nosara Organico Market','00100001040000018191',1,60.00,57.00,'2024-11-13','Paid CCAT Link',NULL,1),(39260,16462,'Emil Ingridsson','014210-112024',60,2,'RipJack Playa Grande at 1pm','Private House Samara','00100001040000018192',4,135.00,125.00,'2024-12-30','Paid CCAT Link',NULL,1),(39261,16446,'Sage Hartland','014211-112024',20,1,'Entrada Main Road La Posada','Delta Gas Station Comunidad Liberia','00100001040000018193',1,60.00,57.00,'2024-11-15','Paid CCAT Link',NULL,1),(39262,16446,'Jodi Radmore','014212-112024',6,1,'Capitan Suizo Tamarindo','D Pams Malpais','00100001040000018194',2,120.00,114.00,'2024-12-04','Paid CCAT Link',NULL,1),(39263,16446,'Chloe Emond','014213-112024',78,1,'SJO Airport Malinche Rest','Lost Boyz Santa Teresa ( Entrance )','00100001040000018195',1,60.00,57.00,'2024-12-15','Paid CCAT Link',NULL,1),(39264,16200,'Sergio Jimenez','014214-112024',119,1,'Barcelo Tambor ','SJO Airport','014214',2,72.00,72.00,'2024-11-13','Credito ',NULL,1),(39265,257,'Angela Lei','014215-112024',6,1,'Witch\'s Rock Surf Camp Tamarindo','The Gilded Iguana Surf Hotel Nosara','014215',1,50.00,40.00,'2024-11-16','Credito ',NULL,1),(39266,16430,'Aman Mundra ','014216-112024',6,1,'Casa Pura Vida Surf Hostel','Santa Teresa Eat Streets Rest','1626',4,240.00,192.00,'2024-11-13','Cobrar $192 Gold Coast Bonanza 8634-4381',NULL,1),(39267,274,' Leah Rudischhauser','014217-112024',70,1,'Cafe Social ST at 6:20am','SJO Airport','1635',1,60.00,48.00,'2024-11-13','Cobrar $48 Cliente ‪7210-4925‬',NULL,1),(39268,1,'Lotta Loffler','014218-112024',20,1,'Ventura Hotel','Tamarindo Iguana Surfcamp ','9983797',1,60.00,48.00,'2024-11-18','Credito',NULL,1),(39269,16430,'Manuel Ziegler','014219-112024',6,1,'La Botella de Leche Hostel','Santa Teresa Atrapasueños Hotel ','1655',1,60.00,57.00,'2024-11-13','Cobrar $48 Gold Coast Bonanza 8634-4381',NULL,1),(39270,149,'Neal Reardon	','014220-112024',60,2,'LIR Airport Flight UA 1512 at 1:30pm ','Samara Hotel TBD','00100001040000018196',4,125.00,115.00,'2024-11-21','Paid CCAT Link cliente avisado del cierre en el correo',NULL,1),(39271,149,'Kathrine Jeffries	','014221-112024',6,1,'La Ramona Charming at 8:35am ','MTZ Amor de Mar Hotel ','00100001040000018197',2,120.00,114.00,'2024-11-14','Paid CCAT Link',NULL,1),(39272,16446,'Lena Guerrero	','014222-112024',6,1,'Tamarindo Inn ','Samara Tico Adventure Lodge','00100001040000018198',1,50.00,47.00,'2024-11-14','Paid CCAT Link',NULL,1),(39274,16159,'Ada Wingard','014224-112024',6,1,'Casa Pura Vida Surf Hostel','Santa Teresa Eat Streets Rest','1847',1,60.00,48.00,'2024-11-13','Cobrar $48 Hotel',NULL,1),(39275,16462,'Shannon Peterson	','014225-112024',60,2,'LIR Airport Flight UA 1917 at 5:00pm','Puerto Carriilo GTE Casa Midin Farm','00100001040000018199',1,125.00,115.00,'2024-11-14','Paid CCAT Link',NULL,1),(39276,149,'Perrine Nauleau','014226-112024',60,2,'Bus Station Santa Cruz at 3:30pm ','Santa Teresa Cabinas El Cenizaro','00100001040000018200',3,260.00,250.00,'2024-11-14','Paid CCAT Link Address Pick Up by Email',NULL,1),(39277,149,'Dakota Randazzo','014227-112024',70,1,' Plaza Kahuna Santa Teresa ','SJO International Airport','00100001040000018201',2,120.00,114.00,'2024-11-19','Paid by CCAT Link cliente avisado del cierre en el correo',NULL,1),(39278,16187,'Gina Bacchiocchi','014228-112024',70,1,'Believe Surf & Yoga Santa Teresa','SJO Airport','014228',2,120.00,96.00,'2024-11-15','Credito ',NULL,1),(39279,249,'Kerry Bill','014229-112024',4,1,'WingNuts Canopy Main Road','Steak House Sal y Fuego Playas del Coco','26493',2,100.00,80.00,'2024-12-16','Credito ',NULL,1),(39280,149,'Laura White','014230-112024',72,1,'Luminosa MTZ Hostel at 7:00am','Liberia Airport','00100001040000018203',1,60.00,57.00,'2024-11-15','Paid by CCAT Link',NULL,1),(39281,16424,'Simon Andrin Weber','014231-112024',76,1,'Selina San Jose','Eat Street Santa Teresa','102273',2,120.00,96.00,'2024-11-15','Credito ',NULL,1),(39282,16446,'Alexandra Lauziere','014232-112024',20,1,'Saltys Enthuasiasts ','Liberia Airport','00100001040000018204',1,60.00,57.00,'2024-11-14','Paid by CCAT Link',NULL,1),(39283,16446,'Oliver Herzberg','014233-112024',4,1,'Woodstock hostel samara at 9:00 am','Pura vida mini hostel main entrance santa teresa','00100001040000018205',1,60.00,57.00,'2024-11-17','Paid by CCAT Link',NULL,1),(39284,16462,'Taylor Jurik','014234-112024',6,1,'Tamarindo Boho at 8:40 am','Somos Hostel Santa Teresa','00100001040000018207',1,60.00,57.00,'2024-11-14','Paid by CCAT Link',NULL,1),(39285,16446,'Emily Parlin','014235-112024',5,1,'Liberia Airport patio cafe at 9:00 am','Green sanctuary hotel Nosara','00100001040000018208',1,50.00,47.00,'2024-12-02','Paid by CCAT Link',NULL,1),(39286,16462,'Ed Thompson','014236-112024',20,1,'Somos santa teresa at 6:30 am','La botella de Leche Tamarindo','00100001040000018209',1,60.00,57.00,'2024-11-14','Paid by PayPal',NULL,1),(39287,16200,'Zaida Rodriguez  tel. 8899-2669','014237-112024',76,1,'Barcelo San Jose ','Barcelo Tambor ','014237',3,108.00,108.00,'2024-11-15','Credito ',NULL,1),(39288,16200,'Zaida Rodriguez tel. 8899-2669','014238-112024',22,1,'Barcelo Tambor ','Barcelo San Jose ','014238',3,108.00,108.00,'2024-11-17','Credito ',NULL,1),(39289,16446,'Grace Thompson','014239-112024',60,2,'Little Lucha Tamarindo at 5:30am','SJO Airport','00100001040000018210',2,325.00,315.00,'2024-11-14','Paid CCAT Link',NULL,1),(39290,16462,'Raven Ceres','014240-112024',76,1,'Hilton Garden Inn SJO La Sabana','San Isidro Calle Maria Cruz ST','00100001040000018211',1,60.00,57.00,'2024-11-17','Paid CCAT Link',NULL,1),(39291,16462,'Kevin Stoeltzien','014241-112024',78,1,'SJO Airport Malinche Rest','MalPais Surf Camp','00100001040000018212',2,120.00,114.00,'2024-11-14','Paid CCAT Link',NULL,1),(39292,274,'Vanessa','014242-112024',5,1,'Subway 8:40am','Cobano','992',1,20.00,20.00,'2024-11-14','Cobrar 10mil cliente aut. Leandro',NULL,1),(39294,70,'Sandrine Helie','014244-112024',4,1,'Las Mariposas Hostel','LIR Airport','1707',1,50.00,40.00,'2024-11-17','Cobrar $40 Hotel Mariposas',NULL,1),(39295,149,'Mathilda Olsen','014245-112024',6,1,'Selina Hostel ','Santa Teresa Cabinas Playa','00100001040000018213',1,60.00,57.00,'2024-11-15','Paid CCAT Link',NULL,1),(39297,16446,'Kelsey German	','014247-112024',47,1,'Cabinas Eddy B&B Santa Elena MTV at 6:00am','MTZ El Sano Banano Rest.','00100001040000018214',2,130.00,123.00,'2024-11-15','Paid CCAT Link Hace Roca Verde',NULL,1),(39298,149,'Peter Dudbridge	','014248-112024',33,1,'Perfect Sunset School Hermosa ST at 6:10am ','Santa Elena MTV Selina Hostel ','00100001040000018215',2,150.00,140.00,'2024-11-23','Paid Paypal',NULL,1),(39299,274,'Dayanara Barrantes +506 6452-9462‬','014249-112024',124,1,'Bomba Vieja','Santa Cruz Banco Nacional','014249',3,90.00,90.00,'2024-11-15','Cobrar 45mil al cliente local ‪',NULL,1),(39300,16446,'Lisa Marie ','014250-112024',78,1,'Hilton Garden Inn SJO Airport City Mall','Santa Teresa Entrance MarAmar','00100001040000018216',1,60.00,57.00,'2024-11-16','Paid CCAT Link',NULL,1),(39301,149,'Aleksandra Kluczniak	','014251-112024',3,1,'Entrance out Selina Hostel at 7:45am ','LIR Airport','00100001040000018217',1,50.00,47.00,'2024-11-23','Paid CCAT Link',NULL,1),(39304,16462,'Franziska Zimmer	','014254-112024',6,1,'Dreams Surfcamp at 8:50am','Samara Blue Iguana Hostel','00100001040000018220',1,50.00,47.00,'2024-11-14','Paid CCAT Link',NULL,1),(39305,149,'Sandrine Demers','014255-112024',20,1,'Entrance out Mar A Mar','LIR Airport','00100001040000018221',1,60.00,57.00,'2024-11-17','Paid CCAT Link',NULL,1),(39306,149,'Stefanie Bernier','014256-112024',20,1,'Entrance out Mar A Mar ','LIR Airport','00100001040000018222',1,60.00,57.00,'2024-11-18','Paid CCAT Link',NULL,1),(39307,16446,'Renee Callaghan	','014257-112024',3,1,'10 Pies Rest','Tamarindo Casa Playa','00100001040000018223',2,100.00,95.00,'2024-11-14','Paid CCAT Link',NULL,1),(39308,149,'Nicole Wolfe	','014258-112024',11,2,'Tabacon Thermal Resort La Fortuna at 8:30am','Santa Teresa Hotel','00100001040000018224',4,305.00,295.00,'2025-02-11','Paid CCAT Link',NULL,1),(39309,16570,'Johan Solis','014259-112024',60,2,'Ferry Puntarenas 10:30am','Lifeguard Monteverde ','901',1,100.00,80.00,'2024-11-14','Crédito ',NULL,1),(39310,16462,'Konrad Jaworski	','014260-112024',60,2,' Hotel Presidente San Jose at 10:00 am','Apartatotel Flamboyant Jaco','00100001040000018225',2,200.00,190.00,'2024-11-19','Paid CCAT Link ',NULL,1),(39311,16446,'Mathew Berna	','014261-112024',60,2,'Hotel Luna Llena Tamarindo at 8:00am','LIR Airport','00100001040000018226',2,120.00,110.00,'2024-12-21','Paid CCAT Link',NULL,1),(39312,16446,'Julian G Isidro','014262-112024',60,2,'Liberia Airport flight United 1876 at 1:00 pm','Villas Kalimba Samara','00100001040000018227',2,125.00,115.00,'2024-11-25','Paid CCAT Link',NULL,1),(39313,274,'Uriel +506 7069 5209','014263-112024',6,1,'Gollo Villa Real Tamarindo ','Santa Teresa Centro ','014263',1,30.00,30.00,'2024-11-14','Cobrar 15mil al cliente local',NULL,1),(39314,16446,'Julian G Isidro','014264-112024',60,2,'Villas Kalimba hotel samara at 11:00 am','Hotel Senda Monteverde','00100001040000018228',2,210.00,200.00,'2024-11-29','Paid CCAT Link',NULL,1),(39315,16446,'Julian G Isidro','014265-112024',60,2,'Hotel Senda Monteverde at 11:00 am','Liberia Airport','00100001040000018229',2,230.00,220.00,'2024-12-03','Paid CCAT Link',NULL,1),(39316,16446,'Ines Leroy','014266-112024',78,1,'SJO Airport Malinche Rest',' Perfect Sunset School Hermosa ST','00100001040000018230',1,80.00,77.00,'2024-12-08','Paid CCAT Link',NULL,1),(39317,245,'Alena Midgen','014267-112024',5,1,'Hospedaje Dodero Liberia','Entrance Lost Boyz Santa Teresa','014267',1,60.00,48.00,'2024-11-15','PAID DEPOSIT $54,24',NULL,1),(39318,16563,'Sonja Christiane Bachmann','014268-112024',4,1,'The Inner Light Yoga Lodge','Nya Hotel MTZ','194721',1,60.00,48.00,'2025-05-09','Pen Deposit $54,24',NULL,1),(39319,16446,'Ines Leroy','014269-112024',71,1,'Perfect Sunset','SJO Airport','00100001040000018231',1,80.00,77.00,'2024-12-22','Paid CCAT Link',NULL,1),(39320,16462,'Marina ','014270-112024',78,1,'SJO Airport Malinche Rest','Taco Corner Rest, Santa Teresa','0830',1,60.00,57.00,'2024-12-17','Paid Office Cash / Avisa',NULL,1),(39321,16462,'Giuliana Bisetto','014271-112024',76,1,'Hotel Quinta Avenida SJO','Eat Street Rest, Santa Teresa','00100001040000018232',1,60.00,57.00,'2024-11-15','Paid CCAT Link',NULL,1),(39322,596,'Javier Romero','014272-112024',76,1,'Selina San Jose','Tercer Ojo Santa Teresa','014272',2,60.00,60.00,'2024-11-15','Cobrar 30mil al cliente local',NULL,1),(39323,16462,'Phil Baratt','014273-112024',3,1,'Pelada Studios','Casa Boaz Tamarindo','00100001040000018233',1,50.00,57.00,'2024-12-04','Paid CCAT Link',NULL,1),(39324,149,'Heidi Harju','014274-112024',78,1,'Hilton Garden Inn SJO Airport Alajuela','Shaka Costa Rica Hermosa ST','00100001040000018234',2,140.00,133.00,'2024-12-24','Paid CCAT Link',NULL,1),(39325,16462,'Neomi Mustain','014275-112024',78,1,'Courtyard by Marriott Alajuela','Cafe Social Santa Teresa','00100001040000018235',1,60.00,57.00,'2024-11-16','Paid CCAT Link',NULL,1),(39326,16462,'Tim Roberts','014276-112024',70,1,'Griss Lodge & Villas','SJO Airport','00100001040000018236',2,120.00,114.00,'2024-11-20','Paid CCAT Link',NULL,1),(39327,16462,'Sheila Gervais','014277-112024',4,1,'The Logan','Liberia Airport','00100001040000018237',2,100.00,95.00,'2025-02-25','Paid CCAT Link',NULL,1),(39328,16462,'Sheila Gervais','014278-112024',60,2,'Liberia Airport El Patio Cafe Britt ( AC 1873 ) at 2:30pm','The Logan Samara','00100001040000018238',2,125.00,115.00,'2025-02-04','Paid CCAT Link',NULL,1),(39329,16462,'Sherry B Baxter','014279-112024',60,2,'Samara Rocks at 8:00am','Liberia Airport','00100001040000018239',2,125.00,115.00,'2024-11-15','Paid CCAT Link',NULL,1),(39330,16132,'Poppy Parker','014280-112024',28,1,'Wild Sun Rescue Center','LIR Airport','014280',1,60.00,48.00,'2024-11-18','Paid Net CCAT Link',NULL,1),(39331,16462,'Judith Piontkowski','014281-112024',4,1,'Hotel Giada ','Somos Hostel Santa Teresa','00100001040000018240',1,60.00,57.00,'2024-11-23','Paid CCAT Link',NULL,1),(39332,16462,'Shawn Moddes','014282-112024',6,1,'La Botella de Leche Hostel','Green sanctuary hotel Nosara','00100001040000018241',1,50.00,47.00,'2024-12-07','Paid CCAT Link',NULL,1),(39333,16462,'Shawn Moddes','014283-112024',3,1,'Green Sanctuary Hotel','Botella Leche Hostel Tamarindo','00100001040000018242',1,50.00,47.00,'2024-12-13','Paid CCAT Link',NULL,1),(39334,16462,'Benedikt Hurch','014284-112024',78,1,'SJO Airport Malinche Rest','Zopilote Surf Camp Hermosa ST','00100001040000018243',1,80.00,77.00,'2024-11-15','Paid CCAT Link',NULL,1),(39335,16159,'Ollie Willianson','014285-112024',6,1,'Casa Pura Vida Surf Hostel','Santa Teresa Lost Boyz Hostel','1437',1,60.00,48.00,'2024-11-15','Cobrar $48 Hotel',NULL,1),(39336,1,'LEAH LAKSTINS','014286-112024',72,1,'Aurora Hotel','Tamarindo House of Nomad','9988704',1,60.00,48.00,'2024-11-16','Credito',NULL,1),(39337,16462,'Gina Piemonte	','014287-112024',60,2,'Private House Playa Grande at 11:00 am','SJO International Airport','00100001040000018244',2,295.00,285.00,'2024-11-18','Paid CCAT Link ',NULL,1),(39338,16462,'Jan Rastall ','014288-112024',5,1,'Hotel Liberia LIR at 8:40am','MTZ Aves Resort ','00100001040000018247',1,60.00,57.00,'2024-11-30','Paid CCAT Link',NULL,1),(39339,274,'José Rivera','014289-112024',70,1,'Hotel Rustico','San Jose','9192',1,30.00,30.00,'2024-11-15','Pago sinpe a Leandro',NULL,1),(39340,16446,'David Teichrob','014290-112024',3,1,'Condominio Las Palmas Pelada at 7:45am ','Santa Teresa Super Muralla ','00100001040000018248',4,240.00,228.00,'2024-11-19','Paid CCAT Link',NULL,1),(39341,274,'Christoph Klein','014291-112024',20,1,'Habitat Surf Glamp','Tamarindo Center','1724',1,60.00,50.00,'2024-11-15','Cobrar $60 Cliente & Pend Comi ‪Josue ‪7015-6962‬',NULL,1),(39342,149,'Balint Tilesch','014292-112024',78,1,'Malinche Rest. SJO Airport','Santa Teresa Maoritsio Garden Studio','00100001040000018249',2,120.00,114.00,'2024-11-15','Paid CCAT Link',NULL,1),(39343,149,'Rick Laveay','014293-112024',60,2,'LIR Airport Flight WesJet 2262 at 9:00am ','Samara Lofts','00100001040000018250',2,125.00,115.00,'2024-11-17','Paid CCAT Link ',NULL,1),(39344,149,'Sean Kienzle	','014294-112024',59,2,'Casa Chameleon Mal Pais at 7:00am ','La Fortuna Tabacon Resort & Spa','00100001040000018251',2,280.00,270.00,'2024-12-06','Paid Paypal',NULL,1),(39345,149,'Sean Kienzle	','014295-112024',45,3,'COB AIrport at X:Xam/pm ','Mal Pais Casa Chameleon','00100001040000018251',2,50.00,45.00,'2024-12-02','Paid Paypal',NULL,1),(39346,274,'Amaya Aspillaga ','014296-112024',70,1,'Kikas Rest.','SJO Airport','1854',1,60.00,48.00,'2024-11-15','Cobrar $60 Cliente & Pend Comi ‪Lucy 8668-2913',NULL,1),(39347,16505,'Dario','014297-112024',70,1,'Kooks Smokehouse & Bar','SJO Airport','1900',1,60.00,48.00,'2024-11-15','Cobrar $48 Cliente',NULL,1),(39348,274,'Uriel','014298-112024',20,1,'Tropical Tours Office','Tamarindo Villarreal Gollo Store','2016',2,60.00,60.00,'2024-11-15','Cobrar 30.000 Cliente Local',NULL,1),(39349,149,'Julia Langille	','014299-112024',5,1,'Hospedage Dodero LIR at 8:40am','Santa Teresa Hostel Surf ParadIse','00100001040000018252',2,120.00,114.00,'2024-11-15','Paid CCAT Link',NULL,1),(39350,149,'Christopher Bryant	','014300-112024',60,2,'TamaHostel  Tamarindo at 11:30am ','La Fortuna Arenal Rooms ','00100001040000018253',2,280.00,270.00,'2024-11-15','Paid CCAT Link',NULL,1),(39351,274,'Hannah','014301-112024',45,3,'Casa Privada Santa Teresa at 5:30am','Cobano Airport COB','0856',1,50.00,40.00,'2024-11-18','Cobrar $50 Cliente Reserva Livo',NULL,1),(39352,149,'David Presten','014302-112024',70,1,'Ventura Hotel','SJO Selina Hostel','1901',2,120.00,114.00,'2024-11-19','Paid Office CC',NULL,1),(39353,274,'Aisling Condong','014303-112024',78,1,'Malinche Rest. SJO Airport','Mal Pais Indigo Yoga Resort','1921',1,60.00,48.00,'2024-11-23','Pend Deposit Net $54.24 Sacred Paths Yoga',NULL,1),(39354,16132,'Gabriella Pereira','014304-112024',78,1,'AirBnB  ','Cabuya Wild Sun Center','1924',1,60.00,48.00,'2024-11-17','Cobrar $40 Cliente Address x Whatsapp Providers',NULL,1),(39356,16589,' Sabrina Schart','014306-112024',88,1,'Parking Lot Nya Hotel ','SJO Finca Escalante','00100001040000018255',1,60.00,48.00,'2024-11-29','Paid Net CCAT Link',NULL,1),(39357,379,'Dawn Jackson ','014307-112024',70,1,'Entrance out Luz de Luna Hotel','SJO Airport','1007',1,60.00,48.00,'2024-11-16','Cobrar $48 Hotel',NULL,1),(39358,149,'Mara Zoe','014308-112024',78,1,'Fairfield by Marriott SJO Airport ','Santa Teresa D\\Palm Villas','00100001040000018256',2,120.00,114.00,'2024-11-17','Paid CCAT Link',NULL,1),(39359,149,'Laura Fraser	','014309-112024',28,1,'Entrance out La Conchita de Cabuya ','LIR Hilton Garden Inn GTE ','00100001040000018257',2,120.00,114.00,'2024-12-04','Paid CCAT Link',NULL,1),(39360,149,'Avneen Sehmi','014310-112024',3,1,'Entrance out Selina Hostel at 7:45am','Santa Teresa Ventura Hotel','00100001040000018259',1,60.00,57.00,'2024-11-17','Paid CCAT Link',NULL,1),(39361,149,'Keith Subryan','014311-112024',20,1,'Good Munchies Rest','Papagayo GTE RIU Guanacste Resort','1201',2,130.00,124.00,'2024-11-17','Paid Office Cash',NULL,1),(39362,246,'Jeff Pooree','014312-112024',6,1,'Villas Macondo','Santa Teresa Atrapasueños Hotel','5198',1,60.00,48.00,'2024-11-16','Cobrar $48 Hotel',NULL,1),(39363,15,'Sarah DeMaere','014313-112024',72,1,'Anamaya Resort at 6:50am','Ocotal GTE Hotel Bahia Pez Resort','1300',2,150.00,130.00,'2024-11-16','Credito',NULL,1),(39366,16519,'Courtney Borstel ','014316-112024',78,1,'Hampton by Hilton SJO Airport','MTZ Aves Hotel Resort','1342',1,60.00,48.00,'2024-11-30','Cobrar $48 Hotel',NULL,1),(39367,149,'Andrew Sestric	','014317-112024',60,2,'Casa Ola Section K Nosara at 5:00pm ','LIR Hilton Garden Inn GTE','00100001040000018261',2,140.00,130.00,'2024-11-16','Paid CCAT Link',NULL,1),(39368,257,'Caroline Hornum ','014318-112024',70,1,'Eat Street Rest','Alajuela Hampton By Hilton SJO Airport','1411',1,60.00,48.00,'2024-11-19','Credito',NULL,1),(39369,149,'Morgan Campbell','014319-112024',60,2,' Norte Hotel Nosara at 6:00am ','Liberia Airport','00100001040000018262',1,140.00,130.00,'2024-11-17','Paid by CCAT Link',NULL,1),(39370,149,'Shelley Albert	','014320-112024',60,2,'Tico Adventure Lodge Samara at 10:00am  ','Hermosa GTE Villa del Sueno','00100001040000018263',4,140.00,130.00,'2024-12-26','Paid CCAT Link',NULL,1),(39371,149,'Shelley Albert	','014321-112024',60,2,'LIR Airport Flight WS 2170 at 3:00pm','Samara Tico Adventure Lodge','00100001040000018263',4,125.00,115.00,'2024-12-21','Paid CCAT Link',NULL,1),(39372,149,'Shelley Albert	','014322-112024',60,2,'Villa del Sueno Hermosa GTE at 12:30pm ','LIR Airport','00100001040000018263',4,80.00,70.00,'2024-12-28','Paid CCAT Link',NULL,1),(39373,274,'Waller +506 6475 2434','014323-112024',8,1,'Bomba la Alianza Nicoya','Cobano','014323',1,30.00,30.00,'2024-11-16','Cobrar 15mil al cliente local',NULL,1),(39374,30,'Jade','014324-112024',20,1,'Nalu Surf Shop','Tamarindo','014324',1,60.00,48.00,'2024-11-16','Cobrar $48 a Pura Vida Mini STA Teresa ',NULL,1),(39375,149,'Ryan T Lynch','014325-112024',45,3,'Cobano Airport COB GW326 at 1:30pm',' Santa Teresa AirBnB Calle Fuego Lodge','00100001040000018265',3,55.00,50.00,'2024-11-25','Paid by CCAT Link',NULL,1),(39376,149,'Christine Rohweder	','014326-112024',60,2,'LIR Airport Flight AA2411 at 2:14pm ','Samara AirBnB TBD','00100001040000018264',2,125.00,115.00,'2025-02-15','Paid Paypal',NULL,1),(39377,149,'Christine Rohweder	','014327-112024',60,2,'AirBnB TBD Samara at 10:00am','LIR Hilton Garden Inn GTE','00100001040000018264',2,125.00,115.00,'2025-02-22','Paid Paypal',NULL,1),(39378,16560,'Mara','014328-112024',60,2,'LIR Airport at 2pm Vuelo: JetBlue B6 1691','Peace Loft Santa Teresa','014328',4,280.00,260.00,'2024-12-10','PAID DEPOSIT $316.40',NULL,1),(39379,149,'Kristopher Boettcher','014329-112024',59,2,' SJO Airport Flight AA 3151 at 1:50pm','Santa Teresa Hola Indian Restaurant ','00100001040000018266',2,260.00,250.00,'2024-11-17','Paid CCAT Link ',NULL,1),(39380,16560,'Mara','014330-112024',60,2,'Peace Loft at 9am','Liberia Aeropuerto ','014330',4,280.00,260.00,'2024-12-20','PAID DEPOSIT $316.40',NULL,1),(39381,259,'Romane Humbert','014331-112024',6,1,'Zulu Surf Hotel','Lapoint Surf Camp Costa Rica Santa Teresa','014331',1,60.00,48.00,'2024-11-16','Cobrar $60 al cliente PEN COMMI',NULL,1),(39382,16446,'Jenni Andres Michael','014332-112024',71,1,'Hola Indian Rest. Santa Teresa at 12:30 pm','Hilton Garden Inn in San Jose Airport','00100001040000018267',2,120.00,114.00,'2024-11-17','Paid cc in the office',NULL,1),(39383,16585,'Heather Nill +1 414 530 1925','014333-112024',59,2,'Sunrise Mountain Retreat Santa Teresa at 7am','SJO Airport','014333',8,320.00,320.00,'2024-11-16','Credito',NULL,1),(39384,257,' Maciej Stelinski','014334-112024',6,1,'Hotel Tama Lodge','Santa Teresa','014334',1,60.00,48.00,'2024-11-16','Credito',NULL,1),(39385,16446,'Austin Page','014335-112024',60,2,'Kelly\'s Surf Shop Tamarindo at 10:00 am','SJO International Airport','00100001040000018268',12,500.00,490.00,'2024-11-16','Paid by PayPal llevar 4 sillas de (3,2,1,1 años)',NULL,1),(39386,16446,'Fiona Tran','014336-112024',60,2,'Liberia Airport Hertz Rental at 11:00 am','SJO International Airport','00100001040000018269',5,317.00,307.00,'2024-11-16','Paid by CCAT Link',NULL,1),(39387,149,'Benjamin F Reese','014337-112024',60,2,'Villas Sol Beach Resort Hermosa playa at 8:00 am','SJO International Airport','00100001040000018270',1,395.00,385.00,'2024-11-16','Paid by PayPal',NULL,1),(39388,149,'Lawrence Butler','014338-112024',6,1,'La Bothella de Leche Hostel Tamarindo at 8:40am','Santa Teresa Somos Hostel','00100001040000018271',1,60.00,57.00,'2024-11-16','Paid by CCAT Link',NULL,1),(39389,16446,'Christopher Cutler','014339-112024',20,1,'Patio cafe santa teresa at 6:30 am ','Liberia Bus Stop','00100001040000018272',1,60.00,57.00,'2024-11-16','Paid by CCAT Link',NULL,1),(39390,16446,'Amanda Gaeta','014340-112024',19,1,' Liberia Airport El Patio cafe Britt ','Hola Indian Restaurant Santa Teres','00100001040000018273',3,180.00,170.00,'2024-12-06','Paid by CCAT Link',NULL,1),(39391,149,'Petra Ammeling','014341-112024',6,1,' Boruca Hotel Tamarindo at 8:40am','Hotel ventura santa teresa','00100001040000018274',1,60.00,57.00,'2024-11-16','Paid by CCAT Link',NULL,1),(39392,274,'Sonia alvarez','014342-112024',78,1,'Dennys Rest Alajuela ','Cobano Center','651645',1,30.00,30.00,'2024-11-16','Cobrar 15.000 colones al cliente reserva Argery',NULL,1),(39393,249,'Jennifer Krebs  ','014343-112024',4,1,'La Flor de Coco Cabinas y Apartamentos','Santa Teresa Eat Streets Rest','26501',2,120.00,96.00,'2024-11-16','Credito',NULL,1),(39394,16446,'Mary Glode','014344-112024',60,2,'Hertz rental office at LIR airport at 1:00 PM ','SJO International Airport','00100001040000018275',4,295.00,285.00,'2024-11-16','Paid by CCAT Link',NULL,1),(39395,16446,'Conor Madden','014345-112024',60,2,' 20 oro del sol villa Tamarindo at 6:00 am',' San Jose airport','00100001040000018276',1,295.00,285.00,'2024-11-16','Paid by PayPal',NULL,1),(39396,16446,'Anne Boyd','014346-112024',60,2,'SJO Airport flight xx at 8:30 am ','Blue Spirit Nosara','00100001040000018278',1,295.00,285.00,'2024-11-16','Paid by CCAT Link',NULL,1),(39397,16446,'Luna Hey','014347-112024',20,1,'Somos Hostel Santa Teresa at 6:30 am ','Hostel Dodero Liberia ','00100001040000018279',1,60.00,57.00,'2024-11-17','Paid by PayPal',NULL,1),(39398,16446,' Kaylindi Nevil and Destiny Owens','014348-112024',60,2,' Hotel Boyeros Liberia at 6:00 am','SJO International Airport','00100001040000018280',2,295.00,285.00,'2024-11-16','Paid by CCAT Link',NULL,1),(39399,16446,'Kathleen Bundy Mowris	','014349-112024',28,1,'Panaderia Cabuya at 6:30am','Liberia Airport','00100001040000018281',1,60.00,57.00,'2024-11-17','Paid by CCAT Link',NULL,1),(39400,16446,'Sarah Nicole Normile','014350-112024',4,1,' Casa Balto samara at 9:00 am','Habitat surf garden santa teresa','00100001040000018282',1,60.00,57.00,'2024-11-30','Paid by CCAT Link',NULL,1),(39401,16446,'Rhiannon Curtis	','014351-112024',59,2,'SJO Aiport Flight UA2423. at 2:30pm ','Santa Teresa Casa Kai','00100001040000018283',4,275.00,265.00,'2024-11-17','Paid CCAT Link',NULL,1),(39402,16462,'Maija Paivarinta	','014352-112024',78,1,'Fairfield by Marriott SJO Airport Alajuela ','Santa Teresa Kooks Bar','00100001040000018284',1,60.00,57.00,'2024-11-25','Paid CCAT Link',NULL,1),(39403,149,'Aleah Speranza','014353-112024',60,2,'LIR Airport Flight AC 1321 at 2:30pm','Tamarindo House of Nomad','00100001040000018285',2,120.00,110.00,'2024-11-25','Paid CCAT Link',NULL,1),(39404,149,'Aleah Speranza','014354-112024',60,2,'House of Nomad Tamarindo at 11:00am','Nosara Sendero Hotel','00100001040000018285',2,140.00,130.00,'2024-11-26','Paid CCAT Link',NULL,1),(39405,149,'Suthagar Shanthakumar	','014355-112024',34,1,'Eat Street Rest.','La Fortuna Loma Real Hotel & Hot Springs ','00100001040000018286',2,150.00,140.00,'2024-11-17','Paid Paypal',NULL,1),(39406,149,'Marquise McCrimmon	','014356-112024',60,2,'Basketball Court Coco Beach at 12:15pm ','Inmigration Office Puerto & Alajuela Hampton Inn by Hilton','00100001040000018287',1,370.00,360.00,'2024-11-16','Paid Paypal',NULL,1),(39407,16200,'Felipe Martinez ','014357-112024',22,1,'Barcelo Tambor Beach','SJO Teatro Nacional','1110',3,125.00,100.00,'2024-11-20','Credito 6047-8503 2+1',NULL,1),(39408,16200,'Felipe Martinez ','014358-112024',76,1,'Teatro Nacional','Tambor Barcelo Resort','1110',3,125.00,100.00,'2024-11-17','Credito 6047-8503 2+1',NULL,1),(39409,274,'Marjorie Perez','014359-112024',9,1,'Escuela La Abuela','Nicoya La Alianza ','1234',1,30.00,30.00,'2024-11-18','Cobrar 15.000 Cliente 8413-0894',NULL,1),(39410,16446,'Daniel Sanchez','014360-112024',58,1,'Tamarindo Diria Beach Resort','Barcelo San Jose','00100001040000018288',3,195.00,185.00,'2024-11-28','Paid by CCAT Link',NULL,1),(39411,149,'Theresa Bohm','014361-112024',20,1,'Anis Bowls & Salad Santa Teresa at 6:30am','Samara Giada Hotel','00100001040000018289',1,60.00,57.00,'2024-11-17','Paid by CCAT Link',NULL,1),(39412,558,'Caro Foppe','014362-112024',4,1,'Tico Adventure Lodge ','LIR Airport ','42403',1,50.00,40.00,'2024-11-17','Credito',NULL,1),(39413,149,'Mary Richardson','014363-112024',78,1,'Hotel Mango Alajuela at 6:30am',' MTZ Center ','00100001040000018290',2,120.00,114.00,'2024-12-08','Paid by CCAT Link',NULL,1),(39414,16446,'Clarisbel bradley','014364-112024',70,1,'Calle Mora san Isidro santa teresa at 6:50 am','San Jose centro','00100001040000018291',1,60.00,57.00,'2024-11-18','Paid by CCAT Link',NULL,1),(39415,16446,'Peter Swan','014365-112024',60,2,'Liberia Airport flight 1120 at 3:00 PM ','Occidental Tamarindo','00100001040000018292',2,120.00,110.00,'2024-12-28','Paid by CCAT Link',NULL,1),(39416,16446,'Molly seymour','014366-112024',3,1,'Casa Heart wave Nosara at 8:00 am','La botella de Leche Tamarindo','00100001040000018293',1,50.00,57.00,'2024-11-18','Paid by CCAT Link',NULL,1),(39417,16446,'Elijah ','014367-112024',34,1,'Tropical Tours Office ST','Arenal Camara de Turismo y Comercio','00100001040000018294',1,65.00,62.00,'2024-11-17','Paid by PayPal',NULL,1),(39419,16446,'Jesse Walters','014368-112024',6,1,'Hotel Boruca Tamarindo at 8:40 am ','Gusto beach restaurant Samara','00100001040000018295',2,100.00,95.00,'2024-11-17','Paid by CCAT Link',NULL,1),(39420,16446,'Ella Monique Shirley','014369-112024',15,1,'Conchal Hotel & Papaya Restaurant GTE at 8:00 am','Hotel El Jardin montezuma ','00100001040000018296',2,120.00,114.00,'2024-11-17','Paid by CCAT Link',NULL,1),(39421,16588,' Anthony McDougall','014370-112024',71,1,'Principe del Pacifico Santa Teresa','SJO Airport','464',2,120.00,96.00,'2025-01-01','Pen CCAT Link ',NULL,1),(39422,16446,'Riley McNeilage','014371-112024',60,2,'Sendero hotel nosara at 10:30 am','Planet Hollywood Papagayo ','00100001040000018297',1,160.00,150.00,'2024-11-17','Paid CCAT Link',NULL,1),(39423,16519,'China Rose','014372-112024',78,1,'Fairfield by Marriott San Jose Airport Alajuela','Hotel Aves Montezuma','014372',1,60.00,48.00,'2024-11-30','Cobrar $48 a Hotel Aves Montezuma  ',NULL,1),(39424,16462,'Connie Cantazaros ','014373-112024',60,2,'Pacific Park Tamarindo at 6am','Liberia Airport','00100001040000018298',6,210.00,200.00,'2024-11-17','Paid CCAT Link',NULL,1),(39425,274,'Natasha Cooze ','014374-112024',20,1,'Plaza Kahuna','Nosara Blue','014374',1,60.00,48.00,'2024-11-17','Credito Santa Teresa Adventures +506 6063 4531',NULL,1),(39426,16462,'Emil Kristiansen','014375-112024',15,1,'Hotel Conchal Papaya Rest','Zeneidas Surf Garden Santa Teresa','00100001040000018299',2,120.00,114.00,'2024-11-17','Paid CCAT Link',NULL,1),(39427,16462,'Lesley Oswell','014376-112024',3,1,'Norte Nosara ','Hotel Mar Rey Tamarindo','00100001040000018300',2,100.00,95.00,'2024-11-22','Paid CCAT Link',NULL,1),(39428,16462,'Carly Coleman','014377-112024',60,2,'Azura Beach Samara at 6am','Liberia Airport','00100001040000018301',1,125.00,115.00,'2024-11-17','Paid CCAT Link',NULL,1),(39429,16462,' Logan Wells','014378-112024',60,2,'Aloft San Jose Hotel, Costa Rica at 7am','Las Mariposas Samara','00100001040000018302',2,295.00,285.00,'2024-11-17','Paid CCAT Link',NULL,1),(39430,149,'Mika Shapira','014379-112024',78,1,'Holiday Inn Express SJO Airport','Santa Teresa Entrance Villa Fortuna','00100001040000018303',2,120.00,114.00,'2024-11-21','Paid CCAT Link',NULL,1),(39431,16536,'Sarah Cyphers','014380-112024',45,3,'Cobano Airport at 1:30pm Vuelo: GW 326','Casa Yolo Santa Teresa','014380',4,60.00,50.00,'2024-12-26','PEN CCAT Link $56.50',NULL,1),(39432,16536,'Sarah Cyphers','014381-112024',45,3,'Casa Yolo Santa Teresa at 10:15am','Cobano Airport ','014381',4,60.00,50.00,'2025-01-02','PEN CCAT Link $56.50',NULL,1),(39433,16462,'Peter Hall','014382-112024',72,1,'Ivans House ','Hotel Javy Liberia','00100001040000018304',2,120.00,114.00,'2024-11-19','Paid CCAT Link',NULL,1),(39434,16462,'Maja Strandberg','014383-112024',70,1,'Anis Bowls & Salad','Park Inn San José by Radisson','00100001040000018305',2,120.00,114.00,'2024-11-21','Paid CCAT Link',NULL,1),(39435,16446,'Freya Heckhausen','014384-112024',76,1,'DoubleTree Cariari San Jose at 6am','Zopilote Surf Camp Hermosa ST','00100001040000018306',1,80.00,77.00,'2024-11-21','Paid CCAT Link',NULL,1),(39436,16462,'Grettel Cottner','014385-112024',9,1,'Entrance out Los Delfines','Liberia Airport','00100001040000018307',1,60.00,57.00,'2024-11-20','Paid CCAT Link cliente avisado del cierre en el correo',NULL,1),(39437,16200,'Yesenia Jaimes tel+15127797745','014386-112024',76,1,'Barcelo San Jose ','Barcelo Tambor ','014386',3,100.00,100.00,'2024-11-18','Credito ',NULL,1),(39438,16200,'Yesenia Jaimes tel+15127797745','014387-112024',22,1,'Barcelo Tambor ','Barcelo San Jose ','014387',3,100.00,100.00,'2024-11-22','Credito ',NULL,1),(39439,16200,'Ana Cecilia Velasquez tel. +525621657469','014388-112024',59,2,'SJO Airport at 11:53 am Vuelo: Aeromexico 690','Barcelo Tambor ','014388',3,220.00,220.00,'2024-11-18','Credito ',NULL,1),(39440,16200,'Ana Cecilia Velasquez tel. +525621657469','014389-112024',59,2,'Barcelo Tambor at 5:30am','Barcelo San Jose ','014389',3,220.00,220.00,'2024-11-23','Credito ',NULL,1),(39441,16446,'Karl Sykes Tobin','014390-112024',60,2,'Casa Costa Verde Pinilla GTE at 10:00 AM','Sky Garden Costa Rica San Jose ','00100001040000018308',4,295.00,285.00,'2024-11-18','Paid by PayPal',NULL,1),(39442,149,'Lena Dysli','014391-112024',11,2,'SJO Airport Flight xxx at 3:00 pm','Hermosa ST Zopilote Surfcamp','00100001040000018309',1,340.00,330.00,'2024-11-22','Paid by PayPal',NULL,1),(39443,1,'Magdalena Lindorfer ','014392-112024',5,1,'Hotel Villa Hermosa','Tico Adventure Lodge Samara ','9996842',1,50.00,40.00,'2024-11-19','Credito ',NULL,1),(39444,16462,'Alon Shumskiy','014393-112024',3,1,'Rinde Mas Nosara at 7:45am ','Liberia Airport','00100001040000018310',1,50.00,47.00,'2024-11-20','Paid by CCAT Link cliente avisado del cierre en el correo',NULL,1),(39445,16446,'Lesli Allison','014394-112024',47,1,'Selina Monteverde at 6:00 am','Amor de Mar Montezuma','00100001040000018311',2,130.00,121.00,'2025-02-13','Paid by CCAT Link',NULL,1),(39446,16446,'Steven L OBrien','014395-112024',60,2,'Ten north Tamarindo beach hotel at 7:00 am','Liberia Airport','00100001040000018312',2,120.00,110.00,'2024-11-19','Paid by CCAT Link STAND BY ',NULL,1),(39447,149,'Olivia Lenfestey','014396-112024',5,1,'El Patio Britt Cafe LIR Airport at 9:00am ',' Nosara Es un muy Lindo Rest.','00100001040000018313',2,100.00,95.00,'2024-12-07','Paid by CCAT Link',NULL,1),(39448,16446,'Ida Rathje Ravnborg','014397-112024',3,1,'Selina Nosara at 7:45 am','Liberia Airport','00100001040000018314',1,50.00,47.00,'2024-11-23','Paid by CCAT Link',NULL,1),(39449,16446,'Tyler Grehan','014398-112024',5,1,'Liberia Airport patio cafe at 9:00 am',' Domo hotel Boutiquete Nosara','00100001040000018315',2,120.00,110.00,'2024-11-18','Paid by CCAT Link',NULL,1),(39450,16446,'Alva Hamner','014399-112024',78,1,'Alajuela Backpackres hostel at 6:30 ','Habitat surf glamp santa teresa ','00100001040000018316',1,60.00,57.00,'2024-12-30','Paid by CCAT Link',NULL,1),(39452,274,'Mauricio ','014401-112024',7,1,'Banco nacional ','Tambor','7822',1,30.00,30.00,'2024-11-18','Cobrar 15mil cliente',NULL,1),(39453,16446,'Christopher Bryant','014402-112024',60,2,'Arenal Rooms, la Fortuna: Alajuela at 12:00 pm','In front of Restaurante Bosco\'s  Alajuela','00100001040000018317',2,180.00,170.00,'2024-11-19','Paid by CCAT Link +1 (540) 216-6845',NULL,1),(39455,16446,'Ajay Sekhand','014404-112024',60,2,'Liberia Airport flight TS600 at 3:40 pm','Bodhi tree nosara ','00100001040000018318',2,140.00,130.00,'2024-11-27','Paid by CCAT Link +1 (917) 544-9599',NULL,1),(39457,16519,'Diamond Care','014406-112024',72,1,'Aves Resort at 6:50am','LIR Airport ','0923',1,60.00,48.00,'2024-11-19','Cobrar $48 Cliente',NULL,1),(39458,35,'Jeffrey Pooree','014407-112024',71,1,'Atrapasueños Hotel','SJO Airport ','10206',1,60.00,48.00,'2024-11-20','Cobrar $48 Hotel',NULL,1),(39459,246,'Jonas Jensen','014408-112024',6,1,'Villas Macondo','Santa Teresa Cabinas Playa Sta Teresa','5199',2,120.00,96.00,'2024-11-20','Cobrar $96 Hotel',NULL,1),(39460,16446,'Amelie Müller','014409-112024',70,1,'Somos santa teresa at 6:45 am','SJO International Airport','00100001040000018320',1,60.00,57.00,'2024-11-19','Paid by PayPal',NULL,1),(39461,16434,'Angela ','014410-112024',74,1,'Escuela','SJO AirPort ','1017',2,96.00,96.00,'2024-11-20','Cobrar $96 Cliente',NULL,1),(39462,274,'Fiorella','014411-112024',70,1,'vista  naranja malpais','SJO International Airport','65256',1,50.00,50.00,'2024-11-19','Pay cash in the office',NULL,1),(39463,16462,'Lisa Marie Markmeyer','014412-112024',70,1,' Eat street Santa teresa at 6:45 am ','Hilton San Jose Airport city mall','00100001040000018322',1,60.00,57.00,'2024-11-22','Paid by CCAT Link',NULL,1),(39464,16446,'Gregory P Mooney','014413-112024',71,1,'Maramar Santa Teresa','SJO International Airport','00100001040000018323',1,60.00,57.00,'2024-11-22','Paid by CCAT Link',NULL,1),(39465,274,'Caroline Palmer','014414-112024',78,1,'Malinche Rest. SJO AirPort ','Santa Teresa Súper Ronny’s 1','1248',1,40.00,40.00,'2024-11-19','Cobrar $40 Cliente ',NULL,1),(39466,16446,'Suzanne Chartrand','014415-112024',122,1,'Best western el sitio Liberia at 8:40 am ','SJO International Airport','00100001040000018325',2,130.00,121.00,'2024-11-19','Paid by CCAT Link',NULL,1),(39467,16446,'Amy J Lewis','014416-112024',60,2,'Private House Tamrindo at 3:00 pm','San Jose HTB','00100001040000018326',2,295.00,285.00,'2024-11-18','Paid by CCAT Link 1 (720) 940-3500',NULL,1),(39468,16462,'Susan Burdick','014417-112024',78,1,'Hampton by Hilton at San Jose Airport.','Honu Beach Apartments Santa Teresa','00100001040000017453',2,120.00,114.00,'2024-11-20','Paid by PayPal',NULL,1),(39469,16446,'Sydney Anstine','014418-112024',111,1,'Cocos Mexican restaurant, Samara  at 9:00 am','SJO International Airport','00100001040000018327',1,65.00,63.00,'2024-11-19','Paid by CCAT Link',NULL,1),(39470,16200,' Isabela Elizondo tel. 63849689','014419-112024',76,1,'Barcelo San Jose ','Barcelo Tambor ','014419',2,72.00,72.00,'2024-11-19','Credito ',NULL,1),(39471,16200,' Isabela Elizondo tel. 63849689','014420-112024',22,1,'Barcelo Tambor ','Barcelo San Jose ','014420',2,72.00,72.00,'2024-11-22','Credito ',NULL,1),(39472,16446,'Poppy Parker','014421-112024',122,1,'Hotel villa hermosa liberia at 8:35 am','SJO Airport ','00100001040000018328',1,65.00,62.00,'2024-11-19','Paid by CCAT Link',NULL,1),(39473,16446,'Will Lucia ','014422-112024',60,2,'Liberia Airpot flight WS 2170 at 2:45 pm ','Los Delfines, Playa Tambor','00100001040000018329',2,260.00,250.00,'2024-11-29','Paid by CCAT Link',NULL,1),(39474,16446,'Will Lucia ','014423-112024',60,2,'Los Delfines main entrance Tambor at 8:00 am','Liberia Airport','00100001040000018329',2,260.00,250.00,'2024-12-09','Paid by CCAT Link',NULL,1),(39475,16446,'Joan Paranka','014424-112024',60,2,'Dollar car rental in Liberia AIR at 1:00 pm','Hilton garden inn San Jose Airport','00100001040000018330',3,295.00,285.00,'2024-11-20','Paid by CCAT Link',NULL,1),(39476,16446,'Melissa Sonnleitner','014425-112024',5,1,'Hostel Dodero, Liberia 8:40am','Nosara Burnt Toast Hostel','00100001040000018331',1,50.00,47.00,'2024-11-28','Paid by PayPal',NULL,1),(39477,16446,'Tommaso Casadei','014426-112024',78,1,'Melrost Bed and Breakfast Alajuela at 6:30 am ','Osa Restaurant  Santa Teresa','00100001040000018332',1,60.00,57.00,'2024-11-28','Paid by PayPal',NULL,1),(39478,16387,'Debora','014427-112024',70,1,'Super Muralla Santa Teresa ','Park Inn San Jose by Radisson','014427',2,120.00,96.00,'2024-11-22','Credito ',NULL,1),(39479,16430,'Caitlin Hagberg ','014428-112024',58,1,'House of Nomad','SJO Airport','014428',2,130.00,104.00,'2024-11-19','Cobrar $104 a Gold Cost Bonanza Tamarindo',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`
--



