{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-01-03","total_rooms_exist":66,"departureCount":23,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"2","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2904902","reservation_id":"64269","confirmation_number":"PB12329165658","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"111.38","nightly_discount":"0","subtotal":"111.38","grand_total":"125.86","paid_amount":"125.86","room_type_id":"289","product_id":"1099","siteminder_id":"BDC-1819378076","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":"78947","customer_id":"78947","source_of_creation":"Booking.com","reservation_created_date":"2018-12-26 00:22:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"16.71","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.38","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2905268","reservation_id":"60962","confirmation_number":"BV12419724510","room_stay_from":"2018-12-26","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.00,108.00,188.00,188.00,108.00,108.00,108.00,118.00,118.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,61.82,0.00","subtotal":"1152.00","grand_total":"1231.90","paid_amount":"1231.90","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-2091880938","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":"77310","customer_id":"77310","source_of_creation":"Booking.com","reservation_created_date":"2018-11-23 01:32:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"172.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"118.00","currentDayDiscount":"61.82","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2906395","reservation_id":"61005","confirmation_number":"PB12342570084","room_stay_from":"2018-12-30","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"136.00,136.00,136.00,160.00,160.00","nightly_discount":"0,0,0,0,0","subtotal":"728.00","grand_total":"822.64","paid_amount":"822.64","room_type_id":"291","product_id":"1118","siteminder_id":"BDC-1459509815","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":"77323","customer_id":"77323","source_of_creation":"Booking.com","reservation_created_date":"2018-11-23 20:45:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"109.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2908769","reservation_id":"64669","confirmation_number":"BV12494305673","room_stay_from":"2019-01-03","room_stay_to":"2019-01-07","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"97.81,112.32,112.32,101.56","nightly_discount":"0,0,0,0","subtotal":"424.01","grand_total":"479.13","paid_amount":"479.13","room_type_id":"304","product_id":"1220","siteminder_id":"BDC-1293666967","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":"79095","customer_id":"79095","source_of_creation":"Booking.com","reservation_created_date":"2018-12-29 13:41:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"63.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.81","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909046","reservation_id":"65095","confirmation_number":"PB12350573763","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"95.47,95.47,111.89,111.89","nightly_discount":"0,0,0,0","subtotal":"414.72","grand_total":"468.63","paid_amount":"468.63","room_type_id":"289","product_id":"1102","siteminder_id":"BDC-1002386324","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":"79255","customer_id":"79255","source_of_creation":"Booking.com","reservation_created_date":"2019-01-01 19:20:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"62.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.47","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909349","reservation_id":"65033","confirmation_number":"BV12493382396","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.81,112.32,112.32","nightly_discount":"0.00,0.00,0.00","subtotal":"322.45","grand_total":"341.80","paid_amount":"364.37","room_type_id":"304","product_id":"1221","siteminder_id":"BDC-1026627407","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":"79224","customer_id":"79224","source_of_creation":"Booking.com","reservation_created_date":"2019-01-01 05:36:15","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"42.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.81","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909398","reservation_id":"64944","confirmation_number":"PB12348109274","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"111.89,111.89,128.30","nightly_discount":"0.00,0.00,20.93","subtotal":"352.08","grand_total":"374.20","paid_amount":"374.20","room_type_id":"291","product_id":"1115","siteminder_id":"BDC-1229078166","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":"79199","customer_id":"79199","source_of_creation":"Booking.com","reservation_created_date":"2018-12-31 17:55:14","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"39.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.89","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910123","reservation_id":"65337","confirmation_number":"PB12378552559","room_stay_from":"2019-01-03","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.89,128.30,128.30,116.21,116.21,116.21","nightly_discount":"0,0,0,0,0,0","subtotal":"717.12","grand_total":"810.35","paid_amount":"810.35","room_type_id":"291","product_id":"1114","siteminder_id":"BDC-1134712172","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":"79374","customer_id":"79374","source_of_creation":"Booking.com","reservation_created_date":"2019-01-03 14:49:14","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"107.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.89","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911386","reservation_id":"64315","confirmation_number":"PB12377250827","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"95.47,95.47,111.89,111.89","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"414.72","grand_total":"468.63","paid_amount":"468.63","room_type_id":"289","product_id":"1100","siteminder_id":"BDC-1412738243","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":"78970","customer_id":"78970","source_of_creation":"Booking.com","reservation_created_date":"2018-12-26 18:33:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"62.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.47","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911395","reservation_id":"64151","confirmation_number":"PB12330819377","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"111.38,130.54,130.54","nightly_discount":"0.00,0.00,0.00","subtotal":"372.46","grand_total":"420.88","paid_amount":"420.88","room_type_id":"289","product_id":"1098","siteminder_id":"BDC-1819309475","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":"78908","customer_id":"78908","source_of_creation":"Booking.com","reservation_created_date":"2018-12-24 19:21:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"55.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2895584","reservation_id":"63052","confirmation_number":"PB12345826500","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"126.85,126.85","nightly_discount":"0,0","subtotal":"253.70","grand_total":"286.68","paid_amount":"286.68","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1160651763","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":"78461","customer_id":"78461","source_of_creation":"Expedia","reservation_created_date":"2018-12-08 22:10:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.85","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2898625","reservation_id":"63730","confirmation_number":"PB12398360859","room_stay_from":"2018-12-29","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"251.80,200.60,200.60,200.60,150.68,150.68,170.14","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1325.10","grand_total":"1497.36","paid_amount":"1497.36","room_type_id":"288","product_id":"1092","siteminder_id":"EXP-1165453720","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":"78707","customer_id":"78707","source_of_creation":"Expedia","reservation_created_date":"2018-12-18 20:10:13","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"150.68","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907592","reservation_id":"64252","confirmation_number":"BP12571058895","room_stay_from":"2018-12-29","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"139.33,101.55,101.55,101.55,69.72,69.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,6.00,0.00","subtotal":"583.42","grand_total":"652.48","paid_amount":"652.48","room_type_id":"294","product_id":"1127","siteminder_id":"EXP-1168478120","collect_which":"channel_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":"78938","customer_id":"78938","source_of_creation":"Expedia","reservation_created_date":"2018-12-25 21:35:09","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.72","currentDayDiscount":"6.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907752","reservation_id":"64007","confirmation_number":"BV12492125215","room_stay_from":"2018-12-31","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"113.88,113.88,87.74,87.74","nightly_discount":"0,0,0,0","subtotal":"403.24","grand_total":"455.66","paid_amount":"455.66","room_type_id":"304","product_id":"1219","siteminder_id":"EXP-1167359815","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":"78853","customer_id":"78853","source_of_creation":"Expedia","reservation_created_date":"2018-12-22 18:25:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"87.74","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2908317","reservation_id":"64941","confirmation_number":"BP12554149004","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.09,88.86","nightly_discount":"0,0","subtotal":"159.95","grand_total":"180.75","paid_amount":"180.75","room_type_id":"299","product_id":"1134","siteminder_id":"EXP-1171357460","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":"79198","customer_id":"79198","source_of_creation":"Expedia","reservation_created_date":"2018-12-31 17:30:08","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.09","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2908702","reservation_id":"64887","confirmation_number":"PB12372641357","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.54,130.54","nightly_discount":"0,0","subtotal":"261.08","grand_total":"295.02","paid_amount":"295.02","room_type_id":"291","product_id":"1116","siteminder_id":"EXP-1171051751","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":"79171","customer_id":"79171","source_of_creation":"Expedia","reservation_created_date":"2018-12-30 23:45:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.54","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909008","reservation_id":"65092","confirmation_number":"PB12375531034","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.34,91.34","nightly_discount":"0,0","subtotal":"182.68","grand_total":"206.43","paid_amount":"206.43","room_type_id":"289","product_id":"1101","siteminder_id":"EXP-1171778349","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":"79253","customer_id":"79253","source_of_creation":"Expedia","reservation_created_date":"2019-01-01 19:05:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.34","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910148","reservation_id":"65343","confirmation_number":"PB12317358358","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.08","nightly_discount":"0","subtotal":"86.08","grand_total":"97.27","paid_amount":"97.27","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1172870240","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":"79377","customer_id":"79377","source_of_creation":"Expedia","reservation_created_date":"2019-01-03 16:00:22","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.08","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910182","reservation_id":"65350","confirmation_number":"PB12378650081","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"91.74","nightly_discount":"0","subtotal":"91.74","grand_total":"103.66","paid_amount":"103.66","room_type_id":"291","product_id":"1117","siteminder_id":"EXP-1172957227","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":"79384","customer_id":"79384","source_of_creation":"Expedia","reservation_created_date":"2019-01-03 18:35:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.74","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910262","reservation_id":"65374","confirmation_number":"BP12563230221","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.98,105.21","nightly_discount":"0,0","subtotal":"195.19","grand_total":"220.56","paid_amount":"220.56","room_type_id":"301","product_id":"1137","siteminder_id":"EXP-1173026672","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":"79395","customer_id":"79395","source_of_creation":"Expedia","reservation_created_date":"2019-01-03 20:40:12","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.98","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911332","reservation_id":"62799","confirmation_number":"BP12545263947","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"7","room_stay_child_count":"0","nightly_price":"214.83,214.83,239.16","nightly_discount":"0,0,0","subtotal":"668.82","grand_total":"755.77","paid_amount":"755.77","room_type_id":"302","product_id":"1138","siteminder_id":"EXP-1159606904","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":"78399","customer_id":"78399","source_of_creation":"Expedia","reservation_created_date":"2018-12-06 17:00:08","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"214.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911482","reservation_id":"62792","confirmation_number":"PB12342995915","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.19,104.38,104.38,122.33,122.33","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"569.61","grand_total":"643.66","paid_amount":"643.66","room_type_id":"289","product_id":"1097","siteminder_id":"EXP-1159510132","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":"78395","customer_id":"78395","source_of_creation":"Expedia","reservation_created_date":"2018-12-06 13:15:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2914492","reservation_id":"65184","confirmation_number":"PB12328285918","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.29,78.29,78.29","nightly_discount":"0.00,0.00,0.00","subtotal":"234.87","grand_total":"265.40","paid_amount":"265.40","room_type_id":"289","product_id":"1121","siteminder_id":"EXP-1172170327","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":"79309","customer_id":"79309","source_of_creation":"Expedia","reservation_created_date":"2019-01-02 14:00:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"2908230","reservation_id":"64924","confirmation_number":"BP12539363872","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.39,48.39,48.39","nightly_discount":"0,0,0","subtotal":"145.17","grand_total":"164.04","paid_amount":"164.04","room_type_id":"293","product_id":"1124","siteminder_id":"HTN-72270142","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":"79466","customer_id":"79466","source_of_creation":"HotelTonight","reservation_created_date":"2018-12-31 13:28:12","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.39","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909465","reservation_id":"65187","confirmation_number":"BV12423957971","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.76,53.76","nightly_discount":"0,0","subtotal":"107.51","grand_total":"121.49","paid_amount":"121.49","room_type_id":"307","product_id":"1224","siteminder_id":"HTN-72453136-E4KT9D","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":"79312","customer_id":"79312","source_of_creation":"HotelTonight","reservation_created_date":"2019-01-02 14:16:11","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"53.76","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911350","reservation_id":"64330","confirmation_number":"PB12337416747","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.86,62.86,62.86","nightly_discount":"0,0,0","subtotal":"188.58","grand_total":"213.09","paid_amount":"213.09","room_type_id":"285","product_id":"1084","siteminder_id":"HTN-71720995","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":"78976","customer_id":"78976","source_of_creation":"HotelTonight","reservation_created_date":"2018-12-26 20:55:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.86","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[{"room_stay_id":"2893241","reservation_id":"62180","confirmation_number":"BV12473343889","room_stay_from":"2018-12-28","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.80,118.80,86.80,86.80,86.80,83.60,83.60","nightly_discount":"0,0,0,0,0,0,0","subtotal":"665.20","grand_total":"751.68","paid_amount":"751.68","room_type_id":"305","product_id":"1222","siteminder_id":"PCL-32840683","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":"77987","customer_id":"77987","source_of_creation":"Priceline.com","reservation_created_date":"2018-12-05 00:53:08","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"83.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2904581","reservation_id":"64219","confirmation_number":"BP12528018606","room_stay_from":"2018-12-31","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.00,86.00,59.04,59.04","nightly_discount":"0,0,0,0","subtotal":"290.08","grand_total":"327.79","paid_amount":"327.80","room_type_id":"294","product_id":"1125","siteminder_id":"PCL-33012143","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":"72665","customer_id":"72665","source_of_creation":"Priceline.com","reservation_created_date":"2018-12-25 18:02:09","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"59.04","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2910192","reservation_id":"65352","confirmation_number":"BV12444297515","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"72.23","nightly_discount":"0","subtotal":"72.23","grand_total":"81.62","paid_amount":"81.62","room_type_id":"301","product_id":"1136","siteminder_id":"PCL-33079633","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":"79387","customer_id":"79387","source_of_creation":"Priceline.com","reservation_created_date":"2019-01-03 18:47:10","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"72.23","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2948410","reservation_id":"63672","confirmation_number":"BP12553313851","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"56.67,56.67,71.81","nightly_discount":"0.00,0.00,0.00","subtotal":"185.15","grand_total":"209.22","paid_amount":"209.22","room_type_id":"298","product_id":"1133","siteminder_id":"PCL-32962763","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":"78663","customer_id":"78663","source_of_creation":"Priceline.com","reservation_created_date":"2018-12-17 20:22:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"56.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"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":"2905786","reservation_id":"64401","confirmation_number":"BV12422423321","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.60,137.60","nightly_discount":"0.00,0.00","subtotal":"275.20","grand_total":"310.97","paid_amount":"310.97","room_type_id":"306","product_id":"1223","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":"79005","customer_id":"79005","source_of_creation":"FE","reservation_created_date":"2018-12-27 17:23:39","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2906319","reservation_id":"64383","confirmation_number":"BV12480014270","room_stay_from":"2018-12-30","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"151.00,151.00,151.00,114.40,114.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"681.80","grand_total":"770.43","paid_amount":"770.43","room_type_id":"308","product_id":"1225","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":"78993","customer_id":"78993","source_of_creation":"FE","reservation_created_date":"2018-12-27 04:24:14","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2908885","reservation_id":"65060","confirmation_number":"BP12541804584","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.80,168.80","nightly_discount":"0.00,0.00","subtotal":"337.60","grand_total":"381.49","paid_amount":"381.49","room_type_id":"297","product_id":"1132","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":"79242","customer_id":"79242","source_of_creation":"FE","reservation_created_date":"2019-01-01 16:45:46","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"168.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909290","reservation_id":"65151","confirmation_number":"BV12441919729","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.80,116.80","nightly_discount":"0.00,0.00","subtotal":"233.60","grand_total":"263.97","paid_amount":"263.97","room_type_id":"309","product_id":"1226","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":"79284","customer_id":"79284","source_of_creation":"FE","reservation_created_date":"2019-01-02 00:05:28","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"116.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"96300","reservation_id":"30899","confirmation_number":"PB960032132","room_stay_from":"2018-12-26","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184,184,184,184,184,184,184,184,184,184","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"1840.00","grand_total":"2079.20","paid_amount":"2079.20","room_type_id":"287","product_id":"1089","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":"64186","customer_id":"64186","source_of_creation":"PMS","reservation_created_date":"2018-03-31 22:14:48","canceled_nights_data":"","product_name":"216 PB Gulf Front Efficiency Suite","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"184","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2876331","reservation_id":"58096","confirmation_number":"PB12315576038","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1222.00","grand_total":"1380.86","paid_amount":"1380.86","room_type_id":"289","product_id":"1110","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":"75908","customer_id":"75908","source_of_creation":"PMS","reservation_created_date":"2018-10-12 16:00:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2876334","reservation_id":"58098","confirmation_number":"PB12360697642","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1222.00","grand_total":"1380.86","paid_amount":"1380.86","room_type_id":"289","product_id":"1111","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":"75908","customer_id":"75908","source_of_creation":"PMS","reservation_created_date":"2018-10-12 16:04:38","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2876337","reservation_id":"58099","confirmation_number":"PB12313882951","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1222.00","grand_total":"1380.86","paid_amount":"1380.86","room_type_id":"289","product_id":"1112","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":"75909","customer_id":"75909","source_of_creation":"PMS","reservation_created_date":"2018-10-12 16:07:57","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2886568","reservation_id":"60511","confirmation_number":"PB12348051882","room_stay_from":"2018-12-17","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.00,92.00,92.00,92.00,142.00,184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00,134.00,134.00,134.00,134.00,134.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","subtotal":"2402.00","grand_total":"2714.26","paid_amount":"2714.26","room_type_id":"289","product_id":"1105","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":"77126","customer_id":"77126","source_of_creation":"PMS","reservation_created_date":"2018-11-16 21:53:32","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2905141","reservation_id":"30738","confirmation_number":"PB938814659","room_stay_from":"2018-12-26","room_stay_to":"2019-01-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,134.00,134.00,134.00,134.00,134.00,134.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,46.90,0.00,0.00,0.00,0.00,0.00,0.00,38.50,0.00,0.00,0.00,0.00,0.00,0.00,0.00,44.00","subtotal":"2588.00","grand_total":"2778.22","paid_amount":"2778.22","room_type_id":"289","product_id":"1109","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":"69127","customer_id":"69127","source_of_creation":"PMS","reservation_created_date":"2018-02-28 21:58:13","canceled_nights_data":"","product_name":"207 PB Deluxe Efficiency Suite","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":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2906892","reservation_id":"58039","confirmation_number":"PB12344673941","room_stay_from":"2018-12-28","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"184.00,184.00,134.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,46.90,0.00","subtotal":"1038.00","grand_total":"1119.94","paid_amount":"1119.94","room_type_id":"289","product_id":"1107","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":"67061","customer_id":"67061","source_of_creation":"PMS","reservation_created_date":"2018-10-11 17:48:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"46.90","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907400","reservation_id":"52220","confirmation_number":"PB12396248214","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,199.00,199.00","nightly_discount":"0.00,0.00,0.00","subtotal":"597.00","grand_total":"674.61","paid_amount":"674.61","room_type_id":"287","product_id":"1087","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":"43106","customer_id":"43106","source_of_creation":"PMS","reservation_created_date":"2018-07-27 01:00:43","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"199.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2907921","reservation_id":"64844","confirmation_number":"PB12361017668","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"287","product_id":"1088","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":"26469","customer_id":"26469","source_of_creation":"PMS","reservation_created_date":"2018-12-30 20:20:48","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","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":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2908510","reservation_id":"64972","confirmation_number":"BP12514441935","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.00,80.80,80.80","nightly_discount":"0.00,0.00,0.00","subtotal":"272.60","grand_total":"308.04","paid_amount":"308.04","room_type_id":"295","product_id":"1128","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":"42153","customer_id":"42153","source_of_creation":"PMS","reservation_created_date":"2018-12-31 20:59:07","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"80.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909089","reservation_id":"65106","confirmation_number":"PB12322766274","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","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":"292","product_id":"1120","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":"79264","customer_id":"79264","source_of_creation":"PMS","reservation_created_date":"2019-01-01 20:08:02","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","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":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909287","reservation_id":"64526","confirmation_number":"BV12444980014","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.00,78.40,78.40","nightly_discount":"0.00,0.00,9.62","subtotal":"262.80","grand_total":"286.09","paid_amount":"290.78","room_type_id":"294","product_id":"1126","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":"79035","customer_id":"79035","source_of_creation":"PMS","reservation_created_date":"2018-12-28 04:03:07","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.40","currentDayDiscount":"9.62","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909400","reservation_id":"64656","confirmation_number":"PB12395126017","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"145.00,96.00,96.00","nightly_discount":"0.00,0.00,19.02","subtotal":"337.00","grand_total":"359.32","paid_amount":"364.00","room_type_id":"289","product_id":"1123","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":"53870","customer_id":"53870","source_of_creation":"PMS","reservation_created_date":"2018-12-29 03:46:50","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.00","currentDayDiscount":"19.02","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909445","reservation_id":"65182","confirmation_number":"PB12357253016","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.40","nightly_discount":"0.00","subtotal":"94.40","grand_total":"106.67","paid_amount":"106.67","room_type_id":"285","product_id":"1085","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":"79016","customer_id":"79016","source_of_creation":"PMS","reservation_created_date":"2019-01-02 13:42:36","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909496","reservation_id":"65193","confirmation_number":"PB12329487268","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"105.60","nightly_discount":"0.00","subtotal":"105.60","grand_total":"119.33","paid_amount":"119.33","room_type_id":"289","product_id":"1108","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":"76008","customer_id":"76008","source_of_creation":"PMS","reservation_created_date":"2019-01-02 15:50:39","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909848","reservation_id":"65271","confirmation_number":"PB12389886608","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.60","nightly_discount":"0.00","subtotal":"105.60","grand_total":"119.33","paid_amount":"119.33","room_type_id":"289","product_id":"1106","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":"78954","customer_id":"78954","source_of_creation":"PMS","reservation_created_date":"2019-01-02 22:12:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910178","reservation_id":"65348","confirmation_number":"PB12397201926","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.80,131.20","nightly_discount":"0.00,0.00","subtotal":"256.00","grand_total":"289.28","paid_amount":"289.28","room_type_id":"291","product_id":"1119","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":"60164","customer_id":"60164","source_of_creation":"PMS","reservation_created_date":"2019-01-03 18:17:55","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911335","reservation_id":"64747","confirmation_number":"PB12351646694","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"161.60,168.00","nightly_discount":"0.00,0.00","subtotal":"329.60","grand_total":"372.45","paid_amount":"372.45","room_type_id":"287","product_id":"1090","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":"79124","customer_id":"79124","source_of_creation":"PMS","reservation_created_date":"2018-12-29 22:55:23","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"161.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911446","reservation_id":"64961","confirmation_number":"PB12387459827","room_stay_from":"2019-01-01","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00,23.78,0.00","subtotal":"476.00","grand_total":"511.01","paid_amount":"511.01","room_type_id":"289","product_id":"1104","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":"52357","customer_id":"52357","source_of_creation":"PMS","reservation_created_date":"2018-12-31 19:57:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911492","reservation_id":"49336","confirmation_number":"PB12395178081","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,134.00,134.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"938.00","grand_total":"1059.94","paid_amount":"1059.94","room_type_id":"289","product_id":"1093","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":"71320","customer_id":"71320","source_of_creation":"PMS","reservation_created_date":"2018-06-18 19:55:30","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911494","reservation_id":"49336","confirmation_number":"PB12321287513","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,184.00,184.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1038.00","grand_total":"1172.94","paid_amount":"1172.94","room_type_id":"289","product_id":"1094","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":"71320","customer_id":"71320","source_of_creation":"PMS","reservation_created_date":"2018-06-18 19:55:31","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911498","reservation_id":"49336","confirmation_number":"PB12333738962","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,184.00,184.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1038.00","grand_total":"1172.94","paid_amount":"1172.94","room_type_id":"289","product_id":"1095","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":"71320","customer_id":"71320","source_of_creation":"PMS","reservation_created_date":"2018-06-18 19:55:32","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911510","reservation_id":"64676","confirmation_number":"BP12528088497","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.60,84.00,84.00,81.60,81.60,81.60,81.60","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"568.00","grand_total":"641.84","paid_amount":"641.84","room_type_id":"295","product_id":"1129","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":"79102","customer_id":"79102","source_of_creation":"PMS","reservation_created_date":"2018-12-29 15:08:33","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2926683","reservation_id":"63996","confirmation_number":"BV12497687505","room_stay_from":"2019-01-03","room_stay_to":"2019-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65","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","subtotal":"1630.65","grand_total":"1842.64","paid_amount":"1842.64","room_type_id":"303","product_id":"1140","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":"78851","customer_id":"78851","source_of_creation":"PMS","reservation_created_date":"2018-12-22 16:57:22","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2934470","reservation_id":"30562","confirmation_number":"PB916443308","room_stay_from":"2019-01-03","room_stay_to":"2019-03-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43,113.43","nightly_discount":"87.11,87.11,87.11,87.11,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"7146.09","grand_total":"7681.35","paid_amount":"7681.35","room_type_id":"285","product_id":"1083","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":"23037","customer_id":"23037","source_of_creation":"PMS","reservation_created_date":"2018-02-17 23:01:53","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"113.43","currentDayDiscount":"87.11","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2899112","reservation_id":"63730","confirmation_number":"PBR12257333983","room_confirmation_number":"PB12398360859","room_stay_from":"2018-12-29","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0,0","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"78707","product_attribute_values":"extra_person#&#10","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78707","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2904903","reservation_id":"64269","confirmation_number":"PB12240197965","room_confirmation_number":"PB12329165658","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"78947","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2018-12-26 00:22:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78947","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2906396","reservation_id":"61005","confirmation_number":"PB12276438119","room_confirmation_number":"PB12342570084","room_stay_from":"2018-12-30","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"30,30,30,30,30","nightly_discount":"0,0,0,0,0","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"77323","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2018-12-28 16:08:44","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77323","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2911389","reservation_id":"64151","confirmation_number":"PB12230822704","room_confirmation_number":"PB12330819377","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"30,30,30","nightly_discount":"0.00,0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1780","service_quantity":"1","customer_traveller_id":"78908","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-01-05 14:04:18","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78908","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2898863","reservation_id":"58096","confirmation_number":"PBR12229201566","room_confirmation_number":"PB12315576038","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"75908","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75908","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2898864","reservation_id":"58098","confirmation_number":"PBR12268181066","room_confirmation_number":"PB12360697642","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"75908","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75908","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2898865","reservation_id":"58099","confirmation_number":"PBR12289079923","room_confirmation_number":"PB12313882951","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"75909","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75909","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2899000","reservation_id":"62180","confirmation_number":"PBR12284720664","room_confirmation_number":"BV12473343889","room_stay_from":"2018-12-28","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"77987","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77987","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2899021","reservation_id":"63052","confirmation_number":"PBR12228330704","room_confirmation_number":"PB12345826500","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"78461","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78461","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2899113","reservation_id":"63730","confirmation_number":"PBR12269168480","room_confirmation_number":"PB12398360859","room_stay_from":"2018-12-29","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"78707","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78707","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2900962","reservation_id":"60511","confirmation_number":"PBR12287942666","room_confirmation_number":"PB12348051882","room_stay_from":"2018-12-17","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"216.00","grand_total":"244.08","paid_amount":"244.08","product_id":"1781","service_quantity":"1","customer_traveller_id":"77126","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77126","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2904582","reservation_id":"64219","confirmation_number":"BP12298644065","room_confirmation_number":"BP12528018606","room_stay_from":"2018-12-31","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"78929","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-25 18:02:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72665","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2904904","reservation_id":"64269","confirmation_number":"PB12259143598","room_confirmation_number":"PB12329165658","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"78947","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-26 00:22:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78947","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2905269","reservation_id":"60962","confirmation_number":"PBR12211525968","room_confirmation_number":"BV12419724510","room_stay_from":"2018-12-26","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"77310","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77310","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2905625","reservation_id":"30738","confirmation_number":"PB12369587397","room_confirmation_number":"PB938814659","room_stay_from":"2018-12-26","room_stay_to":"2019-01-17","room_stay_status":"Active","nightly_price":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"69127","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-02-28 21:58:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"69127","canceled_nights_data":"","currentDayPrice":"0","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2905664","reservation_id":"30899","confirmation_number":"PB12342229186","room_confirmation_number":"PB960032132","room_stay_from":"2018-12-26","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"64186","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-03-31 22:14:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"64186","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2905787","reservation_id":"64401","confirmation_number":"BV12225992547","room_confirmation_number":"BV12422423321","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"79005","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-27 17:23:39","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79005","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2906320","reservation_id":"64383","confirmation_number":"BV12269205794","room_confirmation_number":"BV12480014270","room_stay_from":"2018-12-30","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"78993","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-27 04:24:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78993","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2906397","reservation_id":"61005","confirmation_number":"PBR12267906406","room_confirmation_number":"PB12342570084","room_stay_from":"2018-12-30","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"77323","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77323","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2906893","reservation_id":"58039","confirmation_number":"PBR12221794937","room_confirmation_number":"PB12344673941","room_stay_from":"2018-12-28","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"67061","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"67061","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907593","reservation_id":"64252","confirmation_number":"BP12268535110","room_confirmation_number":"BP12571058895","room_stay_from":"2018-12-29","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"78938","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-25 21:35:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78938","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907753","reservation_id":"64007","confirmation_number":"BV12227949661","room_confirmation_number":"BV12492125215","room_stay_from":"2018-12-31","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"78853","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-22 18:25:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78853","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907922","reservation_id":"64844","confirmation_number":"PB12249422606","room_confirmation_number":"PB12361017668","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"26469","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-30 20:20:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26469","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2908231","reservation_id":"64924","confirmation_number":"BP12263810557","room_confirmation_number":"BP12539363872","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79466","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-31 13:28:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79466","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2908318","reservation_id":"64941","confirmation_number":"BP12278326190","room_confirmation_number":"BP12554149004","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"79198","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-31 17:30:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79198","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2908511","reservation_id":"64972","confirmation_number":"BP12248984309","room_confirmation_number":"BP12514441935","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"42153","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-31 20:59:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42153","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2908703","reservation_id":"64887","confirmation_number":"PB12210603999","room_confirmation_number":"PB12372641357","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"79171","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-30 23:45:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79171","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2908770","reservation_id":"64669","confirmation_number":"BV12281041751","room_confirmation_number":"BV12494305673","room_stay_from":"2019-01-03","room_stay_to":"2019-01-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"79095","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-29 13:41:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79095","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2908886","reservation_id":"65060","confirmation_number":"BP12292304192","room_confirmation_number":"BP12541804584","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"79242","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-01 16:45:46","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79242","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909009","reservation_id":"65092","confirmation_number":"PB12230675392","room_confirmation_number":"PB12375531034","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"79253","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-01 19:05:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79253","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909047","reservation_id":"65095","confirmation_number":"PB12244169648","room_confirmation_number":"PB12350573763","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"79255","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-01 19:20:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79255","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909090","reservation_id":"65106","confirmation_number":"PB12221381364","room_confirmation_number":"PB12322766274","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"79264","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-01 20:08:02","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79264","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909288","reservation_id":"64526","confirmation_number":"BV12231381743","room_confirmation_number":"BV12444980014","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"36.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"79035","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-28 04:03:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79035","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909291","reservation_id":"65151","confirmation_number":"BV12260506281","room_confirmation_number":"BV12441919729","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"79284","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-02 00:05:28","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79284","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909351","reservation_id":"65033","confirmation_number":"BV12232434950","room_confirmation_number":"BV12493382396","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79224","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-01 05:36:15","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79224","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909399","reservation_id":"64944","confirmation_number":"PB12253567755","room_confirmation_number":"PB12348109274","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79199","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-31 17:55:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79199","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909401","reservation_id":"64656","confirmation_number":"PB12233521372","room_confirmation_number":"PB12395126017","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"36.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"53870","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-29 03:46:50","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53870","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909446","reservation_id":"65182","confirmation_number":"PB12249786029","room_confirmation_number":"PB12357253016","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"79016","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-02 13:42:36","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79016","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909466","reservation_id":"65187","confirmation_number":"BV12267898543","room_confirmation_number":"BV12423957971","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"79312","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-02 14:16:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79312","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909497","reservation_id":"65193","confirmation_number":"PB12248480502","room_confirmation_number":"PB12329487268","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"76008","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-02 15:50:39","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76008","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909849","reservation_id":"65271","confirmation_number":"PB12233248071","room_confirmation_number":"PB12389886608","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"78954","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-02 22:12:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78954","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910124","reservation_id":"65337","confirmation_number":"PB12299631203","room_confirmation_number":"PB12378552559","room_stay_from":"2019-01-03","room_stay_to":"2019-01-09","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"79374","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-03 14:49:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79374","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910149","reservation_id":"65343","confirmation_number":"PB12253047400","room_confirmation_number":"PB12317358358","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"79377","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-03 16:00:22","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79377","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910179","reservation_id":"65348","confirmation_number":"PB12228266877","room_confirmation_number":"PB12397201926","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"60164","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-03 18:17:55","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"60164","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910183","reservation_id":"65350","confirmation_number":"PB12258042759","room_confirmation_number":"PB12378650081","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"79384","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-03 18:35:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79384","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910193","reservation_id":"65352","confirmation_number":"BV12269337749","room_confirmation_number":"BV12444297515","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"79387","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-03 18:47:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79387","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910263","reservation_id":"65374","confirmation_number":"BP12261571530","room_confirmation_number":"BP12563230221","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"79395","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-03 20:40:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79395","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911336","reservation_id":"64747","confirmation_number":"PB12281028911","room_confirmation_number":"PB12351646694","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"79124","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-29 22:55:23","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79124","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911351","reservation_id":"64330","confirmation_number":"PB12235386895","room_confirmation_number":"PB12337416747","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"78976","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-26 20:55:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78976","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911387","reservation_id":"64315","confirmation_number":"PB12294991886","room_confirmation_number":"PB12377250827","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"78970","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-26 18:33:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78970","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911396","reservation_id":"64151","confirmation_number":"PB12227649305","room_confirmation_number":"PB12330819377","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"78908","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-24 19:21:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78908","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911447","reservation_id":"64961","confirmation_number":"PB12210022592","room_confirmation_number":"PB12387459827","room_stay_from":"2019-01-01","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"52357","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-31 19:57:17","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"52357","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911483","reservation_id":"62792","confirmation_number":"PBR12279524923","room_confirmation_number":"PB12342995915","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"78395","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78395","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911493","reservation_id":"49336","confirmation_number":"PBR12279492377","room_confirmation_number":"PB12395178081","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"71320","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"2018-06-18 19:55:30","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71320","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911495","reservation_id":"49336","confirmation_number":"PBR12278630843","room_confirmation_number":"PB12321287513","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"71320","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"2018-06-18 19:55:30","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71320","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911499","reservation_id":"49336","confirmation_number":"PBR12238759839","room_confirmation_number":"PB12333738962","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"71320","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71320","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911511","reservation_id":"64676","confirmation_number":"BP12288954208","room_confirmation_number":"BP12528088497","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"79102","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-29 15:08:33","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79102","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2912801","reservation_id":"62799","confirmation_number":"PBR12266548520","room_confirmation_number":"BP12545263947","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"78399","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78399","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2914493","reservation_id":"65184","confirmation_number":"PB12248783751","room_confirmation_number":"PB12328285918","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79309","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-02 14:00:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79309","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2926684","reservation_id":"63996","confirmation_number":"BV12214529070","room_confirmation_number":"BV12497687505","room_stay_from":"2019-01-03","room_stay_to":"2019-01-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.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","subtotal":"252.00","grand_total":"284.76","paid_amount":"284.76","product_id":"1781","service_quantity":"1","customer_traveller_id":"78851","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-22 16:57:22","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78851","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2934471","reservation_id":"30562","confirmation_number":"PB12332311942","room_confirmation_number":"PB916443308","room_stay_from":"2019-01-03","room_stay_to":"2019-03-07","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23037","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-02-17 23:01:53","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23037","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2948411","reservation_id":"63672","confirmation_number":"PBR12271851677","room_confirmation_number":"BP12553313851","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"78663","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78663","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2915596","reservation_id":"65419","confirmation_number":"PB12278953876","room_confirmation_number":"PB12365308537","room_stay_from":"2019-01-04","room_stay_to":"2019-01-14","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"65816","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-04 00:51:35","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"65816","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2910131","reservation_id":"62787","confirmation_number":"BP12254343745","room_confirmation_number":"BP12585818875","room_stay_from":"2019-01-12","room_stay_to":"2019-01-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"197.75","paid_amount":"197.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-03 15:03:11","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"78392","parentCustTravId":"78392","customer_traveller_id":"78392","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2910295","reservation_id":"65383","confirmation_number":"BV12268674477","room_confirmation_number":"BV12434169540","room_stay_from":"2019-01-24","room_stay_to":"2019-01-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.75","paid_amount":"84.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-03 21:44:47","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"79402","parentCustTravId":"79402","customer_traveller_id":"79402","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2910134","reservation_id":"65339","confirmation_number":"PB12223101138","room_confirmation_number":"PB12334636900","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":null,"service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-03 15:13:32","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"2910136","reservation_id":"65340","confirmation_number":"PB12257891699","room_confirmation_number":"PB12381330422","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.67","grand_total":"9.99","paid_amount":"9.99","product_id":null,"service_quantity":"2","product_name":"Fishing Pole","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-03 15:14:32","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"9.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1123","departureCount":15,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2904902","reservation_id":"64269","confirmation_number":"PB12329165658","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"111.38","nightly_discount":"0","subtotal":"111.38","grand_total":"125.86","paid_amount":"125.86","room_type_id":"289","product_id":"1099","siteminder_id":"BDC-1819378076","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":"78947","customer_id":"78947","source_of_creation":"Booking.com","reservation_created_date":"2018-12-26 00:22:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"16.71","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.38","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2906395","reservation_id":"61005","confirmation_number":"PB12342570084","room_stay_from":"2018-12-30","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"136.00,136.00,136.00,160.00,160.00","nightly_discount":"0,0,0,0,0","subtotal":"728.00","grand_total":"822.64","paid_amount":"822.64","room_type_id":"291","product_id":"1118","siteminder_id":"BDC-1459509815","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":"77323","customer_id":"77323","source_of_creation":"Booking.com","reservation_created_date":"2018-11-23 20:45:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"109.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2909046","reservation_id":"65095","confirmation_number":"PB12350573763","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"95.47,95.47,111.89,111.89","nightly_discount":"0,0,0,0","subtotal":"414.72","grand_total":"468.63","paid_amount":"468.63","room_type_id":"289","product_id":"1102","siteminder_id":"BDC-1002386324","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":"79255","customer_id":"79255","source_of_creation":"Booking.com","reservation_created_date":"2019-01-01 19:20:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"62.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.47","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909398","reservation_id":"64944","confirmation_number":"PB12348109274","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"111.89,111.89,128.30","nightly_discount":"0.00,0.00,20.93","subtotal":"352.08","grand_total":"374.20","paid_amount":"374.20","room_type_id":"291","product_id":"1115","siteminder_id":"BDC-1229078166","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":"79199","customer_id":"79199","source_of_creation":"Booking.com","reservation_created_date":"2018-12-31 17:55:14","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"39.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.89","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910123","reservation_id":"65337","confirmation_number":"PB12378552559","room_stay_from":"2019-01-03","room_stay_to":"2019-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.89,128.30,128.30,116.21,116.21,116.21","nightly_discount":"0,0,0,0,0,0","subtotal":"717.12","grand_total":"810.35","paid_amount":"810.35","room_type_id":"291","product_id":"1114","siteminder_id":"BDC-1134712172","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":"79374","customer_id":"79374","source_of_creation":"Booking.com","reservation_created_date":"2019-01-03 14:49:14","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"107.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.89","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911386","reservation_id":"64315","confirmation_number":"PB12377250827","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"95.47,95.47,111.89,111.89","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"414.72","grand_total":"468.63","paid_amount":"468.63","room_type_id":"289","product_id":"1100","siteminder_id":"BDC-1412738243","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":"78970","customer_id":"78970","source_of_creation":"Booking.com","reservation_created_date":"2018-12-26 18:33:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"62.21","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.47","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911395","reservation_id":"64151","confirmation_number":"PB12330819377","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"111.38,130.54,130.54","nightly_discount":"0.00,0.00,0.00","subtotal":"372.46","grand_total":"420.88","paid_amount":"420.88","room_type_id":"289","product_id":"1098","siteminder_id":"BDC-1819309475","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":"78908","customer_id":"78908","source_of_creation":"Booking.com","reservation_created_date":"2018-12-24 19:21:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"55.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2895584","reservation_id":"63052","confirmation_number":"PB12345826500","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"126.85,126.85","nightly_discount":"0,0","subtotal":"253.70","grand_total":"286.68","paid_amount":"286.68","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1160651763","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":"78461","customer_id":"78461","source_of_creation":"Expedia","reservation_created_date":"2018-12-08 22:10:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.85","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2898625","reservation_id":"63730","confirmation_number":"PB12398360859","room_stay_from":"2018-12-29","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"251.80,200.60,200.60,200.60,150.68,150.68,170.14","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1325.10","grand_total":"1497.36","paid_amount":"1497.36","room_type_id":"288","product_id":"1092","siteminder_id":"EXP-1165453720","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":"78707","customer_id":"78707","source_of_creation":"Expedia","reservation_created_date":"2018-12-18 20:10:13","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"150.68","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2908702","reservation_id":"64887","confirmation_number":"PB12372641357","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.54,130.54","nightly_discount":"0,0","subtotal":"261.08","grand_total":"295.02","paid_amount":"295.02","room_type_id":"291","product_id":"1116","siteminder_id":"EXP-1171051751","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":"79171","customer_id":"79171","source_of_creation":"Expedia","reservation_created_date":"2018-12-30 23:45:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"130.54","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909008","reservation_id":"65092","confirmation_number":"PB12375531034","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.34,91.34","nightly_discount":"0,0","subtotal":"182.68","grand_total":"206.43","paid_amount":"206.43","room_type_id":"289","product_id":"1101","siteminder_id":"EXP-1171778349","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":"79253","customer_id":"79253","source_of_creation":"Expedia","reservation_created_date":"2019-01-01 19:05:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.34","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910148","reservation_id":"65343","confirmation_number":"PB12317358358","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.08","nightly_discount":"0","subtotal":"86.08","grand_total":"97.27","paid_amount":"97.27","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1172870240","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":"79377","customer_id":"79377","source_of_creation":"Expedia","reservation_created_date":"2019-01-03 16:00:22","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"86.08","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910182","reservation_id":"65350","confirmation_number":"PB12378650081","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"91.74","nightly_discount":"0","subtotal":"91.74","grand_total":"103.66","paid_amount":"103.66","room_type_id":"291","product_id":"1117","siteminder_id":"EXP-1172957227","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":"79384","customer_id":"79384","source_of_creation":"Expedia","reservation_created_date":"2019-01-03 18:35:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.74","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911482","reservation_id":"62792","confirmation_number":"PB12342995915","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.19,104.38,104.38,122.33,122.33","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"569.61","grand_total":"643.66","paid_amount":"643.66","room_type_id":"289","product_id":"1097","siteminder_id":"EXP-1159510132","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":"78395","customer_id":"78395","source_of_creation":"Expedia","reservation_created_date":"2018-12-06 13:15:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2914492","reservation_id":"65184","confirmation_number":"PB12328285918","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.29,78.29,78.29","nightly_discount":"0.00,0.00,0.00","subtotal":"234.87","grand_total":"265.40","paid_amount":"265.40","room_type_id":"289","product_id":"1121","siteminder_id":"EXP-1172170327","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":"79309","customer_id":"79309","source_of_creation":"Expedia","reservation_created_date":"2019-01-02 14:00:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"2911350","reservation_id":"64330","confirmation_number":"PB12337416747","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.86,62.86,62.86","nightly_discount":"0,0,0","subtotal":"188.58","grand_total":"213.09","paid_amount":"213.09","room_type_id":"285","product_id":"1084","siteminder_id":"HTN-71720995","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":"78976","customer_id":"78976","source_of_creation":"HotelTonight","reservation_created_date":"2018-12-26 20:55:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.86","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_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_non_taxable":[],"pms_taxable":[{"room_stay_id":"2876331","reservation_id":"58096","confirmation_number":"PB12315576038","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1222.00","grand_total":"1380.86","paid_amount":"1380.86","room_type_id":"289","product_id":"1110","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":"75908","customer_id":"75908","source_of_creation":"PMS","reservation_created_date":"2018-10-12 16:00:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2876334","reservation_id":"58098","confirmation_number":"PB12360697642","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1222.00","grand_total":"1380.86","paid_amount":"1380.86","room_type_id":"289","product_id":"1111","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":"75908","customer_id":"75908","source_of_creation":"PMS","reservation_created_date":"2018-10-12 16:04:38","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2876337","reservation_id":"58099","confirmation_number":"PB12313882951","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1222.00","grand_total":"1380.86","paid_amount":"1380.86","room_type_id":"289","product_id":"1112","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":"75909","customer_id":"75909","source_of_creation":"PMS","reservation_created_date":"2018-10-12 16:07:57","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2886568","reservation_id":"60511","confirmation_number":"PB12348051882","room_stay_from":"2018-12-17","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.00,92.00,92.00,92.00,142.00,184.00,134.00,134.00,134.00,134.00,134.00,184.00,184.00,134.00,134.00,134.00,134.00,134.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","subtotal":"2402.00","grand_total":"2714.26","paid_amount":"2714.26","room_type_id":"289","product_id":"1105","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":"77126","customer_id":"77126","source_of_creation":"PMS","reservation_created_date":"2018-11-16 21:53:32","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2906892","reservation_id":"58039","confirmation_number":"PB12344673941","room_stay_from":"2018-12-28","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"184.00,184.00,134.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,46.90,0.00","subtotal":"1038.00","grand_total":"1119.94","paid_amount":"1119.94","room_type_id":"289","product_id":"1107","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":"67061","customer_id":"67061","source_of_creation":"PMS","reservation_created_date":"2018-10-11 17:48:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"46.90","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907400","reservation_id":"52220","confirmation_number":"PB12396248214","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,199.00,199.00","nightly_discount":"0.00,0.00,0.00","subtotal":"597.00","grand_total":"674.61","paid_amount":"674.61","room_type_id":"287","product_id":"1087","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":"43106","customer_id":"43106","source_of_creation":"PMS","reservation_created_date":"2018-07-27 01:00:43","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"199.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2907921","reservation_id":"64844","confirmation_number":"PB12361017668","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","room_type_id":"287","product_id":"1088","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":"26469","customer_id":"26469","source_of_creation":"PMS","reservation_created_date":"2018-12-30 20:20:48","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","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":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909089","reservation_id":"65106","confirmation_number":"PB12322766274","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","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":"292","product_id":"1120","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":"79264","customer_id":"79264","source_of_creation":"PMS","reservation_created_date":"2019-01-01 20:08:02","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","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":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909400","reservation_id":"64656","confirmation_number":"PB12395126017","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"145.00,96.00,96.00","nightly_discount":"0.00,0.00,19.02","subtotal":"337.00","grand_total":"359.32","paid_amount":"364.00","room_type_id":"289","product_id":"1123","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":"53870","customer_id":"53870","source_of_creation":"PMS","reservation_created_date":"2018-12-29 03:46:50","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.00","currentDayDiscount":"19.02","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909445","reservation_id":"65182","confirmation_number":"PB12357253016","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.40","nightly_discount":"0.00","subtotal":"94.40","grand_total":"106.67","paid_amount":"106.67","room_type_id":"285","product_id":"1085","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":"79016","customer_id":"79016","source_of_creation":"PMS","reservation_created_date":"2019-01-02 13:42:36","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909496","reservation_id":"65193","confirmation_number":"PB12329487268","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"105.60","nightly_discount":"0.00","subtotal":"105.60","grand_total":"119.33","paid_amount":"119.33","room_type_id":"289","product_id":"1108","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":"76008","customer_id":"76008","source_of_creation":"PMS","reservation_created_date":"2019-01-02 15:50:39","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909848","reservation_id":"65271","confirmation_number":"PB12389886608","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.60","nightly_discount":"0.00","subtotal":"105.60","grand_total":"119.33","paid_amount":"119.33","room_type_id":"289","product_id":"1106","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":"78954","customer_id":"78954","source_of_creation":"PMS","reservation_created_date":"2019-01-02 22:12:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910178","reservation_id":"65348","confirmation_number":"PB12397201926","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.80,131.20","nightly_discount":"0.00,0.00","subtotal":"256.00","grand_total":"289.28","paid_amount":"289.28","room_type_id":"291","product_id":"1119","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":"60164","customer_id":"60164","source_of_creation":"PMS","reservation_created_date":"2019-01-03 18:17:55","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911335","reservation_id":"64747","confirmation_number":"PB12351646694","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"161.60,168.00","nightly_discount":"0.00,0.00","subtotal":"329.60","grand_total":"372.45","paid_amount":"372.45","room_type_id":"287","product_id":"1090","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":"79124","customer_id":"79124","source_of_creation":"PMS","reservation_created_date":"2018-12-29 22:55:23","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"161.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911446","reservation_id":"64961","confirmation_number":"PB12387459827","room_stay_from":"2019-01-01","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00,119.00","nightly_discount":"0.00,0.00,0.00,23.78,0.00","subtotal":"476.00","grand_total":"511.01","paid_amount":"511.01","room_type_id":"289","product_id":"1104","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":"52357","customer_id":"52357","source_of_creation":"PMS","reservation_created_date":"2018-12-31 19:57:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911492","reservation_id":"49336","confirmation_number":"PB12395178081","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,134.00,134.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"938.00","grand_total":"1059.94","paid_amount":"1059.94","room_type_id":"289","product_id":"1093","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":"71320","customer_id":"71320","source_of_creation":"PMS","reservation_created_date":"2018-06-18 19:55:30","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911494","reservation_id":"49336","confirmation_number":"PB12321287513","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,184.00,184.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1038.00","grand_total":"1172.94","paid_amount":"1172.94","room_type_id":"289","product_id":"1094","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":"71320","customer_id":"71320","source_of_creation":"PMS","reservation_created_date":"2018-06-18 19:55:31","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911498","reservation_id":"49336","confirmation_number":"PB12333738962","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"134.00,184.00,184.00,134.00,134.00,134.00,134.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1038.00","grand_total":"1172.94","paid_amount":"1172.94","room_type_id":"289","product_id":"1095","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":"71320","customer_id":"71320","source_of_creation":"PMS","reservation_created_date":"2018-06-18 19:55:32","canceled_nights_data":"","product_name":"PB:- Deluxe Efficiency Suite 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"134.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"2899112","reservation_id":"63730","confirmation_number":"PBR12257333983","room_confirmation_number":"PB12398360859","room_stay_from":"2018-12-29","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0,0,0,0,0,0,0","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"78707","product_attribute_values":"extra_person#&#10","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78707","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2904903","reservation_id":"64269","confirmation_number":"PB12240197965","room_confirmation_number":"PB12329165658","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"78947","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2018-12-26 00:22:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78947","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2906396","reservation_id":"61005","confirmation_number":"PB12276438119","room_confirmation_number":"PB12342570084","room_stay_from":"2018-12-30","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"30,30,30,30,30","nightly_discount":"0,0,0,0,0","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"77323","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2018-12-28 16:08:44","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77323","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2911389","reservation_id":"64151","confirmation_number":"PB12230822704","room_confirmation_number":"PB12330819377","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"30,30,30","nightly_discount":"0.00,0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1780","service_quantity":"1","customer_traveller_id":"78908","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-01-05 14:04:18","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78908","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2898863","reservation_id":"58096","confirmation_number":"PBR12229201566","room_confirmation_number":"PB12315576038","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"75908","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75908","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2898864","reservation_id":"58098","confirmation_number":"PBR12268181066","room_confirmation_number":"PB12360697642","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"75908","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75908","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2898865","reservation_id":"58099","confirmation_number":"PBR12289079923","room_confirmation_number":"PB12313882951","room_stay_from":"2018-12-29","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"75909","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"75909","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2899021","reservation_id":"63052","confirmation_number":"PBR12228330704","room_confirmation_number":"PB12345826500","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"78461","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78461","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2899113","reservation_id":"63730","confirmation_number":"PBR12269168480","room_confirmation_number":"PB12398360859","room_stay_from":"2018-12-29","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"78707","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78707","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2900962","reservation_id":"60511","confirmation_number":"PBR12287942666","room_confirmation_number":"PB12348051882","room_stay_from":"2018-12-17","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"216.00","grand_total":"244.08","paid_amount":"244.08","product_id":"1781","service_quantity":"1","customer_traveller_id":"77126","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77126","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2904904","reservation_id":"64269","confirmation_number":"PB12259143598","room_confirmation_number":"PB12329165658","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"78947","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-26 00:22:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78947","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2906397","reservation_id":"61005","confirmation_number":"PBR12267906406","room_confirmation_number":"PB12342570084","room_stay_from":"2018-12-30","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"77323","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77323","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2906893","reservation_id":"58039","confirmation_number":"PBR12221794937","room_confirmation_number":"PB12344673941","room_stay_from":"2018-12-28","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"67061","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"67061","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907922","reservation_id":"64844","confirmation_number":"PB12249422606","room_confirmation_number":"PB12361017668","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"26469","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-30 20:20:48","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26469","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2908703","reservation_id":"64887","confirmation_number":"PB12210603999","room_confirmation_number":"PB12372641357","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"79171","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-30 23:45:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79171","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909009","reservation_id":"65092","confirmation_number":"PB12230675392","room_confirmation_number":"PB12375531034","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"79253","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-01 19:05:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79253","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909047","reservation_id":"65095","confirmation_number":"PB12244169648","room_confirmation_number":"PB12350573763","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"79255","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-01 19:20:13","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79255","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909090","reservation_id":"65106","confirmation_number":"PB12221381364","room_confirmation_number":"PB12322766274","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"79264","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-01 20:08:02","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79264","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909399","reservation_id":"64944","confirmation_number":"PB12253567755","room_confirmation_number":"PB12348109274","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79199","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-31 17:55:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79199","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909401","reservation_id":"64656","confirmation_number":"PB12233521372","room_confirmation_number":"PB12395126017","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"36.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"53870","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-29 03:46:50","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"53870","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909446","reservation_id":"65182","confirmation_number":"PB12249786029","room_confirmation_number":"PB12357253016","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"79016","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-02 13:42:36","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79016","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909497","reservation_id":"65193","confirmation_number":"PB12248480502","room_confirmation_number":"PB12329487268","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"76008","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-02 15:50:39","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76008","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909849","reservation_id":"65271","confirmation_number":"PB12233248071","room_confirmation_number":"PB12389886608","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"78954","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-02 22:12:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78954","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910124","reservation_id":"65337","confirmation_number":"PB12299631203","room_confirmation_number":"PB12378552559","room_stay_from":"2019-01-03","room_stay_to":"2019-01-09","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"79374","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-03 14:49:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79374","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910149","reservation_id":"65343","confirmation_number":"PB12253047400","room_confirmation_number":"PB12317358358","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"79377","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-03 16:00:22","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79377","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910179","reservation_id":"65348","confirmation_number":"PB12228266877","room_confirmation_number":"PB12397201926","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"60164","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-03 18:17:55","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"60164","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910183","reservation_id":"65350","confirmation_number":"PB12258042759","room_confirmation_number":"PB12378650081","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"79384","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-03 18:35:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79384","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911336","reservation_id":"64747","confirmation_number":"PB12281028911","room_confirmation_number":"PB12351646694","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"79124","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-29 22:55:23","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79124","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911351","reservation_id":"64330","confirmation_number":"PB12235386895","room_confirmation_number":"PB12337416747","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"78976","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-26 20:55:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78976","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911387","reservation_id":"64315","confirmation_number":"PB12294991886","room_confirmation_number":"PB12377250827","room_stay_from":"2019-01-02","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"78970","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-26 18:33:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78970","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911396","reservation_id":"64151","confirmation_number":"PB12227649305","room_confirmation_number":"PB12330819377","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"78908","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-24 19:21:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78908","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911447","reservation_id":"64961","confirmation_number":"PB12210022592","room_confirmation_number":"PB12387459827","room_stay_from":"2019-01-01","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"52357","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-31 19:57:17","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"52357","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911483","reservation_id":"62792","confirmation_number":"PBR12279524923","room_confirmation_number":"PB12342995915","room_stay_from":"2019-01-01","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"78395","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78395","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911493","reservation_id":"49336","confirmation_number":"PBR12279492377","room_confirmation_number":"PB12395178081","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"71320","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"2018-06-18 19:55:30","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71320","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911495","reservation_id":"49336","confirmation_number":"PBR12278630843","room_confirmation_number":"PB12321287513","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"71320","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"2018-06-18 19:55:30","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71320","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911499","reservation_id":"49336","confirmation_number":"PBR12238759839","room_confirmation_number":"PB12333738962","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"71320","product_attribute_values":"resort_fee#&#flat_rate#&#12.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71320","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2914493","reservation_id":"65184","confirmation_number":"PB12248783751","room_confirmation_number":"PB12328285918","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79309","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-02 14:00:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79309","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2915596","reservation_id":"65419","confirmation_number":"PB12278953876","room_confirmation_number":"PB12365308537","room_stay_from":"2019-01-04","room_stay_to":"2019-01-14","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"65816","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-04 00:51:35","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"65816","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2910134","reservation_id":"65339","confirmation_number":"PB12223101138","room_confirmation_number":"PB12334636900","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":null,"service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-03 15:13:32","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"2910136","reservation_id":"65340","confirmation_number":"PB12257891699","room_confirmation_number":"PB12381330422","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.67","grand_total":"9.99","paid_amount":"9.99","product_id":null,"service_quantity":"2","product_name":"Fishing Pole","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-03 15:14:32","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"9.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":4,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"2905268","reservation_id":"60962","confirmation_number":"BV12419724510","room_stay_from":"2018-12-26","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.00,108.00,188.00,188.00,108.00,108.00,108.00,118.00,118.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,61.82,0.00","subtotal":"1152.00","grand_total":"1231.90","paid_amount":"1231.90","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-2091880938","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":"77310","customer_id":"77310","source_of_creation":"Booking.com","reservation_created_date":"2018-11-23 01:32:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"172.80","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"118.00","currentDayDiscount":"61.82","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2908769","reservation_id":"64669","confirmation_number":"BV12494305673","room_stay_from":"2019-01-03","room_stay_to":"2019-01-07","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"97.81,112.32,112.32,101.56","nightly_discount":"0,0,0,0","subtotal":"424.01","grand_total":"479.13","paid_amount":"479.13","room_type_id":"304","product_id":"1220","siteminder_id":"BDC-1293666967","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":"79095","customer_id":"79095","source_of_creation":"Booking.com","reservation_created_date":"2018-12-29 13:41:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"63.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.81","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909349","reservation_id":"65033","confirmation_number":"BV12493382396","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.81,112.32,112.32","nightly_discount":"0.00,0.00,0.00","subtotal":"322.45","grand_total":"341.80","paid_amount":"364.37","room_type_id":"304","product_id":"1221","siteminder_id":"BDC-1026627407","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":"79224","customer_id":"79224","source_of_creation":"Booking.com","reservation_created_date":"2019-01-01 05:36:15","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"42.10","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"97.81","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2907752","reservation_id":"64007","confirmation_number":"BV12492125215","room_stay_from":"2018-12-31","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"113.88,113.88,87.74,87.74","nightly_discount":"0,0,0,0","subtotal":"403.24","grand_total":"455.66","paid_amount":"455.66","room_type_id":"304","product_id":"1219","siteminder_id":"EXP-1167359815","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":"78853","customer_id":"78853","source_of_creation":"Expedia","reservation_created_date":"2018-12-22 18:25:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"87.74","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"2909465","reservation_id":"65187","confirmation_number":"BV12423957971","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.76,53.76","nightly_discount":"0,0","subtotal":"107.51","grand_total":"121.49","paid_amount":"121.49","room_type_id":"307","product_id":"1224","siteminder_id":"HTN-72453136-E4KT9D","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":"79312","customer_id":"79312","source_of_creation":"HotelTonight","reservation_created_date":"2019-01-02 14:16:11","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"53.76","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[{"room_stay_id":"2893241","reservation_id":"62180","confirmation_number":"BV12473343889","room_stay_from":"2018-12-28","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.80,118.80,86.80,86.80,86.80,83.60,83.60","nightly_discount":"0,0,0,0,0,0,0","subtotal":"665.20","grand_total":"751.68","paid_amount":"751.68","room_type_id":"305","product_id":"1222","siteminder_id":"PCL-32840683","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":"77987","customer_id":"77987","source_of_creation":"Priceline.com","reservation_created_date":"2018-12-05 00:53:08","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"83.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2910192","reservation_id":"65352","confirmation_number":"BV12444297515","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"72.23","nightly_discount":"0","subtotal":"72.23","grand_total":"81.62","paid_amount":"81.62","room_type_id":"301","product_id":"1136","siteminder_id":"PCL-33079633","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":"79387","customer_id":"79387","source_of_creation":"Priceline.com","reservation_created_date":"2019-01-03 18:47:10","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"72.23","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"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":"2905786","reservation_id":"64401","confirmation_number":"BV12422423321","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.60,137.60","nightly_discount":"0.00,0.00","subtotal":"275.20","grand_total":"310.97","paid_amount":"310.97","room_type_id":"306","product_id":"1223","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":"79005","customer_id":"79005","source_of_creation":"FE","reservation_created_date":"2018-12-27 17:23:39","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"137.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2906319","reservation_id":"64383","confirmation_number":"BV12480014270","room_stay_from":"2018-12-30","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"151.00,151.00,151.00,114.40,114.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"681.80","grand_total":"770.43","paid_amount":"770.43","room_type_id":"308","product_id":"1225","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":"78993","customer_id":"78993","source_of_creation":"FE","reservation_created_date":"2018-12-27 04:24:14","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2909290","reservation_id":"65151","confirmation_number":"BV12441919729","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.80,116.80","nightly_discount":"0.00,0.00","subtotal":"233.60","grand_total":"263.97","paid_amount":"263.97","room_type_id":"309","product_id":"1226","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":"79284","customer_id":"79284","source_of_creation":"FE","reservation_created_date":"2019-01-02 00:05:28","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"116.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2909287","reservation_id":"64526","confirmation_number":"BV12444980014","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.00,78.40,78.40","nightly_discount":"0.00,0.00,9.62","subtotal":"262.80","grand_total":"286.09","paid_amount":"290.78","room_type_id":"294","product_id":"1126","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":"79035","customer_id":"79035","source_of_creation":"PMS","reservation_created_date":"2018-12-28 04:03:07","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.40","currentDayDiscount":"9.62","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2926683","reservation_id":"63996","confirmation_number":"BV12497687505","room_stay_from":"2019-01-03","room_stay_to":"2019-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65,77.65","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","subtotal":"1630.65","grand_total":"1842.64","paid_amount":"1842.64","room_type_id":"303","product_id":"1140","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":"78851","customer_id":"78851","source_of_creation":"PMS","reservation_created_date":"2018-12-22 16:57:22","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"77.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2899000","reservation_id":"62180","confirmation_number":"PBR12284720664","room_confirmation_number":"BV12473343889","room_stay_from":"2018-12-28","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"77987","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77987","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2905269","reservation_id":"60962","confirmation_number":"PBR12211525968","room_confirmation_number":"BV12419724510","room_stay_from":"2018-12-26","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"77310","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"77310","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2905787","reservation_id":"64401","confirmation_number":"BV12225992547","room_confirmation_number":"BV12422423321","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"79005","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-27 17:23:39","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79005","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2906320","reservation_id":"64383","confirmation_number":"BV12269205794","room_confirmation_number":"BV12480014270","room_stay_from":"2018-12-30","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"78993","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-27 04:24:14","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78993","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907753","reservation_id":"64007","confirmation_number":"BV12227949661","room_confirmation_number":"BV12492125215","room_stay_from":"2018-12-31","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"78853","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-22 18:25:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78853","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2908770","reservation_id":"64669","confirmation_number":"BV12281041751","room_confirmation_number":"BV12494305673","room_stay_from":"2019-01-03","room_stay_to":"2019-01-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"79095","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-29 13:41:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79095","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909288","reservation_id":"64526","confirmation_number":"BV12231381743","room_confirmation_number":"BV12444980014","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"36.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"79035","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-28 04:03:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79035","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909291","reservation_id":"65151","confirmation_number":"BV12260506281","room_confirmation_number":"BV12441919729","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"79284","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-02 00:05:28","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79284","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909351","reservation_id":"65033","confirmation_number":"BV12232434950","room_confirmation_number":"BV12493382396","room_stay_from":"2019-01-03","room_stay_to":"2019-01-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79224","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-01 05:36:15","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79224","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2909466","reservation_id":"65187","confirmation_number":"BV12267898543","room_confirmation_number":"BV12423957971","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"79312","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-02 14:16:11","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79312","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910193","reservation_id":"65352","confirmation_number":"BV12269337749","room_confirmation_number":"BV12444297515","room_stay_from":"2019-01-03","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"79387","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-03 18:47:10","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79387","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2926684","reservation_id":"63996","confirmation_number":"BV12214529070","room_confirmation_number":"BV12497687505","room_stay_from":"2019-01-03","room_stay_to":"2019-01-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.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","subtotal":"252.00","grand_total":"284.76","paid_amount":"284.76","product_id":"1781","service_quantity":"1","customer_traveller_id":"78851","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-22 16:57:22","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78851","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2910295","reservation_id":"65383","confirmation_number":"BV12268674477","room_confirmation_number":"BV12434169540","room_stay_from":"2019-01-24","room_stay_to":"2019-01-27","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"75.00","grand_total":"84.75","paid_amount":"84.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-03 21:44:47","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"79402","parentCustTravId":"79402","customer_traveller_id":"79402","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":4,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"2907592","reservation_id":"64252","confirmation_number":"BP12571058895","room_stay_from":"2018-12-29","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"139.33,101.55,101.55,101.55,69.72,69.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00,6.00,0.00","subtotal":"583.42","grand_total":"652.48","paid_amount":"652.48","room_type_id":"294","product_id":"1127","siteminder_id":"EXP-1168478120","collect_which":"channel_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":"78938","customer_id":"78938","source_of_creation":"Expedia","reservation_created_date":"2018-12-25 21:35:09","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"69.72","currentDayDiscount":"6.00","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2908317","reservation_id":"64941","confirmation_number":"BP12554149004","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.09,88.86","nightly_discount":"0,0","subtotal":"159.95","grand_total":"180.75","paid_amount":"180.75","room_type_id":"299","product_id":"1134","siteminder_id":"EXP-1171357460","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":"79198","customer_id":"79198","source_of_creation":"Expedia","reservation_created_date":"2018-12-31 17:30:08","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.09","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910262","reservation_id":"65374","confirmation_number":"BP12563230221","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.98,105.21","nightly_discount":"0,0","subtotal":"195.19","grand_total":"220.56","paid_amount":"220.56","room_type_id":"301","product_id":"1137","siteminder_id":"EXP-1173026672","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":"79395","customer_id":"79395","source_of_creation":"Expedia","reservation_created_date":"2019-01-03 20:40:12","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.98","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911332","reservation_id":"62799","confirmation_number":"BP12545263947","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"7","room_stay_child_count":"0","nightly_price":"214.83,214.83,239.16","nightly_discount":"0,0,0","subtotal":"668.82","grand_total":"755.77","paid_amount":"755.77","room_type_id":"302","product_id":"1138","siteminder_id":"EXP-1159606904","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":"78399","customer_id":"78399","source_of_creation":"Expedia","reservation_created_date":"2018-12-06 17:00:08","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"214.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"2908230","reservation_id":"64924","confirmation_number":"BP12539363872","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.39,48.39,48.39","nightly_discount":"0,0,0","subtotal":"145.17","grand_total":"164.04","paid_amount":"164.04","room_type_id":"293","product_id":"1124","siteminder_id":"HTN-72270142","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":"79466","customer_id":"79466","source_of_creation":"HotelTonight","reservation_created_date":"2018-12-31 13:28:12","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.39","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[{"room_stay_id":"2904581","reservation_id":"64219","confirmation_number":"BP12528018606","room_stay_from":"2018-12-31","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.00,86.00,59.04,59.04","nightly_discount":"0,0,0,0","subtotal":"290.08","grand_total":"327.79","paid_amount":"327.80","room_type_id":"294","product_id":"1125","siteminder_id":"PCL-33012143","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":"72665","customer_id":"72665","source_of_creation":"Priceline.com","reservation_created_date":"2018-12-25 18:02:09","canceled_nights_data":"","product_name":"BP One Bedroom Suite 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"59.04","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"2948410","reservation_id":"63672","confirmation_number":"BP12553313851","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"56.67,56.67,71.81","nightly_discount":"0.00,0.00,0.00","subtotal":"185.15","grand_total":"209.22","paid_amount":"209.22","room_type_id":"298","product_id":"1133","siteminder_id":"PCL-32962763","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":"78663","customer_id":"78663","source_of_creation":"Priceline.com","reservation_created_date":"2018-12-17 20:22:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"56.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"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":"2908885","reservation_id":"65060","confirmation_number":"BP12541804584","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.80,168.80","nightly_discount":"0.00,0.00","subtotal":"337.60","grand_total":"381.49","paid_amount":"381.49","room_type_id":"297","product_id":"1132","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":"79242","customer_id":"79242","source_of_creation":"FE","reservation_created_date":"2019-01-01 16:45:46","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"168.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2908510","reservation_id":"64972","confirmation_number":"BP12514441935","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.00,80.80,80.80","nightly_discount":"0.00,0.00,0.00","subtotal":"272.60","grand_total":"308.04","paid_amount":"308.04","room_type_id":"295","product_id":"1128","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":"42153","customer_id":"42153","source_of_creation":"PMS","reservation_created_date":"2018-12-31 20:59:07","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"80.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911510","reservation_id":"64676","confirmation_number":"BP12528088497","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"73.60,84.00,84.00,81.60,81.60,81.60,81.60","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"568.00","grand_total":"641.84","paid_amount":"641.84","room_type_id":"295","product_id":"1129","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":"79102","customer_id":"79102","source_of_creation":"PMS","reservation_created_date":"2018-12-29 15:08:33","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2904582","reservation_id":"64219","confirmation_number":"BP12298644065","room_confirmation_number":"BP12528018606","room_stay_from":"2018-12-31","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"78929","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-25 18:02:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72665","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2907593","reservation_id":"64252","confirmation_number":"BP12268535110","room_confirmation_number":"BP12571058895","room_stay_from":"2018-12-29","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"78938","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-25 21:35:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78938","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"2908231","reservation_id":"64924","confirmation_number":"BP12263810557","room_confirmation_number":"BP12539363872","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79466","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-31 13:28:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79466","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2908318","reservation_id":"64941","confirmation_number":"BP12278326190","room_confirmation_number":"BP12554149004","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"79198","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2018-12-31 17:30:08","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79198","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2908511","reservation_id":"64972","confirmation_number":"BP12248984309","room_confirmation_number":"BP12514441935","room_stay_from":"2019-01-01","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"42153","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-31 20:59:07","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42153","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2908886","reservation_id":"65060","confirmation_number":"BP12292304192","room_confirmation_number":"BP12541804584","room_stay_from":"2019-01-02","room_stay_to":"2019-01-04","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"79242","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-01 16:45:46","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79242","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2910263","reservation_id":"65374","confirmation_number":"BP12261571530","room_confirmation_number":"BP12563230221","room_stay_from":"2019-01-03","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"79395","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-01-03 20:40:12","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79395","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2911511","reservation_id":"64676","confirmation_number":"BP12288954208","room_confirmation_number":"BP12528088497","room_stay_from":"2019-01-03","room_stay_to":"2019-01-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"79102","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-29 15:08:33","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79102","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2912801","reservation_id":"62799","confirmation_number":"PBR12266548520","room_confirmation_number":"BP12545263947","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"78399","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78399","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2948411","reservation_id":"63672","confirmation_number":"PBR12271851677","room_confirmation_number":"BP12553313851","room_stay_from":"2019-01-02","room_stay_to":"2019-01-05","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"78663","product_attribute_values":"resort_fee#&#flat_rate#&#20.00","reservation_created_date":"0000-00-00 00:00:00","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78663","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2910131","reservation_id":"62787","confirmation_number":"BP12254343745","room_confirmation_number":"BP12585818875","room_stay_from":"2019-01-12","room_stay_to":"2019-01-19","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"175.00","grand_total":"197.75","paid_amount":"197.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-01-03 15:03:11","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"78392","parentCustTravId":"78392","customer_traveller_id":"78392","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}