{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-07-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":13,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1942,1314,1281,1289,1304,1286","block_room_bookings":[{"confirmation_number":"SJ12688368812","room_stay_from":"2021-07-04","room_stay_to":"2021-07-05","bundle_room":"0","product_id":"1942"},{"confirmation_number":"SJ12632328643","room_stay_from":"2021-07-04","room_stay_to":"2021-07-05","bundle_room":"0","product_id":"1314"},{"confirmation_number":"SJ12612154338","room_stay_from":"2021-07-04","room_stay_to":"2021-07-05","bundle_room":"0","product_id":"1281"},{"confirmation_number":"SJ12681989283","room_stay_from":"2021-07-04","room_stay_to":"2021-07-05","bundle_room":"0","product_id":"1289"},{"confirmation_number":"SJ12675759026","room_stay_from":"2021-06-29","room_stay_to":"2021-07-08","bundle_room":"0","product_id":"1304"},{"confirmation_number":"SJ12645807054","room_stay_from":"2021-06-30","room_stay_to":"2021-07-09","bundle_room":"0","product_id":"1286"}],"bundle_block_count":"1271,1272,1302,1303,1262,1263,1307,1308,1260,1261,1311,1312,1269,1270,1309,1310,1291,1711,1304,1305,1267,1268","bundle_block_bookings":[{"confirmation_number":"SJB12685312431","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","bundle_room":"0","product_id":"1271"},{"confirmation_number":"SJB12631717950","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","bundle_room":"0","product_id":"1272"},{"confirmation_number":"SJB12622350821","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","bundle_room":"0","product_id":"1302"},{"confirmation_number":"SJB12676664296","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","bundle_room":"0","product_id":"1303"},{"confirmation_number":"SJB12618957869","room_stay_from":"2021-07-03","room_stay_to":"2021-07-05","bundle_room":"1","product_id":"1321"},{"confirmation_number":"SJB12634331785","room_stay_from":"2021-07-04","room_stay_to":"2021-07-05","bundle_room":"1","product_id":"1330"},{"confirmation_number":"SJB12656098380","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","bundle_room":"1","product_id":"1320"},{"confirmation_number":"SJB12647640737","room_stay_from":"2021-07-04","room_stay_to":"2021-07-05","bundle_room":"1","product_id":"1332"},{"confirmation_number":"SJB12686874632","room_stay_from":"2021-07-03","room_stay_to":"2021-07-05","bundle_room":"1","product_id":"1323"},{"confirmation_number":"SJB12697097953","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","bundle_room":"1","product_id":"1910"},{"confirmation_number":"SJB12640517015","room_stay_from":"2021-07-03","room_stay_to":"2021-07-08","bundle_room":"0","product_id":"1291"},{"confirmation_number":"SJB12679631750","room_stay_from":"2021-07-03","room_stay_to":"2021-07-08","bundle_room":"0","product_id":"1711"},{"confirmation_number":"SJB12693652583","room_stay_from":"2021-07-04","room_stay_to":"2021-07-08","bundle_room":"1","product_id":"1329"},{"confirmation_number":"SJB12692092894","room_stay_from":"2021-07-03","room_stay_to":"2021-07-10","bundle_room":"0","product_id":"1267"},{"confirmation_number":"SJB12680520632","room_stay_from":"2021-07-03","room_stay_to":"2021-07-10","bundle_room":"0","product_id":"1268"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3224415","reservation_id":"111572","confirmation_number":"SJ12697294787","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"279.30,314.30,314.30,314.30","nightly_discount":"0,0,0,0","subtotal":"1222.20","grand_total":"1374.98","paid_amount":"1374.98","room_type_id":"320","product_id":"1328","siteminder_id":"BDC-2755994797","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":"118130","customer_id":"118130","source_of_creation":"Booking.com","reservation_created_date":"2021-03-29 03:21:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"238.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1302,1303","currentDayPrice":"314.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":"3233507","reservation_id":"112476","confirmation_number":"SJ12669647181","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"198.02,229.52,229.52,229.52","nightly_discount":"0,0,0,0","subtotal":"886.58","grand_total":"997.40","paid_amount":"997.40","room_type_id":"319","product_id":"1318","siteminder_id":"BDC-3404464107","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119048","customer_id":"119048","source_of_creation":"Booking.com","reservation_created_date":"2021-04-08 23:22:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"391.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"229.52","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3233512","reservation_id":"112476","confirmation_number":"SJ12620609595","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"223.02,254.52,254.52,254.52","nightly_discount":"0,0,0,0","subtotal":"986.58","grand_total":"1109.90","paid_amount":"1109.90","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-3404464107","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":"119048","customer_id":"119048","source_of_creation":"Booking.com","reservation_created_date":"2021-04-08 23:22:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"391.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"254.52","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3260769","reservation_id":"116370","confirmation_number":"SJ12693706099","room_stay_from":"2021-07-03","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"330.48,308.88","nightly_discount":"0,0","subtotal":"639.36","grand_total":"719.28","paid_amount":"719.28","room_type_id":"319","product_id":"1301","siteminder_id":"BDC-2617703489","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":"123237","customer_id":"123237","source_of_creation":"Booking.com","reservation_created_date":"2021-06-02 02:29:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"124.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"308.88","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3265412","reservation_id":"116934","confirmation_number":"SJ12612705485","room_stay_from":"2021-07-04","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"360.40","nightly_discount":"0","subtotal":"360.40","grand_total":"405.45","paid_amount":"405.45","room_type_id":"413","product_id":"1273","siteminder_id":"BDC-2721808136","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":"123862","customer_id":"123862","source_of_creation":"Booking.com","reservation_created_date":"2021-06-10 12:36:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","ota_service_fee_amount":"0","commision_charges":"69.37","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"360.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":"3265645","reservation_id":"115661","confirmation_number":"SJ12671474468","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"242.39,242.39,242.39","nightly_discount":"0,0,0","subtotal":"727.17","grand_total":"818.07","paid_amount":"818.07","room_type_id":"413","product_id":"1266","siteminder_id":"BDC-3177912099","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":"122426","customer_id":"122426","source_of_creation":"Booking.com","reservation_created_date":"2021-05-22 03:17:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"144.39","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"242.39","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":"3272391","reservation_id":"112984","confirmation_number":"SJ12622791746","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"270.5,270.5,240.5","nightly_discount":"0,0,0","subtotal":"781.50","grand_total":"879.19","paid_amount":"879.19","room_type_id":"319","product_id":"1308","siteminder_id":"BDC-2597882183","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119568","customer_id":"119568","source_of_creation":"Booking.com","reservation_created_date":"2021-04-14 18:38:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"167.67","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"240.5","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":"3277030","reservation_id":"118560","confirmation_number":"SJ12687813182","room_stay_from":"2021-07-03","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"308.88,308.88","nightly_discount":"0,0","subtotal":"617.76","grand_total":"694.98","paid_amount":"694.98","room_type_id":"413","product_id":"1269","siteminder_id":"BDC-3783709700","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":"125601","customer_id":"125601","source_of_creation":"Booking.com","reservation_created_date":"2021-07-02 19:30:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","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","group_rooms":null,"currentDayPrice":"308.88","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3277038","reservation_id":"118562","confirmation_number":"SJ12694549471","room_stay_from":"2021-07-03","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"383.20,383.20","nightly_discount":"0,0","subtotal":"766.40","grand_total":"862.20","paid_amount":"862.20","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-2272525289","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":"125603","customer_id":"125603","source_of_creation":"Booking.com","reservation_created_date":"2021-07-02 19:36:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"146.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"383.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":"3233520","reservation_id":"112404","confirmation_number":"SJ12660249731","room_stay_from":"2021-07-01","room_stay_to":"2021-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"195.30,230.30,230.30,230.30,160.30","nightly_discount":"0,0,0,0,0","subtotal":"1046.50","grand_total":"1177.32","paid_amount":"1177.32","room_type_id":"412","product_id":"1316","siteminder_id":"BDC-3214038580","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":"118977","customer_id":"118977","source_of_creation":"Booking.com","reservation_created_date":"2021-04-07 23:53:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"210.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239795","reservation_id":"113637","confirmation_number":"SJ12674197856","room_stay_from":"2021-07-04","room_stay_to":"2021-07-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"261.3,191.3,170.3,170.3","nightly_discount":"0,0,0,0","subtotal":"793.20","grand_total":"892.35","paid_amount":"892.35","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3023421956","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"120235","customer_id":"120235","source_of_creation":"Booking.com","reservation_created_date":"2021-04-22 17:54:09","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"178.78","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"261.3","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3278552","reservation_id":"115857","confirmation_number":"SJ12612004539","room_stay_from":"2021-10-05","room_stay_to":"2021-10-12","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"115.67,115.67,115.67,155.36,155.36,115.67,115.67","nightly_discount":"0,0,0,0,0,0,0","subtotal":"889.07","grand_total":"1000.20","paid_amount":"130.13","room_type_id":"319","product_id":"1943","siteminder_id":"BDC-2445274349","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":"122640","customer_id":"122640","source_of_creation":"Booking.com","reservation_created_date":"2021-05-25 16:11:24","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3189904","reservation_id":"106713","confirmation_number":"SJ12694096771","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.40,179.40,179.40","nightly_discount":"0,0,0","subtotal":"538.20","grand_total":"605.48","paid_amount":"605.48","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1734575279","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":"113136","customer_id":"113136","source_of_creation":"Expedia","reservation_created_date":"2021-02-02 02:21:17","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":"179.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3215353","reservation_id":"110253","confirmation_number":"SJ12656119910","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"8","room_stay_child_count":"0","nightly_price":"199.4,199.4,199.4","nightly_discount":"0,0,0","subtotal":"598.20","grand_total":"672.98","paid_amount":"672.98","room_type_id":"320","product_id":"1324","siteminder_id":"EXP-1747370366","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"300.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116771","customer_id":"116771","source_of_creation":"Expedia","reservation_created_date":"2021-03-14 02:47:08","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 220+221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":"1271,1272","currentDayPrice":"199.4","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3272395","reservation_id":"106703","confirmation_number":"SJ12664760158","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.40,179.40,179.40","nightly_discount":"0,0,0","subtotal":"538.20","grand_total":"605.48","paid_amount":"605.48","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1734546229","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":"113123","customer_id":"113123","source_of_creation":"Expedia","reservation_created_date":"2021-02-02 00:31:05","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"107.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"179.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3272432","reservation_id":"111666","confirmation_number":"SJ12610771285","room_stay_from":"2021-06-30","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.30,195.30,230.30,230.30,230.30","nightly_discount":"0,0,0,0,0","subtotal":"1067.50","grand_total":"1200.94","paid_amount":"1200.94","room_type_id":"319","product_id":"1943","siteminder_id":"EXP-1753740236","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":"118222","customer_id":"118222","source_of_creation":"Expedia","reservation_created_date":"2021-03-30 04:17: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":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3275567","reservation_id":"116320","confirmation_number":"SJ12698711157","room_stay_from":"2021-07-04","room_stay_to":"2021-07-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":"1261","siteminder_id":"EXP-1778887994","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":"123183","customer_id":"123183","source_of_creation":"Expedia","reservation_created_date":"2021-06-01 16:01:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"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":"3275821","reservation_id":"114161","confirmation_number":"SJ12696477051","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"299.25,299.25,269.25","nightly_discount":"0.00,0.00,0.00","subtotal":"867.75","grand_total":"976.22","paid_amount":"976.22","room_type_id":"319","product_id":"1307","siteminder_id":"EXP-1765179203","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":"120793","customer_id":"120793","source_of_creation":"Expedia","reservation_created_date":"2021-04-29 18:55:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 414","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"269.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3277606","reservation_id":"117726","confirmation_number":"SJ12658407564","room_stay_from":"2021-07-04","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"312.12","nightly_discount":"0","subtotal":"312.12","grand_total":"351.14","paid_amount":"351.14","room_type_id":"319","product_id":"1305","siteminder_id":"EXP-1788506983","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":"124702","customer_id":"124702","source_of_creation":"Expedia","reservation_created_date":"2021-06-20 22:21:10","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":"312.12","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":"3276913","reservation_id":"118509","confirmation_number":"SJ12634267395","room_stay_from":"2021-07-03","room_stay_to":"2021-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"305.40,305.40,245.40","nightly_discount":"0,0,0","subtotal":"856.20","grand_total":"963.23","paid_amount":"963.23","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1794491390","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":"125546","customer_id":"125546","source_of_creation":"Expedia","reservation_created_date":"2021-07-02 03:11:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"305.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":"3278320","reservation_id":"111778","confirmation_number":"SJ12618437004","room_stay_from":"2021-07-02","room_stay_to":"2021-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"265.50,265.50,265.50,265.50","nightly_discount":"0,0,0,0","subtotal":"1062.00","grand_total":"1194.75","paid_amount":"896.07","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1754362588","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":"118337","customer_id":"118337","source_of_creation":"Expedia","reservation_created_date":"2021-03-31 20:18:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"265.50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3269906","reservation_id":"117388","confirmation_number":"SJ12614070155","room_stay_from":"2021-07-04","room_stay_to":"2021-07-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"257.04,201.04,201.04,201.04","nightly_discount":"0,0,0,0","subtotal":"860.16","grand_total":"967.68","paid_amount":"967.68","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1786134557","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":"124350","customer_id":"124350","source_of_creation":"Expedia","reservation_created_date":"2021-06-16 01:41:36","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"257.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":"3246195","reservation_id":"107510","confirmation_number":"SJ12611940204","room_stay_from":"2021-07-02","room_stay_to":"2021-07-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.30,230.30,230.30,160.30,160.30,160.30,160.30,188.30","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1520.40","grand_total":"1710.45","paid_amount":"1710.45","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1737789981","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":"113966","customer_id":"113966","source_of_creation":"Expedia","reservation_created_date":"2021-02-13 15:37:10","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":"230.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[{"room_stay_id":"3269691","reservation_id":"117504","confirmation_number":"SJ12674667506","room_stay_from":"2021-07-04","room_stay_to":"2021-07-06","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"290.56,226.56","nightly_discount":"0,0","subtotal":"517.12","grand_total":"581.76","paid_amount":"581.76","room_type_id":"413","product_id":"1264","siteminder_id":"EXP-1787060772","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":"124465","customer_id":"124465","source_of_creation":"Expedia","reservation_created_date":"2021-06-17 20:16:18","service_canceled_date_time":"2021-07-05 02:20:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"126","deltaChange":"581.76","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":"3254119","reservation_id":"115249","confirmation_number":"SJ12690078104","room_stay_from":"2021-07-04","room_stay_to":"2021-07-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"231.23,177.33,123.43,123.43","nightly_discount":"0,0,0,0","subtotal":"655.42","grand_total":"737.35","paid_amount":"737.35","room_type_id":"319","product_id":"1313","siteminder_id":"GAM-R2519396206","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":"121956","customer_id":"121956","source_of_creation":"Getaroom.com","reservation_created_date":"2021-05-15 03:48:47","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"231.23","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":"3278273","reservation_id":"118349","confirmation_number":"SJ12690902311","room_stay_from":"2021-07-04","room_stay_to":"2021-07-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"368.84,373.32","nightly_discount":"0.00,0.00","subtotal":"742.16","grand_total":"860.07","paid_amount":"860.07","room_type_id":"413","product_id":"1265","siteminder_id":"ABB-HM8HSR53HX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"746.64","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125358","customer_id":"125358","source_of_creation":"Airbnb","reservation_created_date":"2021-06-29 21:43:14","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"21.96","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","currentDayPrice":"368.84","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]},{"room_stay_id":"3278523","reservation_id":"118644","confirmation_number":"SJ12673764918","room_stay_from":"2021-10-18","room_stay_to":"2021-10-20","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"182.58,182.58","nightly_discount":"0,0","subtotal":"365.16","grand_total":"422.82","paid_amount":"0.00","room_type_id":"319","product_id":"1756","siteminder_id":"ABB-HM8WXAZSNA","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"365.16","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125723","customer_id":"125723","source_of_creation":"Airbnb","reservation_created_date":"2021-07-04 03:22:15","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"10.74","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3235836","reservation_id":"113148","confirmation_number":"SJ12680242161","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"299.25,299.25,269.25","nightly_discount":"0.00,0.00,0.00","subtotal":"867.75","grand_total":"976.22","paid_amount":"976.22","room_type_id":"318","product_id":"1282","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"119735","customer_id":"119735","source_of_creation":"FE","reservation_created_date":"2021-04-16 23:13:42","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"269.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3243226","reservation_id":"111319","confirmation_number":"SJ12655918848","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75","nightly_discount":"0.00,0.00,0.00","subtotal":"740.25","grand_total":"832.78","paid_amount":"832.78","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117853","customer_id":"117853","source_of_creation":"FE","reservation_created_date":"2021-03-26 04:39:31","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 308","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3277126","reservation_id":"111174","confirmation_number":"SJ12633174915","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"246.75,246.75,246.75","nightly_discount":"0.00,0.00,0.00","subtotal":"740.25","grand_total":"832.78","paid_amount":"832.78","room_type_id":"319","product_id":"1309","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":"117706","customer_id":"117706","source_of_creation":"FE","reservation_created_date":"2021-03-24 15:01:21","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"246.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3277493","reservation_id":"117240","confirmation_number":"SJ12614300138","room_stay_from":"2021-07-04","room_stay_to":"2021-07-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":"1311","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":"124187","customer_id":"124187","source_of_creation":"FE","reservation_created_date":"2021-06-14 16:06:17","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"3228500","reservation_id":"111389","confirmation_number":"SJ12624192354","room_stay_from":"2021-07-03","room_stay_to":"2021-07-08","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"336.75,336.75,261.75,261.75,261.75","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1458.75","grand_total":"1641.10","paid_amount":"1641.10","room_type_id":"320","product_id":"1714","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"117937","customer_id":"117937","source_of_creation":"FE","reservation_created_date":"2021-03-26 23:45:09","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 318+319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1291,1711","currentDayPrice":"336.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3264585","reservation_id":"114211","confirmation_number":"SJ12677206487","room_stay_from":"2021-07-02","room_stay_to":"2021-07-08","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"318.00,318.00,288.00,194.25,171.75,171.75","nightly_discount":"15.90,15.90,14.40,9.71,8.59,8.59","subtotal":"1461.75","grand_total":"1562.24","paid_amount":"1562.24","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":"120848","customer_id":"120848","source_of_creation":"FE","reservation_created_date":"2021-04-30 16:22:49","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":"AAA","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"288.00","currentDayDiscount":"14.40","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3246203","reservation_id":"110281","confirmation_number":"SJ12628386307","room_stay_from":"2021-07-03","room_stay_to":"2021-07-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"246.75,246.75,246.75,246.75,246.75,246.75","nightly_discount":"0.00,0,0,0,0,0","subtotal":"1480.50","grand_total":"1665.57","paid_amount":"1665.57","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116794","customer_id":"116794","source_of_creation":"FE","reservation_created_date":"2021-03-14 16:47:49","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 333","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3272426","reservation_id":"117914","confirmation_number":"SJ12631315250","room_stay_from":"2021-07-04","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"390.15","nightly_discount":"0.00","subtotal":"390.15","grand_total":"438.92","paid_amount":"438.92","room_type_id":"319","product_id":"1312","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124898","customer_id":"124898","source_of_creation":"PMS","reservation_created_date":"2021-06-23 19:09:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"390.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":"3277216","reservation_id":"118575","confirmation_number":"SJ12623009306","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"390.15,390.15,390.15","nightly_discount":"0.00,0.00,0.00","subtotal":"1170.45","grand_total":"1316.75","paid_amount":"1316.75","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":"125622","customer_id":"125622","source_of_creation":"PMS","reservation_created_date":"2021-07-02 21:47:24","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":"390.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":"3277954","reservation_id":"118492","confirmation_number":"SJ12679215503","room_stay_from":"2021-07-03","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"367.00,367.00","nightly_discount":"0.00,0.00","subtotal":"734.00","grand_total":"825.75","paid_amount":"825.75","room_type_id":"319","product_id":"1916","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125529","customer_id":"125529","source_of_creation":"PMS","reservation_created_date":"2021-07-01 22:46:42","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"367.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":"3218203","reservation_id":"110518","confirmation_number":"SJ12626235102","room_stay_from":"2021-07-03","room_stay_to":"2021-07-10","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"268.00,268.00,268.00,268.00,268.00,268.00,268.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1876.00","grand_total":"2110.50","paid_amount":"2110.50","room_type_id":"320","product_id":"1322","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"116905","customer_id":"116905","source_of_creation":"PMS","reservation_created_date":"2021-03-17 15:40:06","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 216+217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":"1267,1268","currentDayPrice":"268.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":"3278360","reservation_id":"109341","confirmation_number":"SJ12664723833","room_stay_from":"2021-07-10","room_stay_to":"2021-07-14","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"400.00","grand_total":"450.00","paid_amount":"337.50","room_type_id":"319","product_id":"1314","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"115806","customer_id":"115806","source_of_creation":"PMS","reservation_created_date":"2021-03-04 15:35:09","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":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3278497","reservation_id":"117570","confirmation_number":"SJ12649718492","room_stay_from":"2021-07-14","room_stay_to":"2021-07-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"305.00","nightly_discount":"15.25","subtotal":"305.00","grand_total":"325.97","paid_amount":"297.87","room_type_id":"319","product_id":"1314","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123886","customer_id":"123886","source_of_creation":"PMS","reservation_created_date":"2021-06-18 21:05:58","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"AAA","sub_hotel_id":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3217400","reservation_id":"110537","confirmation_number":"SJ12647246127","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"88.38","room_type_id":"319","product_id":"1915","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-17 18:20:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"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":"3232871","reservation_id":"112722","confirmation_number":"SJ12627958942","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"1306","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-11 23:09:25","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":"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":"3233548","reservation_id":"111959","confirmation_number":"SJ12667344951","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"413","product_id":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-03 02:49:04","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","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":"3261844","reservation_id":"111960","confirmation_number":"SJ12633000890","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","room_stay_status":"Checked-In","room_stay_guest_count":"4","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":"260.01","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-03 02:50:27","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":"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":"3276335","reservation_id":"109554","confirmation_number":"SJ12627326086","room_stay_from":"2021-07-03","room_stay_to":"2021-07-06","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.67,86.67,86.67","nightly_discount":"0.00,0,0","subtotal":"260.01","grand_total":"260.01","paid_amount":"0.00","room_type_id":"319","product_id":"1917","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-06 03:15:30","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"86.67","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":"3233543","reservation_id":"111958","confirmation_number":"SJ12612718784","room_stay_from":"2021-07-02","room_stay_to":"2021-07-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"435.00","grand_total":"435.00","paid_amount":"435.00","room_type_id":"412","product_id":"1294","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-03 02:47:29","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3276088","reservation_id":"112723","confirmation_number":"SJ12688280417","room_stay_from":"2021-07-02","room_stay_to":"2021-07-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0,0,0,0","subtotal":"435.00","grand_total":"435.00","paid_amount":"140.63","room_type_id":"319","product_id":"1276","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-11 23:12:22","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"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":"3251006","reservation_id":"110706","confirmation_number":"SJ12639442693","room_stay_from":"2021-07-02","room_stay_to":"2021-07-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.85,109.85,109.85,109.85,109.85,109.85,109.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"769.00","grand_total":"769.00","paid_amount":"0.00","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"4","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","negotiatedName":"Interval International","reservation_created_date":"2021-03-19 14:39:44","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"109.85","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":"3233553","reservation_id":"109918","confirmation_number":"SJ12670433420","room_stay_from":"2021-07-03","room_stay_to":"2021-07-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1277","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-03-10 01:31:19","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3241012","reservation_id":"112343","confirmation_number":"SJ12682484427","room_stay_from":"2021-07-03","room_stay_to":"2021-07-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.00,87.00,87.00,87.00,87.00,87.00,87.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"609.00","grand_total":"609.00","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2021-04-07 15:54:57","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"87.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3251018","reservation_id":"111955","confirmation_number":"SJ12663206748","room_stay_from":"2021-07-03","room_stay_to":"2021-07-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.85,119.85,119.86,119.86,119.86,119.86,119.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"839.00","grand_total":"839.00","paid_amount":"0.00","room_type_id":"319","product_id":"1293","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-04-03 02:22:58","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":"0","group_rooms":null,"currentDayPrice":"119.85","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":"3215354","reservation_id":"110253","confirmation_number":"SJ12683420744","room_confirmation_number":"SJ12656119910","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","room_stay_status":"Active","nightly_price":"100,100,100","nightly_discount":"0.00,0.00,0.00","subtotal":"300.00","grand_total":"337.50","paid_amount":"337.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"116771","product_attribute_values":"extra_person#.00","reservation_created_date":"2021-03-14 02:47:08","reservation_modified_date_time":"2021-03-14 02:47:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116771","canceled_nights_data":"","posAmt_airbnb_taxpaid":"300.00","sub_hotel_id":"126","currentDayPrice":"100","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3233508","reservation_id":"112476","confirmation_number":"SJ12614838249","room_confirmation_number":"SJ12669647181","room_stay_from":"2021-07-01","room_stay_to":"2021-07-05","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":"119048","product_attribute_values":"extra_person#","reservation_created_date":"2021-04-13 00:32:18","reservation_modified_date_time":"2021-04-13 00:32:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119048","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":"3272393","reservation_id":"112984","confirmation_number":"SJ12682356427","room_confirmation_number":"SJ12622791746","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","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":"1777","service_quantity":"1","customer_traveller_id":"119568","product_attribute_values":"extra_person#","reservation_created_date":"2021-06-23 20:31:13","reservation_modified_date_time":"2021-06-23 20:31:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119568","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.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":"3275568","reservation_id":"116320","confirmation_number":"SJ12679276698","room_confirmation_number":"SJ12698711157","room_stay_from":"2021-07-04","room_stay_to":"2021-07-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":"123183","product_attribute_values":"extra_person#","reservation_created_date":"2021-06-29 22:32:54","reservation_modified_date_time":"2021-06-29 22:32:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123183","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":"3275822","reservation_id":"114161","confirmation_number":"SJ12610993562","room_confirmation_number":"SJ12696477051","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0,0,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"120793","product_attribute_values":"extra_person#.00","reservation_created_date":"2021-06-30 14:36:18","reservation_modified_date_time":"2021-06-30 14:36:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120793","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","currentDayPrice":"50","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3239796","reservation_id":"113637","confirmation_number":"SJ12624072487","room_confirmation_number":"SJ12674197856","room_stay_from":"2021-07-04","room_stay_to":"2021-07-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":"120235","product_attribute_values":"extra_person#.00","reservation_created_date":"2021-04-22 17:54:09","reservation_modified_date_time":"2021-04-22 17:54:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120235","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3189905","reservation_id":"106713","confirmation_number":"SJ12625239767","room_confirmation_number":"SJ12694096771","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"113136","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-02-02 02:21:17","reservation_modified_date_time":"2021-02-02 02:21:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113136","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":"3215355","reservation_id":"110253","confirmation_number":"SJ12687822697","room_confirmation_number":"SJ12656119910","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"116771","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-14 02:47:08","reservation_modified_date_time":"2021-03-14 02:47:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116771","canceled_nights_data":"","posAmt_airbnb_taxpaid":"300.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":"3217401","reservation_id":"110537","confirmation_number":"SJ12656073894","room_confirmation_number":"SJ12647246127","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"117050","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-17 18:20:10","reservation_modified_date_time":"2021-03-17 18:20:10","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":"3224416","reservation_id":"111572","confirmation_number":"SJ12687437878","room_confirmation_number":"SJ12697294787","room_stay_from":"2021-07-01","room_stay_to":"2021-07-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":"118130","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-29 03:21:09","reservation_modified_date_time":"2021-03-29 03:21:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118130","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":"3232872","reservation_id":"112722","confirmation_number":"SJ12642117367","room_confirmation_number":"SJ12627958942","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"119313","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-11 23:09:25","reservation_modified_date_time":"2021-04-11 23:09:25","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":"3233509","reservation_id":"112476","confirmation_number":"SJ12637629763","room_confirmation_number":"SJ12669647181","room_stay_from":"2021-07-01","room_stay_to":"2021-07-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":"119048","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-08 23:22:11","reservation_modified_date_time":"2021-04-13 00:32:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119048","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":"3233513","reservation_id":"112476","confirmation_number":"SJ12685225154","room_confirmation_number":"SJ12620609595","room_stay_from":"2021-07-01","room_stay_to":"2021-07-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":"119048","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-08 23:22:16","reservation_modified_date_time":"2021-04-13 00:32:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119048","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":"3233549","reservation_id":"111959","confirmation_number":"SJ12662749409","room_confirmation_number":"SJ12667344951","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"118521","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-03 02:49:04","reservation_modified_date_time":"2021-04-13 00:46:34","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":"3235837","reservation_id":"113148","confirmation_number":"SJ12684822047","room_confirmation_number":"SJ12680242161","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"119735","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-16 23:13:42","reservation_modified_date_time":"2021-04-16 23:13:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119735","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":"3243227","reservation_id":"111319","confirmation_number":"SJ12615939354","room_confirmation_number":"SJ12655918848","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"117853","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-26 04:39:31","reservation_modified_date_time":"2021-04-28 19:11:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117853","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":"3260770","reservation_id":"116370","confirmation_number":"SJ12672541161","room_confirmation_number":"SJ12693706099","room_stay_from":"2021-07-03","room_stay_to":"2021-07-05","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":"123237","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-02 02:29:09","reservation_modified_date_time":"2021-06-02 02:37:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123237","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":"3261846","reservation_id":"111960","confirmation_number":"SJ12655001669","room_confirmation_number":"SJ12633000890","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"118522","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-03 02:50:27","reservation_modified_date_time":"2021-06-04 15:33:10","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":"3265413","reservation_id":"116934","confirmation_number":"SJ12696380184","room_confirmation_number":"SJ12612705485","room_stay_from":"2021-07-04","room_stay_to":"2021-07-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":"123862","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-10 12:36:13","reservation_modified_date_time":"2021-06-10 22:33:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123862","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":"3265646","reservation_id":"115661","confirmation_number":"SJ12659506899","room_confirmation_number":"SJ12671474468","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"122426","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-22 03:17:10","reservation_modified_date_time":"2021-06-11 16:25:59","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122426","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":"3272394","reservation_id":"112984","confirmation_number":"SJ12650779275","room_confirmation_number":"SJ12622791746","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"119568","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-14 18:38:11","reservation_modified_date_time":"2021-06-23 20:31:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"119568","canceled_nights_data":"","posAmt_airbnb_taxpaid":"75.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":"3272397","reservation_id":"106703","confirmation_number":"SJ12668767805","room_confirmation_number":"SJ12664760158","room_stay_from":"2021-07-02","room_stay_to":"2021-07-05","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":"113123","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-02-02 00:31:05","reservation_modified_date_time":"2021-06-23 20:32:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113123","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":"3272427","reservation_id":"117914","confirmation_number":"SJ12658243675","room_confirmation_number":"SJ12631315250","room_stay_from":"2021-07-04","room_stay_to":"2021-07-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":"124898","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-23 19:09:10","reservation_modified_date_time":"2021-06-23 20:42:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124898","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":"3272433","reservation_id":"111666","confirmation_number":"SJ12634566415","room_confirmation_number":"SJ12610771285","room_stay_from":"2021-06-30","room_stay_to":"2021-07-05","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"118222","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-30 04:17:11","reservation_modified_date_time":"2021-06-23 20:43:24","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118222","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":"3275569","reservation_id":"116320","confirmation_number":"SJ12665711147","room_confirmation_number":"SJ12698711157","room_stay_from":"2021-07-04","room_stay_to":"2021-07-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":"123183","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-01 16:01:07","reservation_modified_date_time":"2021-06-29 22:32:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123183","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":"3275823","reservation_id":"114161","confirmation_number":"SJ12636045044","room_confirmation_number":"SJ12696477051","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"120793","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-29 18:55:11","reservation_modified_date_time":"2021-06-30 14:36:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120793","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":"3277031","reservation_id":"118560","confirmation_number":"SJ12626458651","room_confirmation_number":"SJ12687813182","room_stay_from":"2021-07-03","room_stay_to":"2021-07-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":"125601","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-02 19:30:10","reservation_modified_date_time":"2021-07-02 19:30:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125601","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":"3277039","reservation_id":"118562","confirmation_number":"SJ12694561199","room_confirmation_number":"SJ12694549471","room_stay_from":"2021-07-03","room_stay_to":"2021-07-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":"125603","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-02 19:36:13","reservation_modified_date_time":"2021-07-02 19:36:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125603","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":"3277128","reservation_id":"111174","confirmation_number":"SJ12625267443","room_confirmation_number":"SJ12633174915","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"117706","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-24 15:01:21","reservation_modified_date_time":"2021-07-02 20:31:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117706","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":"3277217","reservation_id":"118575","confirmation_number":"SJ12628169130","room_confirmation_number":"SJ12623009306","room_stay_from":"2021-07-02","room_stay_to":"2021-07-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":"125622","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-02 21:47:24","reservation_modified_date_time":"2021-07-02 21:51:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125622","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":"3277494","reservation_id":"117240","confirmation_number":"SJ12672916053","room_confirmation_number":"SJ12614300138","room_stay_from":"2021-07-04","room_stay_to":"2021-07-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":"124187","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-14 16:06:17","reservation_modified_date_time":"2021-07-03 17:32:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124187","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":"3277607","reservation_id":"117726","confirmation_number":"SJ12613234293","room_confirmation_number":"SJ12658407564","room_stay_from":"2021-07-04","room_stay_to":"2021-07-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":"124702","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-20 22:21:10","reservation_modified_date_time":"2021-07-03 18:05:33","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124702","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":"3277956","reservation_id":"118492","confirmation_number":"SJ12687686203","room_confirmation_number":"SJ12679215503","room_stay_from":"2021-07-03","room_stay_to":"2021-07-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":"125529","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-01 22:46:42","reservation_modified_date_time":"2021-07-03 21:56:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125529","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":"3233522","reservation_id":"112404","confirmation_number":"SJ12671899671","room_confirmation_number":"SJ12660249731","room_stay_from":"2021-07-01","room_stay_to":"2021-07-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"118977","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-07 23:53:10","reservation_modified_date_time":"2021-04-13 00:37:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118977","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":"3276336","reservation_id":"109554","confirmation_number":"SJ12611483149","room_confirmation_number":"SJ12627326086","room_stay_from":"2021-07-03","room_stay_to":"2021-07-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":"116037","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-06 03:15:30","reservation_modified_date_time":"2021-07-01 14:47:16","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":"3276914","reservation_id":"118509","confirmation_number":"SJ12661344021","room_confirmation_number":"SJ12634267395","room_stay_from":"2021-07-03","room_stay_to":"2021-07-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":"125546","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-02 03:11:11","reservation_modified_date_time":"2021-07-02 18:19:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125546","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":"3278274","reservation_id":"118349","confirmation_number":"SJ12613942467","room_confirmation_number":"SJ12690902311","room_stay_from":"2021-07-04","room_stay_to":"2021-07-06","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"125358","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-29 21:43:14","reservation_modified_date_time":"2021-07-04 14:28:27","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125358","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":"3278321","reservation_id":"111778","confirmation_number":"SJ12683238013","room_confirmation_number":"SJ12618437004","room_stay_from":"2021-07-02","room_stay_to":"2021-07-06","room_stay_status":"Active","nightly_price":"25,25,25,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"118337","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-31 20:18:08","reservation_modified_date_time":"2021-07-04 15:17:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118337","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","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":"3233544","reservation_id":"111958","confirmation_number":"SJ12643239247","room_confirmation_number":"SJ12612718784","room_stay_from":"2021-07-02","room_stay_to":"2021-07-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"118520","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-03 02:47:29","reservation_modified_date_time":"2021-04-13 00:45:28","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":"3276089","reservation_id":"112723","confirmation_number":"SJ12672404193","room_confirmation_number":"SJ12688280417","room_stay_from":"2021-07-02","room_stay_to":"2021-07-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"119314","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-11 23:12:22","reservation_modified_date_time":"2021-06-30 20:56:48","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","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":"3228503","reservation_id":"111389","confirmation_number":"SJ12663986032","room_confirmation_number":"SJ12624192354","room_stay_from":"2021-07-03","room_stay_to":"2021-07-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"117937","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-26 23:45:09","reservation_modified_date_time":"2021-04-05 18:34:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117937","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":"3239797","reservation_id":"113637","confirmation_number":"SJ12667422985","room_confirmation_number":"SJ12674197856","room_stay_from":"2021-07-04","room_stay_to":"2021-07-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":"120235","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-22 17:54:09","reservation_modified_date_time":"2021-04-22 17:54:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120235","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":"3244988","reservation_id":"114211","confirmation_number":"SJ12629569760","room_confirmation_number":"SJ12677206487","room_stay_from":"2021-07-02","room_stay_to":"2021-07-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"120848","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-30 16:22:49","reservation_modified_date_time":"2021-04-30 16:22:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120848","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":"3254118","reservation_id":"115249","confirmation_number":"SJ12654453426","room_confirmation_number":"SJ12690078104","room_stay_from":"2021-07-04","room_stay_to":"2021-07-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":"121956","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-15 03:48:47","reservation_modified_date_time":"2021-05-19 16:24:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"121956","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":"3269905","reservation_id":"117388","confirmation_number":"SJ12623015040","room_confirmation_number":"SJ12614070155","room_stay_from":"2021-07-04","room_stay_to":"2021-07-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":"124350","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-16 01:41:36","reservation_modified_date_time":"2021-06-18 23:52:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124350","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":"3246204","reservation_id":"110281","confirmation_number":"SJ12660393502","room_confirmation_number":"SJ12628386307","room_stay_from":"2021-07-03","room_stay_to":"2021-07-09","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":"116794","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-14 16:47:49","reservation_modified_date_time":"2021-05-03 19:45:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116794","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":"3251005","reservation_id":"110706","confirmation_number":"SJ12671810479","room_confirmation_number":"SJ12639442693","room_stay_from":"2021-07-02","room_stay_to":"2021-07-09","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":"117216","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-19 14:39:44","reservation_modified_date_time":"2021-05-12 22:47:12","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":"3217270","reservation_id":"110518","confirmation_number":"SJ12685938598","room_confirmation_number":"SJ12626235102","room_stay_from":"2021-07-03","room_stay_to":"2021-07-10","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":"116905","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-17 15:40:06","reservation_modified_date_time":"2021-03-17 15:40:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116905","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":"3233554","reservation_id":"109918","confirmation_number":"SJ12688579204","room_confirmation_number":"SJ12670433420","room_stay_from":"2021-07-03","room_stay_to":"2021-07-10","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":"116410","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-10 01:31:19","reservation_modified_date_time":"2021-04-13 00:49:00","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":"3241013","reservation_id":"112343","confirmation_number":"SJ12636391552","room_confirmation_number":"SJ12682484427","room_stay_from":"2021-07-03","room_stay_to":"2021-07-10","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":"118912","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-07 15:54:57","reservation_modified_date_time":"2021-04-24 17:10:42","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":"3246196","reservation_id":"107510","confirmation_number":"SJ12639717308","room_confirmation_number":"SJ12611940204","room_stay_from":"2021-07-02","room_stay_to":"2021-07-10","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"225.00","paid_amount":"225.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"113966","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-02-13 15:37:10","reservation_modified_date_time":"2021-05-03 19:45:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"113966","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":"3251017","reservation_id":"111955","confirmation_number":"SJ12636429441","room_confirmation_number":"SJ12663206748","room_stay_from":"2021-07-03","room_stay_to":"2021-07-10","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":"118517","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-04-03 02:22:58","reservation_modified_date_time":"2021-05-12 22:47:13","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3278361","reservation_id":"109341","confirmation_number":"SJ12629484416","room_confirmation_number":"SJ12664723833","room_stay_from":"2021-07-10","room_stay_to":"2021-07-14","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"115806","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-04 15:35:09","reservation_modified_date_time":"2021-07-04 17:13:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115806","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3278498","reservation_id":"117570","confirmation_number":"SJ12620453228","room_confirmation_number":"SJ12649718492","room_stay_from":"2021-07-14","room_stay_to":"2021-07-15","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":"123886","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-18 21:05:58","reservation_modified_date_time":"2021-07-04 19:47:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123886","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3278524","reservation_id":"118644","confirmation_number":"SJ12639965671","room_confirmation_number":"SJ12673764918","room_stay_from":"2021-10-18","room_stay_to":"2021-10-20","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"125723","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-04 03:22:15","reservation_modified_date_time":"2021-07-04 20:02:52","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125723","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3278551","reservation_id":"115857","confirmation_number":"SJ12611425321","room_confirmation_number":"SJ12612004539","room_stay_from":"2021-10-05","room_stay_to":"2021-10-12","room_stay_status":"Active","nightly_price":"25,25,25,25,25,25,25","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":"122640","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-25 16:11:24","reservation_modified_date_time":"2021-07-04 20:06:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122640","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"126","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3278303","reservation_id":"114211","confirmation_number":"SJ12662271030","room_confirmation_number":"SJ12677206487","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":"0.00","product_id":"1663","service_quantity":"1","product_name":"10 lb Bag of Ice","parentTypeOfRes":"reservation","reservation_created_date":"2021-07-04 14:51:57","reservation_modified_date_time":"2021-07-04 14:51:57","customer_id":"120848","parentCustTravId":"120848","customer_traveller_id":"120848","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-07-02","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"}]},{"room_stay_id":"3278494","reservation_id":"110537","confirmation_number":"SJ12681665823","room_confirmation_number":"SJ12647246127","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"1.86","grand_total":"4.00","paid_amount":"0.00","product_id":"1660","service_quantity":"2","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2021-07-04 19:40:39","reservation_modified_date_time":"2021-07-04 19:40:39","customer_id":"82465","parentCustTravId":"82465","customer_traveller_id":"117050","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-07-02","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":[]}}