{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-12-18","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":5,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1274,1305,1307,1866","block_room_bookings":[{"confirmation_number":"SJ12637317516","room_stay_from":"2020-12-05","room_stay_to":"2020-12-23","bundle_room":"0"},{"confirmation_number":"SJ12643855812","room_stay_from":"2020-12-17","room_stay_to":"2020-12-24","bundle_room":"0"},{"confirmation_number":"SJ12676533150","room_stay_from":"2020-08-13","room_stay_to":"2020-12-27","bundle_room":"0"},{"confirmation_number":"SJ12649223434","room_stay_from":"2020-12-13","room_stay_to":"2021-01-04","bundle_room":"0"}],"bundle_block_count":"1262,1263,1302,1303,1304,1305,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12694888264","room_stay_from":"2020-12-15","room_stay_to":"2020-12-20","bundle_room":"1"},{"confirmation_number":"SJB12633000420","room_stay_from":"2020-12-17","room_stay_to":"2020-12-23","bundle_room":"0"},{"confirmation_number":"SJB12654323977","room_stay_from":"2020-12-17","room_stay_to":"2020-12-23","bundle_room":"0"},{"confirmation_number":"SJB12667782164","room_stay_from":"2020-12-17","room_stay_to":"2020-12-24","bundle_room":"1"},{"confirmation_number":"SJB12613550018","room_stay_from":"2020-10-22","room_stay_to":"2020-12-26","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3162982","reservation_id":"102688","confirmation_number":"SJ12637126603","room_stay_from":"2020-12-16","room_stay_to":"2020-12-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"161.28,161.28,211.68","nightly_discount":"0,0,0","subtotal":"534.24","grand_total":"601.02","paid_amount":"601.02","room_type_id":"412","product_id":"1315","siteminder_id":"BDC-3325577574","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":"108833","customer_id":"108833","source_of_creation":"Booking.com","reservation_created_date":"2020-11-15 04:13:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"109.66","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"211.68","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":"3166083","reservation_id":"102690","confirmation_number":"SJ12641303869","room_stay_from":"2020-12-17","room_stay_to":"2020-12-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"181.44,238.14","nightly_discount":"0,0","subtotal":"419.58","grand_total":"472.03","paid_amount":"472.03","room_type_id":"412","product_id":"1294","siteminder_id":"BDC-2235140059","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":"108835","customer_id":"108835","source_of_creation":"Booking.com","reservation_created_date":"2020-11-15 14:23:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"84.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"238.14","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":"3166088","reservation_id":"102810","confirmation_number":"SJ12683828745","room_stay_from":"2020-12-17","room_stay_to":"2020-12-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"236.16,280.96,280.96,261.76,261.76,261.76","nightly_discount":"0,0,0,0,0,0","subtotal":"1583.36","grand_total":"1781.28","paid_amount":"1781.28","room_type_id":"320","product_id":"1328","siteminder_id":"EXP-1717007477","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":"108953","customer_id":"108953","source_of_creation":"Expedia","reservation_created_date":"2020-11-18 15:33:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 408+409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"280.96","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":"3165648","reservation_id":"102609","confirmation_number":"SJ12697255638","room_stay_from":"2020-12-15","room_stay_to":"2020-12-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"161.25,161.25,161.25,161.25,156.41","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"801.41","grand_total":"1040.99","paid_amount":"1040.99","room_type_id":"413","product_id":"1263","siteminder_id":"ABB-HM5XAKRSBE","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"806.25","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108755","customer_id":"108755","source_of_creation":"Airbnb","reservation_created_date":"2020-11-13 16:54:11","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"124.04","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"161.25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"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":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3167107","reservation_id":"103941","confirmation_number":"SJ12623300382","room_stay_from":"2020-12-18","room_stay_to":"2020-12-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.65","nightly_discount":"0.00","subtotal":"160.65","grand_total":"180.73","paid_amount":"180.73","room_type_id":"319","product_id":"1319","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":"110236","customer_id":"110236","source_of_creation":"PMS","reservation_created_date":"2020-12-18 13:31:13","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.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":[{"room_stay_id":"3167062","reservation_id":"101083","confirmation_number":"SJ12676020743","room_stay_from":"2020-12-12","room_stay_to":"2020-12-18","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.72,100.72,100.72,100.71,100.71,100.71","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"604.29","grand_total":"604.29","paid_amount":"0.00","room_type_id":"412","product_id":"1316","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":"106240","customer_id":"106240","source_of_creation":"PMS","reservation_created_date":"2020-10-02 22:56:34","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 428","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"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"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[{"room_stay_id":"3162973","reservation_id":"102018","confirmation_number":"SJ12682575725","room_stay_from":"2020-12-12","room_stay_to":"2020-12-19","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,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"546.00","grand_total":"546.00","paid_amount":"196.88","room_type_id":"319","product_id":"1287","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":"109931","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-10-28 01:24:34","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":"","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":"3162993","reservation_id":"103546","confirmation_number":"SJ12658286568","room_stay_from":"2020-12-15","room_stay_to":"2020-12-20","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":"140.63","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-12-06 22:21:15","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":"","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":"3162995","reservation_id":"102413","confirmation_number":"SJ12614013986","room_stay_from":"2020-12-13","room_stay_to":"2020-12-20","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,78.00,78.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"546.00","grand_total":"546.00","paid_amount":"196.88","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":"2020-11-08 01:26:21","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":"","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":"3166781","reservation_id":"102623","confirmation_number":"SJ12639445218","room_stay_from":"2020-12-17","room_stay_to":"2020-12-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.34","nightly_discount":"0.00,0.00,0.00","subtotal":"235.00","grand_total":"235.00","paid_amount":"84.38","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-13 22:07:18","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]},{"room_stay_id":"3166783","reservation_id":"101517","confirmation_number":"SJ12666438070","room_stay_from":"2020-12-17","room_stay_to":"2020-12-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.34","nightly_discount":"0.00,0.00,0.00","subtotal":"235.00","grand_total":"235.00","paid_amount":"84.38","room_type_id":"413","product_id":"1264","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-10-14 01:31:46","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":"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"}]},{"room_stay_id":"3166785","reservation_id":"103375","confirmation_number":"SJ12635929176","room_stay_from":"2020-12-17","room_stay_to":"2020-12-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.33,78.33,78.34","nightly_discount":"0.00,0.00,0.00","subtotal":"235.00","grand_total":"235.00","paid_amount":"84.38","room_type_id":"413","product_id":"1262","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:47:51","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":"","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":"3162975","reservation_id":"102018","confirmation_number":"SJ12695736698","room_confirmation_number":"SJ12682575725","room_stay_from":"2020-12-12","room_stay_to":"2020-12-19","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":"108136","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-28 01:24:34","reservation_modified_date_time":"2020-12-08 02:13:55","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":"3162983","reservation_id":"102688","confirmation_number":"SJ12699840034","room_confirmation_number":"SJ12637126603","room_stay_from":"2020-12-16","room_stay_to":"2020-12-19","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":"108833","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-15 04:13:10","reservation_modified_date_time":"2020-12-08 02:15:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108833","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":"3166084","reservation_id":"102690","confirmation_number":"SJ12631754870","room_confirmation_number":"SJ12641303869","room_stay_from":"2020-12-17","room_stay_to":"2020-12-19","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":"108835","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-15 14:23:06","reservation_modified_date_time":"2020-12-17 12:55:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108835","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":"3167108","reservation_id":"103941","confirmation_number":"SJ12624813287","room_confirmation_number":"SJ12623300382","room_stay_from":"2020-12-18","room_stay_to":"2020-12-19","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":"110236","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-18 13:31:13","reservation_modified_date_time":"2020-12-18 21:27:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110236","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":"3162994","reservation_id":"103546","confirmation_number":"SJ12629520468","room_confirmation_number":"SJ12658286568","room_stay_from":"2020-12-15","room_stay_to":"2020-12-20","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":"109777","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-06 22:21:15","reservation_modified_date_time":"2020-12-08 02:17:24","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":"3162996","reservation_id":"102413","confirmation_number":"SJ12691749219","room_confirmation_number":"SJ12614013986","room_stay_from":"2020-12-13","room_stay_to":"2020-12-20","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":"108579","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-08 01:26:21","reservation_modified_date_time":"2020-12-08 02:18:06","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":"3165650","reservation_id":"102609","confirmation_number":"SJ12670992487","room_confirmation_number":"SJ12697255638","room_stay_from":"2020-12-15","room_stay_to":"2020-12-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"108755","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-13 16:54:11","reservation_modified_date_time":"2020-12-15 23:08:53","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108755","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":"3166782","reservation_id":"102623","confirmation_number":"SJ12655883559","room_confirmation_number":"SJ12639445218","room_stay_from":"2020-12-17","room_stay_to":"2020-12-20","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":"108769","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-13 22:07:18","reservation_modified_date_time":"2020-12-17 21:16:05","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":"3166784","reservation_id":"101517","confirmation_number":"SJ12689602568","room_confirmation_number":"SJ12666438070","room_stay_from":"2020-12-17","room_stay_to":"2020-12-20","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":"107595","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-14 01:31:46","reservation_modified_date_time":"2020-12-17 21:16:24","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":"3166786","reservation_id":"103375","confirmation_number":"SJ12628999977","room_confirmation_number":"SJ12635929176","room_stay_from":"2020-12-17","room_stay_to":"2020-12-20","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":"109553","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-12-02 00:47:51","reservation_modified_date_time":"2020-12-17 21:16:40","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":"3166091","reservation_id":"102810","confirmation_number":"SJ12654077483","room_confirmation_number":"SJ12683828745","room_stay_from":"2020-12-17","room_stay_to":"2020-12-23","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":"108953","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-18 15:33:10","reservation_modified_date_time":"2020-12-17 13:27:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108953","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":"3167063","reservation_id":"101083","confirmation_number":"SJ12678477530","room_confirmation_number":"SJ12676020743","room_stay_from":"2020-12-12","room_stay_to":"2020-12-18","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"107145","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-02 22:56:34","reservation_modified_date_time":"2020-12-18 20:12:37","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"106240","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":"3167225","reservation_id":"103975","confirmation_number":"SJ12656913922","room_confirmation_number":"SJ12646045672","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.33","grand_total":"5.00","paid_amount":"5.00","product_id":"1660","service_quantity":"2","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2020-12-19 04:20:33","reservation_modified_date_time":"2020-12-19 04:20:33","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":"4.66","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]}],"gift_shop_non_taxable":[{"room_stay_id":"3166911","reservation_id":"103939","confirmation_number":"SJ12632249584","room_confirmation_number":"SJ12665123099","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"300.00","grand_total":"300.00","paid_amount":"300.00","product_id":"1442","service_quantity":"1","product_name":"Gift Card","parentTypeOfRes":"reservation","reservation_created_date":"2020-12-18 12:49:21","reservation_modified_date_time":"2020-12-18 12:49:21","customer_id":"110234","parentCustTravId":"110234","customer_traveller_id":"110234","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":"0000-00-00","currentDayPrice":"300.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}