{"hotel_id":"128","sub_hotel_id":0,"room_type":"hotel","date":"2019-02-17","total_rooms_exist":18,"departureCount":6,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"4","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2898482","reservation_id":"63692","confirmation_number":"CC12887783291","room_stay_from":"2019-02-16","room_stay_to":"2019-02-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,100.00,100.00,100.00,100.00,100.00,110.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"720.00","grand_total":"813.60","paid_amount":"813.60","room_type_id":"357","product_id":"1753","siteminder_id":"BDC-1237504702","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":"78678","customer_id":"78678","source_of_creation":"Booking.com","reservation_created_date":"2018-12-18 01:39:09","canceled_nights_data":"","product_name":"27 Hotel Room","ota_service_fee_amount":"0","commision_charges":"108.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2936906","reservation_id":"69683","confirmation_number":"CC12872312154","room_stay_from":"2019-02-17","room_stay_to":"2019-02-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"155.25","nightly_discount":"0","subtotal":"155.25","grand_total":"175.44","paid_amount":"175.44","room_type_id":"348","product_id":"1744","siteminder_id":"BDC-1042221750","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":"81991","customer_id":"81991","source_of_creation":"Booking.com","reservation_created_date":"2019-02-17 17:21:09","canceled_nights_data":"","product_name":"17 Studio","ota_service_fee_amount":"0","commision_charges":"23.29","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"155.25","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2908760","reservation_id":"64956","confirmation_number":"CC12835599749","room_stay_from":"2019-02-17","room_stay_to":"2019-02-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"106.09,106.09,106.09","nightly_discount":"0,0,0","subtotal":"318.27","grand_total":"359.65","paid_amount":"359.65","room_type_id":"352","product_id":"1748","siteminder_id":"EXP-1171411468","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":"79203","customer_id":"79203","source_of_creation":"Expedia","reservation_created_date":"2018-12-31 19:45:09","canceled_nights_data":"","product_name":"22 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"106.09","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2920612","reservation_id":"67414","confirmation_number":"CC12875002533","room_stay_from":"2019-02-17","room_stay_to":"2019-02-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.73","nightly_discount":"0","subtotal":"103.73","grand_total":"117.21","paid_amount":"117.21","room_type_id":"338","product_id":"1733","siteminder_id":"EXP-1183233852","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":"80637","customer_id":"80637","source_of_creation":"Expedia","reservation_created_date":"2019-01-20 22:25:10","canceled_nights_data":"","product_name":"4 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.73","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2927406","reservation_id":"65172","confirmation_number":"CC12820261382","room_stay_from":"2019-02-16","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"141.45,122.59,122.59","nightly_discount":"0,0,0","subtotal":"386.63","grand_total":"436.89","paid_amount":"436.89","room_type_id":"336","product_id":"1731","siteminder_id":"EXP-1171998637","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":"79301","customer_id":"79301","source_of_creation":"Expedia","reservation_created_date":"2019-01-02 04:20:11","canceled_nights_data":"","product_name":"2 Studio","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"122.59","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2935316","reservation_id":"63789","confirmation_number":"CC12891297633","room_stay_from":"2019-02-14","room_stay_to":"2019-02-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.30,103.73,103.73,94.30","nightly_discount":"0,0,0,0","subtotal":"396.06","grand_total":"447.54","paid_amount":"447.54","room_type_id":"355","product_id":"1751","siteminder_id":"EXP-1165911914","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":"78741","customer_id":"78741","source_of_creation":"Expedia","reservation_created_date":"2018-12-19 17:50:13","canceled_nights_data":"","product_name":"25 Hotel Room","ota_service_fee_amount":"0","commision_charges":"86.94","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[{"room_stay_id":"2910831","reservation_id":"65479","confirmation_number":"CC12864535425","room_stay_from":"2019-02-17","room_stay_to":"2019-02-19","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.25,86.25","nightly_discount":"0,0","subtotal":"172.50","grand_total":"194.93","paid_amount":"97.47","room_type_id":"338","product_id":"1733","siteminder_id":"EXP-1173529736","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":"79445","customer_id":"79445","source_of_creation":"Expedia","reservation_created_date":"2019-01-04 17:50:10","service_canceled_date_time":"2019-01-16 14:46:13","canceled_nights_data":"","product_name":"4 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"97.47","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"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":"2919426","reservation_id":"67086","confirmation_number":"CC12875402776","room_stay_from":"2019-02-15","room_stay_to":"2019-02-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.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","subtotal":"1764.00","grand_total":"1993.32","paid_amount":"1993.32","room_type_id":"356","product_id":"1752","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":"80451","customer_id":"80451","source_of_creation":"PMS","reservation_created_date":"2019-01-17 17:24:26","canceled_nights_data":"","product_name":"26 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"147.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2921062","reservation_id":"67502","confirmation_number":"CC12867796819","room_stay_from":"2019-02-17","room_stay_to":"2019-02-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,150.00,150.00,150.00,160.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"910.00","grand_total":"1028.30","paid_amount":"1028.30","room_type_id":"337","product_id":"1732","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":"80709","customer_id":"80709","source_of_creation":"PMS","reservation_created_date":"2019-01-21 22:58:40","canceled_nights_data":"","product_name":"3 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"150.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2935486","reservation_id":"68601","confirmation_number":"CC12896858943","room_stay_from":"2019-02-16","room_stay_to":"2019-02-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00","nightly_discount":"0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","room_type_id":"353","product_id":"1749","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":"78028","customer_id":"78028","source_of_creation":"PMS","reservation_created_date":"2019-02-04 16:20:24","canceled_nights_data":"","product_name":"23 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2935734","reservation_id":"65831","confirmation_number":"CC12846562509","room_stay_from":"2019-02-17","room_stay_to":"2019-03-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.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","subtotal":"2610.00","grand_total":"2949.30","paid_amount":"2949.30","room_type_id":"349","product_id":"1745","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":"79382","customer_id":"79382","source_of_creation":"PMS","reservation_created_date":"2019-01-07 15:18:17","canceled_nights_data":"","product_name":"18 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"135.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2939880","reservation_id":"65902","confirmation_number":"CC12865343877","room_stay_from":"2019-01-26","room_stay_to":"2019-02-24","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.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","subtotal":"2716.00","grand_total":"3069.08","paid_amount":"3069.08","room_type_id":"358","product_id":"1754","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":"78243","customer_id":"78243","source_of_creation":"PMS","reservation_created_date":"2019-01-07 22:33:12","canceled_nights_data":"","product_name":"28 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"2903039","reservation_id":"62649","confirmation_number":"CC12844463864","room_stay_from":"2019-02-01","room_stay_to":"2019-03-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21","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","subtotal":"1349.88","grand_total":"1349.88","paid_amount":"1349.88","room_type_id":"345","product_id":"1741","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":"1","customer_traveller_id":"78009","customer_id":"78009","source_of_creation":"PMS","reservation_created_date":"2018-12-22 18:19:03","canceled_nights_data":"","product_name":"15 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.21","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[{"room_stay_id":"2894177","reservation_id":"62739","confirmation_number":"11809","room_stay_from":"2019-02-04","room_stay_to":"2019-03-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165","nightly_discount":"49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5","subtotal":"6435.00","grand_total":"5090.09","paid_amount":"5090.09","room_type_id":"354","product_id":"1750","siteminder_id":"","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":"78283","customer_id":"78283","source_of_creation":"PMS","reservation_created_date":"2018-03-12 00:00:00","canceled_nights_data":"","product_name":"24 Studio","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"11809","currentDayPrice":"165","currentDayDiscount":"49.5","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2894300","reservation_id":"62777","confirmation_number":"CC12867448369","room_stay_from":"2019-02-16","room_stay_to":"2019-02-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.12,111.38","nightly_discount":"0.00,0.00","subtotal":"229.50","grand_total":"259.34","paid_amount":"259.34","room_type_id":"343","product_id":"1739","siteminder_id":"BDC-1237803101","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":"78298","customer_id":"78298","source_of_creation":"Booking.com","reservation_created_date":"2018-12-06 07:00:18","canceled_nights_data":"","product_name":"14 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"1","currentDayPrice":"111.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2926858","reservation_id":"62731","confirmation_number":"12336","room_stay_from":"2019-01-28","room_stay_to":"2019-02-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"3525.00","grand_total":"3983.25","paid_amount":"3983.25","room_type_id":"351","product_id":"1747","siteminder_id":"EXP-1134728378","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":"78276","customer_id":"78276","source_of_creation":"Expedia","reservation_created_date":"2018-10-21 00:00:00","canceled_nights_data":"","product_name":"20 Studio","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"12336","currentDayPrice":"125.89285714286","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2933937","reservation_id":"62746","confirmation_number":"11831","room_stay_from":"2019-02-12","room_stay_to":"2019-03-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,430.00,430.00","nightly_discount":"86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,172.00,172.00","subtotal":"4300.00","grand_total":"2915.40","paid_amount":"2915.40","room_type_id":"350","product_id":"1746","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":"78291","customer_id":"78291","source_of_creation":"PMS","reservation_created_date":"2018-03-22 00:00:00","canceled_nights_data":"","product_name":"19 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"11831","currentDayPrice":"215.00","currentDayDiscount":"86.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2935313","reservation_id":"62777","confirmation_number":"CC12830385857","room_stay_from":"2019-02-16","room_stay_to":"2019-02-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.12,111.38","nightly_discount":"0.00,0.00","subtotal":"229.50","grand_total":"259.34","paid_amount":"259.34","room_type_id":"346","product_id":"1742","siteminder_id":"BDC-1237803101","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":"78298","customer_id":"78298","source_of_creation":"Booking.com","reservation_created_date":"2018-12-06 07:00:18","canceled_nights_data":"","product_name":"16 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"1","currentDayPrice":"111.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2936582","reservation_id":"62752","confirmation_number":"12511","room_stay_from":"2019-02-17","room_stay_to":"2019-02-24","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"151.00,151.00,151.00,151.00,151.00,151.00,151.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1057.00","grand_total":"1194.41","paid_amount":"1194.41","room_type_id":"342","product_id":"1738","siteminder_id":"BDC-1590642804","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":"78300","customer_id":"78300","source_of_creation":"Booking.com","reservation_created_date":"2018-11-27 00:00:00","canceled_nights_data":"","product_name":"12 One bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"12511","currentDayPrice":"151.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}