{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-08-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":13,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1273","block_room_bookings":[{"confirmation_number":"SJ12646427749","room_stay_from":"2021-08-13","room_stay_to":"2021-08-30","bundle_room":"0","product_id":"1273"}],"bundle_block_count":"1291,1711,1260,1261,1302,1303,1307,1308,1267,1268,1271,1272,1309,1310,1262,1263,1311,1312,1269,1270,1304,1305","bundle_block_bookings":[{"confirmation_number":"SJB12655865910","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12641238538","room_stay_from":"2021-08-20","room_stay_to":"2021-08-23","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12612904344","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12690952593","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12672411594","room_stay_from":"2021-08-21","room_stay_to":"2021-08-23","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12650813738","room_stay_from":"2021-08-21","room_stay_to":"2021-08-23","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12684123643","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12675928623","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1268"},{"confirmation_number":"SJB12676600359","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12670998181","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12620777661","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12682017133","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12633656526","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12630740888","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12651093841","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12637798624","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12638580154","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12645799746","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","bundle_room":"0","product_id":"1305"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3238914","reservation_id":"111215","confirmation_number":"SJ12624482451","room_stay_from":"2021-08-18","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"101.49,101.49,135.51,135.51,101.49","nightly_discount":"0,0,0,0,0","subtotal":"575.49","grand_total":"647.42","paid_amount":"647.42","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2282879312","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":"117746","customer_id":"117746","source_of_creation":"Booking.com","reservation_created_date":"2021-03-24 23:08:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"264.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"135.51","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":"3238917","reservation_id":"111215","confirmation_number":"SJ12685471986","room_stay_from":"2021-08-18","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"115.67,115.67,149.69,149.69,115.67","nightly_discount":"0,0,0,0,0","subtotal":"646.39","grand_total":"727.19","paid_amount":"727.19","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-2282879312","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":"117746","customer_id":"117746","source_of_creation":"Booking.com","reservation_created_date":"2021-03-24 23:08:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"264.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"149.69","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":"3272513","reservation_id":"117719","confirmation_number":"SJ12631500137","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.20,239.20","nightly_discount":"0,0","subtotal":"478.40","grand_total":"538.20","paid_amount":"538.20","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-2142491518","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":"124695","customer_id":"124695","source_of_creation":"Booking.com","reservation_created_date":"2021-06-20 21:37:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"95.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.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":"3293904","reservation_id":"120488","confirmation_number":"SJ12678815947","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.30,300.30,230.30,230.30,230.30,230.30,230.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1752.10","grand_total":"1971.12","paid_amount":"1971.12","room_type_id":"319","product_id":"1943","siteminder_id":"BDC-3035373619","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":"127802","customer_id":"127802","source_of_creation":"Booking.com","reservation_created_date":"2021-07-31 20:58:37","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"300.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":"3295914","reservation_id":"118654","confirmation_number":"SJ12613221044","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"239.57,286.82,286.82","nightly_discount":"0,0,0","subtotal":"813.21","grand_total":"914.86","paid_amount":"914.86","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-2234460041","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":"125732","customer_id":"125732","source_of_creation":"Booking.com","reservation_created_date":"2021-07-04 14:28:22","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","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","group_rooms":"1302,1303","currentDayPrice":"286.82","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":"3303478","reservation_id":"121282","confirmation_number":"SJ12634904040","room_stay_from":"2021-08-21","room_stay_to":"2021-08-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.87,139.12,139.12","nightly_discount":"0,0,0","subtotal":"478.11","grand_total":"537.88","paid_amount":"537.88","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2725140938","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":"128753","customer_id":"128753","source_of_creation":"Booking.com","reservation_created_date":"2021-08-16 16:10: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","group_rooms":null,"currentDayPrice":"199.87","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":"3304366","reservation_id":"121439","confirmation_number":"SJ12611860526","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.63,232.63","nightly_discount":"0,0","subtotal":"465.26","grand_total":"523.41","paid_amount":"523.41","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3244400761","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":"128916","customer_id":"128916","source_of_creation":"Booking.com","reservation_created_date":"2021-08-18 23:49:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"92.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"232.63","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":"3304551","reservation_id":"121418","confirmation_number":"SJ12660975173","room_stay_from":"2021-08-20","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,171.75","nightly_discount":"0,0,0","subtotal":"665.25","grand_total":"748.40","paid_amount":"748.40","room_type_id":"319","product_id":"1756","siteminder_id":"BDC-2469631891","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":"128891","customer_id":"128891","source_of_creation":"Booking.com","reservation_created_date":"2021-08-18 19:59:19","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":"126","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305168","reservation_id":"121506","confirmation_number":"SJ12663862019","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"307.20,307.20","nightly_discount":"0,0","subtotal":"614.40","grand_total":"691.20","paid_amount":"691.20","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2746828092","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":"128987","customer_id":"128987","source_of_creation":"Booking.com","reservation_created_date":"2021-08-19 17:46:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"119.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"307.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":"3305437","reservation_id":"121576","confirmation_number":"SJ12625817643","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.20,239.20","nightly_discount":"0,0","subtotal":"478.40","grand_total":"538.20","paid_amount":"538.20","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-3943632330","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":"129066","customer_id":"129066","source_of_creation":"Booking.com","reservation_created_date":"2021-08-20 17:33:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"95.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.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":"3305834","reservation_id":"121613","confirmation_number":"SJ12640639749","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,230.30,160.30,160.30,160.30","nightly_discount":"0,0,0,0,0","subtotal":"941.50","grand_total":"1059.19","paid_amount":"1059.19","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-3010268276","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":"129114","customer_id":"129114","source_of_creation":"Booking.com","reservation_created_date":"2021-08-20 22:28:37","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":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3306107","reservation_id":"121650","confirmation_number":"SJ12630700219","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"205.86","nightly_discount":"0","subtotal":"205.86","grand_total":"231.59","paid_amount":"231.59","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-2797038430","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":"129173","customer_id":"129173","source_of_creation":"Booking.com","reservation_created_date":"2021-08-21 16:31:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"41.55","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"205.86","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":"5178458","reservation_id":"121675","confirmation_number":"SJ12664104120","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.52","nightly_discount":"0","subtotal":"226.52","grand_total":"254.84","paid_amount":"254.84","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-3017525659","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":"129211","customer_id":"129211","source_of_creation":"Booking.com","reservation_created_date":"2021-08-21 23:09:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"45.27","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"226.52","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":[{"room_stay_id":"3300491","reservation_id":"113834","confirmation_number":"SJ12655737749","room_stay_from":"2021-08-21","room_stay_to":"2021-08-23","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"211.92","room_type_id":"413","product_id":"1261","siteminder_id":"BDC-2521097594","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":"120460","customer_id":"120460","source_of_creation":"Booking.com","reservation_created_date":"2021-04-25 13:07:17","service_canceled_date_time":"2021-08-14 21:00:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"59.80","sub_hotel_id":"126","deltaChange":"211.92","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3304545","reservation_id":"121421","confirmation_number":"SJ12681712746","room_stay_from":"2021-08-19","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.32,138.32,138.32,96.32","nightly_discount":"0,0,0,0","subtotal":"469.28","grand_total":"527.94","paid_amount":"527.94","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1818064860","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":"128893","customer_id":"128893","source_of_creation":"Expedia","reservation_created_date":"2021-08-18 20:43:26","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":"138.32","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":"3304972","reservation_id":"113356","confirmation_number":"SJ12634933985","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.25,201.75,201.75","nightly_discount":"0.00,0.00,0.00","subtotal":"552.75","grand_total":"621.85","paid_amount":"621.85","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1761284054","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":"119948","customer_id":"119948","source_of_creation":"Expedia","reservation_created_date":"2021-04-19 11:23:11","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":"201.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3304989","reservation_id":"121523","confirmation_number":"SJ12627710445","room_stay_from":"2021-08-21","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"2","nightly_price":"373.2,293.2","nightly_discount":"0,0","subtotal":"666.40","grand_total":"749.70","paid_amount":"749.70","room_type_id":"320","product_id":"1330","siteminder_id":"EXP-1818525685","collect_which":"hotel_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":"129007","customer_id":"129007","source_of_creation":"Expedia","reservation_created_date":"2021-08-19 20:34:13","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":null,"sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"373.2","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":"3305170","reservation_id":"121472","confirmation_number":"SJ12625989993","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"192.56,192.56","nightly_discount":"0,0","subtotal":"385.12","grand_total":"433.26","paid_amount":"433.26","room_type_id":"319","product_id":"1291","siteminder_id":"EXP-1818364208","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":"128955","customer_id":"128955","source_of_creation":"Expedia","reservation_created_date":"2021-08-19 14:03:10","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":"126","group_rooms":null,"currentDayPrice":"192.56","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3305461","reservation_id":"120105","confirmation_number":"SJ12652611482","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"210.56,210.56","nightly_discount":"0.00,0.00","subtotal":"421.12","grand_total":"473.76","paid_amount":"473.76","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1806946227","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":"127355","customer_id":"127355","source_of_creation":"Expedia","reservation_created_date":"2021-07-26 14:40:10","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"210.56","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":"3305471","reservation_id":"112593","confirmation_number":"SJ12665719773","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.96,152.96","nightly_discount":"0,0","subtotal":"305.92","grand_total":"344.16","paid_amount":"344.16","room_type_id":"319","product_id":"1311","siteminder_id":"EXP-1758003732","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":"119173","customer_id":"119173","source_of_creation":"Expedia","reservation_created_date":"2021-04-10 14:34:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","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":"152.96","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":"3305852","reservation_id":"121614","confirmation_number":"SJ12667172152","room_stay_from":"2021-08-21","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.44,142.24,142.24,142.24","nightly_discount":"0,0,0,0","subtotal":"594.16","grand_total":"668.43","paid_amount":"668.43","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1819053484","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":"129115","customer_id":"129115","source_of_creation":"Expedia","reservation_created_date":"2021-08-20 22:44:21","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","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.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3290719","reservation_id":"120151","confirmation_number":"SJ12654695827","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"202.66,202.66","nightly_discount":"0,0","subtotal":"405.32","grand_total":"455.99","paid_amount":"455.99","room_type_id":"413","product_id":"1265","siteminder_id":"GAM-R2688961532","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":"127408","customer_id":"127408","source_of_creation":"Getaroom.com","reservation_created_date":"2021-07-26 22:06:07","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"202.66","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3305350","reservation_id":"121204","confirmation_number":"SJ12636106363","room_stay_from":"2021-08-20","room_stay_to":"2021-08-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"256.02,256.02,256.02,249.88","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1017.94","grand_total":"1179.65","paid_amount":"1179.65","room_type_id":"319","product_id":"1306","siteminder_id":"ABB-HMSKWNXWXH","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1024.08","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128672","customer_id":"128672","source_of_creation":"Airbnb","reservation_created_date":"2021-08-14 23:40:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"30.12","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"256.02","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":"3305368","reservation_id":"118012","confirmation_number":"SJ12643087510","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"8","room_stay_child_count":"0","nightly_price":"414.08,407.91","nightly_discount":"0.00,0.00","subtotal":"821.99","grand_total":"983.15","paid_amount":"983.15","room_type_id":"320","product_id":"1910","siteminder_id":"ABB-HMNRBF8RBX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"828.16","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125002","customer_id":"125002","source_of_creation":"Airbnb","reservation_created_date":"2021-06-24 22:50:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"30.24","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1309,1310","currentDayPrice":"407.91","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":"3305971","reservation_id":"119784","confirmation_number":"SJ12672238412","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"381.87","nightly_discount":"0.00","subtotal":"381.87","grand_total":"450.81","paid_amount":"450.81","room_type_id":"320","product_id":"1323","siteminder_id":"ABB-HMYDH9N8YC","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"412.58","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126973","customer_id":"126973","source_of_creation":"Airbnb","reservation_created_date":"2021-07-21 14:07:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"12.87","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"381.87","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":"3305999","reservation_id":"121175","confirmation_number":"SJ12663819545","room_stay_from":"2021-08-21","room_stay_to":"2021-08-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.13,268.26,268.26","nightly_discount":"0.00,0.00,0.00","subtotal":"715.65","grand_total":"842.73","paid_amount":"842.73","room_type_id":"319","product_id":"1293","siteminder_id":"ABB-HMT3WZ5SWX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"804.78","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128636","customer_id":"128636","source_of_creation":"Airbnb","reservation_created_date":"2021-08-14 15:52:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"23.67","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"179.13","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":"3306022","reservation_id":"121533","confirmation_number":"SJ12615432002","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"409.20","nightly_discount":"0.00","subtotal":"409.20","grand_total":"482.50","paid_amount":"482.50","room_type_id":"320","product_id":"1329","siteminder_id":"ABB-HMYAA8J548","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"440.12","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129020","customer_id":"129020","source_of_creation":"Airbnb","reservation_created_date":"2021-08-19 22:41:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"13.68","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"409.20","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":"3283840","reservation_id":"116405","confirmation_number":"SJ12670869899","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"254.15","nightly_discount":"0.00","subtotal":"254.15","grand_total":"285.92","paid_amount":"285.92","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":"123273","customer_id":"123273","source_of_creation":"FE","reservation_created_date":"2021-06-02 21:06:46","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","group_rooms":null,"currentDayPrice":"254.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":"3286800","reservation_id":"119523","confirmation_number":"SJ12617496589","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.90,300.90","nightly_discount":"0.00,0.00","subtotal":"601.80","grand_total":"677.03","paid_amount":"677.03","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":"126684","customer_id":"126684","source_of_creation":"FE","reservation_created_date":"2021-07-17 18:36:04","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","group_rooms":null,"currentDayPrice":"300.90","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":"3304626","reservation_id":"116886","confirmation_number":"SJ12640066234","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"224.25,246.75,246.75","nightly_discount":"11.21,12.34,12.34","subtotal":"717.75","grand_total":"767.09","paid_amount":"767.09","room_type_id":"319","product_id":"1318","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":"115615","customer_id":"115615","source_of_creation":"FE","reservation_created_date":"2021-06-09 17:57:39","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","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":"246.75","currentDayDiscount":"12.34","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":"3305399","reservation_id":"121566","confirmation_number":"SJ12654420184","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"279.65","nightly_discount":"0.00","subtotal":"279.65","grand_total":"314.60","paid_amount":"314.60","room_type_id":"319","product_id":"1913","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":"129055","customer_id":"129055","source_of_creation":"FE","reservation_created_date":"2021-08-20 15:31:50","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":"279.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3283829","reservation_id":"117634","confirmation_number":"SJ12673504589","room_stay_from":"2021-08-18","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.00,176.00,176.00,176.00,176.00","nightly_discount":"17.60,17.60,17.60,17.60,17.60","subtotal":"880.00","grand_total":"891.00","paid_amount":"891.00","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":"74162","customer_id":"74162","source_of_creation":"PMS","reservation_created_date":"2021-06-19 17:49:30","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":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"176.00","currentDayDiscount":"17.60","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":"3305173","reservation_id":"120752","confirmation_number":"SJ12639396320","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"466.65","nightly_discount":"23.33","subtotal":"466.65","grand_total":"498.74","paid_amount":"498.74","room_type_id":"320","product_id":"1322","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":"128130","customer_id":"128130","source_of_creation":"PMS","reservation_created_date":"2021-08-04 21:17:58","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":"AAA","sub_hotel_id":"0","group_rooms":"1267,1268","currentDayPrice":"466.65","currentDayDiscount":"23.33","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":"3305180","reservation_id":"121537","confirmation_number":"SJ12673157955","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"322.15,407.15,407.15","nightly_discount":"0.00,0.00,0.00","subtotal":"1136.45","grand_total":"1278.50","paid_amount":"1278.50","room_type_id":"320","product_id":"1324","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":"128808","customer_id":"128808","source_of_creation":"PMS","reservation_created_date":"2021-08-19 23:08:17","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1271,1272","currentDayPrice":"407.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":"3305539","reservation_id":"121516","confirmation_number":"SJ12691668368","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"305.15,305.15","nightly_discount":"15.26,15.26","subtotal":"610.30","grand_total":"652.25","paid_amount":"652.25","room_type_id":"413","product_id":"1262","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":"128997","customer_id":"128997","source_of_creation":"PMS","reservation_created_date":"2021-08-19 19:13:46","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","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":"305.15","currentDayDiscount":"15.26","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3527528","reservation_id":"121654","confirmation_number":"SJ12646697650","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.65","nightly_discount":"0.00","subtotal":"279.65","grand_total":"314.60","paid_amount":"314.60","room_type_id":"319","product_id":"1312","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":"129180","customer_id":"129180","source_of_creation":"PMS","reservation_created_date":"2021-08-21 17:30:25","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"279.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5178444","reservation_id":"121670","confirmation_number":"SJ12632704628","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"279.65","nightly_discount":"27.97","subtotal":"279.65","grand_total":"283.14","paid_amount":"283.14","room_type_id":"319","product_id":"1314","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":"129206","customer_id":"129206","source_of_creation":"PMS","reservation_created_date":"2021-08-21 21:38:33","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","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","currentDayPrice":"279.65","currentDayDiscount":"27.97","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[{"room_stay_id":"3443585","reservation_id":"116608","confirmation_number":"SJ12698046361","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-06-05 19:26:07","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","currentDayPrice":"87.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":"3443120","reservation_id":"113203","confirmation_number":"SJ12618451415","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"0.00","room_type_id":"412","product_id":"1294","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-17 16:55:59","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"87.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":"3442686","reservation_id":"116025","confirmation_number":"SJ12684052436","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"0.00","room_type_id":"411","product_id":"1296","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-27 22:07:22","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":"","sub_hotel_id":"0","currentDayPrice":"87.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":"3437229","reservation_id":"116034","confirmation_number":"SJ12673544332","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"0.00","room_type_id":"319","product_id":"1942","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-27 22:26:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"87.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":"3436237","reservation_id":"115356","confirmation_number":"SJ12610691787","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-16 23:19:12","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","currentDayPrice":"87.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":"3434996","reservation_id":"110723","confirmation_number":"SJ12645910859","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.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":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-19 15:58:17","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","currentDayPrice":"87.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"}]}],"negotiated_non_taxable":[{"room_stay_id":"3251038","reservation_id":"114466","confirmation_number":"SJ12687913738","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.28,102.28,102.28,102.28,102.28,102.28,102.32","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.00","room_type_id":"319","product_id":"1286","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-05-04 00:24:43","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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"102.28","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":"3251042","reservation_id":"114476","confirmation_number":"SJ12623629284","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.28,102.28,102.28,102.28,102.28,102.28,102.32","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.00","room_type_id":"319","product_id":"1287","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-05-04 01:34:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","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":"102.28","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":"3251044","reservation_id":"114477","confirmation_number":"SJ12668182506","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.28,102.28,102.28,102.28,102.28,102.28,102.32","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"716.00","grand_total":"716.00","paid_amount":"0.00","room_type_id":"319","product_id":"1288","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-05-04 01:37:16","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":"0","group_rooms":null,"currentDayPrice":"102.28","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":"3437663","reservation_id":"116282","confirmation_number":"SJ12622209707","room_stay_from":"2021-08-20","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"413","product_id":"1260","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-05-31 21:52:25","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"86.67","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":"3438996","reservation_id":"116769","confirmation_number":"SJ12628264167","room_stay_from":"2021-08-20","room_stay_to":"2021-08-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1277","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-06-08 00:18:36","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"86.67","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":"3443089","reservation_id":"110722","confirmation_number":"SJ12634040187","room_stay_from":"2021-08-17","room_stay_to":"2021-08-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"412","product_id":"1297","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-03-19 15:56:01","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","currentDayPrice":"87.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":"3443771","reservation_id":"112340","confirmation_number":"SJ12647773932","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"0.00","room_type_id":"413","product_id":"1264","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-04-07 15:42:53","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","currentDayPrice":"87.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":"3306036","reservation_id":"112039","confirmation_number":"SJ12614181084","room_stay_from":"2021-08-18","room_stay_to":"2021-08-21","room_stay_status":"Checked-Out","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.66","nightly_discount":"0.00,0.00,0.00","subtotal":"260.00","grand_total":"260.00","paid_amount":"84.38","room_type_id":"413","product_id":"1269","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-04-03 23:37:08","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":"0","changedComment":"Nightly price or discount changed","deltaChange":"-0.01","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"}]},{"room_stay_id":"3311383","reservation_id":"80993","confirmation_number":"SJ12688175805","room_stay_from":"2019-12-19","room_stay_to":"2019-12-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"245.00","grand_total":"245.00","paid_amount":"245.00","room_type_id":"413","product_id":"1266","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":"2019-07-19 03:31:38","canceled_nights_data":"","product_name":"Deluxe 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":null,"sub_hotel_id":"0","changedComment":"Nightly price or discount changed","deltaChange":"245.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"}]},{"room_stay_id":"3314003","reservation_id":"85031","confirmation_number":"SJ12690775851","room_stay_from":"2019-11-01","room_stay_to":"2019-11-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"595.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"595.00","grand_total":"595.00","paid_amount":"669.38","room_type_id":"319","product_id":"1311","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":"106975","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-10-03 04:36:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","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","taxExmptApplied":-74.38,"changedComment":"Nightly price or discount changed","deltaChange":"0.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"}]},{"room_stay_id":"3322726","reservation_id":"85390","confirmation_number":"SJ12636797823","room_stay_from":"2019-12-19","room_stay_to":"2019-12-22","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"315.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"315.00","grand_total":"315.00","paid_amount":"315.00","room_type_id":"319","product_id":"1306","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":"2019-10-10 04:26:24","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":"0","taxExmptApplied":-30.63,"changedComment":"Nightly price or discount changed","deltaChange":"70.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"}]},{"room_stay_id":"4047959","reservation_id":"112812","confirmation_number":"SJ12656847200","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67,86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00,0,0,0","subtotal":"520.02","grand_total":"520.02","paid_amount":"0.00","room_type_id":"413","product_id":"1266","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-04-12 22:05:51","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":"0","changedComment":"To date changed","deltaChange":"0.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"}]},{"room_stay_id":"3307873","reservation_id":"85749","confirmation_number":"SJ12692288238","room_stay_from":"2019-11-09","room_stay_to":"2019-11-12","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"245.00","grand_total":"245.00","paid_amount":"245.00","room_type_id":"319","product_id":"1301","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":"2019-10-16 20:51:14","service_canceled_date_time":"2021-08-21 16:40:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"tax_exempted_indicator_1","total_paid_amount":"245.00","sub_hotel_id":"0","deltaChange":"245.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3308761","reservation_id":"75272","confirmation_number":"SJ12648895412","room_stay_from":"2019-11-03","room_stay_to":"2019-11-05","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,0.00","nightly_discount":"0.00,0.00","subtotal":"255.00","grand_total":"255.00","paid_amount":"255.00","room_type_id":"413","product_id":"1273","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":"2019-04-25 01:11:11","service_canceled_date_time":"2021-08-21 16:44:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"tax_exempted_indicator_1","total_paid_amount":"255.00","sub_hotel_id":"0","deltaChange":"255.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3334940","reservation_id":"85392","confirmation_number":"SJ12620876407","room_stay_from":"2019-12-10","room_stay_to":"2019-12-13","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"245.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"245.00","grand_total":"245.00","paid_amount":"245.00","room_type_id":"319","product_id":"1306","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":"2019-10-10 04:45:06","service_canceled_date_time":"2021-08-21 17:01:43","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"tax_exempted_indicator_1","total_paid_amount":"490.00","sub_hotel_id":"0","deltaChange":"490.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3415887","reservation_id":"85739","confirmation_number":"SJ12668471508","room_stay_from":"2019-12-06","room_stay_to":"2019-12-20","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"575.00,0.00,0.00,0.00,0.00,0.00,0.00,575.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,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1150.00","grand_total":"1293.75","paid_amount":"1150.00","room_type_id":"319","product_id":"1305","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-10-16 20:01:44","service_canceled_date_time":"2021-08-21 17:28:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"","total_paid_amount":"1150.00","sub_hotel_id":"0","deltaChange":"1150.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3498743","reservation_id":"85386","confirmation_number":"SJ12633364557","room_stay_from":"2019-12-13","room_stay_to":"2019-12-16","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"315.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"315.00","grand_total":"354.38","paid_amount":"315.00","room_type_id":"319","product_id":"1303","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-10-10 04:07:27","service_canceled_date_time":"2021-08-21 17:29:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"Room-Night-0-prices","total_paid_amount":"315.00","sub_hotel_id":"0","deltaChange":"315.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3525728","reservation_id":"80668","confirmation_number":"SJ12625686731","room_stay_from":"2019-12-17","room_stay_to":"2019-12-20","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.66,81.66,81.68","nightly_discount":"0.00,0.00,0.00","subtotal":"245.00","grand_total":"275.63","paid_amount":"245.00","room_type_id":"413","product_id":"1261","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2019-07-13 19:10:10","service_canceled_date_time":"2021-08-21 17:49:56","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"","total_paid_amount":"245.00","sub_hotel_id":"0","deltaChange":"245.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3896873","reservation_id":"95532","confirmation_number":"SJ12633661106","room_stay_from":"2021-03-21","room_stay_to":"2021-03-26","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"340.71,113.57,113.57,113.57,113.58","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"795.00","grand_total":"795.00","paid_amount":"795.00","room_type_id":"318","product_id":"1289","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-05-28 13:54:56","service_canceled_date_time":"2021-08-21 18:22:59","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"","total_paid_amount":"795.00","sub_hotel_id":"0","deltaChange":-88.34,"changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3273141","reservation_id":"118012","confirmation_number":"SJ12655932889","room_confirmation_number":"SJ12643087510","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"100,100","nightly_discount":"0.00,0.00","subtotal":"200.00","grand_total":"201.20","paid_amount":"201.20","product_id":"1777","service_quantity":"1","customer_traveller_id":"125002","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-06-24 22:50:08","reservation_modified_date_time":"2021-06-24 22:50:08","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125002","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.00","sub_hotel_id":"126","currentDayPrice":"100","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"0.60","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3295917","reservation_id":"118654","confirmation_number":"SJ12682244626","room_confirmation_number":"SJ12613221044","room_stay_from":"2021-08-19","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"125732","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-08-03 20:43:13","reservation_modified_date_time":"2021-08-03 20:43:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125732","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"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":"3304765","reservation_id":"119784","confirmation_number":"SJ12699346564","room_confirmation_number":"SJ12672238412","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"25.15","paid_amount":"25.15","product_id":"1777","service_quantity":"1","customer_traveller_id":"126973","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-08-19 16:12:12","reservation_modified_date_time":"2021-08-19 16:12:12","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126973","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25","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":"3304990","reservation_id":"121523","confirmation_number":"SJ12625154378","room_confirmation_number":"SJ12627710445","room_stay_from":"2021-08-21","room_stay_to":"2021-08-23","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"129007","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-08-19 20:34:13","reservation_modified_date_time":"2021-08-19 20:34:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129007","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"50","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":"3305157","reservation_id":"121533","confirmation_number":"SJ12637759454","room_confirmation_number":"SJ12615432002","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"25.15","paid_amount":"25.15","product_id":"1777","service_quantity":"1","customer_traveller_id":"129020","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-08-19 22:41:07","reservation_modified_date_time":"2021-08-19 22:41:07","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129020","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"0.60","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3305171","reservation_id":"121472","confirmation_number":"SJ12640081403","room_confirmation_number":"SJ12625989993","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"128955","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-08-19 23:00:57","reservation_modified_date_time":"2021-08-19 23:00:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128955","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"50","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":"3305462","reservation_id":"120105","confirmation_number":"SJ12614630052","room_confirmation_number":"SJ12652611482","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"127355","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-08-20 18:09:47","reservation_modified_date_time":"2021-08-20 18:09:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127355","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3238916","reservation_id":"111215","confirmation_number":"SJ12637118153","room_confirmation_number":"SJ12624482451","room_stay_from":"2021-08-18","room_stay_to":"2021-08-23","room_stay_status":"Active","nightly_price":"25,25,25,25,25","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":"117746","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 23:08:12","reservation_modified_date_time":"2021-04-21 17:30:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117746","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":"3238918","reservation_id":"111215","confirmation_number":"SJ12615909474","room_confirmation_number":"SJ12685471986","room_stay_from":"2021-08-18","room_stay_to":"2021-08-23","room_stay_status":"Active","nightly_price":"25,25,25,25,25","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":"117746","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-24 23:08:17","reservation_modified_date_time":"2021-04-21 17:30:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117746","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":"3251037","reservation_id":"114466","confirmation_number":"SJ12686060898","room_confirmation_number":"SJ12687913738","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","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":"121160","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 00:24:43","reservation_modified_date_time":"2021-05-12 22:47:13","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":"3251041","reservation_id":"114476","confirmation_number":"SJ12617705605","room_confirmation_number":"SJ12623629284","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","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":"121172","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 01:34:06","reservation_modified_date_time":"2021-05-12 22:47:13","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":"3251043","reservation_id":"114477","confirmation_number":"SJ12616665124","room_confirmation_number":"SJ12668182506","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","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":"121173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-04 01:37:16","reservation_modified_date_time":"2021-05-12 22:47:13","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":"3272514","reservation_id":"117719","confirmation_number":"SJ12640627413","room_confirmation_number":"SJ12631500137","room_stay_from":"2021-08-20","room_stay_to":"2021-08-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":"124695","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-20 21:37:07","reservation_modified_date_time":"2021-06-23 22:43:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124695","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":"3283830","reservation_id":"117634","confirmation_number":"SJ12688788733","room_confirmation_number":"SJ12673504589","room_stay_from":"2021-08-18","room_stay_to":"2021-08-23","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,10.00","subtotal":"125.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"74162","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-19 17:49:30","reservation_modified_date_time":"2021-07-14 13:52:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74162","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"10.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":"3283841","reservation_id":"116405","confirmation_number":"SJ12680106019","room_confirmation_number":"SJ12670869899","room_stay_from":"2021-08-21","room_stay_to":"2021-08-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":"123273","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-02 21:06:46","reservation_modified_date_time":"2021-07-14 13:55:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123273","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":"3286801","reservation_id":"119523","confirmation_number":"SJ12670348455","room_confirmation_number":"SJ12617496589","room_stay_from":"2021-08-20","room_stay_to":"2021-08-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":"126684","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-17 18:36:04","reservation_modified_date_time":"2021-07-19 21:32:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126684","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":"3290720","reservation_id":"120151","confirmation_number":"SJ12679995090","room_confirmation_number":"SJ12654695827","room_stay_from":"2021-08-20","room_stay_to":"2021-08-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":"127408","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-26 22:06:07","reservation_modified_date_time":"2021-07-26 22:06:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127408","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":"3293903","reservation_id":"120488","confirmation_number":"SJ12648395364","room_confirmation_number":"SJ12678815947","room_stay_from":"2021-08-20","room_stay_to":"2021-08-27","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":"127802","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-31 20:58:37","reservation_modified_date_time":"2021-07-31 22:30:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127802","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":"3295918","reservation_id":"118654","confirmation_number":"SJ12694022882","room_confirmation_number":"SJ12613221044","room_stay_from":"2021-08-19","room_stay_to":"2021-08-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":"125732","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-04 14:28:22","reservation_modified_date_time":"2021-08-03 20:43:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125732","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":"3303477","reservation_id":"121282","confirmation_number":"SJ12659374914","room_confirmation_number":"SJ12634904040","room_stay_from":"2021-08-21","room_stay_to":"2021-08-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":"128753","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-16 16:10:18","reservation_modified_date_time":"2021-08-16 16:10:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128753","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":"3304367","reservation_id":"121439","confirmation_number":"SJ12698679274","room_confirmation_number":"SJ12611860526","room_stay_from":"2021-08-20","room_stay_to":"2021-08-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":"128916","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-18 23:49:12","reservation_modified_date_time":"2021-08-18 23:49:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128916","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":"3304544","reservation_id":"121421","confirmation_number":"SJ12646688544","room_confirmation_number":"SJ12681712746","room_stay_from":"2021-08-19","room_stay_to":"2021-08-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":"128893","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-18 20:43:26","reservation_modified_date_time":"2021-08-19 11:47:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128893","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":"3304550","reservation_id":"121418","confirmation_number":"SJ12688869451","room_confirmation_number":"SJ12660975173","room_stay_from":"2021-08-20","room_stay_to":"2021-08-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":"128891","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-18 19:59:19","reservation_modified_date_time":"2021-08-19 11:50:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128891","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":"3304627","reservation_id":"116886","confirmation_number":"SJ12644919479","room_confirmation_number":"SJ12640066234","room_stay_from":"2021-08-19","room_stay_to":"2021-08-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":"115615","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-09 17:57:39","reservation_modified_date_time":"2021-08-19 14:03:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115615","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":"3304973","reservation_id":"113356","confirmation_number":"SJ12636004971","room_confirmation_number":"SJ12634933985","room_stay_from":"2021-08-19","room_stay_to":"2021-08-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":"119948","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-19 11:23:11","reservation_modified_date_time":"2021-08-19 20:05:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119948","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":"3304991","reservation_id":"121523","confirmation_number":"SJ12640158633","room_confirmation_number":"SJ12627710445","room_stay_from":"2021-08-21","room_stay_to":"2021-08-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":"129007","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-19 20:34:13","reservation_modified_date_time":"2021-08-19 20:34:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129007","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":"3305169","reservation_id":"121506","confirmation_number":"SJ12612010379","room_confirmation_number":"SJ12663862019","room_stay_from":"2021-08-20","room_stay_to":"2021-08-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":"128987","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-19 17:46:11","reservation_modified_date_time":"2021-08-19 22:58:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128987","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":"3305172","reservation_id":"121472","confirmation_number":"SJ12655563220","room_confirmation_number":"SJ12625989993","room_stay_from":"2021-08-20","room_stay_to":"2021-08-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":"128955","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-19 14:03:10","reservation_modified_date_time":"2021-08-19 23:00:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128955","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":"3305176","reservation_id":"120752","confirmation_number":"SJ12692608695","room_confirmation_number":"SJ12639396320","room_stay_from":"2021-08-21","room_stay_to":"2021-08-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":"128130","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-04 21:17:58","reservation_modified_date_time":"2021-08-19 23:01:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128130","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":"3305351","reservation_id":"121204","confirmation_number":"SJ12646847638","room_confirmation_number":"SJ12636106363","room_stay_from":"2021-08-20","room_stay_to":"2021-08-24","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":"128672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-14 23:40:16","reservation_modified_date_time":"2021-08-20 14:10:30","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128672","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":"3305371","reservation_id":"118012","confirmation_number":"SJ12653815004","room_confirmation_number":"SJ12643087510","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"125002","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-24 22:50:08","reservation_modified_date_time":"2021-08-20 14:11:15","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125002","canceled_nights_data":"","posAmt_airbnb_taxpaid":"200.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":"3305396","reservation_id":"121566","confirmation_number":"SJ12696620652","room_confirmation_number":"SJ12654420184","room_stay_from":"2021-08-21","room_stay_to":"2021-08-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":"129055","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 15:31:51","reservation_modified_date_time":"2021-08-20 15:34:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129055","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":"3305438","reservation_id":"121576","confirmation_number":"SJ12641925919","room_confirmation_number":"SJ12625817643","room_stay_from":"2021-08-20","room_stay_to":"2021-08-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":"129066","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 17:33:11","reservation_modified_date_time":"2021-08-20 17:33:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129066","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":"3305463","reservation_id":"120105","confirmation_number":"SJ12681363728","room_confirmation_number":"SJ12652611482","room_stay_from":"2021-08-20","room_stay_to":"2021-08-22","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":"127355","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-26 14:40:10","reservation_modified_date_time":"2021-08-20 18:09:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127355","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":"3305473","reservation_id":"112593","confirmation_number":"SJ12694614355","room_confirmation_number":"SJ12665719773","room_stay_from":"2021-08-20","room_stay_to":"2021-08-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":"119173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-10 14:34:14","reservation_modified_date_time":"2021-08-20 18:22:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119173","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":"3305540","reservation_id":"121516","confirmation_number":"SJ12690337014","room_confirmation_number":"SJ12691668368","room_stay_from":"2021-08-20","room_stay_to":"2021-08-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":"128997","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-19 19:13:46","reservation_modified_date_time":"2021-08-20 19:50:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128997","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":"3305833","reservation_id":"121613","confirmation_number":"SJ12658838639","room_confirmation_number":"SJ12640639749","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","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":"129114","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 22:28:37","reservation_modified_date_time":"2021-08-21 01:22:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129114","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":"3305851","reservation_id":"121614","confirmation_number":"SJ12668718502","room_confirmation_number":"SJ12667172152","room_stay_from":"2021-08-21","room_stay_to":"2021-08-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":"129115","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-20 22:44:21","reservation_modified_date_time":"2021-08-21 01:30:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129115","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":"3305974","reservation_id":"119784","confirmation_number":"SJ12674589848","room_confirmation_number":"SJ12672238412","room_stay_from":"2021-08-21","room_stay_to":"2021-08-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":"126973","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-21 14:07:08","reservation_modified_date_time":"2021-08-21 14:22:59","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126973","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.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","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":"3306000","reservation_id":"121175","confirmation_number":"SJ12677374442","room_confirmation_number":"SJ12663819545","room_stay_from":"2021-08-21","room_stay_to":"2021-08-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":"128636","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-14 15:52:08","reservation_modified_date_time":"2021-08-21 14:29:14","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128636","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","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":"3306025","reservation_id":"121533","confirmation_number":"SJ12631175657","room_confirmation_number":"SJ12615432002","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"129020","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-19 22:41:07","reservation_modified_date_time":"2021-08-21 14:43:22","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129020","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25","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":"3306108","reservation_id":"121650","confirmation_number":"SJ12660042481","room_confirmation_number":"SJ12630700219","room_stay_from":"2021-08-21","room_stay_to":"2021-08-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":"129173","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-21 16:31:10","reservation_modified_date_time":"2021-08-21 16:31:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129173","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":"3436236","reservation_id":"115356","confirmation_number":"SJ12636431603","room_confirmation_number":"SJ12610691787","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","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":"122082","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-16 23:19:12","reservation_modified_date_time":"2021-08-21 17:17:50","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":"3437228","reservation_id":"116034","confirmation_number":"SJ12684069053","room_confirmation_number":"SJ12673544332","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","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":"122844","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-27 22:26:38","reservation_modified_date_time":"2021-08-21 17:17:58","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":"3437662","reservation_id":"116282","confirmation_number":"SJ12657282565","room_confirmation_number":"SJ12622209707","room_stay_from":"2021-08-20","room_stay_to":"2021-08-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":"123143","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-31 21:52:25","reservation_modified_date_time":"2021-08-21 17:18:02","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":"3438995","reservation_id":"116769","confirmation_number":"SJ12695341156","room_confirmation_number":"SJ12628264167","room_stay_from":"2021-08-20","room_stay_to":"2021-08-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":"123677","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-08 00:18:36","reservation_modified_date_time":"2021-08-21 17:18:15","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":"3442685","reservation_id":"116025","confirmation_number":"SJ12632554861","room_confirmation_number":"SJ12684052436","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","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":"122839","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-27 22:07:22","reservation_modified_date_time":"2021-08-21 17:18:44","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":"3443088","reservation_id":"110722","confirmation_number":"SJ12668281685","room_confirmation_number":"SJ12634040187","room_stay_from":"2021-08-17","room_stay_to":"2021-08-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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"117233","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 15:56:01","reservation_modified_date_time":"2021-08-21 17:18:47","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":"3443119","reservation_id":"113203","confirmation_number":"SJ12646508609","room_confirmation_number":"SJ12618451415","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","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":"119793","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-17 16:55:59","reservation_modified_date_time":"2021-08-21 17:18:47","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":"3443584","reservation_id":"116608","confirmation_number":"SJ12641874173","room_confirmation_number":"SJ12698046361","room_stay_from":"2021-08-20","room_stay_to":"2021-08-25","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":"123498","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-05 19:26:07","reservation_modified_date_time":"2021-08-21 17:18:51","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":"3443770","reservation_id":"112340","confirmation_number":"SJ12661664478","room_confirmation_number":"SJ12647773932","room_stay_from":"2021-08-21","room_stay_to":"2021-08-28","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":"118909","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 15:42:53","reservation_modified_date_time":"2021-08-21 17:18:52","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":"3527530","reservation_id":"121654","confirmation_number":"SJ12695985408","room_confirmation_number":"SJ12646697650","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"129180","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-21 17:30:25","reservation_modified_date_time":"2021-08-21 17:30:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129180","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":"5178445","reservation_id":"121670","confirmation_number":"SJ12669532792","room_confirmation_number":"SJ12632704628","room_stay_from":"2021-08-21","room_stay_to":"2021-08-22","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"129206","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-21 21:38:33","reservation_modified_date_time":"2021-08-21 21:51:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129206","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":"5178459","reservation_id":"121675","confirmation_number":"SJ12643120005","room_confirmation_number":"SJ12664104120","room_stay_from":"2021-08-21","room_stay_to":"2021-08-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":"129211","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-08-21 23:09:11","reservation_modified_date_time":"2021-08-21 23:09:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129211","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":"3310509","reservation_id":"80993","confirmation_number":"SJ12633363989","room_confirmation_number":"SJ12688175805","room_stay_from":"2019-12-19","room_stay_to":"2019-12-22","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":"89112","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-19 03:31:38","reservation_modified_date_time":"2021-08-21 16:45:48","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","changedComment":"Nightly price or discount changed","deltaChange":"-75.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":"3322725","reservation_id":"85390","confirmation_number":"SJ12671639939","room_confirmation_number":"SJ12636797823","room_stay_from":"2019-12-19","room_stay_to":"2019-12-22","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":"92537","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-10 04:26:24","reservation_modified_date_time":"2021-08-21 16:52:11","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","changedComment":"Nightly price or discount changed","deltaChange":"-75.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":"4047973","reservation_id":"112812","confirmation_number":"SJ12662187630","room_confirmation_number":"SJ12656847200","room_stay_from":"2021-08-22","room_stay_to":"2021-08-28","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":"119400","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-12 22:05:51","reservation_modified_date_time":"2021-08-21 18:43:51","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3434966","reservation_id":"110723","confirmation_number":"SJ12676370179","room_confirmation_number":"SJ12645910859","room_stay_from":"2021-08-21","room_stay_to":"2021-08-26","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":"117234","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-19 15:58:17","reservation_modified_date_time":"2021-08-21 17:17:41","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":true,"taxes":[]}],"gift_shop_taxable":[{"room_stay_id":"4182210","reservation_id":"121658","confirmation_number":"SJ12631358496","room_confirmation_number":"SJ12635478549","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":"4.00","paid_amount":"4.00","product_id":"1660","service_quantity":"2","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-21 19:02:32","reservation_modified_date_time":"2021-08-21 19:02:32","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":"3.72","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":[]}}