{"hotel_id":"126","sub_hotel_id":0,"room_type":"garden_villa","date":"2020-01-29","total_rooms_exist":"1246,1252,1256,1950,1952,1956,1957,1960,1962,1968,1970,1974,1976,1982,1986,1988,1992,1994,1997,1998","holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1950,1952,1956,1957,1960,1962,1252,1968,1970,1974,1976,1982,1997,1998","block_room_bookings":[{"confirmation_number":"SJ12688548693","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12678622886","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12610838194","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12613142878","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12687898538","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12699660853","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12630566464","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12699682337","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12653953829","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12625029318","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12636415562","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12679488133","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12633666995","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"},{"confirmation_number":"SJ12673579127","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"0"}],"bundle_block_count":"1256,1246,1950,1952,1956,1957,1960,1962,1252,1982,1968,1970,1974,1976,1997,1998","bundle_block_bookings":[{"confirmation_number":"SJB12636898434","room_stay_from":"2020-01-16","room_stay_to":"2020-02-07","bundle_room":"1"},{"confirmation_number":"SJB12623120612","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12630688658","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12698121515","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12641033345","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12610359718","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12673674369","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"},{"confirmation_number":"SJB12629602700","room_stay_from":"2019-12-13","room_stay_to":"2021-01-01","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3054534","reservation_id":"88982","confirmation_number":"SJ12647169627","room_stay_from":"2020-01-25","room_stay_to":"2020-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"235.45,186.15,186.15,186.15,186.15","nightly_discount":"0,0,0,0,0","subtotal":"980.05","grand_total":"1102.55","paid_amount":"1102.55","room_type_id":"319","product_id":"1302","siteminder_id":"BDC-2785857655","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":"96654","customer_id":"96654","source_of_creation":"Booking.com","reservation_created_date":"2019-12-30 20:46:07","canceled_nights_data":"","currentDayPrice":"186.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":"3063122","reservation_id":"90866","confirmation_number":"SJ12637727233","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","room_stay_status":"Checked-In","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":"1913","siteminder_id":"BDC-3372706184","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":"96954","customer_id":"96954","source_of_creation":"Booking.com","reservation_created_date":"2020-01-29 15:53:10","canceled_nights_data":"","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":"3063348","reservation_id":"90774","confirmation_number":"SJ12661604329","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","room_stay_status":"Checked-In","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":"96855","customer_id":"96855","source_of_creation":"Booking.com","reservation_created_date":"2020-01-28 14:09:09","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","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":"Checked-In","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":"","currentDayPrice":"203.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3061695","reservation_id":"89069","confirmation_number":"SJ12641358951","room_stay_from":"2020-01-25","room_stay_to":"2020-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"180.88,148.92,148.92,148.92,148.92","nightly_discount":"0,0,0,0,0","subtotal":"776.56","grand_total":"873.63","paid_amount":"873.63","room_type_id":"413","product_id":"1272","siteminder_id":"EXP-1615681549","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":"95129","customer_id":"95129","source_of_creation":"Expedia","reservation_created_date":"2020-01-01 18:22:09","canceled_nights_data":"","currentDayPrice":"148.92","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":"3062790","reservation_id":"90778","confirmation_number":"SJ12677579384","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","room_stay_status":"Checked-In","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":"413","product_id":"1266","siteminder_id":"EXP-1631242754","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":"96859","customer_id":"96859","source_of_creation":"Expedia","reservation_created_date":"2020-01-28 14:43:07","canceled_nights_data":"","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":"3063189","reservation_id":"90875","confirmation_number":"SJ12673122009","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","room_stay_status":"Checked-In","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":"1274","siteminder_id":"EXP-1631949151","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":"96963","customer_id":"96963","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 17:03:10","canceled_nights_data":"","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":"3063221","reservation_id":"90882","confirmation_number":"SJ12648632989","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","room_stay_status":"Active","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":"1286","siteminder_id":"EXP-1631970884","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":"96970","customer_id":"96970","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 17:43:12","canceled_nights_data":"","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":"3063224","reservation_id":"90883","confirmation_number":"SJ12611443364","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","room_stay_status":"Active","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":"1287","siteminder_id":"EXP-1631970883","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":"96971","customer_id":"96971","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 17:43:17","canceled_nights_data":"","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":"3063331","reservation_id":"90885","confirmation_number":"SJ12615212197","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","room_stay_status":"Checked-In","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":"1915","siteminder_id":"EXP-1632007487","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":"96975","customer_id":"96975","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 18:53:08","canceled_nights_data":"","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":"3063341","reservation_id":"90888","confirmation_number":"SJ12661873855","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","room_stay_status":"Checked-In","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":"1288","siteminder_id":"EXP-1632016438","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":"96977","customer_id":"96977","source_of_creation":"Expedia","reservation_created_date":"2020-01-29 19:08:10","canceled_nights_data":"","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":"3062371","reservation_id":"80565","confirmation_number":"SJ12617069471","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","room_stay_status":"Checked-In","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":"","currentDayPrice":"187.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":"3063411","reservation_id":"90902","confirmation_number":"SJ12672099943","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","room_stay_status":"Checked-In","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":"","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":"3054675","reservation_id":"87928","confirmation_number":"SJ12637915131","room_stay_from":"2020-01-23","room_stay_to":"2020-02-03","room_stay_status":"Checked-In","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,212.80,230.40","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0","subtotal":"2204.80","grand_total":"2480.40","paid_amount":"2480.40","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":"","currentDayPrice":"187.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":"3063079","reservation_id":"90020","confirmation_number":"SJ12659784776","room_stay_from":"2020-01-27","room_stay_to":"2020-01-29","room_stay_status":"Checked-Out","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"13.60,169.20","nightly_discount":"0.00,0.00","subtotal":"182.80","grand_total":"205.65","paid_amount":"205.65","room_type_id":"413","product_id":"1271","siteminder_id":"EXP-1623399850","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":"96046","customer_id":"96046","source_of_creation":"Expedia","reservation_created_date":"2020-01-15 15:03:12","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"13.60","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"}]}],"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":[{"room_stay_id":"3063404","reservation_id":"90900","confirmation_number":"SJ12646470113","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"179.00","nightly_discount":"0.00","subtotal":"179.00","grand_total":"201.38","paid_amount":"201.38","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":"96994","customer_id":"96994","source_of_creation":"FE","reservation_created_date":"2020-01-29 22:09:36","canceled_nights_data":"","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":"3062644","reservation_id":"88410","confirmation_number":"SJ12623750966","room_stay_from":"2020-01-28","room_stay_to":"2020-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"209.00,209.00,209.00","nightly_discount":"0.00,0.00,0.00","subtotal":"627.00","grand_total":"705.38","paid_amount":"705.38","room_type_id":"319","product_id":"1303","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":"94640","customer_id":"94640","source_of_creation":"FE","reservation_created_date":"2019-12-17 05:18:37","canceled_nights_data":"","currentDayPrice":"209.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":"3063094","reservation_id":"90775","confirmation_number":"SJ12652587425","room_stay_from":"2020-01-28","room_stay_to":"2020-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.32,162.32","nightly_discount":"0.00,0.00","subtotal":"324.64","grand_total":"365.22","paid_amount":"365.22","room_type_id":"319","product_id":"1275","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96854","customer_id":"96854","source_of_creation":"PMS","reservation_created_date":"2020-01-28 14:09:25","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"162.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":"3063360","reservation_id":"90892","confirmation_number":"SJ12651018094","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"159.00","nightly_discount":"0.00","subtotal":"159.00","grand_total":"178.88","paid_amount":"178.88","room_type_id":"413","product_id":"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":"96985","customer_id":"96985","source_of_creation":"PMS","reservation_created_date":"2020-01-29 20:01:46","canceled_nights_data":"","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":"3063450","reservation_id":"90916","confirmation_number":"SJ12620044800","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00","nightly_discount":"0.00","subtotal":"159.00","grand_total":"178.88","paid_amount":"178.88","room_type_id":"413","product_id":"1268","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":"96908","customer_id":"96908","source_of_creation":"PMS","reservation_created_date":"2020-01-30 01:05:16","canceled_nights_data":"","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":"3063470","reservation_id":"90923","confirmation_number":"SJ12642857143","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00","nightly_discount":"0.00","subtotal":"159.00","grand_total":"178.88","paid_amount":"178.88","room_type_id":"413","product_id":"1269","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":"97019","customer_id":"97019","source_of_creation":"PMS","reservation_created_date":"2020-01-30 03:01:28","canceled_nights_data":"","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":"3062189","reservation_id":"90463","confirmation_number":"SJ12667679631","room_stay_from":"2020-01-26","room_stay_to":"2020-01-31","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","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":"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":"","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":"3063046","reservation_id":"90716","confirmation_number":"SJ12640422694","room_stay_from":"2020-01-27","room_stay_to":"2020-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,169.00,169.00,169.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"676.00","grand_total":"760.50","paid_amount":"760.50","room_type_id":"319","product_id":"1319","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96799","customer_id":"96799","source_of_creation":"PMS","reservation_created_date":"2020-01-27 22:20:38","canceled_nights_data":"","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":"3063462","reservation_id":"90920","confirmation_number":"SJ12627208415","room_stay_from":"2020-01-29","room_stay_to":"2020-01-31","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,159.00","nightly_discount":"0.00,0.00","subtotal":"318.00","grand_total":"357.75","paid_amount":"357.75","room_type_id":"413","product_id":"1273","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":"97015","customer_id":"97015","source_of_creation":"PMS","reservation_created_date":"2020-01-30 02:18:29","canceled_nights_data":"","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":"3063162","reservation_id":"90833","confirmation_number":"SJ12629140123","room_stay_from":"2020-01-29","room_stay_to":"2020-02-01","room_stay_status":"Checked-In","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":"","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":"3063371","reservation_id":"90802","confirmation_number":"SJ12682586359","room_stay_from":"2020-01-28","room_stay_to":"2020-02-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.00,169.00,169.00,169.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"676.00","grand_total":"760.50","paid_amount":"760.50","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":"","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":"3059407","reservation_id":"73996","confirmation_number":"SJ12664049931","room_stay_from":"2020-01-19","room_stay_to":"2020-02-02","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,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":"393.76","room_type_id":"319","product_id":"1756","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":"74459","customer_id":"74459","source_of_creation":"PMS","reservation_created_date":"2019-04-04 00:30:59","canceled_nights_data":"","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"}]},{"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":"Checked-In","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":"","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":"3059939","reservation_id":"87569","confirmation_number":"SJ12620875524","room_stay_from":"2019-12-13","room_stay_to":"2020-02-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,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,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,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,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,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":"333","product_id":"1246","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":"94078","customer_id":"94078","source_of_creation":"PMS","reservation_created_date":"2019-11-27 19:18:57","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":"3063027","reservation_id":"85384","confirmation_number":"SJ12612987067","room_stay_from":"2019-12-04","room_stay_to":"2019-12-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"410.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"410.00","grand_total":"461.25","paid_amount":"461.25","room_type_id":"319","product_id":"1306","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":"82465","customer_id":"82465","source_of_creation":"PMS","reservation_created_date":"2019-10-10 03:58:43","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"-15.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":"3063029","reservation_id":"88227","confirmation_number":"SJ12640661925","room_stay_from":"2019-12-19","room_stay_to":"2019-12-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"410.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"410.00","grand_total":"461.25","paid_amount":"461.25","room_type_id":"319","product_id":"1917","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":"82465","customer_id":"82465","source_of_creation":"PMS","reservation_created_date":"2019-12-13 02:02:50","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"410.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":"3063031","reservation_id":"87869","confirmation_number":"SJ12646968853","room_stay_from":"2019-12-26","room_stay_to":"2019-12-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"920.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"920.00","grand_total":"1035.00","paid_amount":"1035.00","room_type_id":"412","product_id":"1297","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","reservation_created_date":"2019-12-05 04:51:58","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"510.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":"3063033","reservation_id":"87870","confirmation_number":"SJ12611544100","room_stay_from":"2019-12-26","room_stay_to":"2019-12-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"920.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"920.00","grand_total":"1035.00","paid_amount":"1035.00","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":"82465","customer_id":"82465","source_of_creation":"PMS","reservation_created_date":"2019-12-05 05:04:14","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"510.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":"3063041","reservation_id":"85756","confirmation_number":"SJ12641191964","room_stay_from":"2019-12-13","room_stay_to":"2019-12-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"315.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"315.00","grand_total":"354.38","paid_amount":"354.38","room_type_id":"319","product_id":"1309","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":"82465","customer_id":"82465","source_of_creation":"PMS","reservation_created_date":"2019-10-16 21:24:20","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"70.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":"3063044","reservation_id":"85761","confirmation_number":"SJ12665943338","room_stay_from":"2019-12-15","room_stay_to":"2019-12-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"315.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"315.00","grand_total":"354.38","paid_amount":"354.38","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":"82465","customer_id":"82465","source_of_creation":"PMS","reservation_created_date":"2019-10-16 22:17:09","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"70.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":"3063048","reservation_id":"85764","confirmation_number":"SJ12614258973","room_stay_from":"2019-12-16","room_stay_to":"2019-12-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"315.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"315.00","grand_total":"354.38","paid_amount":"354.38","room_type_id":"412","product_id":"1294","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":"82465","customer_id":"82465","source_of_creation":"PMS","reservation_created_date":"2019-10-16 22:49:42","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"70.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":"3063056","reservation_id":"85769","confirmation_number":"SJ12615394098","room_stay_from":"2019-12-17","room_stay_to":"2019-12-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"315.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"315.00","grand_total":"354.38","paid_amount":"354.38","room_type_id":"319","product_id":"1309","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":"82465","customer_id":"82465","source_of_creation":"PMS","reservation_created_date":"2019-10-16 23:19:35","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"70.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":"3063063","reservation_id":"86779","confirmation_number":"SJ12667028080","room_stay_from":"2019-12-17","room_stay_to":"2019-12-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"315.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"315.00","grand_total":"354.38","paid_amount":"354.38","room_type_id":"413","product_id":"1265","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","reservation_created_date":"2019-11-07 01:10:18","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"70.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":"3063065","reservation_id":"85753","confirmation_number":"SJ12682151842","room_stay_from":"2019-12-18","room_stay_to":"2019-12-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"315.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"315.00","grand_total":"354.38","paid_amount":"354.38","room_type_id":"319","product_id":"1307","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":"82465","customer_id":"82465","source_of_creation":"PMS","reservation_created_date":"2019-10-16 21:11:58","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"70.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":"3063068","reservation_id":"85752","confirmation_number":"SJ12691920701","room_stay_from":"2019-12-19","room_stay_to":"2019-12-22","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"315.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"315.00","grand_total":"354.38","paid_amount":"354.38","room_type_id":"412","product_id":"1294","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":"82465","customer_id":"82465","source_of_creation":"PMS","reservation_created_date":"2019-10-16 21:07:53","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"70.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":"3063084","reservation_id":"88687","confirmation_number":"SJ12622238517","room_stay_from":"2020-01-28","room_stay_to":"2020-01-29","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","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":"94172","customer_id":"94172","source_of_creation":"PMS","reservation_created_date":"2019-12-25 17:02:40","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":"3063070","reservation_id":"85390","confirmation_number":"SJ12636797823","room_stay_from":"2019-12-19","room_stay_to":"2019-12-22","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"315.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"315.00","grand_total":"354.38","paid_amount":"315.00","room_type_id":"319","product_id":"1306","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":"82465","customer_id":"82465","source_of_creation":"PMS","reservation_created_date":"2019-10-10 04:26:24","service_canceled_date_time":"2020-01-29 13:44:57","canceled_nights_data":"","deltaChange":0,"changedComment":"reservation is canceled but amt paid","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"}]}],"pms_non_taxable":[{"room_stay_id":"3018118","reservation_id":"83895","confirmation_number":"SJ12619790355","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","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":"319","product_id":"1279","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":"82876","customer_id":"82876","source_of_creation":"PMS","reservation_created_date":"2019-09-10 20:25:30","canceled_nights_data":"","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":"3059591","reservation_id":"89922","confirmation_number":"SJ12694283457","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","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":"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":"","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":"3060185","reservation_id":"88177","confirmation_number":"SJ12613433354","room_stay_from":"2020-01-25","room_stay_to":"2020-02-01","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":"409","product_id":"1798","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":"74796","customer_id":"74796","source_of_creation":"PMS","reservation_created_date":"2019-12-11 22:32:58","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"111","tax_name":"Long Term Stay","tax_percentage":"0.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":"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":"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":"","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":"Checked-In","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":"","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":"3063448","reservation_id":"90915","confirmation_number":"SJ12656261445","room_stay_from":"2019-12-14","room_stay_to":"2019-12-15","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"575.00","nightly_discount":"0.00","subtotal":"575.00","grand_total":"646.88","paid_amount":"575.00","room_type_id":"413","product_id":"1262","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"2","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"82465","customer_id":"82465","source_of_creation":"PMS","negotiatedName":"RCI","reservation_created_date":"2020-01-30 00:35:07","service_canceled_date_time":"2020-01-30 00:36:15","canceled_nights_data":"","deltaChange":0,"changedComment":"reservation is canceled but amt paid","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"}]}],"negotiated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3054536","reservation_id":"88982","confirmation_number":"SJ12696403679","room_confirmation_number":"SJ12647169627","room_stay_from":"2020-01-25","room_stay_to":"2020-01-30","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":"96654","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-30 20:46:07","reservation_modified_date_time":"2019-12-30 20:46:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96654","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":"3061698","reservation_id":"89069","confirmation_number":"SJ12647918326","room_confirmation_number":"SJ12641358951","room_stay_from":"2020-01-25","room_stay_to":"2020-01-30","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":"95129","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-01 18:22:09","reservation_modified_date_time":"2020-01-01 18:22:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95129","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":"3062791","reservation_id":"90778","confirmation_number":"SJ12682435717","room_confirmation_number":"SJ12677579384","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","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":"96859","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-28 14:43:07","reservation_modified_date_time":"2020-01-28 19:53:43","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96859","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":"3063095","reservation_id":"90775","confirmation_number":"SJ12641532915","room_confirmation_number":"SJ12652587425","room_stay_from":"2020-01-28","room_stay_to":"2020-01-30","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":"96854","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-28 14:09:25","reservation_modified_date_time":"2020-01-29 15:05:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96854","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":"3063123","reservation_id":"90866","confirmation_number":"SJ12638562173","room_confirmation_number":"SJ12637727233","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","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":"96954","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-29 15:53:10","reservation_modified_date_time":"2020-01-29 16:16:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96954","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":"3063190","reservation_id":"90875","confirmation_number":"SJ12653457952","room_confirmation_number":"SJ12673122009","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","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":"96963","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-29 17:03:10","reservation_modified_date_time":"2020-01-29 17:03:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96963","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":"3063222","reservation_id":"90882","confirmation_number":"SJ12693716082","room_confirmation_number":"SJ12648632989","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","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":"96970","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-29 17:43:12","reservation_modified_date_time":"2020-01-29 17:43:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96970","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":"3063225","reservation_id":"90883","confirmation_number":"SJ12654799508","room_confirmation_number":"SJ12611443364","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","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":"96971","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-29 17:43:17","reservation_modified_date_time":"2020-01-29 17:43:17","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96971","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":"3063332","reservation_id":"90885","confirmation_number":"SJ12687519491","room_confirmation_number":"SJ12615212197","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","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":"96975","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-29 18:53:08","reservation_modified_date_time":"2020-01-29 19:03:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96975","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":"3063342","reservation_id":"90888","confirmation_number":"SJ12683971017","room_confirmation_number":"SJ12661873855","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","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":"96977","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-29 19:08:10","reservation_modified_date_time":"2020-01-29 19:08:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96977","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":"3063361","reservation_id":"90892","confirmation_number":"SJ12660204343","room_confirmation_number":"SJ12651018094","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","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":"96985","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-29 20:01:46","reservation_modified_date_time":"2020-01-29 20:01:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96985","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":"3063405","reservation_id":"90900","confirmation_number":"SJ12665199631","room_confirmation_number":"SJ12646470113","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","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":"96994","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-29 22:09:36","reservation_modified_date_time":"2020-01-29 22:27:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96994","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":"3063451","reservation_id":"90916","confirmation_number":"SJ12654300157","room_confirmation_number":"SJ12620044800","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","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":"96908","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-30 01:05:16","reservation_modified_date_time":"2020-01-30 01:05:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96908","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":"3063471","reservation_id":"90923","confirmation_number":"SJ12686149713","room_confirmation_number":"SJ12642857143","room_stay_from":"2020-01-29","room_stay_to":"2020-01-30","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":"97019","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-30 03:01:28","reservation_modified_date_time":"2020-01-30 03:01:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97019","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":"3062190","reservation_id":"90463","confirmation_number":"SJ12631515357","room_confirmation_number":"SJ12667679631","room_stay_from":"2020-01-26","room_stay_to":"2020-01-31","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":"96519","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-23 22:06:22","reservation_modified_date_time":"2020-01-23 22:06:22","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":"3062646","reservation_id":"88410","confirmation_number":"SJ12690098147","room_confirmation_number":"SJ12623750966","room_stay_from":"2020-01-28","room_stay_to":"2020-01-31","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":"94640","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-17 05:18:37","reservation_modified_date_time":"2020-01-28 12:22:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94640","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":"3063047","reservation_id":"90716","confirmation_number":"SJ12641101247","room_confirmation_number":"SJ12640422694","room_stay_from":"2020-01-27","room_stay_to":"2020-01-31","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":"96799","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-27 22:20:38","reservation_modified_date_time":"2020-01-29 13:31:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96799","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":"3063463","reservation_id":"90920","confirmation_number":"SJ12642796824","room_confirmation_number":"SJ12627208415","room_stay_from":"2020-01-29","room_stay_to":"2020-01-31","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":"97015","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-30 02:18:29","reservation_modified_date_time":"2020-01-30 02:18:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"97015","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":"3018119","reservation_id":"83895","confirmation_number":"SJ12656213688","room_confirmation_number":"SJ12619790355","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":"91461","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-10 20:25:30","reservation_modified_date_time":"2019-09-10 20:25:30","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"82876","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":"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#","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":"3060188","reservation_id":"88177","confirmation_number":"SJ12641231391","room_confirmation_number":"SJ12613433354","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":"94497","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-11 22:32:58","reservation_modified_date_time":"2019-12-11 22:32:58","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"0","customer_id":"74796","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#","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#","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":"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#","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":"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#","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":"96855","product_attribute_values":"resort_fee#&#flat_rate#","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":"96855","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":"3063372","reservation_id":"90802","confirmation_number":"SJ12672268692","room_confirmation_number":"SJ12682586359","room_stay_from":"2020-01-28","room_stay_to":"2020-02-01","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":"96889","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-28 20:04:30","reservation_modified_date_time":"2020-01-29 21:14:31","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":"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#","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":"3059408","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":"0.00","product_id":"1776","service_quantity":"1","customer_traveller_id":"84586","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-04-04 00:30:59","reservation_modified_date_time":"0000-00-00 00:00:00","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":"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#","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":"3054676","reservation_id":"87928","confirmation_number":"SJ12623788085","room_confirmation_number":"SJ12637915131","room_stay_from":"2020-01-23","room_stay_to":"2020-02-03","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"275.00","grand_total":"309.38","paid_amount":"309.38","product_id":"1776","service_quantity":"1","customer_traveller_id":"94340","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-06 16:08:11","reservation_modified_date_time":"2019-12-06 16:08:11","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":"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#","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":"3059942","reservation_id":"87569","confirmation_number":"SJ12650902986","room_confirmation_number":"SJ12620875524","room_stay_from":"2019-12-13","room_stay_to":"2020-02-07","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,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,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,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,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":"94078","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-27 19:18:57","reservation_modified_date_time":"2019-11-27 19:18:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94078","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":"3063085","reservation_id":"88687","confirmation_number":"SJ12687174708","room_confirmation_number":"SJ12622238517","room_stay_from":"2020-01-28","room_stay_to":"2020-01-29","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":"94854","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-25 17:02:40","reservation_modified_date_time":"2020-01-29 14:49:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94172","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":[]}}