{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-03-05","total_rooms_exist":"1281,1282,1289,1274,1275,1276,1277,1278,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":15,"holdBlockRooms":{"hold_room_count":"1277","hold_room_bookings":[{"confirmation_number":"SJ12697964990","room_stay_from":"2020-03-03","room_stay_to":"2020-03-07","bundle_room":"0"}],"block_room_count":"1297,1942,1262,1313,1261,1943","block_room_bookings":[{"confirmation_number":"SJ12691276365","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","bundle_room":"0"},{"confirmation_number":"SJ12622180244","room_stay_from":"2020-02-29","room_stay_to":"2020-03-09","bundle_room":"0"},{"confirmation_number":"SJ12632788009","room_stay_from":"2019-12-20","room_stay_to":"2020-03-13","bundle_room":"0"},{"confirmation_number":"SJ12660283277","room_stay_from":"2020-03-02","room_stay_to":"2020-03-13","bundle_room":"0"},{"confirmation_number":"SJ12661352664","room_stay_from":"2020-03-04","room_stay_to":"2020-03-13","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-14","room_stay_to":"2020-03-27","bundle_room":"0"}],"bundle_block_count":"1271,1272,1267,1268,1304,1305,1262,1263,1291,1711,1311,1312,1309,1310,1260,1261,1307,1308,1269,1270","bundle_block_bookings":[{"confirmation_number":"SJB12652267379","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","bundle_room":"1"},{"confirmation_number":"SJB12654493168","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","bundle_room":"1"},{"confirmation_number":"SJB12641058412","room_stay_from":"2020-03-04","room_stay_to":"2020-03-06","bundle_room":"1"},{"confirmation_number":"SJB12625728885","room_stay_from":"2020-03-04","room_stay_to":"2020-03-06","bundle_room":"1"},{"confirmation_number":"SJB12695926063","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","bundle_room":"1"},{"confirmation_number":"SJB12651369654","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","bundle_room":"1"},{"confirmation_number":"SJB12620744296","room_stay_from":"2020-03-04","room_stay_to":"2020-03-06","bundle_room":"1"},{"confirmation_number":"SJB12671735907","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","bundle_room":"1"},{"confirmation_number":"SJB12684003462","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","bundle_room":"0"},{"confirmation_number":"SJB12690316105","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","bundle_room":"0"},{"confirmation_number":"SJB12699283429","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3065555","reservation_id":"91210","confirmation_number":"SJ12645618924","room_stay_from":"2020-03-04","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"161.10,161.10","nightly_discount":"0,0","subtotal":"322.20","grand_total":"362.48","paid_amount":"362.48","room_type_id":"413","product_id":"1268","siteminder_id":"BDC-2464934363","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":"97333","customer_id":"97333","source_of_creation":"Booking.com","reservation_created_date":"2020-02-03 15:57:17","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"34.06","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"161.10","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":"3067681","reservation_id":"90655","confirmation_number":"SJ12655152005","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00,179.00","nightly_discount":"0,0,0","subtotal":"537.00","grand_total":"604.13","paid_amount":"604.13","room_type_id":"413","product_id":"1270","siteminder_id":"BDC-3163101587","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":"96739","customer_id":"96739","source_of_creation":"Booking.com","reservation_created_date":"2020-01-26 21:33:12","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 219","ota_service_fee_amount":"0","commision_charges":"111.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.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":"3077542","reservation_id":"90552","confirmation_number":"SJ12657257104","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129,129,129","nightly_discount":"0,0,0","subtotal":"387.00","grand_total":"435.38","paid_amount":"435.38","room_type_id":"413","product_id":"1263","siteminder_id":"BDC-2493406546","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"150.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99086","customer_id":"99086","source_of_creation":"Booking.com","reservation_created_date":"2020-01-25 14:15:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 209","ota_service_fee_amount":"0","commision_charges":"111.84","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129","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":"3078143","reservation_id":"92317","confirmation_number":"SJ12689403620","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"216.75","nightly_discount":"0.00","subtotal":"216.75","grand_total":"243.85","paid_amount":"271.98","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-2456803141","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":"99160","customer_id":"99160","source_of_creation":"Booking.com","reservation_created_date":"2020-02-21 18:54:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"43.52","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"216.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3065614","reservation_id":"91185","confirmation_number":"SJ12631952695","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"111.1,143.5,143.5","nightly_discount":"0,0,0","subtotal":"398.10","grand_total":"447.87","paid_amount":"447.87","room_type_id":"319","product_id":"1286","siteminder_id":"BDC-2285543696","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"97309","customer_id":"97309","source_of_creation":"Booking.com","reservation_created_date":"2020-02-03 00:44:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"56.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.1","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":"3078067","reservation_id":"92535","confirmation_number":"SJ12663346009","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"272,325,325","nightly_discount":"0,0,0","subtotal":"922.00","grand_total":"1037.25","paid_amount":"1037.25","room_type_id":"319","product_id":"1319","siteminder_id":"BDC-2862401758","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"75.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98697","customer_id":"98697","source_of_creation":"Booking.com","reservation_created_date":"2020-02-25 09:21:08","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 435","ota_service_fee_amount":"0","commision_charges":"192.96","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"272","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":"3062006","reservation_id":"90653","confirmation_number":"SJ12637568288","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20","nightly_discount":"0","subtotal":"143.20","grand_total":"161.10","paid_amount":"161.10","room_type_id":"413","product_id":"1265","siteminder_id":"EXP-1630213545","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":"96737","customer_id":"96737","source_of_creation":"Expedia","reservation_created_date":"2020-01-26 21:23:07","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3063467","reservation_id":"90922","confirmation_number":"SJ12665724730","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1632254700","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":"97018","customer_id":"97018","source_of_creation":"Expedia","reservation_created_date":"2020-01-30 02:53:06","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":"179.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":"3065973","reservation_id":"91309","confirmation_number":"SJ12645696396","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20","nightly_discount":"0","subtotal":"143.20","grand_total":"161.10","paid_amount":"161.10","room_type_id":"413","product_id":"1267","siteminder_id":"EXP-1635535699","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":"97433","customer_id":"97433","source_of_creation":"Expedia","reservation_created_date":"2020-02-04 21:13:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 216","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":"3073951","reservation_id":"90415","confirmation_number":"SJ12669549930","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20","nightly_discount":"0.00","subtotal":"143.20","grand_total":"161.10","paid_amount":"161.10","room_type_id":"319","product_id":"1913","siteminder_id":"EXP-1628018936","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":"96456","customer_id":"96456","source_of_creation":"Expedia","reservation_created_date":"2020-01-23 06:17:17","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":"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":"3075786","reservation_id":"92296","confirmation_number":"SJ12630865644","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60","nightly_discount":"0","subtotal":"183.60","grand_total":"206.55","paid_amount":"206.55","room_type_id":"319","product_id":"1318","siteminder_id":"EXP-1645977812","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":"98479","customer_id":"98479","source_of_creation":"Expedia","reservation_created_date":"2020-02-21 15:08:09","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":"183.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"}]},{"room_stay_id":"3077005","reservation_id":"92848","confirmation_number":"SJ12693928580","room_stay_from":"2020-03-02","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"204.00,204.00,204.00,204.00","nightly_discount":"0,0,0,0","subtotal":"816.00","grand_total":"918.00","paid_amount":"918.00","room_type_id":"318","product_id":"1281","siteminder_id":"EXP-1651437482","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":"99000","customer_id":"99000","source_of_creation":"Expedia","reservation_created_date":"2020-03-02 02:19:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"204.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":"3078045","reservation_id":"90857","confirmation_number":"SJ12619820329","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","room_type_id":"319","product_id":"1915","siteminder_id":"EXP-1631862536","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":"99162","customer_id":"99162","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 14:28:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.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":"3055197","reservation_id":"86752","confirmation_number":"SJ12617303084","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"272.80,230.40,230.40,230.40,230.40,230.40,272.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1697.60","grand_total":"1909.80","paid_amount":"1909.80","room_type_id":"413","product_id":"1260","siteminder_id":"EXP-1375501820","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":"93421","customer_id":"93421","source_of_creation":"Expedia","reservation_created_date":"2019-11-06 16:30:10","canceled_nights_data":"","product_name":"Deluxe 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":"230.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3074664","reservation_id":"91639","confirmation_number":"SJ12664433543","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"205.20,223.20","nightly_discount":"0,0","subtotal":"428.40","grand_total":"481.95","paid_amount":"481.95","room_type_id":"319","product_id":"1711","siteminder_id":"EXP-1638329276","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":"97776","customer_id":"97776","source_of_creation":"Expedia","reservation_created_date":"2020-02-09 15:28:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 318","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"205.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":"3074667","reservation_id":"91955","confirmation_number":"SJ12632568471","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,187.20","nightly_discount":"0,0","subtotal":"356.40","grand_total":"400.95","paid_amount":"400.95","room_type_id":"412","product_id":"1866","siteminder_id":"EXP-1641315395","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":"98102","customer_id":"98102","source_of_creation":"Expedia","reservation_created_date":"2020-02-14 03:19:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 330","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"169.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":"3077765","reservation_id":"90494","confirmation_number":"SJ12697251388","room_stay_from":"2020-03-04","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"179.00,179.00,215.00","nightly_discount":"0,0,0","subtotal":"573.00","grand_total":"644.63","paid_amount":"644.63","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1628994775","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":"96550","customer_id":"96550","source_of_creation":"Expedia","reservation_created_date":"2020-01-24 15:34:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 416","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.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":"3077969","reservation_id":"92606","confirmation_number":"SJ12640410314","room_stay_from":"2020-03-04","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"183.60,183.60,201.60","nightly_discount":"0.00,0.00,0.00","subtotal":"568.80","grand_total":"639.90","paid_amount":"639.90","room_type_id":"412","product_id":"1294","siteminder_id":"EXP-1648992567","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":"98762","customer_id":"98762","source_of_creation":"Expedia","reservation_created_date":"2020-02-26 17:43:05","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite 326","ota_service_fee_amount":"0","commision_charges":"113.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"183.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":"3063434","reservation_id":"90907","confirmation_number":"SJ12651125833","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,172.00,172.00","nightly_discount":"0,0,0","subtotal":"487.20","grand_total":"548.10","paid_amount":"548.10","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1632159193","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":"97002","customer_id":"97002","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 23:38:09","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":"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":"3064014","reservation_id":"91023","confirmation_number":"SJ12689263523","room_stay_from":"2020-03-03","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.20,169.20,169.20,187.20,187.20","nightly_discount":"0,0,0,0,0","subtotal":"882.00","grand_total":"992.25","paid_amount":"992.25","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1633421734","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":"97130","customer_id":"97130","source_of_creation":"Expedia","reservation_created_date":"2020-02-01 01:03:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 226","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"169.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":"3067675","reservation_id":"91614","confirmation_number":"SJ12613875844","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.20,172.00,172.00","nightly_discount":"0,0,0","subtotal":"487.20","grand_total":"548.10","paid_amount":"548.10","room_type_id":"413","product_id":"1266","siteminder_id":"EXP-1638023693","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":"97751","customer_id":"97751","source_of_creation":"Expedia","reservation_created_date":"2020-02-08 22:28:06","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":"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"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3067635","reservation_id":"91624","confirmation_number":"SJ12687095070","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"156.09,172.69","nightly_discount":"0,0","subtotal":"328.78","grand_total":"369.88","paid_amount":"369.88","room_type_id":"319","product_id":"1288","siteminder_id":"HTN-118469557-2RLYYA","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":"97762","customer_id":"97762","source_of_creation":"HotelTonight","reservation_created_date":"2020-02-09 02:28:05","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":"156.09","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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3063484","reservation_id":"90930","confirmation_number":"SJ12682256303","room_stay_from":"2020-03-04","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00","nightly_discount":"0.00,0.00","subtotal":"358.00","grand_total":"402.75","paid_amount":"402.75","room_type_id":"413","product_id":"1272","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":"97027","customer_id":"97027","source_of_creation":"FE","reservation_created_date":"2020-01-30 13:30:40","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 221","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.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":"3077340","reservation_id":"92195","confirmation_number":"SJ12655913785","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,255.00,255.00","nightly_discount":"0.00,0.00,0.00","subtotal":"765.00","grand_total":"860.63","paid_amount":"860.63","room_type_id":"319","product_id":"1314","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98382","customer_id":"98382","source_of_creation":"FE","reservation_created_date":"2020-02-19 15:21:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 422","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"255.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":"3075599","reservation_id":"92707","confirmation_number":"SJ12662042316","room_stay_from":"2020-03-05","room_stay_to":"2020-03-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.00,280.00,280.00,255.00,255.00,255.00,255.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1835.00","grand_total":"2064.38","paid_amount":"2064.38","room_type_id":"319","product_id":"1312","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98852","customer_id":"98852","source_of_creation":"FE","reservation_created_date":"2020-02-28 04:13:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 419","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"255.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3071091","reservation_id":"91396","confirmation_number":"SJ12617075997","room_stay_from":"2020-03-04","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00,179.00","nightly_discount":"0.00,0.00","subtotal":"358.00","grand_total":"402.75","paid_amount":"402.75","room_type_id":"319","product_id":"1304","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":"97524","customer_id":"97524","source_of_creation":"PMS","reservation_created_date":"2020-02-06 01:36:32","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 410","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"179.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":"3072129","reservation_id":"92280","confirmation_number":"SJ12684781023","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"420.00,420.00","nightly_discount":"0.00,0.00","subtotal":"840.00","grand_total":"945.00","paid_amount":"945.00","room_type_id":"320","product_id":"1330","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":"98462","customer_id":"98462","source_of_creation":"PMS","reservation_created_date":"2020-02-21 02:03:37","canceled_nights_data":"","product_name":"Deluxe King Two Bedroom Suite 414+415","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"420.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":"3061652","reservation_id":"90576","confirmation_number":"SJ12694255640","room_stay_from":"2020-03-04","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"179.00,179.00,215.00,215.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"788.00","grand_total":"886.50","paid_amount":"886.50","room_type_id":"413","product_id":"1264","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96641","customer_id":"96641","source_of_creation":"PMS","reservation_created_date":"2020-01-25 18:36:03","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":"179.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"}]}],"pms_non_taxable":[{"room_stay_id":"3063607","reservation_id":"90536","confirmation_number":"SJ12678284131","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.71,160.71,160.71,160.71,160.72,160.72,160.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1125.00","grand_total":"1125.00","paid_amount":"0.00","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":"1","traveller_tax_exempt":"0","customer_traveller_id":"77106","customer_id":"77106","source_of_creation":"PMS","reservation_created_date":"2020-01-25 01:27:28","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":"160.72","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":"3068639","reservation_id":"91759","confirmation_number":"SJ12612193407","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","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","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":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-02-11 01:00:18","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":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3077913","reservation_id":"91761","confirmation_number":"SJ12683533919","room_stay_from":"2020-02-29","room_stay_to":"2020-03-05","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","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","room_type_id":"319","product_id":"1276","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":"81161","customer_id":"81161","source_of_creation":"PMS","reservation_created_date":"2020-02-11 01:04:41","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 228","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3077973","reservation_id":"90092","confirmation_number":"SJ12692020381","room_stay_from":"2020-02-29","room_stay_to":"2020-03-05","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","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","room_type_id":"319","product_id":"1278","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":"74797","customer_id":"74797","source_of_creation":"PMS","reservation_created_date":"2020-01-16 20:24:40","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 231","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":[{"room_stay_id":"3074364","reservation_id":"86398","confirmation_number":"SJ12650609805","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"127.62,127.62,127.62,127.62,127.62,127.62,127.62","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"893.34","grand_total":"1005.01","paid_amount":"196.88","room_type_id":"319","product_id":"1756","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"74459","customer_id":"74459","source_of_creation":"PMS","negotiatedName":"ICE","reservation_created_date":"2019-10-29 02:20:04","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":"","currentDayPrice":"127.62","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"}]}],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3077540","reservation_id":"90552","confirmation_number":"SJ12698606943","room_confirmation_number":"SJ12657257104","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0.00","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"99086","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-01-25 14:15:09","reservation_modified_date_time":"2020-03-03 22:38:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99086","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3061653","reservation_id":"90576","confirmation_number":"SJ12676537162","room_confirmation_number":"SJ12694255640","room_stay_from":"2020-03-04","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"25,25,25,25","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1777","service_quantity":"1","customer_traveller_id":"96641","product_attribute_values":"extra_person#&#25.00","reservation_created_date":"2020-01-25 18:36:03","reservation_modified_date_time":"2020-01-25 18:36:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96641","canceled_nights_data":"","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":"3065617","reservation_id":"91185","confirmation_number":"SJ12614578557","room_confirmation_number":"SJ12631952695","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"50,50,50","nightly_discount":"0.00,0.00,0","subtotal":"150.00","grand_total":"168.75","paid_amount":"168.75","product_id":"1777","service_quantity":"1","customer_traveller_id":"97309","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-02-03 18:08:01","reservation_modified_date_time":"2020-02-03 18:08:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97309","canceled_nights_data":"","currentDayPrice":"50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3078068","reservation_id":"92535","confirmation_number":"SJ12686524017","room_confirmation_number":"SJ12663346009","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"25,25,25","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1777","service_quantity":"1","customer_traveller_id":"98697","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-03-05 21:20:50","reservation_modified_date_time":"2020-03-05 21:20:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98697","canceled_nights_data":"","currentDayPrice":"25","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3062007","reservation_id":"90653","confirmation_number":"SJ12680765337","room_confirmation_number":"SJ12637568288","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","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":"96737","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-26 21:23:07","reservation_modified_date_time":"2020-01-26 21:23:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96737","canceled_nights_data":"","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":"3063468","reservation_id":"90922","confirmation_number":"SJ12680229920","room_confirmation_number":"SJ12665724730","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","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":"97018","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 02:53:06","reservation_modified_date_time":"2020-01-30 02:53:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97018","canceled_nights_data":"","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":"3063485","reservation_id":"90930","confirmation_number":"SJ12683511734","room_confirmation_number":"SJ12682256303","room_stay_from":"2020-03-04","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"97027","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 13:30:40","reservation_modified_date_time":"2020-01-30 13:30:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97027","canceled_nights_data":"","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":"3063608","reservation_id":"90536","confirmation_number":"SJ12691035339","room_confirmation_number":"SJ12678284131","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","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":"96598","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 01:27:28","reservation_modified_date_time":"2020-01-30 17:52:42","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"77106","canceled_nights_data":"","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":"3065556","reservation_id":"91210","confirmation_number":"SJ12630065547","room_confirmation_number":"SJ12645618924","room_stay_from":"2020-03-04","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0,0","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"97333","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-03 15:57:17","reservation_modified_date_time":"2020-02-03 15:57:17","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97333","canceled_nights_data":"","currentDayPrice":"25.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":"3065974","reservation_id":"91309","confirmation_number":"SJ12634664127","room_confirmation_number":"SJ12645696396","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","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":"97433","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-04 21:13:09","reservation_modified_date_time":"2020-02-04 21:13:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97433","canceled_nights_data":"","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":"3067682","reservation_id":"90655","confirmation_number":"SJ12677902218","room_confirmation_number":"SJ12655152005","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"96739","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-26 21:33:12","reservation_modified_date_time":"2020-02-09 12:10:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96739","canceled_nights_data":"","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":"3071093","reservation_id":"91396","confirmation_number":"SJ12666880680","room_confirmation_number":"SJ12617075997","room_stay_from":"2020-03-04","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"25.00,25.00","nightly_discount":"0.00,0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"97524","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-06 01:36:32","reservation_modified_date_time":"2020-02-18 18:17:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97524","canceled_nights_data":"","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":"3073952","reservation_id":"90415","confirmation_number":"SJ12630642013","room_confirmation_number":"SJ12669549930","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","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":"96456","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-23 06:17:17","reservation_modified_date_time":"2020-02-25 14:18:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96456","canceled_nights_data":"","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":"3074363","reservation_id":"86398","confirmation_number":"SJ12663775501","room_confirmation_number":"SJ12650609805","room_stay_from":"2020-02-28","room_stay_to":"2020-03-06","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":"95414","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-29 02:20:04","reservation_modified_date_time":"2020-02-25 23:12:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"74459","canceled_nights_data":"","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":"3075787","reservation_id":"92296","confirmation_number":"SJ12696873426","room_confirmation_number":"SJ12630865644","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","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":"98479","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-21 15:08:09","reservation_modified_date_time":"2020-02-28 19:31:33","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98479","canceled_nights_data":"","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":"3077006","reservation_id":"92848","confirmation_number":"SJ12699511033","room_confirmation_number":"SJ12693928580","room_stay_from":"2020-03-02","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"99000","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-03-02 02:19:12","reservation_modified_date_time":"2020-03-02 02:19:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99000","canceled_nights_data":"","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":"3077341","reservation_id":"92195","confirmation_number":"SJ12649677517","room_confirmation_number":"SJ12655913785","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"98382","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-19 15:21:10","reservation_modified_date_time":"2020-03-03 12:40:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98382","canceled_nights_data":"","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":"3077541","reservation_id":"90552","confirmation_number":"SJ12635717314","room_confirmation_number":"SJ12657257104","room_stay_from":"2020-03-03","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"99086","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 14:15:09","reservation_modified_date_time":"2020-03-03 22:38:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99086","canceled_nights_data":"","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":"3078044","reservation_id":"90857","confirmation_number":"SJ12624132852","room_confirmation_number":"SJ12619820329","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","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":"99162","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 14:28:11","reservation_modified_date_time":"2020-03-05 19:38:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99162","canceled_nights_data":"","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":"3078144","reservation_id":"92317","confirmation_number":"SJ12649333299","room_confirmation_number":"SJ12689403620","room_stay_from":"2020-03-05","room_stay_to":"2020-03-06","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"99160","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-21 18:54:07","reservation_modified_date_time":"2020-03-06 01:00:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99160","canceled_nights_data":"","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":"3055199","reservation_id":"86752","confirmation_number":"SJ12661253646","room_confirmation_number":"SJ12617303084","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"93421","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-11-06 16:30:10","reservation_modified_date_time":"2019-11-06 16:30:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93421","canceled_nights_data":"","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":"3067636","reservation_id":"91624","confirmation_number":"SJ12623844703","room_confirmation_number":"SJ12687095070","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","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":"97762","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 02:28:05","reservation_modified_date_time":"2020-02-09 02:28:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97762","canceled_nights_data":"","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":"3068640","reservation_id":"91759","confirmation_number":"SJ12618322882","room_confirmation_number":"SJ12612193407","room_stay_from":"2020-02-29","room_stay_to":"2020-03-07","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":"96904","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 01:00:18","reservation_modified_date_time":"2020-02-11 01:00:18","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","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":"3072130","reservation_id":"92280","confirmation_number":"SJ12690761059","room_confirmation_number":"SJ12684781023","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","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":"98462","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-21 02:03:37","reservation_modified_date_time":"2020-02-21 02:03:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98462","canceled_nights_data":"","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":"3074666","reservation_id":"91639","confirmation_number":"SJ12681597142","room_confirmation_number":"SJ12664433543","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","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":"97776","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-09 15:28:10","reservation_modified_date_time":"2020-02-26 16:33:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97776","canceled_nights_data":"","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":"3074668","reservation_id":"91955","confirmation_number":"SJ12626886177","room_confirmation_number":"SJ12632568471","room_stay_from":"2020-03-05","room_stay_to":"2020-03-07","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":"98102","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-14 03:19:10","reservation_modified_date_time":"2020-02-26 16:34:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98102","canceled_nights_data":"","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":"3077767","reservation_id":"90494","confirmation_number":"SJ12625949406","room_confirmation_number":"SJ12697251388","room_stay_from":"2020-03-04","room_stay_to":"2020-03-07","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"96550","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-24 15:34:11","reservation_modified_date_time":"2020-03-04 20:03:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96550","canceled_nights_data":"","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":"3077970","reservation_id":"92606","confirmation_number":"SJ12698272259","room_confirmation_number":"SJ12640410314","room_stay_from":"2020-03-04","room_stay_to":"2020-03-07","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":"98762","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-26 17:43:05","reservation_modified_date_time":"2020-03-05 14:38:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98762","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"-25.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":"3061654","reservation_id":"90576","confirmation_number":"SJ12631729997","room_confirmation_number":"SJ12694255640","room_stay_from":"2020-03-04","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"112.50","paid_amount":"112.50","product_id":"1776","service_quantity":"1","customer_traveller_id":"96641","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-25 18:36:03","reservation_modified_date_time":"2020-01-25 18:36:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96641","canceled_nights_data":"","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":"3063435","reservation_id":"90907","confirmation_number":"SJ12691492475","room_confirmation_number":"SJ12651125833","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","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":"97002","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 23:38:09","reservation_modified_date_time":"2020-01-29 23:38:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97002","canceled_nights_data":"","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":"3064015","reservation_id":"91023","confirmation_number":"SJ12613691427","room_confirmation_number":"SJ12689263523","room_stay_from":"2020-03-03","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"125.00","grand_total":"140.63","paid_amount":"140.63","product_id":"1776","service_quantity":"1","customer_traveller_id":"97130","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-01 01:03:07","reservation_modified_date_time":"2020-02-01 01:03:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97130","canceled_nights_data":"","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":"3065618","reservation_id":"91185","confirmation_number":"SJ12645908837","room_confirmation_number":"SJ12631952695","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"28.12,28.12,28.12","nightly_discount":"0.00,0.00,0","subtotal":"84.36","grand_total":"94.90","paid_amount":"94.90","product_id":"1776","service_quantity":"1","customer_traveller_id":"97309","product_attribute_values":"resort_fee#&#flat_rate#&#28.12","reservation_created_date":"2020-02-03 00:44:08","reservation_modified_date_time":"2020-02-03 18:08:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97309","canceled_nights_data":"","currentDayPrice":"28.12","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":"3067676","reservation_id":"91614","confirmation_number":"SJ12635995311","room_confirmation_number":"SJ12613875844","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0","subtotal":"75.00","grand_total":"84.38","paid_amount":"84.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"97751","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-08 22:28:06","reservation_modified_date_time":"2020-02-09 12:10:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97751","canceled_nights_data":"","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":"3078069","reservation_id":"92535","confirmation_number":"SJ12690470775","room_confirmation_number":"SJ12663346009","room_stay_from":"2020-03-05","room_stay_to":"2020-03-08","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":"98697","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-25 09:21:08","reservation_modified_date_time":"2020-03-05 21:20:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98697","canceled_nights_data":"","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":"3075600","reservation_id":"92707","confirmation_number":"SJ12630565147","room_confirmation_number":"SJ12662042316","room_stay_from":"2020-03-05","room_stay_to":"2020-03-12","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"196.88","paid_amount":"196.88","product_id":"1776","service_quantity":"1","customer_traveller_id":"98852","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-28 04:13:14","reservation_modified_date_time":"2020-02-28 04:13:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98852","canceled_nights_data":"","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":"3077914","reservation_id":"91761","confirmation_number":"SJ12647559783","room_confirmation_number":"SJ12683533919","room_stay_from":"2020-02-29","room_stay_to":"2020-03-05","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":"97903","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-02-11 01:04:41","reservation_modified_date_time":"2020-03-05 13:41:20","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"81161","canceled_nights_data":"","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":"3077974","reservation_id":"90092","confirmation_number":"SJ12690545263","room_confirmation_number":"SJ12692020381","room_stay_from":"2020-02-29","room_stay_to":"2020-03-05","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":"96124","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-16 20:24:40","reservation_modified_date_time":"2020-03-05 15:00:15","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","canceled_nights_data":"","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":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}