{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-21","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":22,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1311,1312","block_room_bookings":[{"confirmation_number":"SJ12635136359","room_stay_from":"2021-04-21","room_stay_to":"2021-04-22","bundle_room":"1","product_id":"1332"}],"bundle_block_count":"1309,1310,1269,1270,1291,1711,1311,1312,1304,1305,1262,1263,1267,1268,1302,1303,1260,1261,1307,1308,1271,1272","bundle_block_bookings":[{"confirmation_number":"SJB12668673854","room_stay_from":"2021-04-18","room_stay_to":"2021-04-22","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12613791694","room_stay_from":"2021-04-20","room_stay_to":"2021-04-22","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12647162641","room_stay_from":"2021-04-21","room_stay_to":"2021-04-22","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12632065775","room_stay_from":"2021-04-21","room_stay_to":"2021-04-22","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12626475942","room_stay_from":"2021-04-21","room_stay_to":"2021-04-22","bundle_room":"0","product_id":"1312"},{"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":"SJB12612420326","room_stay_from":"2021-04-21","room_stay_to":"2021-04-23","bundle_room":"1","product_id":"1321"},{"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"}]},"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":"231.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":"3223850","reservation_id":"111496","confirmation_number":"SJ12668382981","room_stay_from":"2021-04-18","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,230.30,251.30,251.30","nightly_discount":"0,0,0,0","subtotal":"963.20","grand_total":"1083.60","paid_amount":"1083.60","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-3111740107","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":"118063","customer_id":"118063","source_of_creation":"Booking.com","reservation_created_date":"2021-03-28 13:40:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"191.38","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"251.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":"3225407","reservation_id":"110493","confirmation_number":"SJ12643406014","room_stay_from":"2021-04-19","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"152.8,152.8,180.8","nightly_discount":"0,0,0","subtotal":"486.40","grand_total":"547.20","paid_amount":"547.20","room_type_id":"319","product_id":"1277","siteminder_id":"BDC-2404920756","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":"120006","customer_id":"117006","source_of_creation":"Booking.com","reservation_created_date":"2021-03-17 04:01:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"114.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"180.8","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":"216.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":"3229701","reservation_id":"111267","confirmation_number":"SJ12622533546","room_stay_from":"2021-04-19","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.75,231.75,231.75","nightly_discount":"0,0,0","subtotal":"695.25","grand_total":"782.15","paid_amount":"782.15","room_type_id":"319","product_id":"1943","siteminder_id":"BDC-2794405258","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":"117800","customer_id":"117800","source_of_creation":"Booking.com","reservation_created_date":"2021-03-25 17:03:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"138.65","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"231.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":"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":"169.47","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":"3230626","reservation_id":"112445","confirmation_number":"SJ12657981240","room_stay_from":"2021-04-20","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"276.48,276.48","nightly_discount":"0,0","subtotal":"552.96","grand_total":"622.08","paid_amount":"622.08","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-3120998345","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":"119015","customer_id":"119015","source_of_creation":"Booking.com","reservation_created_date":"2021-04-08 15:53:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"108.53","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"276.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":"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":"247.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":"169.47","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","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","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":"3238475","reservation_id":"113234","confirmation_number":"SJ12655211599","room_stay_from":"2021-06-04","room_stay_to":"2021-06-09","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.16,224.16,181.64,181.64,181.64","nightly_discount":"0,0,0,0,0","subtotal":"993.24","grand_total":"1117.39","paid_amount":"252.18","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-3480112141","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":"119826","customer_id":"119826","source_of_creation":"Booking.com","reservation_created_date":"2021-04-17 18:22:22","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":"","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":"3238479","reservation_id":"113274","confirmation_number":"SJ12613061202","room_stay_from":"2021-06-03","room_stay_to":"2021-06-06","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.25,299.25,299.25","nightly_discount":"0,0,0","subtotal":"807.75","grand_total":"908.72","paid_amount":"235.40","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3916072506","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":"119863","customer_id":"119863","source_of_creation":"Booking.com","reservation_created_date":"2021-04-18 02:02:27","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","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":"3238750","reservation_id":"113417","confirmation_number":"SJ12686409126","room_stay_from":"2021-07-22","room_stay_to":"2021-07-27","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"265.30,314.30,314.30,265.30,279.30","nightly_discount":"0,0,0,0,0","subtotal":"1438.50","grand_total":"1618.32","paid_amount":"298.47","room_type_id":"320","product_id":"1322","siteminder_id":"BDC-2834861001","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":"120005","customer_id":"120005","source_of_creation":"Booking.com","reservation_created_date":"2021-04-19 20:01:24","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","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"}]},{"room_stay_id":"3238902","reservation_id":"113429","confirmation_number":"SJ12616905134","room_stay_from":"2021-08-15","room_stay_to":"2021-08-18","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,149.25,149.25","nightly_discount":"0,0,0","subtotal":"447.75","grand_total":"503.72","paid_amount":"167.90","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-3359408008","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":"120020","customer_id":"120020","source_of_creation":"Booking.com","reservation_created_date":"2021-04-19 21:50:18","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","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"}]},{"room_stay_id":"3239344","reservation_id":"112739","confirmation_number":"SJ12618618153","room_stay_from":"2021-05-21","room_stay_to":"2021-05-23","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"311.20,287.20","nightly_discount":"0,0","subtotal":"598.40","grand_total":"673.20","paid_amount":"386.10","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3502652674","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":"119336","customer_id":"119336","source_of_creation":"Booking.com","reservation_created_date":"2021-04-12 01:14:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"116.72","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","changedComment":"both dates 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":"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":"167.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":"3216934","reservation_id":"110454","confirmation_number":"SJ12689106582","room_stay_from":"2021-04-21","room_stay_to":"2021-04-25","room_stay_status":"Active","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":"235.47","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":"209.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":"3218133","reservation_id":"110631","confirmation_number":"SJ12653884458","room_stay_from":"2021-04-17","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"240.24,167.44,145.04,145.04,167.44","nightly_discount":"0,0,0,0,0","subtotal":"865.20","grand_total":"973.35","paid_amount":"973.35","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1749140435","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":"117138","customer_id":"117138","source_of_creation":"Expedia","reservation_created_date":"2021-03-18 15:52:06","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":"167.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":"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":"243.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":"3220553","reservation_id":"110979","confirmation_number":"SJ12650049589","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":"1","nightly_price":"200.40,212.40,272.40","nightly_discount":"0,0,0","subtotal":"685.20","grand_total":"770.85","paid_amount":"770.85","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"200.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":"3235351","reservation_id":"108854","confirmation_number":"SJ12673184346","room_stay_from":"2021-04-18","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"170.24,170.24,170.24,170.24","nightly_discount":"0,0,0,0","subtotal":"680.96","grand_total":"766.08","paid_amount":"766.08","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1742513887","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":"115311","customer_id":"115311","source_of_creation":"Expedia","reservation_created_date":"2021-02-28 19:22:08","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":"126","group_rooms":null,"currentDayPrice":"170.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":"3236946","reservation_id":"110385","confirmation_number":"SJ12620947491","room_stay_from":"2021-04-19","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.75,171.75,201.75","nightly_discount":"0,0,0","subtotal":"545.25","grand_total":"613.40","paid_amount":"613.40","room_type_id":"413","product_id":"1270","siteminder_id":"EXP-1748012160","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":"119920","customer_id":"116898","source_of_creation":"Expedia","reservation_created_date":"2021-03-15 21:07:07","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":"126","group_rooms":null,"currentDayPrice":"201.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":"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":"3238399","reservation_id":"113256","confirmation_number":"SJ12626654144","room_stay_from":"2021-05-15","room_stay_to":"2021-05-18","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"257.40,197.40,197.40","nightly_discount":"0,0,0","subtotal":"652.20","grand_total":"733.73","paid_amount":"0.00","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1760760659","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":"119846","customer_id":"119846","source_of_creation":"Expedia","reservation_created_date":"2021-04-17 20:53:22","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":"","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":"3238423","reservation_id":"113423","confirmation_number":"SJ12682658179","room_stay_from":"2021-05-22","room_stay_to":"2021-05-29","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.40,179.40,179.40,155.40,179.40,179.40,275.40","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1363.80","grand_total":"1534.28","paid_amount":"0.00","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1761467576","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":"120013","customer_id":"120013","source_of_creation":"Expedia","reservation_created_date":"2021-04-19 21:03:35","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":"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":"3238687","reservation_id":"113449","confirmation_number":"SJ12691182456","room_stay_from":"2021-07-20","room_stay_to":"2021-07-23","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"4","nightly_price":"321.75,321.75,321.75","nightly_discount":"0,0,0","subtotal":"965.25","grand_total":"1085.90","paid_amount":"361.97","room_type_id":"320","product_id":"1329","siteminder_id":"EXP-1761574704","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":"120041","customer_id":"120041","source_of_creation":"Expedia","reservation_created_date":"2021-04-20 01:49:17","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":"","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":"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":"166.55","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":"3225421","reservation_id":"111707","confirmation_number":"SJ12624537142","room_stay_from":"2021-04-17","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.23,177.33,177.33,193.50,193.50","nightly_discount":"0,0,0,0,0","subtotal":"972.89","grand_total":"1094.50","paid_amount":"1094.50","room_type_id":"319","product_id":"1288","siteminder_id":"GAM-R2417817756","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":"118267","customer_id":"118267","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-30 20:36:23","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":"193.50","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":"3235340","reservation_id":"108385","confirmation_number":"SJ12624732961","room_stay_from":"2021-04-21","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.88","nightly_discount":"0","subtotal":"185.88","grand_total":"209.11","paid_amount":"209.11","room_type_id":"412","product_id":"1315","siteminder_id":"GAM-R2343393833","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":"114836","customer_id":"114836","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-23 13:02:12","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":"126","group_rooms":null,"currentDayPrice":"185.88","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":"3235348","reservation_id":"108384","confirmation_number":"SJ12618776548","room_stay_from":"2021-04-21","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.88","nightly_discount":"0","subtotal":"185.88","grand_total":"209.11","paid_amount":"209.11","room_type_id":"412","product_id":"1316","siteminder_id":"GAM-R2343390982","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":"114835","customer_id":"114835","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-23 12:57:10","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":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"185.88","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":"3236761","reservation_id":"105295","confirmation_number":"SJ12691488696","room_stay_from":"2021-04-18","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"205.08,210.12,210.12,210.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"835.44","grand_total":"968.16","paid_amount":"968.16","room_type_id":"413","product_id":"1264","siteminder_id":"ABB-HMSPNZBC3B","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"840.48","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111682","customer_id":"111682","source_of_creation":"Airbnb","reservation_created_date":"2021-01-13 23:55:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"24.72","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"210.12","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"}]},{"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","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","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":"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":"231.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"}]}],"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":"3229348","reservation_id":"112146","confirmation_number":"SJ12666534677","room_stay_from":"2021-04-19","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,269.25,269.25","nightly_discount":"24.68,26.93,26.93","subtotal":"785.25","grand_total":"795.05","paid_amount":"795.05","room_type_id":"319","product_id":"1313","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":"118715","customer_id":"118715","source_of_creation":"PMS","reservation_created_date":"2021-04-05 13:48:28","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"269.25","currentDayDiscount":"26.93","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":"3237321","reservation_id":"113320","confirmation_number":"SJ12611073885","room_stay_from":"2021-04-21","room_stay_to":"2021-04-22","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":"319","product_id":"1291","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:31","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","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":"3237759","reservation_id":"113428","confirmation_number":"SJ12628309979","room_stay_from":"2021-04-20","room_stay_to":"2021-04-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.65,305.15","nightly_discount":"0.00,0.00","subtotal":"584.80","grand_total":"657.90","paid_amount":"657.90","room_type_id":"319","product_id":"1711","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":"120019","customer_id":"120019","source_of_creation":"PMS","reservation_created_date":"2021-04-19 21:45:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","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":"305.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":"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","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":"3238553","reservation_id":"109499","confirmation_number":"SJ12694334256","room_stay_from":"2021-07-20","room_stay_to":"2021-07-26","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.65,194.65,194.65,228.65,228.65,194.65","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1235.90","grand_total":"1390.39","paid_amount":"218.98","room_type_id":"319","product_id":"1917","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":"115963","customer_id":"115963","source_of_creation":"PMS","reservation_created_date":"2021-03-05 17:19:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","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","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":"3239145","reservation_id":"111177","confirmation_number":"SJ12698925046","room_stay_from":"2021-06-09","room_stay_to":"2021-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.00,160.00,160.00,160.00,160.00","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"800.00","grand_total":"900.00","paid_amount":"0.00","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":"74927","customer_id":"74927","source_of_creation":"PMS","reservation_created_date":"2021-03-24 15:16:22","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","changedComment":"From 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":"3239147","reservation_id":"111176","confirmation_number":"SJ12676930896","room_stay_from":"2021-06-09","room_stay_to":"2021-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.00,160.00,160.00,160.00,160.00","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"800.00","grand_total":"900.00","paid_amount":"0.00","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":"74927","customer_id":"74927","source_of_creation":"PMS","reservation_created_date":"2021-03-24 15:12:11","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","changedComment":"From 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":"3239149","reservation_id":"111180","confirmation_number":"SJ12681378780","room_stay_from":"2021-06-09","room_stay_to":"2021-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.00,160.00,160.00,160.00,160.00","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"800.00","grand_total":"900.00","paid_amount":"0.00","room_type_id":"412","product_id":"1316","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":"74927","customer_id":"74927","source_of_creation":"PMS","reservation_created_date":"2021-03-24 15:30:45","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":"","sub_hotel_id":"0","changedComment":"From 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":"3239151","reservation_id":"111181","confirmation_number":"SJ12691024614","room_stay_from":"2021-06-09","room_stay_to":"2021-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.00,160.00,160.00,160.00,160.00","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"800.00","grand_total":"900.00","paid_amount":"0.00","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":"74927","customer_id":"74927","source_of_creation":"PMS","reservation_created_date":"2021-03-24 15:33:30","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":"","sub_hotel_id":"0","changedComment":"From 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":"3239153","reservation_id":"111627","confirmation_number":"SJ12632256710","room_stay_from":"2021-06-09","room_stay_to":"2021-06-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.00,160.00,160.00,160.00,160.00","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"800.00","grand_total":"900.00","paid_amount":"0.00","room_type_id":"318","product_id":"1282","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":"74927","customer_id":"74927","source_of_creation":"PMS","reservation_created_date":"2021-03-29 22:18:54","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":"0","changedComment":"From 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"}]}],"pms_non_taxable":[{"room_stay_id":"3239309","reservation_id":"86852","confirmation_number":"SJ12638335503","room_stay_from":"2019-12-15","room_stay_to":"2019-12-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","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","room_type_id":"412","product_id":"1316","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"113529","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2019-11-08 15:32:17","canceled_nights_data":"","product_name":"Deluxe 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":"0","changedComment":"Nightly price or discount changed","deltaChange":"-695.00","currentDayPrice":0,"currentDayDiscount":0,"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"}]}],"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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3225408","reservation_id":"110493","confirmation_number":"SJ12629800341","room_confirmation_number":"SJ12643406014","room_stay_from":"2021-04-19","room_stay_to":"2021-04-22","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"120006","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-03-31 02:52:20","reservation_modified_date_time":"2021-03-31 02:52:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117006","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","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":"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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3218134","reservation_id":"110631","confirmation_number":"SJ12683890528","room_confirmation_number":"SJ12653884458","room_stay_from":"2021-04-17","room_stay_to":"2021-04-22","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":"117138","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-18 15:52:06","reservation_modified_date_time":"2021-03-18 15:52:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117138","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":"3223851","reservation_id":"111496","confirmation_number":"SJ12687483967","room_confirmation_number":"SJ12668382981","room_stay_from":"2021-04-18","room_stay_to":"2021-04-22","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":"118063","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-28 13:40:13","reservation_modified_date_time":"2021-03-28 13:40:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118063","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":"3225409","reservation_id":"110493","confirmation_number":"SJ12622891298","room_confirmation_number":"SJ12643406014","room_stay_from":"2021-04-19","room_stay_to":"2021-04-22","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":"120006","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-17 04:01:25","reservation_modified_date_time":"2021-03-31 02:52:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117006","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":"3225420","reservation_id":"111707","confirmation_number":"SJ12657873816","room_confirmation_number":"SJ12624537142","room_stay_from":"2021-04-17","room_stay_to":"2021-04-22","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":"118267","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 20:36:23","reservation_modified_date_time":"2021-03-30 21:39:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118267","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":"3229351","reservation_id":"112146","confirmation_number":"SJ12632681209","room_confirmation_number":"SJ12666534677","room_stay_from":"2021-04-19","room_stay_to":"2021-04-22","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":"118715","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-05 13:48:28","reservation_modified_date_time":"2021-04-07 02:53:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118715","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":"3229702","reservation_id":"111267","confirmation_number":"SJ12696916918","room_confirmation_number":"SJ12622533546","room_stay_from":"2021-04-19","room_stay_to":"2021-04-22","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":"117800","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-25 17:03:08","reservation_modified_date_time":"2021-04-07 16:39:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117800","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":"3230627","reservation_id":"112445","confirmation_number":"SJ12663611643","room_confirmation_number":"SJ12657981240","room_stay_from":"2021-04-20","room_stay_to":"2021-04-22","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":"119015","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-08 15:53:08","reservation_modified_date_time":"2021-04-08 15:53:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119015","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":"3235341","reservation_id":"108385","confirmation_number":"SJ12638200396","room_confirmation_number":"SJ12624732961","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":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"114836","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 13:02:12","reservation_modified_date_time":"2021-04-16 15:39:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114836","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":"3235349","reservation_id":"108384","confirmation_number":"SJ12625330612","room_confirmation_number":"SJ12618776548","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":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"114835","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-23 12:57:10","reservation_modified_date_time":"2021-04-16 15:42:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114835","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":"3235352","reservation_id":"108854","confirmation_number":"SJ12612837218","room_confirmation_number":"SJ12673184346","room_stay_from":"2021-04-18","room_stay_to":"2021-04-22","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":"115311","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-02-28 19:22:08","reservation_modified_date_time":"2021-04-16 15:42:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115311","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":"3236762","reservation_id":"105295","confirmation_number":"SJ12688019931","room_confirmation_number":"SJ12691488696","room_stay_from":"2021-04-18","room_stay_to":"2021-04-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"111682","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-13 23:55:06","reservation_modified_date_time":"2021-04-18 12:32:27","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111682","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":"3236947","reservation_id":"110385","confirmation_number":"SJ12676347786","room_confirmation_number":"SJ12620947491","room_stay_from":"2021-04-19","room_stay_to":"2021-04-22","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":"119920","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-15 21:07:07","reservation_modified_date_time":"2021-04-18 18:14:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116898","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":"3237322","reservation_id":"113320","confirmation_number":"SJ12610330093","room_confirmation_number":"SJ12611073885","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":"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:31","reservation_modified_date_time":"2021-04-19 14:38:44","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":"3237760","reservation_id":"113428","confirmation_number":"SJ12696551996","room_confirmation_number":"SJ12628309979","room_stay_from":"2021-04-20","room_stay_to":"2021-04-22","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":"120019","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-19 21:45:18","reservation_modified_date_time":"2021-04-19 21:45:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120019","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":"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":"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":"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":"3220554","reservation_id":"110979","confirmation_number":"SJ12618454113","room_confirmation_number":"SJ12650049589","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":"117516","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-22 17:32:12","reservation_modified_date_time":"2021-03-22 17:32:12","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","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":"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":"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":"0.00","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":"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":"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":"3238398","reservation_id":"113256","confirmation_number":"SJ12666760090","room_confirmation_number":"SJ12626654144","room_stay_from":"2021-05-15","room_stay_to":"2021-05-18","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119846","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 20:53:22","reservation_modified_date_time":"2021-04-21 13:15:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119846","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":"3238422","reservation_id":"113423","confirmation_number":"SJ12644907521","room_confirmation_number":"SJ12682658179","room_stay_from":"2021-05-22","room_stay_to":"2021-05-29","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":"120013","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-19 21:03:35","reservation_modified_date_time":"2021-04-21 13:20:43","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120013","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":"3238476","reservation_id":"113234","confirmation_number":"SJ12647985842","room_confirmation_number":"SJ12655211599","room_stay_from":"2021-06-04","room_stay_to":"2021-06-09","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":"119826","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 18:22:22","reservation_modified_date_time":"2021-04-21 13:42:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119826","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":"3238480","reservation_id":"113274","confirmation_number":"SJ12630278274","room_confirmation_number":"SJ12613061202","room_stay_from":"2021-06-03","room_stay_to":"2021-06-06","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119863","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-18 02:02:27","reservation_modified_date_time":"2021-04-21 13:43:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119863","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":"3238554","reservation_id":"109499","confirmation_number":"SJ12615025084","room_confirmation_number":"SJ12694334256","room_stay_from":"2021-07-20","room_stay_to":"2021-07-26","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"115963","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-05 17:19:15","reservation_modified_date_time":"2021-04-21 14:55:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115963","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3238686","reservation_id":"113449","confirmation_number":"SJ12622288370","room_confirmation_number":"SJ12691182456","room_stay_from":"2021-07-20","room_stay_to":"2021-07-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120041","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-20 01:49:17","reservation_modified_date_time":"2021-04-21 15:32:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120041","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":"3238753","reservation_id":"113417","confirmation_number":"SJ12648967764","room_confirmation_number":"SJ12686409126","room_stay_from":"2021-07-22","room_stay_to":"2021-07-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":"120005","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-19 20:01:24","reservation_modified_date_time":"2021-04-21 15:49:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120005","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":"3238901","reservation_id":"113429","confirmation_number":"SJ12683425300","room_confirmation_number":"SJ12616905134","room_stay_from":"2021-08-15","room_stay_to":"2021-08-18","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"120020","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-19 21:50:18","reservation_modified_date_time":"2021-04-21 17:11:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120020","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":"3239146","reservation_id":"111177","confirmation_number":"SJ12661216666","room_confirmation_number":"SJ12698925046","room_stay_from":"2021-06-09","room_stay_to":"2021-06-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"10.00,10.00,10.00,10.00,0.00","subtotal":"125.00","grand_total":"95.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"74927","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 15:16:22","reservation_modified_date_time":"2021-04-21 20:53:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74927","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From 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":"3239148","reservation_id":"111176","confirmation_number":"SJ12682484207","room_confirmation_number":"SJ12676930896","room_stay_from":"2021-06-09","room_stay_to":"2021-06-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"10.00,10.00,10.00,10.00,0.00","subtotal":"125.00","grand_total":"95.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"74927","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 15:12:11","reservation_modified_date_time":"2021-04-21 20:53:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74927","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From 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":"3239150","reservation_id":"111180","confirmation_number":"SJ12681565020","room_confirmation_number":"SJ12681378780","room_stay_from":"2021-06-09","room_stay_to":"2021-06-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"10.00,10.00,10.00,10.00,0.00","subtotal":"125.00","grand_total":"95.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"74927","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 15:30:45","reservation_modified_date_time":"2021-04-21 20:53:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74927","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From 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":"3239152","reservation_id":"111181","confirmation_number":"SJ12615676897","room_confirmation_number":"SJ12691024614","room_stay_from":"2021-06-09","room_stay_to":"2021-06-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"10.00,10.00,10.00,10.00,0.00","subtotal":"125.00","grand_total":"95.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"74927","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 15:33:30","reservation_modified_date_time":"2021-04-21 20:53:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74927","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From 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":"3239154","reservation_id":"111627","confirmation_number":"SJ12622561199","room_confirmation_number":"SJ12632256710","room_stay_from":"2021-06-09","room_stay_to":"2021-06-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"10.00,10.00,10.00,10.00,0.00","subtotal":"125.00","grand_total":"95.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"74927","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-29 22:18:54","reservation_modified_date_time":"2021-04-21 20:54:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74927","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"From 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":"3239345","reservation_id":"112739","confirmation_number":"SJ12611474833","room_confirmation_number":"SJ12618618153","room_stay_from":"2021-05-21","room_stay_to":"2021-05-23","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119336","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-12 01:14:09","reservation_modified_date_time":"2021-04-22 00:20:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119336","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"both dates 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":[{"room_stay_id":"3238491","reservation_id":"113527","confirmation_number":"SJ12696163445","room_confirmation_number":"SJ12698371823","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.86","grand_total":"2.00","paid_amount":"2.00","product_id":"1660","service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-21 14:12:09","reservation_modified_date_time":"2021-04-21 14:12:09","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"1.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}