{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2021-09-07","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,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":28,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1114,1226,1131","block_room_bookings":[{"confirmation_number":"PB12295714485","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","bundle_room":"0","product_id":"1114"},{"confirmation_number":"BV12263988354","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","bundle_room":"0","product_id":"1226"},{"confirmation_number":"BP12237062750","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","bundle_room":"0","product_id":"1131"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5308098","reservation_id":"122459","confirmation_number":"PB12337381879","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"670.55,421.18,142.15,142.15","nightly_discount":"0,0,0,0","subtotal":"1376.03","grand_total":"1554.91","paid_amount":"1554.91","room_type_id":"291","product_id":"1116","siteminder_id":"BDC-3112625374","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":"130057","customer_id":"130057","source_of_creation":"Booking.com","reservation_created_date":"2021-09-03 11:54:14","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"218.40","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"142.15","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":"5308875","reservation_id":"122412","confirmation_number":"BP12555256120","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"213.37,195.14,88.13,95.28","nightly_discount":"0,0,0,0","subtotal":"591.92","grand_total":"668.87","paid_amount":"668.87","room_type_id":"294","product_id":"1127","siteminder_id":"BDC-3330536346","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":"130177","customer_id":"130177","source_of_creation":"Booking.com","reservation_created_date":"2021-09-02 15:09:10","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 822","ota_service_fee_amount":"0","commision_charges":"120.96","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"95.28","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":"5309773","reservation_id":"122674","confirmation_number":"PB12344621789","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.29","nightly_discount":"0","subtotal":"102.29","grand_total":"115.59","paid_amount":"115.59","room_type_id":"289","product_id":"1097","siteminder_id":"BDC-2374393522","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":"130321","customer_id":"130321","source_of_creation":"Booking.com","reservation_created_date":"2021-09-07 08:44:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"18.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"102.29","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":"5310190","reservation_id":"122640","confirmation_number":"BV12435837985","room_stay_from":"2021-09-06","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.59,95.00,95.00","nightly_discount":"0.00,0.00,0.00","subtotal":"301.59","grand_total":"340.80","paid_amount":"340.80","room_type_id":"306","product_id":"1223","siteminder_id":"BDC-2872249747","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":"130297","customer_id":"130297","source_of_creation":"Booking.com","reservation_created_date":"2021-09-06 19:08:13","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"23.69","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"95.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":"5310257","reservation_id":"122697","confirmation_number":"BP12522558392","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.58","nightly_discount":"0","subtotal":"106.58","grand_total":"120.43","paid_amount":"120.43","room_type_id":"302","product_id":"1138","siteminder_id":"BDC-2494850049","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":"130346","customer_id":"130346","source_of_creation":"Booking.com","reservation_created_date":"2021-09-07 18:52:14","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"22.78","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"106.58","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":"5310283","reservation_id":"122441","confirmation_number":"BP12566073128","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.71,84.71","nightly_discount":"0,0","subtotal":"169.42","grand_total":"191.45","paid_amount":"191.45","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-3529137071","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":"112612","customer_id":"112612","source_of_creation":"Booking.com","reservation_created_date":"2021-09-02 22:55:08","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"0","commision_charges":"37.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"84.71","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":"5310352","reservation_id":"122014","confirmation_number":"PB12347951719","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"191.23,191.23,191.23,150.57,150.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"874.83","grand_total":"988.56","paid_amount":"988.56","room_type_id":"289","product_id":"1102","siteminder_id":"BDC-3043750611","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":"130369","customer_id":"130369","source_of_creation":"Booking.com","reservation_created_date":"2021-08-27 18:18:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"146.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"191.23","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5309551","reservation_id":"122630","confirmation_number":"PB12324555467","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.35,83.35","nightly_discount":"0,0","subtotal":"166.70","grand_total":"188.37","paid_amount":"188.37","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1826287800","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":"130268","customer_id":"130268","source_of_creation":"Expedia","reservation_created_date":"2021-09-06 17:14:17","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"83.35","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":"5309567","reservation_id":"122431","confirmation_number":"PB12362564908","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.98,83.98","nightly_discount":"0,0","subtotal":"167.96","grand_total":"189.80","paid_amount":"189.80","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1824707525","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":"130271","customer_id":"130271","source_of_creation":"Expedia","reservation_created_date":"2021-09-02 20:26:08","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":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"83.98","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5309804","reservation_id":"122645","confirmation_number":"PB12328998065","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.24,97.24","nightly_discount":"0,0","subtotal":"194.48","grand_total":"219.76","paid_amount":"219.76","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1826356521","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":"130299","customer_id":"130299","source_of_creation":"Expedia","reservation_created_date":"2021-09-06 19:56:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"97.24","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":"5309940","reservation_id":"122035","confirmation_number":"PB12384796841","room_stay_from":"2021-09-03","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"311.89,311.89,291.13,196.97,196.97","nightly_discount":"0,0,0,0,0","subtotal":"1308.85","grand_total":"1479.00","paid_amount":"1479.00","room_type_id":"288","product_id":"1091","siteminder_id":"EXP-1822068811","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130329","customer_id":"130329","source_of_creation":"Expedia","reservation_created_date":"2021-08-27 20:35:07","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"235.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"196.97","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":"5310129","reservation_id":"122556","confirmation_number":"PB12356858890","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"98.2,98.2","nightly_discount":"0,0","subtotal":"196.40","grand_total":"221.93","paid_amount":"221.94","room_type_id":"291","product_id":"1115","siteminder_id":"EXP-1825737867","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":"130287","customer_id":"130287","source_of_creation":"Expedia","reservation_created_date":"2021-09-07 15:37:32","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":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"98.2","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":"5310255","reservation_id":"122675","confirmation_number":"BP12531867785","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"57.44","nightly_discount":"0","subtotal":"57.44","grand_total":"64.91","paid_amount":"64.91","room_type_id":"295","product_id":"1128","siteminder_id":"EXP-1826578238","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":"130345","customer_id":"130345","source_of_creation":"Expedia","reservation_created_date":"2021-09-07 09:19:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"57.44","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":"5310306","reservation_id":"122671","confirmation_number":"BV12452745352","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"93.72","nightly_discount":"0","subtotal":"93.72","grand_total":"105.90","paid_amount":"105.90","room_type_id":"304","product_id":"1218","siteminder_id":"EXP-1826511270","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":"130355","customer_id":"130355","source_of_creation":"Expedia","reservation_created_date":"2021-09-07 03:19:11","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"93.72","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":"5310364","reservation_id":"122457","confirmation_number":"PB12311229106","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.59,90.59","nightly_discount":"0,0","subtotal":"181.18","grand_total":"204.73","paid_amount":"204.73","room_type_id":"289","product_id":"1123","siteminder_id":"EXP-1824933541","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":"130371","customer_id":"130371","source_of_creation":"Expedia","reservation_created_date":"2021-09-03 08:06:12","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":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"90.59","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":"5310120","reservation_id":"122556","confirmation_number":"PB12338107996","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","room_stay_status":"Checked-Out","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"98.2","nightly_discount":"0","subtotal":"98.20","grand_total":"110.96","paid_amount":"110.96","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1825737867","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":"130287","customer_id":"130287","source_of_creation":"Expedia","reservation_created_date":"2021-09-05 04:36:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","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":"5310136","reservation_id":"119370","confirmation_number":"PB12368864278","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.42","nightly_discount":"0","subtotal":"116.42","grand_total":"131.56","paid_amount":"131.56","room_type_id":"291","product_id":"1119","siteminder_id":"EXP-1801225389","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":"130334","customer_id":"130334","source_of_creation":"Expedia","reservation_created_date":"2021-07-15 05:35:09","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":"","promotion_code":"","sub_hotel_id":"123","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"}]}],"exp_non_taxable":[{"room_stay_id":"5310228","reservation_id":"122692","confirmation_number":"PB12364276863","room_stay_from":"2021-09-07","room_stay_to":"2021-09-11","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.89,111.89,111.89,146.61","nightly_discount":"0,0,0,0","subtotal":"482.28","grand_total":"544.98","paid_amount":"544.98","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1826740839","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":"130342","customer_id":"130342","source_of_creation":"Expedia","reservation_created_date":"2021-09-07 17:39:09","service_canceled_date_time":"2021-09-07 22:44:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"544.98","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5308657","reservation_id":"116694","confirmation_number":"PB12337007929","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"266.21,243.93,96.80,96.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"703.74","grand_total":"795.22","paid_amount":"795.22","room_type_id":"292","product_id":"1120","siteminder_id":"GAM-R2573467940","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":"130134","customer_id":"130134","source_of_creation":"Getaroom.com","reservation_created_date":"2021-06-07 00:45:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"96.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5309637","reservation_id":"122651","confirmation_number":"BP12537559068","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"145.57,145.57,145.57,185.74,185.74","nightly_discount":"0,0,0,0,0","subtotal":"808.19","grand_total":"913.25","paid_amount":"913.25","room_type_id":"301","product_id":"1136","siteminder_id":"GAM-R2787562808","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130289","customer_id":"130289","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-06 21:19:06","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 807","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"145.57","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":"5309641","reservation_id":"122500","confirmation_number":"BP12515174829","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.48,53.49","nightly_discount":"0,0","subtotal":"102.97","grand_total":"116.36","paid_amount":"116.36","room_type_id":"299","product_id":"1134","siteminder_id":"GAM-R2781973429","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":"130290","customer_id":"130290","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-04 01:17:09","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"53.49","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":"5310292","reservation_id":"122705","confirmation_number":"BP12571256678","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.49","nightly_discount":"0","subtotal":"53.49","grand_total":"60.44","paid_amount":"60.44","room_type_id":"298","product_id":"1133","siteminder_id":"GAM-R2789634203","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":"130353","customer_id":"130353","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-07 20:05:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"53.49","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3258734","reservation_id":"116123","confirmation_number":"BV12449413854","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"262.08,211.68,84.00,84.00,84.00,84.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"913.76","grand_total":"1032.55","paid_amount":"1032.55","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":"122954","customer_id":"122954","source_of_creation":"FE","reservation_created_date":"2021-05-29 01:20:27","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":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"84.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":"5178873","reservation_id":"121733","confirmation_number":"BP12542082633","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"300.00,324.32","nightly_discount":"0.00,0.00","subtotal":"624.32","grand_total":"705.48","paid_amount":"705.48","room_type_id":"297","product_id":"1132","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129277","customer_id":"129277","source_of_creation":"FE","reservation_created_date":"2021-08-23 01:10:30","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 826","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"324.32","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5307995","reservation_id":"122390","confirmation_number":"PB12352370296","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"610.73,347.17,179.96,179.96","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1317.82","grand_total":"1489.14","paid_amount":"1489.14","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":"129982","customer_id":"129982","source_of_creation":"FE","reservation_created_date":"2021-09-02 02:38:01","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"179.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5308250","reservation_id":"122448","confirmation_number":"PB12333574291","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.29,194.29","nightly_discount":"0.00,0.00","subtotal":"388.58","grand_total":"439.09","paid_amount":"439.09","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":"130043","customer_id":"130043","source_of_creation":"FE","reservation_created_date":"2021-09-03 01:21:34","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"194.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5309237","reservation_id":"105921","confirmation_number":"PB12358700519","room_stay_from":"2021-09-05","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00,29.00","subtotal":"650.00","grand_total":"701.73","paid_amount":"701.73","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":"47205","customer_id":"47205","source_of_creation":"FE","reservation_created_date":"2021-01-23 11:12:10","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"130.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":"5309388","reservation_id":"120831","confirmation_number":"PB12378251203","room_stay_from":"2021-09-06","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"278.58,278.58,278.58,278.58","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1114.32","grand_total":"1259.18","paid_amount":"1259.18","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128224","customer_id":"128224","source_of_creation":"FE","reservation_created_date":"2021-08-06 15:59:39","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"278.58","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5309403","reservation_id":"121939","confirmation_number":"PB12390181805","room_stay_from":"2021-09-06","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"278.58,278.58,278.58,278.58,221.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1335.32","grand_total":"1508.91","paid_amount":"1508.91","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129479","customer_id":"129479","source_of_creation":"FE","reservation_created_date":"2021-09-06 15:03:29","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"278.58","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5310288","reservation_id":"120021","confirmation_number":"PB12339425825","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.02,97.02,97.02","nightly_discount":"0.00,0.00,12.34","subtotal":"291.06","grand_total":"314.95","paid_amount":"314.95","room_type_id":"285","product_id":"1084","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":"105102","customer_id":"105102","source_of_creation":"FE","reservation_created_date":"2021-07-24 23:36:27","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":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"97.02","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3299932","reservation_id":"119756","confirmation_number":"PB12341583321","room_stay_from":"2021-09-02","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00,130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0,0","subtotal":"1040.00","grand_total":"1175.20","paid_amount":"1175.20","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":"44919","customer_id":"44919","source_of_creation":"PMS","reservation_created_date":"2021-07-21 01:00:08","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"130.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":"5307253","reservation_id":"121644","confirmation_number":"PB12375066657","room_stay_from":"2021-09-05","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.00,203.00,203.00","nightly_discount":"0.00,0.00,0.00","subtotal":"609.00","grand_total":"688.17","paid_amount":"688.17","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129111","customer_id":"129111","source_of_creation":"PMS","reservation_created_date":"2021-08-21 15:39:36","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"203.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":"5308705","reservation_id":"121059","confirmation_number":"PB12335945544","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.04,194.04","nightly_discount":"0.00,0.00","subtotal":"388.08","grand_total":"438.53","paid_amount":"438.53","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":"127248","customer_id":"127248","source_of_creation":"PMS","reservation_created_date":"2021-08-11 17:05:06","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"194.04","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5309416","reservation_id":"122624","confirmation_number":"PB12379242493","room_stay_from":"2021-09-06","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","room_type_id":"289","product_id":"1110","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130261","customer_id":"130261","source_of_creation":"PMS","reservation_created_date":"2021-09-06 15:31:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"107.08","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5309541","reservation_id":"120296","confirmation_number":"PB12360196366","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.00,169.00","nightly_discount":"0.00,0.00","subtotal":"334.00","grand_total":"377.42","paid_amount":"377.42","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"127560","customer_id":"127560","source_of_creation":"PMS","reservation_created_date":"2021-07-28 20:21:13","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"165.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":"5309615","reservation_id":"122647","confirmation_number":"BV12499982069","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.20,117.20","nightly_discount":"0.00,0.00","subtotal":"234.40","grand_total":"264.87","paid_amount":"264.87","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":"130283","customer_id":"130283","source_of_creation":"PMS","reservation_created_date":"2021-09-06 20:20:29","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":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"117.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":"5309667","reservation_id":"122507","confirmation_number":"BV12410076400","room_stay_from":"2021-09-06","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"66.17,66.00,66.00,66.00","nightly_discount":"0.00,0.00,16.43,0.00","subtotal":"264.17","grand_total":"279.94","paid_amount":"279.94","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130295","customer_id":"130295","source_of_creation":"PMS","reservation_created_date":"2021-09-04 15:11:30","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"66.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":"5309800","reservation_id":"122602","confirmation_number":"PB12369625068","room_stay_from":"2021-09-07","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.46,100.46,100.46,152.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"453.38","grand_total":"512.32","paid_amount":"512.32","room_type_id":"289","product_id":"1100","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":"130237","customer_id":"130237","source_of_creation":"PMS","reservation_created_date":"2021-09-07 12:42:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"100.46","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5309977","reservation_id":"119558","confirmation_number":"PB12353880243","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"140.00","nightly_discount":"0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126735","customer_id":"126735","source_of_creation":"PMS","reservation_created_date":"2021-07-18 02:41:43","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","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":"5310137","reservation_id":"122436","confirmation_number":"BP12590730386","room_stay_from":"2021-09-06","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.65,83.65,83.65","nightly_discount":"0.00,0,0","subtotal":"250.95","grand_total":"283.58","paid_amount":"283.58","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":"129853","customer_id":"129853","source_of_creation":"PMS","reservation_created_date":"2021-09-02 22:08:22","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":"","promotion_code":"","sub_hotel_id":"124","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"83.65","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":"5310162","reservation_id":"122688","confirmation_number":"BP12587245327","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.00,60.00,60.00","nightly_discount":"0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","room_type_id":"295","product_id":"1129","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":"130336","customer_id":"130336","source_of_creation":"PMS","reservation_created_date":"2021-09-07 16:28:18","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","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":"5310261","reservation_id":"122699","confirmation_number":"BV12476489966","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"68.00","nightly_discount":"0.00","subtotal":"68.00","grand_total":"76.84","paid_amount":"76.84","room_type_id":"303","product_id":"1139","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":"130348","customer_id":"130348","source_of_creation":"PMS","reservation_created_date":"2021-09-07 19:15:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"68.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":"5309798","reservation_id":"122602","confirmation_number":"BV12416966207","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.93","nightly_discount":"0.00","subtotal":"92.93","grand_total":"105.02","paid_amount":"105.02","room_type_id":"304","product_id":"1220","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":"130237","customer_id":"130237","source_of_creation":"PMS","reservation_created_date":"2021-09-05 21:57:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","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":"5310141","reservation_id":"116958","confirmation_number":"BV12467429418","room_stay_from":"2021-09-16","room_stay_to":"2021-09-20","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.00,163.00,143.00,143.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"612.00","grand_total":"691.56","paid_amount":"184.19","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":"123885","customer_id":"123885","source_of_creation":"PMS","reservation_created_date":"2021-06-10 16:57: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":"","promotion_code":"","sub_hotel_id":"124","changedComment":"From 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":"5294481","reservation_id":"121870","confirmation_number":"BP12552914424","room_stay_from":"2021-09-06","room_stay_to":"2021-09-23","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,95.00,85.00,85.00,125.00,125.00,85.00,85.00,85.00,85.00,85.00,125.00,125.00,85.00,85.00,85.00,85.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","subtotal":"1630.00","grand_total":"1841.90","paid_amount":"0.00","room_type_id":"301","product_id":"1137","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":"129363","customer_id":"129363","source_of_creation":"PMS","reservation_created_date":"2021-08-24 23:06:02","service_canceled_date_time":"2021-09-07 21:18:06","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 824","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"","total_paid_amount":"0.00","sub_hotel_id":"125","deltaChange":-100,"changedComment":"reservation is canceled","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":[{"room_stay_id":"5310207","reservation_id":"122691","confirmation_number":"PB12382911607","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","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":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:49:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310210","reservation_id":"122691","confirmation_number":"PB12327503692","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:49:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310213","reservation_id":"122691","confirmation_number":"PB12323169444","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","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":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:49:34","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310216","reservation_id":"122691","confirmation_number":"PB12399118641","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","room_type_id":"289","product_id":"1106","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:51:30","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310219","reservation_id":"122691","confirmation_number":"PB12352350126","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:51:44","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310222","reservation_id":"122691","confirmation_number":"PB12365500086","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:51:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310225","reservation_id":"122691","confirmation_number":"PB12381602211","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","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":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:52:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310236","reservation_id":"122691","confirmation_number":"PB12374276102","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.00,107.00,107.00","nightly_discount":"0.00,0.00,0.00","subtotal":"321.00","grand_total":"362.73","paid_amount":"362.73","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":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:47:10","service_canceled_date_time":"2021-09-07 20:52:24","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"403.41","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3258736","reservation_id":"116123","confirmation_number":"BV12230812714","room_confirmation_number":"BV12449413854","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","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":"122954","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-05-29 01:20:27","reservation_modified_date_time":"2021-05-29 01:20:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122954","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5178875","reservation_id":"121733","confirmation_number":"BP12224767998","room_confirmation_number":"BP12542082633","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"10.00,10.00","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"129277","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-08-23 01:10:30","reservation_modified_date_time":"2021-08-23 01:10:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129277","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5303836","reservation_id":"105921","confirmation_number":"PB12223125997","room_confirmation_number":"PB12358700519","room_stay_from":"2021-09-05","room_stay_to":"2021-09-10","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"47205","product_attribute_values":"extra_person# ","reservation_created_date":"2021-08-26 19:38:29","reservation_modified_date_time":"2021-08-26 19:38:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47205","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309638","reservation_id":"122651","confirmation_number":"BP12274237723","room_confirmation_number":"BP12537559068","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","room_stay_status":"Active","nightly_price":"20,20,20,20,20","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":"1780","service_quantity":"1","customer_traveller_id":"130289","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-09-06 21:19:06","reservation_modified_date_time":"2021-09-06 21:19:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130289","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"125","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":"5309665","reservation_id":"122507","confirmation_number":"BV12295573870","room_confirmation_number":"BV12410076400","room_stay_from":"2021-09-06","room_stay_to":"2021-09-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,4.00","subtotal":"80.00","grand_total":"85.88","paid_amount":"85.88","product_id":"1780","service_quantity":"1","customer_traveller_id":"130295","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-09-06 16:40:03","reservation_modified_date_time":"2021-09-06 22:02:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130295","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5309938","reservation_id":"122035","confirmation_number":"PB12294949328","room_confirmation_number":"PB12384796841","room_stay_from":"2021-09-03","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"30,30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"130329","product_attribute_values":"extra_person# ","reservation_created_date":"2021-08-28 18:23:45","reservation_modified_date_time":"2021-09-07 14:09:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130329","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"123","currentDayPrice":"30","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":"5309974","reservation_id":"119558","confirmation_number":"PB12224362642","room_confirmation_number":"PB12353880243","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"40","nightly_discount":"0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"126735","product_attribute_values":"extra_person# ","reservation_created_date":"2021-09-01 13:36:42","reservation_modified_date_time":"2021-09-07 14:37:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126735","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310262","reservation_id":"122699","confirmation_number":"BV12233188696","room_confirmation_number":"BV12476489966","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"130348","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-09-07 19:15:12","reservation_modified_date_time":"2021-09-07 19:15:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130348","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5310350","reservation_id":"122014","confirmation_number":"PB12242385936","room_confirmation_number":"PB12347951719","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","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":"1780","service_quantity":"1","customer_traveller_id":"130369","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-09-07 15:02:01","reservation_modified_date_time":"2021-09-08 01:01:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130369","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310121","reservation_id":"122556","confirmation_number":"PB12238860747","room_confirmation_number":"PB12338107996","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"130287","product_attribute_values":"extra_person# ","reservation_created_date":"2021-09-07 15:37:29","reservation_modified_date_time":"2021-09-07 15:37:29","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130287","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3258735","reservation_id":"116123","confirmation_number":"BV12276595304","room_confirmation_number":"BV12449413854","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","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":"122954","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-05-29 01:20:27","reservation_modified_date_time":"2021-05-29 01:20:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122954","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"3299933","reservation_id":"119756","confirmation_number":"PB12267640322","room_confirmation_number":"PB12341583321","room_stay_from":"2021-09-02","room_stay_to":"2021-09-10","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":"44919","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-07-21 01:00:08","reservation_modified_date_time":"2021-08-07 23:56:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44919","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5178874","reservation_id":"121733","confirmation_number":"BP12236213494","room_confirmation_number":"BP12542082633","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","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":"129277","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-08-23 01:10:30","reservation_modified_date_time":"2021-08-23 01:10:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129277","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5307254","reservation_id":"121644","confirmation_number":"PB12272549785","room_confirmation_number":"PB12375066657","room_stay_from":"2021-09-05","room_stay_to":"2021-09-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":"129111","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-08-21 15:39:36","reservation_modified_date_time":"2021-09-01 13:36:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129111","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5307996","reservation_id":"122390","confirmation_number":"PB12230333914","room_confirmation_number":"PB12352370296","room_stay_from":"2021-09-04","room_stay_to":"2021-09-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":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"129982","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-02 02:38:02","reservation_modified_date_time":"2021-09-03 00:57:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129982","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5308099","reservation_id":"122459","confirmation_number":"PB12250975947","room_confirmation_number":"PB12337381879","room_stay_from":"2021-09-04","room_stay_to":"2021-09-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":"130057","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-03 11:54:14","reservation_modified_date_time":"2021-09-03 11:54:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130057","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5308251","reservation_id":"122448","confirmation_number":"PB12257547611","room_confirmation_number":"PB12333574291","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"130043","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-03 01:21:34","reservation_modified_date_time":"2021-09-03 19:03:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130043","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5308659","reservation_id":"116694","confirmation_number":"PB12234448200","room_confirmation_number":"PB12337007929","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"70.39","product_id":"1781","service_quantity":"1","customer_traveller_id":"130134","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-07 00:45:10","reservation_modified_date_time":"2021-09-04 18:55:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130134","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5308706","reservation_id":"121059","confirmation_number":"PB12252365037","room_confirmation_number":"PB12335945544","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"127248","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-08-11 17:05:06","reservation_modified_date_time":"2021-09-04 21:22:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127248","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5308874","reservation_id":"122412","confirmation_number":"BP12249776741","room_confirmation_number":"BP12555256120","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"20,20,20,20","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":"130177","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-02 15:09:10","reservation_modified_date_time":"2021-09-05 01:37:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130177","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5309238","reservation_id":"105921","confirmation_number":"PB12276984093","room_confirmation_number":"PB12358700519","room_stay_from":"2021-09-05","room_stay_to":"2021-09-10","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":"47205","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-01-23 11:12:10","reservation_modified_date_time":"2021-09-05 19:17:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47205","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309389","reservation_id":"120831","confirmation_number":"PB12254521355","room_confirmation_number":"PB12378251203","room_stay_from":"2021-09-06","room_stay_to":"2021-09-10","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":"128224","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-08-06 15:59:39","reservation_modified_date_time":"2021-09-06 15:01:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128224","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309404","reservation_id":"121939","confirmation_number":"PB12278346126","room_confirmation_number":"PB12390181805","room_stay_from":"2021-09-06","room_stay_to":"2021-09-11","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":"129479","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-06 15:03:29","reservation_modified_date_time":"2021-09-06 15:03:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129479","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309417","reservation_id":"122624","confirmation_number":"PB12222969394","room_confirmation_number":"PB12379242493","room_stay_from":"2021-09-06","room_stay_to":"2021-09-09","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":"130261","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-06 15:31:33","reservation_modified_date_time":"2021-09-06 15:31:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130261","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309542","reservation_id":"120296","confirmation_number":"PB12271392657","room_confirmation_number":"PB12360196366","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"127560","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-07-28 20:21:13","reservation_modified_date_time":"2021-09-06 17:17:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127560","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309550","reservation_id":"122630","confirmation_number":"PB12262016172","room_confirmation_number":"PB12324555467","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","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":"130268","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-06 17:14:17","reservation_modified_date_time":"2021-09-06 17:28:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130268","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309566","reservation_id":"122431","confirmation_number":"PB12218098932","room_confirmation_number":"PB12362564908","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","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":"130271","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-02 20:26:08","reservation_modified_date_time":"2021-09-06 18:17:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130271","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309616","reservation_id":"122647","confirmation_number":"BV12296780702","room_confirmation_number":"BV12499982069","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"130283","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-06 20:20:29","reservation_modified_date_time":"2021-09-06 20:20:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130283","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5309639","reservation_id":"122651","confirmation_number":"BP12213950169","room_confirmation_number":"BP12537559068","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","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":"130289","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-06 21:19:06","reservation_modified_date_time":"2021-09-06 21:19:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130289","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"125","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":"5309640","reservation_id":"122500","confirmation_number":"BP12295004954","room_confirmation_number":"BP12515174829","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","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":"130290","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-04 01:17:09","reservation_modified_date_time":"2021-09-06 21:26:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130290","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5309666","reservation_id":"122507","confirmation_number":"BV12270612942","room_confirmation_number":"BV12410076400","room_stay_from":"2021-09-06","room_stay_to":"2021-09-10","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":"130296","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-04 15:11:30","reservation_modified_date_time":"2021-09-06 22:02:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130295","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5309772","reservation_id":"122674","confirmation_number":"PB12273254803","room_confirmation_number":"PB12344621789","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"130321","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-07 08:44:11","reservation_modified_date_time":"2021-09-07 09:52:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130321","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309801","reservation_id":"122602","confirmation_number":"PB12276815050","room_confirmation_number":"PB12369625068","room_stay_from":"2021-09-07","room_stay_to":"2021-09-11","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":"130237","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-07 12:42:55","reservation_modified_date_time":"2021-09-07 12:42:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130237","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309805","reservation_id":"122645","confirmation_number":"PB12292779123","room_confirmation_number":"PB12328998065","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"20,12.00","nightly_discount":"0.00,0.00","subtotal":"32.00","grand_total":"36.16","paid_amount":"36.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"130299","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-06 19:56:13","reservation_modified_date_time":"2021-09-07 12:43:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130299","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","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":"5309939","reservation_id":"122035","confirmation_number":"PB12229499977","room_confirmation_number":"PB12384796841","room_stay_from":"2021-09-03","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"20,20,20,20,20","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":"130329","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-27 20:35:07","reservation_modified_date_time":"2021-09-07 14:09:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130329","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"123","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":"5309975","reservation_id":"119558","confirmation_number":"PB12270453657","room_confirmation_number":"PB12353880243","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"126735","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-07-18 02:41:43","reservation_modified_date_time":"2021-09-07 14:37:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126735","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310131","reservation_id":"122556","confirmation_number":"PB12225571095","room_confirmation_number":"PB12356858890","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"130287","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-07 15:37:32","reservation_modified_date_time":"2021-09-07 15:38:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130287","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310138","reservation_id":"122436","confirmation_number":"BP12256526668","room_confirmation_number":"BP12590730386","room_stay_from":"2021-09-06","room_stay_to":"2021-09-09","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":"129853","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-02 22:08:22","reservation_modified_date_time":"2021-09-07 15:50:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129853","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","changedComment":"To date changed","deltaChange":"0.00","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":"5310163","reservation_id":"122688","confirmation_number":"BP12290277173","room_confirmation_number":"BP12587245327","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","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":"130336","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-07 16:28:18","reservation_modified_date_time":"2021-09-07 16:28:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130336","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5310191","reservation_id":"122640","confirmation_number":"BV12232080952","room_confirmation_number":"BV12435837985","room_stay_from":"2021-09-06","room_stay_to":"2021-09-09","room_stay_status":"Active","nightly_price":"20,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"44.00","grand_total":"49.72","paid_amount":"29.72","product_id":"1781","service_quantity":"1","customer_traveller_id":"130297","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-06 19:08:13","reservation_modified_date_time":"2021-09-07 16:37:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130297","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","changedComment":"To date changed","deltaChange":"0.00","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":"5310254","reservation_id":"122675","confirmation_number":"BP12296874297","room_confirmation_number":"BP12531867785","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"130345","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-07 09:19:11","reservation_modified_date_time":"2021-09-07 18:51:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130345","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5310258","reservation_id":"122697","confirmation_number":"BP12246517015","room_confirmation_number":"BP12522558392","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"130346","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-07 18:52:14","reservation_modified_date_time":"2021-09-07 18:52:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130346","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5310263","reservation_id":"122699","confirmation_number":"BV12242603446","room_confirmation_number":"BV12476489966","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"130348","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-07 19:15:12","reservation_modified_date_time":"2021-09-07 19:15:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130348","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5310282","reservation_id":"122441","confirmation_number":"BP12247951103","room_confirmation_number":"BP12566073128","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"112612","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-02 22:55:08","reservation_modified_date_time":"2021-09-07 19:43:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112612","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5310289","reservation_id":"120021","confirmation_number":"PB12276576235","room_confirmation_number":"PB12339425825","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","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":"105102","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-07-24 23:36:27","reservation_modified_date_time":"2021-09-07 19:57:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105102","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310293","reservation_id":"122705","confirmation_number":"BP12246425519","room_confirmation_number":"BP12571256678","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"130353","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-07 20:05:10","reservation_modified_date_time":"2021-09-07 20:05:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130353","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5310305","reservation_id":"122671","confirmation_number":"BV12274112413","room_confirmation_number":"BV12452745352","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"130355","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-07 03:19:11","reservation_modified_date_time":"2021-09-07 20:23:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130355","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5310351","reservation_id":"122014","confirmation_number":"PB12227121363","room_confirmation_number":"PB12347951719","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","room_stay_status":"Active","nightly_price":"20,20,20,20,20","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":"130369","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-27 18:18:17","reservation_modified_date_time":"2021-09-08 01:01:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130369","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310363","reservation_id":"122457","confirmation_number":"PB12285883069","room_confirmation_number":"PB12311229106","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"130371","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-03 08:06:12","reservation_modified_date_time":"2021-09-08 02:29:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130371","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309799","reservation_id":"122602","confirmation_number":"BV12242859340","room_confirmation_number":"BV12416966207","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","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":"130237","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-05 21:57:08","reservation_modified_date_time":"2021-09-07 12:42:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130237","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5310122","reservation_id":"122556","confirmation_number":"PB12221092658","room_confirmation_number":"PB12338107996","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","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":"130287","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-05 04:36:11","reservation_modified_date_time":"2021-09-07 15:37:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130287","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310135","reservation_id":"119370","confirmation_number":"PB12259240294","room_confirmation_number":"PB12368864278","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","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":"130334","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-15 05:35:09","reservation_modified_date_time":"2021-09-07 15:43:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130334","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310142","reservation_id":"116958","confirmation_number":"BV12259845547","room_confirmation_number":"BV12467429418","room_stay_from":"2021-09-16","room_stay_to":"2021-09-20","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"123885","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-06-10 16:57:14","reservation_modified_date_time":"2021-09-07 15:57:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123885","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","changedComment":"From 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":"5294482","reservation_id":"121870","confirmation_number":"BP12229663006","room_confirmation_number":"BP12552914424","room_stay_from":"2021-09-06","room_stay_to":"2021-09-23","room_stay_status":"Canceled","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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","subtotal":"204.00","grand_total":"230.52","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 23:06:02","reservation_modified_date_time":"2021-08-24 23:06:02","customer_id":"129363","parentCustTravId":"129363","customer_traveller_id":"129363","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-07 21:18:07","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate# ","parentRoomStayFrom":"2021-09-06","sub_hotel_id":"125","deltaChange":-12,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"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":[{"room_stay_id":"5310123","reservation_id":"122556","confirmation_number":"PB12221092658","room_confirmation_number":"PB12338107996","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","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":"130287","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-05 04:36:11","reservation_modified_date_time":"2021-09-07 15:37:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130287","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"gift_shop_taxable":[{"room_stay_id":"5309810","reservation_id":"122602","confirmation_number":"PB12266965501","room_confirmation_number":"PB12369625068","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 12:48:02","reservation_modified_date_time":"2021-09-07 12:48:02","customer_id":"130237","parentCustTravId":"130237","customer_traveller_id":"130237","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"123","currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5309830","reservation_id":"113854","confirmation_number":"BP12244529817","room_confirmation_number":"BP12564487167","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.20","grand_total":"8.99","paid_amount":"8.99","product_id":"1151","service_quantity":"2","product_name":"Coffee Mug","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-03 18:31:15","reservation_modified_date_time":"2021-09-07 12:52:21","customer_id":"120475","parentCustTravId":"120475","customer_traveller_id":"120949","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","parentRoomStayFrom":"2021-09-02","sub_hotel_id":"125","changedComment":"price, discount or quantity changed","deltaChange":"4.20","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5309976","reservation_id":"119558","confirmation_number":"PB12226497661","room_confirmation_number":"PB12353880243","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":"60.03","paid_amount":"0.00","product_id":"2010","service_quantity":"6","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 14:30:04","reservation_modified_date_time":"2021-09-07 14:37:16","customer_id":"126735","parentCustTravId":"126735","customer_traveller_id":"126735","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"123","currentDayPrice":"56.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5310256","reservation_id":"122675","confirmation_number":"BP12246355709","room_confirmation_number":"BP12531867785","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"45.00","grand_total":"48.15","paid_amount":"48.15","product_id":"1175","service_quantity":"1","product_name":"Miscellaneous","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 18:51:46","reservation_modified_date_time":"2021-09-07 18:51:46","customer_id":"130345","parentCustTravId":"130345","customer_traveller_id":"130345","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"125","currentDayPrice":"45.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5310312","reservation_id":"122448","confirmation_number":"PB12235782181","room_confirmation_number":"PB12333574291","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":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 20:37:32","reservation_modified_date_time":"2021-09-07 20:37:32","customer_id":"130043","parentCustTravId":"130043","customer_traveller_id":"130043","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"123","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":"5310319","reservation_id":"120021","confirmation_number":"PB12230103942","room_confirmation_number":"PB12339425825","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":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 22:20:38","reservation_modified_date_time":"2021-09-07 22:20:38","customer_id":"105102","parentCustTravId":"105102","customer_traveller_id":"105102","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"123","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":"5310321","reservation_id":"122705","confirmation_number":"BP12293206452","room_confirmation_number":"BP12571256678","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":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 22:40:26","reservation_modified_date_time":"2021-09-07 22:40:26","customer_id":"130353","parentCustTravId":"130353","customer_traveller_id":"130353","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"125","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":"5310346","reservation_id":"121059","confirmation_number":"PB12285916868","room_confirmation_number":"PB12335945544","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":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-08 00:52:47","reservation_modified_date_time":"2021-09-08 00:52:47","customer_id":"127248","parentCustTravId":"127248","customer_traveller_id":"127248","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"123","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":"5310269","reservation_id":"122700","confirmation_number":"PB12221876147","room_confirmation_number":"PB12313910207","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 19:22:15","reservation_modified_date_time":"2021-09-07 19:22:15","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"123","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5310358","reservation_id":"122719","confirmation_number":"PB12219714411","room_confirmation_number":"PB12392166531","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.34","grand_total":"5.00","paid_amount":"5.00","product_id":"1205","service_quantity":"2","product_name":"Toothbrush","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-08 01:58:08","reservation_modified_date_time":"2021-09-08 01:58:08","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"123","currentDayPrice":"4.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5310360","reservation_id":"122720","confirmation_number":"PB12227618821","room_confirmation_number":"PB12350115898","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"4.00","paid_amount":"4.00","product_id":"1213","service_quantity":"4","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-08 01:58:27","reservation_modified_date_time":"2021-09-08 01:58:27","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"123","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5309286","reservation_id":"122560","confirmation_number":"PB12220026817","room_confirmation_number":"PB12390510532","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-05 21:33:26","reservation_modified_date_time":"2021-09-05 21:33:26","customer_id":"130231","parentCustTravId":"130231","customer_traveller_id":"130231","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-07 12:16:19","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-09-05","sub_hotel_id":"123","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5309570","reservation_id":"122630","confirmation_number":"PB12258310440","room_confirmation_number":"PB12324555467","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-06 18:19:34","reservation_modified_date_time":"2021-09-06 18:19:34","customer_id":"130268","parentCustTravId":"130268","customer_traveller_id":"130268","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-07 18:27:21","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-09-06","sub_hotel_id":"123","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5309676","reservation_id":"122556","confirmation_number":"PB12232855180","room_confirmation_number":"PB12338107996","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-06 22:19:09","reservation_modified_date_time":"2021-09-06 22:19:09","customer_id":"130287","parentCustTravId":"130287","customer_traveller_id":"130287","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-07 15:17:51","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-09-06","sub_hotel_id":"123","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5309683","reservation_id":"122628","confirmation_number":"BP12290489791","room_confirmation_number":"BP12562051707","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-06 23:02:19","reservation_modified_date_time":"2021-09-06 23:02:19","customer_id":"130292","parentCustTravId":"130292","customer_traveller_id":"130292","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-07 15:34:07","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-09-06","sub_hotel_id":"125","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5309718","reservation_id":"122649","confirmation_number":"PB12251827450","room_confirmation_number":"PB12371257132","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-06 23:47:37","reservation_modified_date_time":"2021-09-06 23:47:37","customer_id":"130286","parentCustTravId":"130286","customer_traveller_id":"130286","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-07 15:04:53","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-09-06","sub_hotel_id":"123","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120","departureCount":13,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1114","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12295714485","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","bundle_room":"0","product_id":"1114"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5308098","reservation_id":"122459","confirmation_number":"PB12337381879","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"670.55,421.18,142.15,142.15","nightly_discount":"0,0,0,0","subtotal":"1376.03","grand_total":"1554.91","paid_amount":"1554.91","room_type_id":"291","product_id":"1116","siteminder_id":"BDC-3112625374","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":"130057","customer_id":"130057","source_of_creation":"Booking.com","reservation_created_date":"2021-09-03 11:54:14","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"218.40","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"142.15","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":"5309773","reservation_id":"122674","confirmation_number":"PB12344621789","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"102.29","nightly_discount":"0","subtotal":"102.29","grand_total":"115.59","paid_amount":"115.59","room_type_id":"289","product_id":"1097","siteminder_id":"BDC-2374393522","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":"130321","customer_id":"130321","source_of_creation":"Booking.com","reservation_created_date":"2021-09-07 08:44:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"18.34","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"102.29","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":"5310352","reservation_id":"122014","confirmation_number":"PB12347951719","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"191.23,191.23,191.23,150.57,150.57","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"874.83","grand_total":"988.56","paid_amount":"988.56","room_type_id":"289","product_id":"1102","siteminder_id":"BDC-3043750611","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":"130369","customer_id":"130369","source_of_creation":"Booking.com","reservation_created_date":"2021-08-27 18:18:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"146.20","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"191.23","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5309551","reservation_id":"122630","confirmation_number":"PB12324555467","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.35,83.35","nightly_discount":"0,0","subtotal":"166.70","grand_total":"188.37","paid_amount":"188.37","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1826287800","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":"130268","customer_id":"130268","source_of_creation":"Expedia","reservation_created_date":"2021-09-06 17:14:17","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"83.35","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":"5309567","reservation_id":"122431","confirmation_number":"PB12362564908","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.98,83.98","nightly_discount":"0,0","subtotal":"167.96","grand_total":"189.80","paid_amount":"189.80","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1824707525","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":"130271","customer_id":"130271","source_of_creation":"Expedia","reservation_created_date":"2021-09-02 20:26:08","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":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"83.98","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5309804","reservation_id":"122645","confirmation_number":"PB12328998065","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.24,97.24","nightly_discount":"0,0","subtotal":"194.48","grand_total":"219.76","paid_amount":"219.76","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1826356521","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":"130299","customer_id":"130299","source_of_creation":"Expedia","reservation_created_date":"2021-09-06 19:56:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"97.24","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":"5309940","reservation_id":"122035","confirmation_number":"PB12384796841","room_stay_from":"2021-09-03","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"311.89,311.89,291.13,196.97,196.97","nightly_discount":"0,0,0,0,0","subtotal":"1308.85","grand_total":"1479.00","paid_amount":"1479.00","room_type_id":"288","product_id":"1091","siteminder_id":"EXP-1822068811","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130329","customer_id":"130329","source_of_creation":"Expedia","reservation_created_date":"2021-08-27 20:35:07","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"235.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"196.97","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":"5310129","reservation_id":"122556","confirmation_number":"PB12356858890","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"98.2,98.2","nightly_discount":"0,0","subtotal":"196.40","grand_total":"221.93","paid_amount":"221.94","room_type_id":"291","product_id":"1115","siteminder_id":"EXP-1825737867","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":"130287","customer_id":"130287","source_of_creation":"Expedia","reservation_created_date":"2021-09-07 15:37:32","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":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"98.2","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":"5310364","reservation_id":"122457","confirmation_number":"PB12311229106","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.59,90.59","nightly_discount":"0,0","subtotal":"181.18","grand_total":"204.73","paid_amount":"204.73","room_type_id":"289","product_id":"1123","siteminder_id":"EXP-1824933541","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":"130371","customer_id":"130371","source_of_creation":"Expedia","reservation_created_date":"2021-09-03 08:06:12","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":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"90.59","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":"5310120","reservation_id":"122556","confirmation_number":"PB12338107996","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","room_stay_status":"Checked-Out","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"98.2","nightly_discount":"0","subtotal":"98.20","grand_total":"110.96","paid_amount":"110.96","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1825737867","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":"130287","customer_id":"130287","source_of_creation":"Expedia","reservation_created_date":"2021-09-05 04:36:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","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":"5310136","reservation_id":"119370","confirmation_number":"PB12368864278","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.42","nightly_discount":"0","subtotal":"116.42","grand_total":"131.56","paid_amount":"131.56","room_type_id":"291","product_id":"1119","siteminder_id":"EXP-1801225389","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":"130334","customer_id":"130334","source_of_creation":"Expedia","reservation_created_date":"2021-07-15 05:35:09","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":"","promotion_code":"","sub_hotel_id":"123","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"}]}],"exp_non_taxable":[{"room_stay_id":"5310228","reservation_id":"122692","confirmation_number":"PB12364276863","room_stay_from":"2021-09-07","room_stay_to":"2021-09-11","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.89,111.89,111.89,146.61","nightly_discount":"0,0,0,0","subtotal":"482.28","grand_total":"544.98","paid_amount":"544.98","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1826740839","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":"130342","customer_id":"130342","source_of_creation":"Expedia","reservation_created_date":"2021-09-07 17:39:09","service_canceled_date_time":"2021-09-07 22:44:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"544.98","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5308657","reservation_id":"116694","confirmation_number":"PB12337007929","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"266.21,243.93,96.80,96.80","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"703.74","grand_total":"795.22","paid_amount":"795.22","room_type_id":"292","product_id":"1120","siteminder_id":"GAM-R2573467940","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":"130134","customer_id":"130134","source_of_creation":"Getaroom.com","reservation_created_date":"2021-06-07 00:45:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"96.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":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"5307995","reservation_id":"122390","confirmation_number":"PB12352370296","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"610.73,347.17,179.96,179.96","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1317.82","grand_total":"1489.14","paid_amount":"1489.14","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":"129982","customer_id":"129982","source_of_creation":"FE","reservation_created_date":"2021-09-02 02:38:01","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"179.96","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5308250","reservation_id":"122448","confirmation_number":"PB12333574291","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.29,194.29","nightly_discount":"0.00,0.00","subtotal":"388.58","grand_total":"439.09","paid_amount":"439.09","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":"130043","customer_id":"130043","source_of_creation":"FE","reservation_created_date":"2021-09-03 01:21:34","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"194.29","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5309237","reservation_id":"105921","confirmation_number":"PB12358700519","room_stay_from":"2021-09-05","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00,29.00","subtotal":"650.00","grand_total":"701.73","paid_amount":"701.73","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":"47205","customer_id":"47205","source_of_creation":"FE","reservation_created_date":"2021-01-23 11:12:10","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"130.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":"5309388","reservation_id":"120831","confirmation_number":"PB12378251203","room_stay_from":"2021-09-06","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"278.58,278.58,278.58,278.58","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"1114.32","grand_total":"1259.18","paid_amount":"1259.18","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"128224","customer_id":"128224","source_of_creation":"FE","reservation_created_date":"2021-08-06 15:59:39","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"278.58","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5309403","reservation_id":"121939","confirmation_number":"PB12390181805","room_stay_from":"2021-09-06","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"278.58,278.58,278.58,278.58,221.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1335.32","grand_total":"1508.91","paid_amount":"1508.91","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129479","customer_id":"129479","source_of_creation":"FE","reservation_created_date":"2021-09-06 15:03:29","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"278.58","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5310288","reservation_id":"120021","confirmation_number":"PB12339425825","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"97.02,97.02,97.02","nightly_discount":"0.00,0.00,12.34","subtotal":"291.06","grand_total":"314.95","paid_amount":"314.95","room_type_id":"285","product_id":"1084","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":"105102","customer_id":"105102","source_of_creation":"FE","reservation_created_date":"2021-07-24 23:36:27","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":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"97.02","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3299932","reservation_id":"119756","confirmation_number":"PB12341583321","room_stay_from":"2021-09-02","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00,130.00,130.00,130.00,130.00","nightly_discount":"0.00,0.00,0.00,0.00,0,0,0,0","subtotal":"1040.00","grand_total":"1175.20","paid_amount":"1175.20","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":"44919","customer_id":"44919","source_of_creation":"PMS","reservation_created_date":"2021-07-21 01:00:08","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"130.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":"5307253","reservation_id":"121644","confirmation_number":"PB12375066657","room_stay_from":"2021-09-05","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"203.00,203.00,203.00","nightly_discount":"0.00,0.00,0.00","subtotal":"609.00","grand_total":"688.17","paid_amount":"688.17","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129111","customer_id":"129111","source_of_creation":"PMS","reservation_created_date":"2021-08-21 15:39:36","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"203.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":"5308705","reservation_id":"121059","confirmation_number":"PB12335945544","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"194.04,194.04","nightly_discount":"0.00,0.00","subtotal":"388.08","grand_total":"438.53","paid_amount":"438.53","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":"127248","customer_id":"127248","source_of_creation":"PMS","reservation_created_date":"2021-08-11 17:05:06","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"194.04","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5309416","reservation_id":"122624","confirmation_number":"PB12379242493","room_stay_from":"2021-09-06","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","room_type_id":"289","product_id":"1110","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130261","customer_id":"130261","source_of_creation":"PMS","reservation_created_date":"2021-09-06 15:31:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"107.08","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5309541","reservation_id":"120296","confirmation_number":"PB12360196366","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.00,169.00","nightly_discount":"0.00,0.00","subtotal":"334.00","grand_total":"377.42","paid_amount":"377.42","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"127560","customer_id":"127560","source_of_creation":"PMS","reservation_created_date":"2021-07-28 20:21:13","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"165.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":"5309800","reservation_id":"122602","confirmation_number":"PB12369625068","room_stay_from":"2021-09-07","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.46,100.46,100.46,152.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"453.38","grand_total":"512.32","paid_amount":"512.32","room_type_id":"289","product_id":"1100","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":"130237","customer_id":"130237","source_of_creation":"PMS","reservation_created_date":"2021-09-07 12:42:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"100.46","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5309977","reservation_id":"119558","confirmation_number":"PB12353880243","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"140.00","nightly_discount":"0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126735","customer_id":"126735","source_of_creation":"PMS","reservation_created_date":"2021-07-18 02:41:43","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","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"}]}],"pms_non_taxable":[{"room_stay_id":"5310207","reservation_id":"122691","confirmation_number":"PB12382911607","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","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":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:49:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310210","reservation_id":"122691","confirmation_number":"PB12327503692","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:49:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310213","reservation_id":"122691","confirmation_number":"PB12323169444","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","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":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:49:34","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310216","reservation_id":"122691","confirmation_number":"PB12399118641","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","room_type_id":"289","product_id":"1106","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:51:30","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310219","reservation_id":"122691","confirmation_number":"PB12352350126","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:51:44","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310222","reservation_id":"122691","confirmation_number":"PB12365500086","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:51:58","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310225","reservation_id":"122691","confirmation_number":"PB12381602211","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"107.08,107.08,107.08","nightly_discount":"0.00,0.00,0.00","subtotal":"321.24","grand_total":"363.00","paid_amount":"363.00","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":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:32:35","service_canceled_date_time":"2021-09-07 20:52:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"437.58","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5310236","reservation_id":"122691","confirmation_number":"PB12374276102","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.00,107.00,107.00","nightly_discount":"0.00,0.00,0.00","subtotal":"321.00","grand_total":"362.73","paid_amount":"362.73","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":"130339","customer_id":"130339","source_of_creation":"PMS","reservation_created_date":"2021-09-07 17:47:10","service_canceled_date_time":"2021-09-07 20:52:24","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"403.41","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5303836","reservation_id":"105921","confirmation_number":"PB12223125997","room_confirmation_number":"PB12358700519","room_stay_from":"2021-09-05","room_stay_to":"2021-09-10","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"47205","product_attribute_values":"extra_person# ","reservation_created_date":"2021-08-26 19:38:29","reservation_modified_date_time":"2021-08-26 19:38:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47205","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309938","reservation_id":"122035","confirmation_number":"PB12294949328","room_confirmation_number":"PB12384796841","room_stay_from":"2021-09-03","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"30,30,30,30,30","nightly_discount":"0.00,0.00,0.00,0.00,0","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"130329","product_attribute_values":"extra_person# ","reservation_created_date":"2021-08-28 18:23:45","reservation_modified_date_time":"2021-09-07 14:09:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130329","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"123","currentDayPrice":"30","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":"5309974","reservation_id":"119558","confirmation_number":"PB12224362642","room_confirmation_number":"PB12353880243","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"40","nightly_discount":"0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"126735","product_attribute_values":"extra_person# ","reservation_created_date":"2021-09-01 13:36:42","reservation_modified_date_time":"2021-09-07 14:37:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126735","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310350","reservation_id":"122014","confirmation_number":"PB12242385936","room_confirmation_number":"PB12347951719","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","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":"1780","service_quantity":"1","customer_traveller_id":"130369","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-09-07 15:02:01","reservation_modified_date_time":"2021-09-08 01:01:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130369","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310121","reservation_id":"122556","confirmation_number":"PB12238860747","room_confirmation_number":"PB12338107996","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"130287","product_attribute_values":"extra_person# ","reservation_created_date":"2021-09-07 15:37:29","reservation_modified_date_time":"2021-09-07 15:37:29","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130287","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3299933","reservation_id":"119756","confirmation_number":"PB12267640322","room_confirmation_number":"PB12341583321","room_stay_from":"2021-09-02","room_stay_to":"2021-09-10","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":"44919","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-07-21 01:00:08","reservation_modified_date_time":"2021-08-07 23:56:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44919","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5307254","reservation_id":"121644","confirmation_number":"PB12272549785","room_confirmation_number":"PB12375066657","room_stay_from":"2021-09-05","room_stay_to":"2021-09-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":"129111","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-08-21 15:39:36","reservation_modified_date_time":"2021-09-01 13:36:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129111","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5307996","reservation_id":"122390","confirmation_number":"PB12230333914","room_confirmation_number":"PB12352370296","room_stay_from":"2021-09-04","room_stay_to":"2021-09-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":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"129982","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-02 02:38:02","reservation_modified_date_time":"2021-09-03 00:57:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129982","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5308099","reservation_id":"122459","confirmation_number":"PB12250975947","room_confirmation_number":"PB12337381879","room_stay_from":"2021-09-04","room_stay_to":"2021-09-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":"130057","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-03 11:54:14","reservation_modified_date_time":"2021-09-03 11:54:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130057","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5308251","reservation_id":"122448","confirmation_number":"PB12257547611","room_confirmation_number":"PB12333574291","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"130043","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-03 01:21:34","reservation_modified_date_time":"2021-09-03 19:03:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130043","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5308659","reservation_id":"116694","confirmation_number":"PB12234448200","room_confirmation_number":"PB12337007929","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"70.39","product_id":"1781","service_quantity":"1","customer_traveller_id":"130134","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-07 00:45:10","reservation_modified_date_time":"2021-09-04 18:55:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130134","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5308706","reservation_id":"121059","confirmation_number":"PB12252365037","room_confirmation_number":"PB12335945544","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"127248","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-08-11 17:05:06","reservation_modified_date_time":"2021-09-04 21:22:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127248","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309238","reservation_id":"105921","confirmation_number":"PB12276984093","room_confirmation_number":"PB12358700519","room_stay_from":"2021-09-05","room_stay_to":"2021-09-10","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":"47205","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-01-23 11:12:10","reservation_modified_date_time":"2021-09-05 19:17:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47205","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309389","reservation_id":"120831","confirmation_number":"PB12254521355","room_confirmation_number":"PB12378251203","room_stay_from":"2021-09-06","room_stay_to":"2021-09-10","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":"128224","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-08-06 15:59:39","reservation_modified_date_time":"2021-09-06 15:01:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128224","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309404","reservation_id":"121939","confirmation_number":"PB12278346126","room_confirmation_number":"PB12390181805","room_stay_from":"2021-09-06","room_stay_to":"2021-09-11","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":"129479","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-06 15:03:29","reservation_modified_date_time":"2021-09-06 15:03:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129479","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309417","reservation_id":"122624","confirmation_number":"PB12222969394","room_confirmation_number":"PB12379242493","room_stay_from":"2021-09-06","room_stay_to":"2021-09-09","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":"130261","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-06 15:31:33","reservation_modified_date_time":"2021-09-06 15:31:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130261","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309542","reservation_id":"120296","confirmation_number":"PB12271392657","room_confirmation_number":"PB12360196366","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"127560","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-07-28 20:21:13","reservation_modified_date_time":"2021-09-06 17:17:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127560","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309550","reservation_id":"122630","confirmation_number":"PB12262016172","room_confirmation_number":"PB12324555467","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","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":"130268","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-06 17:14:17","reservation_modified_date_time":"2021-09-06 17:28:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130268","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309566","reservation_id":"122431","confirmation_number":"PB12218098932","room_confirmation_number":"PB12362564908","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","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":"130271","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-02 20:26:08","reservation_modified_date_time":"2021-09-06 18:17:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130271","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309772","reservation_id":"122674","confirmation_number":"PB12273254803","room_confirmation_number":"PB12344621789","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"130321","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-07 08:44:11","reservation_modified_date_time":"2021-09-07 09:52:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130321","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309801","reservation_id":"122602","confirmation_number":"PB12276815050","room_confirmation_number":"PB12369625068","room_stay_from":"2021-09-07","room_stay_to":"2021-09-11","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":"130237","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-07 12:42:55","reservation_modified_date_time":"2021-09-07 12:42:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130237","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5309805","reservation_id":"122645","confirmation_number":"PB12292779123","room_confirmation_number":"PB12328998065","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"20,12.00","nightly_discount":"0.00,0.00","subtotal":"32.00","grand_total":"36.16","paid_amount":"36.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"130299","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-06 19:56:13","reservation_modified_date_time":"2021-09-07 12:43:21","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130299","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","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":"5309939","reservation_id":"122035","confirmation_number":"PB12229499977","room_confirmation_number":"PB12384796841","room_stay_from":"2021-09-03","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"20,20,20,20,20","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":"130329","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-27 20:35:07","reservation_modified_date_time":"2021-09-07 14:09:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130329","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"123","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":"5309975","reservation_id":"119558","confirmation_number":"PB12270453657","room_confirmation_number":"PB12353880243","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"126735","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-07-18 02:41:43","reservation_modified_date_time":"2021-09-07 14:37:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126735","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310131","reservation_id":"122556","confirmation_number":"PB12225571095","room_confirmation_number":"PB12356858890","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"130287","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-07 15:37:32","reservation_modified_date_time":"2021-09-07 15:38:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130287","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310289","reservation_id":"120021","confirmation_number":"PB12276576235","room_confirmation_number":"PB12339425825","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","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":"105102","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-07-24 23:36:27","reservation_modified_date_time":"2021-09-07 19:57:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"105102","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310351","reservation_id":"122014","confirmation_number":"PB12227121363","room_confirmation_number":"PB12347951719","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","room_stay_status":"Active","nightly_price":"20,20,20,20,20","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":"130369","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-27 18:18:17","reservation_modified_date_time":"2021-09-08 01:01:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130369","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310363","reservation_id":"122457","confirmation_number":"PB12285883069","room_confirmation_number":"PB12311229106","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"130371","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-03 08:06:12","reservation_modified_date_time":"2021-09-08 02:29:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130371","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310122","reservation_id":"122556","confirmation_number":"PB12221092658","room_confirmation_number":"PB12338107996","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","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":"130287","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-05 04:36:11","reservation_modified_date_time":"2021-09-07 15:37:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130287","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5310135","reservation_id":"119370","confirmation_number":"PB12259240294","room_confirmation_number":"PB12368864278","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","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":"130334","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-15 05:35:09","reservation_modified_date_time":"2021-09-07 15:43:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130334","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"5310123","reservation_id":"122556","confirmation_number":"PB12221092658","room_confirmation_number":"PB12338107996","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","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":"130287","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-05 04:36:11","reservation_modified_date_time":"2021-09-07 15:37:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130287","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"gift_shop_taxable":[{"room_stay_id":"5309810","reservation_id":"122602","confirmation_number":"PB12266965501","room_confirmation_number":"PB12369625068","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 12:48:02","reservation_modified_date_time":"2021-09-07 12:48:02","customer_id":"130237","parentCustTravId":"130237","customer_traveller_id":"130237","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"123","currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5309976","reservation_id":"119558","confirmation_number":"PB12226497661","room_confirmation_number":"PB12353880243","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":"60.03","paid_amount":"0.00","product_id":"2010","service_quantity":"6","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 14:30:04","reservation_modified_date_time":"2021-09-07 14:37:16","customer_id":"126735","parentCustTravId":"126735","customer_traveller_id":"126735","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"123","currentDayPrice":"56.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5310312","reservation_id":"122448","confirmation_number":"PB12235782181","room_confirmation_number":"PB12333574291","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":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 20:37:32","reservation_modified_date_time":"2021-09-07 20:37:32","customer_id":"130043","parentCustTravId":"130043","customer_traveller_id":"130043","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"123","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":"5310319","reservation_id":"120021","confirmation_number":"PB12230103942","room_confirmation_number":"PB12339425825","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":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 22:20:38","reservation_modified_date_time":"2021-09-07 22:20:38","customer_id":"105102","parentCustTravId":"105102","customer_traveller_id":"105102","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"123","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":"5310346","reservation_id":"121059","confirmation_number":"PB12285916868","room_confirmation_number":"PB12335945544","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":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-08 00:52:47","reservation_modified_date_time":"2021-09-08 00:52:47","customer_id":"127248","parentCustTravId":"127248","customer_traveller_id":"127248","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"123","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":"5310269","reservation_id":"122700","confirmation_number":"PB12221876147","room_confirmation_number":"PB12313910207","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 19:22:15","reservation_modified_date_time":"2021-09-07 19:22:15","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"123","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5310358","reservation_id":"122719","confirmation_number":"PB12219714411","room_confirmation_number":"PB12392166531","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.34","grand_total":"5.00","paid_amount":"5.00","product_id":"1205","service_quantity":"2","product_name":"Toothbrush","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-08 01:58:08","reservation_modified_date_time":"2021-09-08 01:58:08","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"123","currentDayPrice":"4.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5310360","reservation_id":"122720","confirmation_number":"PB12227618821","room_confirmation_number":"PB12350115898","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"4.00","paid_amount":"4.00","product_id":"1213","service_quantity":"4","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-08 01:58:27","reservation_modified_date_time":"2021-09-08 01:58:27","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"123","currentDayPrice":"3.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5309286","reservation_id":"122560","confirmation_number":"PB12220026817","room_confirmation_number":"PB12390510532","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-05 21:33:26","reservation_modified_date_time":"2021-09-05 21:33:26","customer_id":"130231","parentCustTravId":"130231","customer_traveller_id":"130231","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-07 12:16:19","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-09-05","sub_hotel_id":"123","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5309570","reservation_id":"122630","confirmation_number":"PB12258310440","room_confirmation_number":"PB12324555467","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-06 18:19:34","reservation_modified_date_time":"2021-09-06 18:19:34","customer_id":"130268","parentCustTravId":"130268","customer_traveller_id":"130268","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-07 18:27:21","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-09-06","sub_hotel_id":"123","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5309676","reservation_id":"122556","confirmation_number":"PB12232855180","room_confirmation_number":"PB12338107996","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-06 22:19:09","reservation_modified_date_time":"2021-09-06 22:19:09","customer_id":"130287","parentCustTravId":"130287","customer_traveller_id":"130287","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-07 15:17:51","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-09-06","sub_hotel_id":"123","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5309718","reservation_id":"122649","confirmation_number":"PB12251827450","room_confirmation_number":"PB12371257132","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-06 23:47:37","reservation_modified_date_time":"2021-09-06 23:47:37","customer_id":"130286","parentCustTravId":"130286","customer_traveller_id":"130286","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-07 15:04:53","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-09-06","sub_hotel_id":"123","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":5,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1226","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BV12263988354","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","bundle_room":"0","product_id":"1226"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5310190","reservation_id":"122640","confirmation_number":"BV12435837985","room_stay_from":"2021-09-06","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"111.59,95.00,95.00","nightly_discount":"0.00,0.00,0.00","subtotal":"301.59","grand_total":"340.80","paid_amount":"340.80","room_type_id":"306","product_id":"1223","siteminder_id":"BDC-2872249747","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":"130297","customer_id":"130297","source_of_creation":"Booking.com","reservation_created_date":"2021-09-06 19:08:13","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"23.69","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"95.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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"5310306","reservation_id":"122671","confirmation_number":"BV12452745352","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"93.72","nightly_discount":"0","subtotal":"93.72","grand_total":"105.90","paid_amount":"105.90","room_type_id":"304","product_id":"1218","siteminder_id":"EXP-1826511270","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":"130355","customer_id":"130355","source_of_creation":"Expedia","reservation_created_date":"2021-09-07 03:19:11","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"93.72","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":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3258734","reservation_id":"116123","confirmation_number":"BV12449413854","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"262.08,211.68,84.00,84.00,84.00,84.00,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"913.76","grand_total":"1032.55","paid_amount":"1032.55","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":"122954","customer_id":"122954","source_of_creation":"FE","reservation_created_date":"2021-05-29 01:20:27","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":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"84.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":"5309615","reservation_id":"122647","confirmation_number":"BV12499982069","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"117.20,117.20","nightly_discount":"0.00,0.00","subtotal":"234.40","grand_total":"264.87","paid_amount":"264.87","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":"130283","customer_id":"130283","source_of_creation":"PMS","reservation_created_date":"2021-09-06 20:20:29","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":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"117.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":"5309667","reservation_id":"122507","confirmation_number":"BV12410076400","room_stay_from":"2021-09-06","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"66.17,66.00,66.00,66.00","nightly_discount":"0.00,0.00,16.43,0.00","subtotal":"264.17","grand_total":"279.94","paid_amount":"279.94","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130295","customer_id":"130295","source_of_creation":"PMS","reservation_created_date":"2021-09-04 15:11:30","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"66.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":"5310137","reservation_id":"122436","confirmation_number":"BP12590730386","room_stay_from":"2021-09-06","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.65,83.65,83.65","nightly_discount":"0.00,0,0","subtotal":"250.95","grand_total":"283.58","paid_amount":"283.58","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":"129853","customer_id":"129853","source_of_creation":"PMS","reservation_created_date":"2021-09-02 22:08:22","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":"","promotion_code":"","sub_hotel_id":"124","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"83.65","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":"5310261","reservation_id":"122699","confirmation_number":"BV12476489966","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"68.00","nightly_discount":"0.00","subtotal":"68.00","grand_total":"76.84","paid_amount":"76.84","room_type_id":"303","product_id":"1139","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":"130348","customer_id":"130348","source_of_creation":"PMS","reservation_created_date":"2021-09-07 19:15:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"68.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":"5309798","reservation_id":"122602","confirmation_number":"BV12416966207","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.93","nightly_discount":"0.00","subtotal":"92.93","grand_total":"105.02","paid_amount":"105.02","room_type_id":"304","product_id":"1220","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":"130237","customer_id":"130237","source_of_creation":"PMS","reservation_created_date":"2021-09-05 21:57:08","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","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":"5310141","reservation_id":"116958","confirmation_number":"BV12467429418","room_stay_from":"2021-09-16","room_stay_to":"2021-09-20","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"163.00,163.00,143.00,143.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"612.00","grand_total":"691.56","paid_amount":"184.19","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":"123885","customer_id":"123885","source_of_creation":"PMS","reservation_created_date":"2021-06-10 16:57: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":"","promotion_code":"","sub_hotel_id":"124","changedComment":"From 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":"3258736","reservation_id":"116123","confirmation_number":"BV12230812714","room_confirmation_number":"BV12449413854","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","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":"122954","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-05-29 01:20:27","reservation_modified_date_time":"2021-05-29 01:20:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122954","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5309665","reservation_id":"122507","confirmation_number":"BV12295573870","room_confirmation_number":"BV12410076400","room_stay_from":"2021-09-06","room_stay_to":"2021-09-10","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,4.00","subtotal":"80.00","grand_total":"85.88","paid_amount":"85.88","product_id":"1780","service_quantity":"1","customer_traveller_id":"130295","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-09-06 16:40:03","reservation_modified_date_time":"2021-09-06 22:02:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130295","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5310262","reservation_id":"122699","confirmation_number":"BV12233188696","room_confirmation_number":"BV12476489966","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"130348","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-09-07 19:15:12","reservation_modified_date_time":"2021-09-07 19:15:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130348","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3258735","reservation_id":"116123","confirmation_number":"BV12276595304","room_confirmation_number":"BV12449413854","room_stay_from":"2021-09-04","room_stay_to":"2021-09-11","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":"122954","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-05-29 01:20:27","reservation_modified_date_time":"2021-05-29 01:20:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122954","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5309616","reservation_id":"122647","confirmation_number":"BV12296780702","room_confirmation_number":"BV12499982069","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"130283","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-06 20:20:29","reservation_modified_date_time":"2021-09-06 20:20:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130283","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5309666","reservation_id":"122507","confirmation_number":"BV12270612942","room_confirmation_number":"BV12410076400","room_stay_from":"2021-09-06","room_stay_to":"2021-09-10","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":"130296","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-04 15:11:30","reservation_modified_date_time":"2021-09-06 22:02:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130295","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5310138","reservation_id":"122436","confirmation_number":"BP12256526668","room_confirmation_number":"BP12590730386","room_stay_from":"2021-09-06","room_stay_to":"2021-09-09","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":"129853","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-02 22:08:22","reservation_modified_date_time":"2021-09-07 15:50:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129853","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","changedComment":"To date changed","deltaChange":"0.00","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":"5310191","reservation_id":"122640","confirmation_number":"BV12232080952","room_confirmation_number":"BV12435837985","room_stay_from":"2021-09-06","room_stay_to":"2021-09-09","room_stay_status":"Active","nightly_price":"20,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"44.00","grand_total":"49.72","paid_amount":"29.72","product_id":"1781","service_quantity":"1","customer_traveller_id":"130297","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-06 19:08:13","reservation_modified_date_time":"2021-09-07 16:37:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130297","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","changedComment":"To date changed","deltaChange":"0.00","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":"5310263","reservation_id":"122699","confirmation_number":"BV12242603446","room_confirmation_number":"BV12476489966","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"130348","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-07 19:15:12","reservation_modified_date_time":"2021-09-07 19:15:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130348","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5310305","reservation_id":"122671","confirmation_number":"BV12274112413","room_confirmation_number":"BV12452745352","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"130355","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-07 03:19:11","reservation_modified_date_time":"2021-09-07 20:23:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130355","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5309799","reservation_id":"122602","confirmation_number":"BV12242859340","room_confirmation_number":"BV12416966207","room_stay_from":"2021-09-06","room_stay_to":"2021-09-07","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":"130237","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-05 21:57:08","reservation_modified_date_time":"2021-09-07 12:42:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130237","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5310142","reservation_id":"116958","confirmation_number":"BV12259845547","room_confirmation_number":"BV12467429418","room_stay_from":"2021-09-16","room_stay_to":"2021-09-20","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"123885","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-06-10 16:57:14","reservation_modified_date_time":"2021-09-07 15:57:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123885","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"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":10,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1131","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BP12237062750","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","bundle_room":"0","product_id":"1131"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5308875","reservation_id":"122412","confirmation_number":"BP12555256120","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"213.37,195.14,88.13,95.28","nightly_discount":"0,0,0,0","subtotal":"591.92","grand_total":"668.87","paid_amount":"668.87","room_type_id":"294","product_id":"1127","siteminder_id":"BDC-3330536346","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":"130177","customer_id":"130177","source_of_creation":"Booking.com","reservation_created_date":"2021-09-02 15:09:10","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 822","ota_service_fee_amount":"0","commision_charges":"120.96","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"95.28","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":"5310257","reservation_id":"122697","confirmation_number":"BP12522558392","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.58","nightly_discount":"0","subtotal":"106.58","grand_total":"120.43","paid_amount":"120.43","room_type_id":"302","product_id":"1138","siteminder_id":"BDC-2494850049","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":"130346","customer_id":"130346","source_of_creation":"Booking.com","reservation_created_date":"2021-09-07 18:52:14","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"22.78","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"106.58","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":"5310283","reservation_id":"122441","confirmation_number":"BP12566073128","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.71,84.71","nightly_discount":"0,0","subtotal":"169.42","grand_total":"191.45","paid_amount":"191.45","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-3529137071","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":"112612","customer_id":"112612","source_of_creation":"Booking.com","reservation_created_date":"2021-09-02 22:55:08","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"0","commision_charges":"37.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"84.71","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":"5310255","reservation_id":"122675","confirmation_number":"BP12531867785","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"57.44","nightly_discount":"0","subtotal":"57.44","grand_total":"64.91","paid_amount":"64.91","room_type_id":"295","product_id":"1128","siteminder_id":"EXP-1826578238","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":"130345","customer_id":"130345","source_of_creation":"Expedia","reservation_created_date":"2021-09-07 09:19:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"57.44","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":"5309637","reservation_id":"122651","confirmation_number":"BP12537559068","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"145.57,145.57,145.57,185.74,185.74","nightly_discount":"0,0,0,0,0","subtotal":"808.19","grand_total":"913.25","paid_amount":"913.25","room_type_id":"301","product_id":"1136","siteminder_id":"GAM-R2787562808","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130289","customer_id":"130289","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-06 21:19:06","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 807","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"145.57","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":"5309641","reservation_id":"122500","confirmation_number":"BP12515174829","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.48,53.49","nightly_discount":"0,0","subtotal":"102.97","grand_total":"116.36","paid_amount":"116.36","room_type_id":"299","product_id":"1134","siteminder_id":"GAM-R2781973429","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":"130290","customer_id":"130290","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-04 01:17:09","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"53.49","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":"5310292","reservation_id":"122705","confirmation_number":"BP12571256678","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"53.49","nightly_discount":"0","subtotal":"53.49","grand_total":"60.44","paid_amount":"60.44","room_type_id":"298","product_id":"1133","siteminder_id":"GAM-R2789634203","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":"130353","customer_id":"130353","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-07 20:05:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"53.49","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"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"5178873","reservation_id":"121733","confirmation_number":"BP12542082633","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"300.00,324.32","nightly_discount":"0.00,0.00","subtotal":"624.32","grand_total":"705.48","paid_amount":"705.48","room_type_id":"297","product_id":"1132","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"129277","customer_id":"129277","source_of_creation":"FE","reservation_created_date":"2021-08-23 01:10:30","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 826","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"324.32","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5310162","reservation_id":"122688","confirmation_number":"BP12587245327","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"60.00,60.00,60.00","nightly_discount":"0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","room_type_id":"295","product_id":"1129","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":"130336","customer_id":"130336","source_of_creation":"PMS","reservation_created_date":"2021-09-07 16:28:18","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","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":"5294481","reservation_id":"121870","confirmation_number":"BP12552914424","room_stay_from":"2021-09-06","room_stay_to":"2021-09-23","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,95.00,85.00,85.00,125.00,125.00,85.00,85.00,85.00,85.00,85.00,125.00,125.00,85.00,85.00,85.00,85.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","subtotal":"1630.00","grand_total":"1841.90","paid_amount":"0.00","room_type_id":"301","product_id":"1137","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":"129363","customer_id":"129363","source_of_creation":"PMS","reservation_created_date":"2021-08-24 23:06:02","service_canceled_date_time":"2021-09-07 21:18:06","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 824","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"","total_paid_amount":"0.00","sub_hotel_id":"125","deltaChange":-100,"changedComment":"reservation is canceled","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":"5178875","reservation_id":"121733","confirmation_number":"BP12224767998","room_confirmation_number":"BP12542082633","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"10.00,10.00","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"129277","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-08-23 01:10:30","reservation_modified_date_time":"2021-08-23 01:10:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129277","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5309638","reservation_id":"122651","confirmation_number":"BP12274237723","room_confirmation_number":"BP12537559068","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","room_stay_status":"Active","nightly_price":"20,20,20,20,20","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":"1780","service_quantity":"1","customer_traveller_id":"130289","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-09-06 21:19:06","reservation_modified_date_time":"2021-09-06 21:19:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130289","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"125","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":"5178874","reservation_id":"121733","confirmation_number":"BP12236213494","room_confirmation_number":"BP12542082633","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","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":"129277","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-08-23 01:10:30","reservation_modified_date_time":"2021-08-23 01:10:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"129277","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5308874","reservation_id":"122412","confirmation_number":"BP12249776741","room_confirmation_number":"BP12555256120","room_stay_from":"2021-09-04","room_stay_to":"2021-09-08","room_stay_status":"Active","nightly_price":"20,20,20,20","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":"130177","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-02 15:09:10","reservation_modified_date_time":"2021-09-05 01:37:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130177","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5309639","reservation_id":"122651","confirmation_number":"BP12213950169","room_confirmation_number":"BP12537559068","room_stay_from":"2021-09-07","room_stay_to":"2021-09-12","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":"130289","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-06 21:19:06","reservation_modified_date_time":"2021-09-06 21:19:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130289","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","sub_hotel_id":"125","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":"5309640","reservation_id":"122500","confirmation_number":"BP12295004954","room_confirmation_number":"BP12515174829","room_stay_from":"2021-09-06","room_stay_to":"2021-09-08","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":"130290","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-04 01:17:09","reservation_modified_date_time":"2021-09-06 21:26:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130290","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5310163","reservation_id":"122688","confirmation_number":"BP12290277173","room_confirmation_number":"BP12587245327","room_stay_from":"2021-09-07","room_stay_to":"2021-09-10","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":"130336","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-07 16:28:18","reservation_modified_date_time":"2021-09-07 16:28:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130336","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5310254","reservation_id":"122675","confirmation_number":"BP12296874297","room_confirmation_number":"BP12531867785","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"130345","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-07 09:19:11","reservation_modified_date_time":"2021-09-07 18:51:30","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130345","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5310258","reservation_id":"122697","confirmation_number":"BP12246517015","room_confirmation_number":"BP12522558392","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"130346","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-07 18:52:14","reservation_modified_date_time":"2021-09-07 18:52:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130346","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5310282","reservation_id":"122441","confirmation_number":"BP12247951103","room_confirmation_number":"BP12566073128","room_stay_from":"2021-09-07","room_stay_to":"2021-09-09","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":"112612","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-02 22:55:08","reservation_modified_date_time":"2021-09-07 19:43:04","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"112612","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5310293","reservation_id":"122705","confirmation_number":"BP12246425519","room_confirmation_number":"BP12571256678","room_stay_from":"2021-09-07","room_stay_to":"2021-09-08","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":"130353","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-07 20:05:10","reservation_modified_date_time":"2021-09-07 20:05:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130353","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5294482","reservation_id":"121870","confirmation_number":"BP12229663006","room_confirmation_number":"BP12552914424","room_stay_from":"2021-09-06","room_stay_to":"2021-09-23","room_stay_status":"Canceled","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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","subtotal":"204.00","grand_total":"230.52","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-08-24 23:06:02","reservation_modified_date_time":"2021-08-24 23:06:02","customer_id":"129363","parentCustTravId":"129363","customer_traveller_id":"129363","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-07 21:18:07","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate# ","parentRoomStayFrom":"2021-09-06","sub_hotel_id":"125","deltaChange":-12,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"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":"5309830","reservation_id":"113854","confirmation_number":"BP12244529817","room_confirmation_number":"BP12564487167","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.20","grand_total":"8.99","paid_amount":"8.99","product_id":"1151","service_quantity":"2","product_name":"Coffee Mug","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-03 18:31:15","reservation_modified_date_time":"2021-09-07 12:52:21","customer_id":"120475","parentCustTravId":"120475","customer_traveller_id":"120949","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","parentRoomStayFrom":"2021-09-02","sub_hotel_id":"125","changedComment":"price, discount or quantity changed","deltaChange":"4.20","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5310256","reservation_id":"122675","confirmation_number":"BP12246355709","room_confirmation_number":"BP12531867785","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"45.00","grand_total":"48.15","paid_amount":"48.15","product_id":"1175","service_quantity":"1","product_name":"Miscellaneous","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 18:51:46","reservation_modified_date_time":"2021-09-07 18:51:46","customer_id":"130345","parentCustTravId":"130345","customer_traveller_id":"130345","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"125","currentDayPrice":"45.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5310321","reservation_id":"122705","confirmation_number":"BP12293206452","room_confirmation_number":"BP12571256678","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":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-07 22:40:26","reservation_modified_date_time":"2021-09-07 22:40:26","customer_id":"130353","parentCustTravId":"130353","customer_traveller_id":"130353","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","parentRoomStayFrom":"2021-09-07","sub_hotel_id":"125","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":"5309683","reservation_id":"122628","confirmation_number":"BP12290489791","room_confirmation_number":"BP12562051707","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-06 23:02:19","reservation_modified_date_time":"2021-09-06 23:02:19","customer_id":"130292","parentCustTravId":"130292","customer_traveller_id":"130292","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-07 15:34:07","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-09-06","sub_hotel_id":"125","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}