{"hotel_id":"128","sub_hotel_id":0,"room_type":"hotel","date":"2019-02-16","total_rooms_exist":18,"departureCount":6,"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":"2898482","reservation_id":"63692","confirmation_number":"CC12887783291","room_stay_from":"2019-02-16","room_stay_to":"2019-02-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00,100.00,100.00,100.00,100.00,100.00,110.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"720.00","grand_total":"813.60","paid_amount":"813.60","room_type_id":"357","product_id":"1753","siteminder_id":"BDC-1237504702","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":"78678","customer_id":"78678","source_of_creation":"Booking.com","reservation_created_date":"2018-12-18 01:39:09","canceled_nights_data":"","product_name":"27 Hotel Room","ota_service_fee_amount":"0","commision_charges":"108.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"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":"2927406","reservation_id":"65172","confirmation_number":"CC12820261382","room_stay_from":"2019-02-16","room_stay_to":"2019-02-19","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"141.45,122.59,122.59","nightly_discount":"0,0,0","subtotal":"386.63","grand_total":"436.89","paid_amount":"436.89","room_type_id":"336","product_id":"1731","siteminder_id":"EXP-1171998637","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":"79301","customer_id":"79301","source_of_creation":"Expedia","reservation_created_date":"2019-01-02 04:20:11","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":"141.45","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":"2934945","reservation_id":"67774","confirmation_number":"CC12817166864","room_stay_from":"2019-02-16","room_stay_to":"2019-02-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.25","nightly_discount":"0","subtotal":"165.25","grand_total":"186.74","paid_amount":"186.74","room_type_id":"349","product_id":"1745","siteminder_id":"EXP-1185981348","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":"80894","customer_id":"80894","source_of_creation":"Expedia","reservation_created_date":"2019-01-25 07:30:12","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":"165.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":"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":[{"room_stay_id":"2894191","reservation_id":"62751","confirmation_number":"12494","room_stay_from":"2019-02-16","room_stay_to":"2019-02-18","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"127.5,127.5","nightly_discount":"0,0","subtotal":"255.00","grand_total":"288.15","paid_amount":"50.00","room_type_id":"355","product_id":"1751","siteminder_id":"EXP-1153550557","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":"78299","customer_id":"78299","source_of_creation":"Expedia","reservation_created_date":"2018-11-25 00:00:00","service_canceled_date_time":"2018-12-19 13:46:53","canceled_nights_data":"","product_name":"25 Hotel Room","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"50.00","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":[],"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":[],"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":"2935486","reservation_id":"68601","confirmation_number":"CC12896858943","room_stay_from":"2019-02-16","room_stay_to":"2019-02-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00","nightly_discount":"0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","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":"78028","customer_id":"78028","source_of_creation":"PMS","reservation_created_date":"2019-02-04 16:20:24","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":"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":"2894300","reservation_id":"62777","confirmation_number":"CC12867448369","room_stay_from":"2019-02-16","room_stay_to":"2019-02-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.12,111.38","nightly_discount":"0.00,0.00","subtotal":"229.50","grand_total":"259.34","paid_amount":"259.34","room_type_id":"343","product_id":"1739","siteminder_id":"BDC-1237803101","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":"78298","customer_id":"78298","source_of_creation":"Booking.com","reservation_created_date":"2018-12-06 07:00:18","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":"1","currentDayPrice":"118.12","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":"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":"2935313","reservation_id":"62777","confirmation_number":"CC12830385857","room_stay_from":"2019-02-16","room_stay_to":"2019-02-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.12,111.38","nightly_discount":"0.00,0.00","subtotal":"229.50","grand_total":"259.34","paid_amount":"259.34","room_type_id":"346","product_id":"1742","siteminder_id":"BDC-1237803101","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":"78298","customer_id":"78298","source_of_creation":"Booking.com","reservation_created_date":"2018-12-06 07:00:18","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":"1","currentDayPrice":"118.12","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":"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":[{"room_stay_id":"2936583","reservation_id":"62752","confirmation_number":"CC12889282806","room_confirmation_number":"12511","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"15.00","grand_total":"118.65","paid_amount":"118.65","product_id":"1770","service_quantity":"7","product_name":"Extra Person Charge","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-16 21:32:58","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"78300","parentCustTravId":"78300","customer_traveller_id":"78300","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":"105.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"112","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}