{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-12-04","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":0,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1273,1269,1270,1271,1319,1274,1272,1866,1307","block_room_bookings":[{"confirmation_number":"SJ12654211568","room_stay_from":"2020-12-02","room_stay_to":"2020-12-05","bundle_room":"0"},{"confirmation_number":"SJ12684450120","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","bundle_room":"0"},{"confirmation_number":"SJ12687263701","room_stay_from":"2020-12-04","room_stay_to":"2020-12-08","bundle_room":"0"},{"confirmation_number":"SJ12693802597","room_stay_from":"2020-12-04","room_stay_to":"2020-12-08","bundle_room":"0"},{"confirmation_number":"SJ12674665601","room_stay_from":"2020-12-04","room_stay_to":"2020-12-08","bundle_room":"0"},{"confirmation_number":"SJ12637317516","room_stay_from":"2020-12-04","room_stay_to":"2020-12-10","bundle_room":"0"},{"confirmation_number":"SJ12642915532","room_stay_from":"2020-12-04","room_stay_to":"2020-12-12","bundle_room":"0"},{"confirmation_number":"SJ12649223434","room_stay_from":"2020-12-04","room_stay_to":"2020-12-13","bundle_room":"0"},{"confirmation_number":"SJ12676533150","room_stay_from":"2020-08-07","room_stay_to":"2020-12-20","bundle_room":"0"}],"bundle_block_count":"1260,1261,1267,1268,1309,1310,1311,1312,1269,1270,1304,1305,1291,1711,1271,1272,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12621874364","room_stay_from":"2020-12-03","room_stay_to":"2020-12-05","bundle_room":"1"},{"confirmation_number":"SJB12695369512","room_stay_from":"2020-12-02","room_stay_to":"2020-12-05","bundle_room":"1"},{"confirmation_number":"SJB12625475241","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","bundle_room":"0"},{"confirmation_number":"SJB12632210733","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","bundle_room":"0"},{"confirmation_number":"SJB12684058879","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","bundle_room":"0"},{"confirmation_number":"SJB12651093036","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","bundle_room":"0"},{"confirmation_number":"SJB12670774409","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","bundle_room":"1"},{"confirmation_number":"SJB12687937276","room_stay_from":"2020-12-02","room_stay_to":"2020-12-07","bundle_room":"0"},{"confirmation_number":"SJB12650941756","room_stay_from":"2020-12-02","room_stay_to":"2020-12-07","bundle_room":"0"},{"confirmation_number":"SJB12668229664","room_stay_from":"2020-12-03","room_stay_to":"2020-12-11","bundle_room":"0"},{"confirmation_number":"SJB12644763079","room_stay_from":"2020-12-03","room_stay_to":"2020-12-11","bundle_room":"0"},{"confirmation_number":"SJB12671742699","room_stay_from":"2020-12-04","room_stay_to":"2020-12-12","bundle_room":"1"},{"confirmation_number":"SJB12653450421","room_stay_from":"2020-10-22","room_stay_to":"2020-12-20","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[{"room_stay_id":"3080490","reservation_id":"92623","confirmation_number":"SJ12690384005","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"255.15","room_type_id":"319","product_id":"1274","siteminder_id":"BDC-3541088906","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":"98778","customer_id":"98778","source_of_creation":"Booking.com","reservation_created_date":"2020-02-26 22:45:07","service_canceled_date_time":"2020-08-23 17:06:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"58.28","deltaChange":"255.15","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3160969","reservation_id":"103365","confirmation_number":"SJ12686038130","room_stay_from":"2020-12-03","room_stay_to":"2020-12-11","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"192.64,231.84,231.84,192.64,192.64,192.64,192.64,192.64","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1619.52","grand_total":"1821.96","paid_amount":"1821.96","room_type_id":"320","product_id":"1714","siteminder_id":"EXP-1720081275","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":"109541","customer_id":"109541","source_of_creation":"Expedia","reservation_created_date":"2020-12-01 22:51: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":"","currentDayPrice":"231.84","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3161123","reservation_id":"103391","confirmation_number":"SJ12643345492","room_stay_from":"2020-12-02","room_stay_to":"2020-12-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.09,91.09,128.82","nightly_discount":"0,0,0","subtotal":"311.00","grand_total":"349.88","paid_amount":"349.88","room_type_id":"413","product_id":"1268","siteminder_id":"GAM-R2231293877","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":"109579","customer_id":"109579","source_of_creation":"Getaroom.com","reservation_created_date":"2020-12-02 14:31:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.82","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3154957","reservation_id":"102672","confirmation_number":"SJ12642939208","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"318.98,318.98","nightly_discount":"0.00,0.00","subtotal":"637.96","grand_total":"717.71","paid_amount":"717.71","room_type_id":"320","product_id":"1910","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":"108812","customer_id":"108812","source_of_creation":"FE","reservation_created_date":"2020-11-14 21:14:32","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"318.98","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":"3154961","reservation_id":"102672","confirmation_number":"SJ12645536448","room_stay_from":"2020-12-04","room_stay_to":"2020-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"318.98,318.98","nightly_discount":"0.00,0.00","subtotal":"637.96","grand_total":"717.71","paid_amount":"717.71","room_type_id":"320","product_id":"1332","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108812","customer_id":"108812","source_of_creation":"FE","reservation_created_date":"2020-11-14 21:14:33","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 418+419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"318.98","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3153841","reservation_id":"102499","confirmation_number":"SJ12675828638","room_stay_from":"2020-12-03","room_stay_to":"2020-12-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,183.50","nightly_discount":"0.00,0.00","subtotal":"313.50","grand_total":"352.69","paid_amount":"352.69","room_type_id":"413","product_id":"1260","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":"108692","customer_id":"108692","source_of_creation":"PMS","reservation_created_date":"2020-11-10 19:38:21","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":"","currentDayPrice":"183.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3160962","reservation_id":"103364","confirmation_number":"SJ12623907513","room_stay_from":"2020-12-03","room_stay_to":"2020-12-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.85,155.35","nightly_discount":"0.00,0.00","subtotal":"265.20","grand_total":"298.35","paid_amount":"298.35","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109539","customer_id":"109539","source_of_creation":"PMS","reservation_created_date":"2020-12-01 22:19:44","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"155.35","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":"3161911","reservation_id":"103494","confirmation_number":"SJ12621030121","room_stay_from":"2020-12-04","room_stay_to":"2020-12-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00","nightly_discount":"0.00","subtotal":"159.00","grand_total":"178.88","paid_amount":"178.88","room_type_id":"413","product_id":"1261","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109705","customer_id":"109705","source_of_creation":"PMS","reservation_created_date":"2020-12-05 00:16:48","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":"","currentDayPrice":"159.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":"3160800","reservation_id":"101484","confirmation_number":"SJ12635806097","room_stay_from":"2020-12-03","room_stay_to":"2020-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.28,201.00,201.00","nightly_discount":"0.00,0.00,0.00","subtotal":"545.28","grand_total":"613.44","paid_amount":"613.44","room_type_id":"412","product_id":"1315","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102182","customer_id":"102182","source_of_creation":"PMS","reservation_created_date":"2020-10-13 16:32:57","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"201.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":"3161250","reservation_id":"95969","confirmation_number":"SJ12684112674","room_stay_from":"2020-12-02","room_stay_to":"2020-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"238.88,238.88,238.88,238.88,238.88","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1194.40","grand_total":"1343.70","paid_amount":"1343.70","room_type_id":"320","product_id":"1329","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90934","customer_id":"90934","source_of_creation":"PMS","reservation_created_date":"2020-06-05 23:06:57","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 410+411","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"238.88","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"pms_non_taxable":[{"room_stay_id":"3156606","reservation_id":"102891","confirmation_number":"SJ12647173731","room_stay_from":"2020-12-04","room_stay_to":"2020-12-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.71,100.71,100.71,100.71,100.71,101.45,100.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"705.00","grand_total":"705.00","paid_amount":"0.00","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-11-20 18:33:16","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":"","currentDayPrice":"100.71","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":"3160802","reservation_id":"101870","confirmation_number":"SJ12673441154","room_stay_from":"2020-12-04","room_stay_to":"2020-12-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"750.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":"750.00","grand_total":"750.00","paid_amount":"0.00","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":"1","traveller_tax_exempt":"1","customer_traveller_id":"106240","customer_id":"106240","source_of_creation":"PMS","reservation_created_date":"2020-10-23 12:39:54","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":"","currentDayPrice":"750.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":"3159481","reservation_id":"97902","confirmation_number":"SJ12694200498","room_stay_from":"2020-11-28","room_stay_to":"2020-12-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"705.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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0,0,0","subtotal":"705.00","grand_total":"705.00","paid_amount":"0.00","room_type_id":"412","product_id":"1921","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-07-18 02:37:32","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":"","currentDayPrice":"0.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"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3161339","reservation_id":"103169","confirmation_number":"SJ12684358224","room_stay_from":"2020-12-01","room_stay_to":"2020-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"390.00","grand_total":"390.00","paid_amount":"75.94","room_type_id":"413","product_id":"1266","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-11-27 00:41:05","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":"","currentDayPrice":"78.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":"3161697","reservation_id":"103370","confirmation_number":"SJ12626445503","room_stay_from":"2020-12-04","room_stay_to":"2020-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.33","nightly_discount":"0.00,0.00,0.00","subtotal":"234.99","grand_total":"234.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-02 00:37:20","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":"","currentDayPrice":"78.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":"3153842","reservation_id":"102499","confirmation_number":"SJ12691208163","room_confirmation_number":"SJ12675828638","room_stay_from":"2020-12-03","room_stay_to":"2020-12-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":"108692","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-10 19:38:21","reservation_modified_date_time":"2020-11-10 19:38:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108692","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":"3160963","reservation_id":"103364","confirmation_number":"SJ12664751097","room_confirmation_number":"SJ12623907513","room_stay_from":"2020-12-03","room_stay_to":"2020-12-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":"109539","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-01 22:19:44","reservation_modified_date_time":"2020-12-01 22:19:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109539","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":"3161124","reservation_id":"103391","confirmation_number":"SJ12638242348","room_confirmation_number":"SJ12643345492","room_stay_from":"2020-12-02","room_stay_to":"2020-12-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":"109579","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-02 14:31:08","reservation_modified_date_time":"2020-12-02 14:36:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109579","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":"3161912","reservation_id":"103494","confirmation_number":"SJ12641824655","room_confirmation_number":"SJ12621030121","room_stay_from":"2020-12-04","room_stay_to":"2020-12-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":"109705","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-05 00:16:48","reservation_modified_date_time":"2020-12-05 00:16:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109705","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":"3154960","reservation_id":"102672","confirmation_number":"SJ12683172813","room_confirmation_number":"SJ12642939208","room_stay_from":"2020-12-04","room_stay_to":"2020-12-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":"108811","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-14 21:14:32","reservation_modified_date_time":"2020-11-14 21:52:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108812","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":"3154964","reservation_id":"102672","confirmation_number":"SJ12637667822","room_confirmation_number":"SJ12645536448","room_stay_from":"2020-12-04","room_stay_to":"2020-12-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":"1","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-14 21:14:33","reservation_modified_date_time":"2020-11-14 21:52:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108812","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":"3160801","reservation_id":"101484","confirmation_number":"SJ12685223377","room_confirmation_number":"SJ12635806097","room_stay_from":"2020-12-03","room_stay_to":"2020-12-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":"102182","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-13 16:32:57","reservation_modified_date_time":"2020-12-01 17:37:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102182","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":"3161341","reservation_id":"103169","confirmation_number":"SJ12658097691","room_confirmation_number":"SJ12684358224","room_stay_from":"2020-12-01","room_stay_to":"2020-12-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50","subtotal":"125.00","grand_total":"75.94","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109322","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-27 00:41:05","reservation_modified_date_time":"2020-12-03 01:13:26","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":"11.50","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3161253","reservation_id":"95969","confirmation_number":"SJ12642747200","room_confirmation_number":"SJ12684112674","room_stay_from":"2020-12-02","room_stay_to":"2020-12-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":"90934","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-05 23:06:57","reservation_modified_date_time":"2020-12-02 20:59:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90934","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":"3161698","reservation_id":"103370","confirmation_number":"SJ12678780095","room_confirmation_number":"SJ12626445503","room_stay_from":"2020-12-04","room_stay_to":"2020-12-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":"109548","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-02 00:37:20","reservation_modified_date_time":"2020-12-04 13:04:18","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":"3156607","reservation_id":"102891","confirmation_number":"SJ12661116767","room_confirmation_number":"SJ12647173731","room_stay_from":"2020-12-04","room_stay_to":"2020-12-11","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":"109024","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-20 18:33:16","reservation_modified_date_time":"2020-11-20 18:33:16","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","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"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3160970","reservation_id":"103365","confirmation_number":"SJ12614989322","room_confirmation_number":"SJ12686038130","room_stay_from":"2020-12-03","room_stay_to":"2020-12-11","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":"109541","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-01 22:51:09","reservation_modified_date_time":"2020-12-01 22:51:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109541","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":"3159482","reservation_id":"97902","confirmation_number":"SJ12635323915","room_confirmation_number":"SJ12694200498","room_stay_from":"2020-11-28","room_stay_to":"2020-12-12","room_stay_status":"Active","nightly_price":"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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"103969","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-07-18 02:37:32","reservation_modified_date_time":"2020-11-28 14:26:58","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","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"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3160803","reservation_id":"101870","confirmation_number":"SJ12690822009","room_confirmation_number":"SJ12673441154","room_stay_from":"2020-12-04","room_stay_to":"2020-12-11","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":"107974","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-23 12:39:54","reservation_modified_date_time":"2020-12-01 17:38:28","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"106240","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"0.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"}]}],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}