{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2021-01-05","total_rooms_exist":"1281,1282,1289,1274,1275,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":6,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1289","block_room_bookings":[{"confirmation_number":"SJ12615466762","room_stay_from":"2021-01-01","room_stay_to":"2021-01-26","bundle_room":"0"}],"bundle_block_count":"1262,1263,1304,1305","bundle_block_bookings":[{"confirmation_number":"SJB12629575418","room_stay_from":"2021-01-04","room_stay_to":"2021-01-06","bundle_room":"0"},{"confirmation_number":"SJB12639402812","room_stay_from":"2021-01-04","room_stay_to":"2021-01-06","bundle_room":"0"},{"confirmation_number":"SJB12683539544","room_stay_from":"2021-01-04","room_stay_to":"2021-01-08","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3172801","reservation_id":"104254","confirmation_number":"SJ12639274529","room_stay_from":"2021-01-02","room_stay_to":"2021-01-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.30,160.30,146.30,146.30","nightly_discount":"0,0,0,0","subtotal":"662.20","grand_total":"744.98","paid_amount":"744.98","room_type_id":"319","product_id":"1313","siteminder_id":"BDC-2180259947","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":"110603","customer_id":"110603","source_of_creation":"Booking.com","reservation_created_date":"2020-12-26 17:56:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 420","ota_service_fee_amount":"0","commision_charges":"137.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"146.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":"3173390","reservation_id":"104618","confirmation_number":"SJ12610205576","room_stay_from":"2021-01-04","room_stay_to":"2021-01-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.69,149.69,149.69,149.69","nightly_discount":"0,0,0,0","subtotal":"598.76","grand_total":"673.61","paid_amount":"673.61","room_type_id":"319","product_id":"1304","siteminder_id":"BDC-3610837424","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":"110973","customer_id":"110973","source_of_creation":"Booking.com","reservation_created_date":"2021-01-03 00:09:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"125.78","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"149.69","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3171833","reservation_id":"104417","confirmation_number":"SJ12678232848","room_stay_from":"2021-01-02","room_stay_to":"2021-01-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.44,128.24,117.04,117.04","nightly_discount":"0,0,0,0","subtotal":"529.76","grand_total":"595.98","paid_amount":"595.98","room_type_id":"319","product_id":"1942","siteminder_id":"EXP-1726210548","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":"110766","customer_id":"110766","source_of_creation":"Expedia","reservation_created_date":"2020-12-30 02:36:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 334","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"117.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":"3171841","reservation_id":"104418","confirmation_number":"SJ12690804482","room_stay_from":"2021-01-02","room_stay_to":"2021-01-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.44,128.24,117.04,117.04","nightly_discount":"0,0,0,0","subtotal":"529.76","grand_total":"595.98","paid_amount":"595.98","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1726210622","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":"110767","customer_id":"110767","source_of_creation":"Expedia","reservation_created_date":"2020-12-30 02:36:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"117.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":"3173508","reservation_id":"103314","confirmation_number":"SJ12685533445","room_stay_from":"2021-01-04","room_stay_to":"2021-01-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.24,212.24","nightly_discount":"0,0","subtotal":"424.48","grand_total":"477.54","paid_amount":"477.54","room_type_id":"320","product_id":"1321","siteminder_id":"EXP-1719772709","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":"109479","customer_id":"109479","source_of_creation":"Expedia","reservation_created_date":"2020-11-30 19:31:11","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 208+209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":"1262,1263","currentDayPrice":"212.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3174614","reservation_id":"104757","confirmation_number":"SJ12656627196","room_stay_from":"2021-01-09","room_stay_to":"2021-01-24","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"174.30,146.30,146.30,146.30,146.30,146.30,174.30,174.30,160.30,146.30,146.30,146.30,146.30,174.30,174.30","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"2348.50","grand_total":"2642.07","paid_amount":"196.09","room_type_id":"413","product_id":"1262","siteminder_id":"EXP-1727632162","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":"111110","customer_id":"111110","source_of_creation":"Expedia","reservation_created_date":"2021-01-05 03:51:41","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"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":"3174630","reservation_id":"104756","confirmation_number":"SJ12619440104","room_stay_from":"2021-01-11","room_stay_to":"2021-01-23","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.04,117.04,117.04,117.04,139.44,139.44,128.24,117.04,117.04,117.04,117.04,139.44","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1482.88","grand_total":"1668.24","paid_amount":"0.00","room_type_id":"413","product_id":"1263","siteminder_id":"EXP-1727623216","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":"111109","customer_id":"111109","source_of_creation":"Expedia","reservation_created_date":"2021-01-05 03:11:26","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":"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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3173555","reservation_id":"104363","confirmation_number":"SJ12634076352","room_stay_from":"2021-01-03","room_stay_to":"2021-01-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"223.89,223.89,223.89,218.52","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"890.19","grand_total":"1031.60","paid_amount":"1031.60","room_type_id":"319","product_id":"1306","siteminder_id":"ABB-HMQBJXW8JB","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"895.56","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110713","customer_id":"110713","source_of_creation":"Airbnb","reservation_created_date":"2020-12-29 03:21:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 413","ota_service_fee_amount":"0","commision_charges":"26.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"223.89","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":"3174365","reservation_id":"104761","confirmation_number":"SJ12616413834","room_stay_from":"2021-01-05","room_stay_to":"2021-01-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"191.76,191.76","nightly_discount":"2.28,0.00","subtotal":"383.52","grand_total":"441.80","paid_amount":"441.80","room_type_id":"319","product_id":"1915","siteminder_id":"ABB-HMTASJNPHX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"383.52","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111114","customer_id":"111114","source_of_creation":"Airbnb","reservation_created_date":"2021-01-05 07:01:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"11.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","currentDayPrice":"191.76","currentDayDiscount":"2.28","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":"3174312","reservation_id":"104534","confirmation_number":"SJ12629037735","room_stay_from":"2021-01-05","room_stay_to":"2021-01-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"191.76,191.76,191.76","nightly_discount":"3.45,0.00,0.00","subtotal":"575.28","grand_total":"662.68","paid_amount":"662.68","room_type_id":"413","product_id":"1264","siteminder_id":"ABB-HME4YMSZQW","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"575.28","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"110883","customer_id":"110883","source_of_creation":"Airbnb","reservation_created_date":"2021-01-01 20:00:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"16.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"currentDayPrice":"191.76","currentDayDiscount":"3.45","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":[{"room_stay_id":"3174195","reservation_id":"104735","confirmation_number":"SJ12647817183","room_stay_from":"2021-01-04","room_stay_to":"2021-01-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,119.00","nightly_discount":"0,0,0,0,0","subtotal":"515.00","grand_total":"579.38","paid_amount":"579.38","room_type_id":"413","product_id":"1266","siteminder_id":"HWR-303020578","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":"111091","customer_id":"111091","source_of_creation":"Hotwire","reservation_created_date":"2021-01-04 23:08:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3174187","reservation_id":"104497","confirmation_number":"SJ12638945988","room_stay_from":"2021-01-03","room_stay_to":"2021-01-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,119.00,119.00,99.00,99.00,99.00,99.00,99.00,119.00,119.00,99.00,99.00,99.00","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1763.00","grand_total":"1983.38","paid_amount":"1983.38","room_type_id":"319","product_id":"1301","siteminder_id":"HWR-303010168","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":"110851","customer_id":"110851","source_of_creation":"Hotwire","reservation_created_date":"2021-01-01 00:33:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 406","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"126","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3173437","reservation_id":"104451","confirmation_number":"SJ12669188249","room_stay_from":"2021-01-02","room_stay_to":"2021-01-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"238.15,174.65,159.65,159.65,159.65,159.65,190.65","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1242.05","grand_total":"1397.30","paid_amount":"1397.30","room_type_id":"413","product_id":"1273","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":"110804","customer_id":"110804","source_of_creation":"PMS","reservation_created_date":"2020-12-30 21:49:45","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 224","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":"159.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3173324","reservation_id":"103548","confirmation_number":"SJ12699284992","room_stay_from":"2021-01-03","room_stay_to":"2021-01-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0.00,0.00","subtotal":"339.99","grand_total":"339.99","paid_amount":"84.38","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":"2020-12-06 22:45:46","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":"113.33","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":"3170645","reservation_id":"99175","confirmation_number":"SJ12620584163","room_stay_from":"2021-01-04","room_stay_to":"2021-01-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.33,113.33,113.33","nightly_discount":"0.00,0.00,0.00","subtotal":"339.99","grand_total":"339.99","paid_amount":"84.38","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-08-17 19:21:13","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"113.33","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":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3171834","reservation_id":"104417","confirmation_number":"SJ12689283431","room_confirmation_number":"SJ12678232848","room_stay_from":"2021-01-02","room_stay_to":"2021-01-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"110766","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-30 02:36:11","reservation_modified_date_time":"2020-12-30 12:44:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110766","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3171842","reservation_id":"104418","confirmation_number":"SJ12676668399","room_confirmation_number":"SJ12690804482","room_stay_from":"2021-01-02","room_stay_to":"2021-01-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"110767","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-30 02:36:16","reservation_modified_date_time":"2020-12-30 12:45:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110767","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3172802","reservation_id":"104254","confirmation_number":"SJ12695102890","room_confirmation_number":"SJ12639274529","room_stay_from":"2021-01-02","room_stay_to":"2021-01-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"110603","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-26 17:56:07","reservation_modified_date_time":"2021-01-02 06:08:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110603","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3173325","reservation_id":"103548","confirmation_number":"SJ12662219486","room_confirmation_number":"SJ12699284992","room_stay_from":"2021-01-03","room_stay_to":"2021-01-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":"109782","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-06 22:45:46","reservation_modified_date_time":"2021-01-03 14:39:16","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3173511","reservation_id":"103314","confirmation_number":"SJ12631338654","room_confirmation_number":"SJ12685533445","room_stay_from":"2021-01-04","room_stay_to":"2021-01-06","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"109479","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-30 19:31:11","reservation_modified_date_time":"2021-01-03 19:09:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109479","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3170646","reservation_id":"99175","confirmation_number":"SJ12637914761","room_confirmation_number":"SJ12620584163","room_stay_from":"2021-01-04","room_stay_to":"2021-01-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105154","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-17 19:21:13","reservation_modified_date_time":"2020-12-26 23:46:09","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3173556","reservation_id":"104363","confirmation_number":"SJ12662407141","room_confirmation_number":"SJ12634076352","room_stay_from":"2021-01-03","room_stay_to":"2021-01-07","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110713","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-29 03:21:06","reservation_modified_date_time":"2021-01-03 20:39:38","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110713","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3174366","reservation_id":"104761","confirmation_number":"SJ12676533761","room_confirmation_number":"SJ12616413834","room_stay_from":"2021-01-05","room_stay_to":"2021-01-07","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":"111114","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 07:01:10","reservation_modified_date_time":"2021-01-05 14:04:49","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111114","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3173392","reservation_id":"104618","confirmation_number":"SJ12650761235","room_confirmation_number":"SJ12610205576","room_stay_from":"2021-01-04","room_stay_to":"2021-01-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":"110973","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-03 00:09:07","reservation_modified_date_time":"2021-01-03 15:55:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110973","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3174313","reservation_id":"104534","confirmation_number":"SJ12648511785","room_confirmation_number":"SJ12629037735","room_stay_from":"2021-01-05","room_stay_to":"2021-01-08","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"110883","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-01 20:00:08","reservation_modified_date_time":"2021-01-05 12:56:56","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110883","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3173438","reservation_id":"104451","confirmation_number":"SJ12674592597","room_confirmation_number":"SJ12669188249","room_stay_from":"2021-01-02","room_stay_to":"2021-01-09","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":"110804","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-30 21:49:45","reservation_modified_date_time":"2021-01-03 17:19:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110804","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3174196","reservation_id":"104735","confirmation_number":"SJ12644890767","room_confirmation_number":"SJ12647817183","room_stay_from":"2021-01-04","room_stay_to":"2021-01-09","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"111091","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-04 23:08:13","reservation_modified_date_time":"2021-01-04 23:08:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111091","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3174188","reservation_id":"104497","confirmation_number":"SJ12670070920","room_confirmation_number":"SJ12638945988","room_stay_from":"2021-01-03","room_stay_to":"2021-01-20","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"425.00","grand_total":"478.13","paid_amount":"478.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"110851","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-01 00:33:32","reservation_modified_date_time":"2021-01-04 22:50:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110851","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3174613","reservation_id":"104757","confirmation_number":"SJ12657525432","room_confirmation_number":"SJ12656627196","room_stay_from":"2021-01-09","room_stay_to":"2021-01-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"375.00","grand_total":"421.88","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111110","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 03:51:41","reservation_modified_date_time":"2021-01-05 19:47:33","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111110","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3174629","reservation_id":"104756","confirmation_number":"SJ12638018597","room_confirmation_number":"SJ12619440104","room_stay_from":"2021-01-11","room_stay_to":"2021-01-23","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"300.00","grand_total":"337.50","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"111109","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2021-01-05 03:11:26","reservation_modified_date_time":"2021-01-05 19:49:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111109","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3174567","reservation_id":"104795","confirmation_number":"SJ12691291597","room_confirmation_number":"SJ12671203922","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.30","grand_total":"20.00","paid_amount":"20.00","product_id":"1662","service_quantity":"2","product_name":"Extra Chair or Umbrella","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-05 18:50:06","reservation_modified_date_time":"2021-01-05 18:50:06","customer_id":"72187","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","currentDayPrice":"18.60","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":[]}}