{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2021-12-01","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":24,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1124,1136","block_room_bookings":[{"confirmation_number":"BP12266616944","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","bundle_room":"0","product_id":"1124"},{"confirmation_number":"BP12217136296","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","bundle_room":"0","product_id":"1136"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5339065","reservation_id":"125898","confirmation_number":"BP12552690841","room_stay_from":"2021-11-29","room_stay_to":"2021-12-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"91.03,91.03,131.57,131.57,192.33,192.33","nightly_discount":"0,0,0,0,0,0","subtotal":"829.86","grand_total":"937.74","paid_amount":"937.74","room_type_id":"295","product_id":"1129","siteminder_id":"BDC-3217827895","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":"134689","customer_id":"134689","source_of_creation":"Booking.com","reservation_created_date":"2021-11-25 16:31:33","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"170.97","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"131.57","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339415","reservation_id":"126002","confirmation_number":"BV12466729378","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"79.14","nightly_discount":"0","subtotal":"79.14","grand_total":"89.43","paid_amount":"89.43","room_type_id":"289","product_id":"1108","siteminder_id":"BDC-2274193343","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":"134753","customer_id":"134753","source_of_creation":"Booking.com","reservation_created_date":"2021-11-28 14:41:38","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"17.85","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"79.14","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":"5339819","reservation_id":"126168","confirmation_number":"BV12426103359","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"79.14","nightly_discount":"0","subtotal":"79.14","grand_total":"89.43","paid_amount":"89.43","room_type_id":"307","product_id":"1224","siteminder_id":"BDC-2198602127","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":"134784","customer_id":"134804","source_of_creation":"Booking.com","reservation_created_date":"2021-12-01 06:20:50","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"17.85","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"79.14","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":"5339828","reservation_id":"126176","confirmation_number":"BP12572290512","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.41,109.41","nightly_discount":"0,0","subtotal":"218.82","grand_total":"247.27","paid_amount":"247.27","room_type_id":"296","product_id":"1131","siteminder_id":"BDC-3883918817","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":"134805","customer_id":"134805","source_of_creation":"Booking.com","reservation_created_date":"2021-12-01 15:28:23","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"46.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"109.41","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":"5339906","reservation_id":"124958","confirmation_number":"PB12322570814","room_stay_from":"2021-11-26","room_stay_to":"2021-11-27","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"498.29","nightly_discount":"0","subtotal":"498.29","grand_total":"563.07","paid_amount":"540.46","room_type_id":"313","product_id":"1228","siteminder_id":"BDC-2205518272","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133102","customer_id":"133102","source_of_creation":"Booking.com","reservation_created_date":"2021-11-01 21:34:19","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"155.49","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"-498.29","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"5337577","reservation_id":"110587","confirmation_number":"PB12391801686","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.62,84.62,84.62,84.62","nightly_discount":"0,0,0,0","subtotal":"338.48","grand_total":"382.48","paid_amount":"382.48","room_type_id":"289","product_id":"1094","siteminder_id":"EXP-1748888048","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":"134396","customer_id":"134396","source_of_creation":"Expedia","reservation_created_date":"2021-03-17 23:42:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"84.62","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":"5338907","reservation_id":"119880","confirmation_number":"BV12422949988","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"69.64,69.64,69.64","nightly_discount":"0,0,0","subtotal":"208.92","grand_total":"236.08","paid_amount":"236.08","room_type_id":"304","product_id":"1220","siteminder_id":"EXP-1805378795","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":"133194","customer_id":"133194","source_of_creation":"Expedia","reservation_created_date":"2021-07-23 02:35:09","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"69.64","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":"5339307","reservation_id":"126130","confirmation_number":"BP12518068079","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"84.07,96.00","nightly_discount":"0,0","subtotal":"180.07","grand_total":"203.47","paid_amount":"203.47","room_type_id":"294","product_id":"1125","siteminder_id":"EXP-1864569283","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":"134497","customer_id":"134497","source_of_creation":"Expedia","reservation_created_date":"2021-11-30 07:44:44","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","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":"96.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"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":"5339367","reservation_id":"120985","confirmation_number":"PB12382600093","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"72.53,72.53,72.53","nightly_discount":"0,0,0","subtotal":"217.59","grand_total":"245.88","paid_amount":"245.88","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1813840942","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":"134750","customer_id":"134750","source_of_creation":"Expedia","reservation_created_date":"2021-08-09 17:54:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"72.53","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":"5339465","reservation_id":"125941","confirmation_number":"BP12578194710","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"47.26,71.94","nightly_discount":"0,0","subtotal":"119.20","grand_total":"134.69","paid_amount":"134.69","room_type_id":"300","product_id":"1135","siteminder_id":"EXP-1863087155","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":"134766","customer_id":"134766","source_of_creation":"Expedia","reservation_created_date":"2021-11-26 18:35:46","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 805","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":"71.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":"5339469","reservation_id":"115554","confirmation_number":"PB12363197872","room_stay_from":"2021-11-30","room_stay_to":"2021-12-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"78.58,78.58,78.58,88.59,88.59","nightly_discount":"0,0,0,0,0","subtotal":"412.92","grand_total":"466.60","paid_amount":"466.60","room_type_id":"289","product_id":"1093","siteminder_id":"EXP-1773556598","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":"134767","customer_id":"134767","source_of_creation":"Expedia","reservation_created_date":"2021-05-20 16:35:11","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":"78.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339473","reservation_id":"115553","confirmation_number":"PB12391482666","room_stay_from":"2021-11-30","room_stay_to":"2021-12-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"78.58,78.58,78.58,88.59,88.59","nightly_discount":"0,0,0,0,0","subtotal":"412.92","grand_total":"466.60","paid_amount":"466.60","room_type_id":"289","product_id":"1121","siteminder_id":"EXP-1773556597","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":"134769","customer_id":"134769","source_of_creation":"Expedia","reservation_created_date":"2021-05-20 16:35:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"78.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339505","reservation_id":"125852","confirmation_number":"BV12470780232","room_stay_from":"2021-12-01","room_stay_to":"2021-12-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.45,99.45,135.38","nightly_discount":"0,0,0","subtotal":"334.28","grand_total":"377.74","paid_amount":"377.74","room_type_id":"304","product_id":"1219","siteminder_id":"EXP-1862214104","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":"134774","customer_id":"134774","source_of_creation":"Expedia","reservation_created_date":"2021-11-24 15:50:07","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":"99.45","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":"5339609","reservation_id":"126148","confirmation_number":"PB12329753641","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"63.23,77.68","nightly_discount":"0.00,0.00","subtotal":"140.91","grand_total":"159.22","paid_amount":"159.22","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1864765759","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":"134782","customer_id":"134782","source_of_creation":"Expedia","reservation_created_date":"2021-11-30 19:21:08","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"77.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339803","reservation_id":"120769","confirmation_number":"PB12321901869","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"124.9","nightly_discount":"0","subtotal":"124.90","grand_total":"141.13","paid_amount":"141.13","room_type_id":"289","product_id":"1095","siteminder_id":"EXP-1811920659","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134800","customer_id":"134800","source_of_creation":"Expedia","reservation_created_date":"2021-08-05 12:15:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"124.9","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":"5339812","reservation_id":"126123","confirmation_number":"BP12559834781","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"45.83,45.83","nightly_discount":"0,0","subtotal":"91.66","grand_total":"103.58","paid_amount":"103.58","room_type_id":"295","product_id":"1128","siteminder_id":"EXP-1864147188","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":"134802","customer_id":"134802","source_of_creation":"Expedia","reservation_created_date":"2021-11-30 06:23:06","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","currentDayPrice":"45.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339902","reservation_id":"126179","confirmation_number":"BP12531631619","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"51.31","nightly_discount":"0","subtotal":"51.31","grand_total":"57.98","paid_amount":"57.98","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1865120647","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":"134819","customer_id":"134819","source_of_creation":"Expedia","reservation_created_date":"2021-12-01 16:09:19","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"51.31","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5339000","reservation_id":"120869","confirmation_number":"BP12552563671","room_stay_from":"2021-11-28","room_stay_to":"2021-12-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"50.59,50.59,50.59,50.59,50.59,59.02","nightly_discount":"0,0,0,0,0,0","subtotal":"311.97","grand_total":"352.53","paid_amount":"352.53","room_type_id":"294","product_id":"1127","siteminder_id":"GAM-R2717833349","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":"134678","customer_id":"134678","source_of_creation":"Getaroom.com","reservation_created_date":"2021-08-07 04:54:12","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 822","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":"50.59","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"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":"5338731","reservation_id":"125850","confirmation_number":"BV12452382605","room_stay_from":"2021-11-28","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.29,92.88,92.88,134.24","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"428.29","grand_total":"483.97","paid_amount":"483.97","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":"134428","customer_id":"134428","source_of_creation":"FE","reservation_created_date":"2021-11-24 14:47:39","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":"134.24","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339023","reservation_id":"126030","confirmation_number":"PB12385798025","room_stay_from":"2021-11-29","room_stay_to":"2021-12-06","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"859.15","grand_total":"970.84","paid_amount":"970.84","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","group_rooms":null,"currentDayPrice":"110.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339287","reservation_id":"126102","confirmation_number":"BP12513410324","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.21,101.87,101.87","nightly_discount":"0.00,0.00,0.00","subtotal":"292.95","grand_total":"331.04","paid_amount":"331.04","room_type_id":"294","product_id":"1126","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":"134709","customer_id":"134709","source_of_creation":"FE","reservation_created_date":"2021-11-30 01:50:46","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 806","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"101.87","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339308","reservation_id":"126013","confirmation_number":"PB12378836300","room_stay_from":"2021-12-01","room_stay_to":"2021-12-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.65,119.65,177.65,177.65","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"594.60","grand_total":"671.90","paid_amount":"671.90","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134628","customer_id":"134628","source_of_creation":"FE","reservation_created_date":"2021-11-28 18:29:18","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"119.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339798","reservation_id":"126149","confirmation_number":"BV12428148532","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.94,113.94","nightly_discount":"0.00,0.00","subtotal":"227.88","grand_total":"257.50","paid_amount":"257.50","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":"134755","customer_id":"134755","source_of_creation":"FE","reservation_created_date":"2021-11-30 19:45:17","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","currentDayPrice":"113.94","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339874","reservation_id":"126193","confirmation_number":"BV12417409393","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.76","nightly_discount":"0.00","subtotal":"94.76","grand_total":"107.08","paid_amount":"107.08","room_type_id":"303","product_id":"1139","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134813","customer_id":"134813","source_of_creation":"FE","reservation_created_date":"2021-12-01 23:33:08","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"94.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3293157","reservation_id":"120463","confirmation_number":"PB12376905504","room_stay_from":"2021-11-28","room_stay_to":"2021-12-05","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1104.00","grand_total":"1247.52","paid_amount":"1247.52","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":"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":"5338185","reservation_id":"125912","confirmation_number":"BP12563468012","room_stay_from":"2021-11-25","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.74,201.25,231.43,105.76,103.00,103.00,133.91","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,57.00","subtotal":"1063.09","grand_total":"1136.89","paid_amount":"1136.89","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134516","customer_id":"134516","source_of_creation":"PMS","reservation_created_date":"2021-11-25 21:47:17","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 804","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":"133.91","currentDayDiscount":"57.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5338372","reservation_id":"125942","confirmation_number":"PB12335681429","room_stay_from":"2021-11-27","room_stay_to":"2021-12-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.00,99.28,100.00,100.00,100.00,100.00,200.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"899.28","grand_total":"1016.19","paid_amount":"1016.19","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":"134538","customer_id":"134538","source_of_creation":"PMS","reservation_created_date":"2021-11-26 18:41:20","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"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":"5339080","reservation_id":"125787","confirmation_number":"PB12323129494","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.95,86.95,135.18,135.18","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"444.26","grand_total":"502.02","paid_amount":"502.02","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98071","customer_id":"98071","source_of_creation":"PMS","reservation_created_date":"2021-11-23 03:01:41","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"135.18","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339310","reservation_id":"126135","confirmation_number":"PB12396791322","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.00,90.00","nightly_discount":"0.00,0.00","subtotal":"181.00","grand_total":"204.53","paid_amount":"204.53","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":"134720","customer_id":"134720","source_of_creation":"PMS","reservation_created_date":"2021-11-30 15:19:49","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":"90.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339604","reservation_id":"126165","confirmation_number":"BP12511192682","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.36,101.36","nightly_discount":"0.00,0.00","subtotal":"202.72","grand_total":"229.07","paid_amount":"229.07","room_type_id":"302","product_id":"1138","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134780","customer_id":"134780","source_of_creation":"PMS","reservation_created_date":"2021-12-01 03:08:02","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"101.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":"5339639","reservation_id":"126060","confirmation_number":"BV12473283646","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"85.00,95.00,85.00,95.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"360.00","grand_total":"406.80","paid_amount":"406.80","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":"134675","customer_id":"134675","source_of_creation":"PMS","reservation_created_date":"2021-11-29 17:44:22","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"85.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339643","reservation_id":"126172","confirmation_number":"PB12323650834","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.00","nightly_discount":"0.00","subtotal":"64.00","grand_total":"72.32","paid_amount":"72.32","room_type_id":"289","product_id":"1110","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134704","customer_id":"134704","source_of_creation":"PMS","reservation_created_date":"2021-12-01 14:44:46","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","currentDayPrice":"64.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339691","reservation_id":"126087","confirmation_number":"PB12393928350","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00","nightly_discount":"0.00,0.00","subtotal":"260.00","grand_total":"293.80","paid_amount":"293.80","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":"134744","customer_id":"134744","source_of_creation":"PMS","reservation_created_date":"2021-12-01 16:33:32","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"130.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339860","reservation_id":"125750","confirmation_number":"PB12344773559","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,199.00","nightly_discount":"0.00,0.00","subtotal":"398.00","grand_total":"449.74","paid_amount":"449.74","room_type_id":"289","product_id":"1096","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":"134268","customer_id":"134268","source_of_creation":"PMS","reservation_created_date":"2021-11-22 15:37:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","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":"5339884","reservation_id":"126157","confirmation_number":"PB12341901637","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.76,118.37,118.37","nightly_discount":"0.00,0.00,0","subtotal":"341.50","grand_total":"385.90","paid_amount":"385.90","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":"134768","customer_id":"134768","source_of_creation":"PMS","reservation_created_date":"2021-11-30 22:05:29","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"118.37","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339891","reservation_id":"126007","confirmation_number":"PB12364022982","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.00,200.00","nightly_discount":"0.00,0.00","subtotal":"400.00","grand_total":"452.00","paid_amount":"452.00","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":"134600","customer_id":"134600","source_of_creation":"PMS","reservation_created_date":"2021-11-30 22:42:25","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":"200.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339743","reservation_id":"123599","confirmation_number":"PB12337331641","room_stay_from":"2021-12-12","room_stay_to":"2021-12-19","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"171.00,171.00,171.00,171.00,171.00,211.00,211.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1277.00","grand_total":"1443.01","paid_amount":"281.09","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99977","customer_id":"99977","source_of_creation":"PMS","reservation_created_date":"2021-09-24 17:23:04","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":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5339024","reservation_id":"126030","confirmation_number":"PB12293494816","room_confirmation_number":"PB12385798025","room_stay_from":"2021-11-29","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"134656","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-29 19:26:20","reservation_modified_date_time":"2021-11-29 19:26:20","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","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":"5339439","reservation_id":"125999","confirmation_number":"BV12239646642","room_confirmation_number":"BV12483892008","room_stay_from":"2021-11-29","room_stay_to":"2021-12-02","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"134681","product_attribute_values":"extra_person# ","reservation_created_date":"2021-11-30 20:24:50","reservation_modified_date_time":"2021-11-30 20:24:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134681","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"124","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":"5339801","reservation_id":"120769","confirmation_number":"PB12254073332","room_confirmation_number":"PB12321901869","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"134800","product_attribute_values":"extra_person# ","reservation_created_date":"2021-11-24 23:22:14","reservation_modified_date_time":"2021-12-01 18:31:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134800","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3293158","reservation_id":"120463","confirmation_number":"PB12244827763","room_confirmation_number":"PB12376905504","room_stay_from":"2021-11-28","room_stay_to":"2021-12-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"107164","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-07-31 13:41:04","reservation_modified_date_time":"2021-07-31 13:41:04","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":"5336849","reservation_id":"116592","confirmation_number":"PB12252831863","room_confirmation_number":"PB12396997296","room_stay_from":"2021-11-21","room_stay_to":"2021-12-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"228.00","grand_total":"257.64","paid_amount":"257.64","product_id":"1781","service_quantity":"1","customer_traveller_id":"91142","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-06-05 16:26:00","reservation_modified_date_time":"2021-11-21 21:20:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91142","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5337576","reservation_id":"110587","confirmation_number":"PB12230771194","room_confirmation_number":"PB12391801686","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"134396","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-17 23:42:08","reservation_modified_date_time":"2021-11-24 01:16:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134396","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":"5337935","reservation_id":"125855","confirmation_number":"PB12221672272","room_confirmation_number":"PB12322870111","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"134433","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-24 16:07:16","reservation_modified_date_time":"2021-11-24 23:23:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134433","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":"5338186","reservation_id":"125912","confirmation_number":"BP12288911852","room_confirmation_number":"BP12563468012","room_stay_from":"2021-11-25","room_stay_to":"2021-12-02","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"134516","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-25 21:47:17","reservation_modified_date_time":"2021-11-25 21:47:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134516","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":"5338373","reservation_id":"125942","confirmation_number":"PB12251471065","room_confirmation_number":"PB12335681429","room_stay_from":"2021-11-27","room_stay_to":"2021-12-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"134538","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-26 18:41:20","reservation_modified_date_time":"2021-11-26 18:41:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134538","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":"5338732","reservation_id":"125850","confirmation_number":"BV12284632321","room_confirmation_number":"BV12452382605","room_stay_from":"2021-11-28","room_stay_to":"2021-12-02","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":"134428","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-24 14:47:39","reservation_modified_date_time":"2021-11-28 14:58:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134428","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":"5338908","reservation_id":"119880","confirmation_number":"BV12281138182","room_confirmation_number":"BV12422949988","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"133194","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-23 02:35:09","reservation_modified_date_time":"2021-11-29 15:01:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133194","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5338999","reservation_id":"120869","confirmation_number":"BP12237621697","room_confirmation_number":"BP12552563671","room_stay_from":"2021-11-28","room_stay_to":"2021-12-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134678","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-07 04:54:12","reservation_modified_date_time":"2021-11-29 18:09:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134678","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339025","reservation_id":"126030","confirmation_number":"PB12276206380","room_confirmation_number":"PB12385798025","room_stay_from":"2021-11-29","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"134656","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-29 06:41:28","reservation_modified_date_time":"2021-11-29 19:26:20","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","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":"5339062","reservation_id":"125898","confirmation_number":"BP12274114616","room_confirmation_number":"BP12552690841","room_stay_from":"2021-11-29","room_stay_to":"2021-12-05","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134689","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-25 16:31:33","reservation_modified_date_time":"2021-11-29 20:47:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134689","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":"5339081","reservation_id":"125787","confirmation_number":"PB12267511805","room_confirmation_number":"PB12323129494","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","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":"98071","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-23 03:01:41","reservation_modified_date_time":"2021-11-29 21:24:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98071","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":"5339253","reservation_id":"126099","confirmation_number":"PB12262528988","room_confirmation_number":"PB12334803684","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134644","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 01:14:46","reservation_modified_date_time":"2021-11-30 07:07:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134644","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":"5339288","reservation_id":"126102","confirmation_number":"BP12284777927","room_confirmation_number":"BP12513410324","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","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":"134709","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-30 01:50:46","reservation_modified_date_time":"2021-11-30 13:11:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134709","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":"5339306","reservation_id":"126130","confirmation_number":"BP12244392818","room_confirmation_number":"BP12518068079","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","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":"134497","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 07:44:44","reservation_modified_date_time":"2021-11-30 14:57:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134497","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":"5339309","reservation_id":"126013","confirmation_number":"PB12231728402","room_confirmation_number":"PB12378836300","room_stay_from":"2021-12-01","room_stay_to":"2021-12-05","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":"134628","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-28 18:29:18","reservation_modified_date_time":"2021-11-30 15:17:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134628","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":"5339311","reservation_id":"126135","confirmation_number":"PB12222470129","room_confirmation_number":"PB12396791322","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","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":"134720","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-30 15:19:49","reservation_modified_date_time":"2021-11-30 15:19:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134720","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#","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":"5339366","reservation_id":"120985","confirmation_number":"PB12212337298","room_confirmation_number":"PB12382600093","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"134750","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-09 17:54:12","reservation_modified_date_time":"2021-11-30 18:36:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134750","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":"5339399","reservation_id":"126147","confirmation_number":"BV12258331145","room_confirmation_number":"BV12486322044","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134558","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 18:55:07","reservation_modified_date_time":"2021-11-30 19:11:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134558","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339416","reservation_id":"126002","confirmation_number":"BV12295912734","room_confirmation_number":"BV12466729378","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","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":"134753","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-28 14:41:38","reservation_modified_date_time":"2021-11-30 19:18:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134753","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":"5339442","reservation_id":"125999","confirmation_number":"BV12277485631","room_confirmation_number":"BV12483892008","room_stay_from":"2021-11-29","room_stay_to":"2021-12-02","room_stay_status":"Active","nightly_price":"20,20,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"52.00","grand_total":"58.76","paid_amount":"58.76","product_id":"1781","service_quantity":"1","customer_traveller_id":"134681","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-28 13:55:43","reservation_modified_date_time":"2021-11-30 20:24:56","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134681","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.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":"5339448","reservation_id":"126122","confirmation_number":"BP12287807404","room_confirmation_number":"BP12568680782","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","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":"134760","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 06:08:43","reservation_modified_date_time":"2021-11-30 20:58:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134760","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":"5339464","reservation_id":"125941","confirmation_number":"BP12222844930","room_confirmation_number":"BP12578194710","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","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":"134766","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-26 18:35:46","reservation_modified_date_time":"2021-11-30 22:01:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134766","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":"5339468","reservation_id":"115554","confirmation_number":"PB12210220844","room_confirmation_number":"PB12363197872","room_stay_from":"2021-11-30","room_stay_to":"2021-12-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"134767","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-20 16:35:11","reservation_modified_date_time":"2021-11-30 22:04:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134767","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":"5339472","reservation_id":"115553","confirmation_number":"PB12284284284","room_confirmation_number":"PB12391482666","room_stay_from":"2021-11-30","room_stay_to":"2021-12-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"134769","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-20 16:35:08","reservation_modified_date_time":"2021-11-30 22:12:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134769","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":"5339504","reservation_id":"125852","confirmation_number":"BV12239713237","room_confirmation_number":"BV12470780232","room_stay_from":"2021-12-01","room_stay_to":"2021-12-04","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":"134774","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-24 15:50:07","reservation_modified_date_time":"2021-12-01 00:14:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134774","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339605","reservation_id":"126165","confirmation_number":"BP12243099732","room_confirmation_number":"BP12511192682","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","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":"134780","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-12-01 03:08:02","reservation_modified_date_time":"2021-12-01 03:08:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134780","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":"5339608","reservation_id":"126148","confirmation_number":"PB12214456804","room_confirmation_number":"PB12329753641","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","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":"134782","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 19:21:08","reservation_modified_date_time":"2021-12-01 03:15:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134782","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":"5339626","reservation_id":"126111","confirmation_number":"PB12296719311","room_confirmation_number":"PB12344062168","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","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":"134775","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-12-01 03:32:03","reservation_modified_date_time":"2021-12-01 03:32:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134775","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":"5339640","reservation_id":"126060","confirmation_number":"BV12267199785","room_confirmation_number":"BV12473283646","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","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":"134675","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-29 17:44:22","reservation_modified_date_time":"2021-12-01 14:23:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134675","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":"5339644","reservation_id":"126172","confirmation_number":"PB12235296248","room_confirmation_number":"PB12323650834","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","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":"134704","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-12-01 14:44:46","reservation_modified_date_time":"2021-12-01 14:44:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134704","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":"5339692","reservation_id":"126087","confirmation_number":"PB12252700771","room_confirmation_number":"PB12393928350","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134744","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-12-01 16:33:32","reservation_modified_date_time":"2021-12-01 16:33:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134744","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":"5339799","reservation_id":"126149","confirmation_number":"BV12243441959","room_confirmation_number":"BV12428148532","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134755","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-30 19:45:17","reservation_modified_date_time":"2021-12-01 18:23:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134755","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":"5339802","reservation_id":"120769","confirmation_number":"PB12277345903","room_confirmation_number":"PB12321901869","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134800","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-05 12:15:07","reservation_modified_date_time":"2021-12-01 18:31:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134800","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339811","reservation_id":"126123","confirmation_number":"BP12281518587","room_confirmation_number":"BP12559834781","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134802","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 06:23:06","reservation_modified_date_time":"2021-12-01 18:41:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134802","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":"5339818","reservation_id":"126168","confirmation_number":"BV12211990821","room_confirmation_number":"BV12426103359","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","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":"134784","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-12-01 06:20:50","reservation_modified_date_time":"2021-12-01 20:10:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134804","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339827","reservation_id":"126176","confirmation_number":"BP12216832700","room_confirmation_number":"BP12572290512","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134805","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-12-01 15:28:23","reservation_modified_date_time":"2021-12-01 20:54:32","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134805","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":"5339861","reservation_id":"125750","confirmation_number":"PB12225808294","room_confirmation_number":"PB12344773559","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134268","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-22 15:37:55","reservation_modified_date_time":"2021-12-01 22:46:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134268","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":"5339875","reservation_id":"126193","confirmation_number":"BV12235003764","room_confirmation_number":"BV12417409393","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","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":"134813","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-12-01 23:33:08","reservation_modified_date_time":"2021-12-01 23:33:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134813","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":"5339885","reservation_id":"126157","confirmation_number":"PB12291436108","room_confirmation_number":"PB12341901637","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","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":"134768","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-30 22:05:29","reservation_modified_date_time":"2021-12-02 00:37:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134768","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":"5339890","reservation_id":"126007","confirmation_number":"PB12290803830","room_confirmation_number":"PB12364022982","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134600","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-30 22:42:25","reservation_modified_date_time":"2021-11-30 22:42:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134600","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":"5339901","reservation_id":"126179","confirmation_number":"BP12266568694","room_confirmation_number":"BP12531631619","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","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":"134819","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-12-01 16:09:19","reservation_modified_date_time":"2021-12-02 01:35:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134819","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":"5339695","reservation_id":"126138","confirmation_number":"PB12283769286","room_confirmation_number":"PB12328058314","room_stay_from":"2021-12-11","room_stay_to":"2021-12-12","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"134741","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 16:52:42","reservation_modified_date_time":"2021-12-01 16:47:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134741","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339742","reservation_id":"123599","confirmation_number":"PB12247815972","room_confirmation_number":"PB12337331641","room_stay_from":"2021-12-12","room_stay_to":"2021-12-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"99977","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-24 17:23:04","reservation_modified_date_time":"2021-12-01 17:20:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99977","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339907","reservation_id":"124958","confirmation_number":"PB12280241733","room_confirmation_number":"PB12322570814","room_stay_from":"2021-11-26","room_stay_to":"2021-11-27","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133102","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-01 21:34:19","reservation_modified_date_time":"2021-12-02 02:38:32","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133102","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"-20.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":"5339063","reservation_id":"125898","confirmation_number":"BP12248970845","room_confirmation_number":"BP12552690841","room_stay_from":"2021-11-29","room_stay_to":"2021-12-05","room_stay_status":"Active","nightly_price":"45.00,45.00,45.00,45.00,45.00,45.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"270.00","grand_total":"305.10","paid_amount":"305.10","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-29 20:32:35","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":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-29","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":"5339177","reservation_id":"126102","confirmation_number":"BP12270096496","room_confirmation_number":"BP12513410324","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","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 01:50:46","reservation_modified_date_time":"2021-11-30 01:50:46","customer_id":"134709","parentCustTravId":"134709","customer_traveller_id":"134709","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-30","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":"5339634","reservation_id":"125787","confirmation_number":"PB12278673759","room_confirmation_number":"PB12323129494","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":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-01 14:01:44","reservation_modified_date_time":"2021-12-01 14:01:44","customer_id":"98071","parentCustTravId":"98071","customer_traveller_id":"98071","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-29","sub_hotel_id":"123","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":"5339637","reservation_id":"126060","confirmation_number":"BV12216592134","room_confirmation_number":"BV12473283646","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","room_stay_status":"Active","nightly_price":"45.00,45.00,45.00,45.00","nightly_discount":"0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-29 17:44:22","reservation_modified_date_time":"2021-12-01 14:23:30","customer_id":"134675","parentCustTravId":"134675","customer_traveller_id":"134675","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-29","sub_hotel_id":"124","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"45.00","currentDayDiscount":null,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5339645","reservation_id":"116592","confirmation_number":"PB12265281066","room_confirmation_number":"PB12396997296","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.34","grand_total":"2.50","paid_amount":"2.50","product_id":"1205","service_quantity":"1","product_name":"Toothbrush","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-01 14:48:01","reservation_modified_date_time":"2021-12-01 14:48:01","customer_id":"91142","parentCustTravId":"91142","customer_traveller_id":"91142","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-21","sub_hotel_id":"123","currentDayPrice":"2.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5339679","reservation_id":"125850","confirmation_number":"BV12283183396","room_confirmation_number":"BV12452382605","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-01 15:57:34","reservation_modified_date_time":"2021-12-01 15:57:34","customer_id":"134428","parentCustTravId":"134428","customer_traveller_id":"134428","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-28","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":"5339693","reservation_id":"110587","confirmation_number":"PB12263356400","room_confirmation_number":"PB12391801686","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-01 16:44:25","reservation_modified_date_time":"2021-12-01 16:44:25","customer_id":"134396","parentCustTravId":"134396","customer_traveller_id":"134396","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-29","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":"5339800","reservation_id":"126149","confirmation_number":"BV12261284555","room_confirmation_number":"BV12428148532","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-01 18:24:10","reservation_modified_date_time":"2021-12-01 18:24:10","customer_id":"134755","parentCustTravId":"134755","customer_traveller_id":"134755","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-01","sub_hotel_id":"124","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5339816","reservation_id":"126087","confirmation_number":"PB12285491809","room_confirmation_number":"PB12393928350","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-01 19:20:48","reservation_modified_date_time":"2021-12-01 19:20:48","customer_id":"134744","parentCustTravId":"134744","customer_traveller_id":"134744","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-01","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":"5339876","reservation_id":"126193","confirmation_number":"BV12291813468","room_confirmation_number":"BV12417409393","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-01 23:36:10","reservation_modified_date_time":"2021-12-01 23:36:10","customer_id":"134813","parentCustTravId":"134813","customer_traveller_id":"134813","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-01","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":"5339903","reservation_id":"126179","confirmation_number":"PB12214693503","room_confirmation_number":"BP12531631619","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":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-02 01:35:57","reservation_modified_date_time":"2021-12-02 01:35:57","customer_id":"134819","parentCustTravId":"134819","customer_traveller_id":"134819","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-01","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":"5339682","reservation_id":"126178","confirmation_number":"PB12298297283","room_confirmation_number":"PB12335973090","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.27","grand_total":"3.50","paid_amount":"3.50","product_id":"1198","service_quantity":"1","product_name":"SunBlock \/ Tanning Oil","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-01 15:57:55","reservation_modified_date_time":"2021-12-01 15:57:55","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.27","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5339103","reservation_id":"125827","confirmation_number":"PB12216928390","room_confirmation_number":"PB12381420355","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-29 22:06:35","reservation_modified_date_time":"2021-11-29 22:06:35","customer_id":"45854","parentCustTravId":"45854","customer_traveller_id":"45854","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-01 22:22:11","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-28","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":"5339443","reservation_id":"126087","confirmation_number":"PB12225739072","room_confirmation_number":"PB12362606573","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-30 20:28:15","reservation_modified_date_time":"2021-11-30 20:28:15","customer_id":"134744","parentCustTravId":"134744","customer_traveller_id":"134744","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-01 19:20:42","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-29","sub_hotel_id":"123","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"5339877","reservation_id":"126007","confirmation_number":"PB12212957650","room_confirmation_number":"PB12364022982","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"25.00","paid_amount":"25.00","product_id":"1082","service_quantity":"1","product_name":"1pm c\/o","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-01 23:49:36","reservation_modified_date_time":"2021-12-01 23:49:36","customer_id":"134600","parentCustTravId":"134600","customer_traveller_id":"134600","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-01","sub_hotel_id":"123","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"5339681","reservation_id":"126178","confirmation_number":"PB12211819046","room_confirmation_number":"PB12335973090","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.00","grand_total":"2.00","paid_amount":"2.00","product_id":"1197","service_quantity":"1","product_name":"Stamps","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-01 15:57:55","reservation_modified_date_time":"2021-12-01 15:57:55","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":"2.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[],"ean_taxable":[{"room_stay_id":"5337934","reservation_id":"125855","confirmation_number":"PB12322870111","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"244.03,244.03","nightly_discount":"0,0","subtotal":"488.06","grand_total":"551.50","paid_amount":"551.50","room_type_id":"287","product_id":"1088","siteminder_id":"EAN-1862221230","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":"134433","customer_id":"134433","source_of_creation":"Expedia","reservation_created_date":"2021-11-24 16:07:16","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":"244.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":"5339441","reservation_id":"125999","confirmation_number":"BV12483892008","room_stay_from":"2021-11-29","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"50.55,58.81,113.00","nightly_discount":"0.00,0.00,0.00","subtotal":"222.36","grand_total":"251.27","paid_amount":"251.27","room_type_id":"305","product_id":"1222","siteminder_id":"EAN-1863746419","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134681","customer_id":"134681","source_of_creation":"Expedia","reservation_created_date":"2021-11-28 13:55:43","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"113.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339449","reservation_id":"126122","confirmation_number":"BP12568680782","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"37.65,45.83","nightly_discount":"0,0","subtotal":"83.48","grand_total":"94.33","paid_amount":"94.33","room_type_id":"298","product_id":"1133","siteminder_id":"EAN-1864230901","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":"134760","customer_id":"134760","source_of_creation":"Expedia","reservation_created_date":"2021-11-30 06:08:43","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"45.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339625","reservation_id":"126111","confirmation_number":"PB12344062168","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00","nightly_discount":"0.00","subtotal":"110.00","grand_total":"124.30","paid_amount":"124.30","room_type_id":"287","product_id":"1087","siteminder_id":"EAN-1864492221","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":"134775","customer_id":"134775","source_of_creation":"Expedia","reservation_created_date":"2021-12-01 03:32:03","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":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htl_taxable":[{"room_stay_id":"5339252","reservation_id":"126099","confirmation_number":"PB12334803684","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.62","nightly_discount":"0.00","subtotal":"101.62","grand_total":"114.83","paid_amount":"114.83","room_type_id":"289","product_id":"1101","siteminder_id":"HTL-1864446988","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":"134644","customer_id":"134644","source_of_creation":"Expedia","reservation_created_date":"2021-11-30 01:14:46","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":"101.62","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339401","reservation_id":"126147","confirmation_number":"BV12486322044","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"75.52,61.73","nightly_discount":"0,0","subtotal":"137.25","grand_total":"155.10","paid_amount":"155.10","room_type_id":"304","product_id":"1218","siteminder_id":"HTL-1864755408","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":"134558","customer_id":"134558","source_of_creation":"Expedia","reservation_created_date":"2021-11-30 18:55:07","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":"75.52","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120","departureCount":18,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5339415","reservation_id":"126002","confirmation_number":"BV12466729378","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"79.14","nightly_discount":"0","subtotal":"79.14","grand_total":"89.43","paid_amount":"89.43","room_type_id":"289","product_id":"1108","siteminder_id":"BDC-2274193343","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":"134753","customer_id":"134753","source_of_creation":"Booking.com","reservation_created_date":"2021-11-28 14:41:38","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"17.85","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"79.14","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":"5339906","reservation_id":"124958","confirmation_number":"PB12322570814","room_stay_from":"2021-11-26","room_stay_to":"2021-11-27","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"498.29","nightly_discount":"0","subtotal":"498.29","grand_total":"563.07","paid_amount":"540.46","room_type_id":"313","product_id":"1228","siteminder_id":"BDC-2205518272","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133102","customer_id":"133102","source_of_creation":"Booking.com","reservation_created_date":"2021-11-01 21:34:19","canceled_nights_data":"","product_name":"PB Walk","ota_service_fee_amount":"0","commision_charges":"155.49","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"-498.29","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"5337577","reservation_id":"110587","confirmation_number":"PB12391801686","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.62,84.62,84.62,84.62","nightly_discount":"0,0,0,0","subtotal":"338.48","grand_total":"382.48","paid_amount":"382.48","room_type_id":"289","product_id":"1094","siteminder_id":"EXP-1748888048","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":"134396","customer_id":"134396","source_of_creation":"Expedia","reservation_created_date":"2021-03-17 23:42:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"84.62","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":"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":"5339367","reservation_id":"120985","confirmation_number":"PB12382600093","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"72.53,72.53,72.53","nightly_discount":"0,0,0","subtotal":"217.59","grand_total":"245.88","paid_amount":"245.88","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1813840942","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":"134750","customer_id":"134750","source_of_creation":"Expedia","reservation_created_date":"2021-08-09 17:54:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"72.53","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":"5339469","reservation_id":"115554","confirmation_number":"PB12363197872","room_stay_from":"2021-11-30","room_stay_to":"2021-12-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"78.58,78.58,78.58,88.59,88.59","nightly_discount":"0,0,0,0,0","subtotal":"412.92","grand_total":"466.60","paid_amount":"466.60","room_type_id":"289","product_id":"1093","siteminder_id":"EXP-1773556598","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":"134767","customer_id":"134767","source_of_creation":"Expedia","reservation_created_date":"2021-05-20 16:35:11","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":"78.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339473","reservation_id":"115553","confirmation_number":"PB12391482666","room_stay_from":"2021-11-30","room_stay_to":"2021-12-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"78.58,78.58,78.58,88.59,88.59","nightly_discount":"0,0,0,0,0","subtotal":"412.92","grand_total":"466.60","paid_amount":"466.60","room_type_id":"289","product_id":"1121","siteminder_id":"EXP-1773556597","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":"134769","customer_id":"134769","source_of_creation":"Expedia","reservation_created_date":"2021-05-20 16:35:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"78.58","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339609","reservation_id":"126148","confirmation_number":"PB12329753641","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"63.23,77.68","nightly_discount":"0.00,0.00","subtotal":"140.91","grand_total":"159.22","paid_amount":"159.22","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1864765759","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":"134782","customer_id":"134782","source_of_creation":"Expedia","reservation_created_date":"2021-11-30 19:21:08","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"77.68","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339803","reservation_id":"120769","confirmation_number":"PB12321901869","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"124.9","nightly_discount":"0","subtotal":"124.90","grand_total":"141.13","paid_amount":"141.13","room_type_id":"289","product_id":"1095","siteminder_id":"EXP-1811920659","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134800","customer_id":"134800","source_of_creation":"Expedia","reservation_created_date":"2021-08-05 12:15:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"124.9","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":"5339902","reservation_id":"126179","confirmation_number":"BP12531631619","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"51.31","nightly_discount":"0","subtotal":"51.31","grand_total":"57.98","paid_amount":"57.98","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1865120647","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":"134819","customer_id":"134819","source_of_creation":"Expedia","reservation_created_date":"2021-12-01 16:09:19","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"51.31","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"5339023","reservation_id":"126030","confirmation_number":"PB12385798025","room_stay_from":"2021-11-29","room_stay_to":"2021-12-06","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"859.15","grand_total":"970.84","paid_amount":"970.84","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","group_rooms":null,"currentDayPrice":"110.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339308","reservation_id":"126013","confirmation_number":"PB12378836300","room_stay_from":"2021-12-01","room_stay_to":"2021-12-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.65,119.65,177.65,177.65","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"594.60","grand_total":"671.90","paid_amount":"671.90","room_type_id":"289","product_id":"1107","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134628","customer_id":"134628","source_of_creation":"FE","reservation_created_date":"2021-11-28 18:29:18","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"119.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3293157","reservation_id":"120463","confirmation_number":"PB12376905504","room_stay_from":"2021-11-28","room_stay_to":"2021-12-05","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1104.00","grand_total":"1247.52","paid_amount":"1247.52","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":"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":"5338372","reservation_id":"125942","confirmation_number":"PB12335681429","room_stay_from":"2021-11-27","room_stay_to":"2021-12-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.00,99.28,100.00,100.00,100.00,100.00,200.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"899.28","grand_total":"1016.19","paid_amount":"1016.19","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":"134538","customer_id":"134538","source_of_creation":"PMS","reservation_created_date":"2021-11-26 18:41:20","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"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":"5339080","reservation_id":"125787","confirmation_number":"PB12323129494","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.95,86.95,135.18,135.18","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"444.26","grand_total":"502.02","paid_amount":"502.02","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98071","customer_id":"98071","source_of_creation":"PMS","reservation_created_date":"2021-11-23 03:01:41","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"135.18","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339310","reservation_id":"126135","confirmation_number":"PB12396791322","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.00,90.00","nightly_discount":"0.00,0.00","subtotal":"181.00","grand_total":"204.53","paid_amount":"204.53","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":"134720","customer_id":"134720","source_of_creation":"PMS","reservation_created_date":"2021-11-30 15:19:49","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":"90.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339643","reservation_id":"126172","confirmation_number":"PB12323650834","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.00","nightly_discount":"0.00","subtotal":"64.00","grand_total":"72.32","paid_amount":"72.32","room_type_id":"289","product_id":"1110","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134704","customer_id":"134704","source_of_creation":"PMS","reservation_created_date":"2021-12-01 14:44:46","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","currentDayPrice":"64.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339691","reservation_id":"126087","confirmation_number":"PB12393928350","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00","nightly_discount":"0.00,0.00","subtotal":"260.00","grand_total":"293.80","paid_amount":"293.80","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":"134744","customer_id":"134744","source_of_creation":"PMS","reservation_created_date":"2021-12-01 16:33:32","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"130.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339860","reservation_id":"125750","confirmation_number":"PB12344773559","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,199.00","nightly_discount":"0.00,0.00","subtotal":"398.00","grand_total":"449.74","paid_amount":"449.74","room_type_id":"289","product_id":"1096","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":"134268","customer_id":"134268","source_of_creation":"PMS","reservation_created_date":"2021-11-22 15:37:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","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":"5339884","reservation_id":"126157","confirmation_number":"PB12341901637","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"104.76,118.37,118.37","nightly_discount":"0.00,0.00,0","subtotal":"341.50","grand_total":"385.90","paid_amount":"385.90","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":"134768","customer_id":"134768","source_of_creation":"PMS","reservation_created_date":"2021-11-30 22:05:29","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","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"118.37","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339891","reservation_id":"126007","confirmation_number":"PB12364022982","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"200.00,200.00","nightly_discount":"0.00,0.00","subtotal":"400.00","grand_total":"452.00","paid_amount":"452.00","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":"134600","customer_id":"134600","source_of_creation":"PMS","reservation_created_date":"2021-11-30 22:42:25","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":"200.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339743","reservation_id":"123599","confirmation_number":"PB12337331641","room_stay_from":"2021-12-12","room_stay_to":"2021-12-19","room_stay_status":"Active","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"171.00,171.00,171.00,171.00,171.00,211.00,211.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1277.00","grand_total":"1443.01","paid_amount":"281.09","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99977","customer_id":"99977","source_of_creation":"PMS","reservation_created_date":"2021-09-24 17:23:04","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":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5339024","reservation_id":"126030","confirmation_number":"PB12293494816","room_confirmation_number":"PB12385798025","room_stay_from":"2021-11-29","room_stay_to":"2021-12-06","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20","nightly_discount":"0,0,0,0,0,0,0","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"134656","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-11-29 19:26:20","reservation_modified_date_time":"2021-11-29 19:26:20","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","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":"5339801","reservation_id":"120769","confirmation_number":"PB12254073332","room_confirmation_number":"PB12321901869","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"134800","product_attribute_values":"extra_person# ","reservation_created_date":"2021-11-24 23:22:14","reservation_modified_date_time":"2021-12-01 18:31:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134800","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3293158","reservation_id":"120463","confirmation_number":"PB12244827763","room_confirmation_number":"PB12376905504","room_stay_from":"2021-11-28","room_stay_to":"2021-12-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"107164","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-07-31 13:41:04","reservation_modified_date_time":"2021-07-31 13:41:04","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":"5336849","reservation_id":"116592","confirmation_number":"PB12252831863","room_confirmation_number":"PB12396997296","room_stay_from":"2021-11-21","room_stay_to":"2021-12-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"228.00","grand_total":"257.64","paid_amount":"257.64","product_id":"1781","service_quantity":"1","customer_traveller_id":"91142","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-06-05 16:26:00","reservation_modified_date_time":"2021-11-21 21:20:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91142","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5337576","reservation_id":"110587","confirmation_number":"PB12230771194","room_confirmation_number":"PB12391801686","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"134396","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-03-17 23:42:08","reservation_modified_date_time":"2021-11-24 01:16:40","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134396","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":"5337935","reservation_id":"125855","confirmation_number":"PB12221672272","room_confirmation_number":"PB12322870111","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"134433","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-24 16:07:16","reservation_modified_date_time":"2021-11-24 23:23:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134433","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":"5338373","reservation_id":"125942","confirmation_number":"PB12251471065","room_confirmation_number":"PB12335681429","room_stay_from":"2021-11-27","room_stay_to":"2021-12-04","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"134538","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-26 18:41:20","reservation_modified_date_time":"2021-11-26 18:41:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134538","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":"5339025","reservation_id":"126030","confirmation_number":"PB12276206380","room_confirmation_number":"PB12385798025","room_stay_from":"2021-11-29","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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"134656","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-29 06:41:28","reservation_modified_date_time":"2021-11-29 19:26:20","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","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":"5339081","reservation_id":"125787","confirmation_number":"PB12267511805","room_confirmation_number":"PB12323129494","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","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":"98071","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-23 03:01:41","reservation_modified_date_time":"2021-11-29 21:24:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98071","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":"5339253","reservation_id":"126099","confirmation_number":"PB12262528988","room_confirmation_number":"PB12334803684","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134644","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 01:14:46","reservation_modified_date_time":"2021-11-30 07:07:01","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134644","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":"5339309","reservation_id":"126013","confirmation_number":"PB12231728402","room_confirmation_number":"PB12378836300","room_stay_from":"2021-12-01","room_stay_to":"2021-12-05","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":"134628","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-28 18:29:18","reservation_modified_date_time":"2021-11-30 15:17:27","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134628","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":"5339311","reservation_id":"126135","confirmation_number":"PB12222470129","room_confirmation_number":"PB12396791322","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","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":"134720","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-30 15:19:49","reservation_modified_date_time":"2021-11-30 15:19:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134720","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#","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":"5339366","reservation_id":"120985","confirmation_number":"PB12212337298","room_confirmation_number":"PB12382600093","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"134750","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-09 17:54:12","reservation_modified_date_time":"2021-11-30 18:36:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134750","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":"5339416","reservation_id":"126002","confirmation_number":"BV12295912734","room_confirmation_number":"BV12466729378","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","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":"134753","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-28 14:41:38","reservation_modified_date_time":"2021-11-30 19:18:03","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134753","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":"5339468","reservation_id":"115554","confirmation_number":"PB12210220844","room_confirmation_number":"PB12363197872","room_stay_from":"2021-11-30","room_stay_to":"2021-12-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"134767","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-20 16:35:11","reservation_modified_date_time":"2021-11-30 22:04:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134767","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":"5339472","reservation_id":"115553","confirmation_number":"PB12284284284","room_confirmation_number":"PB12391482666","room_stay_from":"2021-11-30","room_stay_to":"2021-12-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"134769","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-05-20 16:35:08","reservation_modified_date_time":"2021-11-30 22:12:58","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134769","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":"5339608","reservation_id":"126148","confirmation_number":"PB12214456804","room_confirmation_number":"PB12329753641","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","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":"134782","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 19:21:08","reservation_modified_date_time":"2021-12-01 03:15:41","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134782","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":"5339626","reservation_id":"126111","confirmation_number":"PB12296719311","room_confirmation_number":"PB12344062168","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","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":"134775","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-12-01 03:32:03","reservation_modified_date_time":"2021-12-01 03:32:36","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134775","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":"5339644","reservation_id":"126172","confirmation_number":"PB12235296248","room_confirmation_number":"PB12323650834","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","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":"134704","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-12-01 14:44:46","reservation_modified_date_time":"2021-12-01 14:44:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134704","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":"5339692","reservation_id":"126087","confirmation_number":"PB12252700771","room_confirmation_number":"PB12393928350","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134744","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-12-01 16:33:32","reservation_modified_date_time":"2021-12-01 16:33:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134744","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":"5339802","reservation_id":"120769","confirmation_number":"PB12277345903","room_confirmation_number":"PB12321901869","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134800","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-05 12:15:07","reservation_modified_date_time":"2021-12-01 18:31:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134800","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339861","reservation_id":"125750","confirmation_number":"PB12225808294","room_confirmation_number":"PB12344773559","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134268","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-22 15:37:55","reservation_modified_date_time":"2021-12-01 22:46:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134268","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":"5339885","reservation_id":"126157","confirmation_number":"PB12291436108","room_confirmation_number":"PB12341901637","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","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":"134768","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-30 22:05:29","reservation_modified_date_time":"2021-12-02 00:37:31","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134768","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":"5339890","reservation_id":"126007","confirmation_number":"PB12290803830","room_confirmation_number":"PB12364022982","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134600","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-30 22:42:25","reservation_modified_date_time":"2021-11-30 22:42:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134600","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":"5339901","reservation_id":"126179","confirmation_number":"BP12266568694","room_confirmation_number":"BP12531631619","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","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":"134819","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-12-01 16:09:19","reservation_modified_date_time":"2021-12-02 01:35:44","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134819","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":"5339695","reservation_id":"126138","confirmation_number":"PB12283769286","room_confirmation_number":"PB12328058314","room_stay_from":"2021-12-11","room_stay_to":"2021-12-12","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"134741","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 16:52:42","reservation_modified_date_time":"2021-12-01 16:47:23","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134741","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339742","reservation_id":"123599","confirmation_number":"PB12247815972","room_confirmation_number":"PB12337331641","room_stay_from":"2021-12-12","room_stay_to":"2021-12-19","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"99977","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-24 17:23:04","reservation_modified_date_time":"2021-12-01 17:20:38","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99977","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339907","reservation_id":"124958","confirmation_number":"PB12280241733","room_confirmation_number":"PB12322570814","room_stay_from":"2021-11-26","room_stay_to":"2021-11-27","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133102","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-01 21:34:19","reservation_modified_date_time":"2021-12-02 02:38:32","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133102","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"-20.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":"5339634","reservation_id":"125787","confirmation_number":"PB12278673759","room_confirmation_number":"PB12323129494","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":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-01 14:01:44","reservation_modified_date_time":"2021-12-01 14:01:44","customer_id":"98071","parentCustTravId":"98071","customer_traveller_id":"98071","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-29","sub_hotel_id":"123","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":"5339645","reservation_id":"116592","confirmation_number":"PB12265281066","room_confirmation_number":"PB12396997296","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.34","grand_total":"2.50","paid_amount":"2.50","product_id":"1205","service_quantity":"1","product_name":"Toothbrush","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-01 14:48:01","reservation_modified_date_time":"2021-12-01 14:48:01","customer_id":"91142","parentCustTravId":"91142","customer_traveller_id":"91142","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-21","sub_hotel_id":"123","currentDayPrice":"2.34","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5339693","reservation_id":"110587","confirmation_number":"PB12263356400","room_confirmation_number":"PB12391801686","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-01 16:44:25","reservation_modified_date_time":"2021-12-01 16:44:25","customer_id":"134396","parentCustTravId":"134396","customer_traveller_id":"134396","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-29","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":"5339816","reservation_id":"126087","confirmation_number":"PB12285491809","room_confirmation_number":"PB12393928350","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-01 19:20:48","reservation_modified_date_time":"2021-12-01 19:20:48","customer_id":"134744","parentCustTravId":"134744","customer_traveller_id":"134744","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-01","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":"5339903","reservation_id":"126179","confirmation_number":"PB12214693503","room_confirmation_number":"BP12531631619","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":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-02 01:35:57","reservation_modified_date_time":"2021-12-02 01:35:57","customer_id":"134819","parentCustTravId":"134819","customer_traveller_id":"134819","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-01","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":"5339682","reservation_id":"126178","confirmation_number":"PB12298297283","room_confirmation_number":"PB12335973090","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.27","grand_total":"3.50","paid_amount":"3.50","product_id":"1198","service_quantity":"1","product_name":"SunBlock \/ Tanning Oil","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-01 15:57:55","reservation_modified_date_time":"2021-12-01 15:57:55","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.27","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5339103","reservation_id":"125827","confirmation_number":"PB12216928390","room_confirmation_number":"PB12381420355","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-29 22:06:35","reservation_modified_date_time":"2021-11-29 22:06:35","customer_id":"45854","parentCustTravId":"45854","customer_traveller_id":"45854","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-01 22:22:11","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-28","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":"5339443","reservation_id":"126087","confirmation_number":"PB12225739072","room_confirmation_number":"PB12362606573","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-30 20:28:15","reservation_modified_date_time":"2021-11-30 20:28:15","customer_id":"134744","parentCustTravId":"134744","customer_traveller_id":"134744","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-01 19:20:42","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-11-29","sub_hotel_id":"123","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[{"room_stay_id":"5339877","reservation_id":"126007","confirmation_number":"PB12212957650","room_confirmation_number":"PB12364022982","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"25.00","paid_amount":"25.00","product_id":"1082","service_quantity":"1","product_name":"1pm c\/o","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-01 23:49:36","reservation_modified_date_time":"2021-12-01 23:49:36","customer_id":"134600","parentCustTravId":"134600","customer_traveller_id":"134600","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-01","sub_hotel_id":"123","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]},{"room_stay_id":"5339681","reservation_id":"126178","confirmation_number":"PB12211819046","room_confirmation_number":"PB12335973090","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"2.00","grand_total":"2.00","paid_amount":"2.00","product_id":"1197","service_quantity":"1","product_name":"Stamps","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-01 15:57:55","reservation_modified_date_time":"2021-12-01 15:57:55","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":"2.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"alcoholicDrinks":false,"taxes":[]}],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[],"ean_taxable":[{"room_stay_id":"5337934","reservation_id":"125855","confirmation_number":"PB12322870111","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"244.03,244.03","nightly_discount":"0,0","subtotal":"488.06","grand_total":"551.50","paid_amount":"551.50","room_type_id":"287","product_id":"1088","siteminder_id":"EAN-1862221230","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":"134433","customer_id":"134433","source_of_creation":"Expedia","reservation_created_date":"2021-11-24 16:07:16","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":"244.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":"5339625","reservation_id":"126111","confirmation_number":"PB12344062168","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"110.00","nightly_discount":"0.00","subtotal":"110.00","grand_total":"124.30","paid_amount":"124.30","room_type_id":"287","product_id":"1087","siteminder_id":"EAN-1864492221","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":"134775","customer_id":"134775","source_of_creation":"Expedia","reservation_created_date":"2021-12-01 03:32:03","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":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htl_taxable":[{"room_stay_id":"5339252","reservation_id":"126099","confirmation_number":"PB12334803684","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.62","nightly_discount":"0.00","subtotal":"101.62","grand_total":"114.83","paid_amount":"114.83","room_type_id":"289","product_id":"1101","siteminder_id":"HTL-1864446988","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":"134644","customer_id":"134644","source_of_creation":"Expedia","reservation_created_date":"2021-11-30 01:14:46","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":"101.62","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":3,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5339819","reservation_id":"126168","confirmation_number":"BV12426103359","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"79.14","nightly_discount":"0","subtotal":"79.14","grand_total":"89.43","paid_amount":"89.43","room_type_id":"307","product_id":"1224","siteminder_id":"BDC-2198602127","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":"134784","customer_id":"134804","source_of_creation":"Booking.com","reservation_created_date":"2021-12-01 06:20:50","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"17.85","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"79.14","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":"5338907","reservation_id":"119880","confirmation_number":"BV12422949988","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"69.64,69.64,69.64","nightly_discount":"0,0,0","subtotal":"208.92","grand_total":"236.08","paid_amount":"236.08","room_type_id":"304","product_id":"1220","siteminder_id":"EXP-1805378795","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":"133194","customer_id":"133194","source_of_creation":"Expedia","reservation_created_date":"2021-07-23 02:35:09","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"69.64","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":"5339505","reservation_id":"125852","confirmation_number":"BV12470780232","room_stay_from":"2021-12-01","room_stay_to":"2021-12-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.45,99.45,135.38","nightly_discount":"0,0,0","subtotal":"334.28","grand_total":"377.74","paid_amount":"377.74","room_type_id":"304","product_id":"1219","siteminder_id":"EXP-1862214104","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":"134774","customer_id":"134774","source_of_creation":"Expedia","reservation_created_date":"2021-11-24 15:50:07","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":"99.45","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"5338731","reservation_id":"125850","confirmation_number":"BV12452382605","room_stay_from":"2021-11-28","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.29,92.88,92.88,134.24","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"428.29","grand_total":"483.97","paid_amount":"483.97","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":"134428","customer_id":"134428","source_of_creation":"FE","reservation_created_date":"2021-11-24 14:47:39","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":"134.24","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339798","reservation_id":"126149","confirmation_number":"BV12428148532","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.94,113.94","nightly_discount":"0.00,0.00","subtotal":"227.88","grand_total":"257.50","paid_amount":"257.50","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":"134755","customer_id":"134755","source_of_creation":"FE","reservation_created_date":"2021-11-30 19:45:17","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","currentDayPrice":"113.94","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339874","reservation_id":"126193","confirmation_number":"BV12417409393","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.76","nightly_discount":"0.00","subtotal":"94.76","grand_total":"107.08","paid_amount":"107.08","room_type_id":"303","product_id":"1139","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134813","customer_id":"134813","source_of_creation":"FE","reservation_created_date":"2021-12-01 23:33:08","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"94.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5339639","reservation_id":"126060","confirmation_number":"BV12473283646","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"85.00,95.00,85.00,95.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"360.00","grand_total":"406.80","paid_amount":"406.80","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":"134675","customer_id":"134675","source_of_creation":"PMS","reservation_created_date":"2021-11-29 17:44:22","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"85.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5339439","reservation_id":"125999","confirmation_number":"BV12239646642","room_confirmation_number":"BV12483892008","room_stay_from":"2021-11-29","room_stay_to":"2021-12-02","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"134681","product_attribute_values":"extra_person# ","reservation_created_date":"2021-11-30 20:24:50","reservation_modified_date_time":"2021-11-30 20:24:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134681","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"124","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"5338732","reservation_id":"125850","confirmation_number":"BV12284632321","room_confirmation_number":"BV12452382605","room_stay_from":"2021-11-28","room_stay_to":"2021-12-02","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":"134428","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-24 14:47:39","reservation_modified_date_time":"2021-11-28 14:58:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134428","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":"5338908","reservation_id":"119880","confirmation_number":"BV12281138182","room_confirmation_number":"BV12422949988","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"133194","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-23 02:35:09","reservation_modified_date_time":"2021-11-29 15:01:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133194","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339399","reservation_id":"126147","confirmation_number":"BV12258331145","room_confirmation_number":"BV12486322044","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134558","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 18:55:07","reservation_modified_date_time":"2021-11-30 19:11:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134558","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339442","reservation_id":"125999","confirmation_number":"BV12277485631","room_confirmation_number":"BV12483892008","room_stay_from":"2021-11-29","room_stay_to":"2021-12-02","room_stay_status":"Active","nightly_price":"20,20,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"52.00","grand_total":"58.76","paid_amount":"58.76","product_id":"1781","service_quantity":"1","customer_traveller_id":"134681","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-28 13:55:43","reservation_modified_date_time":"2021-11-30 20:24:56","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134681","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.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":"5339504","reservation_id":"125852","confirmation_number":"BV12239713237","room_confirmation_number":"BV12470780232","room_stay_from":"2021-12-01","room_stay_to":"2021-12-04","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":"134774","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-24 15:50:07","reservation_modified_date_time":"2021-12-01 00:14:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134774","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339640","reservation_id":"126060","confirmation_number":"BV12267199785","room_confirmation_number":"BV12473283646","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","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":"134675","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-29 17:44:22","reservation_modified_date_time":"2021-12-01 14:23:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134675","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":"5339799","reservation_id":"126149","confirmation_number":"BV12243441959","room_confirmation_number":"BV12428148532","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134755","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-30 19:45:17","reservation_modified_date_time":"2021-12-01 18:23:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134755","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":"5339818","reservation_id":"126168","confirmation_number":"BV12211990821","room_confirmation_number":"BV12426103359","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","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":"134784","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-12-01 06:20:50","reservation_modified_date_time":"2021-12-01 20:10:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134804","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339875","reservation_id":"126193","confirmation_number":"BV12235003764","room_confirmation_number":"BV12417409393","room_stay_from":"2021-12-01","room_stay_to":"2021-12-02","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":"134813","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-12-01 23:33:08","reservation_modified_date_time":"2021-12-01 23:33:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134813","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":"5339637","reservation_id":"126060","confirmation_number":"BV12216592134","room_confirmation_number":"BV12473283646","room_stay_from":"2021-11-29","room_stay_to":"2021-12-03","room_stay_status":"Active","nightly_price":"45.00,45.00,45.00,45.00","nightly_discount":"0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-29 17:44:22","reservation_modified_date_time":"2021-12-01 14:23:30","customer_id":"134675","parentCustTravId":"134675","customer_traveller_id":"134675","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-29","sub_hotel_id":"124","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"45.00","currentDayDiscount":null,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5339679","reservation_id":"125850","confirmation_number":"BV12283183396","room_confirmation_number":"BV12452382605","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-01 15:57:34","reservation_modified_date_time":"2021-12-01 15:57:34","customer_id":"134428","parentCustTravId":"134428","customer_traveller_id":"134428","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-28","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":"5339800","reservation_id":"126149","confirmation_number":"BV12261284555","room_confirmation_number":"BV12428148532","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-12-01 18:24:10","reservation_modified_date_time":"2021-12-01 18:24:10","customer_id":"134755","parentCustTravId":"134755","customer_traveller_id":"134755","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-01","sub_hotel_id":"124","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5339876","reservation_id":"126193","confirmation_number":"BV12291813468","room_confirmation_number":"BV12417409393","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-01 23:36:10","reservation_modified_date_time":"2021-12-01 23:36:10","customer_id":"134813","parentCustTravId":"134813","customer_traveller_id":"134813","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-01","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"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[],"ean_taxable":[{"room_stay_id":"5339441","reservation_id":"125999","confirmation_number":"BV12483892008","room_stay_from":"2021-11-29","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"50.55,58.81,113.00","nightly_discount":"0.00,0.00,0.00","subtotal":"222.36","grand_total":"251.27","paid_amount":"251.27","room_type_id":"305","product_id":"1222","siteminder_id":"EAN-1863746419","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134681","customer_id":"134681","source_of_creation":"Expedia","reservation_created_date":"2021-11-28 13:55:43","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"113.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htl_taxable":[{"room_stay_id":"5339401","reservation_id":"126147","confirmation_number":"BV12486322044","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"75.52,61.73","nightly_discount":"0,0","subtotal":"137.25","grand_total":"155.10","paid_amount":"155.10","room_type_id":"304","product_id":"1218","siteminder_id":"HTL-1864755408","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":"134558","customer_id":"134558","source_of_creation":"Expedia","reservation_created_date":"2021-11-30 18:55:07","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":"75.52","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"}]}]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":3,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1124,1136","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BP12266616944","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","bundle_room":"0","product_id":"1124"},{"confirmation_number":"BP12217136296","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","bundle_room":"0","product_id":"1136"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5339065","reservation_id":"125898","confirmation_number":"BP12552690841","room_stay_from":"2021-11-29","room_stay_to":"2021-12-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"91.03,91.03,131.57,131.57,192.33,192.33","nightly_discount":"0,0,0,0,0,0","subtotal":"829.86","grand_total":"937.74","paid_amount":"937.74","room_type_id":"295","product_id":"1129","siteminder_id":"BDC-3217827895","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":"134689","customer_id":"134689","source_of_creation":"Booking.com","reservation_created_date":"2021-11-25 16:31:33","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","ota_service_fee_amount":"0","commision_charges":"170.97","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"131.57","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339828","reservation_id":"126176","confirmation_number":"BP12572290512","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.41,109.41","nightly_discount":"0,0","subtotal":"218.82","grand_total":"247.27","paid_amount":"247.27","room_type_id":"296","product_id":"1131","siteminder_id":"BDC-3883918817","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":"134805","customer_id":"134805","source_of_creation":"Booking.com","reservation_created_date":"2021-12-01 15:28:23","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"46.59","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"109.41","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":"5339307","reservation_id":"126130","confirmation_number":"BP12518068079","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"84.07,96.00","nightly_discount":"0,0","subtotal":"180.07","grand_total":"203.47","paid_amount":"203.47","room_type_id":"294","product_id":"1125","siteminder_id":"EXP-1864569283","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":"134497","customer_id":"134497","source_of_creation":"Expedia","reservation_created_date":"2021-11-30 07:44:44","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","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":"96.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339465","reservation_id":"125941","confirmation_number":"BP12578194710","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"47.26,71.94","nightly_discount":"0,0","subtotal":"119.20","grand_total":"134.69","paid_amount":"134.69","room_type_id":"300","product_id":"1135","siteminder_id":"EXP-1863087155","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":"134766","customer_id":"134766","source_of_creation":"Expedia","reservation_created_date":"2021-11-26 18:35:46","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 805","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":"71.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":"5339812","reservation_id":"126123","confirmation_number":"BP12559834781","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"45.83,45.83","nightly_discount":"0,0","subtotal":"91.66","grand_total":"103.58","paid_amount":"103.58","room_type_id":"295","product_id":"1128","siteminder_id":"EXP-1864147188","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":"134802","customer_id":"134802","source_of_creation":"Expedia","reservation_created_date":"2021-11-30 06:23:06","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","currentDayPrice":"45.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5339000","reservation_id":"120869","confirmation_number":"BP12552563671","room_stay_from":"2021-11-28","room_stay_to":"2021-12-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"50.59,50.59,50.59,50.59,50.59,59.02","nightly_discount":"0,0,0,0,0,0","subtotal":"311.97","grand_total":"352.53","paid_amount":"352.53","room_type_id":"294","product_id":"1127","siteminder_id":"GAM-R2717833349","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":"134678","customer_id":"134678","source_of_creation":"Getaroom.com","reservation_created_date":"2021-08-07 04:54:12","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 822","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":"50.59","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"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":"5339287","reservation_id":"126102","confirmation_number":"BP12513410324","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.21,101.87,101.87","nightly_discount":"0.00,0.00,0.00","subtotal":"292.95","grand_total":"331.04","paid_amount":"331.04","room_type_id":"294","product_id":"1126","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":"134709","customer_id":"134709","source_of_creation":"FE","reservation_created_date":"2021-11-30 01:50:46","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 806","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"101.87","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5338185","reservation_id":"125912","confirmation_number":"BP12563468012","room_stay_from":"2021-11-25","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"184.74,201.25,231.43,105.76,103.00,103.00,133.91","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,57.00","subtotal":"1063.09","grand_total":"1136.89","paid_amount":"1136.89","room_type_id":"296","product_id":"1130","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134516","customer_id":"134516","source_of_creation":"PMS","reservation_created_date":"2021-11-25 21:47:17","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 804","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":"133.91","currentDayDiscount":"57.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339604","reservation_id":"126165","confirmation_number":"BP12511192682","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.36,101.36","nightly_discount":"0.00,0.00","subtotal":"202.72","grand_total":"229.07","paid_amount":"229.07","room_type_id":"302","product_id":"1138","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"134780","customer_id":"134780","source_of_creation":"PMS","reservation_created_date":"2021-12-01 03:08:02","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"101.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"}]}],"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":"5338186","reservation_id":"125912","confirmation_number":"BP12288911852","room_confirmation_number":"BP12563468012","room_stay_from":"2021-11-25","room_stay_to":"2021-12-02","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"134516","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-25 21:47:17","reservation_modified_date_time":"2021-11-25 21:47:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134516","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":"5338999","reservation_id":"120869","confirmation_number":"BP12237621697","room_confirmation_number":"BP12552563671","room_stay_from":"2021-11-28","room_stay_to":"2021-12-04","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134678","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-08-07 04:54:12","reservation_modified_date_time":"2021-11-29 18:09:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134678","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5339062","reservation_id":"125898","confirmation_number":"BP12274114616","room_confirmation_number":"BP12552690841","room_stay_from":"2021-11-29","room_stay_to":"2021-12-05","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"134689","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-25 16:31:33","reservation_modified_date_time":"2021-11-29 20:47:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134689","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":"5339288","reservation_id":"126102","confirmation_number":"BP12284777927","room_confirmation_number":"BP12513410324","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","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":"134709","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-11-30 01:50:46","reservation_modified_date_time":"2021-11-30 13:11:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134709","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":"5339306","reservation_id":"126130","confirmation_number":"BP12244392818","room_confirmation_number":"BP12518068079","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","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":"134497","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 07:44:44","reservation_modified_date_time":"2021-11-30 14:57:23","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134497","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":"5339448","reservation_id":"126122","confirmation_number":"BP12287807404","room_confirmation_number":"BP12568680782","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","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":"134760","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 06:08:43","reservation_modified_date_time":"2021-11-30 20:58:48","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134760","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":"5339464","reservation_id":"125941","confirmation_number":"BP12222844930","room_confirmation_number":"BP12578194710","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","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":"134766","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-26 18:35:46","reservation_modified_date_time":"2021-11-30 22:01:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134766","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":"5339605","reservation_id":"126165","confirmation_number":"BP12243099732","room_confirmation_number":"BP12511192682","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","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":"134780","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-12-01 03:08:02","reservation_modified_date_time":"2021-12-01 03:08:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134780","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":"5339811","reservation_id":"126123","confirmation_number":"BP12281518587","room_confirmation_number":"BP12559834781","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134802","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-30 06:23:06","reservation_modified_date_time":"2021-12-01 18:41:15","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134802","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":"5339827","reservation_id":"126176","confirmation_number":"BP12216832700","room_confirmation_number":"BP12572290512","room_stay_from":"2021-12-01","room_stay_to":"2021-12-03","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":"134805","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-12-01 15:28:23","reservation_modified_date_time":"2021-12-01 20:54:32","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"134805","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5339063","reservation_id":"125898","confirmation_number":"BP12248970845","room_confirmation_number":"BP12552690841","room_stay_from":"2021-11-29","room_stay_to":"2021-12-05","room_stay_status":"Active","nightly_price":"45.00,45.00,45.00,45.00,45.00,45.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"270.00","grand_total":"305.10","paid_amount":"305.10","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-29 20:32:35","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":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-29","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":"5339177","reservation_id":"126102","confirmation_number":"BP12270096496","room_confirmation_number":"BP12513410324","room_stay_from":"2021-11-30","room_stay_to":"2021-12-03","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 01:50:46","reservation_modified_date_time":"2021-11-30 01:50:46","customer_id":"134709","parentCustTravId":"134709","customer_traveller_id":"134709","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-11-30","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"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[],"ean_taxable":[{"room_stay_id":"5339449","reservation_id":"126122","confirmation_number":"BP12568680782","room_stay_from":"2021-11-30","room_stay_to":"2021-12-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"37.65,45.83","nightly_discount":"0,0","subtotal":"83.48","grand_total":"94.33","paid_amount":"94.33","room_type_id":"298","product_id":"1133","siteminder_id":"EAN-1864230901","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":"134760","customer_id":"134760","source_of_creation":"Expedia","reservation_created_date":"2021-11-30 06:08:43","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"45.83","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htl_taxable":[]}}}