{"hotel_id":"128","sub_hotel_id":0,"room_type":"hotel","date":"2019-08-16","total_rooms_exist":18,"departureCount":8,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"4","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3010399","reservation_id":"82567","confirmation_number":"CC12865274960","room_stay_from":"2019-08-15","room_stay_to":"2019-08-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"79.20,88.20","nightly_discount":"0,0","subtotal":"167.40","grand_total":"189.16","paid_amount":"189.16","room_type_id":"348","product_id":"1744","siteminder_id":"BDC-3500606999","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":"90164","customer_id":"90164","source_of_creation":"Booking.com","reservation_created_date":"2019-08-13 09:31:08","canceled_nights_data":"","product_name":"17 Studio","ota_service_fee_amount":"0","commision_charges":"25.11","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.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":"3010400","reservation_id":"82282","confirmation_number":"CC12835552167","room_stay_from":"2019-08-15","room_stay_to":"2019-08-17","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"72.00,82.00","nightly_discount":"0,0","subtotal":"154.00","grand_total":"174.02","paid_amount":"174.02","room_type_id":"336","product_id":"1731","siteminder_id":"BDC-2678072562","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":"89988","customer_id":"89988","source_of_creation":"Booking.com","reservation_created_date":"2019-08-09 00:27:10","canceled_nights_data":"","product_name":"2 Studio","ota_service_fee_amount":"0","commision_charges":"23.10","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":"3010404","reservation_id":"81903","confirmation_number":"CC12885950974","room_stay_from":"2019-08-16","room_stay_to":"2019-08-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.70,69.70","nightly_discount":"0,0","subtotal":"139.40","grand_total":"157.52","paid_amount":"157.52","room_type_id":"355","product_id":"1751","siteminder_id":"BDC-2883255405","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":"89730","customer_id":"89730","source_of_creation":"Booking.com","reservation_created_date":"2019-08-02 21:29:09","canceled_nights_data":"","product_name":"25 Hotel Room","ota_service_fee_amount":"0","commision_charges":"20.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.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":"3011141","reservation_id":"82462","confirmation_number":"CC12865208876","room_stay_from":"2019-08-16","room_stay_to":"2019-08-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.20","nightly_discount":"0","subtotal":"70.20","grand_total":"79.32","paid_amount":"79.32","room_type_id":"337","product_id":"1732","siteminder_id":"BDC-2458881909","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":"90077","customer_id":"90077","source_of_creation":"Booking.com","reservation_created_date":"2019-08-11 02:35:09","canceled_nights_data":"","product_name":"3 One Bedroom","ota_service_fee_amount":"0","commision_charges":"10.53","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"70.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":"3009536","reservation_id":"82377","confirmation_number":"CC12824799428","room_stay_from":"2019-08-16","room_stay_to":"2019-08-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.95,73.95,65.45","nightly_discount":"0,0,0","subtotal":"213.35","grand_total":"241.08","paid_amount":"241.08","room_type_id":"357","product_id":"1753","siteminder_id":"EXP-1318829241","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":"90037","customer_id":"90037","source_of_creation":"Expedia","reservation_created_date":"2019-08-10 02:22:10","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":"73.95","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":"3010433","reservation_id":"82638","confirmation_number":"CC12891664991","room_stay_from":"2019-08-16","room_stay_to":"2019-08-19","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"89.22,89.22,82.25","nightly_discount":"0,0,0","subtotal":"260.69","grand_total":"294.58","paid_amount":"294.58","room_type_id":"350","product_id":"1746","siteminder_id":"EXP-1322025376","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":"90222","customer_id":"90222","source_of_creation":"Expedia","reservation_created_date":"2019-08-14 21:42:10","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":"89.22","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":"3010724","reservation_id":"81328","confirmation_number":"CC12873915349","room_stay_from":"2019-08-03","room_stay_to":"2019-08-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.19,89.22,89.22,89.22,89.22,89.22,96.19,96.19,89.22,89.22,89.22,89.22,89.22,96.19","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":"1276.96","grand_total":"1442.97","paid_amount":"1442.97","room_type_id":"342","product_id":"1738","siteminder_id":"EXP-1307102326","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":"89331","customer_id":"89331","source_of_creation":"Expedia","reservation_created_date":"2019-07-24 14:55:05","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":"96.19","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":[{"room_stay_id":"3007556","reservation_id":"80552","confirmation_number":"CC12882398575","room_stay_from":"2019-08-16","room_stay_to":"2019-08-18","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.12,64.12","nightly_discount":"0,0","subtotal":"128.24","grand_total":"144.91","paid_amount":"0.00","room_type_id":"346","product_id":"1742","siteminder_id":"EXP-1297824467","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":"88820","customer_id":"88820","source_of_creation":"Expedia","reservation_created_date":"2019-07-11 20:42:11","service_canceled_date_time":"2019-08-08 13:27:05","canceled_nights_data":"","product_name":"16 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"72.46","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":"3010301","reservation_id":"80285","confirmation_number":"CC12816488630","room_stay_from":"2019-08-16","room_stay_to":"2019-08-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"52.86,52.86","nightly_discount":"0,0","subtotal":"105.72","grand_total":"137.94","paid_amount":"137.94","room_type_id":"354","product_id":"1750","siteminder_id":"ABB-HMAA2HDXZA","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"105.72","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"88625","customer_id":"88625","source_of_creation":"Airbnb","reservation_created_date":"2019-07-06 14:14:07","canceled_nights_data":"","product_name":"24 Studio","ota_service_fee_amount":"14.78","commision_charges":"3.27","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"52.86","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":"3010160","reservation_id":"82391","confirmation_number":"CC12881533433","room_stay_from":"2019-08-12","room_stay_to":"2019-08-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"65.00,65.00,61.00,61.00,61.00,61.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"374.00","grand_total":"422.62","paid_amount":"422.62","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":"90049","customer_id":"90049","source_of_creation":"FE","reservation_created_date":"2019-08-10 12:23:06","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":"61.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":"3009538","reservation_id":"81826","confirmation_number":"CC12853222575","room_stay_from":"2019-08-16","room_stay_to":"2019-08-18","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"48.00,48.00","nightly_discount":"0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","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":"89669","customer_id":"89669","source_of_creation":"PMS","reservation_created_date":"2019-08-01 16:48:52","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":"48.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":"3010277","reservation_id":"82612","confirmation_number":"CC12831392592","room_stay_from":"2019-08-16","room_stay_to":"2019-08-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.00","nightly_discount":"0.00","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","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":"90201","customer_id":"90201","source_of_creation":"PMS","reservation_created_date":"2019-08-14 14:22:13","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":"70.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":"3010402","reservation_id":"81466","confirmation_number":"CC12850857288","room_stay_from":"2019-08-14","room_stay_to":"2019-08-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,95.00,70.00,70.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"235.00","grand_total":"265.55","paid_amount":"265.55","room_type_id":"343","product_id":"1739","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":"89414","customer_id":"89414","source_of_creation":"PMS","reservation_created_date":"2019-07-26 14:59:01","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":"70.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":"3011139","reservation_id":"82201","confirmation_number":"CC12811319312","room_stay_from":"2019-08-16","room_stay_to":"2019-08-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"94.00","nightly_discount":"0.00","subtotal":"94.00","grand_total":"106.22","paid_amount":"106.22","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":"89940","customer_id":"89940","source_of_creation":"PMS","reservation_created_date":"2019-08-07 20:11:38","canceled_nights_data":"","product_name":"18 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.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":"3012703","reservation_id":"81220","confirmation_number":"CC12819304627","room_stay_from":"2019-08-06","room_stay_to":"2019-08-22","room_stay_status":"Closed","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","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","subtotal":"1066.56","grand_total":"1205.21","paid_amount":"1205.21","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":"89244","customer_id":"89244","source_of_creation":"PMS","reservation_created_date":"2019-08-02 14:54:21","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":"66.66","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":"3013537","reservation_id":"81613","confirmation_number":"CC12815457982","room_stay_from":"2019-08-16","room_stay_to":"2019-08-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"86.00,80.00,91.00,80.00,91.00,91.00,81.00,91.00,91.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"782.00","grand_total":"883.66","paid_amount":"1150.00","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":"89488","customer_id":"89488","source_of_creation":"PMS","reservation_created_date":"2019-08-14 14:46:52","canceled_nights_data":"","product_name":"26 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.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":"3028001","reservation_id":"79401","confirmation_number":"CC12874980643","room_stay_from":"2019-08-02","room_stay_to":"2019-09-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.00,80.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","subtotal":"2720.00","grand_total":"3073.60","paid_amount":"3073.60","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":"88011","customer_id":"88011","source_of_creation":"PMS","reservation_created_date":"2019-08-02 01:16:18","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":"80.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":"3011455","reservation_id":"62649","confirmation_number":"CC12855920284","room_stay_from":"2019-07-31","room_stay_to":"2019-08-19","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.14,48.14,48.14,48.14,48.14,48.14,48.16,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"337.00","grand_total":"337.00","paid_amount":"337.00","room_type_id":"345","product_id":"1741","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"78009","customer_id":"78009","source_of_creation":"PMS","reservation_created_date":"2019-07-28 17:39:29","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":"0.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"}]},{"room_stay_id":"3041588","reservation_id":"75682","confirmation_number":"CC12875991159","room_stay_from":"2019-06-01","room_stay_to":"2019-11-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"566.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.86,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.86,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,0.20,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.86,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,0.20,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,466.82,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"12500.00","grand_total":"12500.00","paid_amount":"12500.00","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":"1","traveller_tax_exempt":"1","customer_traveller_id":"85530","customer_id":"85530","source_of_creation":"PMS","reservation_created_date":"2019-05-02 18:10:48","canceled_nights_data":"","product_name":"28 One Bedroom","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"66.66","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":[],"extra_person_non_taxable":[],"resort_fee_taxable":[],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[{"room_stay_id":"3010997","reservation_id":"81613","confirmation_number":"CC12841272891","room_confirmation_number":"CC12815457982","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"150.00","grand_total":"150.00","paid_amount":"0.00","product_id":"1769","service_quantity":"1","product_name":"Refundable Security Deposit for less than 7 day stay.","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-16 16:06:50","reservation_modified_date_time":"2019-08-16 16:06:50","customer_id":"89488","parentCustTravId":"89488","customer_traveller_id":"89488","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"150.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"3007501","reservation_id":"81613","confirmation_number":"CC12866387195","room_confirmation_number":"CC12899398755","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"150.00","grand_total":"150.00","paid_amount":"0.00","product_id":"1769","service_quantity":"1","product_name":"Refundable Security Deposit for less than 7 day stay.","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-05 20:14:08","reservation_modified_date_time":"2019-08-05 20:14:08","customer_id":"89488","parentCustTravId":"89488","customer_traveller_id":"89488","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-08-16 17:14:09","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-150,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}