{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-07-31","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":34,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1260,1261,1304,1305,1262,1263,1311,1312,1307,1308,1269,1270,1291,1711,1302,1303,1309,1310,1271,1272,1267,1268","bundle_block_bookings":[{"confirmation_number":"SJB12671654435","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12689965182","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJB12671871763","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","bundle_room":"0","product_id":"1305"},{"confirmation_number":"SJB12615364836","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","bundle_room":"0","product_id":"1262"},{"confirmation_number":"SJB12612506476","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","bundle_room":"0","product_id":"1263"},{"confirmation_number":"SJB12617055795","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","bundle_room":"0","product_id":"1311"},{"confirmation_number":"SJB12671986452","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","bundle_room":"0","product_id":"1312"},{"confirmation_number":"SJB12627012604","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12636817890","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12694998639","room_stay_from":"2021-07-31","room_stay_to":"2021-08-03","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12648791343","room_stay_from":"2021-07-31","room_stay_to":"2021-08-03","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12651050298","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12641003295","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12638067567","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12675985234","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12661971007","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","bundle_room":"0","product_id":"1309"},{"confirmation_number":"SJB12670354302","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","bundle_room":"0","product_id":"1310"},{"confirmation_number":"SJB12670565004","room_stay_from":"2021-07-31","room_stay_to":"2021-08-05","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12648833257","room_stay_from":"2021-07-31","room_stay_to":"2021-08-07","bundle_room":"1","product_id":"1322"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3247425","reservation_id":"114629","confirmation_number":"SJ12628736478","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"228.74","nightly_discount":"0","subtotal":"228.74","grand_total":"257.34","paid_amount":"257.34","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-2678936707","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":"121320","customer_id":"121320","source_of_creation":"Booking.com","reservation_created_date":"2021-05-06 01:26:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"45.67","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"228.74","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":"3256610","reservation_id":"113012","confirmation_number":"SJ12687215285","room_stay_from":"2021-07-29","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.32,269.32,222.07","nightly_discount":"0,0,0","subtotal":"760.71","grand_total":"855.80","paid_amount":"855.80","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-3955474524","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":"119597","customer_id":"119597","source_of_creation":"Booking.com","reservation_created_date":"2021-04-15 00:42:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"319.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"222.07","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":"3284773","reservation_id":"113012","confirmation_number":"SJ12649460146","room_stay_from":"2021-07-29","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"303.07,303.07,255.82","nightly_discount":"0,0,0","subtotal":"861.96","grand_total":"969.71","paid_amount":"969.71","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3955474524","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":"119597","customer_id":"119597","source_of_creation":"Booking.com","reservation_created_date":"2021-04-15 00:42:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"319.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"255.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":"3287380","reservation_id":"119775","confirmation_number":"SJ12623100772","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"319.20,295.20","nightly_discount":"0,0","subtotal":"614.40","grand_total":"691.20","paid_amount":"691.20","room_type_id":"412","product_id":"1866","siteminder_id":"BDC-2135860456","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":"126968","customer_id":"126968","source_of_creation":"Booking.com","reservation_created_date":"2021-07-21 10:20:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","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":"295.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":"3289470","reservation_id":"119517","confirmation_number":"SJ12676650731","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"308.88,287.28","nightly_discount":"0,0","subtotal":"596.16","grand_total":"670.68","paid_amount":"670.68","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-2378269070","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":"126672","customer_id":"126672","source_of_creation":"Booking.com","reservation_created_date":"2021-07-17 17:02:34","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":"287.28","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":"3289496","reservation_id":"114858","confirmation_number":"SJ12618298742","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"343.49","nightly_discount":"0","subtotal":"343.49","grand_total":"386.42","paid_amount":"386.42","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-2337433217","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":"121600","customer_id":"121600","source_of_creation":"Booking.com","reservation_created_date":"2021-05-09 22:55:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"66.33","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"343.49","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":"3290836","reservation_id":"120169","confirmation_number":"SJ12694902390","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"312.58","nightly_discount":"0","subtotal":"312.58","grand_total":"351.65","paid_amount":"351.65","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-3468463783","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":"127427","customer_id":"127427","source_of_creation":"Booking.com","reservation_created_date":"2021-07-27 01:13:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"60.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"312.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3290862","reservation_id":"120172","confirmation_number":"SJ12685259226","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"312.58","nightly_discount":"0","subtotal":"312.58","grand_total":"351.65","paid_amount":"351.65","room_type_id":"318","product_id":"1289","siteminder_id":"BDC-3468420785","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":"127432","customer_id":"127432","source_of_creation":"Booking.com","reservation_created_date":"2021-07-27 02:10:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"60.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"312.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3293801","reservation_id":"120496","confirmation_number":"SJ12669787594","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"364.65","nightly_discount":"0","subtotal":"364.65","grand_total":"410.23","paid_amount":"410.23","room_type_id":"319","product_id":"1756","siteminder_id":"BDC-2445934249","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":"127809","customer_id":"127809","source_of_creation":"Booking.com","reservation_created_date":"2021-07-31 22:11:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"70.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"364.65","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":"3275129","reservation_id":"118304","confirmation_number":"SJ12688926015","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.11,148.39","nightly_discount":"0,0","subtotal":"387.50","grand_total":"435.94","paid_amount":"435.94","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-2807106532","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":"125320","customer_id":"125320","source_of_creation":"Booking.com","reservation_created_date":"2021-06-29 03:59:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"78.75","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"239.11","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":"3292161","reservation_id":"120342","confirmation_number":"SJ12654109005","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"439.20,359.20","nightly_discount":"0,0","subtotal":"798.40","grand_total":"898.20","paid_amount":"898.20","room_type_id":"320","product_id":"1330","siteminder_id":"BDC-2277531318","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":"127612","customer_id":"127612","source_of_creation":"Booking.com","reservation_created_date":"2021-07-29 15:54:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"152.71","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"439.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":"3292775","reservation_id":"120416","confirmation_number":"SJ12671107416","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"229.2,309.2","nightly_discount":"0,0","subtotal":"538.40","grand_total":"605.70","paid_amount":"605.70","room_type_id":"319","product_id":"1942","siteminder_id":"BDC-2243887266","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":"127694","customer_id":"127694","source_of_creation":"Booking.com","reservation_created_date":"2021-07-30 16:30:21","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"229.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":"3289178","reservation_id":"115490","confirmation_number":"SJ12666045629","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"3","nightly_price":"359.3,310.3,289.3,289.3","nightly_discount":"0,0,0,0","subtotal":"1248.20","grand_total":"1404.23","paid_amount":"1404.23","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-3766328880","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":"122229","customer_id":"122229","source_of_creation":"Booking.com","reservation_created_date":"2021-05-19 02:46:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"395.36","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"359.3","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3289225","reservation_id":"115490","confirmation_number":"SJ12653512423","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"209.30,160.30,139.30,139.30","nightly_discount":"0,0,0,0","subtotal":"648.20","grand_total":"729.23","paid_amount":"729.23","room_type_id":"319","product_id":"1306","siteminder_id":"BDC-3766328880","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":"122229","customer_id":"122229","source_of_creation":"Booking.com","reservation_created_date":"2021-05-19 02:46:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"395.36","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"209.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3293684","reservation_id":"119858","confirmation_number":"SJ12683652050","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"300.30,230.30,230.30,230.30","nightly_discount":"0,0,0,0","subtotal":"991.20","grand_total":"1115.10","paid_amount":"1115.10","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3457108247","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":"127060","customer_id":"127060","source_of_creation":"Booking.com","reservation_created_date":"2021-07-22 20:01:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"196.42","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","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":"3293929","reservation_id":"120375","confirmation_number":"SJ12614706434","room_stay_from":"2021-09-30","room_stay_to":"2021-10-03","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.75,246.75,246.75","nightly_discount":"0,0,0","subtotal":"680.25","grand_total":"765.28","paid_amount":"210.10","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-2180818002","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":"127654","customer_id":"127654","source_of_creation":"Booking.com","reservation_created_date":"2021-07-30 00:34:17","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":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3276359","reservation_id":"118464","confirmation_number":"SJ12654034368","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"352.92","nightly_discount":"0","subtotal":"352.92","grand_total":"397.04","paid_amount":"397.04","room_type_id":"320","product_id":"1321","siteminder_id":"EXP-1794157164","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":"125495","customer_id":"125495","source_of_creation":"Expedia","reservation_created_date":"2021-07-01 15:51:07","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","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":"1262,1263","currentDayPrice":"352.92","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":"3284152","reservation_id":"111788","confirmation_number":"SJ12670799383","room_stay_from":"2021-07-29","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.40,191.40,179.40","nightly_discount":"0,0,0","subtotal":"586.20","grand_total":"659.48","paid_amount":"659.48","room_type_id":"319","product_id":"1277","siteminder_id":"EXP-1754403970","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":"118345","customer_id":"118345","source_of_creation":"Expedia","reservation_created_date":"2021-03-31 22:12:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"117.24","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"179.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3269889","reservation_id":"117412","confirmation_number":"SJ12661930195","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"271.32,250.92,155.72","nightly_discount":"0,0,0","subtotal":"677.96","grand_total":"762.71","paid_amount":"762.71","room_type_id":"319","product_id":"1301","siteminder_id":"EXP-1786397963","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":"124375","customer_id":"124375","source_of_creation":"Expedia","reservation_created_date":"2021-06-16 16:01:23","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":"250.92","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":"3280830","reservation_id":"118961","confirmation_number":"SJ12640296618","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"353.2,234.4,150.4","nightly_discount":"0,0,0","subtotal":"738.00","grand_total":"830.25","paid_amount":"830.25","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1797951133","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126063","customer_id":"126063","source_of_creation":"Expedia","reservation_created_date":"2021-07-09 00:15:10","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"234.4","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":"3293561","reservation_id":"119525","confirmation_number":"SJ12662463650","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"287.36,197.76","nightly_discount":"0.00,0.00","subtotal":"485.12","grand_total":"545.76","paid_amount":"545.76","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1802536131","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":"126686","customer_id":"126686","source_of_creation":"Expedia","reservation_created_date":"2021-07-17 18:45:06","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":"126","currentDayPrice":"287.36","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":"3280986","reservation_id":"118785","confirmation_number":"SJ12695908407","room_stay_from":"2021-07-31","room_stay_to":"2021-08-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"336.75,231.75,231.75","nightly_discount":"0,0,0","subtotal":"800.25","grand_total":"900.28","paid_amount":"900.28","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1796533011","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":"125872","customer_id":"125872","source_of_creation":"Expedia","reservation_created_date":"2021-07-06 14:11:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","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":"336.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":"3287808","reservation_id":"111609","confirmation_number":"SJ12646164237","room_stay_from":"2021-07-30","room_stay_to":"2021-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"173.40,161.40,113.40,107.40,107.40","nightly_discount":"0,0,0,0,0","subtotal":"663.00","grand_total":"745.88","paid_amount":"745.88","room_type_id":"319","product_id":"1276","siteminder_id":"EXP-1753528361","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":"118169","customer_id":"118169","source_of_creation":"Expedia","reservation_created_date":"2021-03-29 18:57:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"132.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"161.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3269810","reservation_id":"115977","confirmation_number":"SJ12647429060","room_stay_from":"2021-07-31","room_stay_to":"2021-08-06","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"265.30,195.30,195.30,195.30,195.30,265.30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1311.80","grand_total":"1475.78","paid_amount":"298.47","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1776608794","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":"122783","customer_id":"122783","source_of_creation":"Expedia","reservation_created_date":"2021-05-27 10:45:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"265.30","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":"3293817","reservation_id":"120323","confirmation_number":"SJ12656044173","room_stay_from":"2021-08-09","room_stay_to":"2021-08-13","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.24,184.24,184.24,173.04","nightly_discount":"0,0,0,0","subtotal":"725.76","grand_total":"816.48","paid_amount":"0.00","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1808423339","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":"127592","customer_id":"127592","source_of_creation":"Expedia","reservation_created_date":"2021-07-29 03:46:37","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":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[{"room_stay_id":"3289481","reservation_id":"119499","confirmation_number":"SJ12664991737","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"319.20,207.20","nightly_discount":"0,0","subtotal":"526.40","grand_total":"592.20","paid_amount":"359.10","room_type_id":"319","product_id":"1756","siteminder_id":"EXP-1802446283","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":"126654","customer_id":"126654","source_of_creation":"Expedia","reservation_created_date":"2021-07-17 15:15:35","service_canceled_date_time":"2021-07-31 19:40:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"126","deltaChange":"359.10","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[{"room_stay_id":"3291864","reservation_id":"120308","confirmation_number":"SJ12634379593","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"226.08","nightly_discount":"0","subtotal":"226.08","grand_total":"254.34","paid_amount":"254.34","room_type_id":"411","product_id":"1296","siteminder_id":"HTN-168899390-VEZC7E","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":"127579","customer_id":"127579","source_of_creation":"HotelTonight","reservation_created_date":"2021-07-28 23:24:12","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"226.08","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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3289499","reservation_id":"114458","confirmation_number":"SJ12669308548","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"227.30,184.18","nightly_discount":"0,0","subtotal":"411.48","grand_total":"462.91","paid_amount":"462.91","room_type_id":"319","product_id":"1915","siteminder_id":"GAM-R2492626685","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":"121149","customer_id":"121149","source_of_creation":"Getaroom.com","reservation_created_date":"2021-05-03 22:49:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"184.18","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":"3290299","reservation_id":"119275","confirmation_number":"SJ12667279365","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"264.26,245.78,159.54","nightly_discount":"0,0,0","subtotal":"669.58","grand_total":"753.28","paid_amount":"753.28","room_type_id":"318","product_id":"1282","siteminder_id":"GAM-R2658326684","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":"126406","customer_id":"126406","source_of_creation":"Getaroom.com","reservation_created_date":"2021-07-13 21:58:21","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":"245.78","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":"3269788","reservation_id":"114994","confirmation_number":"SJ12669342987","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"242.01,204.28,188.11,188.11","nightly_discount":"0,0,0,0","subtotal":"822.51","grand_total":"925.33","paid_amount":"925.33","room_type_id":"320","product_id":"1714","siteminder_id":"GAM-R2509999553","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":"121706","customer_id":"121706","source_of_creation":"Getaroom.com","reservation_created_date":"2021-05-11 15:39:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1291,1711","currentDayPrice":"242.01","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":"3208547","reservation_id":"109261","confirmation_number":"SJ12659436067","room_stay_from":"2021-07-31","room_stay_to":"2021-08-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.77,101.87,96.48,96.48,96.48,96.48,128.82","nightly_discount":"0,0,0,0,0,0,0","subtotal":"772.38","grand_total":"868.93","paid_amount":"868.93","room_type_id":"413","product_id":"1267","siteminder_id":"GAM-R2360416694","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":"115733","customer_id":"115733","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-04 01:01:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","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":"155.77","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":"3269868","reservation_id":"116081","confirmation_number":"SJ12667037583","room_stay_from":"2021-07-31","room_stay_to":"2021-08-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.33,123.43,123.43,123.43,123.43,177.33,215.06","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1063.44","grand_total":"1196.37","paid_amount":"1196.37","room_type_id":"319","product_id":"1913","siteminder_id":"GAM-R2551501010","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":"122895","customer_id":"122895","source_of_creation":"Getaroom.com","reservation_created_date":"2021-05-28 17:06:31","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"177.33","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3293139","reservation_id":"115895","confirmation_number":"SJ12611919487","room_stay_from":"2021-07-31","room_stay_to":"2021-08-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"260.18,350.88,350.88","nightly_discount":"0.00,0.00,0.00","subtotal":"961.94","grand_total":"1128.17","paid_amount":"1128.17","room_type_id":"320","product_id":"1323","siteminder_id":"ABB-HMHEKKPDT3","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1052.64","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122684","customer_id":"122684","source_of_creation":"Airbnb","reservation_created_date":"2021-05-26 04:27:14","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"30.96","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"260.18","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":"3293153","reservation_id":"117485","confirmation_number":"SJ12634716961","room_stay_from":"2021-07-31","room_stay_to":"2021-08-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.03,252.96,252.96","nightly_discount":"0.00,0.00,0.00","subtotal":"669.95","grand_total":"789.78","paid_amount":"789.78","room_type_id":"413","product_id":"1272","siteminder_id":"ABB-HMTED9B2WK","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"758.88","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124447","customer_id":"124447","source_of_creation":"Airbnb","reservation_created_date":"2021-06-17 16:46:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"22.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"164.03","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":"3293163","reservation_id":"118891","confirmation_number":"SJ12671750778","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"370.83,379.95,379.95,379.95","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1510.68","grand_total":"1750.70","paid_amount":"1750.70","room_type_id":"320","product_id":"1910","siteminder_id":"ABB-HM3R5CW8QR","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1519.80","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125979","customer_id":"125979","source_of_creation":"Airbnb","reservation_created_date":"2021-07-07 23:39:24","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"44.72","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"370.83","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":"3293870","reservation_id":"120423","confirmation_number":"SJ12654776269","room_stay_from":"2021-08-14","room_stay_to":"2021-08-19","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"320.28,320.28,320.28,320.28,320.28","nightly_discount":"0,0,0,0,0","subtotal":"1601.40","grand_total":"1854.28","paid_amount":"0.00","room_type_id":"319","product_id":"1943","siteminder_id":"ABB-HMES9YKN3F","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1601.40","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"127704","customer_id":"127704","source_of_creation":"Airbnb","reservation_created_date":"2021-07-30 17:04:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"47.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","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":"3280781","reservation_id":"118831","confirmation_number":"SJ12686353801","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"322.15,322.15","nightly_discount":"0.00,0","subtotal":"644.30","grand_total":"724.84","paid_amount":"724.84","room_type_id":"320","product_id":"1332","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125916","customer_id":"125916","source_of_creation":"FE","reservation_created_date":"2021-07-06 23:51:49","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1311,1312","currentDayPrice":"322.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3291525","reservation_id":"117192","confirmation_number":"SJ12666248489","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,269.25,209.25","nightly_discount":"0.00,0.00,0.00","subtotal":"777.75","grand_total":"874.97","paid_amount":"874.97","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124136","customer_id":"124136","source_of_creation":"FE","reservation_created_date":"2021-06-13 20:49:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"269.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3293692","reservation_id":"119268","confirmation_number":"SJ12674430408","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"299.25,299.25,299.25,299.25","nightly_discount":"0.00,0,0,0","subtotal":"1197.00","grand_total":"1346.63","paid_amount":"1346.63","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126396","customer_id":"126396","source_of_creation":"FE","reservation_created_date":"2021-07-13 19:42:08","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":"299.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3213613","reservation_id":"109047","confirmation_number":"SJ12625464481","room_stay_from":"2021-07-23","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"178.65,178.65,164.65,164.65,182.50,182.50,182.50,196.15,196.15","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1626.40","grand_total":"1829.70","paid_amount":"1829.70","room_type_id":"319","product_id":"1286","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":"104888","customer_id":"104888","source_of_creation":"PMS","reservation_created_date":"2021-03-02 21:09:18","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":"196.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":"3213639","reservation_id":"109047","confirmation_number":"SJ12679992573","room_stay_from":"2021-07-23","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"178.65,178.65,164.65,164.65,182.50,182.50,182.50,196.15,196.15","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1626.40","grand_total":"1829.70","paid_amount":"1829.70","room_type_id":"319","product_id":"1287","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":"104888","customer_id":"104888","source_of_creation":"PMS","reservation_created_date":"2021-03-02 21:09:19","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":"196.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":"3257762","reservation_id":"111303","confirmation_number":"SJ12662091189","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"335.85,335.85","nightly_discount":"0.00,0.00","subtotal":"671.70","grand_total":"755.67","paid_amount":"755.67","room_type_id":"320","product_id":"1329","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":"117835","customer_id":"117835","source_of_creation":"PMS","reservation_created_date":"2021-03-26 00:04:53","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1304,1305","currentDayPrice":"335.85","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":"3283108","reservation_id":"111338","confirmation_number":"SJ12615693130","room_stay_from":"2021-07-27","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"203.15,203.15,152.15,152.15,152.15","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"862.75","grand_total":"970.60","paid_amount":"970.60","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":"118250","customer_id":"118250","source_of_creation":"PMS","reservation_created_date":"2021-03-26 14:18:55","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":"152.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":"3283115","reservation_id":"116896","confirmation_number":"SJ12686044152","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"339.15,305.15","nightly_discount":"16.96,15.26","subtotal":"644.30","grand_total":"688.59","paid_amount":"688.59","room_type_id":"319","product_id":"1916","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":"123820","customer_id":"123820","source_of_creation":"PMS","reservation_created_date":"2021-06-09 20:01:45","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"FLRES","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":"3290866","reservation_id":"120174","confirmation_number":"SJ12627718420","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"385.90","nightly_discount":"19.30","subtotal":"385.90","grand_total":"412.43","paid_amount":"434.14","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"127434","customer_id":"127434","source_of_creation":"PMS","reservation_created_date":"2021-07-27 02:30:04","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":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"385.90","currentDayDiscount":"19.30","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3291533","reservation_id":"111714","confirmation_number":"SJ12651207532","room_stay_from":"2021-07-28","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.63,149.63,149.63,167.93","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"616.82","grand_total":"693.92","paid_amount":"693.92","room_type_id":"413","product_id":"1266","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":"118269","customer_id":"118269","source_of_creation":"PMS","reservation_created_date":"2021-03-30 21:44:56","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","group_rooms":null,"currentDayPrice":"167.93","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":"3291535","reservation_id":"111714","confirmation_number":"SJ12698666582","room_stay_from":"2021-07-28","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.63,143.63,143.63,167.93","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"598.82","grand_total":"673.67","paid_amount":"673.67","room_type_id":"319","product_id":"1288","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":"118269","customer_id":"118269","source_of_creation":"PMS","reservation_created_date":"2021-03-30 21:44:56","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":"167.93","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":"3292773","reservation_id":"119240","confirmation_number":"SJ12681429975","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"313.65","nightly_discount":"0.00","subtotal":"313.65","grand_total":"352.85","paid_amount":"352.85","room_type_id":"413","product_id":"1265","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":"125925","customer_id":"125925","source_of_creation":"PMS","reservation_created_date":"2021-07-13 14:20:38","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"313.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":"3293942","reservation_id":"120313","confirmation_number":"SJ12654283534","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"364.65","nightly_discount":"18.23","subtotal":"364.65","grand_total":"389.72","paid_amount":"389.72","room_type_id":"319","product_id":"1943","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":"118048","customer_id":"118048","source_of_creation":"PMS","reservation_created_date":"2021-07-29 01:13:39","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":"FLRES","sub_hotel_id":"0","currentDayPrice":"364.65","currentDayDiscount":"18.23","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3292804","reservation_id":"116075","confirmation_number":"SJ12626488766","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.25,246.75,171.75","nightly_discount":"13.46,12.34,8.59","subtotal":"687.75","grand_total":"735.03","paid_amount":"735.03","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":"122889","customer_id":"122889","source_of_creation":"PMS","reservation_created_date":"2021-05-28 16:11:32","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":"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":"3292805","reservation_id":"116075","confirmation_number":"SJ12645939718","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"269.25,246.75,171.75","nightly_discount":"13.46,12.34,8.59","subtotal":"687.75","grand_total":"735.03","paid_amount":"735.03","room_type_id":"319","product_id":"1313","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122889","customer_id":"122889","source_of_creation":"PMS","reservation_created_date":"2021-05-28 16:11:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"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":"3261318","reservation_id":"116458","confirmation_number":"SJ12696404495","room_stay_from":"2021-07-31","room_stay_to":"2021-08-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"246.75,186.75,186.75,186.75,186.75,246.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1240.50","grand_total":"1395.57","paid_amount":"1395.57","room_type_id":"413","product_id":"1261","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":"123328","customer_id":"123328","source_of_creation":"PMS","reservation_created_date":"2021-06-03 17:34:15","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":"0","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3230153","reservation_id":"112386","confirmation_number":"SJ12620642854","room_stay_from":"2021-07-31","room_stay_to":"2021-08-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.77,97.77,97.77,97.77,97.77,97.78,97.78","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"684.41","grand_total":"769.96","paid_amount":"196.88","room_type_id":"413","product_id":"1271","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"114227","customer_id":"114227","source_of_creation":"PMS","reservation_created_date":"2021-04-07 21:00:20","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","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":"97.77","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":"3293706","reservation_id":"109417","confirmation_number":"SJ12675774750","room_stay_from":"2021-08-02","room_stay_to":"2021-08-08","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75,134.25,179.25,179.25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1233.00","grand_total":"1387.13","paid_amount":"151.03","room_type_id":"319","product_id":"1301","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":"84824","customer_id":"84824","source_of_creation":"PMS","reservation_created_date":"2021-03-04 22:03:49","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":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3253527","reservation_id":"115449","confirmation_number":"SJ12686505144","room_stay_from":"2021-07-31","room_stay_to":"2021-08-05","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"277.59","room_type_id":"319","product_id":"1943","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":"122182","customer_id":"122182","source_of_creation":"PMS","reservation_created_date":"2021-05-18 17:44:00","service_canceled_date_time":"2021-07-28 19:28:53","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"0","deltaChange":"277.59","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3283109","reservation_id":"111338","confirmation_number":"SJ12699202200","room_confirmation_number":"SJ12615693130","room_stay_from":"2021-07-27","room_stay_to":"2021-08-01","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":"1777","service_quantity":"1","customer_traveller_id":"118250","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-07-13 14:02:28","reservation_modified_date_time":"2021-07-13 14:02:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118250","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3283116","reservation_id":"116896","confirmation_number":"SJ12694131010","room_confirmation_number":"SJ12686044152","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","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":"123820","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-07-13 14:03:01","reservation_modified_date_time":"2021-07-13 14:03:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123820","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3293943","reservation_id":"120313","confirmation_number":"SJ12648393787","room_confirmation_number":"SJ12654283534","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","room_stay_status":"Active","nightly_price":"25","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1777","service_quantity":"1","customer_traveller_id":"118048","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-07-31 22:50:49","reservation_modified_date_time":"2021-07-31 22:50:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118048","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3280831","reservation_id":"118961","confirmation_number":"SJ12630928686","room_confirmation_number":"SJ12640296618","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"126063","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-07-09 00:15:10","reservation_modified_date_time":"2021-07-09 00:15:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126063","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.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":"3292776","reservation_id":"120416","confirmation_number":"SJ12655520161","room_confirmation_number":"SJ12671107416","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"127694","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-07-30 19:06:55","reservation_modified_date_time":"2021-07-30 19:06:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127694","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":"3289181","reservation_id":"115490","confirmation_number":"SJ12654863534","room_confirmation_number":"SJ12666045629","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0,0,0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"122229","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2021-07-24 20:57:51","reservation_modified_date_time":"2021-07-24 20:57:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122229","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3293619","reservation_id":"117441","confirmation_number":"SJ12676728021","room_confirmation_number":"SJ12631011944","room_stay_from":"2021-08-02","room_stay_to":"2021-08-04","room_stay_status":"Active","nightly_price":"50,50","nightly_discount":"0,0","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"124410","product_attribute_values":"extra_person#&#25","reservation_created_date":"2021-07-31 19:04:26","reservation_modified_date_time":"2021-07-31 19:04:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124410","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3213615","reservation_id":"109047","confirmation_number":"SJ12696662274","room_confirmation_number":"SJ12625464481","room_stay_from":"2021-07-23","room_stay_to":"2021-08-01","room_stay_status":"Active","nightly_price":"25.00,25.00,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,0.00,0.00","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"104888","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-02 21:09:18","reservation_modified_date_time":"2021-03-10 23:31:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104888","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":"3213640","reservation_id":"109047","confirmation_number":"SJ12639543695","room_confirmation_number":"SJ12679992573","room_stay_from":"2021-07-23","room_stay_to":"2021-08-01","room_stay_status":"Active","nightly_price":"25.00,25.00,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,0.00,0.00","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"104888","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-02 21:09:19","reservation_modified_date_time":"2021-03-10 23:34:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"104888","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":"3247426","reservation_id":"114629","confirmation_number":"SJ12612431527","room_confirmation_number":"SJ12628736478","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","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":"121320","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-06 01:26:12","reservation_modified_date_time":"2021-05-06 01:26:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121320","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":"3256611","reservation_id":"113012","confirmation_number":"SJ12676254925","room_confirmation_number":"SJ12687215285","room_stay_from":"2021-07-29","room_stay_to":"2021-08-01","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":"119597","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-15 00:42:12","reservation_modified_date_time":"2021-05-25 02:47:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119597","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":"3257765","reservation_id":"111303","confirmation_number":"SJ12614380264","room_confirmation_number":"SJ12662091189","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","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":"117835","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-26 00:04:53","reservation_modified_date_time":"2021-05-27 14:16:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117835","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":"3276360","reservation_id":"118464","confirmation_number":"SJ12645818678","room_confirmation_number":"SJ12654034368","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","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":"125495","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-01 15:51:07","reservation_modified_date_time":"2021-07-01 15:51:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125495","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":"3283110","reservation_id":"111338","confirmation_number":"SJ12647659660","room_confirmation_number":"SJ12615693130","room_stay_from":"2021-07-27","room_stay_to":"2021-08-01","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":"118250","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-26 14:18:55","reservation_modified_date_time":"2021-07-13 14:02:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118250","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":"3283117","reservation_id":"116896","confirmation_number":"SJ12689221679","room_confirmation_number":"SJ12686044152","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","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":"123820","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-09 20:01:45","reservation_modified_date_time":"2021-07-13 14:03:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123820","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":"3284153","reservation_id":"111788","confirmation_number":"SJ12660062196","room_confirmation_number":"SJ12670799383","room_stay_from":"2021-07-29","room_stay_to":"2021-08-01","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":"118345","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-31 22:12:08","reservation_modified_date_time":"2021-07-14 18:36:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118345","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":"3284774","reservation_id":"113012","confirmation_number":"SJ12675382633","room_confirmation_number":"SJ12649460146","room_stay_from":"2021-07-29","room_stay_to":"2021-08-01","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":"119597","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-15 00:42:16","reservation_modified_date_time":"2021-07-15 21:27:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119597","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":"3287381","reservation_id":"119775","confirmation_number":"SJ12698605464","room_confirmation_number":"SJ12623100772","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","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":"126968","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-21 10:20:08","reservation_modified_date_time":"2021-07-21 10:23:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126968","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":"3289469","reservation_id":"119517","confirmation_number":"SJ12688702529","room_confirmation_number":"SJ12676650731","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","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":"126672","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-17 17:02:34","reservation_modified_date_time":"2021-07-17 17:02:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126672","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":"3289497","reservation_id":"114858","confirmation_number":"SJ12660354601","room_confirmation_number":"SJ12618298742","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","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":"121600","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-09 22:55:11","reservation_modified_date_time":"2021-07-25 14:26:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121600","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":"3289500","reservation_id":"114458","confirmation_number":"SJ12645971827","room_confirmation_number":"SJ12669308548","room_stay_from":"2021-07-30","room_stay_to":"2021-08-01","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":"121149","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-03 22:49:06","reservation_modified_date_time":"2021-07-25 14:30:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121149","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":"3290837","reservation_id":"120169","confirmation_number":"SJ12695995809","room_confirmation_number":"SJ12694902390","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","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":"127427","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-27 01:13:10","reservation_modified_date_time":"2021-07-27 01:13:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127427","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":"3290863","reservation_id":"120172","confirmation_number":"SJ12674233302","room_confirmation_number":"SJ12685259226","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","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":"127432","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-27 02:10:12","reservation_modified_date_time":"2021-07-27 02:10:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127432","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":"3290867","reservation_id":"120174","confirmation_number":"SJ12627190018","room_confirmation_number":"SJ12627718420","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"6.42","product_id":"1776","service_quantity":"1","customer_traveller_id":"127434","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-27 02:30:04","reservation_modified_date_time":"2021-07-27 02:30:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127434","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":"3291534","reservation_id":"111714","confirmation_number":"SJ12619092509","room_confirmation_number":"SJ12651207532","room_stay_from":"2021-07-28","room_stay_to":"2021-08-01","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":"118269","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 21:44:56","reservation_modified_date_time":"2021-07-28 13:14:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118269","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":"3291536","reservation_id":"111714","confirmation_number":"SJ12630777318","room_confirmation_number":"SJ12698666582","room_stay_from":"2021-07-28","room_stay_to":"2021-08-01","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":"118269","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-30 21:44:56","reservation_modified_date_time":"2021-07-28 13:18:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118269","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":"3291865","reservation_id":"120308","confirmation_number":"SJ12684258089","room_confirmation_number":"SJ12634379593","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","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":"127579","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-28 23:24:12","reservation_modified_date_time":"2021-07-28 23:24:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127579","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":"3292774","reservation_id":"119240","confirmation_number":"SJ12633395822","room_confirmation_number":"SJ12681429975","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","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":"125925","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-13 14:20:38","reservation_modified_date_time":"2021-07-30 19:06:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125925","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":"3293802","reservation_id":"120496","confirmation_number":"SJ12665079557","room_confirmation_number":"SJ12669787594","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","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":"127809","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-31 22:11:11","reservation_modified_date_time":"2021-07-31 22:11:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127809","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":"3293944","reservation_id":"120313","confirmation_number":"SJ12645202033","room_confirmation_number":"SJ12654283534","room_stay_from":"2021-07-31","room_stay_to":"2021-08-01","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":"118048","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-29 01:13:39","reservation_modified_date_time":"2021-07-31 22:50:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118048","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":"3258373","reservation_id":"116075","confirmation_number":"SJ12674149386","room_confirmation_number":"SJ12626488766","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","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":"122889","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-28 16:11:32","reservation_modified_date_time":"2021-05-28 16:11:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122889","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":"3269882","reservation_id":"116075","confirmation_number":"SJ12683336393","room_confirmation_number":"SJ12645939718","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","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":"122889","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-28 16:11:32","reservation_modified_date_time":"2021-06-18 23:46:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122889","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":"3269888","reservation_id":"117412","confirmation_number":"SJ12640988404","room_confirmation_number":"SJ12661930195","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","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":"124375","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-16 16:01:24","reservation_modified_date_time":"2021-06-18 23:46:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124375","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":"3275130","reservation_id":"118304","confirmation_number":"SJ12658414576","room_confirmation_number":"SJ12688926015","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","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":"125320","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-29 03:59:07","reservation_modified_date_time":"2021-06-29 03:59:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125320","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":"3280784","reservation_id":"118831","confirmation_number":"SJ12626801689","room_confirmation_number":"SJ12686353801","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","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":"125916","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-06 23:51:49","reservation_modified_date_time":"2021-07-08 22:13:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125916","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":"3280832","reservation_id":"118961","confirmation_number":"SJ12681141483","room_confirmation_number":"SJ12640296618","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","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":"126063","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-09 00:15:10","reservation_modified_date_time":"2021-07-09 00:15:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126063","canceled_nights_data":"","posAmt_airbnb_taxpaid":"150.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3290300","reservation_id":"119275","confirmation_number":"SJ12611811963","room_confirmation_number":"SJ12667279365","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","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":"126406","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-13 21:58:21","reservation_modified_date_time":"2021-07-26 16:05:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126406","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":"3291526","reservation_id":"117192","confirmation_number":"SJ12668675152","room_confirmation_number":"SJ12666248489","room_stay_from":"2021-07-30","room_stay_to":"2021-08-02","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":"124136","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-13 20:49:40","reservation_modified_date_time":"2021-07-28 13:10:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124136","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":"3292162","reservation_id":"120342","confirmation_number":"SJ12691785800","room_confirmation_number":"SJ12654109005","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","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":"127612","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-29 15:54:11","reservation_modified_date_time":"2021-07-29 15:54:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127612","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":"3292777","reservation_id":"120416","confirmation_number":"SJ12671252754","room_confirmation_number":"SJ12671107416","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","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":"127694","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-30 16:30:21","reservation_modified_date_time":"2021-07-30 19:06:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127694","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":"3293562","reservation_id":"119525","confirmation_number":"SJ12660196134","room_confirmation_number":"SJ12662463650","room_stay_from":"2021-07-31","room_stay_to":"2021-08-02","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":"126686","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-17 18:45:06","reservation_modified_date_time":"2021-07-31 18:22:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126686","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":"3280987","reservation_id":"118785","confirmation_number":"SJ12630896649","room_confirmation_number":"SJ12695908407","room_stay_from":"2021-07-31","room_stay_to":"2021-08-03","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":"125872","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-06 14:11:14","reservation_modified_date_time":"2021-07-09 13:56:27","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125872","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":"3293142","reservation_id":"115895","confirmation_number":"SJ12617185464","room_confirmation_number":"SJ12611919487","room_stay_from":"2021-07-31","room_stay_to":"2021-08-03","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":"122684","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-26 04:27:14","reservation_modified_date_time":"2021-07-31 13:20:08","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122684","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","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":"3293154","reservation_id":"117485","confirmation_number":"SJ12683742808","room_confirmation_number":"SJ12634716961","room_stay_from":"2021-07-31","room_stay_to":"2021-08-03","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":"124447","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-17 16:46:10","reservation_modified_date_time":"2021-07-31 13:22:36","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124447","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":"3269791","reservation_id":"114994","confirmation_number":"SJ12669477712","room_confirmation_number":"SJ12669342987","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","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":"121706","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-11 15:39:08","reservation_modified_date_time":"2021-06-18 23:16:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121706","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":"3287809","reservation_id":"111609","confirmation_number":"SJ12682952286","room_confirmation_number":"SJ12646164237","room_stay_from":"2021-07-30","room_stay_to":"2021-08-04","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":"118169","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-29 18:57:19","reservation_modified_date_time":"2021-07-22 07:17:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118169","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":"3289182","reservation_id":"115490","confirmation_number":"SJ12636508742","room_confirmation_number":"SJ12666045629","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"122229","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-19 02:46:09","reservation_modified_date_time":"2021-07-24 20:57:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122229","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":"3289226","reservation_id":"115490","confirmation_number":"SJ12641729846","room_confirmation_number":"SJ12653512423","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"122229","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-19 02:46:15","reservation_modified_date_time":"2021-07-24 22:02:35","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122229","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3293166","reservation_id":"118891","confirmation_number":"SJ12643090674","room_confirmation_number":"SJ12671750778","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","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":"125979","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-07 23:39:24","reservation_modified_date_time":"2021-07-31 13:46:40","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125979","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":"3293685","reservation_id":"119858","confirmation_number":"SJ12690840462","room_confirmation_number":"SJ12683652050","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","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":"127060","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-22 20:01:07","reservation_modified_date_time":"2021-07-31 19:41:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127060","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":"3293693","reservation_id":"119268","confirmation_number":"SJ12668982563","room_confirmation_number":"SJ12674430408","room_stay_from":"2021-07-31","room_stay_to":"2021-08-04","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":"126396","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-13 19:42:08","reservation_modified_date_time":"2021-07-31 19:42:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126396","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":"3261319","reservation_id":"116458","confirmation_number":"SJ12638784262","room_confirmation_number":"SJ12696404495","room_stay_from":"2021-07-31","room_stay_to":"2021-08-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"123328","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-06-03 17:34:15","reservation_modified_date_time":"2021-06-03 17:34:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123328","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":"3269811","reservation_id":"115977","confirmation_number":"SJ12652602989","room_confirmation_number":"SJ12647429060","room_stay_from":"2021-07-31","room_stay_to":"2021-08-06","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":"122783","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-27 10:45:10","reservation_modified_date_time":"2021-06-18 23:18:21","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122783","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":"3208548","reservation_id":"109261","confirmation_number":"SJ12683418652","room_confirmation_number":"SJ12659436067","room_stay_from":"2021-07-31","room_stay_to":"2021-08-07","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":"115733","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 01:01:07","reservation_modified_date_time":"2021-03-04 01:01:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115733","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":"3230154","reservation_id":"112386","confirmation_number":"SJ12648334727","room_confirmation_number":"SJ12620642854","room_stay_from":"2021-07-31","room_stay_to":"2021-08-07","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":"118953","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-04-07 21:00:20","reservation_modified_date_time":"2021-04-07 21:00:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"114227","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3269867","reservation_id":"116081","confirmation_number":"SJ12679395477","room_confirmation_number":"SJ12667037583","room_stay_from":"2021-07-31","room_stay_to":"2021-08-07","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":"122895","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-05-28 17:06:32","reservation_modified_date_time":"2021-06-09 23:29:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122895","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":"3293707","reservation_id":"109417","confirmation_number":"SJ12634124002","room_confirmation_number":"SJ12675774750","room_stay_from":"2021-08-02","room_stay_to":"2021-08-08","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":"84824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-03-04 22:03:50","reservation_modified_date_time":"2021-07-31 19:42:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84824","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3293816","reservation_id":"120323","confirmation_number":"SJ12613221152","room_confirmation_number":"SJ12656044173","room_stay_from":"2021-08-09","room_stay_to":"2021-08-13","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"127592","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-29 03:46:37","reservation_modified_date_time":"2021-07-31 22:16:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127592","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3293869","reservation_id":"120423","confirmation_number":"SJ12627634311","room_confirmation_number":"SJ12654776269","room_stay_from":"2021-08-14","room_stay_to":"2021-08-19","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":"127704","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-30 17:04:47","reservation_modified_date_time":"2021-07-31 22:29:12","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127704","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","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":"3293928","reservation_id":"120375","confirmation_number":"SJ12632621555","room_confirmation_number":"SJ12614706434","room_stay_from":"2021-09-30","room_stay_to":"2021-10-03","room_stay_status":"Active","nightly_price":"25,25,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":"127654","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-07-30 00:34:17","reservation_modified_date_time":"2021-07-31 22:41:27","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127654","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3294021","reservation_id":"120507","confirmation_number":"SJ12626654920","room_confirmation_number":"SJ12610151378","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.72","grand_total":"8.00","paid_amount":"8.00","product_id":"1663","service_quantity":"2","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-01 01:37:57","reservation_modified_date_time":"2021-08-01 01:37:57","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":"7.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3293762","reservation_id":"120488","confirmation_number":"SJ12658362105","room_confirmation_number":"SJ12678815947","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"225.00","paid_amount":"0.00","product_id":"1704","service_quantity":"3","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-07-31 21:12:54","reservation_modified_date_time":"2021-07-31 21:12:54","customer_id":"127802","parentCustTravId":"127802","customer_traveller_id":"127802","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-08-20","sub_hotel_id":"126","currentDayPrice":"225.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3293800","reservation_id":"115490","confirmation_number":"SJ12683453221","room_confirmation_number":"SJ12666045629","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"75.00","paid_amount":"75.00","product_id":"1704","service_quantity":"1","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-07-31 22:11:07","reservation_modified_date_time":"2021-07-31 22:11:07","customer_id":"122229","parentCustTravId":"122229","customer_traveller_id":"122229","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-07-31","sub_hotel_id":"126","currentDayPrice":"75.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3255379","reservation_id":"115490","confirmation_number":"SJ12642206168","room_confirmation_number":"SJ12653512423","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"75.00","grand_total":"75.00","paid_amount":"0.00","product_id":"1704","service_quantity":"1","product_name":"Pet Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-05-21 21:39:44","reservation_modified_date_time":"2021-05-21 21:39:44","customer_id":"122229","parentCustTravId":"122229","customer_traveller_id":"122229","static_pos_type":"petfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-07-31 22:11:33","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-07-31","sub_hotel_id":"126","deltaChange":-75,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}