{"hotel_id":"128","sub_hotel_id":0,"room_type":"hotel","date":"2021-04-03","total_rooms_exist":"1731,1732,1733,1738,1739,1741,1742,1744,1745,1746,1747,1748,1749,1750,1751,1752,1753,1754","departureCount":6,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"1732,1733,1741,1742,1753,1754,1738,1739","bundle_block_bookings":[{"confirmation_number":"CCB12826391159","room_stay_from":"2021-04-01","room_stay_to":"2021-04-04","bundle_room":"1","product_id":"1737"},{"confirmation_number":"CCB12821173499","room_stay_from":"2021-04-03","room_stay_to":"2021-04-06","bundle_room":"1","product_id":"1743"},{"confirmation_number":"CCB12835980194","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","bundle_room":"1","product_id":"1755"},{"confirmation_number":"CCB12839164295","room_stay_from":"2020-12-15","room_stay_to":"2021-05-20","bundle_room":"1","product_id":"1740"}]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3221571","reservation_id":"111144","confirmation_number":"CC12833255624","room_stay_from":"2021-04-01","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.90,126.90,126.90","nightly_discount":"0,0,0","subtotal":"362.70","grand_total":"409.85","paid_amount":"409.85","room_type_id":"354","product_id":"1750","siteminder_id":"BDC-3930788961","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":"117675","customer_id":"117675","source_of_creation":"Booking.com","reservation_created_date":"2021-03-24 00:22:13","canceled_nights_data":"","product_name":"24 Studio","ota_service_fee_amount":"0","commision_charges":"54.42","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"128","group_rooms":null,"currentDayPrice":"126.90","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":"3222525","reservation_id":"111106","confirmation_number":"CC12883980233","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"121.50","nightly_discount":"0","subtotal":"121.50","grand_total":"137.30","paid_amount":"137.30","room_type_id":"351","product_id":"1747","siteminder_id":"BDC-3577926609","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":"117644","customer_id":"117644","source_of_creation":"Booking.com","reservation_created_date":"2021-03-23 19:27:11","canceled_nights_data":"","product_name":"20 Studio","ota_service_fee_amount":"0","commision_charges":"18.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"128","group_rooms":null,"currentDayPrice":"121.50","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":"3220094","reservation_id":"110448","confirmation_number":"CC12852973230","room_stay_from":"2021-03-30","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.40,129.60,122.40,136.80,136.80,129.60,129.60","nightly_discount":"0,0,0,0,0,0,0","subtotal":"907.20","grand_total":"1025.13","paid_amount":"1025.13","room_type_id":"350","product_id":"1746","siteminder_id":"BDC-2427062309","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":"116957","customer_id":"116957","source_of_creation":"Booking.com","reservation_created_date":"2021-03-16 19:39:09","canceled_nights_data":"","product_name":"19 One Bedroom","ota_service_fee_amount":"0","commision_charges":"136.08","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"128","group_rooms":null,"currentDayPrice":"136.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":"3227097","reservation_id":"110776","confirmation_number":"CC12817920387","room_stay_from":"2021-05-28","room_stay_to":"2021-05-31","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"158.00,158.00,138.00","nightly_discount":"0,0,0","subtotal":"454.00","grand_total":"513.02","paid_amount":"285.34","room_type_id":"342","product_id":"1738","siteminder_id":"BDC-2535670603","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":"117286","customer_id":"117286","source_of_creation":"Booking.com","reservation_created_date":"2021-03-20 00:10:12","canceled_nights_data":"","product_name":"12 One bedroom","ota_service_fee_amount":"0","commision_charges":"15.30","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"128","changedComment":"From 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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3220867","reservation_id":"110181","confirmation_number":"CC12875347427","room_stay_from":"2021-04-02","room_stay_to":"2021-04-04","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"121.50,121.50","nightly_discount":"0,0","subtotal":"243.00","grand_total":"274.59","paid_amount":"274.59","room_type_id":"343","product_id":"1739","siteminder_id":"EXP-1747016508","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":"116700","customer_id":"116700","source_of_creation":"Expedia","reservation_created_date":"2021-03-13 03:38:07","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":"","promotion_code":"","sub_hotel_id":"128","group_rooms":null,"currentDayPrice":"121.50","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":"3224526","reservation_id":"111454","confirmation_number":"CC12827780054","room_stay_from":"2021-04-02","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"118.17,118.17","nightly_discount":"0,0","subtotal":"236.34","grand_total":"267.06","paid_amount":"267.06","room_type_id":"357","product_id":"1753","siteminder_id":"EXP-1752801395","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":"118004","customer_id":"118004","source_of_creation":"Expedia","reservation_created_date":"2021-03-27 19:22:12","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":"","promotion_code":"","sub_hotel_id":"128","group_rooms":null,"currentDayPrice":"118.17","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":"3227026","reservation_id":"111571","confirmation_number":"CC12861113868","room_stay_from":"2021-04-03","room_stay_to":"2021-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"87.21,78.58","nightly_discount":"0,0","subtotal":"165.79","grand_total":"187.35","paid_amount":"187.35","room_type_id":"338","product_id":"1733","siteminder_id":"EXP-1753319100","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":"118129","customer_id":"118129","source_of_creation":"Expedia","reservation_created_date":"2021-03-29 03:17:06","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":"","promotion_code":"","sub_hotel_id":"128","currentDayPrice":"87.21","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":"3227205","reservation_id":"111147","confirmation_number":"CC12842824656","room_stay_from":"2021-04-03","room_stay_to":"2021-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"161.10,152.10,152.10","nightly_discount":"0.00,0.00,0.00","subtotal":"465.30","grand_total":"525.79","paid_amount":"525.79","room_type_id":"345","product_id":"1741","siteminder_id":"EXP-1751333039","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":"117678","customer_id":"117678","source_of_creation":"Expedia","reservation_created_date":"2021-03-24 01:02:12","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":"","promotion_code":"","sub_hotel_id":"128","currentDayPrice":"161.10","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"}]}],"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":[{"room_stay_id":"3227027","reservation_id":"111493","confirmation_number":"CC12878085493","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"94.28","nightly_discount":"0","subtotal":"94.28","grand_total":"123.01","paid_amount":"123.01","room_type_id":"346","product_id":"1742","siteminder_id":"ABB-HMKY2X5BC3","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"94.28","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118059","customer_id":"118059","source_of_creation":"Airbnb","reservation_created_date":"2021-03-28 04:05:09","canceled_nights_data":"","product_name":"16 Hotel Room","ota_service_fee_amount":"13.18","commision_charges":"2.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"128","currentDayPrice":"94.28","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"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3223861","reservation_id":"111499","confirmation_number":"CC12895453398","room_stay_from":"2021-04-02","room_stay_to":"2021-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"121.00,121.00,111.00","nightly_discount":"0.00,0.00,0.00","subtotal":"353.00","grand_total":"398.89","paid_amount":"398.89","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":"118065","customer_id":"118065","source_of_creation":"FE","reservation_created_date":"2021-03-28 13:57:41","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"121.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":"3222757","reservation_id":"109280","confirmation_number":"CC12887968708","room_stay_from":"2021-04-02","room_stay_to":"2021-04-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"161.00,161.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":"1077.00","grand_total":"1217.01","paid_amount":"1217.01","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":"115574","customer_id":"115574","source_of_creation":"FE","reservation_created_date":"2021-03-04 01:32:26","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"161.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":"3222516","reservation_id":"111041","confirmation_number":"CC12854376941","room_stay_from":"2021-04-03","room_stay_to":"2021-04-10","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"161.00,151.00,151.00,151.00,151.00,151.00,155.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1071.00","grand_total":"1210.23","paid_amount":"1210.23","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":"117583","customer_id":"117583","source_of_creation":"FE","reservation_created_date":"2021-03-23 00:31:28","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"161.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":"3222831","reservation_id":"111364","confirmation_number":"CC12888779238","room_stay_from":"2021-03-28","room_stay_to":"2021-04-04","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,140.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"905.00","grand_total":"1022.65","paid_amount":"1022.65","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":"117905","customer_id":"117905","source_of_creation":"PMS","reservation_created_date":"2021-03-26 18:53: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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"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":"3227196","reservation_id":"111107","confirmation_number":"CC12897799546","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"150.00","nightly_discount":"0.00","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","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":"117645","customer_id":"117645","source_of_creation":"PMS","reservation_created_date":"2021-03-23 19:55:26","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":"","promotion_code":"","sub_hotel_id":"0","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":"3226594","reservation_id":"106433","confirmation_number":"CC12887318013","room_stay_from":"2021-03-21","room_stay_to":"2021-04-19","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.36,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28,64.28","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,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1864.20","grand_total":"2106.54","paid_amount":"1525.46","room_type_id":"355","product_id":"1751","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":"112828","customer_id":"112828","source_of_creation":"PMS","reservation_created_date":"2021-03-10 18:53:09","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"64.28","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":"3218852","reservation_id":"110733","confirmation_number":"CC12899299385","room_stay_from":"2021-03-29","room_stay_to":"2021-04-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,103.23,0.45,103.23,103.23,103.23,103.23,103.23,103.23","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","subtotal":"3097.35","grand_total":"3500.00","paid_amount":"3500.00","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":"117246","customer_id":"117246","source_of_creation":"PMS","reservation_created_date":"2021-03-19 18:25:26","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"103.23","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":"3227186","reservation_id":"97842","confirmation_number":"CC12878581286","room_stay_from":"2020-08-26","room_stay_to":"2021-05-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.95,70.80,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.00,40.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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1075.75","grand_total":"1215.60","paid_amount":"221.20","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":"103911","customer_id":"103911","source_of_creation":"PMS","reservation_created_date":"2020-07-16 23:49:34","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":"","promotion_code":"","sub_hotel_id":"0","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"0.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":"3214457","reservation_id":"101159","confirmation_number":"CC12859385074","room_stay_from":"2020-12-15","room_stay_to":"2021-05-20","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.00,133.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,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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"19131.00","grand_total":"21618.03","paid_amount":"21618.03","room_type_id":"342","product_id":"1738","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":"109628","customer_id":"109628","source_of_creation":"PMS","reservation_created_date":"2020-10-05 15:32:23","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"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"}]}],"pms_non_taxable":[{"room_stay_id":"3225926","reservation_id":"99007","confirmation_number":"CC12894465399","room_stay_from":"2020-08-13","room_stay_to":"2021-05-13","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.00,66.66,66.66,66.66,66.66,66.66,0.00,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,67.49,0.00,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,67.40,66.66,66.66,66.66,66.66,66.66,33.32,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,0.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,100.00,100.00,100.00,100.00,100.00,100.00,100.00,100.00,0.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,200.00,200.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,100.00,0.00,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66,66.66","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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"21999.91","grand_total":"21999.91","paid_amount":"21999.91","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":"1","traveller_tax_exempt":"1","customer_traveller_id":"104989","customer_id":"104989","source_of_creation":"PMS","reservation_created_date":"2020-08-14 02:01:42","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":"","promotion_code":"","sub_hotel_id":"0","group_rooms":null,"currentDayPrice":"100.00","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":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3227197","reservation_id":"111107","confirmation_number":"CC12860742128","room_confirmation_number":"CC12897799546","room_stay_from":"2021-04-03","room_stay_to":"2021-04-04","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1785","service_quantity":"1","customer_traveller_id":"117645","product_attribute_values":"extra_person#&#20","reservation_created_date":"2021-04-03 18:21:13","reservation_modified_date_time":"2021-04-03 18:21:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117645","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"0","currentDayPrice":"20","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3214993","reservation_id":"110181","confirmation_number":"CC12833752013","room_confirmation_number":"CC12875347427","room_stay_from":"2021-04-02","room_stay_to":"2021-04-04","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"42.80","paid_amount":"42.80","product_id":"1761","service_quantity":"1","product_name":"Travelling with pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-13 16:00:34","reservation_modified_date_time":"2021-03-13 16:00:34","customer_id":"116700","parentCustTravId":"116700","customer_traveller_id":"116700","static_pos_type":"petfee","product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-04-02","sub_hotel_id":"128","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3224060","reservation_id":"111364","confirmation_number":"CC12823283522","room_confirmation_number":"CC12888779238","room_stay_from":"2021-03-28","room_stay_to":"2021-04-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"149.80","paid_amount":"149.80","product_id":"1761","service_quantity":"1","product_name":"Travelling with pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-03-28 18:31:56","reservation_modified_date_time":"2021-03-28 18:31:56","customer_id":"117905","parentCustTravId":"117905","customer_traveller_id":"117905","static_pos_type":"petfee","product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-03-28","sub_hotel_id":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3227207","reservation_id":"111147","confirmation_number":"CC12866032104","room_confirmation_number":"CC12842824656","room_stay_from":"2021-04-03","room_stay_to":"2021-04-06","room_stay_status":"Active","nightly_price":"30.00,30.00,30.00","nightly_discount":"0.00,0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"0.00","product_id":"1785","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2021-04-03 18:21:58","reservation_modified_date_time":"2021-04-03 18:22:40","customer_id":"117678","parentCustTravId":"117678","customer_traveller_id":"117678","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-04-03","sub_hotel_id":"128","currentDayPrice":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":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"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}