{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-09-04","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":17,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1942","block_room_bookings":[{"confirmation_number":"SJ12651937647","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","bundle_room":"0","product_id":"1942"}],"bundle_block_count":"1262,1263,1269,1270,1307,1308,1304,1305,1260,1261,1302,1303,1271,1272,1291,1711,1311,1312,1267,1268,1309,1310","bundle_block_bookings":[{"confirmation_number":"SJB12682097092","room_stay_from":"2021-09-02","room_stay_to":"2021-09-06","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12639282813","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","bundle_room":"0","product_id":"1269"},{"confirmation_number":"SJB12698871940","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","bundle_room":"0","product_id":"1270"},{"confirmation_number":"SJB12693676053","room_stay_from":"2021-09-02","room_stay_to":"2021-09-06","bundle_room":"0","product_id":"1307"},{"confirmation_number":"SJB12629791576","room_stay_from":"2021-09-02","room_stay_to":"2021-09-06","bundle_room":"0","product_id":"1308"},{"confirmation_number":"SJB12673141504","room_stay_from":"2021-09-04","room_stay_to":"2021-09-07","bundle_room":"1","product_id":"1329"},{"confirmation_number":"SJB12619072859","room_stay_from":"2021-09-03","room_stay_to":"2021-09-05","bundle_room":"0","product_id":"1260"},{"confirmation_number":"SJB12658164999","room_stay_from":"2021-09-03","room_stay_to":"2021-09-05","bundle_room":"0","product_id":"1261"},{"confirmation_number":"SJB12624433779","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","bundle_room":"1","product_id":"1328"},{"confirmation_number":"SJB12623674887","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","bundle_room":"1","product_id":"1324"},{"confirmation_number":"SJB12663403422","room_stay_from":"2021-09-02","room_stay_to":"2021-09-05","bundle_room":"1","product_id":"1714"},{"confirmation_number":"SJB12687839071","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12656277430","room_stay_from":"2021-09-04","room_stay_to":"2021-09-07","bundle_room":"1","product_id":"1322"},{"confirmation_number":"SJB12665741613","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","bundle_room":"1","product_id":"1910"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3225706","reservation_id":"111800","confirmation_number":"SJ12690694839","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"251.30,223.30,223.30,223.30,223.30,223.30,251.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1619.10","grand_total":"1821.49","paid_amount":"1821.49","room_type_id":"320","product_id":"1323","siteminder_id":"BDC-3270329196","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":"118357","customer_id":"118357","source_of_creation":"Booking.com","reservation_created_date":"2021-03-31 23:53:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 218+219","ota_service_fee_amount":"0","commision_charges":"322.94","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1269,1270","currentDayPrice":"251.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3284581","reservation_id":"118510","confirmation_number":"SJ12667632246","room_stay_from":"2021-09-02","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"254.80,331.80,352.80,331.80","nightly_discount":"0,0,0,0","subtotal":"1271.20","grand_total":"1430.10","paid_amount":"1430.10","room_type_id":"320","product_id":"1330","siteminder_id":"BDC-2468862783","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":"125547","customer_id":"125547","source_of_creation":"Booking.com","reservation_created_date":"2021-07-02 03:17:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"246.82","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1307,1308","currentDayPrice":"352.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3287232","reservation_id":"119726","confirmation_number":"SJ12621028438","room_stay_from":"2021-08-28","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.54,129.84,129.84,129.84,124.17,124.17,186.54,203.55","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1214.49","grand_total":"1366.30","paid_amount":"1366.30","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-2136730789","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":"126919","customer_id":"126919","source_of_creation":"Booking.com","reservation_created_date":"2021-07-20 18:10:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"254.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"203.55","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3289884","reservation_id":"119677","confirmation_number":"SJ12657474708","room_stay_from":"2021-09-03","room_stay_to":"2021-09-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.37,207.27,188.37,119.07","nightly_discount":"0,0,0,0","subtotal":"703.08","grand_total":"790.96","paid_amount":"790.96","room_type_id":"318","product_id":"1282","siteminder_id":"BDC-2377230661","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":"126872","customer_id":"126872","source_of_creation":"Booking.com","reservation_created_date":"2021-07-19 23:28:26","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":"207.27","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":"3289894","reservation_id":"119800","confirmation_number":"SJ12644586216","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.87,218.09,199.87","nightly_discount":"0,0,0","subtotal":"617.83","grand_total":"695.06","paid_amount":"695.06","room_type_id":"319","product_id":"1917","siteminder_id":"BDC-3520380854","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":"126992","customer_id":"126992","source_of_creation":"Booking.com","reservation_created_date":"2021-07-21 18:08:38","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":"126","group_rooms":null,"currentDayPrice":"218.09","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":"3290537","reservation_id":"119739","confirmation_number":"SJ12675467876","room_stay_from":"2021-08-28","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.54,129.84,129.84,129.84,124.17,124.17,186.54,203.55","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1214.49","grand_total":"1366.30","paid_amount":"1366.30","room_type_id":"319","product_id":"1276","siteminder_id":"BDC-2793188004","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":"126933","customer_id":"126933","source_of_creation":"Booking.com","reservation_created_date":"2021-07-20 20:28:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"203.55","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3295959","reservation_id":"119428","confirmation_number":"SJ12676104733","room_stay_from":"2021-09-02","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.07,188.37,207.27,188.37","nightly_discount":"0,0,0,0","subtotal":"703.08","grand_total":"790.96","paid_amount":"790.96","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-2299688398","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":"126570","customer_id":"126570","source_of_creation":"Booking.com","reservation_created_date":"2021-07-16 01:04:18","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"207.27","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":"3304976","reservation_id":"117297","confirmation_number":"SJ12678175013","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,269.25,246.75","nightly_discount":"0,0,0","subtotal":"762.75","grand_total":"858.10","paid_amount":"858.10","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3205793842","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":"124254","customer_id":"124254","source_of_creation":"Booking.com","reservation_created_date":"2021-06-15 00:22:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"150.78","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"269.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3306047","reservation_id":"121640","confirmation_number":"SJ12686499210","room_stay_from":"2021-09-01","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.37,125.37,207.27,251.37","nightly_discount":"0,0,0,0","subtotal":"709.38","grand_total":"798.05","paid_amount":"798.05","room_type_id":"319","product_id":"1314","siteminder_id":"BDC-2454547404","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":"129160","customer_id":"129160","source_of_creation":"Booking.com","reservation_created_date":"2021-08-21 14:39:21","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":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"251.37","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5195366","reservation_id":"115859","confirmation_number":"SJ12614616938","room_stay_from":"2021-09-02","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.16,169.53,169.53,107.16","nightly_discount":"0,0,0,0","subtotal":"553.38","grand_total":"622.55","paid_amount":"622.55","room_type_id":"319","product_id":"1303","siteminder_id":"BDC-2421531934","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":"122641","customer_id":"122641","source_of_creation":"Booking.com","reservation_created_date":"2021-05-25 16:18:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"169.53","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":"5195394","reservation_id":"120593","confirmation_number":"SJ12657528047","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"258.55,258.55","nightly_discount":"0,0","subtotal":"517.10","grand_total":"581.74","paid_amount":"581.74","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2511520306","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":"127930","customer_id":"127930","source_of_creation":"Booking.com","reservation_created_date":"2021-08-02 17:39:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"102.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"258.55","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5304487","reservation_id":"122048","confirmation_number":"SJ12659021848","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"277.99,277.99","nightly_discount":"0,0","subtotal":"555.98","grand_total":"625.48","paid_amount":"625.48","room_type_id":"319","product_id":"1916","siteminder_id":"BDC-3043760572","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":"129598","customer_id":"129598","source_of_creation":"Booking.com","reservation_created_date":"2021-08-27 22:26:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"109.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"277.99","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":"5305228","reservation_id":"118292","confirmation_number":"SJ12625402354","room_stay_from":"2021-08-31","room_stay_to":"2021-09-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.27,137.97,137.97,207.27,226.17,207.27,137.97","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1198.89","grand_total":"1348.75","paid_amount":"1348.75","room_type_id":"319","product_id":"1277","siteminder_id":"BDC-3748210452","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":"125306","customer_id":"125306","source_of_creation":"Booking.com","reservation_created_date":"2021-06-28 23:54:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"247.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"226.17","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":"5305856","reservation_id":"118942","confirmation_number":"SJ12674845466","room_stay_from":"2021-09-01","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"153.72,153.72,223.02,241.92,223.02,153.72,153.72,153.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1456.56","grand_total":"1638.63","paid_amount":"1638.63","room_type_id":"412","product_id":"1921","siteminder_id":"BDC-2485171466","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":"126037","customer_id":"126037","source_of_creation":"Booking.com","reservation_created_date":"2021-07-08 18:07:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"298.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"241.92","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":"5306802","reservation_id":"121078","confirmation_number":"SJ12675779570","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"336.75,336.75,336.75","nightly_discount":"0,0,0","subtotal":"1010.25","grand_total":"1136.53","paid_amount":"1136.53","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2699143579","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":"128508","customer_id":"128508","source_of_creation":"Booking.com","reservation_created_date":"2021-08-11 23:45:18","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":"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":"5307238","reservation_id":"121639","confirmation_number":"SJ12665613444","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"242.33,289.57,289.57","nightly_discount":"0,0,0","subtotal":"821.47","grand_total":"924.15","paid_amount":"924.15","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-3110701987","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":"129158","customer_id":"129158","source_of_creation":"Booking.com","reservation_created_date":"2021-08-21 14:36:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"161.36","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"289.57","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":"5307435","reservation_id":"122364","confirmation_number":"SJ12669269359","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"319.20,319.20","nightly_discount":"0,0","subtotal":"638.40","grand_total":"718.20","paid_amount":"718.20","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-3052806727","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":"129953","customer_id":"129953","source_of_creation":"Booking.com","reservation_created_date":"2021-09-01 19:48:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"123.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"319.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":"5307621","reservation_id":"122392","confirmation_number":"SJ12647532925","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"277.99,277.99","nightly_discount":"0,0","subtotal":"555.98","grand_total":"625.48","paid_amount":"625.48","room_type_id":"319","product_id":"1312","siteminder_id":"BDC-3360185336","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":"129986","customer_id":"129986","source_of_creation":"Booking.com","reservation_created_date":"2021-09-02 02:51:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"109.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"277.99","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":"5308045","reservation_id":"118658","confirmation_number":"SJ12628569043","room_stay_from":"2021-09-03","room_stay_to":"2021-09-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"204.12,223.02,204.12,134.82","nightly_discount":"0,0,0,0","subtotal":"766.08","grand_total":"861.84","paid_amount":"861.84","room_type_id":"319","product_id":"1756","siteminder_id":"BDC-3415612562","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":"125736","customer_id":"125736","source_of_creation":"Booking.com","reservation_created_date":"2021-07-04 14:55:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"155.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"223.02","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5308138","reservation_id":"122351","confirmation_number":"SJ12650976178","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"238.95,286.20,286.20","nightly_discount":"0,0,0","subtotal":"811.35","grand_total":"912.77","paid_amount":"912.77","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-2692116297","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":"129913","customer_id":"129913","source_of_creation":"Booking.com","reservation_created_date":"2021-09-01 16:03:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"159.54","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"286.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":"5308375","reservation_id":"122486","confirmation_number":"SJ12634351572","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"343.20,343.20","nightly_discount":"0,0","subtotal":"686.40","grand_total":"772.20","paid_amount":"772.20","room_type_id":"319","product_id":"1309","siteminder_id":"BDC-3698727837","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":"130096","customer_id":"130096","source_of_creation":"Booking.com","reservation_created_date":"2021-09-03 22:31:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"132.55","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"343.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":"5308412","reservation_id":"122495","confirmation_number":"SJ12670740437","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"319.20,319.20","nightly_discount":"0,0","subtotal":"638.40","grand_total":"718.20","paid_amount":"718.20","room_type_id":"413","product_id":"1262","siteminder_id":"BDC-3088410725","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":"130107","customer_id":"130107","source_of_creation":"Booking.com","reservation_created_date":"2021-09-04 00:00:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"123.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"319.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":"5308599","reservation_id":"122077","confirmation_number":"SJ12628375613","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"295.37","nightly_discount":"0","subtotal":"295.37","grand_total":"332.29","paid_amount":"332.29","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-3968856797","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":"129630","customer_id":"129630","source_of_creation":"Booking.com","reservation_created_date":"2021-08-28 14:21:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"57.67","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"295.37","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5308683","reservation_id":"116272","confirmation_number":"SJ12648480934","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"282.80,205.80,205.80,205.80","nightly_discount":"0,0,0,0","subtotal":"900.20","grand_total":"1012.73","paid_amount":"1012.73","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-2846181857","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":"123131","customer_id":"123131","source_of_creation":"Booking.com","reservation_created_date":"2021-05-31 20:27:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"180.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"282.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5308687","reservation_id":"122403","confirmation_number":"SJ12637520099","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"308.88,308.88","nightly_discount":"0.00,0.00","subtotal":"617.76","grand_total":"694.98","paid_amount":"694.98","room_type_id":"319","product_id":"1311","siteminder_id":"BDC-3862444737","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":"129997","customer_id":"129997","source_of_creation":"Booking.com","reservation_created_date":"2021-09-02 12:15:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"120.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"308.88","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"}]}],"bdc_non_taxable":[{"room_stay_id":"3244761","reservation_id":"114172","confirmation_number":"SJ12640288216","room_stay_from":"2021-09-04","room_stay_to":"2021-09-10","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,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"235.47","room_type_id":"413","product_id":"1272","siteminder_id":"BDC-3808461714","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":"120807","customer_id":"120807","source_of_creation":"Booking.com","reservation_created_date":"2021-04-29 22:19:07","service_canceled_date_time":"2021-09-01 13:36:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"181.20","sub_hotel_id":"126","deltaChange":"235.47","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5308672","reservation_id":"122501","confirmation_number":"SJ12653596453","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"322.31","nightly_discount":"0","subtotal":"322.31","grand_total":"362.60","paid_amount":"362.60","room_type_id":"319","product_id":"1275","siteminder_id":"BDC-3863826008","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130119","customer_id":"130119","source_of_creation":"Booking.com","reservation_created_date":"2021-09-04 02:41:12","service_canceled_date_time":"2021-09-04 19:50:38","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 227","ota_service_fee_amount":"0","commision_charges":"67.02","sub_hotel_id":"126","deltaChange":"418.86","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3276932","reservation_id":"118485","confirmation_number":"SJ12654190724","room_stay_from":"2021-09-01","room_stay_to":"2021-09-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.64,122.64,184.24,201.04,184.24,122.64","nightly_discount":"0,0,0,0,0,0","subtotal":"937.44","grand_total":"1054.62","paid_amount":"1054.62","room_type_id":"319","product_id":"1306","siteminder_id":"EXP-1794325587","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":"125520","customer_id":"125520","source_of_creation":"Expedia","reservation_created_date":"2021-07-01 21:26:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"201.04","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":"3280510","reservation_id":"118876","confirmation_number":"SJ12653181226","room_stay_from":"2021-09-02","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.40,179.40,197.40","nightly_discount":"0,0,0","subtotal":"490.20","grand_total":"551.48","paid_amount":"551.48","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1797290251","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":"125964","customer_id":"125964","source_of_creation":"Expedia","reservation_created_date":"2021-07-07 20:40:12","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":"197.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":"3295657","reservation_id":"120673","confirmation_number":"SJ12686474641","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"288.32","nightly_discount":"0","subtotal":"288.32","grand_total":"324.36","paid_amount":"324.36","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1811023461","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"25.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128026","customer_id":"128026","source_of_creation":"Expedia","reservation_created_date":"2021-08-03 17:01:10","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"288.32","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3295810","reservation_id":"119506","confirmation_number":"SJ12698871048","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"251.30,230.30,153.30,153.30,153.30,139.30,167.30","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1248.10","grand_total":"1404.12","paid_amount":"282.72","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1802464427","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":"126659","customer_id":"126659","source_of_creation":"Expedia","reservation_created_date":"2021-07-17 16:00:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","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":"251.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3296617","reservation_id":"119164","confirmation_number":"SJ12658072858","room_stay_from":"2021-09-04","room_stay_to":"2021-09-07","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,224.25,141.75","nightly_discount":"0,0,0","subtotal":"612.75","grand_total":"689.35","paid_amount":"277.60","room_type_id":"319","product_id":"1304","siteminder_id":"EXP-1799505640","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":"126293","customer_id":"126293","source_of_creation":"Expedia","reservation_created_date":"2021-07-12 04:30:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303725","reservation_id":"121952","confirmation_number":"SJ12664556247","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"156.44,156.44,93.72,72.44","nightly_discount":"0,0,0,0","subtotal":"479.04","grand_total":"538.92","paid_amount":"538.92","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1821478909","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129489","customer_id":"129489","source_of_creation":"Expedia","reservation_created_date":"2021-08-26 15:36:11","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":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"156.44","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5306049","reservation_id":"122218","confirmation_number":"SJ12628533697","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"245.40,287.40,287.40","nightly_discount":"0,0,0","subtotal":"820.20","grand_total":"922.73","paid_amount":"922.73","room_type_id":"318","product_id":"1289","siteminder_id":"EXP-1823207753","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":"129790","customer_id":"129790","source_of_creation":"Expedia","reservation_created_date":"2021-08-30 18:01:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"287.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":"5307486","reservation_id":"122370","confirmation_number":"SJ12659577297","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.40,257.40,257.40","nightly_discount":"0,0,0","subtotal":"730.20","grand_total":"821.48","paid_amount":"821.48","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1824288950","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":"129961","customer_id":"129961","source_of_creation":"Expedia","reservation_created_date":"2021-09-01 22:51:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","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":"257.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":"5308297","reservation_id":"119777","confirmation_number":"SJ12684400118","room_stay_from":"2021-09-03","room_stay_to":"2021-09-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"247.80,268.80,247.80,170.80","nightly_discount":"0,0,0,0","subtotal":"935.20","grand_total":"1052.10","paid_amount":"1052.10","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1804449213","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":"126970","customer_id":"126970","source_of_creation":"Expedia","reservation_created_date":"2021-07-21 12:15:12","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"268.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5308675","reservation_id":"122521","confirmation_number":"SJ12685111860","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"343.20,343.20","nightly_discount":"0,0","subtotal":"686.40","grand_total":"772.20","paid_amount":"772.20","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1825568640","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":"130140","customer_id":"130140","source_of_creation":"Expedia","reservation_created_date":"2021-09-04 19:36:13","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","currentDayPrice":"343.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":"5308685","reservation_id":"117878","confirmation_number":"SJ12671494453","room_stay_from":"2021-09-04","room_stay_to":"2021-09-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"260.40,242.40,176.40","nightly_discount":"0,0,0","subtotal":"679.20","grand_total":"764.10","paid_amount":"764.10","room_type_id":"412","product_id":"1297","siteminder_id":"EXP-1789713076","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":"124863","customer_id":"124863","source_of_creation":"Expedia","reservation_created_date":"2021-06-23 01:51:11","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"260.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"}]}],"exp_non_taxable":[{"room_stay_id":"5308694","reservation_id":"119215","confirmation_number":"SJ12698420099","room_stay_from":"2021-09-04","room_stay_to":"2021-09-07","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"260.40,242.40,176.40","nightly_discount":"0.00,0.00,0.00","subtotal":"679.20","grand_total":"764.10","paid_amount":"764.10","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1799954646","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":"126342","customer_id":"126342","source_of_creation":"Expedia","reservation_created_date":"2021-07-13 00:05:10","service_canceled_date_time":"2021-09-04 20:31:47","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"126","deltaChange":"792.23","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3189028","reservation_id":"106604","confirmation_number":"SJ12680115083","room_stay_from":"2021-09-02","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.09,112.65,112.65,91.09","nightly_discount":"0,0,0,0","subtotal":"407.48","grand_total":"458.41","paid_amount":"458.41","room_type_id":"413","product_id":"1263","siteminder_id":"GAM-R2305721864","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":"113025","customer_id":"113025","source_of_creation":"Getaroom.com","reservation_created_date":"2021-02-01 03:50:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"112.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":"4079535","reservation_id":"121657","confirmation_number":"SJ12659821527","room_stay_from":"2021-09-03","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"345.06,388.18","nightly_discount":"0,0","subtotal":"733.24","grand_total":"824.89","paid_amount":"824.89","room_type_id":"320","product_id":"1320","siteminder_id":"GAM-R2751253616","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":"129184","customer_id":"129184","source_of_creation":"Getaroom.com","reservation_created_date":"2021-08-21 18:48:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 206+207","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":"1260,1261","currentDayPrice":"388.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":"5308057","reservation_id":"111565","confirmation_number":"SJ12612487326","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.74,104.10","nightly_discount":"0,0","subtotal":"232.84","grand_total":"261.94","paid_amount":"261.94","room_type_id":"319","product_id":"1943","siteminder_id":"GAM-R2414113113","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":"118124","customer_id":"118124","source_of_creation":"Getaroom.com","reservation_created_date":"2021-03-29 02:26:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"128.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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"5308712","reservation_id":"122526","confirmation_number":"SJ12663905217","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"465.40","nightly_discount":"0.00","subtotal":"465.40","grand_total":"539.33","paid_amount":"539.33","room_type_id":"412","product_id":"1315","siteminder_id":"ABB-HMS3HDPEDS","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"468.18","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130144","customer_id":"130144","source_of_creation":"Airbnb","reservation_created_date":"2021-09-04 20:47:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"13.77","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","currentDayPrice":"465.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3276930","reservation_id":"118547","confirmation_number":"SJ12621528288","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"288.00,265.50,183.00,183.00,183.00,168.00,198.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1468.50","grand_total":"1652.07","paid_amount":"1652.07","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125581","customer_id":"125581","source_of_creation":"FE","reservation_created_date":"2021-07-02 18:14:42","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"288.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":"5307934","reservation_id":"122442","confirmation_number":"SJ12682770774","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"288.00,340.50,340.50","nightly_discount":"0.00,0.00,0.00","subtotal":"969.00","grand_total":"1090.13","paid_amount":"1090.13","room_type_id":"411","product_id":"1296","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":"130037","customer_id":"130037","source_of_creation":"FE","reservation_created_date":"2021-09-02 23:05:06","canceled_nights_data":"","product_name":"Bay View One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"340.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":"5308410","reservation_id":"122494","confirmation_number":"SJ12617900554","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"364.65","nightly_discount":"0.00","subtotal":"364.65","grand_total":"410.23","paid_amount":"410.23","room_type_id":"319","product_id":"1310","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130106","customer_id":"130106","source_of_creation":"FE","reservation_created_date":"2021-09-03 23:44:45","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"364.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3303335","reservation_id":"121281","confirmation_number":"SJ12620823345","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"339.15,339.15","nightly_discount":"0.00,0.00","subtotal":"678.30","grand_total":"763.09","paid_amount":"763.09","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":"128752","customer_id":"128752","source_of_creation":"PMS","reservation_created_date":"2021-08-16 16:00:05","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"339.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":"5307459","reservation_id":"120786","confirmation_number":"SJ12672603518","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"321.75,321.75,321.75","nightly_discount":"32.18,32.18,32.18","subtotal":"965.25","grand_total":"977.30","paid_amount":"977.30","room_type_id":"319","product_id":"1711","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"104888","customer_id":"104888","source_of_creation":"PMS","reservation_created_date":"2021-08-05 17:38:34","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"special123","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"321.75","currentDayDiscount":"32.18","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5308049","reservation_id":"122449","confirmation_number":"SJ12633742896","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"364.65","nightly_discount":"0.00","subtotal":"364.65","grand_total":"410.23","paid_amount":"410.23","room_type_id":"413","product_id":"1267","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":"130045","customer_id":"130045","source_of_creation":"PMS","reservation_created_date":"2021-09-03 01:22:20","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":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"364.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":"5308596","reservation_id":"122404","confirmation_number":"SJ12688436312","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"339.15","nightly_discount":"16.96","subtotal":"339.15","grand_total":"362.46","paid_amount":"362.46","room_type_id":"412","product_id":"1294","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":"129998","customer_id":"129998","source_of_creation":"PMS","reservation_created_date":"2021-09-02 12:46:01","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":"AAA","sub_hotel_id":"0","currentDayPrice":"339.15","currentDayDiscount":"16.96","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[{"room_stay_id":"3304978","reservation_id":"110475","confirmation_number":"SJ12629988019","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.00,128.00,128.00","nightly_discount":"0.00,0,0","subtotal":"384.00","grand_total":"432.00","paid_amount":"84.38","room_type_id":"319","product_id":"1288","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2021-03-17 02:15:03","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":"128.00","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"}]}],"negotiated_non_taxable":[{"room_stay_id":"3265711","reservation_id":"117037","confirmation_number":"SJ12683471302","room_stay_from":"2021-08-29","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.85,111.85,111.85,111.85,111.85,111.85,111.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"783.00","grand_total":"783.00","paid_amount":"0.00","room_type_id":"319","product_id":"1286","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-06-11 17:47:28","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":"111.90","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303262","reservation_id":"115586","confirmation_number":"SJ12669736118","room_stay_from":"2021-09-02","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1274","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-20 23:02:52","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":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303278","reservation_id":"116284","confirmation_number":"SJ12676909295","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-31 22:01:18","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5305234","reservation_id":"116038","confirmation_number":"SJ12639868735","room_stay_from":"2021-08-29","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0,0,0,0,0","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1291","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-27 23:30:59","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5307861","reservation_id":"116031","confirmation_number":"SJ12678696348","room_stay_from":"2021-09-02","room_stay_to":"2021-09-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0.00,0.00","subtotal":"260.01","grand_total":"260.01","paid_amount":"84.38","room_type_id":"319","product_id":"1302","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-05-27 22:19:51","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","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":"86.67","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3295658","reservation_id":"120673","confirmation_number":"SJ12697676362","room_confirmation_number":"SJ12686474641","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","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":"128026","product_attribute_values":"extra_person#.00","reservation_created_date":"2021-08-03 17:01:10","reservation_modified_date_time":"2021-08-03 17:01:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128026","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3303336","reservation_id":"121281","confirmation_number":"SJ12614989619","room_confirmation_number":"SJ12620823345","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","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":"128752","product_attribute_values":"extra_person#.00","reservation_created_date":"2021-08-16 16:00:05","reservation_modified_date_time":"2021-08-16 16:00:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128752","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":"5303726","reservation_id":"121952","confirmation_number":"SJ12614974523","room_confirmation_number":"SJ12664556247","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"129489","product_attribute_values":"extra_person#.00","reservation_created_date":"2021-08-26 15:36:11","reservation_modified_date_time":"2021-08-26 15:36:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129489","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":"5305857","reservation_id":"118942","confirmation_number":"SJ12682129326","room_confirmation_number":"SJ12674845466","room_stay_from":"2021-09-01","room_stay_to":"2021-09-09","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25,25","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1777","service_quantity":"1","customer_traveller_id":"126037","product_attribute_values":"extra_person#","reservation_created_date":"2021-08-30 13:13:53","reservation_modified_date_time":"2021-08-30 13:13:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126037","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":"5307461","reservation_id":"120786","confirmation_number":"SJ12629430252","room_confirmation_number":"SJ12672603518","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","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":"104888","product_attribute_values":"extra_person#","reservation_created_date":"2021-09-01 20:59:41","reservation_modified_date_time":"2021-09-01 20:59:41","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":"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":"5308597","reservation_id":"122404","confirmation_number":"SJ12663593294","room_confirmation_number":"SJ12688436312","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","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":"129998","product_attribute_values":"extra_person#","reservation_created_date":"2021-09-04 17:11:26","reservation_modified_date_time":"2021-09-04 17:11:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129998","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":"5308688","reservation_id":"122403","confirmation_number":"SJ12613882802","room_confirmation_number":"SJ12637520099","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"129997","product_attribute_values":"extra_person#.00","reservation_created_date":"2021-09-04 20:07:08","reservation_modified_date_time":"2021-09-04 20:07:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129997","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3189029","reservation_id":"106604","confirmation_number":"SJ12620441555","room_confirmation_number":"SJ12680115083","room_stay_from":"2021-09-02","room_stay_to":"2021-09-06","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":"113025","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-02-01 03:50:11","reservation_modified_date_time":"2021-02-01 03:50:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113025","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":"3225707","reservation_id":"111800","confirmation_number":"SJ12620493139","room_confirmation_number":"SJ12690694839","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","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":"118357","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-31 23:53:10","reservation_modified_date_time":"2021-03-31 23:53:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118357","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":"3265712","reservation_id":"117037","confirmation_number":"SJ12690846240","room_confirmation_number":"SJ12683471302","room_stay_from":"2021-08-29","room_stay_to":"2021-09-05","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"123975","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-11 17:47:28","reservation_modified_date_time":"2021-06-11 17:47:28","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3276931","reservation_id":"118547","confirmation_number":"SJ12646064025","room_confirmation_number":"SJ12621528288","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","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":"125581","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-02 18:14:42","reservation_modified_date_time":"2021-07-02 18:31:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125581","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":"3276933","reservation_id":"118485","confirmation_number":"SJ12632088092","room_confirmation_number":"SJ12654190724","room_stay_from":"2021-09-01","room_stay_to":"2021-09-07","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":"125520","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-01 21:26:12","reservation_modified_date_time":"2021-07-02 18:32:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125520","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":"3280511","reservation_id":"118876","confirmation_number":"SJ12647110712","room_confirmation_number":"SJ12653181226","room_stay_from":"2021-09-02","room_stay_to":"2021-09-05","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":"125964","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-07 20:40:12","reservation_modified_date_time":"2021-07-08 18:07:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125964","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":"3284584","reservation_id":"118510","confirmation_number":"SJ12682781034","room_confirmation_number":"SJ12667632246","room_stay_from":"2021-09-02","room_stay_to":"2021-09-06","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":"125547","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-02 03:17:11","reservation_modified_date_time":"2021-07-15 18:00:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125547","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":"3287233","reservation_id":"119726","confirmation_number":"SJ12633658215","room_confirmation_number":"SJ12621028438","room_stay_from":"2021-08-28","room_stay_to":"2021-09-05","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126919","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-20 18:10:29","reservation_modified_date_time":"2021-07-20 21:33:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126919","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":"3289883","reservation_id":"119677","confirmation_number":"SJ12686652080","room_confirmation_number":"SJ12657474708","room_stay_from":"2021-09-03","room_stay_to":"2021-09-07","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":"126872","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-19 23:28:26","reservation_modified_date_time":"2021-07-25 21:19:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126872","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":"3289893","reservation_id":"119800","confirmation_number":"SJ12678293958","room_confirmation_number":"SJ12644586216","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"126992","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-21 18:08:38","reservation_modified_date_time":"2021-07-25 21:20:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126992","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":"3290536","reservation_id":"119739","confirmation_number":"SJ12625742911","room_confirmation_number":"SJ12675467876","room_stay_from":"2021-08-28","room_stay_to":"2021-09-05","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126933","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-20 20:28:57","reservation_modified_date_time":"2021-07-26 19:11:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126933","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":"3295659","reservation_id":"120673","confirmation_number":"SJ12648232038","room_confirmation_number":"SJ12686474641","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","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":"128026","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-03 17:01:10","reservation_modified_date_time":"2021-08-03 17:01:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128026","canceled_nights_data":"","posAmt_airbnb_taxpaid":"25.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3295812","reservation_id":"119506","confirmation_number":"SJ12655312424","room_confirmation_number":"SJ12698871048","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","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":"126659","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-17 16:00:13","reservation_modified_date_time":"2021-08-03 19:12:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126659","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":"3295958","reservation_id":"119428","confirmation_number":"SJ12688520062","room_confirmation_number":"SJ12676104733","room_stay_from":"2021-09-02","room_stay_to":"2021-09-06","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":"126570","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-16 01:04:18","reservation_modified_date_time":"2021-07-16 01:04:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126570","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":"3296618","reservation_id":"119164","confirmation_number":"SJ12634392972","room_confirmation_number":"SJ12658072858","room_stay_from":"2021-09-04","room_stay_to":"2021-09-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126293","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-12 04:30:16","reservation_modified_date_time":"2021-08-05 11:41:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126293","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":"3303337","reservation_id":"121281","confirmation_number":"SJ12676654104","room_confirmation_number":"SJ12620823345","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","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":"128752","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-16 16:00:05","reservation_modified_date_time":"2021-08-16 16:00:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128752","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":"3304977","reservation_id":"117297","confirmation_number":"SJ12637878567","room_confirmation_number":"SJ12678175013","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","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":"124254","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-15 00:22:13","reservation_modified_date_time":"2021-08-19 20:17:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124254","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":"3304979","reservation_id":"110475","confirmation_number":"SJ12677878547","room_confirmation_number":"SJ12629988019","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"116988","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-17 02:15:03","reservation_modified_date_time":"2021-08-19 20:17:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","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":"3306046","reservation_id":"121640","confirmation_number":"SJ12632337116","room_confirmation_number":"SJ12686499210","room_stay_from":"2021-09-01","room_stay_to":"2021-09-05","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":"129160","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-21 14:39:21","reservation_modified_date_time":"2021-08-21 15:11:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129160","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":"4079537","reservation_id":"121657","confirmation_number":"SJ12689072641","room_confirmation_number":"SJ12659821527","room_stay_from":"2021-09-03","room_stay_to":"2021-09-05","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":"129184","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-21 18:48:10","reservation_modified_date_time":"2021-08-21 18:48:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129184","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":"5195367","reservation_id":"115859","confirmation_number":"SJ12653496043","room_confirmation_number":"SJ12614616938","room_stay_from":"2021-09-02","room_stay_to":"2021-09-06","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":"122641","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-25 16:18:22","reservation_modified_date_time":"2021-08-23 17:27:46","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122641","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":"5195395","reservation_id":"120593","confirmation_number":"SJ12632505224","room_confirmation_number":"SJ12657528047","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","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":"127930","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-02 17:39:11","reservation_modified_date_time":"2021-08-23 17:30:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127930","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":"5303261","reservation_id":"115586","confirmation_number":"SJ12683746797","room_confirmation_number":"SJ12669736118","room_stay_from":"2021-09-02","room_stay_to":"2021-09-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122338","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-20 23:02:52","reservation_modified_date_time":"2021-08-25 19:06:20","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303277","reservation_id":"116284","confirmation_number":"SJ12632764658","room_confirmation_number":"SJ12676909295","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"123144","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-31 22:01:18","reservation_modified_date_time":"2021-08-25 19:06:21","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5303727","reservation_id":"121952","confirmation_number":"SJ12622815552","room_confirmation_number":"SJ12664556247","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","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":"129489","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-26 15:36:11","reservation_modified_date_time":"2021-08-26 15:36:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129489","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"126","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5304488","reservation_id":"122048","confirmation_number":"SJ12625345203","room_confirmation_number":"SJ12659021848","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","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":"129598","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-27 22:26:13","reservation_modified_date_time":"2021-08-27 22:26:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129598","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":"5305230","reservation_id":"118292","confirmation_number":"SJ12648283109","room_confirmation_number":"SJ12625402354","room_stay_from":"2021-08-31","room_stay_to":"2021-09-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":"125306","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-28 23:54:14","reservation_modified_date_time":"2021-08-29 01:49:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125306","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":"5305236","reservation_id":"116038","confirmation_number":"SJ12673197210","room_confirmation_number":"SJ12639868735","room_stay_from":"2021-08-29","room_stay_to":"2021-09-05","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":"122845","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-27 23:30:59","reservation_modified_date_time":"2021-08-29 01:49:46","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5305858","reservation_id":"118942","confirmation_number":"SJ12611617237","room_confirmation_number":"SJ12674845466","room_stay_from":"2021-09-01","room_stay_to":"2021-09-09","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"126037","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-08 18:07:08","reservation_modified_date_time":"2021-08-30 13:13:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126037","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":"5306050","reservation_id":"122218","confirmation_number":"SJ12687225676","room_confirmation_number":"SJ12628533697","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"129790","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-30 18:01:10","reservation_modified_date_time":"2021-08-30 18:01:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129790","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":"5306803","reservation_id":"121078","confirmation_number":"SJ12685979346","room_confirmation_number":"SJ12675779570","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"128508","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-11 23:45:18","reservation_modified_date_time":"2021-08-31 20:53:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128508","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":"5307239","reservation_id":"121639","confirmation_number":"SJ12662656487","room_confirmation_number":"SJ12665613444","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"129158","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-21 14:36:13","reservation_modified_date_time":"2021-09-01 13:34:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129158","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":"5307436","reservation_id":"122364","confirmation_number":"SJ12676363354","room_confirmation_number":"SJ12669269359","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","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":"129953","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-01 19:48:08","reservation_modified_date_time":"2021-09-01 19:48:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129953","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":"5307462","reservation_id":"120786","confirmation_number":"SJ12679984711","room_confirmation_number":"SJ12672603518","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"104888","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-05 17:38:34","reservation_modified_date_time":"2021-09-01 20:59:43","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":"5307487","reservation_id":"122370","confirmation_number":"SJ12678019162","room_confirmation_number":"SJ12659577297","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"129961","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-01 22:51:10","reservation_modified_date_time":"2021-09-01 22:51:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129961","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":"5307622","reservation_id":"122392","confirmation_number":"SJ12665775680","room_confirmation_number":"SJ12647532925","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","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":"129986","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-02 02:51:12","reservation_modified_date_time":"2021-09-02 02:51:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129986","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":"5307862","reservation_id":"116031","confirmation_number":"SJ12622509457","room_confirmation_number":"SJ12678696348","room_stay_from":"2021-09-02","room_stay_to":"2021-09-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"122841","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-27 22:19:51","reservation_modified_date_time":"2021-09-02 19:00:55","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"5307935","reservation_id":"122442","confirmation_number":"SJ12682813980","room_confirmation_number":"SJ12682770774","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"130037","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-02 23:05:06","reservation_modified_date_time":"2021-09-02 23:05:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130037","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":"5308048","reservation_id":"118658","confirmation_number":"SJ12645963334","room_confirmation_number":"SJ12628569043","room_stay_from":"2021-09-03","room_stay_to":"2021-09-07","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":"125736","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-04 14:55:09","reservation_modified_date_time":"2021-09-03 11:26:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125736","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":"5308050","reservation_id":"122449","confirmation_number":"SJ12612328486","room_confirmation_number":"SJ12633742896","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","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":"130045","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-03 01:22:20","reservation_modified_date_time":"2021-09-03 11:26:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130045","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":"5308058","reservation_id":"111565","confirmation_number":"SJ12652906368","room_confirmation_number":"SJ12612487326","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","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":"118124","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-29 02:26:11","reservation_modified_date_time":"2021-09-03 11:29:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118124","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":"5308139","reservation_id":"122351","confirmation_number":"SJ12696349378","room_confirmation_number":"SJ12650976178","room_stay_from":"2021-09-03","room_stay_to":"2021-09-06","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":"129913","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-01 16:03:09","reservation_modified_date_time":"2021-09-03 13:54:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129913","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":"5308298","reservation_id":"119777","confirmation_number":"SJ12639638606","room_confirmation_number":"SJ12684400118","room_stay_from":"2021-09-03","room_stay_to":"2021-09-07","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":"126970","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-21 12:15:12","reservation_modified_date_time":"2021-09-03 20:33:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126970","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":"5308376","reservation_id":"122486","confirmation_number":"SJ12642128320","room_confirmation_number":"SJ12634351572","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","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":"130096","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-03 22:31:11","reservation_modified_date_time":"2021-09-03 22:31:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130096","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":"5308411","reservation_id":"122494","confirmation_number":"SJ12691499061","room_confirmation_number":"SJ12617900554","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","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":"130106","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-03 23:44:45","reservation_modified_date_time":"2021-09-03 23:50:26","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130106","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":"5308413","reservation_id":"122495","confirmation_number":"SJ12656754694","room_confirmation_number":"SJ12670740437","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","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":"130107","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-04 00:00:14","reservation_modified_date_time":"2021-09-04 00:00:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130107","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":"5308598","reservation_id":"122404","confirmation_number":"SJ12626741376","room_confirmation_number":"SJ12688436312","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","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":"129998","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-02 12:46:01","reservation_modified_date_time":"2021-09-04 17:11:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129998","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":"5308600","reservation_id":"122077","confirmation_number":"SJ12682982284","room_confirmation_number":"SJ12628375613","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","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":"129630","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-28 14:21:09","reservation_modified_date_time":"2021-09-04 17:11:42","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129630","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":"5308676","reservation_id":"122521","confirmation_number":"SJ12659835091","room_confirmation_number":"SJ12685111860","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","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":"130140","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-04 19:36:13","reservation_modified_date_time":"2021-09-04 19:50:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130140","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":"5308684","reservation_id":"116272","confirmation_number":"SJ12621718982","room_confirmation_number":"SJ12648480934","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","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":"123131","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-31 20:27:08","reservation_modified_date_time":"2021-09-04 20:05:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123131","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":"5308686","reservation_id":"117878","confirmation_number":"SJ12675663483","room_confirmation_number":"SJ12671494453","room_stay_from":"2021-09-04","room_stay_to":"2021-09-07","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":"124863","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-23 01:51:11","reservation_modified_date_time":"2021-09-04 20:05:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124863","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":"5308689","reservation_id":"122403","confirmation_number":"SJ12673961068","room_confirmation_number":"SJ12637520099","room_stay_from":"2021-09-04","room_stay_to":"2021-09-06","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"129997","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-02 12:15:11","reservation_modified_date_time":"2021-09-04 20:07:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129997","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":"5308713","reservation_id":"122526","confirmation_number":"SJ12657224128","room_confirmation_number":"SJ12663905217","room_stay_from":"2021-09-04","room_stay_to":"2021-09-05","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"130144","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-04 20:47:06","reservation_modified_date_time":"2021-09-04 21:28:16","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130144","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":"5308568","reservation_id":"121268","confirmation_number":"SJ12610589781","room_confirmation_number":"SJ12626595737","room_stay_from":"2021-09-01","room_stay_to":"2021-09-04","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"25.00,25.00,0.00","subtotal":"75.00","grand_total":"28.13","paid_amount":"28.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"128741","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-16 13:42:12","reservation_modified_date_time":"2021-09-04 15:52:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128741","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"Nightly price or discount changed","deltaChange":"-50.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":"5308638","reservation_id":"122519","confirmation_number":"SJ12617840967","room_confirmation_number":"SJ12624686461","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":"4.00","paid_amount":"4.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-04 18:41:02","reservation_modified_date_time":"2021-09-04 18:41:02","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"0","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}