{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-11-25","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":12,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1866,1274,1942,1268,1297,1286,1307,1916","block_room_bookings":[{"confirmation_number":"SJ12649223434","room_stay_from":"2020-11-20","room_stay_to":"2020-11-26","bundle_room":"0"},{"confirmation_number":"SJ12630173663","room_stay_from":"2020-11-20","room_stay_to":"2020-11-26","bundle_room":"0"},{"confirmation_number":"SJ12689221751","room_stay_from":"2020-11-22","room_stay_to":"2020-11-26","bundle_room":"0"},{"confirmation_number":"SJ12644061864","room_stay_from":"2020-11-25","room_stay_to":"2020-11-27","bundle_room":"0"},{"confirmation_number":"SJ12699637883","room_stay_from":"2020-11-24","room_stay_to":"2020-11-30","bundle_room":"0"},{"confirmation_number":"SJ12624647364","room_stay_from":"2020-11-23","room_stay_to":"2020-12-01","bundle_room":"0"},{"confirmation_number":"SJ12676533150","room_stay_from":"2020-08-07","room_stay_to":"2020-12-02","bundle_room":"0"},{"confirmation_number":"SJ12648809896","room_stay_from":"2020-11-09","room_stay_to":"2020-12-19","bundle_room":"0"}],"bundle_block_count":"1271,1272,1267,1268,1304,1305,1309,1310,1269,1270,1302,1303,1291,1711,1260,1261,1262,1263,1307,1308","bundle_block_bookings":[{"confirmation_number":"SJB12660450085","room_stay_from":"2020-11-25","room_stay_to":"2020-11-26","bundle_room":"1"},{"confirmation_number":"SJB12657385599","room_stay_from":"2020-11-25","room_stay_to":"2020-11-26","bundle_room":"1"},{"confirmation_number":"SJB12650507785","room_stay_from":"2020-11-23","room_stay_to":"2020-11-27","bundle_room":"0"},{"confirmation_number":"SJB12699583204","room_stay_from":"2020-11-23","room_stay_to":"2020-11-27","bundle_room":"0"},{"confirmation_number":"SJB12642312964","room_stay_from":"2020-11-24","room_stay_to":"2020-11-27","bundle_room":"0"},{"confirmation_number":"SJB12679607135","room_stay_from":"2020-11-24","room_stay_to":"2020-11-27","bundle_room":"0"},{"confirmation_number":"SJB12688266823","room_stay_from":"2020-11-21","room_stay_to":"2020-11-28","bundle_room":"1"},{"confirmation_number":"SJB12633099317","room_stay_from":"2020-11-22","room_stay_to":"2020-11-28","bundle_room":"0"},{"confirmation_number":"SJB12688303935","room_stay_from":"2020-11-22","room_stay_to":"2020-11-28","bundle_room":"0"},{"confirmation_number":"SJB12655813480","room_stay_from":"2020-11-23","room_stay_to":"2020-11-28","bundle_room":"0"},{"confirmation_number":"SJB12658615362","room_stay_from":"2020-11-23","room_stay_to":"2020-11-28","bundle_room":"0"},{"confirmation_number":"SJB12698420412","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","bundle_room":"1"},{"confirmation_number":"SJB12695604038","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","bundle_room":"1"},{"confirmation_number":"SJB12624336456","room_stay_from":"2020-10-22","room_stay_to":"2020-12-02","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3158255","reservation_id":"102818","confirmation_number":"SJ12610058064","room_stay_from":"2020-11-25","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.58,163.18","nightly_discount":"0,0","subtotal":"301.76","grand_total":"339.48","paid_amount":"339.48","room_type_id":"319","product_id":"1308","siteminder_id":"BDC-2122789300","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":"108957","customer_id":"108957","source_of_creation":"Booking.com","reservation_created_date":"2020-11-18 20:15:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 415","ota_service_fee_amount":"0","commision_charges":"63.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"138.58","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":"3156758","reservation_id":"102339","confirmation_number":"SJ12650036074","room_stay_from":"2020-11-23","room_stay_to":"2020-11-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.16,108.16,108.16","nightly_discount":"0,0,0","subtotal":"324.48","grand_total":"365.04","paid_amount":"365.04","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1713925011","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":"108501","customer_id":"108501","source_of_creation":"Expedia","reservation_created_date":"2020-11-06 02:00:11","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":"108.16","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":"3155241","reservation_id":"102622","confirmation_number":"SJ12637746070","room_stay_from":"2020-11-21","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,127.00,127.00,127.00,127.00,149.00","nightly_discount":"0,0,0,0,0,0","subtotal":"836.00","grand_total":"940.50","paid_amount":"940.50","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1715910419","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":"108767","customer_id":"108767","source_of_creation":"Expedia","reservation_created_date":"2020-11-13 21:03:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 314","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"127.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":"3158758","reservation_id":"101833","confirmation_number":"SJ12660593724","room_stay_from":"2020-11-25","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.42,130.54","nightly_discount":"0,0","subtotal":"247.96","grand_total":"278.96","paid_amount":"278.96","room_type_id":"319","product_id":"1917","siteminder_id":"EXP-1710181937","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":"107929","customer_id":"107929","source_of_creation":"Expedia","reservation_created_date":"2020-10-22 11:33:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 402","ota_service_fee_amount":"0","commision_charges":"49.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.42","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":"3152803","reservation_id":"94387","confirmation_number":"SJ12636362871","room_stay_from":"2020-11-22","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,143.20,143.20,143.20,143.20,179.20","nightly_discount":"0,0,0,0,0,0","subtotal":"895.20","grand_total":"1007.10","paid_amount":"1007.10","room_type_id":"412","product_id":"1921","siteminder_id":"EXP-1662686104","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":"100601","customer_id":"100601","source_of_creation":"Expedia","reservation_created_date":"2020-05-03 17:47:08","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 430","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"143.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3100509","reservation_id":"95840","confirmation_number":"SJ12622883880","room_stay_from":"2020-11-25","room_stay_to":"2020-12-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.60,145.60,161.60,161.60,161.60,145.60,145.60,145.60,145.60","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"1358.40","grand_total":"1528.20","paid_amount":"1528.20","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1667650856","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":"109271","customer_id":"101997","source_of_creation":"Expedia","reservation_created_date":"2020-06-03 00:56:06","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"145.60","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":"3158319","reservation_id":"102848","confirmation_number":"SJ12613149848","room_stay_from":"2020-11-24","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"288.47,288.47,288.47","nightly_discount":"0,0,0","subtotal":"865.41","grand_total":"1122.59","paid_amount":"870.52","room_type_id":"320","product_id":"1910","siteminder_id":"ABB-HMN5SJMEPA","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"865.41","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108984","customer_id":"108984","source_of_creation":"Airbnb","reservation_created_date":"2020-11-19 18:20:10","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 416+417","ota_service_fee_amount":"0","commision_charges":"133.14","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"288.47","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3158466","reservation_id":"103118","confirmation_number":"SJ12662115810","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"230.23,230.23,230.23","nightly_discount":"0.00,0.00,0.00","subtotal":"690.69","grand_total":"895.95","paid_amount":"891.83","room_type_id":"319","product_id":"1314","siteminder_id":"ABB-HMJA4PXED4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"690.69","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109257","customer_id":"109257","source_of_creation":"Airbnb","reservation_created_date":"2020-11-25 15:47:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"106.26","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"230.23","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.59","abb_tax_paid_sm":"4.41"}]},{"room_stay_id":"3158630","reservation_id":"103133","confirmation_number":"SJ12694741431","room_stay_from":"2020-11-25","room_stay_to":"2020-12-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.16,160.16,160.16,160.16,160.16,160.16,160.16,160.16,160.16","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"1441.44","grand_total":"1869.85","paid_amount":"1861.20","room_type_id":"413","product_id":"1265","siteminder_id":"ABB-HMKCPSEKJQ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"1441.44","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109278","customer_id":"109278","source_of_creation":"Airbnb","reservation_created_date":"2020-11-25 20:58:06","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"221.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00","abb_tax_paid_pms":"0.60","abb_tax_paid_sm":"4.40"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3156949","reservation_id":"102936","confirmation_number":"SJ12693163561","room_stay_from":"2020-11-25","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"99.00,99.00,129.00,129.00","nightly_discount":"0,0,0,0","subtotal":"456.00","grand_total":"513.00","paid_amount":"513.00","room_type_id":"413","product_id":"1271","siteminder_id":"HWR-302895558","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":"109065","customer_id":"109065","source_of_creation":"Hotwire","reservation_created_date":"2020-11-21 16:07:19","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":[{"room_stay_id":"3155348","reservation_id":"102123","confirmation_number":"SJ12652494171","room_stay_from":"2020-11-23","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"263.20,263.20,263.20,293.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1082.80","grand_total":"1218.15","paid_amount":"1218.15","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":"108257","customer_id":"108257","source_of_creation":"FE","reservation_created_date":"2020-10-30 18:25:19","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":"263.20","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":"3149237","reservation_id":"101999","confirmation_number":"SJ12625032624","room_stay_from":"2020-11-24","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"167.20,167.20,183.20,231.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"748.80","grand_total":"842.40","paid_amount":"842.40","room_type_id":"319","product_id":"1275","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":"108114","customer_id":"108114","source_of_creation":"FE","reservation_created_date":"2020-10-27 19:36:16","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":"167.20","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":"3155246","reservation_id":"101743","confirmation_number":"SJ12667398379","room_stay_from":"2020-11-24","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"143.20,143.20,159.20,207.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"652.80","grand_total":"734.40","paid_amount":"734.40","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":"107836","customer_id":"107836","source_of_creation":"FE","reservation_created_date":"2020-10-19 21:42:16","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":"143.20","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":"3155720","reservation_id":"102787","confirmation_number":"SJ12649458856","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.20,183.20,215.20","nightly_discount":"0.00,0.00,0.00","subtotal":"557.60","grand_total":"627.30","paid_amount":"627.30","room_type_id":"319","product_id":"1301","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":"108927","customer_id":"108927","source_of_creation":"FE","reservation_created_date":"2020-11-17 22:44:48","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":"","currentDayPrice":"159.20","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":[{"room_stay_id":"3108330","reservation_id":"96909","confirmation_number":"SJ12630035390","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","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":"143.31","room_type_id":"318","product_id":"1281","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":"103027","customer_id":"103027","source_of_creation":"FE","reservation_created_date":"2020-06-21 18:25:06","service_canceled_date_time":"2020-11-01 14:58:16","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"143.31","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3155847","reservation_id":"102803","confirmation_number":"SJ12690268182","room_stay_from":"2020-11-23","room_stay_to":"2020-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.20,95.20,95.20,114.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"399.80","grand_total":"449.78","paid_amount":"449.78","room_type_id":"413","product_id":"1270","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":"108946","customer_id":"108946","source_of_creation":"PMS","reservation_created_date":"2020-11-18 14:16:08","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.20","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":"3156781","reservation_id":"102918","confirmation_number":"SJ12653728621","room_stay_from":"2020-11-22","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"255.20,255.20,255.20,279.20,311.20,311.20","nightly_discount":"25.52,25.52,25.52,27.92,31.12,31.12","subtotal":"1667.20","grand_total":"1688.04","paid_amount":"1688.04","room_type_id":"320","product_id":"1328","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":"109049","customer_id":"109049","source_of_creation":"PMS","reservation_created_date":"2020-11-20 23:52:53","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":"279.20","currentDayDiscount":"27.92","productIsTaxExempt":false,"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":"3158121","reservation_id":"100998","confirmation_number":"SJ12659853253","room_stay_from":"2020-11-23","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"279.20,279.20,279.20,279.20,299.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1415.80","grand_total":"1592.78","paid_amount":"1368.90","room_type_id":"320","product_id":"1714","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107037","customer_id":"107037","source_of_creation":"PMS","reservation_created_date":"2020-09-30 15:26:15","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":"279.20","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":"3158762","reservation_id":"103144","confirmation_number":"SJ12657993863","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.20,215.20,215.20","nightly_discount":"0.00,0.00,0.00","subtotal":"613.60","grand_total":"690.30","paid_amount":"690.30","room_type_id":"318","product_id":"1289","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":"109296","customer_id":"109296","source_of_creation":"PMS","reservation_created_date":"2020-11-26 02:33:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 316","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"183.20","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":"3158201","reservation_id":"102900","confirmation_number":"SJ12615733455","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"173.60,173.60,173.60,173.60,173.60","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"868.00","grand_total":"976.50","paid_amount":"976.50","room_type_id":"319","product_id":"1318","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"102312","customer_id":"102312","source_of_creation":"PMS","reservation_created_date":"2020-11-20 19:39:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 434","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"173.60","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":"3158764","reservation_id":"103144","confirmation_number":"SJ12696538752","room_stay_from":"2020-11-25","room_stay_to":"2020-11-29","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.20,215.20,215.20,215.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"828.80","grand_total":"932.40","paid_amount":"932.40","room_type_id":"319","product_id":"1287","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":"109296","customer_id":"109296","source_of_creation":"PMS","reservation_created_date":"2020-11-26 02:33:09","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":"183.20","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":"3150556","reservation_id":"102139","confirmation_number":"SJ12651340546","room_stay_from":"2020-11-22","room_stay_to":"2020-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.28,94.28,94.28,94.28,94.28,94.30,94.30","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"660.00","grand_total":"660.00","paid_amount":"0.00","room_type_id":"319","product_id":"1913","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-10-31 01:20:34","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":"94.28","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":"3158545","reservation_id":"101608","confirmation_number":"SJ12663927401","room_stay_from":"2020-11-21","room_stay_to":"2020-11-25","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.28,94.28,94.28,94.29","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"377.13","grand_total":"377.13","paid_amount":"0.00","room_type_id":"319","product_id":"1287","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"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-16 17:28:07","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":"","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":"3152182","reservation_id":"100952","confirmation_number":"SJ12694249915","room_stay_from":"2020-11-21","room_stay_to":"2020-11-28","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"545.02","grand_total":"545.02","paid_amount":"106.32","room_type_id":"413","product_id":"1263","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-09-29 00:00:30","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":"","currentDayPrice":"77.86","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":"3152224","reservation_id":"101515","confirmation_number":"SJ12655289739","room_stay_from":"2020-11-21","room_stay_to":"2020-11-28","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":"175.00","room_type_id":"413","product_id":"1269","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:28:24","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 218","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":"3156580","reservation_id":"100359","confirmation_number":"SJ12612731934","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Active","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":"0.00","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-09-14 00:29:41","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":"3158692","reservation_id":"99187","confirmation_number":"SJ12668022544","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","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":"45.57","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-08-17 20:26:06","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"}]},{"room_stay_id":"3152264","reservation_id":"101750","confirmation_number":"SJ12669388318","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","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":"1273","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-19 23:28:57","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":"","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":"3157960","reservation_id":"102754","confirmation_number":"SJ12695792026","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","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":"319","product_id":"1943","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-17 01:29:46","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 335","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3152282","reservation_id":"99188","confirmation_number":"SJ12669226988","room_stay_from":"2020-11-25","room_stay_to":"2020-11-30","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":"1260","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-08-17 20:34:25","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":"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":"3158688","reservation_id":"99526","confirmation_number":"SJ12660750856","room_stay_from":"2020-11-25","room_stay_to":"2020-11-30","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":"1261","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-26 00:08:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3158384","reservation_id":"100151","confirmation_number":"SJ12677292088","room_stay_from":"2020-11-21","room_stay_to":"2020-11-25","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.86,77.86,77.86,77.86","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"311.44","grand_total":"311.44","paid_amount":"545.02","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-09-09 00:31:18","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":"","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"}]},{"room_stay_id":"3158569","reservation_id":"102017","confirmation_number":"SJ12638197609","room_stay_from":"2020-11-22","room_stay_to":"2020-11-25","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00","subtotal":"234.00","grand_total":"234.00","paid_amount":"175.00","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-10-28 01:23:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 233","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3156759","reservation_id":"102339","confirmation_number":"SJ12647036228","room_confirmation_number":"SJ12650036074","room_stay_from":"2020-11-23","room_stay_to":"2020-11-26","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":"108501","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-06 02:00:11","reservation_modified_date_time":"2020-11-20 23:04:34","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108501","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":"3155242","reservation_id":"102622","confirmation_number":"SJ12672474881","room_confirmation_number":"SJ12637746070","room_stay_from":"2020-11-21","room_stay_to":"2020-11-27","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":"108767","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-13 21:03:11","reservation_modified_date_time":"2020-11-15 20:37:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108767","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":"3155351","reservation_id":"102123","confirmation_number":"SJ12629223543","room_confirmation_number":"SJ12652494171","room_stay_from":"2020-11-23","room_stay_to":"2020-11-27","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":"108257","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-30 18:25:19","reservation_modified_date_time":"2020-11-16 14:17:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108257","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":"3155848","reservation_id":"102803","confirmation_number":"SJ12610665311","room_confirmation_number":"SJ12690268182","room_stay_from":"2020-11-23","room_stay_to":"2020-11-27","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":"108946","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-18 14:16:08","reservation_modified_date_time":"2020-11-18 14:16:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108946","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":"3158256","reservation_id":"102818","confirmation_number":"SJ12654710480","room_confirmation_number":"SJ12610058064","room_stay_from":"2020-11-25","room_stay_to":"2020-11-27","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":"108957","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-18 20:15:07","reservation_modified_date_time":"2020-11-24 21:59:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108957","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":"3158322","reservation_id":"102848","confirmation_number":"SJ12626603063","room_confirmation_number":"SJ12613149848","room_stay_from":"2020-11-24","room_stay_to":"2020-11-27","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":"108984","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-19 18:20:10","reservation_modified_date_time":"2020-11-25 01:05:13","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108984","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":"3158759","reservation_id":"101833","confirmation_number":"SJ12699701146","room_confirmation_number":"SJ12660593724","room_stay_from":"2020-11-25","room_stay_to":"2020-11-27","room_stay_status":"Active","nightly_price":"25,25","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"107929","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-22 11:33:10","reservation_modified_date_time":"2020-11-26 00:55:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107929","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3149238","reservation_id":"101999","confirmation_number":"SJ12664849410","room_confirmation_number":"SJ12625032624","room_stay_from":"2020-11-24","room_stay_to":"2020-11-28","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":"108114","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-27 19:36:16","reservation_modified_date_time":"2020-10-27 19:36:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108114","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":"3152184","reservation_id":"100952","confirmation_number":"SJ12686353605","room_confirmation_number":"SJ12694249915","room_stay_from":"2020-11-21","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50,11.50,11.50","subtotal":"175.00","grand_total":"106.32","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"106985","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-29 00:00:30","reservation_modified_date_time":"2020-11-05 19:39:54","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":"3152226","reservation_id":"101515","confirmation_number":"SJ12672456298","room_confirmation_number":"SJ12655289739","room_stay_from":"2020-11-21","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50,11.50,11.50,11.50","subtotal":"175.00","grand_total":"106.32","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"107593","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-14 01:28:24","reservation_modified_date_time":"2020-11-05 19:44: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":"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":"3152804","reservation_id":"94387","confirmation_number":"SJ12622921078","room_confirmation_number":"SJ12636362871","room_stay_from":"2020-11-22","room_stay_to":"2020-11-28","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":"100601","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-05-03 17:47:08","reservation_modified_date_time":"2020-11-06 23:46:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100601","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":"3155247","reservation_id":"101743","confirmation_number":"SJ12621700859","room_confirmation_number":"SJ12667398379","room_stay_from":"2020-11-24","room_stay_to":"2020-11-28","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":"107836","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-19 21:42:16","reservation_modified_date_time":"2020-11-15 20:38:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107836","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":"3155721","reservation_id":"102787","confirmation_number":"SJ12668387412","room_confirmation_number":"SJ12649458856","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","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":"108927","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-17 22:44:48","reservation_modified_date_time":"2020-11-17 22:44:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108927","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":"3156581","reservation_id":"100359","confirmation_number":"SJ12629808508","room_confirmation_number":"SJ12612731934","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50","subtotal":"75.00","grand_total":"45.57","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105668","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-14 00:29:41","reservation_modified_date_time":"2020-11-20 17:42:02","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":"3156782","reservation_id":"102918","confirmation_number":"SJ12693527542","room_confirmation_number":"SJ12653728621","room_stay_from":"2020-11-22","room_stay_to":"2020-11-28","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":"109049","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-20 23:52:53","reservation_modified_date_time":"2020-11-20 23:52:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109049","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":"3158124","reservation_id":"100998","confirmation_number":"SJ12617720193","room_confirmation_number":"SJ12659853253","room_stay_from":"2020-11-23","room_stay_to":"2020-11-28","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":"107037","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-30 15:26:15","reservation_modified_date_time":"2020-11-24 18:13:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107037","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":"3158467","reservation_id":"103118","confirmation_number":"SJ12676999805","room_confirmation_number":"SJ12662115810","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","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":"109257","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-25 15:47:06","reservation_modified_date_time":"2020-11-25 16:51:42","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109257","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":"3158693","reservation_id":"99187","confirmation_number":"SJ12685019503","room_confirmation_number":"SJ12668022544","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50","subtotal":"75.00","grand_total":"45.57","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"105164","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-17 20:26:06","reservation_modified_date_time":"2020-11-25 23:30:04","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":"3158763","reservation_id":"103144","confirmation_number":"SJ12687442109","room_confirmation_number":"SJ12657993863","room_stay_from":"2020-11-25","room_stay_to":"2020-11-28","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":"109296","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-26 02:33:09","reservation_modified_date_time":"2020-11-26 02:33:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109296","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":"3150557","reservation_id":"102139","confirmation_number":"SJ12686986577","room_confirmation_number":"SJ12651340546","room_stay_from":"2020-11-22","room_stay_to":"2020-11-29","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":"108276","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-31 01:20:34","reservation_modified_date_time":"2020-10-31 01:32:47","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":"3152265","reservation_id":"101750","confirmation_number":"SJ12634241505","room_confirmation_number":"SJ12669388318","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","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":"107846","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-19 23:28:57","reservation_modified_date_time":"2020-11-05 19:54:28","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":"3156948","reservation_id":"102936","confirmation_number":"SJ12615839038","room_confirmation_number":"SJ12693163561","room_stay_from":"2020-11-25","room_stay_to":"2020-11-29","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109065","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-21 16:07:19","reservation_modified_date_time":"2020-11-21 16:18:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109065","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":"3157961","reservation_id":"102754","confirmation_number":"SJ12642522303","room_confirmation_number":"SJ12695792026","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","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":"108896","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-17 01:29:46","reservation_modified_date_time":"2020-11-24 13:53:01","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":"3158202","reservation_id":"102900","confirmation_number":"SJ12675310612","room_confirmation_number":"SJ12615733455","room_stay_from":"2020-11-24","room_stay_to":"2020-11-29","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":"102312","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-20 19:39:11","reservation_modified_date_time":"2020-11-24 20:18:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"102312","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":"3158765","reservation_id":"103144","confirmation_number":"SJ12641359377","room_confirmation_number":"SJ12696538752","room_stay_from":"2020-11-25","room_stay_to":"2020-11-29","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":"109296","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-26 02:33:09","reservation_modified_date_time":"2020-11-26 02:33:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109296","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":"3152284","reservation_id":"99188","confirmation_number":"SJ12616472676","room_confirmation_number":"SJ12669226988","room_stay_from":"2020-11-25","room_stay_to":"2020-11-30","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":"105166","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-17 20:34:25","reservation_modified_date_time":"2020-11-05 20:10:04","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":"3158691","reservation_id":"99526","confirmation_number":"SJ12676136717","room_confirmation_number":"SJ12660750856","room_stay_from":"2020-11-25","room_stay_to":"2020-11-30","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":"105166","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-08-26 00:08:07","reservation_modified_date_time":"2020-11-25 23:29: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":"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":"3100510","reservation_id":"95840","confirmation_number":"SJ12670769330","room_confirmation_number":"SJ12622883880","room_stay_from":"2020-11-25","room_stay_to":"2020-12-04","room_stay_status":"Active","nightly_price":"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","subtotal":"225.00","grand_total":"253.13","paid_amount":"253.13","product_id":"1776","service_quantity":"1","customer_traveller_id":"109271","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-06-03 00:56:06","reservation_modified_date_time":"2020-06-03 00:56:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"101997","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":"3158631","reservation_id":"103133","confirmation_number":"SJ12636214981","room_confirmation_number":"SJ12694741431","room_stay_from":"2020-11-25","room_stay_to":"2020-12-04","room_stay_status":"Active","nightly_price":"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","subtotal":"225.00","grand_total":"253.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"109278","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-11-25 20:58:06","reservation_modified_date_time":"2020-11-25 20:58:06","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109278","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","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":"3158385","reservation_id":"100151","confirmation_number":"SJ12644971002","room_confirmation_number":"SJ12677292088","room_stay_from":"2020-11-21","room_stay_to":"2020-11-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50,11.50","subtotal":"100.00","grand_total":"60.75","paid_amount":"106.32","product_id":"1776","service_quantity":"1","customer_traveller_id":"106169","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-09-09 00:31:18","reservation_modified_date_time":"2020-11-25 14:36:07","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3158548","reservation_id":"101608","confirmation_number":"SJ12664487046","room_confirmation_number":"SJ12663927401","room_stay_from":"2020-11-21","room_stay_to":"2020-11-25","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":"107687","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-16 17:28:07","reservation_modified_date_time":"2020-11-25 18:50:35","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"}]},{"room_stay_id":"3158570","reservation_id":"102017","confirmation_number":"SJ12648120042","room_confirmation_number":"SJ12638197609","room_stay_from":"2020-11-22","room_stay_to":"2020-11-25","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"11.50,11.50,11.50","subtotal":"75.00","grand_total":"45.57","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"108135","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-10-28 01:23:06","reservation_modified_date_time":"2020-11-25 19:49:30","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82465","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":"3158476","reservation_id":"102941","confirmation_number":"SJ12645181707","room_confirmation_number":"SJ12624288528","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.65","grand_total":"20.00","paid_amount":"20.00","product_id":"2073","service_quantity":"4","product_name":"Face Mask","parentTypeOfRes":"reservation","reservation_created_date":"2020-11-25 17:08:32","reservation_modified_date_time":"2020-11-25 17:08:32","customer_id":"109071","parentCustTravId":"109231","customer_traveller_id":"109231","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2020-11-24","currentDayPrice":"18.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3158480","reservation_id":"103121","confirmation_number":"SJ12687033550","room_confirmation_number":"SJ12656819433","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.65","grand_total":"5.00","paid_amount":"5.00","product_id":"2073","service_quantity":"1","product_name":"Face Mask","parentTypeOfRes":"reservation","reservation_created_date":"2020-11-25 17:20:36","reservation_modified_date_time":"2020-11-25 17:20:36","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.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"}]},{"room_stay_id":"3158491","reservation_id":"103124","confirmation_number":"SJ12631736775","room_confirmation_number":"SJ12632549614","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":"2.50","paid_amount":"2.50","product_id":"1660","service_quantity":"1","product_name":"Sundries","parentTypeOfRes":"reservation","reservation_created_date":"2020-11-25 17:40:20","reservation_modified_date_time":"2020-11-25 17:40:20","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":"2.33","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":[]}}