{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2021-11-21","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":44,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1131,1130,1125","block_room_bookings":[{"confirmation_number":"BP12248230106","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","bundle_room":"0","product_id":"1131"},{"confirmation_number":"BP12278577907","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","bundle_room":"0","product_id":"1130"},{"confirmation_number":"BP12215165739","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","bundle_room":"0","product_id":"1125"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5335623","reservation_id":"125082","confirmation_number":"BV12455625417","room_stay_from":"2021-11-16","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.13,155.56,155.56,195.39,224.70,262.91","nightly_discount":"0,0,0,0,0,0","subtotal":"1193.25","grand_total":"1348.38","paid_amount":"1348.38","room_type_id":"306","product_id":"1223","siteminder_id":"BDC-2417146013","collect_which":"hotel_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":"134032","customer_id":"134032","source_of_creation":"Booking.com","reservation_created_date":"2021-11-05 15:43:51","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"236.38","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"262.91","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":"5336127","reservation_id":"125650","confirmation_number":"BP12555999255","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.41,166.50","nightly_discount":"0,0","subtotal":"307.91","grand_total":"347.93","paid_amount":"347.93","room_type_id":"295","product_id":"1128","siteminder_id":"BDC-3662288494","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":"134116","customer_id":"134116","source_of_creation":"Booking.com","reservation_created_date":"2021-11-19 15:19:18","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"62.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"166.50","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":"5336285","reservation_id":"125652","confirmation_number":"BP12518936879","room_stay_from":"2021-11-19","room_stay_to":"2021-11-26","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"134.34,154.49,181.89,95.17,95.17,126.68,143.95","nightly_discount":"0,0,0,0,0,0,0","subtotal":"931.69","grand_total":"1052.81","paid_amount":"1052.81","room_type_id":"301","product_id":"1136","siteminder_id":"BDC-3946159787","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":"134127","customer_id":"134127","source_of_creation":"Booking.com","reservation_created_date":"2021-11-19 15:37:06","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 807","ota_service_fee_amount":"0","commision_charges":"192.90","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"181.89","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336332","reservation_id":"117942","confirmation_number":"BP12538442226","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.83,120.83,107.33","nightly_discount":"0,0,0","subtotal":"348.99","grand_total":"394.36","paid_amount":"394.36","room_type_id":"298","product_id":"1133","siteminder_id":"BDC-2431052168","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":"134136","customer_id":"134136","source_of_creation":"Booking.com","reservation_created_date":"2021-06-24 01:52:09","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"73.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"107.33","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":"5336604","reservation_id":"123371","confirmation_number":"PB12360405039","room_stay_from":"2021-11-21","room_stay_to":"2021-11-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"344.65,456.10,456.10","nightly_discount":"0.00,0.00,53.35","subtotal":"1256.85","grand_total":"1359.96","paid_amount":"1359.96","room_type_id":"289","product_id":"1123","siteminder_id":"BDC-3024250011","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109128","customer_id":"109128","source_of_creation":"Booking.com","reservation_created_date":"2021-09-20 20:16:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"202.03","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"344.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336643","reservation_id":"125674","confirmation_number":"PB12313321447","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"190.13,169.72","nightly_discount":"0.00,0.00","subtotal":"359.85","grand_total":"406.63","paid_amount":"406.63","room_type_id":"289","product_id":"1106","siteminder_id":"BDC-3717989730","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134186","customer_id":"134186","source_of_creation":"Booking.com","reservation_created_date":"2021-11-20 02:06:49","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"65.98","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"169.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336680","reservation_id":"125474","confirmation_number":"PB12398819884","room_stay_from":"2021-11-20","room_stay_to":"2021-11-24","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"243.16,227.81,299.48,299.48","nightly_discount":"0,0,0,0","subtotal":"1069.93","grand_total":"1209.03","paid_amount":"1209.03","room_type_id":"291","product_id":"1117","siteminder_id":"BDC-2841362562","collect_which":"hotel_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":"134203","customer_id":"134203","source_of_creation":"Booking.com","reservation_created_date":"2021-11-14 23:44:38","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"178.49","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"227.81","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336811","reservation_id":"125709","confirmation_number":"BV12477099705","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.79","nightly_discount":"0","subtotal":"128.79","grand_total":"145.54","paid_amount":"145.54","room_type_id":"304","product_id":"1218","siteminder_id":"BDC-3389001666","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":"134222","customer_id":"134222","source_of_creation":"Booking.com","reservation_created_date":"2021-11-21 13:09:13","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"26.78","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"128.79","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":"5336826","reservation_id":"125691","confirmation_number":"BP12549888091","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.85","nightly_discount":"0","subtotal":"90.85","grand_total":"102.66","paid_amount":"102.66","room_type_id":"295","product_id":"1129","siteminder_id":"BDC-3807705905","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":"134218","customer_id":"134218","source_of_creation":"Booking.com","reservation_created_date":"2021-11-20 18:31:40","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"19.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"90.85","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336829","reservation_id":"125671","confirmation_number":"BP12560615013","room_stay_from":"2021-11-21","room_stay_to":"2021-11-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.65,97.07,97.07","nightly_discount":"0.00,0.00,0.00","subtotal":"307.79","grand_total":"347.81","paid_amount":"347.81","room_type_id":"294","product_id":"1126","siteminder_id":"BDC-3260915475","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":"134206","customer_id":"134206","source_of_creation":"Booking.com","reservation_created_date":"2021-11-21 14:50:55","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 806","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":"113.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336877","reservation_id":"125674","confirmation_number":"PB12334397263","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"190.13,169.72","nightly_discount":"0.00,0.00","subtotal":"359.85","grand_total":"406.63","paid_amount":"406.63","room_type_id":"289","product_id":"1103","siteminder_id":"BDC-3717989730","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134186","customer_id":"134186","source_of_creation":"Booking.com","reservation_created_date":"2021-11-20 02:06:49","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"65.98","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"169.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336887","reservation_id":"125734","confirmation_number":"BP12513693612","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.40","nightly_discount":"0","subtotal":"90.40","grand_total":"102.15","paid_amount":"102.15","room_type_id":"294","product_id":"1127","siteminder_id":"BDC-3946124467","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":"134246","customer_id":"134246","source_of_creation":"Booking.com","reservation_created_date":"2021-11-21 23:54:34","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 822","ota_service_fee_amount":"0","commision_charges":"19.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"90.40","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":"5336909","reservation_id":"125730","confirmation_number":"BV12472119654","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.32","nightly_discount":"0","subtotal":"128.32","grand_total":"145.00","paid_amount":"145.00","room_type_id":"285","product_id":"1083","siteminder_id":"BDC-2740423167","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":"134251","customer_id":"134251","source_of_creation":"Booking.com","reservation_created_date":"2021-11-21 23:16:34","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"26.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"128.32","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":"5336736","reservation_id":"125671","confirmation_number":"BP12591571054","room_stay_from":"2021-11-20","room_stay_to":"2021-11-21","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.92","nightly_discount":"0","subtotal":"144.92","grand_total":"163.76","paid_amount":"163.76","room_type_id":"294","product_id":"1125","siteminder_id":"BDC-3260915475","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":"134206","customer_id":"134206","source_of_creation":"Booking.com","reservation_created_date":"2021-11-20 00:29:58","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","ota_service_fee_amount":"0","commision_charges":"95.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","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"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"5336296","reservation_id":"110316","confirmation_number":"PB12354891843","room_stay_from":"2021-11-19","room_stay_to":"2021-11-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.66,125.66,116.42,116.42,116.42,87.78,87.78","nightly_discount":"0,0,0,0,0,0,0","subtotal":"776.14","grand_total":"877.04","paid_amount":"877.04","room_type_id":"291","product_id":"1119","siteminder_id":"EXP-1747666140","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":"134129","customer_id":"134129","source_of_creation":"Expedia","reservation_created_date":"2021-03-14 23:57:07","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","group_rooms":null,"currentDayPrice":"116.42","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":"5336790","reservation_id":"115894","confirmation_number":"PB12384054342","room_stay_from":"2021-11-21","room_stay_to":"2021-11-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"105.78,105.78,105.78,77.13","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"394.47","grand_total":"445.75","paid_amount":"445.75","room_type_id":"292","product_id":"1120","siteminder_id":"EXP-1776009532","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134219","customer_id":"134219","source_of_creation":"Expedia","reservation_created_date":"2021-05-26 02:35: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","currentDayPrice":"105.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336895","reservation_id":"125725","confirmation_number":"BV12411739201","room_stay_from":"2021-11-21","room_stay_to":"2021-11-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.21,125.00","nightly_discount":"0.00,0.00","subtotal":"215.21","grand_total":"243.18","paid_amount":"243.18","room_type_id":"304","product_id":"1219","siteminder_id":"EXP-1860927633","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":"134247","customer_id":"134247","source_of_creation":"Expedia","reservation_created_date":"2021-11-21 21:08:38","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","currentDayPrice":"90.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5336794","reservation_id":"118538","confirmation_number":"BP12535080946","room_stay_from":"2021-11-20","room_stay_to":"2021-11-21","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"142.91","nightly_discount":"0.00","subtotal":"142.91","grand_total":"161.48","paid_amount":"161.48","room_type_id":"300","product_id":"1135","siteminder_id":"EXP-1794741800","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125572","customer_id":"125572","source_of_creation":"Expedia","reservation_created_date":"2021-07-02 17:15:07","service_canceled_date_time":"2021-11-21 17:55:43","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 805","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"","total_paid_amount":"184.08","sub_hotel_id":"125","deltaChange":"22.60","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3252640","reservation_id":"115342","confirmation_number":"PB12321722129","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"140.00,120.00,120.00,120.00,86.00,86.00,106.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"778.00","grand_total":"879.14","paid_amount":"879.14","room_type_id":"289","product_id":"1102","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":"95312","customer_id":"95312","source_of_creation":"FE","reservation_created_date":"2021-05-16 18:42:01","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5304595","reservation_id":"115342","confirmation_number":"PB12389292828","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,120.00,120.00,120.00,86.00,86.00,106.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"778.00","grand_total":"879.14","paid_amount":"879.14","room_type_id":"289","product_id":"1097","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":"95312","customer_id":"95312","source_of_creation":"FE","reservation_created_date":"2021-05-16 18:42:02","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5304599","reservation_id":"115342","confirmation_number":"PB12322913212","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,120.00,120.00,120.00,86.00,86.00,106.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"778.00","grand_total":"879.14","paid_amount":"879.14","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":"95312","customer_id":"95312","source_of_creation":"FE","reservation_created_date":"2021-05-16 18:42:02","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":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331784","reservation_id":"110806","confirmation_number":"PB12345072593","room_stay_from":"2021-11-18","room_stay_to":"2021-11-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,130.00,130.00,130.00,93.00,93.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"876.00","grand_total":"989.88","paid_amount":"989.88","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":"117323","customer_id":"117323","source_of_creation":"FE","reservation_created_date":"2021-03-20 17:09:23","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","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":"5331958","reservation_id":"125144","confirmation_number":"BP12585573095","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.13","nightly_discount":"0.00","subtotal":"146.13","grand_total":"165.13","paid_amount":"165.13","room_type_id":"299","product_id":"1134","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":"133370","customer_id":"133370","source_of_creation":"FE","reservation_created_date":"2021-11-07 15:49:49","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":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"146.13","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5333034","reservation_id":"116625","confirmation_number":"PB12378215112","room_stay_from":"2021-11-12","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.60,189.60,138.00,138.00,138.00,138.00,138.00,158.00,158.00,138.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1523.20","grand_total":"1721.21","paid_amount":"1721.21","room_type_id":"291","product_id":"1116","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123517","customer_id":"123517","source_of_creation":"FE","reservation_created_date":"2021-06-05 23:34:15","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"138.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5335712","reservation_id":"125113","confirmation_number":"PB12325449859","room_stay_from":"2021-11-18","room_stay_to":"2021-11-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"143.19,179.57,206.51,241.98,318.03","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1089.28","grand_total":"1230.89","paid_amount":"1230.89","room_type_id":"289","product_id":"1109","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133307","customer_id":"133307","source_of_creation":"FE","reservation_created_date":"2021-11-06 05:51:56","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"241.98","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5335999","reservation_id":"109293","confirmation_number":"PB12338478893","room_stay_from":"2021-11-18","room_stay_to":"2021-11-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"206.00,206.00,186.00,186.00,186.00,152.00,152.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,58.20","subtotal":"1274.00","grand_total":"1373.86","paid_amount":"1373.86","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":"106829","customer_id":"106829","source_of_creation":"FE","reservation_created_date":"2021-03-04 02:39:22","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":"186.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336404","reservation_id":"125675","confirmation_number":"PB12388982640","room_stay_from":"2021-11-21","room_stay_to":"2021-11-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"316.57,349.42","nightly_discount":"0.00,0.00","subtotal":"665.99","grand_total":"752.57","paid_amount":"752.57","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":"134157","customer_id":"134157","source_of_creation":"FE","reservation_created_date":"2021-11-20 02:54:52","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":"316.57","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336501","reservation_id":"125015","confirmation_number":"PB12346977496","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"217.89,250.57,301.55","nightly_discount":"0.00,0.00,0.00","subtotal":"770.01","grand_total":"870.11","paid_amount":"870.11","room_type_id":"288","product_id":"1092","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":"133170","customer_id":"133170","source_of_creation":"FE","reservation_created_date":"2021-11-03 19:22:59","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"301.55","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336703","reservation_id":"114303","confirmation_number":"PB12311254322","room_stay_from":"2021-11-20","room_stay_to":"2021-11-26","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,93.00,93.00,113.00","nightly_discount":"0.00,0.00,0.00,0.00,6.72,31.89","subtotal":"689.00","grand_total":"734.94","paid_amount":"734.94","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":"107788","customer_id":"107788","source_of_creation":"FE","reservation_created_date":"2021-05-01 22:37:00","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"5336770","reservation_id":"125387","confirmation_number":"PB12377838387","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"221.50","nightly_discount":"0.00","subtotal":"221.50","grand_total":"250.30","paid_amount":"250.30","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":"133717","customer_id":"133717","source_of_creation":"FE","reservation_created_date":"2021-11-13 04:53:40","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","currentDayPrice":"221.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336868","reservation_id":"113974","confirmation_number":"PB12394525560","room_stay_from":"2021-11-21","room_stay_to":"2021-11-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.00,201.00,201.00,164.00","nightly_discount":"0.00,0.00,0.00,30.70","subtotal":"767.00","grand_total":"832.02","paid_amount":"832.02","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":"120605","customer_id":"120605","source_of_creation":"FE","reservation_created_date":"2021-04-27 03:08:31","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","currentDayPrice":"201.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336870","reservation_id":"125731","confirmation_number":"BV12497580112","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.22","nightly_discount":"0.00","subtotal":"93.22","grand_total":"105.34","paid_amount":"105.34","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":"134241","customer_id":"134241","source_of_creation":"FE","reservation_created_date":"2021-11-21 23:21:20","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":"93.22","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3303376","reservation_id":"121284","confirmation_number":"BP12554386129","room_stay_from":"2021-11-21","room_stay_to":"2021-11-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"288.47,289.87","nightly_discount":"0.00,0.00","subtotal":"578.34","grand_total":"653.52","paid_amount":"653.52","room_type_id":"293","product_id":"1124","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":"128754","customer_id":"128754","source_of_creation":"PMS","reservation_created_date":"2021-08-16 16:29:03","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","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":"288.47","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330980","reservation_id":"125025","confirmation_number":"PB12335194823","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"179.57,206.51,241.98","nightly_discount":"0.00,0.00,0.00","subtotal":"628.06","grand_total":"709.70","paid_amount":"709.70","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":"133185","customer_id":"133185","source_of_creation":"PMS","reservation_created_date":"2021-11-03 23:29:01","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","group_rooms":null,"currentDayPrice":"241.98","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5333378","reservation_id":"124966","confirmation_number":"BV12483666991","room_stay_from":"2021-11-01","room_stay_to":"2021-11-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.56,61.56,61.56,61.56,110.00,115.00,75.00,75.00,75.00,65.00,70.00,70.00,70.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,16.36,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0,0","subtotal":"2011.24","grand_total":"2254.21","paid_amount":"2090.12","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":"133111","customer_id":"133111","source_of_creation":"PMS","reservation_created_date":"2021-11-02 00:58:54","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":"65.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":"5335565","reservation_id":"117665","confirmation_number":"PB12322095586","room_stay_from":"2021-11-21","room_stay_to":"2021-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.00,518.00,518.00,390.37,390.37,465.45,465.45,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2989.64","grand_total":"3378.29","paid_amount":"3378.29","room_type_id":"291","product_id":"1118","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":"65989","customer_id":"65989","source_of_creation":"PMS","reservation_created_date":"2021-06-20 00:38:32","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","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":"138.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336619","reservation_id":"125496","confirmation_number":"PB12361754387","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"220.28,221.50","nightly_discount":"0.00,0.00","subtotal":"441.78","grand_total":"499.21","paid_amount":"499.21","room_type_id":"291","product_id":"1115","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":"133883","customer_id":"133883","source_of_creation":"PMS","reservation_created_date":"2021-11-15 17:25:25","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","group_rooms":null,"currentDayPrice":"221.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336818","reservation_id":"125579","confirmation_number":"PB12362732796","room_stay_from":"2021-11-17","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.98,122.07,179.57,206.51,205.68","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"829.81","grand_total":"937.69","paid_amount":"937.69","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":"134015","customer_id":"134015","source_of_creation":"PMS","reservation_created_date":"2021-11-17 02:53:31","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","currentDayPrice":"205.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336848","reservation_id":"116592","confirmation_number":"PB12396997296","room_stay_from":"2021-11-21","room_stay_to":"2021-12-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,120.00,120.00,86.00,86.00,106.00,106.00,86.00,86.00,86.00,86.00,86.00,106.00,106.00,86.00,86.00,86.00,86.00,86.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,96.57,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":"1816.00","grand_total":"1942.96","paid_amount":"1942.96","room_type_id":"289","product_id":"1098","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":"91142","customer_id":"91142","source_of_creation":"PMS","reservation_created_date":"2021-06-05 16:26:00","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","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":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3252642","reservation_id":"115342","confirmation_number":"PB12265631850","room_confirmation_number":"PB12321722129","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"95312","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-05-16 18:42:01","reservation_modified_date_time":"2021-05-16 18:42:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","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":"5330851","reservation_id":"125015","confirmation_number":"PB12249403374","room_confirmation_number":"PB12346977496","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"133170","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-03 19:22:59","reservation_modified_date_time":"2021-11-03 19:22:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133170","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330981","reservation_id":"125025","confirmation_number":"PB12292815973","room_confirmation_number":"PB12335194823","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"133185","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-03 23:29:01","reservation_modified_date_time":"2021-11-03 23:29:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133185","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":"5335713","reservation_id":"125113","confirmation_number":"PB12287670758","room_confirmation_number":"PB12325449859","room_stay_from":"2021-11-18","room_stay_to":"2021-11-23","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":"133307","product_attribute_values":"extra_person# ","reservation_created_date":"2021-11-18 01:26:34","reservation_modified_date_time":"2021-11-18 01:26:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133307","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":"5335906","reservation_id":"109293","confirmation_number":"PB12245870201","room_confirmation_number":"PB12338478893","room_stay_from":"2021-11-18","room_stay_to":"2021-11-25","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","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":"106829","product_attribute_values":"extra_person# ","reservation_created_date":"2021-11-18 19:19:53","reservation_modified_date_time":"2021-11-18 19:19:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106829","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":"5336552","reservation_id":"125674","confirmation_number":"PB12223426251","room_confirmation_number":"PB12334397263","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"134186","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-20 02:06:49","reservation_modified_date_time":"2021-11-20 19:34:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134186","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.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":"5336555","reservation_id":"125674","confirmation_number":"PB12266745357","room_confirmation_number":"PB12313321447","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"134186","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-20 02:06:49","reservation_modified_date_time":"2021-11-20 19:37:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134186","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.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":"5336601","reservation_id":"123371","confirmation_number":"PB12219987234","room_confirmation_number":"PB12360405039","room_stay_from":"2021-11-21","room_stay_to":"2021-11-24","room_stay_status":"Active","nightly_price":"30,30,30","nightly_discount":"0.00,0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1780","service_quantity":"1","customer_traveller_id":"109128","product_attribute_values":"extra_person# ","reservation_created_date":"2021-11-20 20:30:13","reservation_modified_date_time":"2021-11-20 20:46:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109128","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336678","reservation_id":"125474","confirmation_number":"PB12238432602","room_confirmation_number":"PB12398819884","room_stay_from":"2021-11-20","room_stay_to":"2021-11-24","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"134203","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-14 23:44:38","reservation_modified_date_time":"2021-11-21 00:57:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134203","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.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":"5336690","reservation_id":"114303","confirmation_number":"PB12242314835","room_confirmation_number":"PB12311254322","room_stay_from":"2021-11-20","room_stay_to":"2021-11-26","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"107788","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-21 01:10:07","reservation_modified_date_time":"2021-11-21 01:10:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107788","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336771","reservation_id":"125387","confirmation_number":"PB12214430856","room_confirmation_number":"PB12377838387","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"133717","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-21 16:27:13","reservation_modified_date_time":"2021-11-21 16:27:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133717","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336788","reservation_id":"115894","confirmation_number":"PB12223511770","room_confirmation_number":"PB12384054342","room_stay_from":"2021-11-21","room_stay_to":"2021-11-25","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0,0,0,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"134219","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-21 01:30:04","reservation_modified_date_time":"2021-11-21 17:43:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134219","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336822","reservation_id":"125710","confirmation_number":"BP12259068125","room_confirmation_number":"BP12574889683","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"36.9","nightly_discount":"0.00","subtotal":"36.90","grand_total":"41.69","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"134228","product_attribute_values":"extra_person# .30","reservation_created_date":"2021-11-21 16:14:47","reservation_modified_date_time":"2021-11-21 20:19:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134228","canceled_nights_data":"","posAmt_airbnb_taxpaid":"36.90","sub_hotel_id":"125","currentDayPrice":"36.9","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3276846","reservation_id":"118538","confirmation_number":"BP12264678717","room_confirmation_number":"BP12535080946","room_stay_from":"2021-11-20","room_stay_to":"2021-11-21","room_stay_status":"Canceled","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2021-07-02 17:15:07","reservation_modified_date_time":"2021-07-02 17:15:07","customer_id":"125572","parentCustTravId":"125572","customer_traveller_id":"125572","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-11-21 17:55:43","canceled_nights_data":"","product_attribute_values":"extra_person# .00","parentRoomStayFrom":"2021-11-20","sub_hotel_id":"125","deltaChange":-20,"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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3252641","reservation_id":"115342","confirmation_number":"PB12257718919","room_confirmation_number":"PB12321722129","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","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":"95312","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-05-16 18:42:01","reservation_modified_date_time":"2021-05-16 18:42:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","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":"3303377","reservation_id":"121284","confirmation_number":"BP12263585898","room_confirmation_number":"BP12554386129","room_stay_from":"2021-11-21","room_stay_to":"2021-11-23","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":"128754","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-08-16 16:29:03","reservation_modified_date_time":"2021-08-16 16:29:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128754","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":"5304596","reservation_id":"115342","confirmation_number":"PB12213207374","room_confirmation_number":"PB12389292828","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","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":"95312","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-05-16 18:42:02","reservation_modified_date_time":"2021-08-28 00:29:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","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":"5304600","reservation_id":"115342","confirmation_number":"PB12254420664","room_confirmation_number":"PB12322913212","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","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":"95312","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-05-16 18:42:02","reservation_modified_date_time":"2021-08-28 00:29:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","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":"5330982","reservation_id":"125025","confirmation_number":"PB12273601975","room_confirmation_number":"PB12335194823","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","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":"133185","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-03 23:29:01","reservation_modified_date_time":"2021-11-03 23:29:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133185","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":"5331785","reservation_id":"110806","confirmation_number":"PB12226917228","room_confirmation_number":"PB12345072593","room_stay_from":"2021-11-18","room_stay_to":"2021-11-25","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":"117323","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-03-20 17:09:23","reservation_modified_date_time":"2021-11-06 19:17:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117323","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":"5331959","reservation_id":"125144","confirmation_number":"BP12235096007","room_confirmation_number":"BP12585573095","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","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":"133370","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-07 15:49:49","reservation_modified_date_time":"2021-11-07 15:49:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133370","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":"5333035","reservation_id":"116625","confirmation_number":"PB12282460298","room_confirmation_number":"PB12378215112","room_stay_from":"2021-11-12","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"123517","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-06-05 23:34:15","reservation_modified_date_time":"2021-11-10 17:36:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123517","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":"5333379","reservation_id":"124966","confirmation_number":"BV12273316504","room_confirmation_number":"BV12483666991","room_stay_from":"2021-11-01","room_stay_to":"2021-11-30","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"348.00","grand_total":"393.24","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"133111","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-02 00:58:54","reservation_modified_date_time":"2021-11-11 14:34:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133111","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":"5335566","reservation_id":"117665","confirmation_number":"PB12278385554","room_confirmation_number":"PB12322095586","room_stay_from":"2021-11-21","room_stay_to":"2021-11-29","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":"65989","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-06-20 00:38:32","reservation_modified_date_time":"2021-11-17 17:44:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"65989","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":"5335622","reservation_id":"125082","confirmation_number":"BV12253797716","room_confirmation_number":"BV12455625417","room_stay_from":"2021-11-16","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134032","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-05 15:43:51","reservation_modified_date_time":"2021-11-17 20:09:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134032","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"124","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":"5335714","reservation_id":"125113","confirmation_number":"PB12284362783","room_confirmation_number":"PB12325449859","room_stay_from":"2021-11-18","room_stay_to":"2021-11-23","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":"133307","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-06 05:51:56","reservation_modified_date_time":"2021-11-18 01:26:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133307","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":"5336000","reservation_id":"109293","confirmation_number":"PB12241151145","room_confirmation_number":"PB12338478893","room_stay_from":"2021-11-18","room_stay_to":"2021-11-25","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":"106829","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-03-04 02:39:22","reservation_modified_date_time":"2021-11-18 20:07:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106829","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":"5336007","reservation_id":"124867","confirmation_number":"PB12253367944","room_confirmation_number":"PB12331425460","room_stay_from":"2021-11-18","room_stay_to":"2021-11-22","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":"134092","product_attribute_values":"resort_fee# ","reservation_created_date":"2021-10-29 04:37:01","reservation_modified_date_time":"2021-11-18 21:23:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134092","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.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":"5336128","reservation_id":"125650","confirmation_number":"BP12221549386","room_confirmation_number":"BP12555999255","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20,20","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":"134117","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-19 15:19:18","reservation_modified_date_time":"2021-11-19 15:19:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134116","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":"5336284","reservation_id":"125652","confirmation_number":"BP12292287137","room_confirmation_number":"BP12518936879","room_stay_from":"2021-11-19","room_stay_to":"2021-11-26","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"134127","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-19 15:37:06","reservation_modified_date_time":"2021-11-19 18:35:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134127","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":"5336295","reservation_id":"110316","confirmation_number":"PB12257746671","room_confirmation_number":"PB12354891843","room_stay_from":"2021-11-19","room_stay_to":"2021-11-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"134129","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-14 23:57:07","reservation_modified_date_time":"2021-11-19 19:27:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134129","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":"5336331","reservation_id":"117942","confirmation_number":"BP12299793709","room_confirmation_number":"BP12538442226","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"134136","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-24 01:52:09","reservation_modified_date_time":"2021-11-19 21:18:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134136","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":"5336405","reservation_id":"125675","confirmation_number":"PB12245571508","room_confirmation_number":"PB12388982640","room_stay_from":"2021-11-21","room_stay_to":"2021-11-23","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":"134157","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-20 02:54:52","reservation_modified_date_time":"2021-11-20 02:54:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134157","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":"5336503","reservation_id":"125015","confirmation_number":"PB12253333104","room_confirmation_number":"PB12346977496","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","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":"133170","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-03 19:22:59","reservation_modified_date_time":"2021-11-20 16:00:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133170","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":"5336605","reservation_id":"123371","confirmation_number":"PB12236341418","room_confirmation_number":"PB12360405039","room_stay_from":"2021-11-21","room_stay_to":"2021-11-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"109128","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-20 20:16:14","reservation_modified_date_time":"2021-11-20 20:47:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109128","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.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":"5336620","reservation_id":"125496","confirmation_number":"PB12214242468","room_confirmation_number":"PB12361754387","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","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":"133883","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-15 17:25:25","reservation_modified_date_time":"2021-11-20 21:47:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133883","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":"5336645","reservation_id":"125674","confirmation_number":"PB12211037122","room_confirmation_number":"PB12313321447","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20,20","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":"134186","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-20 02:06:49","reservation_modified_date_time":"2021-11-20 23:18:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134186","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.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":"5336679","reservation_id":"125474","confirmation_number":"PB12232137320","room_confirmation_number":"PB12398819884","room_stay_from":"2021-11-20","room_stay_to":"2021-11-24","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":"134203","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-14 23:44:38","reservation_modified_date_time":"2021-11-21 00:57:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134203","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":"5336704","reservation_id":"114303","confirmation_number":"PB12255938433","room_confirmation_number":"PB12311254322","room_stay_from":"2021-11-20","room_stay_to":"2021-11-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"107788","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-05-01 22:37:00","reservation_modified_date_time":"2021-11-21 01:13:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107788","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":"5336772","reservation_id":"125387","confirmation_number":"PB12241226753","room_confirmation_number":"PB12377838387","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","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":"133717","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-13 04:53:40","reservation_modified_date_time":"2021-11-21 16:27:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133717","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":"5336789","reservation_id":"115894","confirmation_number":"PB12246642589","room_confirmation_number":"PB12384054342","room_stay_from":"2021-11-21","room_stay_to":"2021-11-25","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":"134219","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-26 02:35:10","reservation_modified_date_time":"2021-11-21 17:43:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134219","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.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":"5336809","reservation_id":"125709","confirmation_number":"BV12211614534","room_confirmation_number":"BV12477099705","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134222","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-21 13:09:13","reservation_modified_date_time":"2021-11-21 19:03:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134222","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5336820","reservation_id":"125579","confirmation_number":"PB12241682699","room_confirmation_number":"PB12362732796","room_stay_from":"2021-11-17","room_stay_to":"2021-11-22","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":"134015","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-17 02:53:31","reservation_modified_date_time":"2021-11-21 20:05:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134015","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":"5336823","reservation_id":"125710","confirmation_number":"BP12219787756","room_confirmation_number":"BP12574889683","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"134228","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-21 16:14:47","reservation_modified_date_time":"2021-11-21 20:19:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134228","canceled_nights_data":"","posAmt_airbnb_taxpaid":"36.90","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":"5336825","reservation_id":"125691","confirmation_number":"BP12249898724","room_confirmation_number":"BP12549888091","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134218","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-20 18:31:40","reservation_modified_date_time":"2021-11-21 20:24:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134218","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":"5336828","reservation_id":"125671","confirmation_number":"BP12226128295","room_confirmation_number":"BP12560615013","room_stay_from":"2021-11-21","room_stay_to":"2021-11-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.79","product_id":"1781","service_quantity":"1","customer_traveller_id":"134206","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-21 14:50:55","reservation_modified_date_time":"2021-11-21 20:27:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134206","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":"5336849","reservation_id":"116592","confirmation_number":"PB12252831863","room_confirmation_number":"PB12396997296","room_stay_from":"2021-11-21","room_stay_to":"2021-12-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"228.00","grand_total":"257.64","paid_amount":"257.64","product_id":"1781","service_quantity":"1","customer_traveller_id":"91142","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-06-05 16:26:00","reservation_modified_date_time":"2021-11-21 21:20:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91142","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":"5336869","reservation_id":"113974","confirmation_number":"PB12261880633","room_confirmation_number":"PB12394525560","room_stay_from":"2021-11-21","room_stay_to":"2021-11-25","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":"120605","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-04-27 03:08:31","reservation_modified_date_time":"2021-11-21 23:20:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120605","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":"5336871","reservation_id":"125731","confirmation_number":"BV12268195552","room_confirmation_number":"BV12497580112","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","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":"134241","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-21 23:21:20","reservation_modified_date_time":"2021-11-21 23:21:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134241","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":"5336879","reservation_id":"125674","confirmation_number":"PB12268592274","room_confirmation_number":"PB12334397263","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20,20","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":"134186","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-20 02:06:49","reservation_modified_date_time":"2021-11-21 23:34:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134186","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.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":"5336886","reservation_id":"125734","confirmation_number":"BP12211829825","room_confirmation_number":"BP12513693612","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134246","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-21 23:54:34","reservation_modified_date_time":"2021-11-22 00:17:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134246","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":"5336894","reservation_id":"125725","confirmation_number":"BV12255902968","room_confirmation_number":"BV12411739201","room_stay_from":"2021-11-21","room_stay_to":"2021-11-23","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":"134247","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-21 21:08:38","reservation_modified_date_time":"2021-11-22 00:53:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134247","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5336907","reservation_id":"125730","confirmation_number":"BV12254429980","room_confirmation_number":"BV12472119654","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134251","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-21 23:16:34","reservation_modified_date_time":"2021-11-22 02:07:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134251","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":"5336737","reservation_id":"125671","confirmation_number":"BP12226042468","room_confirmation_number":"BP12591571054","room_stay_from":"2021-11-20","room_stay_to":"2021-11-21","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134147","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-20 00:29:58","reservation_modified_date_time":"2021-11-21 14:50:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134206","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5304601","reservation_id":"115342","confirmation_number":"PB12254420664","room_confirmation_number":"PB12322913212","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","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":"95312","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-05-16 18:42:02","reservation_modified_date_time":"2021-08-28 00:29:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]}],"gift_shop_taxable":[{"room_stay_id":"5336728","reservation_id":"125474","confirmation_number":"PB12215120219","room_confirmation_number":"PB12398819884","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":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-21 14:39:20","reservation_modified_date_time":"2021-11-21 14:39:20","customer_id":"134203","parentCustTravId":"134203","customer_traveller_id":"134203","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-11-20","sub_hotel_id":"123","currentDayPrice":"28.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5336740","reservation_id":"125082","confirmation_number":"BV12267506495","room_confirmation_number":"BV12455625417","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-11-21 14:55:30","reservation_modified_date_time":"2021-11-21 14:55:30","customer_id":"134032","parentCustTravId":"134032","customer_traveller_id":"134032","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-11-16","sub_hotel_id":"124","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":"5336741","reservation_id":"125687","confirmation_number":"PB12236541682","room_confirmation_number":"PB12333672706","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-21 14:59:16","reservation_modified_date_time":"2021-11-21 14:59:16","customer_id":"134189","parentCustTravId":"134189","customer_traveller_id":"134189","static_pos_type":"latecheckoutfee","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-11-20","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5336744","reservation_id":"125687","confirmation_number":"PB12292573781","room_confirmation_number":"PB12333672706","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-21 14:59:59","reservation_modified_date_time":"2021-11-21 14:59:59","customer_id":"134189","parentCustTravId":"134189","customer_traveller_id":"134189","static_pos_type":"latecheckoutfee","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-11-20","sub_hotel_id":"123","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5336810","reservation_id":"125709","confirmation_number":"BV12292149898","room_confirmation_number":"BV12477099705","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"45.00","nightly_discount":"0.00","subtotal":"45.00","grand_total":"50.85","paid_amount":"50.85","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-21 18:26:58","reservation_modified_date_time":"2021-11-21 19:03:13","customer_id":"134222","parentCustTravId":"134222","customer_traveller_id":"134222","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-21","sub_hotel_id":"124","currentDayPrice":"45.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5336819","reservation_id":"125579","confirmation_number":"PB12223010492","room_confirmation_number":"PB12362732796","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"85.00","grand_total":"96.05","paid_amount":"96.05","product_id":"2075","service_quantity":"1","product_name":"1\/2 Day Sunset Late Check-out \/ Season","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-21 20:05:47","reservation_modified_date_time":"2021-11-21 20:05:56","customer_id":"134015","parentCustTravId":"134015","customer_traveller_id":"134015","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-11-17","sub_hotel_id":"123","currentDayPrice":"85.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5336827","reservation_id":"125691","confirmation_number":"BP12234114678","room_confirmation_number":"BP12549888091","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":"10.00","paid_amount":"10.00","product_id":"1158","service_quantity":"1","product_name":"Fishing Pole","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-21 20:25:28","reservation_modified_date_time":"2021-11-21 20:25:28","customer_id":"134218","parentCustTravId":"134218","customer_traveller_id":"134218","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-11-21","sub_hotel_id":"125","currentDayPrice":"9.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5336908","reservation_id":"125730","confirmation_number":"PB12224867782","room_confirmation_number":"BV12472119654","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"26.75","paid_amount":"26.75","product_id":"1082","service_quantity":"1","product_name":"Upgrade Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-22 01:58:43","reservation_modified_date_time":"2021-11-22 02:07:58","customer_id":"134251","parentCustTravId":"134251","customer_traveller_id":"134251","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-11-21","sub_hotel_id":"123","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5336911","reservation_id":"125737","confirmation_number":"PB12279046206","room_confirmation_number":"PB12327906977","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.67","grand_total":"5.00","paid_amount":"5.00","product_id":"2008","service_quantity":"1","product_name":"Penny Booklet","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-22 02:13:43","reservation_modified_date_time":"2021-11-22 02:13:43","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.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5336198","reservation_id":"118206","confirmation_number":"BV12214568651","room_confirmation_number":"BV12487077596","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":"30.01","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-19 17:04:28","reservation_modified_date_time":"2021-11-19 17:05:03","customer_id":"134124","parentCustTravId":"134124","customer_traveller_id":"134124","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-11-21 17:51:38","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-19","sub_hotel_id":"124","deltaChange":-28.05,"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":"5336291","reservation_id":"125579","confirmation_number":"PB12231036403","room_confirmation_number":"PB12362732796","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":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-19 18:50:53","reservation_modified_date_time":"2021-11-19 18:50:53","customer_id":"134015","parentCustTravId":"134015","customer_traveller_id":"134015","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-11-21 20:00:23","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-17","sub_hotel_id":"123","deltaChange":-9.35,"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":"5336351","reservation_id":"125145","confirmation_number":"PB12230242391","room_confirmation_number":"PB12359326927","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":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-19 21:55:58","reservation_modified_date_time":"2021-11-19 21:55:58","customer_id":"133371","parentCustTravId":"133371","customer_traveller_id":"133371","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-11-21 14:19:42","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-19","sub_hotel_id":"123","deltaChange":-28.05,"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":"5336387","reservation_id":"125672","confirmation_number":"PB12283865393","room_confirmation_number":"PB12369142547","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-11-20 01:13:04","reservation_modified_date_time":"2021-11-20 01:13:04","customer_id":"134151","parentCustTravId":"134151","customer_traveller_id":"134151","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-11-21 16:54:32","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-19","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":"5336391","reservation_id":"125181","confirmation_number":"BP12281488628","room_confirmation_number":"BP12580130713","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.01","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-20 01:17:43","reservation_modified_date_time":"2021-11-20 01:22:34","customer_id":"134152","parentCustTravId":"134152","customer_traveller_id":"134152","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-11-21 18:09:21","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-19","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":"5336505","reservation_id":"125686","confirmation_number":"PB12220903013","room_confirmation_number":"PB12361268016","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-11-20 16:23:12","reservation_modified_date_time":"2021-11-20 16:23:12","customer_id":"133791","parentCustTravId":"133791","customer_traveller_id":"133791","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-11-22 01:27:59","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-20","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":"5336745","reservation_id":"125687","confirmation_number":"PB12224745345","room_confirmation_number":"PB12333672706","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":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-20 23:00:11","reservation_modified_date_time":"2021-11-20 23:00:11","customer_id":"134189","parentCustTravId":"134189","customer_traveller_id":"134189","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-11-21 20:09:30","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-20","sub_hotel_id":"123","deltaChange":-28.05,"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":[],"ean_taxable":[{"room_stay_id":"5336008","reservation_id":"124867","confirmation_number":"PB12331425460","room_stay_from":"2021-11-18","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"240.15,263.81,263.81,405.85","nightly_discount":"0,0,0,0","subtotal":"1173.62","grand_total":"1326.19","paid_amount":"1326.19","room_type_id":"290","product_id":"1113","siteminder_id":"EAN-1850320018","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134092","customer_id":"134092","source_of_creation":"Expedia","reservation_created_date":"2021-10-29 04:37:01","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":"405.85","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htl_taxable":[{"room_stay_id":"5336824","reservation_id":"125710","confirmation_number":"BP12574889683","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"109.44","nightly_discount":"0","subtotal":"109.44","grand_total":"123.67","paid_amount":"165.36","room_type_id":"302","product_id":"1138","siteminder_id":"HTL-1860827157","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"36.90","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134228","customer_id":"134228","source_of_creation":"Expedia","reservation_created_date":"2021-11-21 16:14:47","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","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":"109.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"}]}]},"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":24,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5336604","reservation_id":"123371","confirmation_number":"PB12360405039","room_stay_from":"2021-11-21","room_stay_to":"2021-11-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"344.65,456.10,456.10","nightly_discount":"0.00,0.00,53.35","subtotal":"1256.85","grand_total":"1359.96","paid_amount":"1359.96","room_type_id":"289","product_id":"1123","siteminder_id":"BDC-3024250011","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"109128","customer_id":"109128","source_of_creation":"Booking.com","reservation_created_date":"2021-09-20 20:16:14","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"202.03","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"344.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336643","reservation_id":"125674","confirmation_number":"PB12313321447","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"190.13,169.72","nightly_discount":"0.00,0.00","subtotal":"359.85","grand_total":"406.63","paid_amount":"406.63","room_type_id":"289","product_id":"1106","siteminder_id":"BDC-3717989730","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134186","customer_id":"134186","source_of_creation":"Booking.com","reservation_created_date":"2021-11-20 02:06:49","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"65.98","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"169.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336680","reservation_id":"125474","confirmation_number":"PB12398819884","room_stay_from":"2021-11-20","room_stay_to":"2021-11-24","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"243.16,227.81,299.48,299.48","nightly_discount":"0,0,0,0","subtotal":"1069.93","grand_total":"1209.03","paid_amount":"1209.03","room_type_id":"291","product_id":"1117","siteminder_id":"BDC-2841362562","collect_which":"hotel_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":"134203","customer_id":"134203","source_of_creation":"Booking.com","reservation_created_date":"2021-11-14 23:44:38","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"178.49","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"227.81","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336877","reservation_id":"125674","confirmation_number":"PB12334397263","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"190.13,169.72","nightly_discount":"0.00,0.00","subtotal":"359.85","grand_total":"406.63","paid_amount":"406.63","room_type_id":"289","product_id":"1103","siteminder_id":"BDC-3717989730","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134186","customer_id":"134186","source_of_creation":"Booking.com","reservation_created_date":"2021-11-20 02:06:49","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"65.98","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"169.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336909","reservation_id":"125730","confirmation_number":"BV12472119654","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.32","nightly_discount":"0","subtotal":"128.32","grand_total":"145.00","paid_amount":"145.00","room_type_id":"285","product_id":"1083","siteminder_id":"BDC-2740423167","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":"134251","customer_id":"134251","source_of_creation":"Booking.com","reservation_created_date":"2021-11-21 23:16:34","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"26.70","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"128.32","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":"5336296","reservation_id":"110316","confirmation_number":"PB12354891843","room_stay_from":"2021-11-19","room_stay_to":"2021-11-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"125.66,125.66,116.42,116.42,116.42,87.78,87.78","nightly_discount":"0,0,0,0,0,0,0","subtotal":"776.14","grand_total":"877.04","paid_amount":"877.04","room_type_id":"291","product_id":"1119","siteminder_id":"EXP-1747666140","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":"134129","customer_id":"134129","source_of_creation":"Expedia","reservation_created_date":"2021-03-14 23:57:07","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","group_rooms":null,"currentDayPrice":"116.42","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":"5336790","reservation_id":"115894","confirmation_number":"PB12384054342","room_stay_from":"2021-11-21","room_stay_to":"2021-11-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"105.78,105.78,105.78,77.13","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"394.47","grand_total":"445.75","paid_amount":"445.75","room_type_id":"292","product_id":"1120","siteminder_id":"EXP-1776009532","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134219","customer_id":"134219","source_of_creation":"Expedia","reservation_created_date":"2021-05-26 02:35: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","currentDayPrice":"105.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3252640","reservation_id":"115342","confirmation_number":"PB12321722129","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"140.00,120.00,120.00,120.00,86.00,86.00,106.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"778.00","grand_total":"879.14","paid_amount":"879.14","room_type_id":"289","product_id":"1102","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":"95312","customer_id":"95312","source_of_creation":"FE","reservation_created_date":"2021-05-16 18:42:01","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5304595","reservation_id":"115342","confirmation_number":"PB12389292828","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,120.00,120.00,120.00,86.00,86.00,106.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"778.00","grand_total":"879.14","paid_amount":"879.14","room_type_id":"289","product_id":"1097","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":"95312","customer_id":"95312","source_of_creation":"FE","reservation_created_date":"2021-05-16 18:42:02","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5304599","reservation_id":"115342","confirmation_number":"PB12322913212","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,120.00,120.00,120.00,86.00,86.00,106.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"778.00","grand_total":"879.14","paid_amount":"879.14","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":"95312","customer_id":"95312","source_of_creation":"FE","reservation_created_date":"2021-05-16 18:42:02","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":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5331784","reservation_id":"110806","confirmation_number":"PB12345072593","room_stay_from":"2021-11-18","room_stay_to":"2021-11-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00,150.00,130.00,130.00,130.00,93.00,93.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"876.00","grand_total":"989.88","paid_amount":"989.88","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":"117323","customer_id":"117323","source_of_creation":"FE","reservation_created_date":"2021-03-20 17:09:23","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","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":"5333034","reservation_id":"116625","confirmation_number":"PB12378215112","room_stay_from":"2021-11-12","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.60,189.60,138.00,138.00,138.00,138.00,138.00,158.00,158.00,138.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1523.20","grand_total":"1721.21","paid_amount":"1721.21","room_type_id":"291","product_id":"1116","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"123517","customer_id":"123517","source_of_creation":"FE","reservation_created_date":"2021-06-05 23:34:15","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"138.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5335712","reservation_id":"125113","confirmation_number":"PB12325449859","room_stay_from":"2021-11-18","room_stay_to":"2021-11-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"143.19,179.57,206.51,241.98,318.03","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1089.28","grand_total":"1230.89","paid_amount":"1230.89","room_type_id":"289","product_id":"1109","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133307","customer_id":"133307","source_of_creation":"FE","reservation_created_date":"2021-11-06 05:51:56","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"241.98","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5335999","reservation_id":"109293","confirmation_number":"PB12338478893","room_stay_from":"2021-11-18","room_stay_to":"2021-11-25","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"206.00,206.00,186.00,186.00,186.00,152.00,152.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,58.20","subtotal":"1274.00","grand_total":"1373.86","paid_amount":"1373.86","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":"106829","customer_id":"106829","source_of_creation":"FE","reservation_created_date":"2021-03-04 02:39:22","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":"186.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336404","reservation_id":"125675","confirmation_number":"PB12388982640","room_stay_from":"2021-11-21","room_stay_to":"2021-11-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"316.57,349.42","nightly_discount":"0.00,0.00","subtotal":"665.99","grand_total":"752.57","paid_amount":"752.57","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":"134157","customer_id":"134157","source_of_creation":"FE","reservation_created_date":"2021-11-20 02:54:52","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":"316.57","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336501","reservation_id":"125015","confirmation_number":"PB12346977496","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"217.89,250.57,301.55","nightly_discount":"0.00,0.00,0.00","subtotal":"770.01","grand_total":"870.11","paid_amount":"870.11","room_type_id":"288","product_id":"1092","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":"133170","customer_id":"133170","source_of_creation":"FE","reservation_created_date":"2021-11-03 19:22:59","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"301.55","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336703","reservation_id":"114303","confirmation_number":"PB12311254322","room_stay_from":"2021-11-20","room_stay_to":"2021-11-26","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,93.00,93.00,113.00","nightly_discount":"0.00,0.00,0.00,0.00,6.72,31.89","subtotal":"689.00","grand_total":"734.94","paid_amount":"734.94","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":"107788","customer_id":"107788","source_of_creation":"FE","reservation_created_date":"2021-05-01 22:37:00","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"5336770","reservation_id":"125387","confirmation_number":"PB12377838387","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"221.50","nightly_discount":"0.00","subtotal":"221.50","grand_total":"250.30","paid_amount":"250.30","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":"133717","customer_id":"133717","source_of_creation":"FE","reservation_created_date":"2021-11-13 04:53:40","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","currentDayPrice":"221.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336868","reservation_id":"113974","confirmation_number":"PB12394525560","room_stay_from":"2021-11-21","room_stay_to":"2021-11-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.00,201.00,201.00,164.00","nightly_discount":"0.00,0.00,0.00,30.70","subtotal":"767.00","grand_total":"832.02","paid_amount":"832.02","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":"120605","customer_id":"120605","source_of_creation":"FE","reservation_created_date":"2021-04-27 03:08:31","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","currentDayPrice":"201.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5330980","reservation_id":"125025","confirmation_number":"PB12335194823","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"179.57,206.51,241.98","nightly_discount":"0.00,0.00,0.00","subtotal":"628.06","grand_total":"709.70","paid_amount":"709.70","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":"133185","customer_id":"133185","source_of_creation":"PMS","reservation_created_date":"2021-11-03 23:29:01","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","group_rooms":null,"currentDayPrice":"241.98","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5335565","reservation_id":"117665","confirmation_number":"PB12322095586","room_stay_from":"2021-11-21","room_stay_to":"2021-11-29","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.00,518.00,518.00,390.37,390.37,465.45,465.45,104.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2989.64","grand_total":"3378.29","paid_amount":"3378.29","room_type_id":"291","product_id":"1118","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":"65989","customer_id":"65989","source_of_creation":"PMS","reservation_created_date":"2021-06-20 00:38:32","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","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":"138.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336619","reservation_id":"125496","confirmation_number":"PB12361754387","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"220.28,221.50","nightly_discount":"0.00,0.00","subtotal":"441.78","grand_total":"499.21","paid_amount":"499.21","room_type_id":"291","product_id":"1115","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":"133883","customer_id":"133883","source_of_creation":"PMS","reservation_created_date":"2021-11-15 17:25:25","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","group_rooms":null,"currentDayPrice":"221.50","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336818","reservation_id":"125579","confirmation_number":"PB12362732796","room_stay_from":"2021-11-17","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.98,122.07,179.57,206.51,205.68","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"829.81","grand_total":"937.69","paid_amount":"937.69","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":"134015","customer_id":"134015","source_of_creation":"PMS","reservation_created_date":"2021-11-17 02:53:31","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","currentDayPrice":"205.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336848","reservation_id":"116592","confirmation_number":"PB12396997296","room_stay_from":"2021-11-21","room_stay_to":"2021-12-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,120.00,120.00,86.00,86.00,106.00,106.00,86.00,86.00,86.00,86.00,86.00,106.00,106.00,86.00,86.00,86.00,86.00,86.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,96.57,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":"1816.00","grand_total":"1942.96","paid_amount":"1942.96","room_type_id":"289","product_id":"1098","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":"91142","customer_id":"91142","source_of_creation":"PMS","reservation_created_date":"2021-06-05 16:26:00","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","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":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3252642","reservation_id":"115342","confirmation_number":"PB12265631850","room_confirmation_number":"PB12321722129","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"95312","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-05-16 18:42:01","reservation_modified_date_time":"2021-05-16 18:42:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","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":"5330851","reservation_id":"125015","confirmation_number":"PB12249403374","room_confirmation_number":"PB12346977496","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"133170","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-03 19:22:59","reservation_modified_date_time":"2021-11-03 19:22:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133170","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330981","reservation_id":"125025","confirmation_number":"PB12292815973","room_confirmation_number":"PB12335194823","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"133185","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-03 23:29:01","reservation_modified_date_time":"2021-11-03 23:29:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133185","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":"5335713","reservation_id":"125113","confirmation_number":"PB12287670758","room_confirmation_number":"PB12325449859","room_stay_from":"2021-11-18","room_stay_to":"2021-11-23","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":"133307","product_attribute_values":"extra_person# ","reservation_created_date":"2021-11-18 01:26:34","reservation_modified_date_time":"2021-11-18 01:26:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133307","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":"5335906","reservation_id":"109293","confirmation_number":"PB12245870201","room_confirmation_number":"PB12338478893","room_stay_from":"2021-11-18","room_stay_to":"2021-11-25","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","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":"106829","product_attribute_values":"extra_person# ","reservation_created_date":"2021-11-18 19:19:53","reservation_modified_date_time":"2021-11-18 19:19:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106829","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":"5336552","reservation_id":"125674","confirmation_number":"PB12223426251","room_confirmation_number":"PB12334397263","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"134186","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-20 02:06:49","reservation_modified_date_time":"2021-11-20 19:34:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134186","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.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":"5336555","reservation_id":"125674","confirmation_number":"PB12266745357","room_confirmation_number":"PB12313321447","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"134186","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-20 02:06:49","reservation_modified_date_time":"2021-11-20 19:37:48","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134186","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.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":"5336601","reservation_id":"123371","confirmation_number":"PB12219987234","room_confirmation_number":"PB12360405039","room_stay_from":"2021-11-21","room_stay_to":"2021-11-24","room_stay_status":"Active","nightly_price":"30,30,30","nightly_discount":"0.00,0.00,0.00","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1780","service_quantity":"1","customer_traveller_id":"109128","product_attribute_values":"extra_person# ","reservation_created_date":"2021-11-20 20:30:13","reservation_modified_date_time":"2021-11-20 20:46:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109128","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336678","reservation_id":"125474","confirmation_number":"PB12238432602","room_confirmation_number":"PB12398819884","room_stay_from":"2021-11-20","room_stay_to":"2021-11-24","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"134203","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-14 23:44:38","reservation_modified_date_time":"2021-11-21 00:57:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134203","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.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":"5336690","reservation_id":"114303","confirmation_number":"PB12242314835","room_confirmation_number":"PB12311254322","room_stay_from":"2021-11-20","room_stay_to":"2021-11-26","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"107788","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-21 01:10:07","reservation_modified_date_time":"2021-11-21 01:10:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107788","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336771","reservation_id":"125387","confirmation_number":"PB12214430856","room_confirmation_number":"PB12377838387","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"133717","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-21 16:27:13","reservation_modified_date_time":"2021-11-21 16:27:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133717","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336788","reservation_id":"115894","confirmation_number":"PB12223511770","room_confirmation_number":"PB12384054342","room_stay_from":"2021-11-21","room_stay_to":"2021-11-25","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0,0,0,0","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"134219","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-21 01:30:04","reservation_modified_date_time":"2021-11-21 17:43:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134219","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3252641","reservation_id":"115342","confirmation_number":"PB12257718919","room_confirmation_number":"PB12321722129","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","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":"95312","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-05-16 18:42:01","reservation_modified_date_time":"2021-05-16 18:42:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","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":"5304596","reservation_id":"115342","confirmation_number":"PB12213207374","room_confirmation_number":"PB12389292828","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","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":"95312","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-05-16 18:42:02","reservation_modified_date_time":"2021-08-28 00:29:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","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":"5304600","reservation_id":"115342","confirmation_number":"PB12254420664","room_confirmation_number":"PB12322913212","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","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":"95312","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-05-16 18:42:02","reservation_modified_date_time":"2021-08-28 00:29:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","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":"5330982","reservation_id":"125025","confirmation_number":"PB12273601975","room_confirmation_number":"PB12335194823","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","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":"133185","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-03 23:29:01","reservation_modified_date_time":"2021-11-03 23:29:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133185","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":"5331785","reservation_id":"110806","confirmation_number":"PB12226917228","room_confirmation_number":"PB12345072593","room_stay_from":"2021-11-18","room_stay_to":"2021-11-25","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":"117323","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-03-20 17:09:23","reservation_modified_date_time":"2021-11-06 19:17:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"117323","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":"5333035","reservation_id":"116625","confirmation_number":"PB12282460298","room_confirmation_number":"PB12378215112","room_stay_from":"2021-11-12","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"123517","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-06-05 23:34:15","reservation_modified_date_time":"2021-11-10 17:36:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123517","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":"5335566","reservation_id":"117665","confirmation_number":"PB12278385554","room_confirmation_number":"PB12322095586","room_stay_from":"2021-11-21","room_stay_to":"2021-11-29","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":"65989","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-06-20 00:38:32","reservation_modified_date_time":"2021-11-17 17:44:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"65989","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":"5335714","reservation_id":"125113","confirmation_number":"PB12284362783","room_confirmation_number":"PB12325449859","room_stay_from":"2021-11-18","room_stay_to":"2021-11-23","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":"133307","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-06 05:51:56","reservation_modified_date_time":"2021-11-18 01:26:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133307","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":"5336000","reservation_id":"109293","confirmation_number":"PB12241151145","room_confirmation_number":"PB12338478893","room_stay_from":"2021-11-18","room_stay_to":"2021-11-25","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":"106829","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-03-04 02:39:22","reservation_modified_date_time":"2021-11-18 20:07:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"106829","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":"5336007","reservation_id":"124867","confirmation_number":"PB12253367944","room_confirmation_number":"PB12331425460","room_stay_from":"2021-11-18","room_stay_to":"2021-11-22","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":"134092","product_attribute_values":"resort_fee# ","reservation_created_date":"2021-10-29 04:37:01","reservation_modified_date_time":"2021-11-18 21:23:00","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134092","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.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":"5336295","reservation_id":"110316","confirmation_number":"PB12257746671","room_confirmation_number":"PB12354891843","room_stay_from":"2021-11-19","room_stay_to":"2021-11-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"134129","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-14 23:57:07","reservation_modified_date_time":"2021-11-19 19:27:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134129","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":"5336405","reservation_id":"125675","confirmation_number":"PB12245571508","room_confirmation_number":"PB12388982640","room_stay_from":"2021-11-21","room_stay_to":"2021-11-23","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":"134157","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-20 02:54:52","reservation_modified_date_time":"2021-11-20 02:54:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134157","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":"5336503","reservation_id":"125015","confirmation_number":"PB12253333104","room_confirmation_number":"PB12346977496","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","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":"133170","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-03 19:22:59","reservation_modified_date_time":"2021-11-20 16:00:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133170","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":"5336605","reservation_id":"123371","confirmation_number":"PB12236341418","room_confirmation_number":"PB12360405039","room_stay_from":"2021-11-21","room_stay_to":"2021-11-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"109128","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-20 20:16:14","reservation_modified_date_time":"2021-11-20 20:47:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109128","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.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":"5336620","reservation_id":"125496","confirmation_number":"PB12214242468","room_confirmation_number":"PB12361754387","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","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":"133883","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-15 17:25:25","reservation_modified_date_time":"2021-11-20 21:47:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133883","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":"5336645","reservation_id":"125674","confirmation_number":"PB12211037122","room_confirmation_number":"PB12313321447","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20,20","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":"134186","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-20 02:06:49","reservation_modified_date_time":"2021-11-20 23:18:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134186","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.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":"5336679","reservation_id":"125474","confirmation_number":"PB12232137320","room_confirmation_number":"PB12398819884","room_stay_from":"2021-11-20","room_stay_to":"2021-11-24","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":"134203","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-14 23:44:38","reservation_modified_date_time":"2021-11-21 00:57:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134203","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":"5336704","reservation_id":"114303","confirmation_number":"PB12255938433","room_confirmation_number":"PB12311254322","room_stay_from":"2021-11-20","room_stay_to":"2021-11-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"107788","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-05-01 22:37:00","reservation_modified_date_time":"2021-11-21 01:13:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107788","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":"5336772","reservation_id":"125387","confirmation_number":"PB12241226753","room_confirmation_number":"PB12377838387","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","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":"133717","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-13 04:53:40","reservation_modified_date_time":"2021-11-21 16:27:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133717","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":"5336789","reservation_id":"115894","confirmation_number":"PB12246642589","room_confirmation_number":"PB12384054342","room_stay_from":"2021-11-21","room_stay_to":"2021-11-25","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":"134219","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-26 02:35:10","reservation_modified_date_time":"2021-11-21 17:43:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134219","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.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":"5336820","reservation_id":"125579","confirmation_number":"PB12241682699","room_confirmation_number":"PB12362732796","room_stay_from":"2021-11-17","room_stay_to":"2021-11-22","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":"134015","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-17 02:53:31","reservation_modified_date_time":"2021-11-21 20:05:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134015","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":"5336849","reservation_id":"116592","confirmation_number":"PB12252831863","room_confirmation_number":"PB12396997296","room_stay_from":"2021-11-21","room_stay_to":"2021-12-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"228.00","grand_total":"257.64","paid_amount":"257.64","product_id":"1781","service_quantity":"1","customer_traveller_id":"91142","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-06-05 16:26:00","reservation_modified_date_time":"2021-11-21 21:20:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91142","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":"5336869","reservation_id":"113974","confirmation_number":"PB12261880633","room_confirmation_number":"PB12394525560","room_stay_from":"2021-11-21","room_stay_to":"2021-11-25","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":"120605","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-04-27 03:08:31","reservation_modified_date_time":"2021-11-21 23:20:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"120605","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":"5336879","reservation_id":"125674","confirmation_number":"PB12268592274","room_confirmation_number":"PB12334397263","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20,20","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":"134186","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-20 02:06:49","reservation_modified_date_time":"2021-11-21 23:34:51","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134186","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.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":"5336907","reservation_id":"125730","confirmation_number":"BV12254429980","room_confirmation_number":"BV12472119654","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134251","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-21 23:16:34","reservation_modified_date_time":"2021-11-22 02:07:58","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134251","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"}]}],"resort_fee_non_taxable":[{"room_stay_id":"5304601","reservation_id":"115342","confirmation_number":"PB12254420664","room_confirmation_number":"PB12322913212","room_stay_from":"2021-11-20","room_stay_to":"2021-11-27","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":"95312","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-05-16 18:42:02","reservation_modified_date_time":"2021-08-28 00:29:34","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95312","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[]}],"gift_shop_taxable":[{"room_stay_id":"5336728","reservation_id":"125474","confirmation_number":"PB12215120219","room_confirmation_number":"PB12398819884","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":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-21 14:39:20","reservation_modified_date_time":"2021-11-21 14:39:20","customer_id":"134203","parentCustTravId":"134203","customer_traveller_id":"134203","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-11-20","sub_hotel_id":"123","currentDayPrice":"28.05","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5336741","reservation_id":"125687","confirmation_number":"PB12236541682","room_confirmation_number":"PB12333672706","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-21 14:59:16","reservation_modified_date_time":"2021-11-21 14:59:16","customer_id":"134189","parentCustTravId":"134189","customer_traveller_id":"134189","static_pos_type":"latecheckoutfee","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-11-20","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5336744","reservation_id":"125687","confirmation_number":"PB12292573781","room_confirmation_number":"PB12333672706","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-21 14:59:59","reservation_modified_date_time":"2021-11-21 14:59:59","customer_id":"134189","parentCustTravId":"134189","customer_traveller_id":"134189","static_pos_type":"latecheckoutfee","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-11-20","sub_hotel_id":"123","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5336819","reservation_id":"125579","confirmation_number":"PB12223010492","room_confirmation_number":"PB12362732796","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"85.00","grand_total":"96.05","paid_amount":"96.05","product_id":"2075","service_quantity":"1","product_name":"1\/2 Day Sunset Late Check-out \/ Season","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-21 20:05:47","reservation_modified_date_time":"2021-11-21 20:05:56","customer_id":"134015","parentCustTravId":"134015","customer_traveller_id":"134015","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-11-17","sub_hotel_id":"123","currentDayPrice":"85.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5336908","reservation_id":"125730","confirmation_number":"PB12224867782","room_confirmation_number":"BV12472119654","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"26.75","paid_amount":"26.75","product_id":"1082","service_quantity":"1","product_name":"Upgrade Fee","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-22 01:58:43","reservation_modified_date_time":"2021-11-22 02:07:58","customer_id":"134251","parentCustTravId":"134251","customer_traveller_id":"134251","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-11-21","sub_hotel_id":"123","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5336911","reservation_id":"125737","confirmation_number":"PB12279046206","room_confirmation_number":"PB12327906977","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.67","grand_total":"5.00","paid_amount":"5.00","product_id":"2008","service_quantity":"1","product_name":"Penny Booklet","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-22 02:13:43","reservation_modified_date_time":"2021-11-22 02:13:43","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.67","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5336291","reservation_id":"125579","confirmation_number":"PB12231036403","room_confirmation_number":"PB12362732796","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":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-19 18:50:53","reservation_modified_date_time":"2021-11-19 18:50:53","customer_id":"134015","parentCustTravId":"134015","customer_traveller_id":"134015","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-11-21 20:00:23","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-17","sub_hotel_id":"123","deltaChange":-9.35,"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":"5336351","reservation_id":"125145","confirmation_number":"PB12230242391","room_confirmation_number":"PB12359326927","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":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-19 21:55:58","reservation_modified_date_time":"2021-11-19 21:55:58","customer_id":"133371","parentCustTravId":"133371","customer_traveller_id":"133371","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-11-21 14:19:42","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-19","sub_hotel_id":"123","deltaChange":-28.05,"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":"5336387","reservation_id":"125672","confirmation_number":"PB12283865393","room_confirmation_number":"PB12369142547","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-11-20 01:13:04","reservation_modified_date_time":"2021-11-20 01:13:04","customer_id":"134151","parentCustTravId":"134151","customer_traveller_id":"134151","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-11-21 16:54:32","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-19","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":"5336505","reservation_id":"125686","confirmation_number":"PB12220903013","room_confirmation_number":"PB12361268016","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-11-20 16:23:12","reservation_modified_date_time":"2021-11-20 16:23:12","customer_id":"133791","parentCustTravId":"133791","customer_traveller_id":"133791","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-11-22 01:27:59","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-20","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":"5336745","reservation_id":"125687","confirmation_number":"PB12224745345","room_confirmation_number":"PB12333672706","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":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-20 23:00:11","reservation_modified_date_time":"2021-11-20 23:00:11","customer_id":"134189","parentCustTravId":"134189","customer_traveller_id":"134189","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-11-21 20:09:30","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-20","sub_hotel_id":"123","deltaChange":-28.05,"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":[],"ean_taxable":[{"room_stay_id":"5336008","reservation_id":"124867","confirmation_number":"PB12331425460","room_stay_from":"2021-11-18","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"240.15,263.81,263.81,405.85","nightly_discount":"0,0,0,0","subtotal":"1173.62","grand_total":"1326.19","paid_amount":"1326.19","room_type_id":"290","product_id":"1113","siteminder_id":"EAN-1850320018","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134092","customer_id":"134092","source_of_creation":"Expedia","reservation_created_date":"2021-10-29 04:37:01","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":"405.85","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htl_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":9,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5335623","reservation_id":"125082","confirmation_number":"BV12455625417","room_stay_from":"2021-11-16","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.13,155.56,155.56,195.39,224.70,262.91","nightly_discount":"0,0,0,0,0,0","subtotal":"1193.25","grand_total":"1348.38","paid_amount":"1348.38","room_type_id":"306","product_id":"1223","siteminder_id":"BDC-2417146013","collect_which":"hotel_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":"134032","customer_id":"134032","source_of_creation":"Booking.com","reservation_created_date":"2021-11-05 15:43:51","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"236.38","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"262.91","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":"5336811","reservation_id":"125709","confirmation_number":"BV12477099705","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"128.79","nightly_discount":"0","subtotal":"128.79","grand_total":"145.54","paid_amount":"145.54","room_type_id":"304","product_id":"1218","siteminder_id":"BDC-3389001666","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":"134222","customer_id":"134222","source_of_creation":"Booking.com","reservation_created_date":"2021-11-21 13:09:13","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"26.78","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"128.79","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":"5336895","reservation_id":"125725","confirmation_number":"BV12411739201","room_stay_from":"2021-11-21","room_stay_to":"2021-11-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.21,125.00","nightly_discount":"0.00,0.00","subtotal":"215.21","grand_total":"243.18","paid_amount":"243.18","room_type_id":"304","product_id":"1219","siteminder_id":"EXP-1860927633","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":"134247","customer_id":"134247","source_of_creation":"Expedia","reservation_created_date":"2021-11-21 21:08:38","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","currentDayPrice":"90.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5336870","reservation_id":"125731","confirmation_number":"BV12497580112","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.22","nightly_discount":"0.00","subtotal":"93.22","grand_total":"105.34","paid_amount":"105.34","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":"134241","customer_id":"134241","source_of_creation":"FE","reservation_created_date":"2021-11-21 23:21:20","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":"93.22","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5333378","reservation_id":"124966","confirmation_number":"BV12483666991","room_stay_from":"2021-11-01","room_stay_to":"2021-11-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.56,61.56,61.56,61.56,110.00,115.00,75.00,75.00,75.00,65.00,70.00,70.00,70.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00,65.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,16.36,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0,0","subtotal":"2011.24","grand_total":"2254.21","paid_amount":"2090.12","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":"133111","customer_id":"133111","source_of_creation":"PMS","reservation_created_date":"2021-11-02 00:58:54","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":"65.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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"5333379","reservation_id":"124966","confirmation_number":"BV12273316504","room_confirmation_number":"BV12483666991","room_stay_from":"2021-11-01","room_stay_to":"2021-11-30","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"348.00","grand_total":"393.24","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"133111","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-02 00:58:54","reservation_modified_date_time":"2021-11-11 14:34:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133111","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":"5335622","reservation_id":"125082","confirmation_number":"BV12253797716","room_confirmation_number":"BV12455625417","room_stay_from":"2021-11-16","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134032","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-05 15:43:51","reservation_modified_date_time":"2021-11-17 20:09:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134032","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"124","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":"5336809","reservation_id":"125709","confirmation_number":"BV12211614534","room_confirmation_number":"BV12477099705","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134222","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-21 13:09:13","reservation_modified_date_time":"2021-11-21 19:03:13","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134222","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5336871","reservation_id":"125731","confirmation_number":"BV12268195552","room_confirmation_number":"BV12497580112","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","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":"134241","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-21 23:21:20","reservation_modified_date_time":"2021-11-21 23:21:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134241","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":"5336894","reservation_id":"125725","confirmation_number":"BV12255902968","room_confirmation_number":"BV12411739201","room_stay_from":"2021-11-21","room_stay_to":"2021-11-23","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":"134247","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-21 21:08:38","reservation_modified_date_time":"2021-11-22 00:53:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134247","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5336740","reservation_id":"125082","confirmation_number":"BV12267506495","room_confirmation_number":"BV12455625417","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-11-21 14:55:30","reservation_modified_date_time":"2021-11-21 14:55:30","customer_id":"134032","parentCustTravId":"134032","customer_traveller_id":"134032","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-11-16","sub_hotel_id":"124","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":"5336810","reservation_id":"125709","confirmation_number":"BV12292149898","room_confirmation_number":"BV12477099705","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"45.00","nightly_discount":"0.00","subtotal":"45.00","grand_total":"50.85","paid_amount":"50.85","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-21 18:26:58","reservation_modified_date_time":"2021-11-21 19:03:13","customer_id":"134222","parentCustTravId":"134222","customer_traveller_id":"134222","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-21","sub_hotel_id":"124","currentDayPrice":"45.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5336198","reservation_id":"118206","confirmation_number":"BV12214568651","room_confirmation_number":"BV12487077596","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":"30.01","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-19 17:04:28","reservation_modified_date_time":"2021-11-19 17:05:03","customer_id":"134124","parentCustTravId":"134124","customer_traveller_id":"134124","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-11-21 17:51:38","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-19","sub_hotel_id":"124","deltaChange":-28.05,"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":[],"ean_taxable":[],"htl_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":11,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1131,1130,1125","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BP12248230106","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","bundle_room":"0","product_id":"1131"},{"confirmation_number":"BP12278577907","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","bundle_room":"0","product_id":"1130"},{"confirmation_number":"BP12215165739","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","bundle_room":"0","product_id":"1125"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5336127","reservation_id":"125650","confirmation_number":"BP12555999255","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.41,166.50","nightly_discount":"0,0","subtotal":"307.91","grand_total":"347.93","paid_amount":"347.93","room_type_id":"295","product_id":"1128","siteminder_id":"BDC-3662288494","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":"134116","customer_id":"134116","source_of_creation":"Booking.com","reservation_created_date":"2021-11-19 15:19:18","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"62.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"166.50","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":"5336285","reservation_id":"125652","confirmation_number":"BP12518936879","room_stay_from":"2021-11-19","room_stay_to":"2021-11-26","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"134.34,154.49,181.89,95.17,95.17,126.68,143.95","nightly_discount":"0,0,0,0,0,0,0","subtotal":"931.69","grand_total":"1052.81","paid_amount":"1052.81","room_type_id":"301","product_id":"1136","siteminder_id":"BDC-3946159787","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":"134127","customer_id":"134127","source_of_creation":"Booking.com","reservation_created_date":"2021-11-19 15:37:06","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 807","ota_service_fee_amount":"0","commision_charges":"192.90","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"181.89","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336332","reservation_id":"117942","confirmation_number":"BP12538442226","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.83,120.83,107.33","nightly_discount":"0,0,0","subtotal":"348.99","grand_total":"394.36","paid_amount":"394.36","room_type_id":"298","product_id":"1133","siteminder_id":"BDC-2431052168","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":"134136","customer_id":"134136","source_of_creation":"Booking.com","reservation_created_date":"2021-06-24 01:52:09","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"73.62","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"107.33","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":"5336826","reservation_id":"125691","confirmation_number":"BP12549888091","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.85","nightly_discount":"0","subtotal":"90.85","grand_total":"102.66","paid_amount":"102.66","room_type_id":"295","product_id":"1129","siteminder_id":"BDC-3807705905","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":"134218","customer_id":"134218","source_of_creation":"Booking.com","reservation_created_date":"2021-11-20 18:31:40","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"19.95","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"90.85","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336829","reservation_id":"125671","confirmation_number":"BP12560615013","room_stay_from":"2021-11-21","room_stay_to":"2021-11-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.65,97.07,97.07","nightly_discount":"0.00,0.00,0.00","subtotal":"307.79","grand_total":"347.81","paid_amount":"347.81","room_type_id":"294","product_id":"1126","siteminder_id":"BDC-3260915475","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":"134206","customer_id":"134206","source_of_creation":"Booking.com","reservation_created_date":"2021-11-21 14:50:55","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 806","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":"113.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5336887","reservation_id":"125734","confirmation_number":"BP12513693612","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.40","nightly_discount":"0","subtotal":"90.40","grand_total":"102.15","paid_amount":"102.15","room_type_id":"294","product_id":"1127","siteminder_id":"BDC-3946124467","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":"134246","customer_id":"134246","source_of_creation":"Booking.com","reservation_created_date":"2021-11-21 23:54:34","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 822","ota_service_fee_amount":"0","commision_charges":"19.87","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"90.40","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":"5336736","reservation_id":"125671","confirmation_number":"BP12591571054","room_stay_from":"2021-11-20","room_stay_to":"2021-11-21","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.92","nightly_discount":"0","subtotal":"144.92","grand_total":"163.76","paid_amount":"163.76","room_type_id":"294","product_id":"1125","siteminder_id":"BDC-3260915475","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":"134206","customer_id":"134206","source_of_creation":"Booking.com","reservation_created_date":"2021-11-20 00:29:58","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","ota_service_fee_amount":"0","commision_charges":"95.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","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"}]}],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[{"room_stay_id":"5336794","reservation_id":"118538","confirmation_number":"BP12535080946","room_stay_from":"2021-11-20","room_stay_to":"2021-11-21","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"142.91","nightly_discount":"0.00","subtotal":"142.91","grand_total":"161.48","paid_amount":"161.48","room_type_id":"300","product_id":"1135","siteminder_id":"EXP-1794741800","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"125572","customer_id":"125572","source_of_creation":"Expedia","reservation_created_date":"2021-07-02 17:15:07","service_canceled_date_time":"2021-11-21 17:55:43","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 805","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"","total_paid_amount":"184.08","sub_hotel_id":"125","deltaChange":"22.60","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"5331958","reservation_id":"125144","confirmation_number":"BP12585573095","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"146.13","nightly_discount":"0.00","subtotal":"146.13","grand_total":"165.13","paid_amount":"165.13","room_type_id":"299","product_id":"1134","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":"133370","customer_id":"133370","source_of_creation":"FE","reservation_created_date":"2021-11-07 15:49:49","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":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"146.13","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3303376","reservation_id":"121284","confirmation_number":"BP12554386129","room_stay_from":"2021-11-21","room_stay_to":"2021-11-23","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"288.47,289.87","nightly_discount":"0.00,0.00","subtotal":"578.34","grand_total":"653.52","paid_amount":"653.52","room_type_id":"293","product_id":"1124","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":"128754","customer_id":"128754","source_of_creation":"PMS","reservation_created_date":"2021-08-16 16:29:03","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","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":"288.47","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5336822","reservation_id":"125710","confirmation_number":"BP12259068125","room_confirmation_number":"BP12574889683","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"36.9","nightly_discount":"0.00","subtotal":"36.90","grand_total":"41.69","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"134228","product_attribute_values":"extra_person# .30","reservation_created_date":"2021-11-21 16:14:47","reservation_modified_date_time":"2021-11-21 20:19:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134228","canceled_nights_data":"","posAmt_airbnb_taxpaid":"36.90","sub_hotel_id":"125","currentDayPrice":"36.9","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3276846","reservation_id":"118538","confirmation_number":"BP12264678717","room_confirmation_number":"BP12535080946","room_stay_from":"2021-11-20","room_stay_to":"2021-11-21","room_stay_status":"Canceled","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2021-07-02 17:15:07","reservation_modified_date_time":"2021-07-02 17:15:07","customer_id":"125572","parentCustTravId":"125572","customer_traveller_id":"125572","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-11-21 17:55:43","canceled_nights_data":"","product_attribute_values":"extra_person# .00","parentRoomStayFrom":"2021-11-20","sub_hotel_id":"125","deltaChange":-20,"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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3303377","reservation_id":"121284","confirmation_number":"BP12263585898","room_confirmation_number":"BP12554386129","room_stay_from":"2021-11-21","room_stay_to":"2021-11-23","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":"128754","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-08-16 16:29:03","reservation_modified_date_time":"2021-08-16 16:29:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128754","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":"5331959","reservation_id":"125144","confirmation_number":"BP12235096007","room_confirmation_number":"BP12585573095","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","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":"133370","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-07 15:49:49","reservation_modified_date_time":"2021-11-07 15:49:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133370","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":"5336128","reservation_id":"125650","confirmation_number":"BP12221549386","room_confirmation_number":"BP12555999255","room_stay_from":"2021-11-20","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20,20","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":"134117","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-19 15:19:18","reservation_modified_date_time":"2021-11-19 15:19:18","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134116","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":"5336284","reservation_id":"125652","confirmation_number":"BP12292287137","room_confirmation_number":"BP12518936879","room_stay_from":"2021-11-19","room_stay_to":"2021-11-26","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"134127","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-19 15:37:06","reservation_modified_date_time":"2021-11-19 18:35:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134127","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":"5336331","reservation_id":"117942","confirmation_number":"BP12299793709","room_confirmation_number":"BP12538442226","room_stay_from":"2021-11-19","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"134136","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-24 01:52:09","reservation_modified_date_time":"2021-11-19 21:18:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134136","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":"5336823","reservation_id":"125710","confirmation_number":"BP12219787756","room_confirmation_number":"BP12574889683","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"134228","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-21 16:14:47","reservation_modified_date_time":"2021-11-21 20:19:53","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134228","canceled_nights_data":"","posAmt_airbnb_taxpaid":"36.90","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":"5336825","reservation_id":"125691","confirmation_number":"BP12249898724","room_confirmation_number":"BP12549888091","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134218","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-20 18:31:40","reservation_modified_date_time":"2021-11-21 20:24:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134218","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":"5336828","reservation_id":"125671","confirmation_number":"BP12226128295","room_confirmation_number":"BP12560615013","room_stay_from":"2021-11-21","room_stay_to":"2021-11-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.79","product_id":"1781","service_quantity":"1","customer_traveller_id":"134206","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-21 14:50:55","reservation_modified_date_time":"2021-11-21 20:27:55","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134206","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":"5336886","reservation_id":"125734","confirmation_number":"BP12211829825","room_confirmation_number":"BP12513693612","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134246","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-21 23:54:34","reservation_modified_date_time":"2021-11-22 00:17:29","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134246","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":"5336737","reservation_id":"125671","confirmation_number":"BP12226042468","room_confirmation_number":"BP12591571054","room_stay_from":"2021-11-20","room_stay_to":"2021-11-21","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134147","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-20 00:29:58","reservation_modified_date_time":"2021-11-21 14:50:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134206","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5336827","reservation_id":"125691","confirmation_number":"BP12234114678","room_confirmation_number":"BP12549888091","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":"10.00","paid_amount":"10.00","product_id":"1158","service_quantity":"1","product_name":"Fishing Pole","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-21 20:25:28","reservation_modified_date_time":"2021-11-21 20:25:28","customer_id":"134218","parentCustTravId":"134218","customer_traveller_id":"134218","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-11-21","sub_hotel_id":"125","currentDayPrice":"9.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5336391","reservation_id":"125181","confirmation_number":"BP12281488628","room_confirmation_number":"BP12580130713","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.01","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-20 01:17:43","reservation_modified_date_time":"2021-11-20 01:22:34","customer_id":"134152","parentCustTravId":"134152","customer_traveller_id":"134152","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-11-21 18:09:21","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-19","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":[],"ean_taxable":[],"htl_taxable":[{"room_stay_id":"5336824","reservation_id":"125710","confirmation_number":"BP12574889683","room_stay_from":"2021-11-21","room_stay_to":"2021-11-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"109.44","nightly_discount":"0","subtotal":"109.44","grand_total":"123.67","paid_amount":"165.36","room_type_id":"302","product_id":"1138","siteminder_id":"HTL-1860827157","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"36.90","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134228","customer_id":"134228","source_of_creation":"Expedia","reservation_created_date":"2021-11-21 16:14:47","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","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":"109.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"}]}]}}}