{"hotel_id":"128","sub_hotel_id":0,"room_type":"hotel","date":"2020-02-17","total_rooms_exist":"1731,1732,1733,1736,1738,1739,1741,1742,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754","holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1741,1742,1738,1739,1732,1733,1753,1754","bundle_block_bookings":[{"confirmation_number":"CCB12832169645","room_stay_from":"2020-02-16","room_stay_to":"2020-02-18","bundle_room":"1"},{"confirmation_number":"CCB12860954608","room_stay_from":"2020-02-17","room_stay_to":"2020-02-18","bundle_room":"1"},{"confirmation_number":"CCB12888424978","room_stay_from":"2020-02-16","room_stay_to":"2020-03-02","bundle_room":"1"},{"confirmation_number":"CCB12871626434","room_stay_from":"2020-02-15","room_stay_to":"2020-03-16","bundle_room":"1"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3070445","reservation_id":"91763","confirmation_number":"CC12835721926","room_stay_from":"2020-02-17","room_stay_to":"2020-02-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.60,129.60","nightly_discount":"0.00,0.00","subtotal":"241.20","grand_total":"272.55","paid_amount":"272.55","room_type_id":"353","product_id":"1749","siteminder_id":"BDC-3603815285","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":"97906","customer_id":"97906","source_of_creation":"Booking.com","reservation_created_date":"2020-02-11 01:20:11","canceled_nights_data":"","product_name":"23 One Bedroom","ota_service_fee_amount":"0","commision_charges":"36.18","currentDayPrice":"111.60","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3070587","reservation_id":"92079","confirmation_number":"CC12812474637","room_stay_from":"2020-02-17","room_stay_to":"2020-02-19","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"106.40,117.40","nightly_discount":"0,0","subtotal":"223.80","grand_total":"252.90","paid_amount":"252.90","room_type_id":"343","product_id":"1739","siteminder_id":"EXP-1643082984","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":"98255","customer_id":"98255","source_of_creation":"Expedia","reservation_created_date":"2020-02-17 03:34:09","canceled_nights_data":"","product_name":"14 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"106.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"}]},{"room_stay_id":"3070699","reservation_id":"92093","confirmation_number":"CC12881599914","room_stay_from":"2020-02-17","room_stay_to":"2020-02-19","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"87.25,96.27","nightly_discount":"0,0","subtotal":"183.52","grand_total":"207.38","paid_amount":"207.38","room_type_id":"355","product_id":"1751","siteminder_id":"EXP-1643364174","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":"98267","customer_id":"98267","source_of_creation":"Expedia","reservation_created_date":"2020-02-17 16:04:07","canceled_nights_data":"","product_name":"25 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"87.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"}]}],"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":"3070661","reservation_id":"92087","confirmation_number":"CC12851049719","room_stay_from":"2020-02-17","room_stay_to":"2020-02-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.00","nightly_discount":"0.00","subtotal":"102.00","grand_total":"115.26","paid_amount":"115.26","room_type_id":"357","product_id":"1753","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":"93133","customer_id":"93133","source_of_creation":"FE","reservation_created_date":"2020-02-17 13:51:08","canceled_nights_data":"","product_name":"27 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"102.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":"3060965","reservation_id":"84716","confirmation_number":"CC12894991486","room_stay_from":"2020-02-04","room_stay_to":"2020-02-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.00,156.00,156.00,166.00,166.00,156.00,156.00,120.00,156.00,156.00,166.00,166.00,156.00,130.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":"2150.00","grand_total":"2429.50","paid_amount":"2429.50","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":"92033","customer_id":"92033","source_of_creation":"PMS","reservation_created_date":"2019-09-26 13:51:43","canceled_nights_data":"","product_name":"15 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"130.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":"3069849","reservation_id":"91971","confirmation_number":"CC12879328811","room_stay_from":"2020-02-16","room_stay_to":"2020-02-19","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.50,152.90,163.90","nightly_discount":"0.00,0.00,0.00","subtotal":"487.30","grand_total":"550.65","paid_amount":"550.65","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":"98118","customer_id":"98118","source_of_creation":"PMS","reservation_created_date":"2020-02-14 15:21:41","canceled_nights_data":"","product_name":"26 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"152.90","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":"2977449","reservation_id":"76617","confirmation_number":"CC12895749537","room_stay_from":"2020-02-15","room_stay_to":"2020-02-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"121.42,121.42,121.42,121.42,121.42,121.42,121.42,121.42,121.42,121.42,121.42,121.40,121.09,121.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":"1699.11","grand_total":"1920.00","paid_amount":"1920.00","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":"78275","customer_id":"78275","source_of_creation":"PMS","reservation_created_date":"2019-05-16 20:09:14","canceled_nights_data":"","product_name":"20 Studio","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"121.42","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":"3014919","reservation_id":"62738","confirmation_number":"CC12882533561","room_stay_from":"2020-02-08","room_stay_to":"2020-03-01","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.00,155.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","subtotal":"3410.00","grand_total":"3853.30","paid_amount":"3853.30","room_type_id":"352","product_id":"1748","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":"78282","customer_id":"78282","source_of_creation":"PMS","reservation_created_date":"2019-02-15 18:27:32","canceled_nights_data":"","product_name":"22 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"155.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":"3054791","reservation_id":"89453","confirmation_number":"CC12866521237","room_stay_from":"2020-02-02","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.00,122.82,123.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":"3539.82","grand_total":"4000.00","paid_amount":"4000.00","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":"95423","customer_id":"95423","source_of_creation":"PMS","reservation_created_date":"2020-01-06 15:51:31","canceled_nights_data":"","product_name":"18 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"122.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":"3057804","reservation_id":"89952","confirmation_number":"CC12818468947","room_stay_from":"2020-02-07","room_stay_to":"2020-03-02","room_stay_status":"Checked-In","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","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","subtotal":"2400.00","grand_total":"2712.00","paid_amount":"2712.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":"2020-01-14 15:46:16","canceled_nights_data":"","product_name":"3 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","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":"3061098","reservation_id":"90446","confirmation_number":"CC12874125027","room_stay_from":"2020-02-16","room_stay_to":"2020-03-08","room_stay_status":"Checked-In","room_stay_guest_count":"1","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","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","subtotal":"2100.00","grand_total":"2373.00","paid_amount":"2373.00","room_type_id":"338","product_id":"1733","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":"96496","customer_id":"96496","source_of_creation":"PMS","reservation_created_date":"2020-01-23 19:04:41","canceled_nights_data":"","product_name":"4 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","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":"3063971","reservation_id":"86803","confirmation_number":"CC12850300044","room_stay_from":"2020-01-22","room_stay_to":"2020-03-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,200.00,200.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.00,125.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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"6025.00","grand_total":"6808.25","paid_amount":"6808.25","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":"79631","customer_id":"79631","source_of_creation":"PMS","reservation_created_date":"2019-11-07 20:44:18","canceled_nights_data":"","product_name":"19 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"125.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":"2926122","reservation_id":"62748","confirmation_number":"CC12838877765","room_stay_from":"2020-02-10","room_stay_to":"2020-03-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.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":"3335.00","grand_total":"3768.55","paid_amount":"3768.55","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":"78294","customer_id":"78294","source_of_creation":"PMS","reservation_created_date":"2019-01-24 16:24:13","canceled_nights_data":"","product_name":"2 Studio","ota_service_fee_amount":"0","commision_charges":"0.00","currentDayPrice":"115.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":"3070689","reservation_id":"89514","confirmation_number":"CC12876513577","room_stay_from":"2020-02-05","room_stay_to":"2020-03-11","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,102.00,204.00,204.00,204.00,204.00,204.00,204.00,204.00,204.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","subtotal":"4386.00","grand_total":"4956.18","paid_amount":"3342.54","room_type_id":"354","product_id":"1750","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":"95494","customer_id":"95494","source_of_creation":"PMS","reservation_created_date":"2020-01-07 18:20:02","canceled_nights_data":"","product_name":"24 Studio","ota_service_fee_amount":"0","commision_charges":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"102.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":"2979746","reservation_id":"77110","confirmation_number":"CC12811266666","room_stay_from":"2020-02-15","room_stay_to":"2020-03-16","room_stay_status":"Checked-In","room_stay_guest_count":"1","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,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.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","subtotal":"4050.00","grand_total":"4576.50","paid_amount":"4576.50","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":"86573","customer_id":"86573","source_of_creation":"PMS","reservation_created_date":"2019-05-22 17:43:36","canceled_nights_data":"","product_name":"28 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","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":"3070748","reservation_id":"89952","confirmation_number":"CC12856014222","room_stay_from":"2020-03-02","room_stay_to":"2020-03-19","room_stay_status":"Active","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","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","subtotal":"1700.00","grand_total":"1921.00","paid_amount":"0.00","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":"78453","customer_id":"78453","source_of_creation":"PMS","reservation_created_date":"2020-01-14 15:50:07","canceled_nights_data":"","product_name":"18 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","changedComment":"To date changed","deltaChange":"0.00","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"}]},{"room_stay_id":"3070558","reservation_id":"83112","confirmation_number":"CC12888641512","room_stay_from":"2020-02-16","room_stay_to":"2020-02-19","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.00,123.00,123.00","nightly_discount":"0.00,0.00,0.00","subtotal":"369.00","grand_total":"416.97","paid_amount":"208.48","room_type_id":"364","product_id":"1789","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":"90543","customer_id":"90543","source_of_creation":"PMS","reservation_created_date":"2019-08-23 22:16:36","service_canceled_date_time":"2020-02-17 13:31:49","canceled_nights_data":"","product_name":"CC Walk","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"246.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":"123.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":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3070725","reservation_id":"91352","confirmation_number":"CC12828581084","room_confirmation_number":"CC12834679963","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"35.00","grand_total":"35.00","paid_amount":"35.00","product_id":"1773","service_quantity":"1","product_name":"Late Departure","parentTypeOfRes":"reservation","reservation_created_date":"2020-02-17 16:40:09","reservation_modified_date_time":"2020-02-17 16:40:09","customer_id":"97476","parentCustTravId":"97476","customer_traveller_id":"97476","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"35.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}