{"hotel_id":"126","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-31","total_rooms_exist":"1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1281,1282,1286,1287,1288,1289,1291,1293,1294,1296,1297,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1318,1319,1711,1756,1866,1913,1915,1916,1917,1918,1919,1920,1921,1922,1923,1942,1943","departureCount":11,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1923,1313,1920,1943,1922,1921,1919,1918,1262,1261,1270","block_room_bookings":[{"confirmation_number":"SJ12693730510","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12673593636","room_stay_from":"2019-11-09","room_stay_to":"2019-11-20","bundle_room":"0"},{"confirmation_number":"SJ12665324838","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12665142275","room_stay_from":"2020-01-03","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"SJ12657221101","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12648030950","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12638549225","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12632903645","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12632788009","room_stay_from":"2019-12-20","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"SJ12629964770","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","bundle_room":"0"},{"confirmation_number":"SJ12613532835","room_stay_from":"2019-12-18","room_stay_to":"2021-01-01","bundle_room":"0"}],"bundle_block_count":"1302,1303,1271,1272,1304,1305,1267,1268,1311,1312,1291,1711,1309,1310","bundle_block_bookings":[{"confirmation_number":"SJB12694069796","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","bundle_room":"1"},{"confirmation_number":"SJB12691850611","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","bundle_room":"1"},{"confirmation_number":"SJB12681316546","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","bundle_room":"1"},{"confirmation_number":"SJB12668082246","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","bundle_room":"1"},{"confirmation_number":"SJB12662007273","room_stay_from":"2020-01-31","room_stay_to":"2020-02-02","bundle_room":"1"},{"confirmation_number":"SJB12645432809","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","bundle_room":"1"},{"confirmation_number":"SJB12635698206","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3062151","reservation_id":"90675","confirmation_number":"SJ12688371828","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.24","nightly_discount":"0","subtotal":"152.24","grand_total":"171.27","paid_amount":"171.27","room_type_id":"319","product_id":"1915","siteminder_id":"BDC-2369921759","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":"96758","customer_id":"97137","source_of_creation":"Booking.com","reservation_created_date":"2020-01-27 09:49:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 310","ota_service_fee_amount":"0","commision_charges":"37.88","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"152.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3062704","reservation_id":"90779","confirmation_number":"SJ12675585092","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"161.65","nightly_discount":"0","subtotal":"161.65","grand_total":"181.85","paid_amount":"181.85","room_type_id":"319","product_id":"1287","siteminder_id":"BDC-3870094719","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96860","customer_id":"96860","source_of_creation":"Booking.com","reservation_created_date":"2020-01-28 14:44:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 313","ota_service_fee_amount":"0","commision_charges":"50.35","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"161.65","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":"3063348","reservation_id":"90774","confirmation_number":"SJ12661604329","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.15,169.15,169.15","nightly_discount":"0,0,0","subtotal":"507.45","grand_total":"570.88","paid_amount":"570.88","room_type_id":"318","product_id":"1281","siteminder_id":"BDC-3029115604","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":"96979","customer_id":"96979","source_of_creation":"Booking.com","reservation_created_date":"2020-01-28 14:09:09","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 235","ota_service_fee_amount":"0","commision_charges":"82.85","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"169.15","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":"3063560","reservation_id":"90686","confirmation_number":"SJ12697218628","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"165.4,165.4","nightly_discount":"0,0","subtotal":"330.80","grand_total":"372.15","paid_amount":"372.15","room_type_id":"319","product_id":"1305","siteminder_id":"BDC-2374024264","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96768","customer_id":"96768","source_of_creation":"Booking.com","reservation_created_date":"2020-01-27 16:32:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 411","ota_service_fee_amount":"0","commision_charges":"91.78","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"165.4","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":"3063743","reservation_id":"90969","confirmation_number":"SJ12655275513","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.15","nightly_discount":"0","subtotal":"169.15","grand_total":"190.30","paid_amount":"190.30","room_type_id":"413","product_id":"1264","siteminder_id":"BDC-3333344252","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":"97120","customer_id":"97120","source_of_creation":"Booking.com","reservation_created_date":"2020-01-30 21:16:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 211","ota_service_fee_amount":"0","commision_charges":"41.43","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"169.15","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":"3063931","reservation_id":"91000","confirmation_number":"SJ12690073861","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.15","nightly_discount":"0","subtotal":"169.15","grand_total":"190.30","paid_amount":"190.30","room_type_id":"413","product_id":"1260","siteminder_id":"BDC-2123262824","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":"97091","customer_id":"97091","source_of_creation":"Booking.com","reservation_created_date":"2020-01-31 15:15:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 206","ota_service_fee_amount":"0","commision_charges":"41.43","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"169.15","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":"3060168","reservation_id":"90303","confirmation_number":"SJ12667776648","room_stay_from":"2020-01-29","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.15,203.15,252.45,252.45","nightly_discount":"0,0,0,0","subtotal":"911.20","grand_total":"1025.10","paid_amount":"1025.10","room_type_id":"411","product_id":"1296","siteminder_id":"BDC-2853182247","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":"96353","customer_id":"96353","source_of_creation":"Booking.com","reservation_created_date":"2020-01-21 03:23:10","canceled_nights_data":"","product_name":"Bay View King One Bedroom Suite (Accessible)","ota_service_fee_amount":"0","commision_charges":"206.46","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"252.45","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":"3061957","reservation_id":"90468","confirmation_number":"SJ12668473405","room_stay_from":"2020-01-30","room_stay_to":"2020-02-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"179.00,320.00,215.00,179.00,179.00","nightly_discount":"0,0,0,0,0","subtotal":"1072.00","grand_total":"1206.00","paid_amount":"1206.00","room_type_id":"413","product_id":"1265","siteminder_id":"BDC-3713841258","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":"96524","customer_id":"96524","source_of_creation":"Booking.com","reservation_created_date":"2020-01-23 23:13:10","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 212","ota_service_fee_amount":"0","commision_charges":"235.20","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"320.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3062153","reservation_id":"90613","confirmation_number":"SJ12639858215","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.15","nightly_discount":"0","subtotal":"169.15","grand_total":"190.30","paid_amount":"190.30","room_type_id":"319","product_id":"1303","siteminder_id":"EXP-1630032314","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":"96689","customer_id":"96689","source_of_creation":"Expedia","reservation_created_date":"2020-01-26 15:03:10","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 409","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"169.15","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":"3062156","reservation_id":"90614","confirmation_number":"SJ12693953802","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.15","nightly_discount":"0","subtotal":"169.15","grand_total":"190.30","paid_amount":"190.30","room_type_id":"319","product_id":"1302","siteminder_id":"EXP-1630032313","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":"96690","customer_id":"96690","source_of_creation":"Expedia","reservation_created_date":"2020-01-26 15:03:14","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 408","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"169.15","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":"3062371","reservation_id":"80565","confirmation_number":"SJ12617069471","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"212.80,187.20,187.20,187.20,187.20,187.20,212.80","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1361.60","grand_total":"1531.80","paid_amount":"1531.80","room_type_id":"412","product_id":"1316","siteminder_id":"EXP-1297954421","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":"88824","customer_id":"88824","source_of_creation":"Expedia","reservation_created_date":"2019-07-12 00:15:07","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","currentDayPrice":"212.80","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":"3062792","reservation_id":"90687","confirmation_number":"SJ12654246591","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"135.32","nightly_discount":"0","subtotal":"135.32","grand_total":"152.24","paid_amount":"152.24","room_type_id":"413","product_id":"1268","siteminder_id":"EXP-1630661540","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":"96769","customer_id":"96769","source_of_creation":"Expedia","reservation_created_date":"2020-01-27 16:40:09","canceled_nights_data":"","product_name":"Standard King One Bedroom Suite 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"135.32","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":"3063023","reservation_id":"90847","confirmation_number":"SJ12620138555","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.15","nightly_discount":"0","subtotal":"169.15","grand_total":"190.30","paid_amount":"190.30","room_type_id":"319","product_id":"1916","siteminder_id":"EXP-1631665690","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":"96939","customer_id":"96939","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 04:18:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 311","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"169.15","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":"3063411","reservation_id":"90902","confirmation_number":"SJ12672099943","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"135.32,135.32,135.32","nightly_discount":"0,0,0","subtotal":"405.96","grand_total":"456.71","paid_amount":"456.71","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1632127276","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":"96996","customer_id":"96996","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 22:28:11","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","currentDayPrice":"135.32","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":"3063419","reservation_id":"90843","confirmation_number":"SJ12668230148","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.32,135.32","nightly_discount":"0,0","subtotal":"270.64","grand_total":"304.47","paid_amount":"304.47","room_type_id":"413","product_id":"1269","siteminder_id":"EXP-1631657170","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":"96935","customer_id":"96935","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 03:58:10","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","currentDayPrice":"135.32","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":"3063425","reservation_id":"90879","confirmation_number":"SJ12666000764","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"135.32","nightly_discount":"0","subtotal":"135.32","grand_total":"152.24","paid_amount":"152.24","room_type_id":"319","product_id":"1286","siteminder_id":"EXP-1631961211","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":"97127","customer_id":"97127","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 17:28:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 312","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"135.32","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":"3063545","reservation_id":"90942","confirmation_number":"SJ12650099315","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"135.32,135.32","nightly_discount":"0,0","subtotal":"270.64","grand_total":"304.47","paid_amount":"304.47","room_type_id":"319","product_id":"1274","siteminder_id":"EXP-1632572711","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":"97037","customer_id":"97037","source_of_creation":"Expedia","reservation_created_date":"2020-01-30 16:58: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","currentDayPrice":"135.32","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":"3063547","reservation_id":"90943","confirmation_number":"SJ12644566461","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"135.32,135.32","nightly_discount":"0,0","subtotal":"270.64","grand_total":"304.47","paid_amount":"304.47","room_type_id":"319","product_id":"1275","siteminder_id":"EXP-1632572714","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":"97038","customer_id":"97038","source_of_creation":"Expedia","reservation_created_date":"2020-01-30 16:58:11","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","currentDayPrice":"135.32","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":"3063660","reservation_id":"90936","confirmation_number":"SJ12638053904","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"135.32","nightly_discount":"0","subtotal":"135.32","grand_total":"152.24","paid_amount":"152.24","room_type_id":"319","product_id":"1288","siteminder_id":"EXP-1632500838","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":"97032","customer_id":"97032","source_of_creation":"Expedia","reservation_created_date":"2020-01-30 14:48:06","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","currentDayPrice":"135.32","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":"3063809","reservation_id":"90984","confirmation_number":"SJ12628705230","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.32","nightly_discount":"0","subtotal":"135.32","grand_total":"152.24","paid_amount":"152.24","room_type_id":"319","product_id":"1309","siteminder_id":"EXP-1632828968","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":"97078","customer_id":"97078","source_of_creation":"Expedia","reservation_created_date":"2020-01-31 01:28:08","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","currentDayPrice":"135.32","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":"3063850","reservation_id":"90999","confirmation_number":"SJ12671183936","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.32","nightly_discount":"0","subtotal":"135.32","grand_total":"152.24","paid_amount":"152.24","room_type_id":"319","product_id":"1291","siteminder_id":"EXP-1633113699","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":"97090","customer_id":"97114","source_of_creation":"Expedia","reservation_created_date":"2020-01-31 14:59:07","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 319","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"135.32","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":"3063895","reservation_id":"91011","confirmation_number":"SJ12647295760","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.32","nightly_discount":"0","subtotal":"135.32","grand_total":"152.24","paid_amount":"152.24","room_type_id":"319","product_id":"1304","siteminder_id":"EXP-1633241550","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":"97109","customer_id":"97109","source_of_creation":"Expedia","reservation_created_date":"2020-01-31 18:53:10","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","currentDayPrice":"135.32","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":"3072936","reservation_id":"91008","confirmation_number":"SJ12659093288","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.32","nightly_discount":"0.00","subtotal":"135.32","grand_total":"152.24","paid_amount":"152.24","room_type_id":"319","product_id":"1293","siteminder_id":"EXP-1633216585","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":"97104","customer_id":"97104","source_of_creation":"Expedia","reservation_created_date":"2020-01-31 18:04:06","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 322","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"135.32","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":"3065226","reservation_id":"87928","confirmation_number":"SJ12637915131","room_stay_from":"2020-01-23","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"187.20,212.80,212.80,187.20,187.20,187.20,187.20,187.20,212.80,443.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2204.80","grand_total":"2480.40","paid_amount":"2508.53","room_type_id":"412","product_id":"1315","siteminder_id":"EXP-1388688970","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":"94340","customer_id":"94340","source_of_creation":"Expedia","reservation_created_date":"2019-12-06 16:08:11","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 426","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"212.80","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"}]}],"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":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3063162","reservation_id":"90833","confirmation_number":"SJ12629140123","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,159.00,159.00","nightly_discount":"0.00,0.00,0.00","subtotal":"477.00","grand_total":"536.63","paid_amount":"536.63","room_type_id":"413","product_id":"1263","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":"96926","customer_id":"96926","source_of_creation":"PMS","reservation_created_date":"2020-01-29 01:11:25","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","currentDayPrice":"159.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]},{"room_stay_id":"3063843","reservation_id":"90976","confirmation_number":"SJ12659222139","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","room_stay_status":"Closed","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":"1266","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":"97069","customer_id":"97069","source_of_creation":"PMS","reservation_created_date":"2020-01-30 22:11:10","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","changedComment":"To date changed","deltaChange":"0.00","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":"3063927","reservation_id":"91015","confirmation_number":"SJ12675829733","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"169.00","nightly_discount":"0.00","subtotal":"169.00","grand_total":"190.13","paid_amount":"190.13","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":"97117","customer_id":"97117","source_of_creation":"PMS","reservation_created_date":"2020-01-31 20:54:14","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","currentDayPrice":"169.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":"3063848","reservation_id":"90802","confirmation_number":"SJ12682586359","room_stay_from":"2020-01-28","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,169.00,169.00,169.00,169.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"845.00","grand_total":"950.63","paid_amount":"950.63","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":"96889","customer_id":"96889","source_of_creation":"PMS","reservation_created_date":"2020-01-28 20:04:30","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"169.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":"3063918","reservation_id":"91004","confirmation_number":"SJ12614782921","room_stay_from":"2020-01-31","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"199.00,299.00","nightly_discount":"0.00,0.00","subtotal":"498.00","grand_total":"560.25","paid_amount":"560.25","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":"97096","customer_id":"97096","source_of_creation":"PMS","reservation_created_date":"2020-01-31 15:43:31","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","currentDayPrice":"199.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":"3063921","reservation_id":"91003","confirmation_number":"SJ12615150364","room_stay_from":"2020-01-31","room_stay_to":"2020-02-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,299.00","nightly_discount":"0.00,0.00","subtotal":"498.00","grand_total":"560.25","paid_amount":"560.25","room_type_id":"319","product_id":"1311","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":"97095","customer_id":"97095","source_of_creation":"PMS","reservation_created_date":"2020-01-31 15:40:12","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 418","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"199.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":"3056430","reservation_id":"89720","confirmation_number":"SJ12659215838","room_stay_from":"2020-01-28","room_stay_to":"2020-02-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"232.43,232.43,232.43,232.43,232.43,232.43,232.43","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1627.01","grand_total":"1830.39","paid_amount":"1830.39","room_type_id":"318","product_id":"1282","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":"95720","customer_id":"95720","source_of_creation":"PMS","reservation_created_date":"2020-01-10 20:36:29","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite (Accessible) 306","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","currentDayPrice":"232.43","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":"3069600","reservation_id":"90463","confirmation_number":"SJ12667679631","room_stay_from":"2020-01-26","room_stay_to":"2020-02-14","room_stay_status":"Closed","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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"1866","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":"96519","customer_id":"96519","source_of_creation":"PMS","reservation_created_date":"2020-01-23 22:06:22","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","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"}]}],"pms_non_taxable":[{"room_stay_id":"3059591","reservation_id":"89922","confirmation_number":"SJ12694283457","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","room_stay_status":"Closed","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":"319","product_id":"1277","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-01-14 00:16:51","canceled_nights_data":"","product_name":"Deluxe King One Bedroom Suite 229","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","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":"3060652","reservation_id":"89923","confirmation_number":"SJ12672570534","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","room_stay_status":"Closed","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":"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-01-14 00:18:35","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","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":"3062142","reservation_id":"85092","confirmation_number":"SJ12630974145","room_stay_from":"2020-01-27","room_stay_to":"2020-02-01","room_stay_status":"Closed","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":"2019-10-04 03:11:16","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","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"103","tax_name":"Sales Tax","tax_percentage":"7.50"},{"tax_id":"119","tax_name":"Tourist Development Tax","tax_percentage":"5.00"}]}],"negotiated_taxable":[{"room_stay_id":"3074346","reservation_id":"73996","confirmation_number":"SJ12664049931","room_stay_from":"2020-01-19","room_stay_to":"2020-02-02","room_stay_status":"Closed","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,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,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1786.68","grand_total":"2010.01","paid_amount":"2010.01","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-04-04 00:30:59","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","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":[{"room_stay_id":"3055624","reservation_id":"89234","confirmation_number":"SJ12698230410","room_stay_from":"2020-01-04","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"222.14,222.14,222.14,222.14,222.14,222.14,222.14","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1554.98","grand_total":"1554.98","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":"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-01-03 17:08:46","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","taxExmptApplied":-198.57,"changedComment":"Nightly price or discount changed","deltaChange":"-33.59","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"}]}],"extra_person_taxable":[{"room_stay_id":"3062706","reservation_id":"90779","confirmation_number":"SJ12676558880","room_confirmation_number":"SJ12675585092","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Active","nightly_price":"50","nightly_discount":"0.00","subtotal":"50.00","grand_total":"56.25","paid_amount":"56.25","product_id":"1777","service_quantity":"1","customer_traveller_id":"96860","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-01-28 15:42:43","reservation_modified_date_time":"2020-01-28 15:42:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96860","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":"3063562","reservation_id":"90686","confirmation_number":"SJ12645895564","room_confirmation_number":"SJ12697218628","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","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":"1777","service_quantity":"1","customer_traveller_id":"96768","product_attribute_values":"extra_person#&#25","reservation_created_date":"2020-01-30 17:19:36","reservation_modified_date_time":"2020-01-30 17:19:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96768","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":"3059592","reservation_id":"89922","confirmation_number":"SJ12661584761","room_confirmation_number":"SJ12694283457","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","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":"95943","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-14 00:16:51","reservation_modified_date_time":"2020-01-14 00:16:51","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":"3060653","reservation_id":"89923","confirmation_number":"SJ12680772532","room_confirmation_number":"SJ12672570534","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","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":"95944","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-14 00:18:35","reservation_modified_date_time":"2020-01-14 00:18:35","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":"3062143","reservation_id":"85092","confirmation_number":"SJ12651740345","room_confirmation_number":"SJ12630974145","room_stay_from":"2020-01-27","room_stay_to":"2020-02-01","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":"92325","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-10-04 03:11:16","reservation_modified_date_time":"2020-01-25 14:47:48","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74797","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":"3062152","reservation_id":"90675","confirmation_number":"SJ12629760878","room_confirmation_number":"SJ12688371828","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"96758","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 09:49:09","reservation_modified_date_time":"2020-01-27 09:49:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97137","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":"3062155","reservation_id":"90613","confirmation_number":"SJ12633889530","room_confirmation_number":"SJ12639858215","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"96689","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-26 15:03:10","reservation_modified_date_time":"2020-01-26 15:03:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96689","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":"3062157","reservation_id":"90614","confirmation_number":"SJ12647940366","room_confirmation_number":"SJ12693953802","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"96690","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-26 15:03:14","reservation_modified_date_time":"2020-01-26 15:03:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96690","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":"3062375","reservation_id":"80565","confirmation_number":"SJ12617949762","room_confirmation_number":"SJ12617069471","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","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":"88824","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-07-12 00:15:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"88824","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":"3062707","reservation_id":"90779","confirmation_number":"SJ12675191160","room_confirmation_number":"SJ12675585092","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"96860","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 14:44:11","reservation_modified_date_time":"2020-01-28 15:42:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96860","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":"3062794","reservation_id":"90687","confirmation_number":"SJ12637719900","room_confirmation_number":"SJ12654246591","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"96769","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 16:40:09","reservation_modified_date_time":"2020-01-28 19:54:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96769","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":"3063024","reservation_id":"90847","confirmation_number":"SJ12654469073","room_confirmation_number":"SJ12620138555","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"96939","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 04:18:11","reservation_modified_date_time":"2020-01-29 11:53:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96939","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":"3063163","reservation_id":"90833","confirmation_number":"SJ12629317900","room_confirmation_number":"SJ12629140123","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","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":"96926","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 01:11:25","reservation_modified_date_time":"2020-01-29 16:55:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96926","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":"3063349","reservation_id":"90774","confirmation_number":"SJ12674433827","room_confirmation_number":"SJ12661604329","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","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":"96979","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 14:09:09","reservation_modified_date_time":"2020-01-29 19:18:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96979","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":"3063413","reservation_id":"90902","confirmation_number":"SJ12688056216","room_confirmation_number":"SJ12672099943","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","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":"96996","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 22:28:11","reservation_modified_date_time":"2020-01-29 22:40:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96996","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":"3063420","reservation_id":"90843","confirmation_number":"SJ12617859108","room_confirmation_number":"SJ12668230148","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","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":"96935","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 03:58:10","reservation_modified_date_time":"2020-01-29 22:55:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96935","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":"3063426","reservation_id":"90879","confirmation_number":"SJ12696486062","room_confirmation_number":"SJ12666000764","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"97127","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-29 17:28:11","reservation_modified_date_time":"2020-01-29 22:59:45","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97127","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":"3063546","reservation_id":"90942","confirmation_number":"SJ12657557156","room_confirmation_number":"SJ12650099315","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","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":"97037","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 16:58:07","reservation_modified_date_time":"2020-01-30 16:58:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97037","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":"3063548","reservation_id":"90943","confirmation_number":"SJ12699276095","room_confirmation_number":"SJ12644566461","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","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":"97038","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 16:58:11","reservation_modified_date_time":"2020-01-30 16:58:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97038","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":"3063563","reservation_id":"90686","confirmation_number":"SJ12699084022","room_confirmation_number":"SJ12697218628","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","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":"96768","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-27 16:32:06","reservation_modified_date_time":"2020-01-30 17:19:36","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96768","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":"3063661","reservation_id":"90936","confirmation_number":"SJ12693414110","room_confirmation_number":"SJ12638053904","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"97032","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 14:48:06","reservation_modified_date_time":"2020-01-30 18:55:43","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97032","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":"3063744","reservation_id":"90969","confirmation_number":"SJ12659499127","room_confirmation_number":"SJ12655275513","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"97120","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 21:16:10","reservation_modified_date_time":"2020-01-30 22:02:27","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97120","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":"3063811","reservation_id":"90984","confirmation_number":"SJ12688139326","room_confirmation_number":"SJ12628705230","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"97078","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 01:28:08","reservation_modified_date_time":"2020-01-31 12:25:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97078","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":"3063844","reservation_id":"90976","confirmation_number":"SJ12671689461","room_confirmation_number":"SJ12659222139","room_stay_from":"2020-01-30","room_stay_to":"2020-02-01","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":"97069","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-30 22:11:10","reservation_modified_date_time":"2020-01-31 14:18:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97069","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"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":"3063851","reservation_id":"90999","confirmation_number":"SJ12667867741","room_confirmation_number":"SJ12671183936","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"97090","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 14:59:07","reservation_modified_date_time":"2020-01-31 14:59:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97114","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":"3063896","reservation_id":"91011","confirmation_number":"SJ12692000202","room_confirmation_number":"SJ12647295760","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"97109","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 18:53:10","reservation_modified_date_time":"2020-01-31 18:53:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97109","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":"3063928","reservation_id":"91015","confirmation_number":"SJ12655381763","room_confirmation_number":"SJ12675829733","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"97117","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 20:54:14","reservation_modified_date_time":"2020-01-31 20:54:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97117","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":"3063932","reservation_id":"91000","confirmation_number":"SJ12620824067","room_confirmation_number":"SJ12690073861","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"97091","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 15:15:09","reservation_modified_date_time":"2020-01-31 21:22:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97091","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":"3072937","reservation_id":"91008","confirmation_number":"SJ12680665228","room_confirmation_number":"SJ12659093288","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","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":"97104","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 18:04:06","reservation_modified_date_time":"2020-02-22 20:37:03","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97104","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":"3060169","reservation_id":"90303","confirmation_number":"SJ12657289683","room_confirmation_number":"SJ12667776648","room_stay_from":"2020-01-29","room_stay_to":"2020-02-02","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":"96353","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-21 03:23:10","reservation_modified_date_time":"2020-01-21 03:23:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96353","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":"3063849","reservation_id":"90802","confirmation_number":"SJ12672268692","room_confirmation_number":"SJ12682586359","room_stay_from":"2020-01-28","room_stay_to":"2020-02-02","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":"96889","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-28 20:04:30","reservation_modified_date_time":"2020-01-31 14:35:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96889","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"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":"3063920","reservation_id":"91004","confirmation_number":"SJ12693895748","room_confirmation_number":"SJ12614782921","room_stay_from":"2020-01-31","room_stay_to":"2020-02-02","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":"97096","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 15:43:31","reservation_modified_date_time":"2020-01-31 20:29:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97096","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":"3063922","reservation_id":"91003","confirmation_number":"SJ12673920094","room_confirmation_number":"SJ12615150364","room_stay_from":"2020-01-31","room_stay_to":"2020-02-02","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":"97095","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 15:40:12","reservation_modified_date_time":"2020-01-31 20:30:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97095","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":"3065227","reservation_id":"87928","confirmation_number":"SJ12623788085","room_confirmation_number":"SJ12637915131","room_stay_from":"2020-01-23","room_stay_to":"2020-02-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"250.00","grand_total":"281.25","paid_amount":"281.25","product_id":"1776","service_quantity":"1","customer_traveller_id":"94340","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-12-06 16:08:11","reservation_modified_date_time":"2020-02-02 21:00:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94340","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":"3074345","reservation_id":"73996","confirmation_number":"SJ12661291774","room_confirmation_number":"SJ12664049931","room_stay_from":"2020-01-19","room_stay_to":"2020-02-02","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"350.00","grand_total":"393.75","paid_amount":"393.75","product_id":"1776","service_quantity":"1","customer_traveller_id":"84586","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2019-04-04 00:30:59","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":"3056431","reservation_id":"89720","confirmation_number":"SJ12620654096","room_confirmation_number":"SJ12659215838","room_stay_from":"2020-01-28","room_stay_to":"2020-02-04","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":"95720","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-10 20:36:29","reservation_modified_date_time":"2020-01-10 20:36:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95720","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":"3061960","reservation_id":"90468","confirmation_number":"SJ12697146209","room_confirmation_number":"SJ12668473405","room_stay_from":"2020-01-30","room_stay_to":"2020-02-04","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":"96524","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-23 23:13:10","reservation_modified_date_time":"2020-01-23 23:13:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96524","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":"3069601","reservation_id":"90463","confirmation_number":"SJ12631515357","room_confirmation_number":"SJ12667679631","room_stay_from":"2020-01-26","room_stay_to":"2020-02-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"96519","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-23 22:06:22","reservation_modified_date_time":"2020-02-13 18:21:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96519","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":"3072937","reservation_id":"91008","confirmation_number":"SJ12680665228","room_confirmation_number":"SJ12659093288","room_stay_from":"2020-01-31","room_stay_to":"2020-02-01","room_stay_status":"Active","nightly_price":"25.00","nightly_discount":"0.00","subtotal":"25.00","grand_total":"28.13","paid_amount":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"97104","product_attribute_values":"resort_fee#&#flat_rate#&#25","reservation_created_date":"2020-01-31 18:04:06","reservation_modified_date_time":"2020-01-31 18:04:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97104","canceled_nights_data":"","changedComment":"","deltaChange":"0.00","currentDayPrice":25,"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":[]}}