{"hotel_id":"128","sub_hotel_id":0,"room_type":"hotel","date":"2019-02-15","total_rooms_exist":18,"departureCount":4,"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":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2911120","reservation_id":"65542","confirmation_number":"CC12848748270","room_stay_from":"2019-02-13","room_stay_to":"2019-02-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.72,70.72,77.80","nightly_discount":"0,0,0","subtotal":"219.24","grand_total":"247.74","paid_amount":"247.74","room_type_id":"357","product_id":"1753","siteminder_id":"EXP-1173681893","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":"79474","customer_id":"79474","source_of_creation":"Expedia","reservation_created_date":"2019-01-04 22:35:07","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":"77.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":"2926077","reservation_id":"67663","confirmation_number":"CC12850282477","room_stay_from":"2019-02-15","room_stay_to":"2019-02-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.75,189.75","nightly_discount":"0,0","subtotal":"379.50","grand_total":"428.84","paid_amount":"428.84","room_type_id":"337","product_id":"1732","siteminder_id":"EXP-1185174018","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":"80826","customer_id":"80826","source_of_creation":"Expedia","reservation_created_date":"2019-01-23 23:30:13","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":"189.75","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":"2926681","reservation_id":"64294","confirmation_number":"CC12850543457","room_stay_from":"2019-02-13","room_stay_to":"2019-02-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.25,86.25,94.87","nightly_discount":"0,0,0","subtotal":"267.37","grand_total":"302.13","paid_amount":"302.13","room_type_id":"343","product_id":"1739","siteminder_id":"EXP-1168771704","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"78964","customer_id":"78964","source_of_creation":"Expedia","reservation_created_date":"2018-12-26 15:21:09","canceled_nights_data":"","product_name":"14 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.87","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":"2934947","reservation_id":"64194","confirmation_number":"CC12877898613","room_stay_from":"2019-02-13","room_stay_to":"2019-02-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.09,106.09,113.16","nightly_discount":"0,0,0","subtotal":"325.34","grand_total":"367.63","paid_amount":"367.63","room_type_id":"349","product_id":"1745","siteminder_id":"EXP-1168275570","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":"78922","customer_id":"78922","source_of_creation":"Expedia","reservation_created_date":"2018-12-25 06:05:07","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":"113.16","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"113","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"126","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2935314","reservation_id":"65417","confirmation_number":"CC12842920565","room_stay_from":"2019-02-15","room_stay_to":"2019-02-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.00","nightly_discount":"0","subtotal":"138.00","grand_total":"155.94","paid_amount":"155.94","room_type_id":"346","product_id":"1742","siteminder_id":"EXP-1173145820","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":"79412","customer_id":"79412","source_of_creation":"Expedia","reservation_created_date":"2019-01-04 00:35:14","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":"138.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":"2935316","reservation_id":"63789","confirmation_number":"CC12891297633","room_stay_from":"2019-02-14","room_stay_to":"2019-02-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.30,103.73,103.73,94.30","nightly_discount":"0,0,0,0","subtotal":"396.06","grand_total":"447.54","paid_amount":"447.54","room_type_id":"355","product_id":"1751","siteminder_id":"EXP-1165911914","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":"78741","customer_id":"78741","source_of_creation":"Expedia","reservation_created_date":"2018-12-19 17:50:13","canceled_nights_data":"","product_name":"25 Hotel Room","ota_service_fee_amount":"0","commision_charges":"86.94","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"103.73","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":"2935490","reservation_id":"66029","confirmation_number":"CC12873024890","room_stay_from":"2019-02-15","room_stay_to":"2019-02-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.00,165.00","nightly_discount":"0.00,0.00","subtotal":"330.00","grand_total":"372.90","paid_amount":"372.90","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":"79679","customer_id":"79679","source_of_creation":"FE","reservation_created_date":"2019-01-09 01:55:11","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":"165.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":[{"room_stay_id":"2926752","reservation_id":"64825","confirmation_number":"CC12870072607","room_stay_from":"2019-02-15","room_stay_to":"2019-02-16","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.00","nightly_discount":"0.00","subtotal":"165.00","grand_total":"186.45","paid_amount":"184.80","room_type_id":"336","product_id":"1731","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"79151","customer_id":"79151","source_of_creation":"FE","reservation_created_date":"2018-12-30 18:53:33","service_canceled_date_time":"2019-02-14 15:51:38","canceled_nights_data":"","product_name":"2 Studio","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"184.80","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"2919426","reservation_id":"67086","confirmation_number":"CC12875402776","room_stay_from":"2019-02-15","room_stay_to":"2019-02-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.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","subtotal":"1764.00","grand_total":"1993.32","paid_amount":"1993.32","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":"80451","customer_id":"80451","source_of_creation":"PMS","reservation_created_date":"2019-01-17 17:24:26","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":"147.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":"2927409","reservation_id":"67907","confirmation_number":"CC12810944265","room_stay_from":"2019-02-14","room_stay_to":"2019-02-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.00,135.00,135.00","nightly_discount":"0.00,0.00,0.00","subtotal":"405.00","grand_total":"457.65","paid_amount":"457.65","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":"80991","customer_id":"80991","source_of_creation":"PMS","reservation_created_date":"2019-01-27 00:12:06","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":"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":"2935754","reservation_id":"69464","confirmation_number":"CC12898611596","room_stay_from":"2019-02-15","room_stay_to":"2019-02-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00","nightly_discount":"0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","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":"81902","customer_id":"81902","source_of_creation":"PMS","reservation_created_date":"2019-02-14 22:59:25","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":"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":"2939880","reservation_id":"65902","confirmation_number":"CC12865343877","room_stay_from":"2019-01-26","room_stay_to":"2019-02-24","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.00,97.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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2716.00","grand_total":"3069.08","paid_amount":"3069.08","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":"78243","customer_id":"78243","source_of_creation":"PMS","reservation_created_date":"2019-01-07 22:33:12","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":"97.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":"2903039","reservation_id":"62649","confirmation_number":"CC12844463864","room_stay_from":"2019-02-01","room_stay_to":"2019-03-01","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21,48.21","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","subtotal":"1349.88","grand_total":"1349.88","paid_amount":"1349.88","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":"2018-12-22 18:19:03","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":"48.21","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":[{"room_stay_id":"2894177","reservation_id":"62739","confirmation_number":"11809","room_stay_from":"2019-02-04","room_stay_to":"2019-03-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165,165","nightly_discount":"49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5,49.5","subtotal":"6435.00","grand_total":"5090.09","paid_amount":"5090.09","room_type_id":"354","product_id":"1750","siteminder_id":"","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":"78283","customer_id":"78283","source_of_creation":"PMS","reservation_created_date":"2018-03-12 00:00:00","canceled_nights_data":"","product_name":"24 Studio","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"11809","currentDayPrice":"165","currentDayDiscount":"49.5","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":"2907112","reservation_id":"62750","confirmation_number":"12496","room_stay_from":"2019-02-14","room_stay_to":"2019-02-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"103,103,103","nightly_discount":"0,0,0","subtotal":"309.00","grand_total":"349.17","paid_amount":"349.17","room_type_id":"338","product_id":"1733","siteminder_id":"BDC-1316948523","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":"78297","customer_id":"78297","source_of_creation":"Booking.com","reservation_created_date":"2018-11-25 00:00:00","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":"12496","currentDayPrice":"103","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":"2926858","reservation_id":"62731","confirmation_number":"12336","room_stay_from":"2019-01-28","room_stay_to":"2019-02-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286,125.89285714286","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"3525.00","grand_total":"3983.25","paid_amount":"3983.25","room_type_id":"351","product_id":"1747","siteminder_id":"EXP-1134728378","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":"78276","customer_id":"78276","source_of_creation":"Expedia","reservation_created_date":"2018-10-21 00:00:00","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":"12336","currentDayPrice":"125.89285714286","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":"2933937","reservation_id":"62746","confirmation_number":"11831","room_stay_from":"2019-02-12","room_stay_to":"2019-03-02","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,215.00,430.00,430.00","nightly_discount":"86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,86.00,172.00,172.00","subtotal":"4300.00","grand_total":"2915.40","paid_amount":"2915.40","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":"78291","customer_id":"78291","source_of_creation":"PMS","reservation_created_date":"2018-03-22 00:00:00","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":"11831","currentDayPrice":"215.00","currentDayDiscount":"86.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":"2935484","reservation_id":"62749","confirmation_number":"12314","room_stay_from":"2019-02-14","room_stay_to":"2019-02-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.25,128.25","nightly_discount":"0,0","subtotal":"256.50","grand_total":"289.85","paid_amount":"289.85","room_type_id":"353","product_id":"1749","siteminder_id":"BDC-1030719359","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":"78295","customer_id":"78295","source_of_creation":"Booking.com","reservation_created_date":"2018-10-13 00:00:00","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":"12314","currentDayPrice":"128.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"}]},{"room_stay_id":"3017897","reservation_id":"62738","confirmation_number":"11731","room_stay_from":"2019-02-03","room_stay_to":"2019-02-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.00,176.00,176.00,176.00,176.00,176.00,176.00,176.00,176.00,176.00,176.00,176.00,176.00,176.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":"2464.00","grand_total":"2784.32","paid_amount":"2784.32","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":"2018-02-17 00:00:00","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":"11731","currentDayPrice":"176.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"}]}],"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":[]}}