{"hotel_id":"128","sub_hotel_id":0,"room_type":"hotel","date":"2019-12-14","total_rooms_exist":19,"departureCount":8,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"0","block_room_bookings":[],"bundle_block_count":"5","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3044316","reservation_id":"87684","confirmation_number":"CC12858915408","room_stay_from":"2019-12-01","room_stay_to":"2019-12-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"88.80,85.80,85.80,85.80,85.80,91.80,91.80,91.80,91.80,91.80,91.80,91.80,91.80,91.80,91.80,91.80,91.80","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1533.60","grand_total":"1732.97","paid_amount":"1732.97","room_type_id":"349","product_id":"1745","siteminder_id":"BDC-2543396517","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":"94158","customer_id":"94158","source_of_creation":"Booking.com","reservation_created_date":"2019-11-30 22:22:06","canceled_nights_data":"","product_name":"18 One Bedroom","ota_service_fee_amount":"0","commision_charges":"92.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.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":"3046035","reservation_id":"88150","confirmation_number":"CC12893716098","room_stay_from":"2019-12-14","room_stay_to":"2019-12-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.03","nightly_discount":"0","subtotal":"78.03","grand_total":"88.17","paid_amount":"88.17","room_type_id":"346","product_id":"1742","siteminder_id":"BDC-3768802536","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":"94479","customer_id":"94479","source_of_creation":"Booking.com","reservation_created_date":"2019-12-11 06:23:09","canceled_nights_data":"","product_name":"16 Hotel Room","ota_service_fee_amount":"0","commision_charges":"11.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.03","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":"3046947","reservation_id":"87557","confirmation_number":"CC12869343871","room_stay_from":"2019-12-14","room_stay_to":"2019-12-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.20","nightly_discount":"0","subtotal":"64.20","grand_total":"72.54","paid_amount":"72.54","room_type_id":"356","product_id":"1752","siteminder_id":"BDC-3466678563","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":"94070","customer_id":"94070","source_of_creation":"Booking.com","reservation_created_date":"2019-11-27 13:48:10","canceled_nights_data":"","product_name":"26 One Bedroom","ota_service_fee_amount":"0","commision_charges":"9.63","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.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"}]},{"room_stay_id":"3046969","reservation_id":"87370","confirmation_number":"CC12846624204","room_stay_from":"2019-12-14","room_stay_to":"2019-12-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.70","nightly_discount":"0","subtotal":"86.70","grand_total":"97.97","paid_amount":"97.97","room_type_id":"351","product_id":"1747","siteminder_id":"BDC-3151422434","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":"93920","customer_id":"93920","source_of_creation":"Booking.com","reservation_created_date":"2019-11-21 03:58:09","canceled_nights_data":"","product_name":"20 Studio","ota_service_fee_amount":"0","commision_charges":"13.01","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.70","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":"3046970","reservation_id":"87726","confirmation_number":"CC12839214240","room_stay_from":"2019-12-14","room_stay_to":"2019-12-15","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"64.20","nightly_discount":"0","subtotal":"64.20","grand_total":"72.54","paid_amount":"72.54","room_type_id":"354","product_id":"1750","siteminder_id":"BDC-2958540196","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":"94175","customer_id":"94175","source_of_creation":"Booking.com","reservation_created_date":"2019-12-01 17:03:09","canceled_nights_data":"","product_name":"24 Studio","ota_service_fee_amount":"0","commision_charges":"9.63","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"64.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3043404","reservation_id":"87734","confirmation_number":"CC12822861281","room_stay_from":"2019-12-13","room_stay_to":"2019-12-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.00,82.00","nightly_discount":"0,0","subtotal":"164.00","grand_total":"185.32","paid_amount":"185.32","room_type_id":"343","product_id":"1739","siteminder_id":"EXP-1387136843","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":"94181","customer_id":"94181","source_of_creation":"Expedia","reservation_created_date":"2019-12-01 19:47:05","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":"82.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":"3045732","reservation_id":"87342","confirmation_number":"CC12838430794","room_stay_from":"2019-12-12","room_stay_to":"2019-12-17","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"80.00,90.00,90.00,80.00,80.00","nightly_discount":"0,0,0,0,0","subtotal":"420.00","grand_total":"474.60","paid_amount":"474.60","room_type_id":"348","product_id":"1744","siteminder_id":"EXP-1383222035","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":"93893","customer_id":"93893","source_of_creation":"Expedia","reservation_created_date":"2019-11-20 03:18:09","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":"90.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":"3045775","reservation_id":"84462","confirmation_number":"CC12833882971","room_stay_from":"2019-12-14","room_stay_to":"2019-12-15","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"116.44","nightly_discount":"0","subtotal":"116.44","grand_total":"131.58","paid_amount":"131.58","room_type_id":"345","product_id":"1741","siteminder_id":"EXP-1346721433","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":"91875","customer_id":"91875","source_of_creation":"Expedia","reservation_created_date":"2019-09-21 04:52:11","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":"116.44","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":"3005073","reservation_id":"68328","confirmation_number":"CC12847933612","room_stay_from":"2019-12-14","room_stay_to":"2019-12-15","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.00","nightly_discount":"0","subtotal":"81.00","grand_total":"91.53","paid_amount":"9.19","room_type_id":"355","product_id":"1751","siteminder_id":"EXP-1190415249","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":"81291","customer_id":"81291","source_of_creation":"Expedia","reservation_created_date":"2019-02-01 19:49:09","service_canceled_date_time":"2019-09-21 20:57:16","canceled_nights_data":"","product_name":"25 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"9.19","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":"3041878","reservation_id":"87555","confirmation_number":"CC12850753457","room_stay_from":"2019-12-12","room_stay_to":"2019-12-15","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"125.13,125.13,125.13","nightly_discount":"0,0,0","subtotal":"375.39","grand_total":"489.79","paid_amount":"489.79","room_type_id":"359","product_id":"1755","siteminder_id":"ABB-HMACX3B8ZF","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"375.39","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94068","customer_id":"94068","source_of_creation":"Airbnb","reservation_created_date":"2019-11-27 05:49:06","canceled_nights_data":"","product_name":"27+28 Two Bedroom","ota_service_fee_amount":"52.48","commision_charges":"11.61","resv_is_no_show":"0","is_bundle":"1","migrated_id":"","currentDayPrice":"125.13","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":"3043498","reservation_id":"87749","confirmation_number":"CC12883675996","room_stay_from":"2019-12-12","room_stay_to":"2019-12-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.00,130.00,130.00,80.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"420.00","grand_total":"474.60","paid_amount":"474.60","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":"94195","customer_id":"94195","source_of_creation":"FE","reservation_created_date":"2019-12-02 02:08:06","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":"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":"3045373","reservation_id":"88022","confirmation_number":"CC12824329548","room_stay_from":"2019-12-14","room_stay_to":"2019-12-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00","nightly_discount":"0.00","subtotal":"126.00","grand_total":"142.38","paid_amount":"142.38","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":"94387","customer_id":"94387","source_of_creation":"FE","reservation_created_date":"2019-12-08 00:42:50","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":"126.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":"3045773","reservation_id":"87863","confirmation_number":"CC12841508564","room_stay_from":"2019-12-12","room_stay_to":"2019-12-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.00,83.00,83.00,73.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"312.00","grand_total":"352.56","paid_amount":"352.56","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":"94299","customer_id":"94299","source_of_creation":"FE","reservation_created_date":"2019-12-05 03:26:22","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":"83.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":"3046664","reservation_id":"87888","confirmation_number":"CC12857713687","room_stay_from":"2019-12-12","room_stay_to":"2019-12-16","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"73.00,83.00,83.00,83.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"322.00","grand_total":"363.86","paid_amount":"363.86","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":"94318","customer_id":"94318","source_of_creation":"FE","reservation_created_date":"2019-12-05 19:15:25","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":"83.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":"3046946","reservation_id":"88291","confirmation_number":"CC12834402900","room_stay_from":"2019-12-14","room_stay_to":"2019-12-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00","nightly_discount":"0.00","subtotal":"126.00","grand_total":"142.38","paid_amount":"142.38","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":"94571","customer_id":"94571","source_of_creation":"FE","reservation_created_date":"2019-12-14 14:20:02","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":"126.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":"3040773","reservation_id":"83358","confirmation_number":"CC12859363953","room_stay_from":"2019-09-03","room_stay_to":"2019-12-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,0.00,0.00,0.00,0.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,50.00,0.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,55.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.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","subtotal":"5945.00","grand_total":"6717.85","paid_amount":"6717.85","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":"90722","customer_id":"90722","source_of_creation":"PMS","reservation_created_date":"2019-08-28 20:31:07","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":"65.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":"3045764","reservation_id":"87929","confirmation_number":"CC12872880486","room_stay_from":"2019-12-14","room_stay_to":"2019-12-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00","nightly_discount":"0.00","subtotal":"110.00","grand_total":"124.30","paid_amount":"124.30","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":"93725","customer_id":"93725","source_of_creation":"PMS","reservation_created_date":"2019-12-06 16:19:20","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":"","currentDayPrice":"110.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":"3051653","reservation_id":"79401","confirmation_number":"CC12867570365","room_stay_from":"2019-12-02","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,123.00,143.00,143.00,143.00,143.00,143.00,143.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":"4425.00","grand_total":"5000.25","paid_amount":"5000.25","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":"88011","customer_id":"88011","source_of_creation":"PMS","reservation_created_date":"2019-09-07 18:49:39","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":"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":[{"room_stay_id":"3045785","reservation_id":"88100","confirmation_number":"CC12886941409","room_stay_from":"2019-12-14","room_stay_to":"2019-12-15","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"79.00","nightly_discount":"0.00","subtotal":"79.00","grand_total":"89.27","paid_amount":"89.27","room_type_id":"346","product_id":"1742","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":"89016","customer_id":"89016","source_of_creation":"PMS","reservation_created_date":"2019-12-09 23:47:23","service_canceled_date_time":"2019-12-10 00:02:19","canceled_nights_data":"","product_name":"16 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"89.27","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"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":[]}}