{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2021-12-05","total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,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":41,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1134,1127,1136,1124,1111","block_room_bookings":[{"confirmation_number":"BP12239593862","room_stay_from":"2021-12-05","room_stay_to":"2021-12-09","bundle_room":"0","product_id":"1134"},{"confirmation_number":"BP12252828856","room_stay_from":"2021-12-05","room_stay_to":"2021-12-09","bundle_room":"0","product_id":"1127"},{"confirmation_number":"BP12217136296","room_stay_from":"2021-11-30","room_stay_to":"2021-12-06","bundle_room":"0","product_id":"1136"},{"confirmation_number":"BP12266616944","room_stay_from":"2021-11-30","room_stay_to":"2021-12-06","bundle_room":"0","product_id":"1124"},{"confirmation_number":"PB12225469440","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","bundle_room":"0","product_id":"1111"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5340357","reservation_id":"124972","confirmation_number":"BP12573152162","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.69,138.69,118.88","nightly_discount":"0,0,0","subtotal":"396.26","grand_total":"447.78","paid_amount":"447.78","room_type_id":"301","product_id":"1137","siteminder_id":"BDC-3476015458","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134893","customer_id":"134893","source_of_creation":"Booking.com","reservation_created_date":"2021-11-02 09:20:16","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 824","ota_service_fee_amount":"0","commision_charges":"82.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"118.88","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":"5340390","reservation_id":"126227","confirmation_number":"PB12380026764","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"157.77,157.77,139.95","nightly_discount":"0,0,0","subtotal":"455.49","grand_total":"514.70","paid_amount":"514.70","room_type_id":"289","product_id":"1103","siteminder_id":"BDC-2591608120","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":"134902","customer_id":"134902","source_of_creation":"Booking.com","reservation_created_date":"2021-12-03 04:29:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"77.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"139.95","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":"5340627","reservation_id":"126116","confirmation_number":"PB12375974797","room_stay_from":"2021-12-05","room_stay_to":"2021-12-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.79,124.79,124.79","nightly_discount":"0,0,0","subtotal":"374.37","grand_total":"423.04","paid_amount":"423.04","room_type_id":"290","product_id":"1113","siteminder_id":"BDC-3367665433","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":"134961","customer_id":"134961","source_of_creation":"Booking.com","reservation_created_date":"2021-11-30 03:14:03","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"65.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"124.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":"5340691","reservation_id":"120337","confirmation_number":"PB12320724727","room_stay_from":"2021-12-04","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"100.36,89.02","nightly_discount":"0.00,0.00","subtotal":"189.38","grand_total":"214.00","paid_amount":"214.00","room_type_id":"289","product_id":"1106","siteminder_id":"BDC-3680915643","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":"134929","customer_id":"127605","source_of_creation":"Booking.com","reservation_created_date":"2021-07-29 13:49:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"34.41","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"89.02","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340888","reservation_id":"126265","confirmation_number":"PB12398161714","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"182.80","nightly_discount":"0","subtotal":"182.80","grand_total":"206.57","paid_amount":"206.57","room_type_id":"289","product_id":"1123","siteminder_id":"BDC-2597095042","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":"135002","customer_id":"135002","source_of_creation":"Booking.com","reservation_created_date":"2021-12-04 00:03:19","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"30.42","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"182.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340893","reservation_id":"126305","confirmation_number":"PB12325439575","room_stay_from":"2021-12-05","room_stay_to":"2021-12-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.46,110.46,110.46,110.46","nightly_discount":"0,0,0,0","subtotal":"441.84","grand_total":"499.28","paid_amount":"499.28","room_type_id":"289","product_id":"1121","siteminder_id":"BDC-3529969793","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":"135003","customer_id":"135003","source_of_creation":"Booking.com","reservation_created_date":"2021-12-05 15:47:50","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"78.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"110.46","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":"5340897","reservation_id":"120806","confirmation_number":"PB12344003284","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.02,89.02","nightly_discount":"0,0","subtotal":"178.04","grand_total":"201.18","paid_amount":"201.18","room_type_id":"289","product_id":"1096","siteminder_id":"BDC-2303261997","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":"135004","customer_id":"135004","source_of_creation":"Booking.com","reservation_created_date":"2021-08-06 03:40:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"32.71","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"89.02","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":"5340928","reservation_id":"125780","confirmation_number":"PB12390311525","room_stay_from":"2021-12-05","room_stay_to":"2021-12-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"177.15,177.15,177.15","nightly_discount":"0.00,0.00,0.00","subtotal":"531.45","grand_total":"600.54","paid_amount":"600.54","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-2905728656","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":"135008","customer_id":"135008","source_of_creation":"Booking.com","reservation_created_date":"2021-11-23 01:19:16","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"88.72","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"177.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340979","reservation_id":"126327","confirmation_number":"BP12586651637","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.96","nightly_discount":"0","subtotal":"62.96","grand_total":"71.15","paid_amount":"71.15","room_type_id":"295","product_id":"1128","siteminder_id":"BDC-2561387818","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":"135022","customer_id":"135022","source_of_creation":"Booking.com","reservation_created_date":"2021-12-05 23:29:59","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"14.93","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"62.96","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":[{"room_stay_id":"3216183","reservation_id":"107378","confirmation_number":"PB12328766559","room_stay_from":"2021-12-05","room_stay_to":"2021-12-10","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"103.78","room_type_id":"285","product_id":"1083","siteminder_id":"BDC-2751608680","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":"113834","customer_id":"113834","source_of_creation":"Booking.com","reservation_created_date":"2021-02-11 22:56:11","service_canceled_date_time":"2021-08-03 18:18:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"97.40","sub_hotel_id":"123","deltaChange":"103.78","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"5339354","reservation_id":"118828","confirmation_number":"PB12342029860","room_stay_from":"2021-11-30","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.06,109.06,109.06,120.54,120.54,109.06,109.06","nightly_discount":"0,0,0,0,0,0,0","subtotal":"786.38","grand_total":"888.61","paid_amount":"888.61","room_type_id":"291","product_id":"1117","siteminder_id":"EXP-1796783469","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":"134746","customer_id":"134746","source_of_creation":"Expedia","reservation_created_date":"2021-07-06 22:05:07","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"109.06","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":"5340122","reservation_id":"124773","confirmation_number":"PB12383330337","room_stay_from":"2021-12-02","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.34,162.73,162.73,144.34","nightly_discount":"0,0,0,0","subtotal":"614.14","grand_total":"693.98","paid_amount":"693.98","room_type_id":"289","product_id":"1101","siteminder_id":"EXP-1848741293","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":"134871","customer_id":"134871","source_of_creation":"Expedia","reservation_created_date":"2021-10-25 22:12:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"144.34","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340380","reservation_id":"125550","confirmation_number":"BP12550461309","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"207.95,207.95,188.79","nightly_discount":"0,0,0","subtotal":"604.69","grand_total":"683.30","paid_amount":"683.30","room_type_id":"296","product_id":"1131","siteminder_id":"EXP-1858625840","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":"134897","customer_id":"134897","source_of_creation":"Expedia","reservation_created_date":"2021-11-16 17:27:54","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","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":"188.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":"5340477","reservation_id":"125843","confirmation_number":"PB12327237479","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"180.20,180.20,163.03","nightly_discount":"0,0,0","subtotal":"523.43","grand_total":"591.48","paid_amount":"591.48","room_type_id":"291","product_id":"1116","siteminder_id":"EXP-1862084786","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":"134934","customer_id":"134934","source_of_creation":"Expedia","reservation_created_date":"2021-11-24 07:16:40","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":"163.03","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":"5340629","reservation_id":"125700","confirmation_number":"PB12318293221","room_stay_from":"2021-12-04","room_stay_to":"2021-12-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.73,144.34,144.34,144.34","nightly_discount":"0,0,0,0","subtotal":"595.75","grand_total":"673.20","paid_amount":"673.20","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1860604932","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":"134962","customer_id":"134962","source_of_creation":"Expedia","reservation_created_date":"2021-11-20 23:03:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"144.34","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340738","reservation_id":"126252","confirmation_number":"PB12398735676","room_stay_from":"2021-12-04","room_stay_to":"2021-12-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.27,96.94,96.94,96.94","nightly_discount":"0,0,0,0","subtotal":"400.09","grand_total":"452.11","paid_amount":"452.11","room_type_id":"289","product_id":"1110","siteminder_id":"EXP-1866028709","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":"134978","customer_id":"134978","source_of_creation":"Expedia","reservation_created_date":"2021-12-03 20:13:52","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"96.94","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340914","reservation_id":"126294","confirmation_number":"PB12318985645","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"136.84","nightly_discount":"0.00","subtotal":"136.84","grand_total":"154.63","paid_amount":"154.63","room_type_id":"291","product_id":"1118","siteminder_id":"EXP-1866429941","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":"135005","customer_id":"135005","source_of_creation":"Expedia","reservation_created_date":"2021-12-05 00:01:37","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":null,"sub_hotel_id":"123","currentDayPrice":"136.84","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5340854","reservation_id":"126309","confirmation_number":"BP12533845423","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"50.55","nightly_discount":"0","subtotal":"50.55","grand_total":"57.12","paid_amount":"57.12","room_type_id":"295","product_id":"1128","siteminder_id":"EXP-1866619399","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":"134994","customer_id":"134994","source_of_creation":"Expedia","reservation_created_date":"2021-12-05 17:11:48","service_canceled_date_time":"2021-12-05 18:23:13","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"125","deltaChange":"57.12","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5340882","reservation_id":"126314","confirmation_number":"BP12579586833","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"69.74","nightly_discount":"0","subtotal":"69.74","grand_total":"78.80","paid_amount":"78.80","room_type_id":"294","product_id":"1125","siteminder_id":"EXP-1866647455","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":"135001","customer_id":"135001","source_of_creation":"Expedia","reservation_created_date":"2021-12-05 19:35:17","service_canceled_date_time":"2021-12-06 00:39:11","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"125","deltaChange":"78.80","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":"3258716","reservation_id":"116118","confirmation_number":"BV12478795114","room_stay_from":"2021-12-04","room_stay_to":"2021-12-17","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,120.00,120.00,140.00,140.00,120.00,120.00,120.00,120.00,120.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","subtotal":"1620.00","grand_total":"1830.60","paid_amount":"1830.60","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"64584","customer_id":"64584","source_of_creation":"FE","reservation_created_date":"2021-05-29 00:33:43","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","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":"3285218","reservation_id":"119461","confirmation_number":"PB12327150846","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00","nightly_discount":"0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","room_type_id":"292","product_id":"1120","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126609","customer_id":"126609","source_of_creation":"FE","reservation_created_date":"2021-07-16 18:48:13","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":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5325735","reservation_id":"124300","confirmation_number":"PB12377723960","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"366.16,366.16,326.36","nightly_discount":"0.00,0.00,0.00","subtotal":"1058.68","grand_total":"1196.31","paid_amount":"1196.31","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":"93594","customer_id":"93594","source_of_creation":"FE","reservation_created_date":"2021-10-08 19:29: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":"326.36","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5335368","reservation_id":"125577","confirmation_number":"PB12380963836","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"199.00","nightly_discount":"0.00","subtotal":"199.00","grand_total":"224.87","paid_amount":"224.87","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":"134013","customer_id":"134013","source_of_creation":"FE","reservation_created_date":"2021-11-17 02:32:29","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"199.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339144","reservation_id":"125778","confirmation_number":"PB12330411355","room_stay_from":"2021-12-05","room_stay_to":"2021-12-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.07,185.07,185.07,185.07,185.07","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"925.35","grand_total":"1045.64","paid_amount":"1045.64","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":"45253","customer_id":"45253","source_of_creation":"FE","reservation_created_date":"2021-11-23 00:41:37","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":"185.07","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339689","reservation_id":"120407","confirmation_number":"PB12368284102","room_stay_from":"2021-12-02","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00,132.00,132.00,112.00,112.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"600.00","grand_total":"678.00","paid_amount":"678.00","room_type_id":"291","product_id":"1114","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":"127684","customer_id":"127684","source_of_creation":"FE","reservation_created_date":"2021-07-30 15:47:41","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"112.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340154","reservation_id":"125863","confirmation_number":"PB12390155314","room_stay_from":"2021-12-03","room_stay_to":"2021-12-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.94,210.94,171.14,171.14,171.14,171.14,171.14,210.94","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1488.52","grand_total":"1682.03","paid_amount":"1682.03","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":"134439","customer_id":"134439","source_of_creation":"FE","reservation_created_date":"2021-12-03 13:53:28","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":"171.14","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340370","reservation_id":"126190","confirmation_number":"PB12369424227","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"157.21","nightly_discount":"0.00","subtotal":"157.21","grand_total":"177.64","paid_amount":"177.64","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":"134811","customer_id":"134811","source_of_creation":"FE","reservation_created_date":"2021-12-01 22:04:13","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"157.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"}]},{"room_stay_id":"5340545","reservation_id":"120852","confirmation_number":"PB12344432410","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00","nightly_discount":"0.00","subtotal":"112.00","grand_total":"126.56","paid_amount":"126.56","room_type_id":"286","product_id":"1086","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":"128248","customer_id":"128248","source_of_creation":"FE","reservation_created_date":"2021-08-06 22:05:35","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"112.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340561","reservation_id":"118501","confirmation_number":"PB12375087029","room_stay_from":"2021-12-04","room_stay_to":"2021-12-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,164.00,164.00,164.00,164.00,164.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1004.00","grand_total":"1134.52","paid_amount":"1134.52","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":"125539","customer_id":"125539","source_of_creation":"FE","reservation_created_date":"2021-07-02 01:05:39","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"164.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340671","reservation_id":"126012","confirmation_number":"BP12572843958","room_stay_from":"2021-12-04","room_stay_to":"2021-12-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.05,88.20,88.20,88.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"377.65","grand_total":"426.75","paid_amount":"426.75","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134626","customer_id":"134626","source_of_creation":"FE","reservation_created_date":"2021-11-28 18:26:50","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"88.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":"5340769","reservation_id":"126030","confirmation_number":"PB12385798025","room_stay_from":"2021-11-29","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"79.28,90.09,110.65,110.65,166.64,166.64,135.20,105.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"964.15","grand_total":"1089.49","paid_amount":"1089.49","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134656","customer_id":"134656","source_of_creation":"FE","reservation_created_date":"2021-11-29 06:41:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"135.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"5335579","reservation_id":"125595","confirmation_number":"BV12424263360","room_stay_from":"2021-12-04","room_stay_to":"2021-12-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.90,173.90,173.90,173.90,173.90,173.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1080.40","grand_total":"1220.85","paid_amount":"1220.85","room_type_id":"304","product_id":"1218","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":"134025","customer_id":"134025","source_of_creation":"PMS","reservation_created_date":"2021-11-17 18:21:54","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"173.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"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","group_rooms":null,"currentDayPrice":"86.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339385","reservation_id":"125694","confirmation_number":"BV12455877437","room_stay_from":"2021-12-05","room_stay_to":"2021-12-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.95,160.95,160.95,160.95,160.95","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"804.75","grand_total":"909.37","paid_amount":"909.37","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96406","customer_id":"96406","source_of_creation":"PMS","reservation_created_date":"2021-11-20 19:52:33","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"160.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339391","reservation_id":"126043","confirmation_number":"BV12426800132","room_stay_from":"2021-12-02","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.05,166.61,166.61,137.38","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"576.65","grand_total":"651.62","paid_amount":"651.62","room_type_id":"304","product_id":"1221","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":"134670","customer_id":"134670","source_of_creation":"PMS","reservation_created_date":"2021-11-29 16:09:16","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","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":"137.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340076","reservation_id":"120463","confirmation_number":"PB12376905504","room_stay_from":"2021-11-28","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.00,152.00,152.00,152.00,152.00,172.00,172.00,152.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1256.00","grand_total":"1419.28","paid_amount":"1419.28","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107164","customer_id":"107164","source_of_creation":"PMS","reservation_created_date":"2021-07-31 13:41:04","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"152.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340569","reservation_id":"125247","confirmation_number":"PB12365697771","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.87,224.87,185.07","nightly_discount":"0.00,0.00,0.00","subtotal":"634.81","grand_total":"717.34","paid_amount":"717.34","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":"133508","customer_id":"133508","source_of_creation":"PMS","reservation_created_date":"2021-11-09 17:21:39","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":"185.07","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340739","reservation_id":"126296","confirmation_number":"BP12580860228","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.70","nightly_discount":"0.00","subtotal":"88.70","grand_total":"100.23","paid_amount":"100.23","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134979","customer_id":"134979","source_of_creation":"PMS","reservation_created_date":"2021-12-05 02:46:32","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"88.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340774","reservation_id":"126303","confirmation_number":"PB12397924107","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"133.63","nightly_discount":"0.00","subtotal":"133.63","grand_total":"151.00","paid_amount":"151.00","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133407","customer_id":"133407","source_of_creation":"PMS","reservation_created_date":"2021-12-05 15:16:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"133.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340803","reservation_id":"126270","confirmation_number":"PB12311520625","room_stay_from":"2021-12-04","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.00,76.50","nightly_discount":"0.00,0.00","subtotal":"241.50","grand_total":"272.90","paid_amount":"272.90","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134937","customer_id":"134937","source_of_creation":"PMS","reservation_created_date":"2021-12-04 15:10:19","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"76.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":"5340856","reservation_id":"125381","confirmation_number":"PB12315529751","room_stay_from":"2021-12-05","room_stay_to":"2021-12-11","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"185.07,185.07,185.07,185.07,185.07,224.87","nightly_discount":"0.00,51.86,0.00,0.00,0.00,0.00","subtotal":"1150.22","grand_total":"1241.15","paid_amount":"1241.15","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":"66648","customer_id":"66648","source_of_creation":"PMS","reservation_created_date":"2021-11-13 01:52:15","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"185.07","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340876","reservation_id":"126308","confirmation_number":"BV12495623340","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134976","customer_id":"134976","source_of_creation":"PMS","reservation_created_date":"2021-12-05 16:41:46","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340982","reservation_id":"126329","confirmation_number":"BV12461391419","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.70","nightly_discount":"0.00","subtotal":"88.70","grand_total":"100.23","paid_amount":"100.23","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":"115018","customer_id":"115018","source_of_creation":"PMS","reservation_created_date":"2021-12-06 00:58:33","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","currentDayPrice":"88.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340816","reservation_id":"125954","confirmation_number":"BP12532412377","room_stay_from":"2021-12-09","room_stay_to":"2021-12-12","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"132.09,163.54,163.54","nightly_discount":"0.00,0.00,0","subtotal":"459.17","grand_total":"518.86","paid_amount":"149.26","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131559","customer_id":"131559","source_of_creation":"PMS","reservation_created_date":"2021-11-26 21:41:43","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"5340538","reservation_id":"125509","confirmation_number":"PB12387219508","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"325.00","nightly_discount":"0.00","subtotal":"325.00","grand_total":"367.25","paid_amount":"367.25","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":"133905","customer_id":"133905","source_of_creation":"PMS","reservation_created_date":"2021-11-15 20:21:16","service_canceled_date_time":"2021-12-04 16:36:36","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"403.41","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5340692","reservation_id":"120337","confirmation_number":"PB12222634792","room_confirmation_number":"PB12320724727","room_stay_from":"2021-12-04","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20.00,0.00","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"134929","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-12-04 21:01:41","reservation_modified_date_time":"2021-12-04 21:54:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127605","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340911","reservation_id":"126294","confirmation_number":"PB12222891958","room_confirmation_number":"PB12318985645","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"135005","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-12-05 20:52:34","reservation_modified_date_time":"2021-12-05 20:59:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135005","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340765","reservation_id":"126030","confirmation_number":"PB12293494816","room_confirmation_number":"PB12385798025","room_stay_from":"2021-11-29","room_stay_to":"2021-12-07","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"134656","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-12-05 15:00:46","reservation_modified_date_time":"2021-12-05 15:00:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134656","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"Reservation created with partial past date","deltaChange":"120.00","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":"5340926","reservation_id":"125780","confirmation_number":"PB12283363669","room_confirmation_number":"PB12390311525","room_stay_from":"2021-12-05","room_stay_to":"2021-12-08","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"135008","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-12-05 01:10:08","reservation_modified_date_time":"2021-12-05 22:23:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135008","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"5325736","reservation_id":"124300","confirmation_number":"PB12275008498","room_confirmation_number":"PB12377723960","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"93594","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-10-08 19:29:22","reservation_modified_date_time":"2021-10-13 19:08:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93594","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":"5335369","reservation_id":"125577","confirmation_number":"PB12295197762","room_confirmation_number":"PB12380963836","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"134013","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-17 02:32:29","reservation_modified_date_time":"2021-11-17 02:32:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134013","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":"5339392","reservation_id":"126043","confirmation_number":"BV12243034724","room_confirmation_number":"BV12426800132","room_stay_from":"2021-12-02","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"134670","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-29 16:09:16","reservation_modified_date_time":"2021-11-30 19:06:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134670","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":"5340077","reservation_id":"120463","confirmation_number":"PB12244827763","room_confirmation_number":"PB12376905504","room_stay_from":"2021-11-28","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.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":"107164","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-31 13:41:04","reservation_modified_date_time":"2021-12-03 00:43:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107164","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":"5340121","reservation_id":"124773","confirmation_number":"PB12264941713","room_confirmation_number":"PB12383330337","room_stay_from":"2021-12-02","room_stay_to":"2021-12-06","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":"134871","product_attribute_values":"resort_fee#&#12","reservation_created_date":"2021-10-25 22:12:09","reservation_modified_date_time":"2021-12-03 13:17:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134871","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":"5340356","reservation_id":"124972","confirmation_number":"BP12279987523","room_confirmation_number":"BP12573152162","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20,20,20","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":"134893","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-02 09:20:16","reservation_modified_date_time":"2021-12-03 19:29:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134893","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.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":"5340371","reservation_id":"126190","confirmation_number":"PB12297265061","room_confirmation_number":"PB12369424227","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"134811","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-01 22:04:13","reservation_modified_date_time":"2021-12-03 19:59:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134811","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":"5340378","reservation_id":"125550","confirmation_number":"BP12219976755","room_confirmation_number":"BP12550461309","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20,20,20","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":"134897","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-16 17:27:54","reservation_modified_date_time":"2021-12-03 20:05:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134897","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":"5340389","reservation_id":"126227","confirmation_number":"PB12233789929","room_confirmation_number":"PB12380026764","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20,20,20","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":"134902","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-03 04:29:37","reservation_modified_date_time":"2021-12-03 20:34:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134902","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":"5340476","reservation_id":"125843","confirmation_number":"PB12243749238","room_confirmation_number":"PB12327237479","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20,20,20","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":"134934","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-24 07:16:40","reservation_modified_date_time":"2021-12-04 01:32:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134934","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":"5340546","reservation_id":"120852","confirmation_number":"PB12254525063","room_confirmation_number":"PB12344432410","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"128248","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-06 22:05:35","reservation_modified_date_time":"2021-12-04 15:26:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128248","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":"5340570","reservation_id":"125247","confirmation_number":"PB12261168769","room_confirmation_number":"PB12365697771","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"133508","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-09 17:21:39","reservation_modified_date_time":"2021-12-04 16:20:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133508","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340693","reservation_id":"120337","confirmation_number":"PB12216807100","room_confirmation_number":"PB12320724727","room_stay_from":"2021-12-04","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"134929","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-29 13:49:11","reservation_modified_date_time":"2021-12-04 21:54:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127605","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":"5340740","reservation_id":"126296","confirmation_number":"BP12214005565","room_confirmation_number":"BP12580860228","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"134979","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-05 02:46:32","reservation_modified_date_time":"2021-12-05 02:46:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134979","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":"5340775","reservation_id":"126303","confirmation_number":"PB12223648674","room_confirmation_number":"PB12397924107","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"133407","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-05 15:16:37","reservation_modified_date_time":"2021-12-05 15:16:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133407","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":"5340804","reservation_id":"126270","confirmation_number":"PB12231305757","room_confirmation_number":"PB12311520625","room_stay_from":"2021-12-04","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"134937","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-04 15:10:19","reservation_modified_date_time":"2021-12-05 16:14:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134937","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340887","reservation_id":"126265","confirmation_number":"PB12284522977","room_confirmation_number":"PB12398161714","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"135002","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-04 00:03:19","reservation_modified_date_time":"2021-12-05 19:57:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135002","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":"5340912","reservation_id":"126294","confirmation_number":"PB12273947971","room_confirmation_number":"PB12318985645","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"135005","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-05 00:01:37","reservation_modified_date_time":"2021-12-05 20:59:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135005","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":"5340978","reservation_id":"126327","confirmation_number":"BP12289430160","room_confirmation_number":"BP12586651637","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"135022","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-05 23:29:59","reservation_modified_date_time":"2021-12-05 23:59:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135022","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":"5340983","reservation_id":"126329","confirmation_number":"BV12295816547","room_confirmation_number":"BV12461391419","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"115018","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-06 00:58:33","reservation_modified_date_time":"2021-12-06 00:58:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115018","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":"3285219","reservation_id":"119461","confirmation_number":"PB12289456647","room_confirmation_number":"PB12327150846","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","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":"126609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-16 18:48:13","reservation_modified_date_time":"2021-07-16 18:48:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126609","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":"5339353","reservation_id":"118828","confirmation_number":"PB12275497433","room_confirmation_number":"PB12342029860","room_stay_from":"2021-11-30","room_stay_to":"2021-12-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"134746","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-06 22:05:07","reservation_modified_date_time":"2021-11-30 17:44:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134746","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":"5339690","reservation_id":"120407","confirmation_number":"PB12261690683","room_confirmation_number":"PB12368284102","room_stay_from":"2021-12-02","room_stay_to":"2021-12-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"127684","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-30 15:47:41","reservation_modified_date_time":"2021-12-01 16:31:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127684","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":"5340770","reservation_id":"126030","confirmation_number":"PB12276206380","room_confirmation_number":"PB12385798025","room_stay_from":"2021-11-29","room_stay_to":"2021-12-07","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":"134656","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-29 06:41:28","reservation_modified_date_time":"2021-12-05 15:01:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134656","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340877","reservation_id":"126308","confirmation_number":"BV12294827948","room_confirmation_number":"BV12495623340","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","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":"134976","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-05 16:41:46","reservation_modified_date_time":"2021-12-05 19:30:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134976","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":"5340896","reservation_id":"120806","confirmation_number":"PB12269491784","room_confirmation_number":"PB12344003284","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"135004","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-06 03:40:12","reservation_modified_date_time":"2021-12-05 20:30:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135004","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":"5340965","reservation_id":"126311","confirmation_number":"PB12241658978","room_confirmation_number":"PB12345656905","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","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":"135017","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-05 17:58:14","reservation_modified_date_time":"2021-12-05 23:23:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135017","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":"5340974","reservation_id":"126298","confirmation_number":"PB12226068962","room_confirmation_number":"PB12310431372","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","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":"135017","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-05 03:51:44","reservation_modified_date_time":"2021-12-05 23:32:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135017","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":"5340989","reservation_id":"126324","confirmation_number":"PB12244363797","room_confirmation_number":"PB12366142376","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","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":"135024","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-05 23:19:31","reservation_modified_date_time":"2021-12-06 01:31:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135024","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":"5340626","reservation_id":"126116","confirmation_number":"PB12225350030","room_confirmation_number":"PB12375974797","room_stay_from":"2021-12-05","room_stay_to":"2021-12-08","room_stay_status":"Active","nightly_price":"20,20,20","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":"134961","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-30 03:14:03","reservation_modified_date_time":"2021-12-04 18:37:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134961","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":"5340628","reservation_id":"125700","confirmation_number":"PB12259721021","room_confirmation_number":"PB12318293221","room_stay_from":"2021-12-04","room_stay_to":"2021-12-08","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"134962","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-20 23:03:11","reservation_modified_date_time":"2021-12-04 19:10:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134962","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":"5340672","reservation_id":"126012","confirmation_number":"BP12265500710","room_confirmation_number":"BP12572843958","room_stay_from":"2021-12-04","room_stay_to":"2021-12-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.23","product_id":"1781","service_quantity":"1","customer_traveller_id":"134626","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-28 18:26:50","reservation_modified_date_time":"2021-12-04 21:10:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134626","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":"5340737","reservation_id":"126252","confirmation_number":"PB12211870667","room_confirmation_number":"PB12398735676","room_stay_from":"2021-12-04","room_stay_to":"2021-12-08","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"134978","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-03 20:13:52","reservation_modified_date_time":"2021-12-05 02:23:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134978","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":"5340927","reservation_id":"125780","confirmation_number":"PB12275543270","room_confirmation_number":"PB12390311525","room_stay_from":"2021-12-05","room_stay_to":"2021-12-08","room_stay_status":"Active","nightly_price":"20,20,20","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":"135008","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-23 01:19:16","reservation_modified_date_time":"2021-12-05 22:23:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135008","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":"5340892","reservation_id":"126305","confirmation_number":"PB12250634400","room_confirmation_number":"PB12325439575","room_stay_from":"2021-12-05","room_stay_to":"2021-12-09","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":"135003","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-05 15:47:50","reservation_modified_date_time":"2021-12-05 20:24:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135003","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":"5335580","reservation_id":"125595","confirmation_number":"BV12256979583","room_confirmation_number":"BV12424263360","room_stay_from":"2021-12-04","room_stay_to":"2021-12-10","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":"134025","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-17 18:21:54","reservation_modified_date_time":"2021-11-17 18:21:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134025","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":"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#&#12","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":"5339145","reservation_id":"125778","confirmation_number":"PB12224176872","room_confirmation_number":"PB12330411355","room_stay_from":"2021-12-05","room_stay_to":"2021-12-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"45253","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-23 00:41:37","reservation_modified_date_time":"2021-11-30 00:33:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"45253","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":"5339386","reservation_id":"125694","confirmation_number":"BV12243698037","room_confirmation_number":"BV12455877437","room_stay_from":"2021-12-05","room_stay_to":"2021-12-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"96406","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-20 19:52:33","reservation_modified_date_time":"2021-11-30 19:05:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96406","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":"5340562","reservation_id":"118501","confirmation_number":"PB12286426874","room_confirmation_number":"PB12375087029","room_stay_from":"2021-12-04","room_stay_to":"2021-12-10","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":"125539","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-02 01:05:39","reservation_modified_date_time":"2021-12-04 16:00:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125539","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":"5340155","reservation_id":"125863","confirmation_number":"PB12284380423","room_confirmation_number":"PB12390155314","room_stay_from":"2021-12-03","room_stay_to":"2021-12-11","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":"134439","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-03 13:53:28","reservation_modified_date_time":"2021-12-03 13:53:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134439","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":"5340857","reservation_id":"125381","confirmation_number":"PB12224463730","room_confirmation_number":"PB12315529751","room_stay_from":"2021-12-05","room_stay_to":"2021-12-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"66648","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-13 01:52:15","reservation_modified_date_time":"2021-12-05 17:15:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66648","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":"3258717","reservation_id":"116118","confirmation_number":"BV12269399288","room_confirmation_number":"BV12478795114","room_stay_from":"2021-12-04","room_stay_to":"2021-12-17","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","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","subtotal":"156.00","grand_total":"176.28","paid_amount":"176.28","product_id":"1781","service_quantity":"1","customer_traveller_id":"64584","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-05-29 00:33:43","reservation_modified_date_time":"2021-05-29 00:33:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"64584","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":"5340817","reservation_id":"125954","confirmation_number":"BP12268357491","room_confirmation_number":"BP12532412377","room_stay_from":"2021-12-09","room_stay_to":"2021-12-12","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"131559","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-26 21:41:43","reservation_modified_date_time":"2021-12-05 16:38:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131559","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":"5340379","reservation_id":"125550","confirmation_number":"BP12213994226","room_confirmation_number":"BP12550461309","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"45.00,45.00,45.00","nightly_discount":"0.00,0.00,0.00","subtotal":"135.00","grand_total":"152.55","paid_amount":"152.55","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-30 21:37:37","reservation_modified_date_time":"2021-12-03 20:05:51","customer_id":"134897","parentCustTravId":"134897","customer_traveller_id":"134897","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-12-03","sub_hotel_id":"125","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":"5340756","reservation_id":"124688","confirmation_number":"PB12278586605","room_confirmation_number":"PB12348350554","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-12-05 13:41:03","reservation_modified_date_time":"2021-12-05 13:41:03","customer_id":"133265","parentCustTravId":"133265","customer_traveller_id":"133265","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-12-02","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":"5340762","reservation_id":"126273","confirmation_number":"PB12212081919","room_confirmation_number":"PB12310270294","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"69.00","grand_total":"77.97","paid_amount":"77.97","product_id":"1142","service_quantity":"1","product_name":"1\/2 Day Sunset Late Check-out \/ Off-Season","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 14:27:26","reservation_modified_date_time":"2021-12-05 14:27:26","customer_id":"134940","parentCustTravId":"134940","customer_traveller_id":"134940","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-12-04","sub_hotel_id":"123","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5340763","reservation_id":"126269","confirmation_number":"PB12268806103","room_confirmation_number":"PB12342461542","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":"45.20","paid_amount":"45.20","product_id":"1141","service_quantity":"2","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 14:38:03","reservation_modified_date_time":"2021-12-05 14:38:03","customer_id":"134932","parentCustTravId":"134932","customer_traveller_id":"134932","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-12-03","sub_hotel_id":"123","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5340787","reservation_id":"115568","confirmation_number":"PB12296833833","room_confirmation_number":"PB12384359637","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 16:07:00","reservation_modified_date_time":"2021-12-05 16:07:00","customer_id":"122318","parentCustTravId":"122318","customer_traveller_id":"122318","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-12-02","sub_hotel_id":"123","currentDayPrice":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5340788","reservation_id":"126275","confirmation_number":"BV12244101652","room_confirmation_number":"BV12478410131","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-12-05 16:11:37","reservation_modified_date_time":"2021-12-05 16:11:37","customer_id":"134941","parentCustTravId":"134941","customer_traveller_id":"134941","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-12-04","sub_hotel_id":"124","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":"5340904","reservation_id":"125577","confirmation_number":"PB12235451665","room_confirmation_number":"PB12380963836","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-12-05 20:46:13","reservation_modified_date_time":"2021-12-05 20:46:13","customer_id":"134013","parentCustTravId":"134013","customer_traveller_id":"134013","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-12-05","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5340913","reservation_id":"126294","confirmation_number":"PB12298037007","room_confirmation_number":"PB12318985645","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.01","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 20:55:32","reservation_modified_date_time":"2021-12-05 20:59:24","customer_id":"135005","parentCustTravId":"135005","customer_traveller_id":"135005","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-12-05","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":"5340917","reservation_id":"125595","confirmation_number":"BV12257140149","room_confirmation_number":"BV12424263360","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"20.00","product_id":"1158","service_quantity":"2","product_name":"Fishing Pole","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 21:16:09","reservation_modified_date_time":"2021-12-05 21:16:09","customer_id":"134025","parentCustTravId":"134025","customer_traveller_id":"134025","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-12-04","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":"5340918","reservation_id":"125595","confirmation_number":"BV12241243137","room_confirmation_number":"BV12424263360","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-12-05 15:24:34","reservation_modified_date_time":"2021-12-05 15:24:34","customer_id":"134025","parentCustTravId":"134025","customer_traveller_id":"134025","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-12-04","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":"5340919","reservation_id":"126308","confirmation_number":"BV12219129002","room_confirmation_number":"BV12495623340","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-12-05 21:19:59","reservation_modified_date_time":"2021-12-05 21:19:59","customer_id":"134976","parentCustTravId":"134976","customer_traveller_id":"134976","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-12-05","sub_hotel_id":"124","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":"5340923","reservation_id":"125778","confirmation_number":"PB12267768845","room_confirmation_number":"PB12330411355","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-12-05 21:55:53","reservation_modified_date_time":"2021-12-05 21:55:53","customer_id":"45253","parentCustTravId":"45253","customer_traveller_id":"45253","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-12-05","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5340760","reservation_id":"126301","confirmation_number":"PB12247522311","room_confirmation_number":"PB12358568657","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.26","grand_total":"3.49","paid_amount":"3.49","product_id":"1155","service_quantity":"1","product_name":"Deodorant","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 14:16:43","reservation_modified_date_time":"2021-12-05 14:16: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":"3.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5340916","reservation_id":"126315","confirmation_number":"PB12247802617","room_confirmation_number":"PB12362151621","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 21:10:11","reservation_modified_date_time":"2021-12-05 21:10:11","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"123","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5340952","reservation_id":"126319","confirmation_number":"PB12286830324","room_confirmation_number":"PB12391111598","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 23:08:21","reservation_modified_date_time":"2021-12-05 23:08:21","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"123","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5338745","reservation_id":"124498","confirmation_number":"BV12280639371","room_confirmation_number":"BV12443602923","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"50.00","grand_total":"53.50","paid_amount":"0.00","product_id":"1175","service_quantity":"1","product_name":"Miscellaneous","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-28 15:54:25","reservation_modified_date_time":"2021-11-28 15:54:25","customer_id":"134505","parentCustTravId":"134505","customer_traveller_id":"134505","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-12-05 14:37:04","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-25","sub_hotel_id":"124","deltaChange":-50,"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":"5339064","reservation_id":"125898","confirmation_number":"BP12220635680","room_confirmation_number":"BP12552690841","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-29 20:38:04","reservation_modified_date_time":"2021-11-29 20:47:54","customer_id":"134689","parentCustTravId":"134689","customer_traveller_id":"134689","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-12-05 18:53:07","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-29","sub_hotel_id":"125","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":"5340556","reservation_id":"120071","confirmation_number":"PB12265083110","room_confirmation_number":"PB12329795089","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":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-04 15:42:55","reservation_modified_date_time":"2021-12-04 15:42:55","customer_id":"134850","parentCustTravId":"134850","customer_traveller_id":"134850","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-12-05 14:49:09","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-12-02","sub_hotel_id":"123","deltaChange":-37.4,"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":"5340565","reservation_id":"126011","confirmation_number":"PB12271653646","room_confirmation_number":"PB12314193547","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-12-04 16:12:53","reservation_modified_date_time":"2021-12-04 16:12:53","customer_id":"134933","parentCustTravId":"134933","customer_traveller_id":"134933","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-12-05 14:42:46","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-12-03","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":"5340592","reservation_id":"107593","confirmation_number":"PB12268019227","room_confirmation_number":"PB12363972274","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":"60.03","paid_amount":"0.00","product_id":"2010","service_quantity":"6","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-04 17:22:01","reservation_modified_date_time":"2021-12-04 17:22:27","customer_id":"114050","parentCustTravId":"114050","customer_traveller_id":"114050","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-12-05 17:09:41","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-12-03","sub_hotel_id":"123","deltaChange":-56.1,"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":"5340683","reservation_id":"126278","confirmation_number":"PB12221338370","room_confirmation_number":"PB12387859647","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-12-04 20:46:15","reservation_modified_date_time":"2021-12-04 21:15:00","customer_id":"134970","parentCustTravId":"134970","customer_traveller_id":"134970","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-12-05 15:23:59","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-12-04","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":"5340704","reservation_id":"126279","confirmation_number":"PB12270716771","room_confirmation_number":"PB12352626680","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-12-04 18:14:17","reservation_modified_date_time":"2021-12-04 23:26:46","customer_id":"134958","parentCustTravId":"134958","customer_traveller_id":"134958","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-12-05 15:27:46","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-12-04","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":"5340757","reservation_id":"124688","confirmation_number":"PB12225943597","room_confirmation_number":"PB12348350554","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-12-02 20:08:46","reservation_modified_date_time":"2021-12-02 20:08:46","customer_id":"133265","parentCustTravId":"133265","customer_traveller_id":"133265","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-12-05 18:07:54","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-12-02","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"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[],"htl_taxable":[{"room_stay_id":"5340966","reservation_id":"126311","confirmation_number":"PB12345656905","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"96.12,96.12","nightly_discount":"0.00,0.00","subtotal":"192.24","grand_total":"217.23","paid_amount":"217.23","room_type_id":"289","product_id":"1104","siteminder_id":"HTL-1866632613","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":"135017","customer_id":"135017","source_of_creation":"Expedia","reservation_created_date":"2021-12-05 17:58:14","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":null,"sub_hotel_id":"123","currentDayPrice":"96.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340975","reservation_id":"126298","confirmation_number":"PB12310431372","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.09,113.09","nightly_discount":"0,0","subtotal":"226.18","grand_total":"255.58","paid_amount":"255.58","room_type_id":"289","product_id":"1095","siteminder_id":"HTL-1866490342","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":"135017","customer_id":"135017","source_of_creation":"Expedia","reservation_created_date":"2021-12-05 03:51:44","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":null,"sub_hotel_id":"123","currentDayPrice":"113.09","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ean_taxable":[{"room_stay_id":"5340990","reservation_id":"126324","confirmation_number":"PB12366142376","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.39,82.39","nightly_discount":"0.00,0.00","subtotal":"164.78","grand_total":"186.20","paid_amount":"186.20","room_type_id":"289","product_id":"1099","siteminder_id":"EAN-1866735101","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":"135024","customer_id":"135024","source_of_creation":"Expedia","reservation_created_date":"2021-12-05 23:19:31","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"82.39","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"1111","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12225469440","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","bundle_room":"0","product_id":"1111"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5340390","reservation_id":"126227","confirmation_number":"PB12380026764","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"157.77,157.77,139.95","nightly_discount":"0,0,0","subtotal":"455.49","grand_total":"514.70","paid_amount":"514.70","room_type_id":"289","product_id":"1103","siteminder_id":"BDC-2591608120","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":"134902","customer_id":"134902","source_of_creation":"Booking.com","reservation_created_date":"2021-12-03 04:29:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"77.32","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"139.95","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":"5340627","reservation_id":"126116","confirmation_number":"PB12375974797","room_stay_from":"2021-12-05","room_stay_to":"2021-12-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.79,124.79,124.79","nightly_discount":"0,0,0","subtotal":"374.37","grand_total":"423.04","paid_amount":"423.04","room_type_id":"290","product_id":"1113","siteminder_id":"BDC-3367665433","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":"134961","customer_id":"134961","source_of_creation":"Booking.com","reservation_created_date":"2021-11-30 03:14:03","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"65.16","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"124.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":"5340691","reservation_id":"120337","confirmation_number":"PB12320724727","room_stay_from":"2021-12-04","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"100.36,89.02","nightly_discount":"0.00,0.00","subtotal":"189.38","grand_total":"214.00","paid_amount":"214.00","room_type_id":"289","product_id":"1106","siteminder_id":"BDC-3680915643","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":"134929","customer_id":"127605","source_of_creation":"Booking.com","reservation_created_date":"2021-07-29 13:49:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","ota_service_fee_amount":"0","commision_charges":"34.41","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"89.02","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340888","reservation_id":"126265","confirmation_number":"PB12398161714","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"182.80","nightly_discount":"0","subtotal":"182.80","grand_total":"206.57","paid_amount":"206.57","room_type_id":"289","product_id":"1123","siteminder_id":"BDC-2597095042","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":"135002","customer_id":"135002","source_of_creation":"Booking.com","reservation_created_date":"2021-12-04 00:03:19","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"30.42","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"182.80","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340893","reservation_id":"126305","confirmation_number":"PB12325439575","room_stay_from":"2021-12-05","room_stay_to":"2021-12-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.46,110.46,110.46,110.46","nightly_discount":"0,0,0,0","subtotal":"441.84","grand_total":"499.28","paid_amount":"499.28","room_type_id":"289","product_id":"1121","siteminder_id":"BDC-3529969793","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":"135003","customer_id":"135003","source_of_creation":"Booking.com","reservation_created_date":"2021-12-05 15:47:50","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"78.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"110.46","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":"5340897","reservation_id":"120806","confirmation_number":"PB12344003284","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.02,89.02","nightly_discount":"0,0","subtotal":"178.04","grand_total":"201.18","paid_amount":"201.18","room_type_id":"289","product_id":"1096","siteminder_id":"BDC-2303261997","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":"135004","customer_id":"135004","source_of_creation":"Booking.com","reservation_created_date":"2021-08-06 03:40:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"32.71","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"89.02","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":"5340928","reservation_id":"125780","confirmation_number":"PB12390311525","room_stay_from":"2021-12-05","room_stay_to":"2021-12-08","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"177.15,177.15,177.15","nightly_discount":"0.00,0.00,0.00","subtotal":"531.45","grand_total":"600.54","paid_amount":"600.54","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-2905728656","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":"135008","customer_id":"135008","source_of_creation":"Booking.com","reservation_created_date":"2021-11-23 01:19:16","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"88.72","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"177.15","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[{"room_stay_id":"3216183","reservation_id":"107378","confirmation_number":"PB12328766559","room_stay_from":"2021-12-05","room_stay_to":"2021-12-10","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"103.78","room_type_id":"285","product_id":"1083","siteminder_id":"BDC-2751608680","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":"113834","customer_id":"113834","source_of_creation":"Booking.com","reservation_created_date":"2021-02-11 22:56:11","service_canceled_date_time":"2021-08-03 18:18:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"97.40","sub_hotel_id":"123","deltaChange":"103.78","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"exp_taxable":[{"room_stay_id":"5339354","reservation_id":"118828","confirmation_number":"PB12342029860","room_stay_from":"2021-11-30","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.06,109.06,109.06,120.54,120.54,109.06,109.06","nightly_discount":"0,0,0,0,0,0,0","subtotal":"786.38","grand_total":"888.61","paid_amount":"888.61","room_type_id":"291","product_id":"1117","siteminder_id":"EXP-1796783469","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":"134746","customer_id":"134746","source_of_creation":"Expedia","reservation_created_date":"2021-07-06 22:05:07","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"109.06","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":"5340122","reservation_id":"124773","confirmation_number":"PB12383330337","room_stay_from":"2021-12-02","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.34,162.73,162.73,144.34","nightly_discount":"0,0,0,0","subtotal":"614.14","grand_total":"693.98","paid_amount":"693.98","room_type_id":"289","product_id":"1101","siteminder_id":"EXP-1848741293","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":"134871","customer_id":"134871","source_of_creation":"Expedia","reservation_created_date":"2021-10-25 22:12:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"144.34","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340477","reservation_id":"125843","confirmation_number":"PB12327237479","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"180.20,180.20,163.03","nightly_discount":"0,0,0","subtotal":"523.43","grand_total":"591.48","paid_amount":"591.48","room_type_id":"291","product_id":"1116","siteminder_id":"EXP-1862084786","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":"134934","customer_id":"134934","source_of_creation":"Expedia","reservation_created_date":"2021-11-24 07:16:40","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":"163.03","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":"5340629","reservation_id":"125700","confirmation_number":"PB12318293221","room_stay_from":"2021-12-04","room_stay_to":"2021-12-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.73,144.34,144.34,144.34","nightly_discount":"0,0,0,0","subtotal":"595.75","grand_total":"673.20","paid_amount":"673.20","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1860604932","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":"134962","customer_id":"134962","source_of_creation":"Expedia","reservation_created_date":"2021-11-20 23:03:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"144.34","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340738","reservation_id":"126252","confirmation_number":"PB12398735676","room_stay_from":"2021-12-04","room_stay_to":"2021-12-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.27,96.94,96.94,96.94","nightly_discount":"0,0,0,0","subtotal":"400.09","grand_total":"452.11","paid_amount":"452.11","room_type_id":"289","product_id":"1110","siteminder_id":"EXP-1866028709","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":"134978","customer_id":"134978","source_of_creation":"Expedia","reservation_created_date":"2021-12-03 20:13:52","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"96.94","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340914","reservation_id":"126294","confirmation_number":"PB12318985645","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"136.84","nightly_discount":"0.00","subtotal":"136.84","grand_total":"154.63","paid_amount":"154.63","room_type_id":"291","product_id":"1118","siteminder_id":"EXP-1866429941","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":"135005","customer_id":"135005","source_of_creation":"Expedia","reservation_created_date":"2021-12-05 00:01:37","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":null,"sub_hotel_id":"123","currentDayPrice":"136.84","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3285218","reservation_id":"119461","confirmation_number":"PB12327150846","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.00,100.00","nightly_discount":"0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","room_type_id":"292","product_id":"1120","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126609","customer_id":"126609","source_of_creation":"FE","reservation_created_date":"2021-07-16 18:48:13","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":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5325735","reservation_id":"124300","confirmation_number":"PB12377723960","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"366.16,366.16,326.36","nightly_discount":"0.00,0.00,0.00","subtotal":"1058.68","grand_total":"1196.31","paid_amount":"1196.31","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":"93594","customer_id":"93594","source_of_creation":"FE","reservation_created_date":"2021-10-08 19:29: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":"326.36","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5335368","reservation_id":"125577","confirmation_number":"PB12380963836","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"199.00","nightly_discount":"0.00","subtotal":"199.00","grand_total":"224.87","paid_amount":"224.87","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":"134013","customer_id":"134013","source_of_creation":"FE","reservation_created_date":"2021-11-17 02:32:29","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"199.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339144","reservation_id":"125778","confirmation_number":"PB12330411355","room_stay_from":"2021-12-05","room_stay_to":"2021-12-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"185.07,185.07,185.07,185.07,185.07","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"925.35","grand_total":"1045.64","paid_amount":"1045.64","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":"45253","customer_id":"45253","source_of_creation":"FE","reservation_created_date":"2021-11-23 00:41:37","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":"185.07","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339689","reservation_id":"120407","confirmation_number":"PB12368284102","room_stay_from":"2021-12-02","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00,132.00,132.00,112.00,112.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"600.00","grand_total":"678.00","paid_amount":"678.00","room_type_id":"291","product_id":"1114","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":"127684","customer_id":"127684","source_of_creation":"FE","reservation_created_date":"2021-07-30 15:47:41","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"112.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340154","reservation_id":"125863","confirmation_number":"PB12390155314","room_stay_from":"2021-12-03","room_stay_to":"2021-12-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.94,210.94,171.14,171.14,171.14,171.14,171.14,210.94","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1488.52","grand_total":"1682.03","paid_amount":"1682.03","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":"134439","customer_id":"134439","source_of_creation":"FE","reservation_created_date":"2021-12-03 13:53:28","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":"171.14","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340370","reservation_id":"126190","confirmation_number":"PB12369424227","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"157.21","nightly_discount":"0.00","subtotal":"157.21","grand_total":"177.64","paid_amount":"177.64","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":"134811","customer_id":"134811","source_of_creation":"FE","reservation_created_date":"2021-12-01 22:04:13","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"157.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"}]},{"room_stay_id":"5340545","reservation_id":"120852","confirmation_number":"PB12344432410","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.00","nightly_discount":"0.00","subtotal":"112.00","grand_total":"126.56","paid_amount":"126.56","room_type_id":"286","product_id":"1086","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":"128248","customer_id":"128248","source_of_creation":"FE","reservation_created_date":"2021-08-06 22:05:35","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"112.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340561","reservation_id":"118501","confirmation_number":"PB12375087029","room_stay_from":"2021-12-04","room_stay_to":"2021-12-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.00,164.00,164.00,164.00,164.00,164.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1004.00","grand_total":"1134.52","paid_amount":"1134.52","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":"125539","customer_id":"125539","source_of_creation":"FE","reservation_created_date":"2021-07-02 01:05:39","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"164.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340769","reservation_id":"126030","confirmation_number":"PB12385798025","room_stay_from":"2021-11-29","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"3","nightly_price":"79.28,90.09,110.65,110.65,166.64,166.64,135.20,105.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"964.15","grand_total":"1089.49","paid_amount":"1089.49","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134656","customer_id":"134656","source_of_creation":"FE","reservation_created_date":"2021-11-29 06:41:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"135.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"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","group_rooms":null,"currentDayPrice":"86.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340076","reservation_id":"120463","confirmation_number":"PB12376905504","room_stay_from":"2021-11-28","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"152.00,152.00,152.00,152.00,152.00,172.00,172.00,152.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1256.00","grand_total":"1419.28","paid_amount":"1419.28","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107164","customer_id":"107164","source_of_creation":"PMS","reservation_created_date":"2021-07-31 13:41:04","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"152.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340569","reservation_id":"125247","confirmation_number":"PB12365697771","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"224.87,224.87,185.07","nightly_discount":"0.00,0.00,0.00","subtotal":"634.81","grand_total":"717.34","paid_amount":"717.34","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":"133508","customer_id":"133508","source_of_creation":"PMS","reservation_created_date":"2021-11-09 17:21:39","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":"185.07","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340774","reservation_id":"126303","confirmation_number":"PB12397924107","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"133.63","nightly_discount":"0.00","subtotal":"133.63","grand_total":"151.00","paid_amount":"151.00","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133407","customer_id":"133407","source_of_creation":"PMS","reservation_created_date":"2021-12-05 15:16:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"133.63","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340803","reservation_id":"126270","confirmation_number":"PB12311520625","room_stay_from":"2021-12-04","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"165.00,76.50","nightly_discount":"0.00,0.00","subtotal":"241.50","grand_total":"272.90","paid_amount":"272.90","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134937","customer_id":"134937","source_of_creation":"PMS","reservation_created_date":"2021-12-04 15:10:19","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"76.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":"5340856","reservation_id":"125381","confirmation_number":"PB12315529751","room_stay_from":"2021-12-05","room_stay_to":"2021-12-11","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"185.07,185.07,185.07,185.07,185.07,224.87","nightly_discount":"0.00,51.86,0.00,0.00,0.00,0.00","subtotal":"1150.22","grand_total":"1241.15","paid_amount":"1241.15","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":"66648","customer_id":"66648","source_of_creation":"PMS","reservation_created_date":"2021-11-13 01:52:15","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"185.07","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"5340538","reservation_id":"125509","confirmation_number":"PB12387219508","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"325.00","nightly_discount":"0.00","subtotal":"325.00","grand_total":"367.25","paid_amount":"367.25","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":"133905","customer_id":"133905","source_of_creation":"PMS","reservation_created_date":"2021-11-15 20:21:16","service_canceled_date_time":"2021-12-04 16:36:36","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"123","deltaChange":"403.41","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5340692","reservation_id":"120337","confirmation_number":"PB12222634792","room_confirmation_number":"PB12320724727","room_stay_from":"2021-12-04","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20.00,0.00","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"134929","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-12-04 21:01:41","reservation_modified_date_time":"2021-12-04 21:54:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127605","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340911","reservation_id":"126294","confirmation_number":"PB12222891958","room_confirmation_number":"PB12318985645","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"135005","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-12-05 20:52:34","reservation_modified_date_time":"2021-12-05 20:59:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135005","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340765","reservation_id":"126030","confirmation_number":"PB12293494816","room_confirmation_number":"PB12385798025","room_stay_from":"2021-11-29","room_stay_to":"2021-12-07","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"134656","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-12-05 15:00:46","reservation_modified_date_time":"2021-12-05 15:00:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134656","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"Reservation created with partial past date","deltaChange":"120.00","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":"5340926","reservation_id":"125780","confirmation_number":"PB12283363669","room_confirmation_number":"PB12390311525","room_stay_from":"2021-12-05","room_stay_to":"2021-12-08","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"135008","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-12-05 01:10:08","reservation_modified_date_time":"2021-12-05 22:23:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135008","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"5325736","reservation_id":"124300","confirmation_number":"PB12275008498","room_confirmation_number":"PB12377723960","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"93594","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-10-08 19:29:22","reservation_modified_date_time":"2021-10-13 19:08:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93594","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":"5335369","reservation_id":"125577","confirmation_number":"PB12295197762","room_confirmation_number":"PB12380963836","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"134013","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-17 02:32:29","reservation_modified_date_time":"2021-11-17 02:32:29","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134013","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":"5340077","reservation_id":"120463","confirmation_number":"PB12244827763","room_confirmation_number":"PB12376905504","room_stay_from":"2021-11-28","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.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":"107164","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-31 13:41:04","reservation_modified_date_time":"2021-12-03 00:43:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107164","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":"5340121","reservation_id":"124773","confirmation_number":"PB12264941713","room_confirmation_number":"PB12383330337","room_stay_from":"2021-12-02","room_stay_to":"2021-12-06","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":"134871","product_attribute_values":"resort_fee#&#12","reservation_created_date":"2021-10-25 22:12:09","reservation_modified_date_time":"2021-12-03 13:17:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134871","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":"5340371","reservation_id":"126190","confirmation_number":"PB12297265061","room_confirmation_number":"PB12369424227","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"134811","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-01 22:04:13","reservation_modified_date_time":"2021-12-03 19:59:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134811","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":"5340389","reservation_id":"126227","confirmation_number":"PB12233789929","room_confirmation_number":"PB12380026764","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20,20,20","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":"134902","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-03 04:29:37","reservation_modified_date_time":"2021-12-03 20:34:53","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134902","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":"5340476","reservation_id":"125843","confirmation_number":"PB12243749238","room_confirmation_number":"PB12327237479","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20,20,20","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":"134934","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-24 07:16:40","reservation_modified_date_time":"2021-12-04 01:32:27","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134934","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":"5340546","reservation_id":"120852","confirmation_number":"PB12254525063","room_confirmation_number":"PB12344432410","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"128248","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-06 22:05:35","reservation_modified_date_time":"2021-12-04 15:26:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"128248","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":"5340570","reservation_id":"125247","confirmation_number":"PB12261168769","room_confirmation_number":"PB12365697771","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"133508","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-09 17:21:39","reservation_modified_date_time":"2021-12-04 16:20:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133508","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340693","reservation_id":"120337","confirmation_number":"PB12216807100","room_confirmation_number":"PB12320724727","room_stay_from":"2021-12-04","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"134929","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-29 13:49:11","reservation_modified_date_time":"2021-12-04 21:54:43","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127605","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":"5340775","reservation_id":"126303","confirmation_number":"PB12223648674","room_confirmation_number":"PB12397924107","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"133407","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-05 15:16:37","reservation_modified_date_time":"2021-12-05 15:16:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133407","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":"5340804","reservation_id":"126270","confirmation_number":"PB12231305757","room_confirmation_number":"PB12311520625","room_stay_from":"2021-12-04","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"134937","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-04 15:10:19","reservation_modified_date_time":"2021-12-05 16:14:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134937","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340887","reservation_id":"126265","confirmation_number":"PB12284522977","room_confirmation_number":"PB12398161714","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"135002","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-04 00:03:19","reservation_modified_date_time":"2021-12-05 19:57:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135002","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":"5340912","reservation_id":"126294","confirmation_number":"PB12273947971","room_confirmation_number":"PB12318985645","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"135005","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-05 00:01:37","reservation_modified_date_time":"2021-12-05 20:59:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135005","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":"3285219","reservation_id":"119461","confirmation_number":"PB12289456647","room_confirmation_number":"PB12327150846","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","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":"126609","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-16 18:48:13","reservation_modified_date_time":"2021-07-16 18:48:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126609","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":"5339353","reservation_id":"118828","confirmation_number":"PB12275497433","room_confirmation_number":"PB12342029860","room_stay_from":"2021-11-30","room_stay_to":"2021-12-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"134746","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-06 22:05:07","reservation_modified_date_time":"2021-11-30 17:44:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134746","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":"5339690","reservation_id":"120407","confirmation_number":"PB12261690683","room_confirmation_number":"PB12368284102","room_stay_from":"2021-12-02","room_stay_to":"2021-12-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"127684","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-30 15:47:41","reservation_modified_date_time":"2021-12-01 16:31:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127684","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":"5340770","reservation_id":"126030","confirmation_number":"PB12276206380","room_confirmation_number":"PB12385798025","room_stay_from":"2021-11-29","room_stay_to":"2021-12-07","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":"134656","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-29 06:41:28","reservation_modified_date_time":"2021-12-05 15:01:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134656","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340896","reservation_id":"120806","confirmation_number":"PB12269491784","room_confirmation_number":"PB12344003284","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"135004","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-08-06 03:40:12","reservation_modified_date_time":"2021-12-05 20:30:40","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135004","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":"5340965","reservation_id":"126311","confirmation_number":"PB12241658978","room_confirmation_number":"PB12345656905","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","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":"135017","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-05 17:58:14","reservation_modified_date_time":"2021-12-05 23:23:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135017","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":"5340974","reservation_id":"126298","confirmation_number":"PB12226068962","room_confirmation_number":"PB12310431372","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","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":"135017","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-05 03:51:44","reservation_modified_date_time":"2021-12-05 23:32:47","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135017","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":"5340989","reservation_id":"126324","confirmation_number":"PB12244363797","room_confirmation_number":"PB12366142376","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","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":"135024","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-05 23:19:31","reservation_modified_date_time":"2021-12-06 01:31:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135024","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":"5340626","reservation_id":"126116","confirmation_number":"PB12225350030","room_confirmation_number":"PB12375974797","room_stay_from":"2021-12-05","room_stay_to":"2021-12-08","room_stay_status":"Active","nightly_price":"20,20,20","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":"134961","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-30 03:14:03","reservation_modified_date_time":"2021-12-04 18:37:57","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134961","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":"5340628","reservation_id":"125700","confirmation_number":"PB12259721021","room_confirmation_number":"PB12318293221","room_stay_from":"2021-12-04","room_stay_to":"2021-12-08","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"134962","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-20 23:03:11","reservation_modified_date_time":"2021-12-04 19:10:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134962","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":"5340737","reservation_id":"126252","confirmation_number":"PB12211870667","room_confirmation_number":"PB12398735676","room_stay_from":"2021-12-04","room_stay_to":"2021-12-08","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"134978","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-03 20:13:52","reservation_modified_date_time":"2021-12-05 02:23:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134978","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":"5340927","reservation_id":"125780","confirmation_number":"PB12275543270","room_confirmation_number":"PB12390311525","room_stay_from":"2021-12-05","room_stay_to":"2021-12-08","room_stay_status":"Active","nightly_price":"20,20,20","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":"135008","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-23 01:19:16","reservation_modified_date_time":"2021-12-05 22:23:25","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135008","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":"5340892","reservation_id":"126305","confirmation_number":"PB12250634400","room_confirmation_number":"PB12325439575","room_stay_from":"2021-12-05","room_stay_to":"2021-12-09","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":"135003","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-05 15:47:50","reservation_modified_date_time":"2021-12-05 20:24:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135003","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":"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#&#12","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":"5339145","reservation_id":"125778","confirmation_number":"PB12224176872","room_confirmation_number":"PB12330411355","room_stay_from":"2021-12-05","room_stay_to":"2021-12-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"45253","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-23 00:41:37","reservation_modified_date_time":"2021-11-30 00:33:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"45253","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":"5340562","reservation_id":"118501","confirmation_number":"PB12286426874","room_confirmation_number":"PB12375087029","room_stay_from":"2021-12-04","room_stay_to":"2021-12-10","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":"125539","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-02 01:05:39","reservation_modified_date_time":"2021-12-04 16:00:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125539","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":"5340155","reservation_id":"125863","confirmation_number":"PB12284380423","room_confirmation_number":"PB12390155314","room_stay_from":"2021-12-03","room_stay_to":"2021-12-11","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":"134439","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-03 13:53:28","reservation_modified_date_time":"2021-12-03 13:53:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134439","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":"5340857","reservation_id":"125381","confirmation_number":"PB12224463730","room_confirmation_number":"PB12315529751","room_stay_from":"2021-12-05","room_stay_to":"2021-12-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"66648","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-13 01:52:15","reservation_modified_date_time":"2021-12-05 17:15:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66648","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5340756","reservation_id":"124688","confirmation_number":"PB12278586605","room_confirmation_number":"PB12348350554","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-12-05 13:41:03","reservation_modified_date_time":"2021-12-05 13:41:03","customer_id":"133265","parentCustTravId":"133265","customer_traveller_id":"133265","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-12-02","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":"5340762","reservation_id":"126273","confirmation_number":"PB12212081919","room_confirmation_number":"PB12310270294","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"69.00","grand_total":"77.97","paid_amount":"77.97","product_id":"1142","service_quantity":"1","product_name":"1\/2 Day Sunset Late Check-out \/ Off-Season","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 14:27:26","reservation_modified_date_time":"2021-12-05 14:27:26","customer_id":"134940","parentCustTravId":"134940","customer_traveller_id":"134940","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-12-04","sub_hotel_id":"123","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5340763","reservation_id":"126269","confirmation_number":"PB12268806103","room_confirmation_number":"PB12342461542","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":"45.20","paid_amount":"45.20","product_id":"1141","service_quantity":"2","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 14:38:03","reservation_modified_date_time":"2021-12-05 14:38:03","customer_id":"134932","parentCustTravId":"134932","customer_traveller_id":"134932","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-12-03","sub_hotel_id":"123","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5340787","reservation_id":"115568","confirmation_number":"PB12296833833","room_confirmation_number":"PB12384359637","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 16:07:00","reservation_modified_date_time":"2021-12-05 16:07:00","customer_id":"122318","parentCustTravId":"122318","customer_traveller_id":"122318","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-12-02","sub_hotel_id":"123","currentDayPrice":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5340904","reservation_id":"125577","confirmation_number":"PB12235451665","room_confirmation_number":"PB12380963836","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-12-05 20:46:13","reservation_modified_date_time":"2021-12-05 20:46:13","customer_id":"134013","parentCustTravId":"134013","customer_traveller_id":"134013","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-12-05","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5340913","reservation_id":"126294","confirmation_number":"PB12298037007","room_confirmation_number":"PB12318985645","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.01","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 20:55:32","reservation_modified_date_time":"2021-12-05 20:59:24","customer_id":"135005","parentCustTravId":"135005","customer_traveller_id":"135005","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-12-05","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":"5340923","reservation_id":"125778","confirmation_number":"PB12267768845","room_confirmation_number":"PB12330411355","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-12-05 21:55:53","reservation_modified_date_time":"2021-12-05 21:55:53","customer_id":"45253","parentCustTravId":"45253","customer_traveller_id":"45253","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-12-05","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5340760","reservation_id":"126301","confirmation_number":"PB12247522311","room_confirmation_number":"PB12358568657","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.26","grand_total":"3.49","paid_amount":"3.49","product_id":"1155","service_quantity":"1","product_name":"Deodorant","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 14:16:43","reservation_modified_date_time":"2021-12-05 14:16: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":"3.26","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5340916","reservation_id":"126315","confirmation_number":"PB12247802617","room_confirmation_number":"PB12362151621","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 21:10:11","reservation_modified_date_time":"2021-12-05 21:10:11","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"123","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5340952","reservation_id":"126319","confirmation_number":"PB12286830324","room_confirmation_number":"PB12391111598","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 23:08:21","reservation_modified_date_time":"2021-12-05 23:08:21","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","sub_hotel_id":"123","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5340556","reservation_id":"120071","confirmation_number":"PB12265083110","room_confirmation_number":"PB12329795089","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":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-04 15:42:55","reservation_modified_date_time":"2021-12-04 15:42:55","customer_id":"134850","parentCustTravId":"134850","customer_traveller_id":"134850","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-12-05 14:49:09","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-12-02","sub_hotel_id":"123","deltaChange":-37.4,"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":"5340565","reservation_id":"126011","confirmation_number":"PB12271653646","room_confirmation_number":"PB12314193547","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-12-04 16:12:53","reservation_modified_date_time":"2021-12-04 16:12:53","customer_id":"134933","parentCustTravId":"134933","customer_traveller_id":"134933","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-12-05 14:42:46","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-12-03","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":"5340592","reservation_id":"107593","confirmation_number":"PB12268019227","room_confirmation_number":"PB12363972274","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":"60.03","paid_amount":"0.00","product_id":"2010","service_quantity":"6","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-04 17:22:01","reservation_modified_date_time":"2021-12-04 17:22:27","customer_id":"114050","parentCustTravId":"114050","customer_traveller_id":"114050","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-12-05 17:09:41","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-12-03","sub_hotel_id":"123","deltaChange":-56.1,"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":"5340683","reservation_id":"126278","confirmation_number":"PB12221338370","room_confirmation_number":"PB12387859647","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-12-04 20:46:15","reservation_modified_date_time":"2021-12-04 21:15:00","customer_id":"134970","parentCustTravId":"134970","customer_traveller_id":"134970","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-12-05 15:23:59","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-12-04","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":"5340704","reservation_id":"126279","confirmation_number":"PB12270716771","room_confirmation_number":"PB12352626680","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-12-04 18:14:17","reservation_modified_date_time":"2021-12-04 23:26:46","customer_id":"134958","parentCustTravId":"134958","customer_traveller_id":"134958","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-12-05 15:27:46","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-12-04","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":"5340757","reservation_id":"124688","confirmation_number":"PB12225943597","room_confirmation_number":"PB12348350554","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-12-02 20:08:46","reservation_modified_date_time":"2021-12-02 20:08:46","customer_id":"133265","parentCustTravId":"133265","customer_traveller_id":"133265","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-12-05 18:07:54","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-12-02","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"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[],"htl_taxable":[{"room_stay_id":"5340966","reservation_id":"126311","confirmation_number":"PB12345656905","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"96.12,96.12","nightly_discount":"0.00,0.00","subtotal":"192.24","grand_total":"217.23","paid_amount":"217.23","room_type_id":"289","product_id":"1104","siteminder_id":"HTL-1866632613","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":"135017","customer_id":"135017","source_of_creation":"Expedia","reservation_created_date":"2021-12-05 17:58:14","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":null,"sub_hotel_id":"123","currentDayPrice":"96.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340975","reservation_id":"126298","confirmation_number":"PB12310431372","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.09,113.09","nightly_discount":"0,0","subtotal":"226.18","grand_total":"255.58","paid_amount":"255.58","room_type_id":"289","product_id":"1095","siteminder_id":"HTL-1866490342","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":"135017","customer_id":"135017","source_of_creation":"Expedia","reservation_created_date":"2021-12-05 03:51:44","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":null,"sub_hotel_id":"123","currentDayPrice":"113.09","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ean_taxable":[{"room_stay_id":"5340990","reservation_id":"126324","confirmation_number":"PB12366142376","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.39,82.39","nightly_discount":"0.00,0.00","subtotal":"164.78","grand_total":"186.20","paid_amount":"186.20","room_type_id":"289","product_id":"1099","siteminder_id":"EAN-1866735101","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":"135024","customer_id":"135024","source_of_creation":"Expedia","reservation_created_date":"2021-12-05 23:19:31","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"82.39","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":8,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"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":"3258716","reservation_id":"116118","confirmation_number":"BV12478795114","room_stay_from":"2021-12-04","room_stay_to":"2021-12-17","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,120.00,120.00,140.00,140.00,120.00,120.00,120.00,120.00,120.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","subtotal":"1620.00","grand_total":"1830.60","paid_amount":"1830.60","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"64584","customer_id":"64584","source_of_creation":"FE","reservation_created_date":"2021-05-29 00:33:43","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"5335579","reservation_id":"125595","confirmation_number":"BV12424263360","room_stay_from":"2021-12-04","room_stay_to":"2021-12-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.90,173.90,173.90,173.90,173.90,173.90","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1080.40","grand_total":"1220.85","paid_amount":"1220.85","room_type_id":"304","product_id":"1218","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":"134025","customer_id":"134025","source_of_creation":"PMS","reservation_created_date":"2021-11-17 18:21:54","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"173.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339385","reservation_id":"125694","confirmation_number":"BV12455877437","room_stay_from":"2021-12-05","room_stay_to":"2021-12-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.95,160.95,160.95,160.95,160.95","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"804.75","grand_total":"909.37","paid_amount":"909.37","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96406","customer_id":"96406","source_of_creation":"PMS","reservation_created_date":"2021-11-20 19:52:33","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"160.95","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339391","reservation_id":"126043","confirmation_number":"BV12426800132","room_stay_from":"2021-12-02","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.05,166.61,166.61,137.38","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"576.65","grand_total":"651.62","paid_amount":"651.62","room_type_id":"304","product_id":"1221","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":"134670","customer_id":"134670","source_of_creation":"PMS","reservation_created_date":"2021-11-29 16:09:16","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","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":"137.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340876","reservation_id":"126308","confirmation_number":"BV12495623340","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00","nightly_discount":"0.00,0","subtotal":"198.00","grand_total":"223.74","paid_amount":"223.74","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134976","customer_id":"134976","source_of_creation":"PMS","reservation_created_date":"2021-12-05 16:41:46","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340982","reservation_id":"126329","confirmation_number":"BV12461391419","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.70","nightly_discount":"0.00","subtotal":"88.70","grand_total":"100.23","paid_amount":"100.23","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":"115018","customer_id":"115018","source_of_creation":"PMS","reservation_created_date":"2021-12-06 00:58:33","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","currentDayPrice":"88.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"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":"5339392","reservation_id":"126043","confirmation_number":"BV12243034724","room_confirmation_number":"BV12426800132","room_stay_from":"2021-12-02","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"134670","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-29 16:09:16","reservation_modified_date_time":"2021-11-30 19:06:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134670","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":"5340983","reservation_id":"126329","confirmation_number":"BV12295816547","room_confirmation_number":"BV12461391419","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"115018","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-06 00:58:33","reservation_modified_date_time":"2021-12-06 00:58:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"115018","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":"5340877","reservation_id":"126308","confirmation_number":"BV12294827948","room_confirmation_number":"BV12495623340","room_stay_from":"2021-12-05","room_stay_to":"2021-12-07","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":"134976","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-05 16:41:46","reservation_modified_date_time":"2021-12-05 19:30:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134976","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":"5335580","reservation_id":"125595","confirmation_number":"BV12256979583","room_confirmation_number":"BV12424263360","room_stay_from":"2021-12-04","room_stay_to":"2021-12-10","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":"134025","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-17 18:21:54","reservation_modified_date_time":"2021-11-17 18:21:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134025","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":"5339386","reservation_id":"125694","confirmation_number":"BV12243698037","room_confirmation_number":"BV12455877437","room_stay_from":"2021-12-05","room_stay_to":"2021-12-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"96406","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-20 19:52:33","reservation_modified_date_time":"2021-11-30 19:05:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96406","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":"3258717","reservation_id":"116118","confirmation_number":"BV12269399288","room_confirmation_number":"BV12478795114","room_stay_from":"2021-12-04","room_stay_to":"2021-12-17","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","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","subtotal":"156.00","grand_total":"176.28","paid_amount":"176.28","product_id":"1781","service_quantity":"1","customer_traveller_id":"64584","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-05-29 00:33:43","reservation_modified_date_time":"2021-05-29 00:33:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"64584","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5340788","reservation_id":"126275","confirmation_number":"BV12244101652","room_confirmation_number":"BV12478410131","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-12-05 16:11:37","reservation_modified_date_time":"2021-12-05 16:11:37","customer_id":"134941","parentCustTravId":"134941","customer_traveller_id":"134941","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-12-04","sub_hotel_id":"124","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":"5340917","reservation_id":"125595","confirmation_number":"BV12257140149","room_confirmation_number":"BV12424263360","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"20.00","product_id":"1158","service_quantity":"2","product_name":"Fishing Pole","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-05 21:16:09","reservation_modified_date_time":"2021-12-05 21:16:09","customer_id":"134025","parentCustTravId":"134025","customer_traveller_id":"134025","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-12-04","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":"5340918","reservation_id":"125595","confirmation_number":"BV12241243137","room_confirmation_number":"BV12424263360","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-12-05 15:24:34","reservation_modified_date_time":"2021-12-05 15:24:34","customer_id":"134025","parentCustTravId":"134025","customer_traveller_id":"134025","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-12-04","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":"5340919","reservation_id":"126308","confirmation_number":"BV12219129002","room_confirmation_number":"BV12495623340","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-12-05 21:19:59","reservation_modified_date_time":"2021-12-05 21:19:59","customer_id":"134976","parentCustTravId":"134976","customer_traveller_id":"134976","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-12-05","sub_hotel_id":"124","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":"5338745","reservation_id":"124498","confirmation_number":"BV12280639371","room_confirmation_number":"BV12443602923","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"50.00","grand_total":"53.50","paid_amount":"0.00","product_id":"1175","service_quantity":"1","product_name":"Miscellaneous","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-28 15:54:25","reservation_modified_date_time":"2021-11-28 15:54:25","customer_id":"134505","parentCustTravId":"134505","customer_traveller_id":"134505","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-12-05 14:37:04","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-25","sub_hotel_id":"124","deltaChange":-50,"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":[],"htl_taxable":[],"ean_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":9,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1134,1127,1136,1124","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BP12239593862","room_stay_from":"2021-12-05","room_stay_to":"2021-12-09","bundle_room":"0","product_id":"1134"},{"confirmation_number":"BP12252828856","room_stay_from":"2021-12-05","room_stay_to":"2021-12-09","bundle_room":"0","product_id":"1127"},{"confirmation_number":"BP12217136296","room_stay_from":"2021-11-30","room_stay_to":"2021-12-06","bundle_room":"0","product_id":"1136"},{"confirmation_number":"BP12266616944","room_stay_from":"2021-11-30","room_stay_to":"2021-12-06","bundle_room":"0","product_id":"1124"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5340357","reservation_id":"124972","confirmation_number":"BP12573152162","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"138.69,138.69,118.88","nightly_discount":"0,0,0","subtotal":"396.26","grand_total":"447.78","paid_amount":"447.78","room_type_id":"301","product_id":"1137","siteminder_id":"BDC-3476015458","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134893","customer_id":"134893","source_of_creation":"Booking.com","reservation_created_date":"2021-11-02 09:20:16","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 824","ota_service_fee_amount":"0","commision_charges":"82.13","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"118.88","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":"5340979","reservation_id":"126327","confirmation_number":"BP12586651637","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.96","nightly_discount":"0","subtotal":"62.96","grand_total":"71.15","paid_amount":"71.15","room_type_id":"295","product_id":"1128","siteminder_id":"BDC-2561387818","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":"135022","customer_id":"135022","source_of_creation":"Booking.com","reservation_created_date":"2021-12-05 23:29:59","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"14.93","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"62.96","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":"5340380","reservation_id":"125550","confirmation_number":"BP12550461309","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"207.95,207.95,188.79","nightly_discount":"0,0,0","subtotal":"604.69","grand_total":"683.30","paid_amount":"683.30","room_type_id":"296","product_id":"1131","siteminder_id":"EXP-1858625840","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":"134897","customer_id":"134897","source_of_creation":"Expedia","reservation_created_date":"2021-11-16 17:27:54","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","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":"188.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"}]}],"exp_non_taxable":[{"room_stay_id":"5340854","reservation_id":"126309","confirmation_number":"BP12533845423","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"50.55","nightly_discount":"0","subtotal":"50.55","grand_total":"57.12","paid_amount":"57.12","room_type_id":"295","product_id":"1128","siteminder_id":"EXP-1866619399","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":"134994","customer_id":"134994","source_of_creation":"Expedia","reservation_created_date":"2021-12-05 17:11:48","service_canceled_date_time":"2021-12-05 18:23:13","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"125","deltaChange":"57.12","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"5340882","reservation_id":"126314","confirmation_number":"BP12579586833","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Canceled","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"69.74","nightly_discount":"0","subtotal":"69.74","grand_total":"78.80","paid_amount":"78.80","room_type_id":"294","product_id":"1125","siteminder_id":"EXP-1866647455","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":"135001","customer_id":"135001","source_of_creation":"Expedia","reservation_created_date":"2021-12-05 19:35:17","service_canceled_date_time":"2021-12-06 00:39:11","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","ota_service_fee_amount":"0","commision_charges":"0.00","sub_hotel_id":"125","deltaChange":"78.80","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":"5340671","reservation_id":"126012","confirmation_number":"BP12572843958","room_stay_from":"2021-12-04","room_stay_to":"2021-12-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.05,88.20,88.20,88.20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"377.65","grand_total":"426.75","paid_amount":"426.75","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134626","customer_id":"134626","source_of_creation":"FE","reservation_created_date":"2021-11-28 18:26:50","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"88.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"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"5340739","reservation_id":"126296","confirmation_number":"BP12580860228","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"88.70","nightly_discount":"0.00","subtotal":"88.70","grand_total":"100.23","paid_amount":"100.23","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134979","customer_id":"134979","source_of_creation":"PMS","reservation_created_date":"2021-12-05 02:46:32","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"88.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5340816","reservation_id":"125954","confirmation_number":"BP12532412377","room_stay_from":"2021-12-09","room_stay_to":"2021-12-12","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"132.09,163.54,163.54","nightly_discount":"0.00,0.00,0","subtotal":"459.17","grand_total":"518.86","paid_amount":"149.26","room_type_id":"295","product_id":"1129","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131559","customer_id":"131559","source_of_creation":"PMS","reservation_created_date":"2021-11-26 21:41:43","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"5340356","reservation_id":"124972","confirmation_number":"BP12279987523","room_confirmation_number":"BP12573152162","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20,20,20","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":"134893","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-02 09:20:16","reservation_modified_date_time":"2021-12-03 19:29:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134893","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.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":"5340378","reservation_id":"125550","confirmation_number":"BP12219976755","room_confirmation_number":"BP12550461309","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20,20,20","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":"134897","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-11-16 17:27:54","reservation_modified_date_time":"2021-12-03 20:05:51","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134897","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":"5340740","reservation_id":"126296","confirmation_number":"BP12214005565","room_confirmation_number":"BP12580860228","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"134979","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-12-05 02:46:32","reservation_modified_date_time":"2021-12-05 02:46:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134979","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":"5340978","reservation_id":"126327","confirmation_number":"BP12289430160","room_confirmation_number":"BP12586651637","room_stay_from":"2021-12-05","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"135022","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-12-05 23:29:59","reservation_modified_date_time":"2021-12-05 23:59:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"135022","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":"5340672","reservation_id":"126012","confirmation_number":"BP12265500710","room_confirmation_number":"BP12572843958","room_stay_from":"2021-12-04","room_stay_to":"2021-12-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.23","product_id":"1781","service_quantity":"1","customer_traveller_id":"134626","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-28 18:26:50","reservation_modified_date_time":"2021-12-04 21:10:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134626","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":"5340817","reservation_id":"125954","confirmation_number":"BP12268357491","room_confirmation_number":"BP12532412377","room_stay_from":"2021-12-09","room_stay_to":"2021-12-12","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"131559","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-11-26 21:41:43","reservation_modified_date_time":"2021-12-05 16:38:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131559","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":"5340379","reservation_id":"125550","confirmation_number":"BP12213994226","room_confirmation_number":"BP12550461309","room_stay_from":"2021-12-03","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"45.00,45.00,45.00","nightly_discount":"0.00,0.00,0.00","subtotal":"135.00","grand_total":"152.55","paid_amount":"152.55","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-30 21:37:37","reservation_modified_date_time":"2021-12-03 20:05:51","customer_id":"134897","parentCustTravId":"134897","customer_traveller_id":"134897","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-12-03","sub_hotel_id":"125","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":"5339064","reservation_id":"125898","confirmation_number":"BP12220635680","room_confirmation_number":"BP12552690841","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-29 20:38:04","reservation_modified_date_time":"2021-11-29 20:47:54","customer_id":"134689","parentCustTravId":"134689","customer_traveller_id":"134689","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-12-05 18:53:07","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-29","sub_hotel_id":"125","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"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[],"htl_taxable":[],"ean_taxable":[]}}}