{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-22","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1286,1287,1288,1291,1293,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1318,1319,1711,1756,1913,1915,1916,1917,1942,1943,1296,1294,1297,1315,1316,1866,1921,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273","departureCount":15,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1942","block_room_bookings":[{"confirmation_number":"SJ12659090059","room_stay_from":"2021-04-22","room_stay_to":"2021-04-23","bundle_room":"0","product_id":"1942"}],"bundle_block_count":"1304,1305,1269,1270,1262,1263,1311,1312,1309,1310,1267,1268,1302,1303,1260,1261,1307,1308,1271,1272,1291,1711","bundle_block_bookings":[{"confirmation_number":"SJB12636902258","room_stay_from":"2021-04-19","room_stay_to":"2021-04-23","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12690906193","room_stay_from":"2021-04-19","room_stay_to":"2021-04-23","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12631873091","room_stay_from":"2021-04-22","room_stay_to":"2021-04-23","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12612420326","room_stay_from":"2021-04-21","room_stay_to":"2021-04-23","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12637616838","room_stay_from":"2021-04-22","room_stay_to":"2021-04-23","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12675537225","room_stay_from":"2021-04-22","room_stay_to":"2021-04-23","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12691736929","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12640561526","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12645642842","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12699713763","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12670341344","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12675472684","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12632665660","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12675264719","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12647989130","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12695052303","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12638506996","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12663655670","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","bundle_room":"0","product_id":"1711"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3202409","reservation_id":"108217","confirmation_number":"SJ12638182436","room_stay_from":"2021-04-19","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"198.80,198.80,198.80,198.80,226.80,226.80","nightly_discount":"0,0,0,0,0,0","subtotal":"1248.80","grand_total":"1404.90","paid_amount":"1404.90","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2539077142","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114681","customer_id":"114681","source_of_creation":"Booking.com","reservation_created_date":"2021-02-21 22:29:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"251.78","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"198.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202451","reservation_id":"108225","confirmation_number":"SJ12613420122","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"214.89,214.89,237.57,237.57","nightly_discount":"0,0,0,0","subtotal":"904.92","grand_total":"1018.04","paid_amount":"1018.04","room_type_id":"320","product_id":"1324","siteminder_id":"BDC-2246854454","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114689","customer_id":"114689","source_of_creation":"Booking.com","reservation_created_date":"2021-02-21 23:57:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"180.89","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1271,1272","currentDayPrice":"214.89","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202777","reservation_id":"108279","confirmation_number":"SJ12618475082","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"209.25,209.25,239.25","nightly_discount":"0,0,0","subtotal":"657.75","grand_total":"739.97","paid_amount":"739.97","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3849351446","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114738","customer_id":"114738","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 17:15:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"131.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"209.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3213167","reservation_id":"109926","confirmation_number":"SJ12691003228","room_stay_from":"2021-04-19","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0","subtotal":"641.20","grand_total":"721.35","paid_amount":"721.35","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-2244347608","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116420","customer_id":"116420","source_of_creation":"Booking.com","reservation_created_date":"2021-03-10 02:23:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3221270","reservation_id":"111127","confirmation_number":"SJ12695596275","room_stay_from":"2021-04-20","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.75,231.75,246.75","nightly_discount":"0,0,0","subtotal":"710.25","grand_total":"799.03","paid_amount":"799.03","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3068005313","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117658","customer_id":"117658","source_of_creation":"Booking.com","reservation_created_date":"2021-03-23 21:52:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"141.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3226130","reservation_id":"109228","confirmation_number":"SJ12677972799","room_stay_from":"2021-04-18","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"191.3,191.3,191.3,191.3,191.3,289.3","nightly_discount":"0,0,0,0,0,0","subtotal":"1245.80","grand_total":"1401.53","paid_amount":"1401.53","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-2114753229","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115696","customer_id":"115696","source_of_creation":"Booking.com","reservation_created_date":"2021-03-03 23:58:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"278.24","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"191.3","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3227334","reservation_id":"108303","confirmation_number":"SJ12676952612","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,188.30,188.30","nightly_discount":"0,0,0,0","subtotal":"697.20","grand_total":"784.35","paid_amount":"784.35","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-3154242148","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114760","customer_id":"114760","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 19:45:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"143.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3227363","reservation_id":"111995","confirmation_number":"SJ12671632304","room_stay_from":"2021-04-20","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.25,269.25,269.25","nightly_discount":"0,0,0","subtotal":"807.75","grand_total":"908.72","paid_amount":"908.72","room_type_id":"413","product_id":"1269","siteminder_id":"BDC-2357504161","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118565","customer_id":"118565","source_of_creation":"Booking.com","reservation_created_date":"2021-04-03 18:39:32","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"269.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229261","reservation_id":"110895","confirmation_number":"SJ12686447493","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"216.30,230.30,300.30,300.30","nightly_discount":"0,0,0,0","subtotal":"1047.20","grand_total":"1178.10","paid_amount":"1178.10","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-3503900236","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117415","customer_id":"117415","source_of_creation":"Booking.com","reservation_created_date":"2021-03-21 18:11:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"206.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229703","reservation_id":"110551","confirmation_number":"SJ12676364392","room_stay_from":"2021-04-19","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.27,144.27,169.47,188.37","nightly_discount":"0,0,0,0","subtotal":"646.38","grand_total":"727.18","paid_amount":"727.18","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-3310011330","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117063","customer_id":"117063","source_of_creation":"Booking.com","reservation_created_date":"2021-03-17 18:58:26","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"188.37","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235013","reservation_id":"110975","confirmation_number":"SJ12641160975","room_stay_from":"2021-04-21","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"247.20,263.20","nightly_discount":"0,0","subtotal":"510.40","grand_total":"574.20","paid_amount":"574.20","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-3068045964","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117513","customer_id":"117513","source_of_creation":"Booking.com","reservation_created_date":"2021-03-22 17:05:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"100.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"263.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235073","reservation_id":"110597","confirmation_number":"SJ12622354637","room_stay_from":"2021-04-18","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.47,144.27,144.27,169.47,188.37","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"815.85","grand_total":"917.83","paid_amount":"917.83","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-2525713101","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117111","customer_id":"117111","source_of_creation":"Booking.com","reservation_created_date":"2021-03-18 01:30:33","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"188.37","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235183","reservation_id":"112860","confirmation_number":"SJ12639024031","room_stay_from":"2021-04-21","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.20,287.20","nightly_discount":"0,0","subtotal":"574.40","grand_total":"646.20","paid_amount":"646.20","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3955455606","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119439","customer_id":"119439","source_of_creation":"Booking.com","reservation_created_date":"2021-04-13 02:57:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"112.39","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"287.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235338","reservation_id":"108345","confirmation_number":"SJ12689873753","room_stay_from":"2021-04-20","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.75,171.75,171.75","nightly_discount":"0,0,0","subtotal":"515.25","grand_total":"579.65","paid_amount":"579.65","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-3909738645","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114797","customer_id":"114797","source_of_creation":"Booking.com","reservation_created_date":"2021-02-23 01:43:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"106.25","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"171.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239158","reservation_id":"108276","confirmation_number":"SJ12644672036","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"209.25,209.25,239.25","nightly_discount":"0,0,0","subtotal":"657.75","grand_total":"739.97","paid_amount":"739.97","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-3826223714","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114736","customer_id":"114736","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 17:11:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"131.90","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"209.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239162","reservation_id":"108247","confirmation_number":"SJ12695126762","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"154.58,154.58,181.58","nightly_discount":"0,0,0","subtotal":"490.74","grand_total":"552.09","paid_amount":"552.09","room_type_id":"413","product_id":"1262","siteminder_id":"BDC-2642616403","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114715","customer_id":"114715","source_of_creation":"Booking.com","reservation_created_date":"2021-02-22 04:15:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"101.83","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"154.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239354","reservation_id":"112649","confirmation_number":"SJ12640893806","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.20,343.20","nightly_discount":"0,0","subtotal":"630.40","grand_total":"709.20","paid_amount":"709.20","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-2869593074","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119239","customer_id":"119239","source_of_creation":"Booking.com","reservation_created_date":"2021-04-11 02:13:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"122.47","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"287.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239854","reservation_id":"113645","confirmation_number":"SJ12675366204","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"258.48,308.88","nightly_discount":"0,0","subtotal":"567.36","grand_total":"638.28","paid_amount":"638.28","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2840477415","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120245","customer_id":"120245","source_of_creation":"Booking.com","reservation_created_date":"2021-04-22 18:42:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"111.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"258.48","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239667","reservation_id":"113606","confirmation_number":"SJ12633417978","room_stay_from":"2021-05-10","room_stay_to":"2021-05-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.83,201.83,222.08,242.33","nightly_discount":"0,0,0,0","subtotal":"868.07","grand_total":"976.58","paid_amount":"227.06","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-2808297467","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120209","customer_id":"120209","source_of_creation":"Booking.com","reservation_created_date":"2021-04-22 02:44:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3205394","reservation_id":"108719","confirmation_number":"SJ12658256285","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"178.56,210.56","nightly_discount":"0,0","subtotal":"389.12","grand_total":"437.76","paid_amount":"437.76","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1742141562","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115167","customer_id":"115167","source_of_creation":"Expedia","reservation_created_date":"2021-02-27 13:07:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"178.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3215045","reservation_id":"110209","confirmation_number":"SJ12672875391","room_stay_from":"2021-04-19","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.04,145.04,167.44,184.24,223.44","nightly_discount":"0,0,0,0,0","subtotal":"865.20","grand_total":"973.35","paid_amount":"973.35","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1747173784","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116722","customer_id":"116722","source_of_creation":"Expedia","reservation_created_date":"2021-03-13 17:22:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"184.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3216934","reservation_id":"110454","confirmation_number":"SJ12689106582","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,230.30,279.30,279.30","nightly_discount":"0,0,0,0","subtotal":"998.20","grand_total":"1122.98","paid_amount":"1122.98","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1748439431","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116966","customer_id":"116966","source_of_creation":"Expedia","reservation_created_date":"2021-03-16 22:38:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219811","reservation_id":"110858","confirmation_number":"SJ12683106538","room_stay_from":"2021-04-19","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"243.24,243.24,243.24,254.44","nightly_discount":"0,0,0,0","subtotal":"984.16","grand_total":"1107.18","paid_amount":"1107.18","room_type_id":"320","product_id":"1329","siteminder_id":"EXP-1750201463","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117380","customer_id":"117380","source_of_creation":"Expedia","reservation_created_date":"2021-03-21 02:23:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1304,1305","currentDayPrice":"254.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3226152","reservation_id":"109826","confirmation_number":"SJ12686591222","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.40,239.40,239.40","nightly_discount":"0,0,0","subtotal":"634.20","grand_total":"713.48","paid_amount":"713.48","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1745483806","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116317","customer_id":"116317","source_of_creation":"Expedia","reservation_created_date":"2021-03-09 03:17:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"155.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229705","reservation_id":"110622","confirmation_number":"SJ12680227760","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.40,254.40,254.40","nightly_discount":"0,0,0","subtotal":"721.20","grand_total":"811.35","paid_amount":"811.35","room_type_id":"319","product_id":"1943","siteminder_id":"EXP-1749117851","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117133","customer_id":"117133","source_of_creation":"Expedia","reservation_created_date":"2021-03-18 14:47:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"212.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235175","reservation_id":"108485","confirmation_number":"SJ12648436924","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.40,167.40,197.40","nightly_discount":"0,0,0","subtotal":"532.20","grand_total":"598.73","paid_amount":"598.73","room_type_id":"318","product_id":"1282","siteminder_id":"EXP-1741250027","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114931","customer_id":"114931","source_of_creation":"Expedia","reservation_created_date":"2021-02-24 21:37:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"167.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3236956","reservation_id":"108124","confirmation_number":"SJ12696320667","room_stay_from":"2021-04-19","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.30,160.30,160.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0,0,0","subtotal":"961.80","grand_total":"1082.03","paid_amount":"1082.03","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1739968816","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114586","customer_id":"114586","source_of_creation":"Expedia","reservation_created_date":"2021-02-20 18:42:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"160.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239549","reservation_id":"110979","confirmation_number":"SJ12650049589","room_stay_from":"2021-04-21","room_stay_to":"2021-04-22","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"200.40","nightly_discount":"0","subtotal":"200.40","grand_total":"225.45","paid_amount":"169.20","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1750762403","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117516","customer_id":"117516","source_of_creation":"Expedia","reservation_created_date":"2021-03-22 17:32:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3208470","reservation_id":"109233","confirmation_number":"SJ12672816426","room_stay_from":"2021-04-22","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.02,243.38,243.38,163.02","nightly_discount":"0,0,0,0","subtotal":"812.80","grand_total":"914.40","paid_amount":"914.40","room_type_id":"412","product_id":"1316","siteminder_id":"GAM-R2360305570","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115701","customer_id":"115701","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-04 00:14:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"163.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3210765","reservation_id":"109614","confirmation_number":"SJ12620308566","room_stay_from":"2021-04-20","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"132.25,132.25,132.25","nightly_discount":"0,0,0","subtotal":"396.75","grand_total":"446.35","paid_amount":"446.35","room_type_id":"319","product_id":"1915","siteminder_id":"GAM-R2366428530","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116094","customer_id":"116094","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-06 22:23:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"132.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219682","reservation_id":"110837","confirmation_number":"SJ12628923868","room_stay_from":"2021-04-20","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.55,166.55,177.33,231.23","nightly_discount":"0,0,0,0","subtotal":"741.66","grand_total":"834.36","paid_amount":"834.36","room_type_id":"319","product_id":"1306","siteminder_id":"GAM-R2396440968","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117360","customer_id":"117360","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-20 21:37:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"177.33","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3237757","reservation_id":"107496","confirmation_number":"SJ12626501032","room_stay_from":"2021-04-19","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.08,153.08,153.08,153.08,174.64","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"786.96","grand_total":"885.33","paid_amount":"885.33","room_type_id":"411","product_id":"1296","siteminder_id":"GAM-R2325619527","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"113954","customer_id":"113954","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-13 01:14:10","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"153.08","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3238314","reservation_id":"107635","confirmation_number":"SJ12614501894","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"360.06,360.06,353.69","nightly_discount":"0.00,0.00,0.00","subtotal":"1073.81","grand_total":"1244.39","paid_amount":"1244.39","room_type_id":"320","product_id":"1322","siteminder_id":"ABB-HMMBA38YB3","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1080.18","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114092","customer_id":"114092","source_of_creation":"Airbnb","reservation_created_date":"2021-02-14 21:53:06","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"31.77","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1267,1268","currentDayPrice":"360.06","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3238326","reservation_id":"108417","confirmation_number":"SJ12680090526","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"381.48,381.48,374.61","nightly_discount":"0.00,0.00,0.00","subtotal":"1137.57","grand_total":"1318.30","paid_amount":"1318.30","room_type_id":"320","product_id":"1328","siteminder_id":"ABB-HMAD2ZEJCW","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1144.44","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114871","customer_id":"114871","source_of_creation":"Airbnb","reservation_created_date":"2021-02-23 23:50:14","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"33.66","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"381.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3203889","reservation_id":"108477","confirmation_number":"SJ12658659294","room_stay_from":"2021-04-22","room_stay_to":"2021-04-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.00,265.50,265.50,228.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"987.00","grand_total":"1110.38","paid_amount":"1110.38","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114923","customer_id":"114923","source_of_creation":"FE","reservation_created_date":"2021-02-24 20:25:52","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"228.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3211798","reservation_id":"109749","confirmation_number":"SJ12695038399","room_stay_from":"2021-04-19","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.25,194.25,194.25,194.25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"777.00","grand_total":"874.13","paid_amount":"874.13","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116238","customer_id":"116238","source_of_creation":"FE","reservation_created_date":"2021-03-08 05:06:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"194.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219340","reservation_id":"110796","confirmation_number":"SJ12690853784","room_stay_from":"2021-04-18","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,231.75,231.75,231.75,246.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1188.75","grand_total":"1337.35","paid_amount":"1337.35","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117306","customer_id":"117306","source_of_creation":"FE","reservation_created_date":"2021-03-20 13:58:24","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239925","reservation_id":"111650","confirmation_number":"SJ12680964192","room_stay_from":"2021-04-22","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.65","nightly_discount":"0.00","subtotal":"279.65","grand_total":"314.60","paid_amount":"314.60","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118207","customer_id":"118207","source_of_creation":"FE","reservation_created_date":"2021-03-30 01:11:55","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"279.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3137355","reservation_id":"100420","confirmation_number":"SJ12678073836","room_stay_from":"2021-04-17","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"277.00,212.00,212.00,212.00,212.00,212.00,277.00","nightly_discount":"27.70,21.20,21.10,21.10,21.10,21.10,27.70","subtotal":"1614.00","grand_total":"1634.63","paid_amount":"1634.63","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"106453","customer_id":"106453","source_of_creation":"PMS","reservation_created_date":"2020-09-15 22:12:31","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"212.00","currentDayDiscount":"21.10","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203979","reservation_id":"108493","confirmation_number":"SJ12665438074","room_stay_from":"2021-04-16","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.51,123.51,123.51,123.51,123.51,123.51,123.51","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"864.57","grand_total":"972.64","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114227","customer_id":"114227","source_of_creation":"PMS","reservation_created_date":"2021-02-24 23:59:49","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"123.51","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3205317","reservation_id":"108706","confirmation_number":"SJ12650908962","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,336.75,336.75","nightly_discount":"0.00,0.00,0.00","subtotal":"972.75","grand_total":"1094.35","paid_amount":"1094.35","room_type_id":"320","product_id":"1714","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115155","customer_id":"115155","source_of_creation":"PMS","reservation_created_date":"2021-02-27 02:10:44","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1291,1711","currentDayPrice":"299.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239000","reservation_id":"108546","confirmation_number":"SJ12654074847","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.25,209.25,246.75","nightly_discount":"10.46,10.46,12.34","subtotal":"665.25","grand_total":"710.99","paid_amount":"710.99","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114982","customer_id":"114982","source_of_creation":"PMS","reservation_created_date":"2021-02-25 16:15:20","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"209.25","currentDayDiscount":"10.46","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239272","reservation_id":"110797","confirmation_number":"SJ12667407905","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"381.48,381.48,381.48","nightly_discount":"0.00,0.00,0.00","subtotal":"1144.44","grand_total":"1287.49","paid_amount":"1287.49","room_type_id":"320","product_id":"1330","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117308","customer_id":"117308","source_of_creation":"PMS","reservation_created_date":"2021-03-20 14:52:15","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1307,1308","currentDayPrice":"381.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239351","reservation_id":"113320","confirmation_number":"SJ12649986760","room_stay_from":"2021-04-22","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.25","nightly_discount":"0.00","subtotal":"269.25","grand_total":"302.90","paid_amount":"302.90","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118412","customer_id":"118412","source_of_creation":"PMS","reservation_created_date":"2021-04-18 20:13:30","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"269.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239787","reservation_id":"109380","confirmation_number":"SJ12621754161","room_stay_from":"2021-04-22","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"322.15","nightly_discount":"0.00","subtotal":"322.15","grand_total":"362.42","paid_amount":"362.42","room_type_id":"320","product_id":"1332","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115626","customer_id":"115626","source_of_creation":"PMS","reservation_created_date":"2021-03-04 18:12:57","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"322.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239927","reservation_id":"113404","confirmation_number":"SJ12639186597","room_stay_from":"2021-04-22","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"305.15","nightly_discount":"15.26","subtotal":"305.15","grand_total":"326.12","paid_amount":"343.29","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118368","customer_id":"118368","source_of_creation":"PMS","reservation_created_date":"2021-04-19 18:33:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","currentDayPrice":"305.15","currentDayDiscount":"15.26","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3198676","reservation_id":"107718","confirmation_number":"SJ12685378761","room_stay_from":"2021-04-18","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"570.00","grand_total":"570.00","paid_amount":"140.63","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-15 21:23:23","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204804","reservation_id":"108590","confirmation_number":"SJ12692218900","room_stay_from":"2021-04-16","room_stay_to":"2021-04-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"798.00","grand_total":"798.00","paid_amount":"196.88","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-02-26 01:22:54","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3211138","reservation_id":"108700","confirmation_number":"SJ12691038258","room_stay_from":"2021-04-18","room_stay_to":"2021-04-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.57,165.57,165.57,165.57,165.57,165.57,165.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1159.00","grand_total":"1159.00","paid_amount":"0.00","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-02-27 01:30:49","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"165.57","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3236954","reservation_id":"100701","confirmation_number":"SJ12688302981","room_stay_from":"2021-04-22","room_stay_to":"2021-04-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"462.00","grand_total":"462.00","paid_amount":"140.63","room_type_id":"413","product_id":"1270","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-09-22 00:31:37","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3219812","reservation_id":"110858","confirmation_number":"SJ12693091408","room_confirmation_number":"SJ12683106538","room_stay_from":"2021-04-19","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"117380","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-03-21 02:23:09","reservation_modified_date_time":"2021-03-21 02:23:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117380","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3226131","reservation_id":"109228","confirmation_number":"SJ12687361185","room_confirmation_number":"SJ12677972799","room_stay_from":"2021-04-18","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"115696","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-01 21:02:03","reservation_modified_date_time":"2021-04-01 21:02:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115696","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239275","reservation_id":"110797","confirmation_number":"SJ12679690694","room_confirmation_number":"SJ12667407905","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0,0,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"117308","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-04-21 22:30:41","reservation_modified_date_time":"2021-04-21 22:30:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117308","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3240008","reservation_id":"112468","confirmation_number":"SJ12685536751","room_confirmation_number":"SJ12673863811","room_stay_from":"2021-07-15","room_stay_to":"2021-07-18","room_stay_status":"Active","nightly_price":"100,100,100","nightly_discount":"0.00,0.00,0","subtotal":"300.00","grand_total":"337.50","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"119038","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-04-22 22:15:35","reservation_modified_date_time":"2021-04-22 22:15:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119038","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3198677","reservation_id":"107718","confirmation_number":"SJ12622276216","room_confirmation_number":"SJ12685378761","room_stay_from":"2021-04-18","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114164","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-15 21:23:23","reservation_modified_date_time":"2021-02-15 21:23:23","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203980","reservation_id":"108493","confirmation_number":"SJ12693732543","room_confirmation_number":"SJ12665438074","room_stay_from":"2021-04-16","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114940","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 23:59:49","reservation_modified_date_time":"2021-02-25 00:53:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114227","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3204805","reservation_id":"108590","confirmation_number":"SJ12643680677","room_confirmation_number":"SJ12692218900","room_stay_from":"2021-04-16","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115028","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-26 01:22:54","reservation_modified_date_time":"2021-02-26 01:22:54","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3210766","reservation_id":"109614","confirmation_number":"SJ12617316150","room_confirmation_number":"SJ12620308566","room_stay_from":"2021-04-20","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"116094","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-06 22:23:18","reservation_modified_date_time":"2021-03-06 22:48:45","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116094","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3211799","reservation_id":"109749","confirmation_number":"SJ12620209224","room_confirmation_number":"SJ12695038399","room_stay_from":"2021-04-19","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"116238","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-08 05:06:08","reservation_modified_date_time":"2021-03-08 05:06:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116238","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3213166","reservation_id":"109926","confirmation_number":"SJ12675420316","room_confirmation_number":"SJ12691003228","room_stay_from":"2021-04-19","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"116420","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-10 02:23:18","reservation_modified_date_time":"2021-03-10 15:18:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116420","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219341","reservation_id":"110796","confirmation_number":"SJ12662629323","room_confirmation_number":"SJ12690853784","room_stay_from":"2021-04-18","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.62","paid_amount":"140.62","product_id":"1776","service_quantity":"1","customer_traveller_id":"117306","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-20 13:58:24","reservation_modified_date_time":"2021-03-20 13:58:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117306","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219813","reservation_id":"110858","confirmation_number":"SJ12678107934","room_confirmation_number":"SJ12683106538","room_stay_from":"2021-04-19","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"117380","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-21 02:23:09","reservation_modified_date_time":"2021-03-21 02:23:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117380","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3221271","reservation_id":"111127","confirmation_number":"SJ12623012157","room_confirmation_number":"SJ12695596275","room_stay_from":"2021-04-20","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"117658","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-23 21:52:12","reservation_modified_date_time":"2021-03-23 21:52:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117658","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3227362","reservation_id":"111995","confirmation_number":"SJ12675394091","room_confirmation_number":"SJ12671632304","room_stay_from":"2021-04-20","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"118565","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-03 18:39:32","reservation_modified_date_time":"2021-04-03 20:41:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118565","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229704","reservation_id":"110551","confirmation_number":"SJ12690978416","room_confirmation_number":"SJ12676364392","room_stay_from":"2021-04-19","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"117063","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 18:58:26","reservation_modified_date_time":"2021-04-07 16:39:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117063","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235014","reservation_id":"110975","confirmation_number":"SJ12631737844","room_confirmation_number":"SJ12641160975","room_stay_from":"2021-04-21","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"117513","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 17:05:11","reservation_modified_date_time":"2021-04-15 17:51:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117513","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235075","reservation_id":"110597","confirmation_number":"SJ12658979681","room_confirmation_number":"SJ12622354637","room_stay_from":"2021-04-18","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"117111","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-18 01:30:33","reservation_modified_date_time":"2021-04-15 19:09:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117111","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235184","reservation_id":"112860","confirmation_number":"SJ12682900985","room_confirmation_number":"SJ12639024031","room_stay_from":"2021-04-21","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"119439","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-13 02:57:11","reservation_modified_date_time":"2021-04-15 23:05:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119439","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235339","reservation_id":"108345","confirmation_number":"SJ12645945652","room_confirmation_number":"SJ12689873753","room_stay_from":"2021-04-20","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"114797","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 01:43:11","reservation_modified_date_time":"2021-04-16 15:38:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114797","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239352","reservation_id":"113320","confirmation_number":"SJ12680257485","room_confirmation_number":"SJ12649986760","room_stay_from":"2021-04-22","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"118412","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-18 20:13:30","reservation_modified_date_time":"2021-04-22 00:45:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118412","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239790","reservation_id":"109380","confirmation_number":"SJ12697883807","room_confirmation_number":"SJ12621754161","room_stay_from":"2021-04-22","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"115626","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 18:12:57","reservation_modified_date_time":"2021-04-22 17:43:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115626","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239926","reservation_id":"111650","confirmation_number":"SJ12694522544","room_confirmation_number":"SJ12680964192","room_stay_from":"2021-04-22","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"118207","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 01:11:55","reservation_modified_date_time":"2021-04-22 20:03:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118207","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239928","reservation_id":"113404","confirmation_number":"SJ12680418606","room_confirmation_number":"SJ12639186597","room_stay_from":"2021-04-22","room_stay_to":"2021-04-23","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"10.96","product_id":"1776","service_quantity":"1","customer_traveller_id":"118349","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-19 18:33:33","reservation_modified_date_time":"2021-04-22 20:04:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118368","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3137356","reservation_id":"100420","confirmation_number":"SJ12640625081","room_confirmation_number":"SJ12678073836","room_stay_from":"2021-04-17","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"106453","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-15 22:12:31","reservation_modified_date_time":"2020-09-16 14:52:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106453","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202778","reservation_id":"108279","confirmation_number":"SJ12682170043","room_confirmation_number":"SJ12618475082","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"114738","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 17:15:14","reservation_modified_date_time":"2021-02-22 17:59:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114738","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3205395","reservation_id":"108719","confirmation_number":"SJ12656705513","room_confirmation_number":"SJ12658256285","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"115167","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 13:07:07","reservation_modified_date_time":"2021-02-27 13:07:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115167","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3215046","reservation_id":"110209","confirmation_number":"SJ12678620265","room_confirmation_number":"SJ12672875391","room_stay_from":"2021-04-19","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"116722","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-13 17:22:12","reservation_modified_date_time":"2021-03-13 17:22:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116722","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3219683","reservation_id":"110837","confirmation_number":"SJ12624059455","room_confirmation_number":"SJ12628923868","room_stay_from":"2021-04-20","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"117360","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-20 21:37:09","reservation_modified_date_time":"2021-03-20 21:37:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117360","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3226132","reservation_id":"109228","confirmation_number":"SJ12661167663","room_confirmation_number":"SJ12677972799","room_stay_from":"2021-04-18","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"115696","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-03 23:58:12","reservation_modified_date_time":"2021-04-01 21:02:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115696","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229347","reservation_id":"108546","confirmation_number":"SJ12610971869","room_confirmation_number":"SJ12654074847","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"114982","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-25 16:15:20","reservation_modified_date_time":"2021-04-07 02:52:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114982","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3235176","reservation_id":"108485","confirmation_number":"SJ12697536030","room_confirmation_number":"SJ12648436924","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"114931","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 21:37:08","reservation_modified_date_time":"2021-04-15 23:05:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114931","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3237758","reservation_id":"107496","confirmation_number":"SJ12671910824","room_confirmation_number":"SJ12626501032","room_stay_from":"2021-04-19","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25,25,25,25,25","nightly_discount":"25.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"113954","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-13 01:14:10","reservation_modified_date_time":"2021-04-19 21:38:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113954","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3238317","reservation_id":"107635","confirmation_number":"SJ12687941392","room_confirmation_number":"SJ12614501894","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114092","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-14 21:53:06","reservation_modified_date_time":"2021-04-21 12:12:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114092","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3238329","reservation_id":"108417","confirmation_number":"SJ12659003147","room_confirmation_number":"SJ12680090526","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"114871","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 23:50:14","reservation_modified_date_time":"2021-04-21 12:14:39","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114871","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3239161","reservation_id":"108276","confirmation_number":"SJ12661582960","room_confirmation_number":"SJ12644672036","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"114736","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 17:11:09","reservation_modified_date_time":"2021-04-21 21:02:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114736","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239163","reservation_id":"108247","confirmation_number":"SJ12675950755","room_confirmation_number":"SJ12695126762","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"114715","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 04:15:10","reservation_modified_date_time":"2021-04-21 21:02:37","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114715","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239276","reservation_id":"110797","confirmation_number":"SJ12618326822","room_confirmation_number":"SJ12667407905","room_stay_from":"2021-04-21","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"117308","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-20 14:52:15","reservation_modified_date_time":"2021-04-21 22:30:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117308","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239355","reservation_id":"112649","confirmation_number":"SJ12626097145","room_confirmation_number":"SJ12640893806","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"119239","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-11 02:13:08","reservation_modified_date_time":"2021-04-22 00:47:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119239","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239855","reservation_id":"113645","confirmation_number":"SJ12677960734","room_confirmation_number":"SJ12675366204","room_stay_from":"2021-04-22","room_stay_to":"2021-04-24","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"120245","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 18:42:08","reservation_modified_date_time":"2021-04-22 18:42:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120245","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202410","reservation_id":"108217","confirmation_number":"SJ12697238969","room_confirmation_number":"SJ12638182436","room_stay_from":"2021-04-19","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"114681","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 22:29:08","reservation_modified_date_time":"2021-02-21 22:29:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114681","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3202452","reservation_id":"108225","confirmation_number":"SJ12682473531","room_confirmation_number":"SJ12613420122","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"114689","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-21 23:57:11","reservation_modified_date_time":"2021-02-21 23:57:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114689","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3205318","reservation_id":"108706","confirmation_number":"SJ12611926018","room_confirmation_number":"SJ12650908962","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"115155","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 02:10:44","reservation_modified_date_time":"2021-02-27 02:10:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115155","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3211137","reservation_id":"108700","confirmation_number":"SJ12684099128","room_confirmation_number":"SJ12691038258","room_stay_from":"2021-04-18","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115151","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-27 01:30:49","reservation_modified_date_time":"2021-03-07 15:18:15","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3216935","reservation_id":"110454","confirmation_number":"SJ12616414655","room_confirmation_number":"SJ12689106582","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"116966","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-16 22:38:09","reservation_modified_date_time":"2021-03-16 22:38:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116966","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3226153","reservation_id":"109826","confirmation_number":"SJ12674740515","room_confirmation_number":"SJ12686591222","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"116317","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-09 03:17:10","reservation_modified_date_time":"2021-04-01 21:08:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116317","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3227335","reservation_id":"108303","confirmation_number":"SJ12657784253","room_confirmation_number":"SJ12676952612","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"114760","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-22 19:45:11","reservation_modified_date_time":"2021-04-03 20:40:49","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114760","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229262","reservation_id":"110895","confirmation_number":"SJ12699577904","room_confirmation_number":"SJ12686447493","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"117415","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-21 18:11:13","reservation_modified_date_time":"2021-04-07 00:06:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117415","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3229706","reservation_id":"110622","confirmation_number":"SJ12631021197","room_confirmation_number":"SJ12680227760","room_stay_from":"2021-04-22","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"117133","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-18 14:47:09","reservation_modified_date_time":"2021-04-07 16:39:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117133","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3236957","reservation_id":"108124","confirmation_number":"SJ12675583552","room_confirmation_number":"SJ12696320667","room_stay_from":"2021-04-19","room_stay_to":"2021-04-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"114586","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-20 18:42:13","reservation_modified_date_time":"2021-04-18 18:15:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114586","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3203890","reservation_id":"108477","confirmation_number":"SJ12669079365","room_confirmation_number":"SJ12658659294","room_stay_from":"2021-04-22","room_stay_to":"2021-04-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"114923","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-24 20:25:52","reservation_modified_date_time":"2021-02-24 20:25:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114923","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3208471","reservation_id":"109233","confirmation_number":"SJ12640303614","room_confirmation_number":"SJ12672816426","room_stay_from":"2021-04-22","room_stay_to":"2021-04-26","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"115701","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 00:14:12","reservation_modified_date_time":"2021-03-04 00:14:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115701","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3236955","reservation_id":"100701","confirmation_number":"SJ12652259620","room_confirmation_number":"SJ12688302981","room_stay_from":"2021-04-22","room_stay_to":"2021-04-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"106727","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-22 00:31:37","reservation_modified_date_time":"2021-04-18 18:15:30","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239550","reservation_id":"110979","confirmation_number":"SJ12618454113","room_confirmation_number":"SJ12650049589","room_stay_from":"2021-04-21","room_stay_to":"2021-04-22","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"117516","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 17:32:12","reservation_modified_date_time":"2021-04-22 13:03:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117516","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239666","reservation_id":"113606","confirmation_number":"SJ12671861259","room_confirmation_number":"SJ12633417978","room_stay_from":"2021-05-10","room_stay_to":"2021-05-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120209","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-22 02:44:17","reservation_modified_date_time":"2021-04-22 14:20:05","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120209","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}