{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-05","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,1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":32,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1110,1113,1140,1137","block_room_bookings":[{"confirmation_number":"PB12242496565","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"PB12216272823","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"BV12294744143","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"BP12236820689","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3045362","reservation_id":"84676","confirmation_number":"PB12367644966","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"151.75,164.75,164.75,151.75","nightly_discount":"0,0,0,0","subtotal":"633.00","grand_total":"715.29","paid_amount":"715.29","room_type_id":"289","product_id":"1093","siteminder_id":"BDC-2164594727","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92005","customer_id":"92005","source_of_creation":"Booking.com","reservation_created_date":"2019-09-25 13:40:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"118.96","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"151.75","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":"3050609","reservation_id":"88710","confirmation_number":"PB12327436860","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.04,121.94","nightly_discount":"0,0","subtotal":"252.98","grand_total":"285.87","paid_amount":"285.87","room_type_id":"286","product_id":"1086","siteminder_id":"BDC-2551250940","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":"94874","customer_id":"94874","source_of_creation":"Booking.com","reservation_created_date":"2019-12-26 04:08:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"37.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"121.94","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":"3051136","reservation_id":"88794","confirmation_number":"BP12547874835","room_stay_from":"2020-01-01","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"111.12,111.12,119.57,119.57,111.12","nightly_discount":"0,0,0,0,0","subtotal":"572.50","grand_total":"646.93","paid_amount":"646.93","room_type_id":"296","product_id":"1131","siteminder_id":"BDC-3010013558","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":"94942","customer_id":"94942","source_of_creation":"Booking.com","reservation_created_date":"2019-12-27 19:44:08","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"103.05","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.12","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":"3053849","reservation_id":"88543","confirmation_number":"PB12316811294","room_stay_from":"2020-01-03","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"126.4,126.4,126.4","nightly_discount":"0,0,0","subtotal":"379.20","grand_total":"428.49","paid_amount":"428.49","room_type_id":"288","product_id":"1092","siteminder_id":"BDC-2237194899","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94742","customer_id":"94742","source_of_creation":"Booking.com","reservation_created_date":"2019-12-22 05:32:11","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"40.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.4","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":"3053918","reservation_id":"89303","confirmation_number":"PB12381917794","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.75","nightly_discount":"0","subtotal":"109.75","grand_total":"124.02","paid_amount":"124.02","room_type_id":"291","product_id":"1117","siteminder_id":"BDC-3220432550","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":"95305","customer_id":"95305","source_of_creation":"Booking.com","reservation_created_date":"2020-01-04 05:13:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"16.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"109.75","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":"3054652","reservation_id":"89382","confirmation_number":"BP12524841863","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"67.45","nightly_discount":"0.00","subtotal":"67.45","grand_total":"76.22","paid_amount":"76.22","room_type_id":"289","product_id":"1098","siteminder_id":"BDC-3992485786","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95362","customer_id":"95362","source_of_creation":"Booking.com","reservation_created_date":"2020-01-05 06:12:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"15.74","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.45","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":"3054109","reservation_id":"89325","confirmation_number":"BV12478857729","room_stay_from":"2020-01-04","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"93.75,89.13,89.13","nightly_discount":"0,0,0","subtotal":"272.01","grand_total":"307.37","paid_amount":"307.37","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-3276577618","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95325","customer_id":"95325","source_of_creation":"Booking.com","reservation_created_date":"2020-01-04 20:17:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"27.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.13","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":"3042913","reservation_id":"87658","confirmation_number":"PB12321592123","room_stay_from":"2020-01-01","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.80,160.80,172.80,172.80,160.80,160.80,160.80,160.80,160.80","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"1471.20","grand_total":"1662.45","paid_amount":"1662.45","room_type_id":"291","product_id":"1114","siteminder_id":"BDC-3400601347","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":"95729","customer_id":"95729","source_of_creation":"Booking.com","reservation_created_date":"2019-11-30 02:46:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"110.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.80","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3033009","reservation_id":"86210","confirmation_number":"PB12370933584","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.78,180.37,180.37,170.78","nightly_discount":"0,0,0,0","subtotal":"702.30","grand_total":"793.60","paid_amount":"793.60","room_type_id":"287","product_id":"1089","siteminder_id":"EXP-1368418889","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":"93044","customer_id":"93044","source_of_creation":"Expedia","reservation_created_date":"2019-10-25 14:51:06","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"170.78","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":"3049430","reservation_id":"88540","confirmation_number":"PB12343216196","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"85.86,92.1,92.1,85.86","nightly_discount":"0,0,0,0","subtotal":"355.92","grand_total":"402.19","paid_amount":"402.19","room_type_id":"291","product_id":"1115","siteminder_id":"EXP-1611010056","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94739","customer_id":"94739","source_of_creation":"Expedia","reservation_created_date":"2019-12-22 04:02:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.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"}]},{"room_stay_id":"3052615","reservation_id":"87866","confirmation_number":"PB12317891166","room_stay_from":"2020-01-01","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"117.33,117.33,126.92,126.92,117.33","nightly_discount":"0.00,0.00,0.00,0.00,5.31,0.00","subtotal":"605.83","grand_total":"678.59","paid_amount":"678.59","room_type_id":"289","product_id":"1102","siteminder_id":"EXP-1388236887","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94300","customer_id":"94300","source_of_creation":"Expedia","reservation_created_date":"2019-12-05 03:33:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.33","currentDayDiscount":"5.31","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":"3053390","reservation_id":"89214","confirmation_number":"PB12324922027","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.06,106.92","nightly_discount":"0,0","subtotal":"253.98","grand_total":"287.00","paid_amount":"287.00","room_type_id":"289","product_id":"1108","siteminder_id":"EXP-1616626571","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":"95242","customer_id":"95242","source_of_creation":"Expedia","reservation_created_date":"2020-01-03 12:27:06","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":"106.92","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":"3053608","reservation_id":"89246","confirmation_number":"PB12327133504","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.68","nightly_discount":"0","subtotal":"87.68","grand_total":"99.08","paid_amount":"99.08","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1616813765","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":"95272","customer_id":"95272","source_of_creation":"Expedia","reservation_created_date":"2020-01-03 19:37:09","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":"87.68","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":"3053610","reservation_id":"89247","confirmation_number":"PB12362342401","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.68","nightly_discount":"0","subtotal":"87.68","grand_total":"99.08","paid_amount":"99.08","room_type_id":"285","product_id":"1084","siteminder_id":"EXP-1616813763","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":"95273","customer_id":"95273","source_of_creation":"Expedia","reservation_created_date":"2020-01-03 19:37: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":"87.68","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":"3045349","reservation_id":"87135","confirmation_number":"PB12339042989","room_stay_from":"2019-12-31","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.58,141.00,141.00,153.00,153.00,141.00,141.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1010.58","grand_total":"1141.95","paid_amount":"1141.95","room_type_id":"289","product_id":"1097","siteminder_id":"EXP-1380423636","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":"95474","customer_id":"95474","source_of_creation":"Expedia","reservation_created_date":"2019-11-14 17:23:07","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":"141.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":"3050833","reservation_id":"88736","confirmation_number":"PB12319362665","room_stay_from":"2020-01-03","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.24,117.24,111.00,111.00","nightly_discount":"0,0,0,0","subtotal":"456.48","grand_total":"515.82","paid_amount":"515.82","room_type_id":"287","product_id":"1087","siteminder_id":"EXP-1612888050","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":"95475","customer_id":"95475","source_of_creation":"Expedia","reservation_created_date":"2019-12-26 21:57:09","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":"111.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":"3046149","reservation_id":"88170","confirmation_number":"BP12533348084","room_stay_from":"2019-12-29","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"97.09,97.09,97.09,97.38,97.38,106.97,106.97,97.38,97.38,97.38,97.38,97.38","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1186.87","grand_total":"1341.16","paid_amount":"1341.16","room_type_id":"299","product_id":"1134","siteminder_id":"EXP-1389938151","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":"94493","customer_id":"94493","source_of_creation":"Expedia","reservation_created_date":"2019-12-11 19:32:10","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":"97.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3052901","reservation_id":"88705","confirmation_number":"BP12549120773","room_stay_from":"2019-12-31","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"104.05,67.80,67.80,73.55,73.55,67.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"454.55","grand_total":"513.64","paid_amount":"513.64","room_type_id":"294","product_id":"1127","siteminder_id":"GAM-R1802946733","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94869","customer_id":"94869","source_of_creation":"Getaroom.com","reservation_created_date":"2019-12-25 22:12:05","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":"67.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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3054816","reservation_id":"88609","confirmation_number":"BV12454480731","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.27","nightly_discount":"0","subtotal":"88.27","grand_total":"115.17","paid_amount":"115.17","room_type_id":"309","product_id":"1226","siteminder_id":"ABB-HMJ9BRDR5M","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"88.27","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94800","customer_id":"94800","source_of_creation":"Airbnb","reservation_created_date":"2019-12-23 18:29:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"12.34","commision_charges":"2.73","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.27","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3054200","reservation_id":"89347","confirmation_number":"BP12532619848","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.21,60.21","nightly_discount":"0,0","subtotal":"120.42","grand_total":"136.08","paid_amount":"136.08","room_type_id":"295","product_id":"1128","siteminder_id":"HWR-301557287","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":"95334","customer_id":"95334","source_of_creation":"Hotwire","reservation_created_date":"2020-01-04 23:13:10","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":"60.21","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"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3052926","reservation_id":"89117","confirmation_number":"PB12334692075","room_stay_from":"2020-01-04","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.59,74.18,74.18,74.18","nightly_discount":"0,0,0,0","subtotal":"317.13","grand_total":"358.36","paid_amount":"358.36","room_type_id":"289","product_id":"1106","siteminder_id":"AGO-300393654","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":"95171","customer_id":"95171","source_of_creation":"Agoda","reservation_created_date":"2020-01-02 14:46:05","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":"74.18","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":"3053269","reservation_id":"88810","confirmation_number":"PB12393342058","room_stay_from":"2020-01-02","room_stay_to":"2020-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"97.57,104.16,94.73,88.75,88.75,88.75,88.75","nightly_discount":"0.00,0,0,0,0,0,0","subtotal":"651.46","grand_total":"736.15","paid_amount":"736.15","room_type_id":"288","product_id":"1091","siteminder_id":"AGO-262687235","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94955","customer_id":"94955","source_of_creation":"Agoda","reservation_created_date":"2019-12-27 23:33:08","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.75","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":"3054400","reservation_id":"89250","confirmation_number":"BV12481004762","room_stay_from":"2020-01-05","room_stay_to":"2020-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.51,67.51,67.51,67.51","nightly_discount":"0,0,0,0","subtotal":"270.04","grand_total":"305.14","paid_amount":"305.14","room_type_id":"295","product_id":"1129","siteminder_id":"AGO-300678142","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":"95274","customer_id":"95274","source_of_creation":"Agoda","reservation_created_date":"2020-01-03 20:03:07","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":"67.51","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"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3050288","reservation_id":"88694","confirmation_number":"PB12376970751","room_stay_from":"2020-01-03","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.70,115.70,102.70","nightly_discount":"0.00,0.00,0.00","subtotal":"334.10","grand_total":"377.54","paid_amount":"377.54","room_type_id":"291","product_id":"1116","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":"94860","customer_id":"94860","source_of_creation":"FE","reservation_created_date":"2019-12-25 18:51:06","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":"102.70","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":"3052247","reservation_id":"88999","confirmation_number":"PB12389209011","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.24,97.50","nightly_discount":"0.00,0.00","subtotal":"215.74","grand_total":"243.78","paid_amount":"243.78","room_type_id":"289","product_id":"1101","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":"95081","customer_id":"95081","source_of_creation":"FE","reservation_created_date":"2019-12-31 04:58:29","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":"97.50","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":"3052870","reservation_id":"89106","confirmation_number":"BP12568649531","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"6","room_stay_child_count":"2","nightly_price":"130.75,109.20","nightly_discount":"0.00,0.00","subtotal":"239.95","grand_total":"271.15","paid_amount":"271.15","room_type_id":"302","product_id":"1138","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":"95161","customer_id":"95161","source_of_creation":"FE","reservation_created_date":"2020-01-02 02:09:00","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":"109.20","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":"3040449","reservation_id":"87408","confirmation_number":"BV12477052062","room_stay_from":"2020-01-02","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,160.00,160.00,140.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"740.00","grand_total":"836.20","paid_amount":"836.20","room_type_id":"308","product_id":"1225","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":"93953","customer_id":"93953","source_of_creation":"FE","reservation_created_date":"2019-11-22 14:22:40","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":"140.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":"3047664","reservation_id":"88374","confirmation_number":"PB12352472678","room_stay_from":"2020-01-03","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.00,230.00,210.00,210.00,210.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1090.00","grand_total":"1231.70","paid_amount":"1231.70","room_type_id":"287","product_id":"1088","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":"56275","customer_id":"56275","source_of_creation":"FE","reservation_created_date":"2019-12-16 02:40:12","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":"210.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":"3052423","reservation_id":"87816","confirmation_number":"BV12474454075","room_stay_from":"2019-12-31","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,150.00,170.00,170.00,150.00,150.00,150.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,124.00,0.00","subtotal":"1240.00","grand_total":"1261.08","paid_amount":"1261.08","room_type_id":"306","product_id":"1223","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":"64584","customer_id":"64584","source_of_creation":"FE","reservation_created_date":"2019-12-03 18:57:43","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":"150.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":"3053287","reservation_id":"89191","confirmation_number":"BP12515954709","room_stay_from":"2020-01-05","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00","subtotal":"234.00","grand_total":"264.42","paid_amount":"264.42","room_type_id":"298","product_id":"1133","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":"47798","customer_id":"47798","source_of_creation":"FE","reservation_created_date":"2020-01-03 01:50:11","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":"78.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3053467","reservation_id":"87624","confirmation_number":"PB12335558521","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"139.00,159.00,159.00,139.00","nightly_discount":"0.00,27.30,0.00,0.00","subtotal":"596.00","grand_total":"642.63","paid_amount":"642.63","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":"94118","customer_id":"94118","source_of_creation":"PMS","reservation_created_date":"2019-11-29 13:52:03","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":"139.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":"3054463","reservation_id":"89398","confirmation_number":"BV12456561834","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.00","nightly_discount":"0.00","subtotal":"76.00","grand_total":"85.88","paid_amount":"85.88","room_type_id":"307","product_id":"1224","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":"95378","customer_id":"95378","source_of_creation":"PMS","reservation_created_date":"2020-01-05 18:38:19","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":"76.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":"3035135","reservation_id":"82525","confirmation_number":"PB12321339963","room_stay_from":"2019-12-28","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.00,148.00,128.00,128.00,128.00,128.00,128.00,148.00,148.00,128.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1360.00","grand_total":"1536.80","paid_amount":"1536.80","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":"42610","customer_id":"42610","source_of_creation":"PMS","reservation_created_date":"2019-08-12 17:26:44","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"148.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":"3052311","reservation_id":"89010","confirmation_number":"BP12525856960","room_stay_from":"2020-01-01","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.38,141.38,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"762.76","grand_total":"861.92","paid_amount":"861.92","room_type_id":"296","product_id":"1130","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":"95089","customer_id":"95089","source_of_creation":"PMS","reservation_created_date":"2019-12-31 15:16:06","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.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":"3053714","reservation_id":"88417","confirmation_number":"PB12341287413","room_stay_from":"2020-01-03","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,159.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00,21.85,0.00","subtotal":"596.00","grand_total":"648.79","paid_amount":"648.79","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":"37586","customer_id":"37586","source_of_creation":"PMS","reservation_created_date":"2019-12-17 15:59:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.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":"3042716","reservation_id":"87641","confirmation_number":"PB12332218098","room_stay_from":"2020-01-01","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"128.00,128.00,148.00,148.00,128.00,128.00,128.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"936.00","grand_total":"1057.68","paid_amount":"1057.68","room_type_id":"289","product_id":"1103","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":"94130","customer_id":"94130","source_of_creation":"PMS","reservation_created_date":"2019-11-29 21:59:02","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.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":"3042719","reservation_id":"87642","confirmation_number":"PB12354974012","room_stay_from":"2020-01-01","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.00,128.00,148.00,148.00,128.00,128.00,128.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"936.00","grand_total":"1057.68","paid_amount":"1057.68","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":"94130","customer_id":"94130","source_of_creation":"PMS","reservation_created_date":"2019-11-29 22:00:29","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":"128.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":"3055019","reservation_id":"89413","confirmation_number":"PB12322562886","room_stay_from":"2020-01-05","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.50,97.50,97.50","nightly_discount":"0.00,0.00,0.00","subtotal":"292.50","grand_total":"330.53","paid_amount":"330.53","room_type_id":"289","product_id":"1123","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":"95387","customer_id":"95387","source_of_creation":"PMS","reservation_created_date":"2020-01-05 21:08:43","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":"97.50","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":"3055400","reservation_id":"89239","confirmation_number":"BV12495948078","room_stay_from":"2020-01-04","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.92,91.00,91.00,91.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"377.92","grand_total":"427.05","paid_amount":"413.49","room_type_id":"304","product_id":"1219","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":"95262","customer_id":"95262","source_of_creation":"PMS","reservation_created_date":"2020-01-03 18:32:14","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":"91.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":"3053580","reservation_id":"88468","confirmation_number":"PB12333773046","room_stay_from":"2020-01-03","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,32.74,0.00","subtotal":"623.00","grand_total":"667.00","paid_amount":"667.00","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":"91746","customer_id":"91746","source_of_creation":"PMS","reservation_created_date":"2019-12-19 15:30:12","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":"89.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":"3054383","reservation_id":"84534","confirmation_number":"PB12353322634","room_stay_from":"2020-01-05","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00,119.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"754.00","grand_total":"852.02","paid_amount":"852.02","room_type_id":"289","product_id":"1099","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":"76330","customer_id":"76330","source_of_creation":"PMS","reservation_created_date":"2020-01-05 13:16:32","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","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":"3050155","reservation_id":"67055","confirmation_number":"PB12350136682","room_stay_from":"2019-12-24","room_stay_to":"2020-01-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.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.35,137.00,0.00,0.00,0.00","subtotal":"2877.00","grand_total":"3095.81","paid_amount":"3095.81","room_type_id":"287","product_id":"1090","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":"69129","customer_id":"69129","source_of_creation":"PMS","reservation_created_date":"2019-01-17 01:59:48","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":"137.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":"3054406","reservation_id":"83768","confirmation_number":"PB12384571715","room_stay_from":"2020-01-02","room_stay_to":"2020-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.80,83.90,83.90","nightly_discount":"0.00,0.00,0.00","subtotal":"237.60","grand_total":"268.49","paid_amount":"268.49","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":"91118","customer_id":"91118","source_of_creation":"PMS","reservation_created_date":"2019-09-08 02:09:53","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":"","changedComment":"Nightly price or discount changed","deltaChange":"237.60","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"}]},{"room_stay_id":"3054381","reservation_id":"84534","confirmation_number":"PB12344255396","room_stay_from":"2020-01-03","room_stay_to":"2020-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,119.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"290","product_id":"1113","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":"76330","customer_id":"76330","source_of_creation":"PMS","reservation_created_date":"2019-09-22 14:52:56","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]},{"room_stay_id":"3054408","reservation_id":"82641","confirmation_number":"PB12399761909","room_stay_from":"2020-01-03","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"98.00","nightly_discount":"0.00","subtotal":"98.00","grand_total":"110.74","paid_amount":"110.74","room_type_id":"291","product_id":"1117","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":"90223","customer_id":"90223","source_of_creation":"PMS","reservation_created_date":"2019-08-14 22:27:46","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":"","changedComment":"Nightly price or discount changed","deltaChange":"98.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"}]},{"room_stay_id":"3054540","reservation_id":"89274","confirmation_number":"PB12319353963","room_stay_from":"2020-01-06","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.10,91.10","nightly_discount":"0.00,0.00","subtotal":"182.20","grand_total":"205.88","paid_amount":"205.88","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":"85581","customer_id":"85581","source_of_creation":"PMS","reservation_created_date":"2020-01-03 23:51:46","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":"","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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3045363","reservation_id":"84676","confirmation_number":"PB12249371678","room_confirmation_number":"PB12367644966","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"40,40,40,40","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"92005","product_attribute_values":"extra_person# ","reservation_created_date":"2019-12-08 00:19:16","reservation_modified_date_time":"2019-12-08 00:19:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92005","canceled_nights_data":"","currentDayPrice":"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":"3045366","reservation_id":"87866","confirmation_number":"PB12240468968","room_confirmation_number":"PB12317891166","room_stay_from":"2020-01-01","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0,0,0,0,0","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"94300","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-12-08 00:19:32","reservation_modified_date_time":"2019-12-08 00:19:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94300","canceled_nights_data":"","currentDayPrice":"20","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":"3047022","reservation_id":"87624","confirmation_number":"PB12243679477","room_confirmation_number":"PB12335558521","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"94118","product_attribute_values":"extra_person# ","reservation_created_date":"2019-12-14 20:18:15","reservation_modified_date_time":"2019-12-14 20:18:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94118","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":"3049431","reservation_id":"88540","confirmation_number":"PB12245580987","room_confirmation_number":"PB12343216196","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"94739","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-12-22 04:02:09","reservation_modified_date_time":"2019-12-22 04:02:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94739","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":"3052872","reservation_id":"89106","confirmation_number":"BP12296849526","room_confirmation_number":"BP12568649531","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"60.00,60.00","nightly_discount":"0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"95161","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-01-02 02:09:00","reservation_modified_date_time":"2020-01-02 02:09:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95161","canceled_nights_data":"","currentDayPrice":"60.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":"3053850","reservation_id":"88543","confirmation_number":"PB12294092743","room_confirmation_number":"PB12316811294","room_stay_from":"2020-01-03","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0,0,0","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"94742","product_attribute_values":"extra_person# ","reservation_created_date":"2020-01-04 04:03:26","reservation_modified_date_time":"2020-01-04 04:03:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94742","canceled_nights_data":"","currentDayPrice":"10","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":"3054649","reservation_id":"89382","confirmation_number":"BP12238906709","room_confirmation_number":"BP12524841863","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"95362","product_attribute_values":"extra_person# ","reservation_created_date":"2020-01-06 00:50:37","reservation_modified_date_time":"2020-01-06 00:50:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95362","canceled_nights_data":"","currentDayPrice":"20","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":"3054110","reservation_id":"89325","confirmation_number":"BV12243586536","room_confirmation_number":"BV12478857729","room_stay_from":"2020-01-04","room_stay_to":"2020-01-07","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0,0,0","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"95325","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-01-04 20:17:12","reservation_modified_date_time":"2020-01-04 20:17:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95325","canceled_nights_data":"","currentDayPrice":"10","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":"3042717","reservation_id":"87641","confirmation_number":"PB12264073977","room_confirmation_number":"PB12332218098","room_stay_from":"2020-01-01","room_stay_to":"2020-01-08","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00,10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"94130","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-11-29 21:59:02","reservation_modified_date_time":"2019-11-29 21:59:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94130","canceled_nights_data":"","currentDayPrice":"10.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":"3053270","reservation_id":"88810","confirmation_number":"PB12268535142","room_confirmation_number":"PB12393342058","room_stay_from":"2020-01-02","room_stay_to":"2020-01-09","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"94955","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-12-27 23:33:08","reservation_modified_date_time":"2020-01-03 01:17:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94955","canceled_nights_data":"","currentDayPrice":"0.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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3033010","reservation_id":"86210","confirmation_number":"PB12244068608","room_confirmation_number":"PB12370933584","room_stay_from":"2020-01-02","room_stay_to":"2020-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":"93044","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-10-25 14:51:06","reservation_modified_date_time":"2019-10-25 14:51:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93044","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":"3045364","reservation_id":"84676","confirmation_number":"PB12239312958","room_confirmation_number":"PB12367644966","room_stay_from":"2020-01-02","room_stay_to":"2020-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":"92005","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-25 13:40:10","reservation_modified_date_time":"2019-09-25 13:40:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92005","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":"3049432","reservation_id":"88540","confirmation_number":"PB12274570061","room_confirmation_number":"PB12343216196","room_stay_from":"2020-01-02","room_stay_to":"2020-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":"94739","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-22 04:02:09","reservation_modified_date_time":"2019-12-22 04:02:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94739","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":"3050289","reservation_id":"88694","confirmation_number":"PB12244325030","room_confirmation_number":"PB12376970751","room_stay_from":"2020-01-03","room_stay_to":"2020-01-06","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":"94860","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-25 18:51:06","reservation_modified_date_time":"2019-12-25 18:51:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94860","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":"3050610","reservation_id":"88710","confirmation_number":"PB12225923812","room_confirmation_number":"PB12327436860","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","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":"94874","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-26 04:08:09","reservation_modified_date_time":"2019-12-26 04:08:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94874","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":"3051137","reservation_id":"88794","confirmation_number":"BP12224643760","room_confirmation_number":"BP12547874835","room_stay_from":"2020-01-01","room_stay_to":"2020-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":"94942","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-27 19:44:08","reservation_modified_date_time":"2019-12-27 19:44:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94942","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":"3052248","reservation_id":"88999","confirmation_number":"PB12241058565","room_confirmation_number":"PB12389209011","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","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":"95081","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-31 04:58:29","reservation_modified_date_time":"2019-12-31 04:58:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95081","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":"3052616","reservation_id":"87866","confirmation_number":"PB12225453532","room_confirmation_number":"PB12317891166","room_stay_from":"2020-01-01","room_stay_to":"2020-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":"94300","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-05 03:33:07","reservation_modified_date_time":"2020-01-01 18:32:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94300","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":"3052871","reservation_id":"89106","confirmation_number":"BP12225492016","room_confirmation_number":"BP12568649531","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","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":"95161","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-01-02 02:09:00","reservation_modified_date_time":"2020-01-02 02:09:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95161","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":"3052903","reservation_id":"88705","confirmation_number":"BP12211820015","room_confirmation_number":"BP12549120773","room_stay_from":"2019-12-31","room_stay_to":"2020-01-06","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":"94869","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-25 22:12:05","reservation_modified_date_time":"2020-01-02 03:16:18","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94869","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":"3053391","reservation_id":"89214","confirmation_number":"PB12228197311","room_confirmation_number":"PB12324922027","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","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":"95242","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-03 12:27:06","reservation_modified_date_time":"2020-01-03 12:27:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95242","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":"3053468","reservation_id":"87624","confirmation_number":"PB12219689881","room_confirmation_number":"PB12335558521","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"94118","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-11-29 13:52:03","reservation_modified_date_time":"2020-01-03 15:31:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94118","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":"3053609","reservation_id":"89246","confirmation_number":"PB12232649451","room_confirmation_number":"PB12327133504","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","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":"95272","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-03 19:37:09","reservation_modified_date_time":"2020-01-03 19:37:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95272","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":"3053611","reservation_id":"89247","confirmation_number":"PB12251912551","room_confirmation_number":"PB12362342401","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","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":"95273","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-03 19:37:12","reservation_modified_date_time":"2020-01-03 19:37:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95273","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":"3053851","reservation_id":"88543","confirmation_number":"PB12222990442","room_confirmation_number":"PB12316811294","room_stay_from":"2020-01-03","room_stay_to":"2020-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":"94742","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-22 05:32:11","reservation_modified_date_time":"2019-12-22 05:32:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94742","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":"3053919","reservation_id":"89303","confirmation_number":"PB12289431869","room_confirmation_number":"PB12381917794","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","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":"95305","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-04 05:13:12","reservation_modified_date_time":"2020-01-04 05:13:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95305","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":"3054201","reservation_id":"89347","confirmation_number":"BP12229313712","room_confirmation_number":"BP12532619848","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","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":"95334","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-04 23:13:10","reservation_modified_date_time":"2020-01-04 23:13:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95334","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":"3054464","reservation_id":"89398","confirmation_number":"BV12285086618","room_confirmation_number":"BV12456561834","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","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":"95378","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-01-05 18:38:19","reservation_modified_date_time":"2020-01-05 18:38:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95378","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":"3054653","reservation_id":"89382","confirmation_number":"BP12289261940","room_confirmation_number":"BP12524841863","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","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":"95362","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-05 06:12:10","reservation_modified_date_time":"2020-01-06 00:50:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95362","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":"3054817","reservation_id":"88609","confirmation_number":"BV12223946584","room_confirmation_number":"BV12454480731","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","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":"94800","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-23 18:29:08","reservation_modified_date_time":"2019-12-23 18:29:08","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94800","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3035136","reservation_id":"82525","confirmation_number":"PB12277549916","room_confirmation_number":"PB12321339963","room_stay_from":"2019-12-28","room_stay_to":"2020-01-07","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":"42610","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-12 17:26:44","reservation_modified_date_time":"2019-08-12 17:26:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42610","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":"3040450","reservation_id":"87408","confirmation_number":"BV12251857878","room_confirmation_number":"BV12477052062","room_stay_from":"2020-01-02","room_stay_to":"2020-01-07","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":"93953","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-11-22 14:22:40","reservation_modified_date_time":"2019-11-22 14:22:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93953","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":"3045350","reservation_id":"87135","confirmation_number":"PB12211030055","room_confirmation_number":"PB12339042989","room_stay_from":"2019-12-31","room_stay_to":"2020-01-07","room_stay_status":"Active","nightly_price":"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","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"95474","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-14 17:23:07","reservation_modified_date_time":"2019-11-14 17:23:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95474","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":"3050834","reservation_id":"88736","confirmation_number":"PB12215270072","room_confirmation_number":"PB12319362665","room_stay_from":"2020-01-03","room_stay_to":"2020-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":"95475","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-26 21:57:09","reservation_modified_date_time":"2019-12-26 21:57:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95475","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":"3052312","reservation_id":"89010","confirmation_number":"BP12262783264","room_confirmation_number":"BP12525856960","room_stay_from":"2020-01-01","room_stay_to":"2020-01-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0,0,0,0","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"95089","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-31 15:16:06","reservation_modified_date_time":"2019-12-31 15:16:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95089","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":"3053715","reservation_id":"88417","confirmation_number":"PB12289652060","room_confirmation_number":"PB12341287413","room_stay_from":"2020-01-03","room_stay_to":"2020-01-07","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":"37586","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-17 15:59:58","reservation_modified_date_time":"2020-01-03 22:09:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"37586","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":"3054111","reservation_id":"89325","confirmation_number":"BV12283187880","room_confirmation_number":"BV12478857729","room_stay_from":"2020-01-04","room_stay_to":"2020-01-07","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":"95325","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-04 20:17:12","reservation_modified_date_time":"2020-01-04 20:17:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95325","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":"3042718","reservation_id":"87641","confirmation_number":"PB12287904337","room_confirmation_number":"PB12332218098","room_stay_from":"2020-01-01","room_stay_to":"2020-01-08","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":"94130","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-11-29 21:59:02","reservation_modified_date_time":"2019-11-29 21:59:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94130","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":"3042720","reservation_id":"87642","confirmation_number":"PB12217461547","room_confirmation_number":"PB12354974012","room_stay_from":"2020-01-01","room_stay_to":"2020-01-08","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":"94130","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-11-29 22:00:29","reservation_modified_date_time":"2019-11-29 22:00:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94130","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":"3047665","reservation_id":"88374","confirmation_number":"PB12210651626","room_confirmation_number":"PB12352472678","room_stay_from":"2020-01-03","room_stay_to":"2020-01-08","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":"56275","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-16 02:40:12","reservation_modified_date_time":"2019-12-16 02:40:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56275","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":"3052424","reservation_id":"87816","confirmation_number":"BV12234357131","room_confirmation_number":"BV12474454075","room_stay_from":"2019-12-31","room_stay_to":"2020-01-08","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.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"64584","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-03 18:57:43","reservation_modified_date_time":"2019-12-31 20:35:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"64584","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":"3052927","reservation_id":"89117","confirmation_number":"PB12249452394","room_confirmation_number":"PB12334692075","room_stay_from":"2020-01-04","room_stay_to":"2020-01-08","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":"95171","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 14:46:05","reservation_modified_date_time":"2020-01-02 14:46:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95171","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":"3053288","reservation_id":"89191","confirmation_number":"BP12294766989","room_confirmation_number":"BP12515954709","room_stay_from":"2020-01-05","room_stay_to":"2020-01-08","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":"47798","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-01-03 01:50:11","reservation_modified_date_time":"2020-01-03 01:50:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","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":"3055020","reservation_id":"89413","confirmation_number":"PB12250332800","room_confirmation_number":"PB12322562886","room_stay_from":"2020-01-05","room_stay_to":"2020-01-08","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":"95387","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-01-05 21:08:43","reservation_modified_date_time":"2020-01-05 21:08:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95387","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":"3055401","reservation_id":"89239","confirmation_number":"BV12288347082","room_confirmation_number":"BV12495948078","room_stay_from":"2020-01-04","room_stay_to":"2020-01-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95262","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-01-03 18:32:14","reservation_modified_date_time":"2020-01-06 14:33:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95262","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":"3053271","reservation_id":"88810","confirmation_number":"PB12296168841","room_confirmation_number":"PB12393342058","room_stay_from":"2020-01-02","room_stay_to":"2020-01-09","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":"94955","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-27 23:33:08","reservation_modified_date_time":"2020-01-03 01:17:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94955","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":"3054401","reservation_id":"89250","confirmation_number":"BV12277916303","room_confirmation_number":"BV12481004762","room_stay_from":"2020-01-05","room_stay_to":"2020-01-09","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":"95274","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-03 20:03:07","reservation_modified_date_time":"2020-01-03 20:03:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95274","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":"3042914","reservation_id":"87658","confirmation_number":"PB12257724834","room_confirmation_number":"PB12321592123","room_stay_from":"2020-01-01","room_stay_to":"2020-01-10","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,0,0,0,0,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"95729","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-30 02:46:09","reservation_modified_date_time":"2019-11-30 02:46:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95729","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":"3046150","reservation_id":"88170","confirmation_number":"BP12214923305","room_confirmation_number":"BP12533348084","room_stay_from":"2019-12-29","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,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,0.00,0.00,0.00","subtotal":"240.00","grand_total":"271.20","paid_amount":"271.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"94493","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-11 19:32:10","reservation_modified_date_time":"2019-12-11 19:32:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94493","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":"3053581","reservation_id":"88468","confirmation_number":"PB12264607909","room_confirmation_number":"PB12333773046","room_stay_from":"2020-01-03","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"91746","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-19 15:30:12","reservation_modified_date_time":"2020-01-03 18:47:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91746","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":"3054384","reservation_id":"84534","confirmation_number":"PB12248041924","room_confirmation_number":"PB12353322634","room_stay_from":"2020-01-05","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"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","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"76330","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-01-05 13:16:32","reservation_modified_date_time":"2020-01-05 13:16:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76330","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":"3050156","reservation_id":"67055","confirmation_number":"PB12244669360","room_confirmation_number":"PB12350136682","room_stay_from":"2019-12-24","room_stay_to":"2020-01-17","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"69129","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-17 01:59:48","reservation_modified_date_time":"2019-12-24 22:45:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"69129","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":"2936334","reservation_id":"69585","confirmation_number":"BP12214447507","room_confirmation_number":"BP12549690899","room_stay_from":"2020-01-04","room_stay_to":"2020-02-22","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-16 16:13:23","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"46530","parentCustTravId":"46530","customer_traveller_id":"46530","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.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3054375","reservation_id":"87866","confirmation_number":"PB12215782078","room_confirmation_number":"PB12317891166","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"20.00","product_id":"1158","service_quantity":"2","product_name":"Fishing Pole","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-05 12:56:05","reservation_modified_date_time":"2020-01-05 12:56:05","customer_id":"94300","parentCustTravId":"94300","customer_traveller_id":"94300","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3054595","reservation_id":"89398","confirmation_number":"BV12299299526","room_confirmation_number":"BV12456561834","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"15.00","grand_total":"16.95","paid_amount":"16.95","product_id":"1082","service_quantity":"1","product_name":"discounted extra parking pass","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-05 22:35:37","reservation_modified_date_time":"2020-01-05 22:35:37","customer_id":"95378","parentCustTravId":"95378","customer_traveller_id":"95378","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"15.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3054641","reservation_id":"88609","confirmation_number":"BV12219445650","room_confirmation_number":"BV12454480731","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1082","service_quantity":"3","product_name":"upgrade fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-06 00:34:53","reservation_modified_date_time":"2020-01-06 00:34:53","customer_id":"94800","parentCustTravId":"94800","customer_traveller_id":"94800","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3054654","reservation_id":"89382","confirmation_number":"PB12253317742","room_confirmation_number":"BP12524841863","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-06 00:50:47","reservation_modified_date_time":"2020-01-06 00:50:57","customer_id":"95362","parentCustTravId":"95362","customer_traveller_id":"95362","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3054743","reservation_id":"89239","confirmation_number":"BV12214532899","room_confirmation_number":"BV12495948078","room_stay_from":"2020-01-04","room_stay_to":"2020-01-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 18:32:14","reservation_modified_date_time":"2020-01-06 14:33:03","customer_id":"95262","parentCustTravId":"95262","customer_traveller_id":"95262","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":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3053984","reservation_id":"89317","confirmation_number":"PB12226722565","room_confirmation_number":"PB12337874479","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1192","service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-04 17:37:51","reservation_modified_date_time":"2020-01-04 17:37:51","customer_id":"95319","parentCustTravId":"95319","customer_traveller_id":"95319","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-01-05 16:56:55","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-20,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":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":[]},"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":18,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1110,1113","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12242496565","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","bundle_room":"0"},{"confirmation_number":"PB12216272823","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3045362","reservation_id":"84676","confirmation_number":"PB12367644966","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"2","nightly_price":"151.75,164.75,164.75,151.75","nightly_discount":"0,0,0,0","subtotal":"633.00","grand_total":"715.29","paid_amount":"715.29","room_type_id":"289","product_id":"1093","siteminder_id":"BDC-2164594727","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92005","customer_id":"92005","source_of_creation":"Booking.com","reservation_created_date":"2019-09-25 13:40:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"118.96","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"151.75","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":"3050609","reservation_id":"88710","confirmation_number":"PB12327436860","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"131.04,121.94","nightly_discount":"0,0","subtotal":"252.98","grand_total":"285.87","paid_amount":"285.87","room_type_id":"286","product_id":"1086","siteminder_id":"BDC-2551250940","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":"94874","customer_id":"94874","source_of_creation":"Booking.com","reservation_created_date":"2019-12-26 04:08:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"37.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"121.94","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":"3053849","reservation_id":"88543","confirmation_number":"PB12316811294","room_stay_from":"2020-01-03","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"126.4,126.4,126.4","nightly_discount":"0,0,0","subtotal":"379.20","grand_total":"428.49","paid_amount":"428.49","room_type_id":"288","product_id":"1092","siteminder_id":"BDC-2237194899","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94742","customer_id":"94742","source_of_creation":"Booking.com","reservation_created_date":"2019-12-22 05:32:11","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"40.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.4","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":"3053918","reservation_id":"89303","confirmation_number":"PB12381917794","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.75","nightly_discount":"0","subtotal":"109.75","grand_total":"124.02","paid_amount":"124.02","room_type_id":"291","product_id":"1117","siteminder_id":"BDC-3220432550","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":"95305","customer_id":"95305","source_of_creation":"Booking.com","reservation_created_date":"2020-01-04 05:13:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"16.46","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"109.75","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":"3042913","reservation_id":"87658","confirmation_number":"PB12321592123","room_stay_from":"2020-01-01","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.80,160.80,172.80,172.80,160.80,160.80,160.80,160.80,160.80","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"1471.20","grand_total":"1662.45","paid_amount":"1662.45","room_type_id":"291","product_id":"1114","siteminder_id":"BDC-3400601347","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":"95729","customer_id":"95729","source_of_creation":"Booking.com","reservation_created_date":"2019-11-30 02:46:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"110.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"160.80","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3033009","reservation_id":"86210","confirmation_number":"PB12370933584","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.78,180.37,180.37,170.78","nightly_discount":"0,0,0,0","subtotal":"702.30","grand_total":"793.60","paid_amount":"793.60","room_type_id":"287","product_id":"1089","siteminder_id":"EXP-1368418889","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":"93044","customer_id":"93044","source_of_creation":"Expedia","reservation_created_date":"2019-10-25 14:51:06","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"170.78","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":"3049430","reservation_id":"88540","confirmation_number":"PB12343216196","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"85.86,92.1,92.1,85.86","nightly_discount":"0,0,0,0","subtotal":"355.92","grand_total":"402.19","paid_amount":"402.19","room_type_id":"291","product_id":"1115","siteminder_id":"EXP-1611010056","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94739","customer_id":"94739","source_of_creation":"Expedia","reservation_created_date":"2019-12-22 04:02:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.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"}]},{"room_stay_id":"3052615","reservation_id":"87866","confirmation_number":"PB12317891166","room_stay_from":"2020-01-01","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"117.33,117.33,126.92,126.92,117.33","nightly_discount":"0.00,0.00,0.00,0.00,5.31,0.00","subtotal":"605.83","grand_total":"678.59","paid_amount":"678.59","room_type_id":"289","product_id":"1102","siteminder_id":"EXP-1388236887","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94300","customer_id":"94300","source_of_creation":"Expedia","reservation_created_date":"2019-12-05 03:33:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"117.33","currentDayDiscount":"5.31","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":"3053390","reservation_id":"89214","confirmation_number":"PB12324922027","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.06,106.92","nightly_discount":"0,0","subtotal":"253.98","grand_total":"287.00","paid_amount":"287.00","room_type_id":"289","product_id":"1108","siteminder_id":"EXP-1616626571","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":"95242","customer_id":"95242","source_of_creation":"Expedia","reservation_created_date":"2020-01-03 12:27:06","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":"106.92","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":"3053608","reservation_id":"89246","confirmation_number":"PB12327133504","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.68","nightly_discount":"0","subtotal":"87.68","grand_total":"99.08","paid_amount":"99.08","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1616813765","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":"95272","customer_id":"95272","source_of_creation":"Expedia","reservation_created_date":"2020-01-03 19:37:09","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":"87.68","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":"3053610","reservation_id":"89247","confirmation_number":"PB12362342401","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.68","nightly_discount":"0","subtotal":"87.68","grand_total":"99.08","paid_amount":"99.08","room_type_id":"285","product_id":"1084","siteminder_id":"EXP-1616813763","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":"95273","customer_id":"95273","source_of_creation":"Expedia","reservation_created_date":"2020-01-03 19:37: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":"87.68","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":"3045349","reservation_id":"87135","confirmation_number":"PB12339042989","room_stay_from":"2019-12-31","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.58,141.00,141.00,153.00,153.00,141.00,141.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1010.58","grand_total":"1141.95","paid_amount":"1141.95","room_type_id":"289","product_id":"1097","siteminder_id":"EXP-1380423636","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":"95474","customer_id":"95474","source_of_creation":"Expedia","reservation_created_date":"2019-11-14 17:23:07","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":"141.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":"3050833","reservation_id":"88736","confirmation_number":"PB12319362665","room_stay_from":"2020-01-03","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.24,117.24,111.00,111.00","nightly_discount":"0,0,0,0","subtotal":"456.48","grand_total":"515.82","paid_amount":"515.82","room_type_id":"287","product_id":"1087","siteminder_id":"EXP-1612888050","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":"95475","customer_id":"95475","source_of_creation":"Expedia","reservation_created_date":"2019-12-26 21:57:09","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":"111.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3052926","reservation_id":"89117","confirmation_number":"PB12334692075","room_stay_from":"2020-01-04","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.59,74.18,74.18,74.18","nightly_discount":"0,0,0,0","subtotal":"317.13","grand_total":"358.36","paid_amount":"358.36","room_type_id":"289","product_id":"1106","siteminder_id":"AGO-300393654","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":"95171","customer_id":"95171","source_of_creation":"Agoda","reservation_created_date":"2020-01-02 14:46:05","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":"74.18","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":"3053269","reservation_id":"88810","confirmation_number":"PB12393342058","room_stay_from":"2020-01-02","room_stay_to":"2020-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"97.57,104.16,94.73,88.75,88.75,88.75,88.75","nightly_discount":"0.00,0,0,0,0,0,0","subtotal":"651.46","grand_total":"736.15","paid_amount":"736.15","room_type_id":"288","product_id":"1091","siteminder_id":"AGO-262687235","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94955","customer_id":"94955","source_of_creation":"Agoda","reservation_created_date":"2019-12-27 23:33:08","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.75","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"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3050288","reservation_id":"88694","confirmation_number":"PB12376970751","room_stay_from":"2020-01-03","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.70,115.70,102.70","nightly_discount":"0.00,0.00,0.00","subtotal":"334.10","grand_total":"377.54","paid_amount":"377.54","room_type_id":"291","product_id":"1116","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":"94860","customer_id":"94860","source_of_creation":"FE","reservation_created_date":"2019-12-25 18:51:06","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":"102.70","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":"3052247","reservation_id":"88999","confirmation_number":"PB12389209011","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.24,97.50","nightly_discount":"0.00,0.00","subtotal":"215.74","grand_total":"243.78","paid_amount":"243.78","room_type_id":"289","product_id":"1101","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":"95081","customer_id":"95081","source_of_creation":"FE","reservation_created_date":"2019-12-31 04:58:29","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":"97.50","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":"3047664","reservation_id":"88374","confirmation_number":"PB12352472678","room_stay_from":"2020-01-03","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"230.00,230.00,210.00,210.00,210.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1090.00","grand_total":"1231.70","paid_amount":"1231.70","room_type_id":"287","product_id":"1088","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":"56275","customer_id":"56275","source_of_creation":"FE","reservation_created_date":"2019-12-16 02:40:12","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":"210.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3053467","reservation_id":"87624","confirmation_number":"PB12335558521","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"139.00,159.00,159.00,139.00","nightly_discount":"0.00,27.30,0.00,0.00","subtotal":"596.00","grand_total":"642.63","paid_amount":"642.63","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":"94118","customer_id":"94118","source_of_creation":"PMS","reservation_created_date":"2019-11-29 13:52:03","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":"139.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":"3035135","reservation_id":"82525","confirmation_number":"PB12321339963","room_stay_from":"2019-12-28","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.00,148.00,128.00,128.00,128.00,128.00,128.00,148.00,148.00,128.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1360.00","grand_total":"1536.80","paid_amount":"1536.80","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":"42610","customer_id":"42610","source_of_creation":"PMS","reservation_created_date":"2019-08-12 17:26:44","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"148.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":"3053714","reservation_id":"88417","confirmation_number":"PB12341287413","room_stay_from":"2020-01-03","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"159.00,159.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00,21.85,0.00","subtotal":"596.00","grand_total":"648.79","paid_amount":"648.79","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":"37586","customer_id":"37586","source_of_creation":"PMS","reservation_created_date":"2019-12-17 15:59:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.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":"3042716","reservation_id":"87641","confirmation_number":"PB12332218098","room_stay_from":"2020-01-01","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"128.00,128.00,148.00,148.00,128.00,128.00,128.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"936.00","grand_total":"1057.68","paid_amount":"1057.68","room_type_id":"289","product_id":"1103","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":"94130","customer_id":"94130","source_of_creation":"PMS","reservation_created_date":"2019-11-29 21:59:02","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"128.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":"3042719","reservation_id":"87642","confirmation_number":"PB12354974012","room_stay_from":"2020-01-01","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.00,128.00,148.00,148.00,128.00,128.00,128.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"936.00","grand_total":"1057.68","paid_amount":"1057.68","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":"94130","customer_id":"94130","source_of_creation":"PMS","reservation_created_date":"2019-11-29 22:00:29","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":"128.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":"3055019","reservation_id":"89413","confirmation_number":"PB12322562886","room_stay_from":"2020-01-05","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.50,97.50,97.50","nightly_discount":"0.00,0.00,0.00","subtotal":"292.50","grand_total":"330.53","paid_amount":"330.53","room_type_id":"289","product_id":"1123","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":"95387","customer_id":"95387","source_of_creation":"PMS","reservation_created_date":"2020-01-05 21:08:43","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":"97.50","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":"3053580","reservation_id":"88468","confirmation_number":"PB12333773046","room_stay_from":"2020-01-03","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,32.74,0.00","subtotal":"623.00","grand_total":"667.00","paid_amount":"667.00","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":"91746","customer_id":"91746","source_of_creation":"PMS","reservation_created_date":"2019-12-19 15:30:12","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":"89.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":"3054383","reservation_id":"84534","confirmation_number":"PB12353322634","room_stay_from":"2020-01-05","room_stay_to":"2020-01-11","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00,119.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"754.00","grand_total":"852.02","paid_amount":"852.02","room_type_id":"289","product_id":"1099","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":"76330","customer_id":"76330","source_of_creation":"PMS","reservation_created_date":"2020-01-05 13:16:32","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","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":"3050155","reservation_id":"67055","confirmation_number":"PB12350136682","room_stay_from":"2019-12-24","room_stay_to":"2020-01-17","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.00,137.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.35,137.00,0.00,0.00,0.00","subtotal":"2877.00","grand_total":"3095.81","paid_amount":"3095.81","room_type_id":"287","product_id":"1090","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":"69129","customer_id":"69129","source_of_creation":"PMS","reservation_created_date":"2019-01-17 01:59:48","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":"137.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":"3054406","reservation_id":"83768","confirmation_number":"PB12384571715","room_stay_from":"2020-01-02","room_stay_to":"2020-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.80,83.90,83.90","nightly_discount":"0.00,0.00,0.00","subtotal":"237.60","grand_total":"268.49","paid_amount":"268.49","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":"91118","customer_id":"91118","source_of_creation":"PMS","reservation_created_date":"2019-09-08 02:09:53","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":"","changedComment":"Nightly price or discount changed","deltaChange":"237.60","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"}]},{"room_stay_id":"3054381","reservation_id":"84534","confirmation_number":"PB12344255396","room_stay_from":"2020-01-03","room_stay_to":"2020-01-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,119.00","nightly_discount":"0.00,0.00","subtotal":"258.00","grand_total":"291.54","paid_amount":"291.54","room_type_id":"290","product_id":"1113","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":"76330","customer_id":"76330","source_of_creation":"PMS","reservation_created_date":"2019-09-22 14:52:56","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]},{"room_stay_id":"3054408","reservation_id":"82641","confirmation_number":"PB12399761909","room_stay_from":"2020-01-03","room_stay_to":"2020-01-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"98.00","nightly_discount":"0.00","subtotal":"98.00","grand_total":"110.74","paid_amount":"110.74","room_type_id":"291","product_id":"1117","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":"90223","customer_id":"90223","source_of_creation":"PMS","reservation_created_date":"2019-08-14 22:27:46","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":"","changedComment":"Nightly price or discount changed","deltaChange":"98.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"}]},{"room_stay_id":"3054540","reservation_id":"89274","confirmation_number":"PB12319353963","room_stay_from":"2020-01-06","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.10,91.10","nightly_discount":"0.00,0.00","subtotal":"182.20","grand_total":"205.88","paid_amount":"205.88","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":"85581","customer_id":"85581","source_of_creation":"PMS","reservation_created_date":"2020-01-03 23:51:46","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":"","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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3045363","reservation_id":"84676","confirmation_number":"PB12249371678","room_confirmation_number":"PB12367644966","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"40,40,40,40","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"92005","product_attribute_values":"extra_person# ","reservation_created_date":"2019-12-08 00:19:16","reservation_modified_date_time":"2019-12-08 00:19:16","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92005","canceled_nights_data":"","currentDayPrice":"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":"3045366","reservation_id":"87866","confirmation_number":"PB12240468968","room_confirmation_number":"PB12317891166","room_stay_from":"2020-01-01","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0,0,0,0,0","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"94300","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-12-08 00:19:32","reservation_modified_date_time":"2019-12-08 00:19:32","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94300","canceled_nights_data":"","currentDayPrice":"20","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":"3047022","reservation_id":"87624","confirmation_number":"PB12243679477","room_confirmation_number":"PB12335558521","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"94118","product_attribute_values":"extra_person# ","reservation_created_date":"2019-12-14 20:18:15","reservation_modified_date_time":"2019-12-14 20:18:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94118","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":"3049431","reservation_id":"88540","confirmation_number":"PB12245580987","room_confirmation_number":"PB12343216196","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"94739","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-12-22 04:02:09","reservation_modified_date_time":"2019-12-22 04:02:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94739","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":"3053850","reservation_id":"88543","confirmation_number":"PB12294092743","room_confirmation_number":"PB12316811294","room_stay_from":"2020-01-03","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0,0,0","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"94742","product_attribute_values":"extra_person# ","reservation_created_date":"2020-01-04 04:03:26","reservation_modified_date_time":"2020-01-04 04:03:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94742","canceled_nights_data":"","currentDayPrice":"10","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":"3042717","reservation_id":"87641","confirmation_number":"PB12264073977","room_confirmation_number":"PB12332218098","room_stay_from":"2020-01-01","room_stay_to":"2020-01-08","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00,10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"94130","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-11-29 21:59:02","reservation_modified_date_time":"2019-11-29 21:59:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94130","canceled_nights_data":"","currentDayPrice":"10.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":"3053270","reservation_id":"88810","confirmation_number":"PB12268535142","room_confirmation_number":"PB12393342058","room_stay_from":"2020-01-02","room_stay_to":"2020-01-09","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0,0,0,0,0,0,0","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"94955","product_attribute_values":"extra_person# .00","reservation_created_date":"2019-12-27 23:33:08","reservation_modified_date_time":"2020-01-03 01:17:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94955","canceled_nights_data":"","currentDayPrice":"0.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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3033010","reservation_id":"86210","confirmation_number":"PB12244068608","room_confirmation_number":"PB12370933584","room_stay_from":"2020-01-02","room_stay_to":"2020-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":"93044","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-10-25 14:51:06","reservation_modified_date_time":"2019-10-25 14:51:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93044","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":"3045364","reservation_id":"84676","confirmation_number":"PB12239312958","room_confirmation_number":"PB12367644966","room_stay_from":"2020-01-02","room_stay_to":"2020-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":"92005","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-09-25 13:40:10","reservation_modified_date_time":"2019-09-25 13:40:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92005","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":"3049432","reservation_id":"88540","confirmation_number":"PB12274570061","room_confirmation_number":"PB12343216196","room_stay_from":"2020-01-02","room_stay_to":"2020-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":"94739","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-22 04:02:09","reservation_modified_date_time":"2019-12-22 04:02:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94739","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":"3050289","reservation_id":"88694","confirmation_number":"PB12244325030","room_confirmation_number":"PB12376970751","room_stay_from":"2020-01-03","room_stay_to":"2020-01-06","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":"94860","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-25 18:51:06","reservation_modified_date_time":"2019-12-25 18:51:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94860","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":"3050610","reservation_id":"88710","confirmation_number":"PB12225923812","room_confirmation_number":"PB12327436860","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","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":"94874","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-26 04:08:09","reservation_modified_date_time":"2019-12-26 04:08:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94874","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":"3052248","reservation_id":"88999","confirmation_number":"PB12241058565","room_confirmation_number":"PB12389209011","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","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":"95081","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-31 04:58:29","reservation_modified_date_time":"2019-12-31 04:58:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95081","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":"3052616","reservation_id":"87866","confirmation_number":"PB12225453532","room_confirmation_number":"PB12317891166","room_stay_from":"2020-01-01","room_stay_to":"2020-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":"94300","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-05 03:33:07","reservation_modified_date_time":"2020-01-01 18:32:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94300","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":"3053391","reservation_id":"89214","confirmation_number":"PB12228197311","room_confirmation_number":"PB12324922027","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","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":"95242","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-03 12:27:06","reservation_modified_date_time":"2020-01-03 12:27:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95242","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":"3053468","reservation_id":"87624","confirmation_number":"PB12219689881","room_confirmation_number":"PB12335558521","room_stay_from":"2020-01-02","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"94118","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-11-29 13:52:03","reservation_modified_date_time":"2020-01-03 15:31:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94118","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":"3053609","reservation_id":"89246","confirmation_number":"PB12232649451","room_confirmation_number":"PB12327133504","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","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":"95272","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-03 19:37:09","reservation_modified_date_time":"2020-01-03 19:37:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95272","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":"3053611","reservation_id":"89247","confirmation_number":"PB12251912551","room_confirmation_number":"PB12362342401","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","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":"95273","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-03 19:37:12","reservation_modified_date_time":"2020-01-03 19:37:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95273","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":"3053851","reservation_id":"88543","confirmation_number":"PB12222990442","room_confirmation_number":"PB12316811294","room_stay_from":"2020-01-03","room_stay_to":"2020-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":"94742","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-22 05:32:11","reservation_modified_date_time":"2019-12-22 05:32:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94742","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":"3053919","reservation_id":"89303","confirmation_number":"PB12289431869","room_confirmation_number":"PB12381917794","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","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":"95305","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-04 05:13:12","reservation_modified_date_time":"2020-01-04 05:13:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95305","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":"3035136","reservation_id":"82525","confirmation_number":"PB12277549916","room_confirmation_number":"PB12321339963","room_stay_from":"2019-12-28","room_stay_to":"2020-01-07","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":"42610","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-08-12 17:26:44","reservation_modified_date_time":"2019-08-12 17:26:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"42610","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":"3045350","reservation_id":"87135","confirmation_number":"PB12211030055","room_confirmation_number":"PB12339042989","room_stay_from":"2019-12-31","room_stay_to":"2020-01-07","room_stay_status":"Active","nightly_price":"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","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"95474","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-14 17:23:07","reservation_modified_date_time":"2019-11-14 17:23:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95474","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":"3050834","reservation_id":"88736","confirmation_number":"PB12215270072","room_confirmation_number":"PB12319362665","room_stay_from":"2020-01-03","room_stay_to":"2020-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":"95475","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-26 21:57:09","reservation_modified_date_time":"2019-12-26 21:57:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95475","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":"3053715","reservation_id":"88417","confirmation_number":"PB12289652060","room_confirmation_number":"PB12341287413","room_stay_from":"2020-01-03","room_stay_to":"2020-01-07","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":"37586","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-17 15:59:58","reservation_modified_date_time":"2020-01-03 22:09:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"37586","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":"3042718","reservation_id":"87641","confirmation_number":"PB12287904337","room_confirmation_number":"PB12332218098","room_stay_from":"2020-01-01","room_stay_to":"2020-01-08","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":"94130","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-11-29 21:59:02","reservation_modified_date_time":"2019-11-29 21:59:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94130","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":"3042720","reservation_id":"87642","confirmation_number":"PB12217461547","room_confirmation_number":"PB12354974012","room_stay_from":"2020-01-01","room_stay_to":"2020-01-08","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":"94130","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-11-29 22:00:29","reservation_modified_date_time":"2019-11-29 22:00:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94130","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":"3047665","reservation_id":"88374","confirmation_number":"PB12210651626","room_confirmation_number":"PB12352472678","room_stay_from":"2020-01-03","room_stay_to":"2020-01-08","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":"56275","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-16 02:40:12","reservation_modified_date_time":"2019-12-16 02:40:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56275","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":"3052927","reservation_id":"89117","confirmation_number":"PB12249452394","room_confirmation_number":"PB12334692075","room_stay_from":"2020-01-04","room_stay_to":"2020-01-08","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":"95171","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-02 14:46:05","reservation_modified_date_time":"2020-01-02 14:46:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95171","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":"3055020","reservation_id":"89413","confirmation_number":"PB12250332800","room_confirmation_number":"PB12322562886","room_stay_from":"2020-01-05","room_stay_to":"2020-01-08","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":"95387","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-01-05 21:08:43","reservation_modified_date_time":"2020-01-05 21:08:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95387","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":"3053271","reservation_id":"88810","confirmation_number":"PB12296168841","room_confirmation_number":"PB12393342058","room_stay_from":"2020-01-02","room_stay_to":"2020-01-09","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":"94955","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-27 23:33:08","reservation_modified_date_time":"2020-01-03 01:17:22","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94955","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":"3042914","reservation_id":"87658","confirmation_number":"PB12257724834","room_confirmation_number":"PB12321592123","room_stay_from":"2020-01-01","room_stay_to":"2020-01-10","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,0,0,0,0,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"95729","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-11-30 02:46:09","reservation_modified_date_time":"2019-11-30 02:46:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95729","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":"3053581","reservation_id":"88468","confirmation_number":"PB12264607909","room_confirmation_number":"PB12333773046","room_stay_from":"2020-01-03","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"91746","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-19 15:30:12","reservation_modified_date_time":"2020-01-03 18:47:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91746","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":"3054384","reservation_id":"84534","confirmation_number":"PB12248041924","room_confirmation_number":"PB12353322634","room_stay_from":"2020-01-05","room_stay_to":"2020-01-11","room_stay_status":"Active","nightly_price":"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","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"76330","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-01-05 13:16:32","reservation_modified_date_time":"2020-01-05 13:16:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76330","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":"3050156","reservation_id":"67055","confirmation_number":"PB12244669360","room_confirmation_number":"PB12350136682","room_stay_from":"2019-12-24","room_stay_to":"2020-01-17","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"69129","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-01-17 01:59:48","reservation_modified_date_time":"2019-12-24 22:45:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"69129","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":"3054375","reservation_id":"87866","confirmation_number":"PB12215782078","room_confirmation_number":"PB12317891166","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"20.00","product_id":"1158","service_quantity":"2","product_name":"Fishing Pole","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-05 12:56:05","reservation_modified_date_time":"2020-01-05 12:56:05","customer_id":"94300","parentCustTravId":"94300","customer_traveller_id":"94300","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3053984","reservation_id":"89317","confirmation_number":"PB12226722565","room_confirmation_number":"PB12337874479","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1192","service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-04 17:37:51","reservation_modified_date_time":"2020-01-04 17:37:51","customer_id":"95319","parentCustTravId":"95319","customer_traveller_id":"95319","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2020-01-05 16:56:55","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-20,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":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":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":7,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1140","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BV12294744143","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3054109","reservation_id":"89325","confirmation_number":"BV12478857729","room_stay_from":"2020-01-04","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"93.75,89.13,89.13","nightly_discount":"0,0,0","subtotal":"272.01","grand_total":"307.37","paid_amount":"307.37","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-3276577618","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95325","customer_id":"95325","source_of_creation":"Booking.com","reservation_created_date":"2020-01-04 20:17:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"27.18","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.13","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"}]}],"bdc_non_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3054816","reservation_id":"88609","confirmation_number":"BV12454480731","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.27","nightly_discount":"0","subtotal":"88.27","grand_total":"115.17","paid_amount":"115.17","room_type_id":"309","product_id":"1226","siteminder_id":"ABB-HMJ9BRDR5M","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"88.27","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94800","customer_id":"94800","source_of_creation":"Airbnb","reservation_created_date":"2019-12-23 18:29:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"12.34","commision_charges":"2.73","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"88.27","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3054400","reservation_id":"89250","confirmation_number":"BV12481004762","room_stay_from":"2020-01-05","room_stay_to":"2020-01-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.51,67.51,67.51,67.51","nightly_discount":"0,0,0,0","subtotal":"270.04","grand_total":"305.14","paid_amount":"305.14","room_type_id":"295","product_id":"1129","siteminder_id":"AGO-300678142","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":"95274","customer_id":"95274","source_of_creation":"Agoda","reservation_created_date":"2020-01-03 20:03:07","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":"67.51","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"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3040449","reservation_id":"87408","confirmation_number":"BV12477052062","room_stay_from":"2020-01-02","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,160.00,160.00,140.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"740.00","grand_total":"836.20","paid_amount":"836.20","room_type_id":"308","product_id":"1225","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":"93953","customer_id":"93953","source_of_creation":"FE","reservation_created_date":"2019-11-22 14:22:40","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":"140.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":"3052423","reservation_id":"87816","confirmation_number":"BV12474454075","room_stay_from":"2019-12-31","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,150.00,170.00,170.00,150.00,150.00,150.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,124.00,0.00","subtotal":"1240.00","grand_total":"1261.08","paid_amount":"1261.08","room_type_id":"306","product_id":"1223","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":"64584","customer_id":"64584","source_of_creation":"FE","reservation_created_date":"2019-12-03 18:57:43","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":"150.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3054463","reservation_id":"89398","confirmation_number":"BV12456561834","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.00","nightly_discount":"0.00","subtotal":"76.00","grand_total":"85.88","paid_amount":"85.88","room_type_id":"307","product_id":"1224","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":"95378","customer_id":"95378","source_of_creation":"PMS","reservation_created_date":"2020-01-05 18:38:19","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":"76.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":"3055400","reservation_id":"89239","confirmation_number":"BV12495948078","room_stay_from":"2020-01-04","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.92,91.00,91.00,91.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"377.92","grand_total":"427.05","paid_amount":"413.49","room_type_id":"304","product_id":"1219","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":"95262","customer_id":"95262","source_of_creation":"PMS","reservation_created_date":"2020-01-03 18:32:14","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":"91.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":"3054110","reservation_id":"89325","confirmation_number":"BV12243586536","room_confirmation_number":"BV12478857729","room_stay_from":"2020-01-04","room_stay_to":"2020-01-07","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0,0,0","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"95325","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-01-04 20:17:12","reservation_modified_date_time":"2020-01-04 20:17:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95325","canceled_nights_data":"","currentDayPrice":"10","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3054464","reservation_id":"89398","confirmation_number":"BV12285086618","room_confirmation_number":"BV12456561834","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","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":"95378","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-01-05 18:38:19","reservation_modified_date_time":"2020-01-05 18:38:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95378","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":"3054817","reservation_id":"88609","confirmation_number":"BV12223946584","room_confirmation_number":"BV12454480731","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","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":"94800","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-23 18:29:08","reservation_modified_date_time":"2019-12-23 18:29:08","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94800","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3040450","reservation_id":"87408","confirmation_number":"BV12251857878","room_confirmation_number":"BV12477052062","room_stay_from":"2020-01-02","room_stay_to":"2020-01-07","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":"93953","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-11-22 14:22:40","reservation_modified_date_time":"2019-11-22 14:22:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93953","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":"3054111","reservation_id":"89325","confirmation_number":"BV12283187880","room_confirmation_number":"BV12478857729","room_stay_from":"2020-01-04","room_stay_to":"2020-01-07","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":"95325","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-04 20:17:12","reservation_modified_date_time":"2020-01-04 20:17:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95325","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":"3052424","reservation_id":"87816","confirmation_number":"BV12234357131","room_confirmation_number":"BV12474454075","room_stay_from":"2019-12-31","room_stay_to":"2020-01-08","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.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"64584","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-03 18:57:43","reservation_modified_date_time":"2019-12-31 20:35:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"64584","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":"3055401","reservation_id":"89239","confirmation_number":"BV12288347082","room_confirmation_number":"BV12495948078","room_stay_from":"2020-01-04","room_stay_to":"2020-01-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95262","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-01-03 18:32:14","reservation_modified_date_time":"2020-01-06 14:33:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95262","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":"3054401","reservation_id":"89250","confirmation_number":"BV12277916303","room_confirmation_number":"BV12481004762","room_stay_from":"2020-01-05","room_stay_to":"2020-01-09","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":"95274","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-03 20:03:07","reservation_modified_date_time":"2020-01-03 20:03:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95274","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3054595","reservation_id":"89398","confirmation_number":"BV12299299526","room_confirmation_number":"BV12456561834","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"15.00","grand_total":"16.95","paid_amount":"16.95","product_id":"1082","service_quantity":"1","product_name":"discounted extra parking pass","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-05 22:35:37","reservation_modified_date_time":"2020-01-05 22:35:37","customer_id":"95378","parentCustTravId":"95378","customer_traveller_id":"95378","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"15.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3054641","reservation_id":"88609","confirmation_number":"BV12219445650","room_confirmation_number":"BV12454480731","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1082","service_quantity":"3","product_name":"upgrade fee","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-06 00:34:53","reservation_modified_date_time":"2020-01-06 00:34:53","customer_id":"94800","parentCustTravId":"94800","customer_traveller_id":"94800","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3054743","reservation_id":"89239","confirmation_number":"BV12214532899","room_confirmation_number":"BV12495948078","room_stay_from":"2020-01-04","room_stay_to":"2020-01-08","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-03 18:32:14","reservation_modified_date_time":"2020-01-06 14:33:03","customer_id":"95262","parentCustTravId":"95262","customer_traveller_id":"95262","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":"25.00","currentDayDiscount":"0.00","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":7,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1137","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BP12236820689","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3051136","reservation_id":"88794","confirmation_number":"BP12547874835","room_stay_from":"2020-01-01","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"111.12,111.12,119.57,119.57,111.12","nightly_discount":"0,0,0,0,0","subtotal":"572.50","grand_total":"646.93","paid_amount":"646.93","room_type_id":"296","product_id":"1131","siteminder_id":"BDC-3010013558","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":"94942","customer_id":"94942","source_of_creation":"Booking.com","reservation_created_date":"2019-12-27 19:44:08","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"103.05","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.12","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":"3054652","reservation_id":"89382","confirmation_number":"BP12524841863","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"67.45","nightly_discount":"0.00","subtotal":"67.45","grand_total":"76.22","paid_amount":"76.22","room_type_id":"289","product_id":"1098","siteminder_id":"BDC-3992485786","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95362","customer_id":"95362","source_of_creation":"Booking.com","reservation_created_date":"2020-01-05 06:12:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"15.74","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.45","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":"3046149","reservation_id":"88170","confirmation_number":"BP12533348084","room_stay_from":"2019-12-29","room_stay_to":"2020-01-10","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"97.09,97.09,97.09,97.38,97.38,106.97,106.97,97.38,97.38,97.38,97.38,97.38","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1186.87","grand_total":"1341.16","paid_amount":"1341.16","room_type_id":"299","product_id":"1134","siteminder_id":"EXP-1389938151","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":"94493","customer_id":"94493","source_of_creation":"Expedia","reservation_created_date":"2019-12-11 19:32:10","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":"97.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3052901","reservation_id":"88705","confirmation_number":"BP12549120773","room_stay_from":"2019-12-31","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"104.05,67.80,67.80,73.55,73.55,67.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"454.55","grand_total":"513.64","paid_amount":"513.64","room_type_id":"294","product_id":"1127","siteminder_id":"GAM-R1802946733","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94869","customer_id":"94869","source_of_creation":"Getaroom.com","reservation_created_date":"2019-12-25 22:12:05","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":"67.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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3054200","reservation_id":"89347","confirmation_number":"BP12532619848","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.21,60.21","nightly_discount":"0,0","subtotal":"120.42","grand_total":"136.08","paid_amount":"136.08","room_type_id":"295","product_id":"1128","siteminder_id":"HWR-301557287","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":"95334","customer_id":"95334","source_of_creation":"Hotwire","reservation_created_date":"2020-01-04 23:13:10","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":"60.21","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"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3052870","reservation_id":"89106","confirmation_number":"BP12568649531","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","room_stay_status":"Closed","room_stay_guest_count":"6","room_stay_child_count":"2","nightly_price":"130.75,109.20","nightly_discount":"0.00,0.00","subtotal":"239.95","grand_total":"271.15","paid_amount":"271.15","room_type_id":"302","product_id":"1138","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":"95161","customer_id":"95161","source_of_creation":"FE","reservation_created_date":"2020-01-02 02:09:00","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":"109.20","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":"3053287","reservation_id":"89191","confirmation_number":"BP12515954709","room_stay_from":"2020-01-05","room_stay_to":"2020-01-08","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"78.00,78.00,78.00","nightly_discount":"0.00,0.00,0.00","subtotal":"234.00","grand_total":"264.42","paid_amount":"264.42","room_type_id":"298","product_id":"1133","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":"47798","customer_id":"47798","source_of_creation":"FE","reservation_created_date":"2020-01-03 01:50:11","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":"78.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3052311","reservation_id":"89010","confirmation_number":"BP12525856960","room_stay_from":"2020-01-01","room_stay_to":"2020-01-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.38,141.38,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"762.76","grand_total":"861.92","paid_amount":"861.92","room_type_id":"296","product_id":"1130","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":"95089","customer_id":"95089","source_of_creation":"PMS","reservation_created_date":"2019-12-31 15:16:06","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.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":"3052872","reservation_id":"89106","confirmation_number":"BP12296849526","room_confirmation_number":"BP12568649531","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"60.00,60.00","nightly_discount":"0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"95161","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-01-02 02:09:00","reservation_modified_date_time":"2020-01-02 02:09:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95161","canceled_nights_data":"","currentDayPrice":"60.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":"3054649","reservation_id":"89382","confirmation_number":"BP12238906709","room_confirmation_number":"BP12524841863","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"95362","product_attribute_values":"extra_person# ","reservation_created_date":"2020-01-06 00:50:37","reservation_modified_date_time":"2020-01-06 00:50:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95362","canceled_nights_data":"","currentDayPrice":"20","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":"3051137","reservation_id":"88794","confirmation_number":"BP12224643760","room_confirmation_number":"BP12547874835","room_stay_from":"2020-01-01","room_stay_to":"2020-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":"94942","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-27 19:44:08","reservation_modified_date_time":"2019-12-27 19:44:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94942","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":"3052871","reservation_id":"89106","confirmation_number":"BP12225492016","room_confirmation_number":"BP12568649531","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","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":"95161","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-01-02 02:09:00","reservation_modified_date_time":"2020-01-02 02:09:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95161","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":"3052903","reservation_id":"88705","confirmation_number":"BP12211820015","room_confirmation_number":"BP12549120773","room_stay_from":"2019-12-31","room_stay_to":"2020-01-06","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":"94869","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-25 22:12:05","reservation_modified_date_time":"2020-01-02 03:16:18","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94869","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":"3054201","reservation_id":"89347","confirmation_number":"BP12229313712","room_confirmation_number":"BP12532619848","room_stay_from":"2020-01-04","room_stay_to":"2020-01-06","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":"95334","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-04 23:13:10","reservation_modified_date_time":"2020-01-04 23:13:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95334","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":"3054653","reservation_id":"89382","confirmation_number":"BP12289261940","room_confirmation_number":"BP12524841863","room_stay_from":"2020-01-05","room_stay_to":"2020-01-06","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":"95362","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-01-05 06:12:10","reservation_modified_date_time":"2020-01-06 00:50:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95362","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":"3052312","reservation_id":"89010","confirmation_number":"BP12262783264","room_confirmation_number":"BP12525856960","room_stay_from":"2020-01-01","room_stay_to":"2020-01-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0,0,0,0","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"95089","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-12-31 15:16:06","reservation_modified_date_time":"2019-12-31 15:16:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95089","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":"3053288","reservation_id":"89191","confirmation_number":"BP12294766989","room_confirmation_number":"BP12515954709","room_stay_from":"2020-01-05","room_stay_to":"2020-01-08","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":"47798","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-01-03 01:50:11","reservation_modified_date_time":"2020-01-03 01:50:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","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":"3046150","reservation_id":"88170","confirmation_number":"BP12214923305","room_confirmation_number":"BP12533348084","room_stay_from":"2019-12-29","room_stay_to":"2020-01-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,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,0.00,0.00,0.00","subtotal":"240.00","grand_total":"271.20","paid_amount":"271.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"94493","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2019-12-11 19:32:10","reservation_modified_date_time":"2019-12-11 19:32:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94493","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"2936334","reservation_id":"69585","confirmation_number":"BP12214447507","room_confirmation_number":"BP12549690899","room_stay_from":"2020-01-04","room_stay_to":"2020-02-22","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","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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-16 16:13:23","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"46530","parentCustTravId":"46530","customer_traveller_id":"46530","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.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3054654","reservation_id":"89382","confirmation_number":"PB12253317742","room_confirmation_number":"BP12524841863","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-06 00:50:47","reservation_modified_date_time":"2020-01-06 00:50:57","customer_id":"95362","parentCustTravId":"95362","customer_traveller_id":"95362","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"10.00","currentDayDiscount":"0.00","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":[]}}}