{"hotel_id":"128","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-17","total_rooms_exist":"1731,1732,1733,1736,1738,1739,1741,1742,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754","departureCount":8,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1748","block_room_bookings":[{"confirmation_number":"CC12841541191","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","bundle_room":"0"}],"bundle_block_count":"1738,1739,1753,1754,1732,1733,1741,1742","bundle_block_bookings":[{"confirmation_number":"CCB12892405504","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","bundle_room":"1"},{"confirmation_number":"CCB12877950989","room_stay_from":"2020-01-16","room_stay_to":"2020-01-18","bundle_room":"1"},{"confirmation_number":"CCB12865752952","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","bundle_room":"1"},{"confirmation_number":"CCB12840520162","room_stay_from":"2020-01-17","room_stay_to":"2020-01-20","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3057394","reservation_id":"89073","confirmation_number":"CC12811048406","room_stay_from":"2020-01-14","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.35,145.35,145.35,162.35","nightly_discount":"0,0,0,0","subtotal":"598.40","grand_total":"676.19","paid_amount":"676.19","room_type_id":"358","product_id":"1754","siteminder_id":"BDC-3993102638","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":"95133","customer_id":"95133","source_of_creation":"Booking.com","reservation_created_date":"2020-01-01 18:42:11","canceled_nights_data":"","product_name":"28 One Bedroom","ota_service_fee_amount":"0","commision_charges":"89.76","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"162.35","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":"3058722","reservation_id":"90073","confirmation_number":"CC12886988338","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00","nightly_discount":"0","subtotal":"126.00","grand_total":"142.38","paid_amount":"142.38","room_type_id":"338","product_id":"1733","siteminder_id":"BDC-3428222375","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":"96107","customer_id":"96107","source_of_creation":"Booking.com","reservation_created_date":"2020-01-16 15:11:09","canceled_nights_data":"","product_name":"4 Hotel Room","ota_service_fee_amount":"0","commision_charges":"18.90","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.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":"3058444","reservation_id":"89796","confirmation_number":"CC12855115519","room_stay_from":"2020-01-16","room_stay_to":"2020-01-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.40,131.40,131.40,113.40,113.40","nightly_discount":"0,0,0,0,0","subtotal":"594.00","grand_total":"671.22","paid_amount":"671.22","room_type_id":"350","product_id":"1746","siteminder_id":"BDC-2730273396","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":"95815","customer_id":"95815","source_of_creation":"Booking.com","reservation_created_date":"2020-01-12 07:30:06","canceled_nights_data":"","product_name":"19 One Bedroom","ota_service_fee_amount":"0","commision_charges":"89.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.40","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":[{"room_stay_id":"3039531","reservation_id":"87287","confirmation_number":"CC12811049552","room_stay_from":"2020-01-16","room_stay_to":"2020-01-18","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"138.60,147.60","nightly_discount":"0,0","subtotal":"286.20","grand_total":"323.40","paid_amount":"161.70","room_type_id":"357","product_id":"1753","siteminder_id":"BDC-3949787271","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":"93846","customer_id":"93846","source_of_creation":"Booking.com","reservation_created_date":"2019-11-18 19:36:10","service_canceled_date_time":"2020-01-17 07:32:07","canceled_nights_data":"","product_name":"27 Hotel Room","ota_service_fee_amount":"0","commision_charges":"42.93","deltaChange":"5.08","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"3056504","reservation_id":"89738","confirmation_number":"CC12821779117","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"140.00","nightly_discount":"0","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","room_type_id":"343","product_id":"1739","siteminder_id":"EXP-1392217710","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":"95752","customer_id":"95752","source_of_creation":"Expedia","reservation_created_date":"2020-01-11 01:48:09","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":"","currentDayPrice":"140.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":"3058782","reservation_id":"90117","confirmation_number":"CC12812020879","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"114.80","nightly_discount":"0","subtotal":"114.80","grand_total":"129.73","paid_amount":"129.73","room_type_id":"342","product_id":"1738","siteminder_id":"EXP-1624539795","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":"96150","customer_id":"96150","source_of_creation":"Expedia","reservation_created_date":"2020-01-17 11:28:07","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":"","currentDayPrice":"114.80","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":"3058862","reservation_id":"90131","confirmation_number":"CC12875445814","room_stay_from":"2020-01-17","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.80","nightly_discount":"0","subtotal":"114.80","grand_total":"129.73","paid_amount":"129.73","room_type_id":"357","product_id":"1753","siteminder_id":"EXP-1624685208","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":"96164","customer_id":"96164","source_of_creation":"Expedia","reservation_created_date":"2020-01-17 17:18:09","canceled_nights_data":"","product_name":"27 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.80","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":"3058867","reservation_id":"89942","confirmation_number":"CC12863757021","room_stay_from":"2020-01-17","room_stay_to":"2020-01-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.16,113.16,96.76","nightly_discount":"0,0,0","subtotal":"323.08","grand_total":"365.08","paid_amount":"365.08","room_type_id":"355","product_id":"1751","siteminder_id":"EXP-1622661911","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":"95963","customer_id":"95963","source_of_creation":"Expedia","reservation_created_date":"2020-01-14 07:53:07","canceled_nights_data":"","product_name":"25 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.16","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":"3059877","reservation_id":"90105","confirmation_number":"CC12879863790","room_stay_from":"2020-01-17","room_stay_to":"2020-01-20","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"140.00,140.00,119.11","nightly_discount":"0.00,0.00,0.00","subtotal":"399.11","grand_total":"451.00","paid_amount":"451.00","room_type_id":"346","product_id":"1742","siteminder_id":"EXP-1624316080","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":"96137","customer_id":"96137","source_of_creation":"Expedia","reservation_created_date":"2020-01-17 00:33:10","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":"","currentDayPrice":"140.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":"3058859","reservation_id":"82669","confirmation_number":"CC12889357584","room_stay_from":"2019-12-31","room_stay_to":"2020-01-02","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"1","nightly_price":"200.29,200.29","nightly_discount":"0,0","subtotal":"400.58","grand_total":"452.65","paid_amount":"452.65","room_type_id":"347","product_id":"1743","siteminder_id":"EXP-1322393720","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":"90240","customer_id":"90240","source_of_creation":"Expedia","reservation_created_date":"2019-08-15 11:32:08","canceled_nights_data":"","product_name":"15 + 16 Two Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","changedComment":"From date changed","deltaChange":"-200.29","currentDayPrice":0,"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":"3057110","reservation_id":"89740","confirmation_number":"CC12842529718","room_stay_from":"2020-01-17","room_stay_to":"2020-01-20","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"149.24,149.24,132.84","nightly_discount":"0,0,0","subtotal":"431.32","grand_total":"487.39","paid_amount":"0.00","room_type_id":"345","product_id":"1741","siteminder_id":"EXP-1620927301","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":"95754","customer_id":"95754","source_of_creation":"Expedia","reservation_created_date":"2020-01-11 02:48:06","service_canceled_date_time":"2020-01-14 17:48:08","canceled_nights_data":"","product_name":"15 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"243.69","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":[{"room_stay_id":"3058051","reservation_id":"90008","confirmation_number":"CC12833204839","room_stay_from":"2020-01-16","room_stay_to":"2020-01-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.40,116.40,116.40","nightly_discount":"0,0,0","subtotal":"349.20","grand_total":"455.62","paid_amount":"455.62","room_type_id":"354","product_id":"1750","siteminder_id":"ABB-HMEQ5AA8M8","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"349.20","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96035","customer_id":"96035","source_of_creation":"Airbnb","reservation_created_date":"2020-01-15 13:33:04","canceled_nights_data":"","product_name":"24 Studio","ota_service_fee_amount":"48.82","commision_charges":"10.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"116.40","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]},{"room_stay_id":"3058888","reservation_id":"90042","confirmation_number":"CC12879247978","room_stay_from":"2020-01-17","room_stay_to":"2020-01-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.91,99.91,99.91,99.91","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"399.64","grand_total":"521.42","paid_amount":"521.42","room_type_id":"356","product_id":"1752","siteminder_id":"ABB-HMHH89R9N4","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"399.64","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96070","customer_id":"96070","source_of_creation":"Airbnb","reservation_created_date":"2020-01-15 20:59:09","canceled_nights_data":"","product_name":"26 One Bedroom","ota_service_fee_amount":"55.87","commision_charges":"12.36","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.91","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3055226","reservation_id":"89130","confirmation_number":"CC12894536491","room_stay_from":"2020-01-15","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"143.00,143.00,173.00","nightly_discount":"0.00,0.00,0.00","subtotal":"459.00","grand_total":"518.67","paid_amount":"518.67","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":"95053","customer_id":"95053","source_of_creation":"FE","reservation_created_date":"2020-01-02 17:37:07","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":"173.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":"3057100","reservation_id":"87919","confirmation_number":"CC12853680316","room_stay_from":"2020-01-16","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"140.00,150.00","nightly_discount":"0.00,0.00","subtotal":"290.00","grand_total":"327.70","paid_amount":"327.70","room_type_id":"348","product_id":"1744","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":"94335","customer_id":"94335","source_of_creation":"FE","reservation_created_date":"2019-12-06 04:20:42","canceled_nights_data":"","product_name":"17 Studio","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":"3058441","reservation_id":"88406","confirmation_number":"CC12844525460","room_stay_from":"2020-01-16","room_stay_to":"2020-01-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"188.00,188.00,178.00,178.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"732.00","grand_total":"827.16","paid_amount":"827.16","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":"0","traveller_tax_exempt":"0","customer_traveller_id":"94636","customer_id":"94636","source_of_creation":"FE","reservation_created_date":"2019-12-17 02:40:23","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":"188.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3057793","reservation_id":"63032","confirmation_number":"CC12887553366","room_stay_from":"2019-12-16","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.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","subtotal":"3300.00","grand_total":"3729.00","paid_amount":"3729.00","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":"78453","customer_id":"78453","source_of_creation":"PMS","reservation_created_date":"2019-11-07 18:37:00","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":"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":"3058848","reservation_id":"90029","confirmation_number":"CC12887589018","room_stay_from":"2020-01-16","room_stay_to":"2020-01-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0.00","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"336","product_id":"1731","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":"96054","customer_id":"96054","source_of_creation":"PMS","reservation_created_date":"2020-01-16 15:43:00","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"99.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":"3049764","reservation_id":"81008","confirmation_number":"CC12816344707","room_stay_from":"2020-01-17","room_stay_to":"2020-01-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.00,103.00","nightly_discount":"0.00,0.00","subtotal":"206.00","grand_total":"232.78","paid_amount":"232.78","room_type_id":"351","product_id":"1747","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":"89124","customer_id":"89124","source_of_creation":"PMS","reservation_created_date":"2019-12-23 18:22:58","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":"","currentDayPrice":"103.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":"3058970","reservation_id":"89728","confirmation_number":"CC12838100726","room_stay_from":"2020-01-13","room_stay_to":"2020-01-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.00,113.00,113.00,113.00,113.00,113.00,113.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"791.00","grand_total":"893.83","paid_amount":"893.83","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":"95736","customer_id":"95736","source_of_creation":"PMS","reservation_created_date":"2020-01-13 18:36:24","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"113.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":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3055227","reservation_id":"89130","confirmation_number":"CC12837038510","room_confirmation_number":"CC12894536491","room_stay_from":"2020-01-15","room_stay_to":"2020-01-18","room_stay_status":"Active","nightly_price":"40,40,40","nightly_discount":"0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1785","service_quantity":"1","customer_traveller_id":"95053","product_attribute_values":"extra_person#&#20","reservation_created_date":"2020-01-08 13:21:11","reservation_modified_date_time":"2020-01-08 13:21:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95053","canceled_nights_data":"","currentDayPrice":"40","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"}]}],"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":[]}}