{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-05-03","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":39,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1113,1224,1109,1090,1225,1103,1099,1096,1098,1100,1116,1117,1220,1120,1084,1088,1129,1125","block_room_bookings":[{"confirmation_number":"PB12259026652","room_stay_from":"2020-04-30","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"BV12210826858","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12289923789","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12232114892","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"BV12247696731","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12233775955","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12254644972","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12280629318","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12274212324","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12236130995","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12211517231","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12280872883","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"BV12281937235","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12274711359","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12245105552","room_stay_from":"2020-05-02","room_stay_to":"2020-05-05","bundle_room":"0"},{"confirmation_number":"PB12262423464","room_stay_from":"2020-05-02","room_stay_to":"2020-05-05","bundle_room":"0"},{"confirmation_number":"BP12235114022","room_stay_from":"2020-05-01","room_stay_to":"2020-05-06","bundle_room":"0"},{"confirmation_number":"BP12251042630","room_stay_from":"2020-05-02","room_stay_to":"2020-05-06","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3090472","reservation_id":"94145","confirmation_number":"PB12357158727","room_stay_from":"2020-05-01","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.37,177.37,149.00","nightly_discount":"0.00,0.00,0.00","subtotal":"503.74","grand_total":"569.22","paid_amount":"569.22","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1661886401","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":"100549","customer_id":"100549","source_of_creation":"Expedia","reservation_created_date":"2020-04-25 18:51:06","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[{"room_stay_id":"3090890","reservation_id":"94264","confirmation_number":"PB12392025683","room_stay_from":"2020-05-03","room_stay_to":"2020-05-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00","nightly_discount":"0,0","subtotal":"178.00","grand_total":"201.14","paid_amount":"201.14","room_type_id":"289","product_id":"1093","siteminder_id":"HWR-302111656","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":"46174","customer_id":"46174","source_of_creation":"Hotwire","reservation_created_date":"2020-04-29 17:26:09","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":"","currentDayPrice":"89.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"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3090900","reservation_id":"94355","confirmation_number":"BP12537495419","room_stay_from":"2020-05-02","room_stay_to":"2020-05-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.83,104.94,104.94","nightly_discount":"0,0,0","subtotal":"379.71","grand_total":"429.07","paid_amount":"429.07","room_type_id":"301","product_id":"1136","siteminder_id":"AGO-317498602","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":"100582","customer_id":"100582","source_of_creation":"Agoda","reservation_created_date":"2020-05-02 19:16:11","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 807","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.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":"3090956","reservation_id":"94400","confirmation_number":"BP12594418989","room_stay_from":"2020-05-03","room_stay_to":"2020-05-06","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"85.87,85.87,85.87","nightly_discount":"0,0,0","subtotal":"257.61","grand_total":"291.10","paid_amount":"291.10","room_type_id":"299","product_id":"1134","siteminder_id":"AGO-317633894","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":"100615","customer_id":"100615","source_of_creation":"Agoda","reservation_created_date":"2020-05-03 23:46:09","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.87","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3090824","reservation_id":"94347","confirmation_number":"BP12563136275","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"129.00","nightly_discount":"0.00","subtotal":"129.00","grand_total":"145.77","paid_amount":"145.77","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100308","customer_id":"100308","source_of_creation":"FE","reservation_created_date":"2020-05-02 18:05:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090853","reservation_id":"94356","confirmation_number":"BV12412900576","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129.00","nightly_discount":"0.00","subtotal":"129.00","grand_total":"145.77","paid_amount":"145.77","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":"100577","customer_id":"100577","source_of_creation":"FE","reservation_created_date":"2020-05-02 20:10:10","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090677","reservation_id":"94154","confirmation_number":"BP12571412855","room_stay_from":"2020-05-02","room_stay_to":"2020-05-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,99.00,99.00","nightly_discount":"0.00,0.00,11.88","subtotal":"327.00","grand_total":"356.09","paid_amount":"356.09","room_type_id":"295","product_id":"1128","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":"100402","customer_id":"100402","source_of_creation":"FE","reservation_created_date":"2020-04-25 23:29:28","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":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3090304","reservation_id":"94313","confirmation_number":"BV12435475327","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,126.00","nightly_discount":"0.00,0.00","subtotal":"252.00","grand_total":"284.76","paid_amount":"284.76","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100557","customer_id":"100557","source_of_creation":"PMS","reservation_created_date":"2020-05-01 19:25:45","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090436","reservation_id":"94187","confirmation_number":"PB12367984089","room_stay_from":"2020-04-30","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,149.00,149.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"526.00","grand_total":"594.38","paid_amount":"594.38","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100437","customer_id":"100437","source_of_creation":"PMS","reservation_created_date":"2020-04-27 13:23:09","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":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090454","reservation_id":"94261","confirmation_number":"PB12341476300","room_stay_from":"2020-04-30","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,179.00,236.28,149.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"693.28","grand_total":"783.41","paid_amount":"783.41","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":"100502","customer_id":"100502","source_of_creation":"PMS","reservation_created_date":"2020-04-29 15:28:30","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":"","currentDayPrice":"149.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":"3090669","reservation_id":"94361","confirmation_number":"BV12490682180","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.80,129.00","nightly_discount":"0.00,7.87","subtotal":"319.80","grand_total":"352.49","paid_amount":"352.49","room_type_id":"309","product_id":"1226","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":"100583","customer_id":"100583","source_of_creation":"PMS","reservation_created_date":"2020-05-02 21:16:40","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"7.87","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090756","reservation_id":"94323","confirmation_number":"PB12310572418","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"119.00,119.00","nightly_discount":"0.00,0.00","subtotal":"238.00","grand_total":"268.94","paid_amount":"291.54","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":"100558","customer_id":"100558","source_of_creation":"PMS","reservation_created_date":"2020-05-01 23:02:42","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":"","currentDayPrice":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090778","reservation_id":"94332","confirmation_number":"BV12497812680","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"1","nightly_price":"161.00,99.00","nightly_discount":"0.00,0.00","subtotal":"260.00","grand_total":"293.80","paid_amount":"293.80","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":"100400","customer_id":"100400","source_of_creation":"PMS","reservation_created_date":"2020-05-02 15:22:37","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090789","reservation_id":"94229","confirmation_number":"PB12344950766","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"149.00,99.00","nightly_discount":"2.18,0.00","subtotal":"248.00","grand_total":"277.78","paid_amount":"277.78","room_type_id":"288","product_id":"1092","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100266","customer_id":"100266","source_of_creation":"PMS","reservation_created_date":"2020-04-28 17:49:38","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090803","reservation_id":"94353","confirmation_number":"PB12361810308","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00","nightly_discount":"0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100575","customer_id":"100575","source_of_creation":"PMS","reservation_created_date":"2020-05-02 18:43:30","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090893","reservation_id":"94331","confirmation_number":"BV12418760540","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.80,99.00","nightly_discount":"0.00,0.00","subtotal":"289.80","grand_total":"327.48","paid_amount":"327.48","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100564","customer_id":"100564","source_of_creation":"PMS","reservation_created_date":"2020-05-02 14:58:13","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090901","reservation_id":"94373","confirmation_number":"PB12392708281","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"129.00","nightly_discount":"0.00","subtotal":"129.00","grand_total":"145.77","paid_amount":"145.77","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100406","customer_id":"100406","source_of_creation":"PMS","reservation_created_date":"2020-05-03 14:09:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090952","reservation_id":"94399","confirmation_number":"PB12353689730","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.10","nightly_discount":"0.00","subtotal":"80.10","grand_total":"90.52","paid_amount":"90.52","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100614","customer_id":"100614","source_of_creation":"PMS","reservation_created_date":"2020-05-03 22:55:27","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"80.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090729","reservation_id":"94218","confirmation_number":"PB12384878498","room_stay_from":"2020-05-03","room_stay_to":"2020-05-05","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":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100386","customer_id":"100386","source_of_creation":"PMS","reservation_created_date":"2020-04-28 14:57:29","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3090754","reservation_id":"94219","confirmation_number":"PB12333059557","room_stay_from":"2020-05-03","room_stay_to":"2020-05-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"119.00,119.00","nightly_discount":"0.00,0.00","subtotal":"238.00","grand_total":"268.94","paid_amount":"268.94","room_type_id":"289","product_id":"1101","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100385","customer_id":"100385","source_of_creation":"PMS","reservation_created_date":"2020-04-28 14:59:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090491","reservation_id":"94339","confirmation_number":"BV12433000596","room_stay_from":"2020-05-03","room_stay_to":"2020-05-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00","subtotal":"297.00","grand_total":"335.61","paid_amount":"335.61","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":"47798","customer_id":"47798","source_of_creation":"PMS","reservation_created_date":"2020-05-02 16:27:53","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":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090847","reservation_id":"94300","confirmation_number":"PB12331557837","room_stay_from":"2020-05-03","room_stay_to":"2020-05-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.75,118.75,118.75,118.75","nightly_discount":"0.00,0.00,0.00,20.18","subtotal":"475.00","grand_total":"513.95","paid_amount":"513.95","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100539","customer_id":"100539","source_of_creation":"PMS","reservation_created_date":"2020-05-01 01:51:17","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":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":"118.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090967","reservation_id":"94362","confirmation_number":"BP12536970932","room_stay_from":"2020-05-03","room_stay_to":"2020-05-07","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"516.00","grand_total":"583.08","paid_amount":"583.08","room_type_id":"297","product_id":"1132","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100585","customer_id":"100585","source_of_creation":"PMS","reservation_created_date":"2020-05-02 21:31:47","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 826","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090810","reservation_id":"94255","confirmation_number":"PB12321030477","room_stay_from":"2020-05-03","room_stay_to":"2020-05-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,29.09","subtotal":"645.00","grand_total":"695.97","paid_amount":"695.97","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100496","customer_id":"100496","source_of_creation":"PMS","reservation_created_date":"2020-04-29 13:16:19","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090235","reservation_id":"93659","confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00,99.00,89.00,89.00,89.00,89.00,89.00,99.00,109.00,99.00,99.00,99.00,99.00,99.00,109.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,69.26,5.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00,0.00,0.00,0.00,0.00,0.00,0.00,42.00,0.00,0.00,0.00,0.00,0.00,0.00,39.85","subtotal":"3295.00","grand_total":"3501.74","paid_amount":"3501.74","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76889","customer_id":"76889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 17:57:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090646","reservation_id":"94268","confirmation_number":"PB12332556119","room_stay_from":"2020-05-02","room_stay_to":"2020-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"174.00,129.00,129.00,129.00,129.00,129.00,159.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"978.00","grand_total":"1105.14","paid_amount":"1105.14","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99977","customer_id":"99977","source_of_creation":"PMS","reservation_created_date":"2020-04-29 18:37:51","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090594","reservation_id":"94357","confirmation_number":"BV12448543332","room_stay_from":"2020-05-02","room_stay_to":"2020-05-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"890.00","grand_total":"1005.70","paid_amount":"1005.70","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76151","customer_id":"76151","source_of_creation":"PMS","reservation_created_date":"2020-05-02 20:22:53","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":"","currentDayPrice":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090148","reservation_id":"93881","confirmation_number":"PB12347631567","room_stay_from":"2020-04-30","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.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,78.39","subtotal":"1485.00","grand_total":"1589.47","paid_amount":"1011.87","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":"100118","customer_id":"100118","source_of_creation":"PMS","reservation_created_date":"2020-04-16 19:41:23","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":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090960","reservation_id":"94275","confirmation_number":"PB12399302445","room_stay_from":"2020-05-07","room_stay_to":"2020-05-09","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,129.00","nightly_discount":"0.00,0.00","subtotal":"248.00","grand_total":"280.24","paid_amount":"145.77","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100516","customer_id":"100516","source_of_creation":"PMS","reservation_created_date":"2020-04-29 23:21:35","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090849","reservation_id":"79457","confirmation_number":"PB12359188803","room_stay_from":"2020-08-04","room_stay_to":"2020-08-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2394.00","grand_total":"2705.22","paid_amount":"188.71","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"71131","customer_id":"71131","source_of_creation":"PMS","reservation_created_date":"2019-06-23 16:27:41","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":"","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":"3090817","reservation_id":"94272","confirmation_number":"PB12329568231","room_stay_from":"2020-05-01","room_stay_to":"2020-05-03","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"159.00,174.00","nightly_discount":"0.00,20.54","subtotal":"333.00","grand_total":"353.08","paid_amount":"353.08","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":"100512","customer_id":"100512","source_of_creation":"PMS","reservation_created_date":"2020-04-29 21:18:57","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":"","changedComment":"Nightly price or discount changed","deltaChange":"-0.01","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":"3090875","reservation_id":"94277","confirmation_number":"PB12359672276","room_stay_from":"2020-05-01","room_stay_to":"2020-05-03","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"159.00,174.00","nightly_discount":"0.00,20.01","subtotal":"333.00","grand_total":"353.68","paid_amount":"353.68","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"58370","customer_id":"58370","source_of_creation":"PMS","reservation_created_date":"2020-04-29 23:50:38","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"-0.01","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":"3090851","reservation_id":"79459","confirmation_number":"PB12325318718","room_stay_from":"2020-08-04","room_stay_to":"2020-08-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2394.00","grand_total":"2705.22","paid_amount":"188.71","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"71132","customer_id":"71132","source_of_creation":"PMS","reservation_created_date":"2019-06-23 16:30:56","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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":"3090905","reservation_id":"92054","confirmation_number":"BP12578243247","room_stay_from":"2020-10-10","room_stay_to":"2020-10-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,94.00,94.00,94.00,94.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"490.00","grand_total":"553.70","paid_amount":"224.87","room_type_id":"293","product_id":"1124","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84844","customer_id":"84844","source_of_creation":"PMS","reservation_created_date":"2020-02-16 17:48:04","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3090757","reservation_id":"94323","confirmation_number":"PB12227501209","room_confirmation_number":"PB12310572418","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"0.00,20.00","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100558","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-05-02 23:46:54","reservation_modified_date_time":"2020-05-03 12:49:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100558","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"-20.00","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":"3090779","reservation_id":"94332","confirmation_number":"BV12211184832","room_confirmation_number":"BV12497812680","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"40.00,20.00","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"100400","product_attribute_values":"extra_person# ","reservation_created_date":"2020-05-03 14:17:06","reservation_modified_date_time":"2020-05-03 14:17:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100400","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"40.00","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":"3090787","reservation_id":"94229","confirmation_number":"PB12270473634","room_confirmation_number":"PB12344950766","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"30,30","nightly_discount":"0.00,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"100266","product_attribute_values":"extra_person# ","reservation_created_date":"2020-05-03 14:33:40","reservation_modified_date_time":"2020-05-03 14:33:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100266","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"30.00","currentDayPrice":"30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090826","reservation_id":"94347","confirmation_number":"PB12210286805","room_confirmation_number":"BP12563136275","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"100308","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-05-03 16:24:55","reservation_modified_date_time":"2020-05-03 16:24:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100308","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090855","reservation_id":"94356","confirmation_number":"PB12249697380","room_confirmation_number":"BV12412900576","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100577","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-05-03 17:32:10","reservation_modified_date_time":"2020-05-03 17:32:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100577","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090902","reservation_id":"94373","confirmation_number":"PB12254070606","room_confirmation_number":"PB12392708281","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100406","product_attribute_values":"extra_person# ","reservation_created_date":"2020-05-03 20:22:43","reservation_modified_date_time":"2020-05-03 20:22:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100406","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090657","reservation_id":"94362","confirmation_number":"BP12243792006","room_confirmation_number":"BP12536970932","room_stay_from":"2020-05-03","room_stay_to":"2020-05-07","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"100585","product_attribute_values":"extra_person# ","reservation_created_date":"2020-05-02 22:37:05","reservation_modified_date_time":"2020-05-02 22:37:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100585","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090648","reservation_id":"94268","confirmation_number":"PB12261500315","room_confirmation_number":"PB12332556119","room_stay_from":"2020-05-02","room_stay_to":"2020-05-09","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"99977","product_attribute_values":"extra_person# ","reservation_created_date":"2020-05-02 21:49:22","reservation_modified_date_time":"2020-05-02 21:49:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99977","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3090303","reservation_id":"94313","confirmation_number":"BV12251337946","room_confirmation_number":"BV12435475327","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","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":"100557","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-01 19:25:45","reservation_modified_date_time":"2020-05-01 21:56:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100557","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090437","reservation_id":"94187","confirmation_number":"PB12233724555","room_confirmation_number":"PB12367984089","room_stay_from":"2020-04-30","room_stay_to":"2020-05-04","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":"100437","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-27 13:23:09","reservation_modified_date_time":"2020-05-02 13:46:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100437","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090455","reservation_id":"94261","confirmation_number":"PB12299536916","room_confirmation_number":"PB12341476300","room_stay_from":"2020-04-30","room_stay_to":"2020-05-04","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":"100502","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-29 15:28:30","reservation_modified_date_time":"2020-05-02 15:18:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100502","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090471","reservation_id":"94145","confirmation_number":"PB12238722601","room_confirmation_number":"PB12357158727","room_stay_from":"2020-05-01","room_stay_to":"2020-05-04","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":"100549","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-04-25 18:51:06","reservation_modified_date_time":"2020-05-02 15:33:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100549","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090670","reservation_id":"94361","confirmation_number":"BV12216683051","room_confirmation_number":"BV12490682180","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","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":"100583","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 21:16:40","reservation_modified_date_time":"2020-05-02 22:54:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100583","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090758","reservation_id":"94323","confirmation_number":"PB12227067401","room_confirmation_number":"PB12310572418","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","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":"100558","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-01 23:02:42","reservation_modified_date_time":"2020-05-03 12:49:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100558","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090780","reservation_id":"94332","confirmation_number":"BV12243617375","room_confirmation_number":"BV12497812680","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","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":"100400","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 15:22:37","reservation_modified_date_time":"2020-05-03 14:17:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100400","canceled_nights_data":"","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":"3090790","reservation_id":"94229","confirmation_number":"PB12222077426","room_confirmation_number":"PB12344950766","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","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":"100266","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-28 17:49:38","reservation_modified_date_time":"2020-05-03 14:34:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100266","canceled_nights_data":"","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":"3090804","reservation_id":"94353","confirmation_number":"PB12289416339","room_confirmation_number":"PB12361810308","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","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":"100575","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 18:43:30","reservation_modified_date_time":"2020-05-03 15:30:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100575","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090827","reservation_id":"94347","confirmation_number":"BP12250978960","room_confirmation_number":"BP12563136275","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","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":"100308","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 18:05:14","reservation_modified_date_time":"2020-05-03 16:24:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100308","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090856","reservation_id":"94356","confirmation_number":"BV12279195080","room_confirmation_number":"BV12412900576","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","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":"100577","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 20:10:10","reservation_modified_date_time":"2020-05-03 17:32:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100577","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090894","reservation_id":"94331","confirmation_number":"BV12214635961","room_confirmation_number":"BV12418760540","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","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":"100564","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 14:58:13","reservation_modified_date_time":"2020-05-03 19:49:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100564","canceled_nights_data":"","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":"3090903","reservation_id":"94373","confirmation_number":"PB12279962076","room_confirmation_number":"PB12392708281","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","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":"100406","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-03 14:09:13","reservation_modified_date_time":"2020-05-03 20:22:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100406","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090951","reservation_id":"94399","confirmation_number":"PB12270794589","room_confirmation_number":"PB12353689730","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100614","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-03 22:55:27","reservation_modified_date_time":"2020-05-03 23:09:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100614","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090678","reservation_id":"94154","confirmation_number":"BP12293994837","room_confirmation_number":"BP12571412855","room_stay_from":"2020-05-02","room_stay_to":"2020-05-05","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":"100402","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-25 23:29:28","reservation_modified_date_time":"2020-05-02 23:18:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100402","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090730","reservation_id":"94218","confirmation_number":"PB12259688159","room_confirmation_number":"PB12384878498","room_stay_from":"2020-05-03","room_stay_to":"2020-05-05","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":"100386","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-28 14:57:29","reservation_modified_date_time":"2020-05-03 00:47:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100386","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090755","reservation_id":"94219","confirmation_number":"PB12285255489","room_confirmation_number":"PB12333059557","room_stay_from":"2020-05-03","room_stay_to":"2020-05-05","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":"100385","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-28 14:59:42","reservation_modified_date_time":"2020-05-03 12:20:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100385","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090888","reservation_id":"94264","confirmation_number":"PB12283691018","room_confirmation_number":"PB12392025683","room_stay_from":"2020-05-03","room_stay_to":"2020-05-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"46174","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-04-29 17:26:09","reservation_modified_date_time":"2020-05-03 19:38:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"46174","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090899","reservation_id":"94355","confirmation_number":"BP12265199200","room_confirmation_number":"BP12537495419","room_stay_from":"2020-05-02","room_stay_to":"2020-05-05","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":"100582","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-02 19:16:11","reservation_modified_date_time":"2020-05-03 20:15:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100582","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090492","reservation_id":"94339","confirmation_number":"BV12226769381","room_confirmation_number":"BV12433000596","room_stay_from":"2020-05-03","room_stay_to":"2020-05-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"47798","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 16:27:53","reservation_modified_date_time":"2020-05-02 16:27:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090957","reservation_id":"94400","confirmation_number":"BP12266350277","room_confirmation_number":"BP12594418989","room_stay_from":"2020-05-03","room_stay_to":"2020-05-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100615","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-03 23:46:09","reservation_modified_date_time":"2020-05-03 23:46:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100615","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090848","reservation_id":"94300","confirmation_number":"PB12261388506","room_confirmation_number":"PB12331557837","room_stay_from":"2020-05-03","room_stay_to":"2020-05-07","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":"100539","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-01 01:51:17","reservation_modified_date_time":"2020-05-03 17:21:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100539","canceled_nights_data":"","changedComment":"From 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":"3090969","reservation_id":"94362","confirmation_number":"BP12241614071","room_confirmation_number":"BP12536970932","room_stay_from":"2020-05-03","room_stay_to":"2020-05-07","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":"100585","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 21:31:47","reservation_modified_date_time":"2020-05-04 00:23:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100585","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090811","reservation_id":"94255","confirmation_number":"PB12280750251","room_confirmation_number":"PB12321030477","room_stay_from":"2020-05-03","room_stay_to":"2020-05-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"100496","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-29 13:16:19","reservation_modified_date_time":"2020-05-03 15:44:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100496","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090236","reservation_id":"93659","confirmation_number":"PB12259744424","room_confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"420.00","grand_total":"474.60","paid_amount":"474.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"76889","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-03-30 17:57:33","reservation_modified_date_time":"2020-05-01 18:02:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76889","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090649","reservation_id":"94268","confirmation_number":"PB12257032290","room_confirmation_number":"PB12332556119","room_stay_from":"2020-05-02","room_stay_to":"2020-05-09","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":"99977","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-29 18:37:51","reservation_modified_date_time":"2020-05-02 21:49:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99977","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090595","reservation_id":"94357","confirmation_number":"BV12259448950","room_confirmation_number":"BV12448543332","room_stay_from":"2020-05-02","room_stay_to":"2020-05-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"76151","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 20:22:53","reservation_modified_date_time":"2020-05-02 20:22:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76151","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090149","reservation_id":"93881","confirmation_number":"PB12234805093","room_confirmation_number":"PB12347631567","room_stay_from":"2020-04-30","room_stay_to":"2020-05-15","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","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","subtotal":"180.00","grand_total":"203.40","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100118","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-16 19:41:23","reservation_modified_date_time":"2020-05-01 00:57:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100118","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090961","reservation_id":"94275","confirmation_number":"PB12284744450","room_confirmation_number":"PB12399302445","room_stay_from":"2020-05-07","room_stay_to":"2020-05-09","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100516","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-29 23:21:35","reservation_modified_date_time":"2020-05-03 23:56:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100516","canceled_nights_data":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090850","reservation_id":"79457","confirmation_number":"PB12255143071","room_confirmation_number":"PB12359188803","room_stay_from":"2020-08-04","room_stay_to":"2020-08-25","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"71131","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-23 16:27:41","reservation_modified_date_time":"2020-05-03 17:28:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71131","canceled_nights_data":"","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":"3090852","reservation_id":"79459","confirmation_number":"PB12244534835","room_confirmation_number":"PB12325318718","room_stay_from":"2020-08-04","room_stay_to":"2020-08-25","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"71132","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-23 16:30:56","reservation_modified_date_time":"2020-05-03 17:29:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71132","canceled_nights_data":"","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":"3090906","reservation_id":"92054","confirmation_number":"BP12273510009","room_confirmation_number":"BP12578243247","room_stay_from":"2020-10-10","room_stay_to":"2020-10-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"84844","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-02-16 17:48:04","reservation_modified_date_time":"2020-05-03 20:28:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84844","canceled_nights_data":"","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3090643","reservation_id":"94362","confirmation_number":"BP12227616766","room_confirmation_number":"BP12536970932","room_stay_from":"2020-05-03","room_stay_to":"2020-05-07","room_stay_status":"Active","nightly_price":"30.00,30.00,30.00,30.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-02 21:31:47","reservation_modified_date_time":"2020-05-02 21:31:47","customer_id":"100585","parentCustTravId":"100585","customer_traveller_id":"100585","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090768","reservation_id":"94273","confirmation_number":"PB12248786756","room_confirmation_number":"PB12384394774","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"69.00","grand_total":"77.97","paid_amount":"77.97","product_id":"1142","service_quantity":"1","product_name":"1\/2 Day till 6pm","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 13:46:48","reservation_modified_date_time":"2020-05-03 13:46:48","customer_id":"100514","parentCustTravId":"100514","customer_traveller_id":"100514","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","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090793","reservation_id":"93925","confirmation_number":"PB12275832045","room_confirmation_number":"PB12399221589","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:14:03","reservation_modified_date_time":"2020-05-03 15:14:03","customer_id":"100165","parentCustTravId":"100165","customer_traveller_id":"100165","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","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090795","reservation_id":"94048","confirmation_number":"PB12214015233","room_confirmation_number":"PB12376782326","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:16:30","reservation_modified_date_time":"2020-05-03 15:16:30","customer_id":"100291","parentCustTravId":"100291","customer_traveller_id":"100291","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","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090797","reservation_id":"94267","confirmation_number":"BV12216990271","room_confirmation_number":"BV12488890659","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"69.00","grand_total":"77.97","paid_amount":"77.97","product_id":"1142","service_quantity":"1","product_name":"1\/2 Day till 6pm","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:22:24","reservation_modified_date_time":"2020-05-03 15:22:24","customer_id":"100507","parentCustTravId":"100507","customer_traveller_id":"100507","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","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090814","reservation_id":"94261","confirmation_number":"PB12275603437","room_confirmation_number":"PB12341476300","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":"28.25","paid_amount":"28.25","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:48:22","reservation_modified_date_time":"2020-05-03 15:48:22","customer_id":"100502","parentCustTravId":"100502","customer_traveller_id":"100502","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090889","reservation_id":"94264","confirmation_number":"PB12266009936","room_confirmation_number":"PB12392025683","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.67","grand_total":"14.99","paid_amount":"15.00","product_id":"2009","service_quantity":"3","product_name":"Hourly Parking","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 19:10:28","reservation_modified_date_time":"2020-05-03 19:38:22","customer_id":"46174","parentCustTravId":"46174","customer_traveller_id":"46174","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"14.01","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3090904","reservation_id":"94373","confirmation_number":"PB12267171684","room_confirmation_number":"PB12392708281","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":"28.25","paid_amount":"28.25","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 20:24:59","reservation_modified_date_time":"2020-05-03 20:24:59","customer_id":"100406","parentCustTravId":"100406","customer_traveller_id":"100406","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090917","reservation_id":"94229","confirmation_number":"PB12230310781","room_confirmation_number":"PB12344950766","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":"28.25","paid_amount":"28.25","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 21:16:10","reservation_modified_date_time":"2020-05-03 21:16:10","customer_id":"100266","parentCustTravId":"100266","customer_traveller_id":"100266","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090950","reservation_id":"94399","confirmation_number":"PB12237593280","room_confirmation_number":"PB12353689730","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 23:01:47","reservation_modified_date_time":"2020-05-03 23:09:08","customer_id":"100614","parentCustTravId":"100614","customer_traveller_id":"100614","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090965","reservation_id":"94297","confirmation_number":"PB12288917852","room_confirmation_number":"PB12353563213","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"69.00","grand_total":"77.97","paid_amount":"77.97","product_id":"1142","service_quantity":"1","product_name":"1\/2 Day till 6pm","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 14:07:33","reservation_modified_date_time":"2020-05-04 00:21:08","customer_id":"100616","parentCustTravId":"100616","customer_traveller_id":"100616","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","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090968","reservation_id":"94362","confirmation_number":"BP12238924138","room_confirmation_number":"BP12536970932","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":"28.25","paid_amount":"28.25","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-04 00:13:29","reservation_modified_date_time":"2020-05-04 00:23:18","customer_id":"100585","parentCustTravId":"100585","customer_traveller_id":"100585","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090970","reservation_id":"94261","confirmation_number":"PB12238620715","room_confirmation_number":"PB12341476300","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.21","grand_total":"4.50","paid_amount":"4.50","product_id":"1144","service_quantity":"1","product_name":"Aloe Lotion\/ Gel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-04 01:18:45","reservation_modified_date_time":"2020-05-04 01:18:45","customer_id":"100502","parentCustTravId":"100502","customer_traveller_id":"100502","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"4.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3090799","reservation_id":"94377","confirmation_number":"PB12226502770","room_confirmation_number":"PB12369935998","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.74","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"2","product_name":"Koolies","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:24:15","reservation_modified_date_time":"2020-05-03 15:24:15","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3090808","reservation_id":"94378","confirmation_number":"PB12240043314","room_confirmation_number":"PB12366272767","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":"22.60","paid_amount":"22.60","product_id":null,"service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:31:28","reservation_modified_date_time":"2020-05-03 15:31:28","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,"currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090809","reservation_id":"94378","confirmation_number":"PB12292674522","room_confirmation_number":"PB12366272767","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":"28.25","paid_amount":"28.25","product_id":null,"service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:31:28","reservation_modified_date_time":"2020-05-03 15:31:28","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,"currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090813","reservation_id":"94379","confirmation_number":"PB12261472611","room_confirmation_number":"PB12374657856","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":"22.60","paid_amount":"22.60","product_id":null,"service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:47:43","reservation_modified_date_time":"2020-05-03 15:47:43","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090829","reservation_id":"94382","confirmation_number":"PB12216093521","room_confirmation_number":"PB12327579878","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"3","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 16:28:57","reservation_modified_date_time":"2020-05-03 16:28:57","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,"currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3090861","reservation_id":"94385","confirmation_number":"PB12247387347","room_confirmation_number":"PB12357002943","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":null,"service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 17:44:17","reservation_modified_date_time":"2020-05-03 17:44:17","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,"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":"3090862","reservation_id":"94385","confirmation_number":"PB12261757324","room_confirmation_number":"PB12357002943","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":"28.25","paid_amount":"28.25","product_id":null,"service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 17:44:17","reservation_modified_date_time":"2020-05-03 17:44:17","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,"currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"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":29,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1113,1109,1090,1103,1099,1096,1098,1100,1116,1117,1120,1084,1088","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12259026652","room_stay_from":"2020-04-30","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12289923789","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12232114892","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12233775955","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12254644972","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12280629318","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12274212324","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12236130995","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12211517231","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12280872883","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12274711359","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"PB12245105552","room_stay_from":"2020-05-02","room_stay_to":"2020-05-05","bundle_room":"0"},{"confirmation_number":"PB12262423464","room_stay_from":"2020-05-02","room_stay_to":"2020-05-05","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3090472","reservation_id":"94145","confirmation_number":"PB12357158727","room_stay_from":"2020-05-01","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.37,177.37,149.00","nightly_discount":"0.00,0.00,0.00","subtotal":"503.74","grand_total":"569.22","paid_amount":"569.22","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1661886401","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":"100549","customer_id":"100549","source_of_creation":"Expedia","reservation_created_date":"2020-04-25 18:51:06","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"149.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[{"room_stay_id":"3090890","reservation_id":"94264","confirmation_number":"PB12392025683","room_stay_from":"2020-05-03","room_stay_to":"2020-05-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00","nightly_discount":"0,0","subtotal":"178.00","grand_total":"201.14","paid_amount":"201.14","room_type_id":"289","product_id":"1093","siteminder_id":"HWR-302111656","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":"46174","customer_id":"46174","source_of_creation":"Hotwire","reservation_created_date":"2020-04-29 17:26:09","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":"","currentDayPrice":"89.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"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3090436","reservation_id":"94187","confirmation_number":"PB12367984089","room_stay_from":"2020-04-30","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,149.00,149.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"526.00","grand_total":"594.38","paid_amount":"594.38","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100437","customer_id":"100437","source_of_creation":"PMS","reservation_created_date":"2020-04-27 13:23:09","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":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090454","reservation_id":"94261","confirmation_number":"PB12341476300","room_stay_from":"2020-04-30","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,179.00,236.28,149.00","nightly_discount":"0.00,0.00,0.00,0","subtotal":"693.28","grand_total":"783.41","paid_amount":"783.41","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":"100502","customer_id":"100502","source_of_creation":"PMS","reservation_created_date":"2020-04-29 15:28:30","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":"","currentDayPrice":"149.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":"3090756","reservation_id":"94323","confirmation_number":"PB12310572418","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"119.00,119.00","nightly_discount":"0.00,0.00","subtotal":"238.00","grand_total":"268.94","paid_amount":"291.54","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":"100558","customer_id":"100558","source_of_creation":"PMS","reservation_created_date":"2020-05-01 23:02:42","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":"","currentDayPrice":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090789","reservation_id":"94229","confirmation_number":"PB12344950766","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"2","nightly_price":"149.00,99.00","nightly_discount":"2.18,0.00","subtotal":"248.00","grand_total":"277.78","paid_amount":"277.78","room_type_id":"288","product_id":"1092","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100266","customer_id":"100266","source_of_creation":"PMS","reservation_created_date":"2020-04-28 17:49:38","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090803","reservation_id":"94353","confirmation_number":"PB12361810308","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00","nightly_discount":"0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100575","customer_id":"100575","source_of_creation":"PMS","reservation_created_date":"2020-05-02 18:43:30","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090901","reservation_id":"94373","confirmation_number":"PB12392708281","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"129.00","nightly_discount":"0.00","subtotal":"129.00","grand_total":"145.77","paid_amount":"145.77","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100406","customer_id":"100406","source_of_creation":"PMS","reservation_created_date":"2020-05-03 14:09:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090952","reservation_id":"94399","confirmation_number":"PB12353689730","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.10","nightly_discount":"0.00","subtotal":"80.10","grand_total":"90.52","paid_amount":"90.52","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100614","customer_id":"100614","source_of_creation":"PMS","reservation_created_date":"2020-05-03 22:55:27","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"80.10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090729","reservation_id":"94218","confirmation_number":"PB12384878498","room_stay_from":"2020-05-03","room_stay_to":"2020-05-05","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":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100386","customer_id":"100386","source_of_creation":"PMS","reservation_created_date":"2020-04-28 14:57:29","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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":"3090754","reservation_id":"94219","confirmation_number":"PB12333059557","room_stay_from":"2020-05-03","room_stay_to":"2020-05-05","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"119.00,119.00","nightly_discount":"0.00,0.00","subtotal":"238.00","grand_total":"268.94","paid_amount":"268.94","room_type_id":"289","product_id":"1101","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100385","customer_id":"100385","source_of_creation":"PMS","reservation_created_date":"2020-04-28 14:59:42","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090847","reservation_id":"94300","confirmation_number":"PB12331557837","room_stay_from":"2020-05-03","room_stay_to":"2020-05-07","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.75,118.75,118.75,118.75","nightly_discount":"0.00,0.00,0.00,20.18","subtotal":"475.00","grand_total":"513.95","paid_amount":"513.95","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100539","customer_id":"100539","source_of_creation":"PMS","reservation_created_date":"2020-05-01 01:51:17","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":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":"118.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090810","reservation_id":"94255","confirmation_number":"PB12321030477","room_stay_from":"2020-05-03","room_stay_to":"2020-05-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,29.09","subtotal":"645.00","grand_total":"695.97","paid_amount":"695.97","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100496","customer_id":"100496","source_of_creation":"PMS","reservation_created_date":"2020-04-29 13:16:19","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090235","reservation_id":"93659","confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00,99.00,89.00,89.00,89.00,89.00,89.00,99.00,109.00,99.00,99.00,99.00,99.00,99.00,109.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,69.26,5.00,0.00,0.00,0.00,0.00,0.00,0.00,40.00,0.00,0.00,0.00,0.00,0.00,0.00,42.00,0.00,0.00,0.00,0.00,0.00,0.00,39.85","subtotal":"3295.00","grand_total":"3501.74","paid_amount":"3501.74","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76889","customer_id":"76889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 17:57:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090646","reservation_id":"94268","confirmation_number":"PB12332556119","room_stay_from":"2020-05-02","room_stay_to":"2020-05-09","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"174.00,129.00,129.00,129.00,129.00,129.00,159.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"978.00","grand_total":"1105.14","paid_amount":"1105.14","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99977","customer_id":"99977","source_of_creation":"PMS","reservation_created_date":"2020-04-29 18:37:51","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090148","reservation_id":"93881","confirmation_number":"PB12347631567","room_stay_from":"2020-04-30","room_stay_to":"2020-05-15","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.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,78.39","subtotal":"1485.00","grand_total":"1589.47","paid_amount":"1011.87","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":"100118","customer_id":"100118","source_of_creation":"PMS","reservation_created_date":"2020-04-16 19:41:23","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":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090960","reservation_id":"94275","confirmation_number":"PB12399302445","room_stay_from":"2020-05-07","room_stay_to":"2020-05-09","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,129.00","nightly_discount":"0.00,0.00","subtotal":"248.00","grand_total":"280.24","paid_amount":"145.77","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100516","customer_id":"100516","source_of_creation":"PMS","reservation_created_date":"2020-04-29 23:21:35","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090849","reservation_id":"79457","confirmation_number":"PB12359188803","room_stay_from":"2020-08-04","room_stay_to":"2020-08-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2394.00","grand_total":"2705.22","paid_amount":"188.71","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"71131","customer_id":"71131","source_of_creation":"PMS","reservation_created_date":"2019-06-23 16:27:41","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":"","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":"3090817","reservation_id":"94272","confirmation_number":"PB12329568231","room_stay_from":"2020-05-01","room_stay_to":"2020-05-03","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"3","nightly_price":"159.00,174.00","nightly_discount":"0.00,20.54","subtotal":"333.00","grand_total":"353.08","paid_amount":"353.08","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":"100512","customer_id":"100512","source_of_creation":"PMS","reservation_created_date":"2020-04-29 21:18:57","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":"","changedComment":"Nightly price or discount changed","deltaChange":"-0.01","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":"3090875","reservation_id":"94277","confirmation_number":"PB12359672276","room_stay_from":"2020-05-01","room_stay_to":"2020-05-03","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"159.00,174.00","nightly_discount":"0.00,20.01","subtotal":"333.00","grand_total":"353.68","paid_amount":"353.68","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"58370","customer_id":"58370","source_of_creation":"PMS","reservation_created_date":"2020-04-29 23:50:38","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"Nightly price or discount changed","deltaChange":"-0.01","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":"3090851","reservation_id":"79459","confirmation_number":"PB12325318718","room_stay_from":"2020-08-04","room_stay_to":"2020-08-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2394.00","grand_total":"2705.22","paid_amount":"188.71","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"71132","customer_id":"71132","source_of_creation":"PMS","reservation_created_date":"2019-06-23 16:30:56","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3090757","reservation_id":"94323","confirmation_number":"PB12227501209","room_confirmation_number":"PB12310572418","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"0.00,20.00","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100558","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-05-02 23:46:54","reservation_modified_date_time":"2020-05-03 12:49:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100558","canceled_nights_data":"","changedComment":"Nightly price or discount changed","deltaChange":"-20.00","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":"3090787","reservation_id":"94229","confirmation_number":"PB12270473634","room_confirmation_number":"PB12344950766","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"30,30","nightly_discount":"0.00,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"100266","product_attribute_values":"extra_person# ","reservation_created_date":"2020-05-03 14:33:40","reservation_modified_date_time":"2020-05-03 14:33:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100266","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"30.00","currentDayPrice":"30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090902","reservation_id":"94373","confirmation_number":"PB12254070606","room_confirmation_number":"PB12392708281","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100406","product_attribute_values":"extra_person# ","reservation_created_date":"2020-05-03 20:22:43","reservation_modified_date_time":"2020-05-03 20:22:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100406","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090648","reservation_id":"94268","confirmation_number":"PB12261500315","room_confirmation_number":"PB12332556119","room_stay_from":"2020-05-02","room_stay_to":"2020-05-09","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"70.00","grand_total":"79.10","paid_amount":"79.10","product_id":"1780","service_quantity":"1","customer_traveller_id":"99977","product_attribute_values":"extra_person# ","reservation_created_date":"2020-05-02 21:49:22","reservation_modified_date_time":"2020-05-02 21:49:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99977","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3090437","reservation_id":"94187","confirmation_number":"PB12233724555","room_confirmation_number":"PB12367984089","room_stay_from":"2020-04-30","room_stay_to":"2020-05-04","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":"100437","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-27 13:23:09","reservation_modified_date_time":"2020-05-02 13:46:42","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100437","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090455","reservation_id":"94261","confirmation_number":"PB12299536916","room_confirmation_number":"PB12341476300","room_stay_from":"2020-04-30","room_stay_to":"2020-05-04","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":"100502","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-29 15:28:30","reservation_modified_date_time":"2020-05-02 15:18:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100502","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090471","reservation_id":"94145","confirmation_number":"PB12238722601","room_confirmation_number":"PB12357158727","room_stay_from":"2020-05-01","room_stay_to":"2020-05-04","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":"100549","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-04-25 18:51:06","reservation_modified_date_time":"2020-05-02 15:33:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100549","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090758","reservation_id":"94323","confirmation_number":"PB12227067401","room_confirmation_number":"PB12310572418","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","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":"100558","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-01 23:02:42","reservation_modified_date_time":"2020-05-03 12:49:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100558","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090790","reservation_id":"94229","confirmation_number":"PB12222077426","room_confirmation_number":"PB12344950766","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","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":"100266","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-28 17:49:38","reservation_modified_date_time":"2020-05-03 14:34:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100266","canceled_nights_data":"","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":"3090804","reservation_id":"94353","confirmation_number":"PB12289416339","room_confirmation_number":"PB12361810308","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","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":"100575","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 18:43:30","reservation_modified_date_time":"2020-05-03 15:30:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100575","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090903","reservation_id":"94373","confirmation_number":"PB12279962076","room_confirmation_number":"PB12392708281","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","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":"100406","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-03 14:09:13","reservation_modified_date_time":"2020-05-03 20:22:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100406","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090951","reservation_id":"94399","confirmation_number":"PB12270794589","room_confirmation_number":"PB12353689730","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"0.00","nightly_discount":"0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100614","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-03 22:55:27","reservation_modified_date_time":"2020-05-03 23:09:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100614","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090730","reservation_id":"94218","confirmation_number":"PB12259688159","room_confirmation_number":"PB12384878498","room_stay_from":"2020-05-03","room_stay_to":"2020-05-05","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":"100386","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-28 14:57:29","reservation_modified_date_time":"2020-05-03 00:47:30","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100386","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090755","reservation_id":"94219","confirmation_number":"PB12285255489","room_confirmation_number":"PB12333059557","room_stay_from":"2020-05-03","room_stay_to":"2020-05-05","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":"100385","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-28 14:59:42","reservation_modified_date_time":"2020-05-03 12:20:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100385","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090888","reservation_id":"94264","confirmation_number":"PB12283691018","room_confirmation_number":"PB12392025683","room_stay_from":"2020-05-03","room_stay_to":"2020-05-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"46174","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-04-29 17:26:09","reservation_modified_date_time":"2020-05-03 19:38:22","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"46174","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090848","reservation_id":"94300","confirmation_number":"PB12261388506","room_confirmation_number":"PB12331557837","room_stay_from":"2020-05-03","room_stay_to":"2020-05-07","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":"100539","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-01 01:51:17","reservation_modified_date_time":"2020-05-03 17:21:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100539","canceled_nights_data":"","changedComment":"From 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":"3090811","reservation_id":"94255","confirmation_number":"PB12280750251","room_confirmation_number":"PB12321030477","room_stay_from":"2020-05-03","room_stay_to":"2020-05-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"100496","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-29 13:16:19","reservation_modified_date_time":"2020-05-03 15:44:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100496","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090236","reservation_id":"93659","confirmation_number":"PB12259744424","room_confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-05-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"420.00","grand_total":"474.60","paid_amount":"474.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"76889","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-03-30 17:57:33","reservation_modified_date_time":"2020-05-01 18:02:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76889","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090649","reservation_id":"94268","confirmation_number":"PB12257032290","room_confirmation_number":"PB12332556119","room_stay_from":"2020-05-02","room_stay_to":"2020-05-09","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":"99977","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-29 18:37:51","reservation_modified_date_time":"2020-05-02 21:49:23","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99977","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090149","reservation_id":"93881","confirmation_number":"PB12234805093","room_confirmation_number":"PB12347631567","room_stay_from":"2020-04-30","room_stay_to":"2020-05-15","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","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","subtotal":"180.00","grand_total":"203.40","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100118","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-16 19:41:23","reservation_modified_date_time":"2020-05-01 00:57:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100118","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090961","reservation_id":"94275","confirmation_number":"PB12284744450","room_confirmation_number":"PB12399302445","room_stay_from":"2020-05-07","room_stay_to":"2020-05-09","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100516","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-29 23:21:35","reservation_modified_date_time":"2020-05-03 23:56:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100516","canceled_nights_data":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090850","reservation_id":"79457","confirmation_number":"PB12255143071","room_confirmation_number":"PB12359188803","room_stay_from":"2020-08-04","room_stay_to":"2020-08-25","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"71131","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-23 16:27:41","reservation_modified_date_time":"2020-05-03 17:28:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71131","canceled_nights_data":"","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":"3090852","reservation_id":"79459","confirmation_number":"PB12244534835","room_confirmation_number":"PB12325318718","room_stay_from":"2020-08-04","room_stay_to":"2020-08-25","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"71132","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2019-06-23 16:30:56","reservation_modified_date_time":"2020-05-03 17:29:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"71132","canceled_nights_data":"","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3090768","reservation_id":"94273","confirmation_number":"PB12248786756","room_confirmation_number":"PB12384394774","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"69.00","grand_total":"77.97","paid_amount":"77.97","product_id":"1142","service_quantity":"1","product_name":"1\/2 Day till 6pm","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 13:46:48","reservation_modified_date_time":"2020-05-03 13:46:48","customer_id":"100514","parentCustTravId":"100514","customer_traveller_id":"100514","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","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090793","reservation_id":"93925","confirmation_number":"PB12275832045","room_confirmation_number":"PB12399221589","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:14:03","reservation_modified_date_time":"2020-05-03 15:14:03","customer_id":"100165","parentCustTravId":"100165","customer_traveller_id":"100165","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","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090795","reservation_id":"94048","confirmation_number":"PB12214015233","room_confirmation_number":"PB12376782326","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:16:30","reservation_modified_date_time":"2020-05-03 15:16:30","customer_id":"100291","parentCustTravId":"100291","customer_traveller_id":"100291","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","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090814","reservation_id":"94261","confirmation_number":"PB12275603437","room_confirmation_number":"PB12341476300","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":"28.25","paid_amount":"28.25","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:48:22","reservation_modified_date_time":"2020-05-03 15:48:22","customer_id":"100502","parentCustTravId":"100502","customer_traveller_id":"100502","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090889","reservation_id":"94264","confirmation_number":"PB12266009936","room_confirmation_number":"PB12392025683","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.67","grand_total":"14.99","paid_amount":"15.00","product_id":"2009","service_quantity":"3","product_name":"Hourly Parking","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 19:10:28","reservation_modified_date_time":"2020-05-03 19:38:22","customer_id":"46174","parentCustTravId":"46174","customer_traveller_id":"46174","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"14.01","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3090904","reservation_id":"94373","confirmation_number":"PB12267171684","room_confirmation_number":"PB12392708281","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":"28.25","paid_amount":"28.25","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 20:24:59","reservation_modified_date_time":"2020-05-03 20:24:59","customer_id":"100406","parentCustTravId":"100406","customer_traveller_id":"100406","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090917","reservation_id":"94229","confirmation_number":"PB12230310781","room_confirmation_number":"PB12344950766","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":"28.25","paid_amount":"28.25","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 21:16:10","reservation_modified_date_time":"2020-05-03 21:16:10","customer_id":"100266","parentCustTravId":"100266","customer_traveller_id":"100266","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090950","reservation_id":"94399","confirmation_number":"PB12237593280","room_confirmation_number":"PB12353689730","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1217","service_quantity":"1","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 23:01:47","reservation_modified_date_time":"2020-05-03 23:09:08","customer_id":"100614","parentCustTravId":"100614","customer_traveller_id":"100614","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090965","reservation_id":"94297","confirmation_number":"PB12288917852","room_confirmation_number":"PB12353563213","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"69.00","grand_total":"77.97","paid_amount":"77.97","product_id":"1142","service_quantity":"1","product_name":"1\/2 Day till 6pm","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 14:07:33","reservation_modified_date_time":"2020-05-04 00:21:08","customer_id":"100616","parentCustTravId":"100616","customer_traveller_id":"100616","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","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090970","reservation_id":"94261","confirmation_number":"PB12238620715","room_confirmation_number":"PB12341476300","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.21","grand_total":"4.50","paid_amount":"4.50","product_id":"1144","service_quantity":"1","product_name":"Aloe Lotion\/ Gel","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-04 01:18:45","reservation_modified_date_time":"2020-05-04 01:18:45","customer_id":"100502","parentCustTravId":"100502","customer_traveller_id":"100502","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"4.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3090799","reservation_id":"94377","confirmation_number":"PB12226502770","room_confirmation_number":"PB12369935998","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"3.74","grand_total":"8.00","paid_amount":"8.00","product_id":null,"service_quantity":"2","product_name":"Koolies","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:24:15","reservation_modified_date_time":"2020-05-03 15:24:15","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"7.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3090808","reservation_id":"94378","confirmation_number":"PB12240043314","room_confirmation_number":"PB12366272767","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":"22.60","paid_amount":"22.60","product_id":null,"service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:31:28","reservation_modified_date_time":"2020-05-03 15:31:28","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,"currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090809","reservation_id":"94378","confirmation_number":"PB12292674522","room_confirmation_number":"PB12366272767","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":"28.25","paid_amount":"28.25","product_id":null,"service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:31:28","reservation_modified_date_time":"2020-05-03 15:31:28","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,"currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090813","reservation_id":"94379","confirmation_number":"PB12261472611","room_confirmation_number":"PB12374657856","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":"22.60","paid_amount":"22.60","product_id":null,"service_quantity":"2","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:47:43","reservation_modified_date_time":"2020-05-03 15:47:43","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090829","reservation_id":"94382","confirmation_number":"PB12216093521","room_confirmation_number":"PB12327579878","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.93","grand_total":"3.00","paid_amount":"3.00","product_id":null,"service_quantity":"3","product_name":"Water","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 16:28:57","reservation_modified_date_time":"2020-05-03 16:28:57","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,"currentDayPrice":"2.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3090861","reservation_id":"94385","confirmation_number":"PB12247387347","room_confirmation_number":"PB12357002943","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":null,"service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 17:44:17","reservation_modified_date_time":"2020-05-03 17:44:17","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,"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":"3090862","reservation_id":"94385","confirmation_number":"PB12261757324","room_confirmation_number":"PB12357002943","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":"28.25","paid_amount":"28.25","product_id":null,"service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 17:44:17","reservation_modified_date_time":"2020-05-03 17:44:17","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,"currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":5,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1224,1225,1220","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BV12210826858","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"BV12247696731","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"},{"confirmation_number":"BV12281937235","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3090853","reservation_id":"94356","confirmation_number":"BV12412900576","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129.00","nightly_discount":"0.00","subtotal":"129.00","grand_total":"145.77","paid_amount":"145.77","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":"100577","customer_id":"100577","source_of_creation":"FE","reservation_created_date":"2020-05-02 20:10:10","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3090304","reservation_id":"94313","confirmation_number":"BV12435475327","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.00,126.00","nightly_discount":"0.00,0.00","subtotal":"252.00","grand_total":"284.76","paid_amount":"284.76","room_type_id":"303","product_id":"1140","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100557","customer_id":"100557","source_of_creation":"PMS","reservation_created_date":"2020-05-01 19:25:45","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"126.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090669","reservation_id":"94361","confirmation_number":"BV12490682180","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.80,129.00","nightly_discount":"0.00,7.87","subtotal":"319.80","grand_total":"352.49","paid_amount":"352.49","room_type_id":"309","product_id":"1226","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":"100583","customer_id":"100583","source_of_creation":"PMS","reservation_created_date":"2020-05-02 21:16:40","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"7.87","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090778","reservation_id":"94332","confirmation_number":"BV12497812680","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"1","nightly_price":"161.00,99.00","nightly_discount":"0.00,0.00","subtotal":"260.00","grand_total":"293.80","paid_amount":"293.80","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":"100400","customer_id":"100400","source_of_creation":"PMS","reservation_created_date":"2020-05-02 15:22:37","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090893","reservation_id":"94331","confirmation_number":"BV12418760540","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"190.80,99.00","nightly_discount":"0.00,0.00","subtotal":"289.80","grand_total":"327.48","paid_amount":"327.48","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100564","customer_id":"100564","source_of_creation":"PMS","reservation_created_date":"2020-05-02 14:58:13","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090491","reservation_id":"94339","confirmation_number":"BV12433000596","room_stay_from":"2020-05-03","room_stay_to":"2020-05-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00","subtotal":"297.00","grand_total":"335.61","paid_amount":"335.61","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":"47798","customer_id":"47798","source_of_creation":"PMS","reservation_created_date":"2020-05-02 16:27:53","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":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090594","reservation_id":"94357","confirmation_number":"BV12448543332","room_stay_from":"2020-05-02","room_stay_to":"2020-05-12","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"890.00","grand_total":"1005.70","paid_amount":"1005.70","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76151","customer_id":"76151","source_of_creation":"PMS","reservation_created_date":"2020-05-02 20:22:53","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":"","currentDayPrice":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3090779","reservation_id":"94332","confirmation_number":"BV12211184832","room_confirmation_number":"BV12497812680","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"40.00,20.00","nightly_discount":"0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"100400","product_attribute_values":"extra_person# ","reservation_created_date":"2020-05-03 14:17:06","reservation_modified_date_time":"2020-05-03 14:17:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100400","canceled_nights_data":"","changedComment":"Reservation created with partial past date","deltaChange":"40.00","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":"3090855","reservation_id":"94356","confirmation_number":"PB12249697380","room_confirmation_number":"BV12412900576","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"100577","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-05-03 17:32:10","reservation_modified_date_time":"2020-05-03 17:32:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100577","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3090303","reservation_id":"94313","confirmation_number":"BV12251337946","room_confirmation_number":"BV12435475327","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","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":"100557","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-01 19:25:45","reservation_modified_date_time":"2020-05-01 21:56:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100557","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090670","reservation_id":"94361","confirmation_number":"BV12216683051","room_confirmation_number":"BV12490682180","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","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":"100583","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 21:16:40","reservation_modified_date_time":"2020-05-02 22:54:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100583","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090780","reservation_id":"94332","confirmation_number":"BV12243617375","room_confirmation_number":"BV12497812680","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","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":"100400","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 15:22:37","reservation_modified_date_time":"2020-05-03 14:17:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100400","canceled_nights_data":"","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":"3090856","reservation_id":"94356","confirmation_number":"BV12279195080","room_confirmation_number":"BV12412900576","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","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":"100577","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 20:10:10","reservation_modified_date_time":"2020-05-03 17:32:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100577","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090894","reservation_id":"94331","confirmation_number":"BV12214635961","room_confirmation_number":"BV12418760540","room_stay_from":"2020-05-02","room_stay_to":"2020-05-04","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":"100564","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 14:58:13","reservation_modified_date_time":"2020-05-03 19:49:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100564","canceled_nights_data":"","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":"3090492","reservation_id":"94339","confirmation_number":"BV12226769381","room_confirmation_number":"BV12433000596","room_stay_from":"2020-05-03","room_stay_to":"2020-05-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"47798","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 16:27:53","reservation_modified_date_time":"2020-05-02 16:27:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090595","reservation_id":"94357","confirmation_number":"BV12259448950","room_confirmation_number":"BV12448543332","room_stay_from":"2020-05-02","room_stay_to":"2020-05-12","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"76151","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 20:22:53","reservation_modified_date_time":"2020-05-02 20:22:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76151","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3090797","reservation_id":"94267","confirmation_number":"BV12216990271","room_confirmation_number":"BV12488890659","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"69.00","grand_total":"77.97","paid_amount":"77.97","product_id":"1142","service_quantity":"1","product_name":"1\/2 Day till 6pm","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-03 15:22:24","reservation_modified_date_time":"2020-05-03 15:22:24","customer_id":"100507","parentCustTravId":"100507","customer_traveller_id":"100507","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","currentDayPrice":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":5,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1129,1125","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BP12235114022","room_stay_from":"2020-05-01","room_stay_to":"2020-05-06","bundle_room":"0"},{"confirmation_number":"BP12251042630","room_stay_from":"2020-05-02","room_stay_to":"2020-05-06","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3090900","reservation_id":"94355","confirmation_number":"BP12537495419","room_stay_from":"2020-05-02","room_stay_to":"2020-05-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.83,104.94,104.94","nightly_discount":"0,0,0","subtotal":"379.71","grand_total":"429.07","paid_amount":"429.07","room_type_id":"301","product_id":"1136","siteminder_id":"AGO-317498602","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":"100582","customer_id":"100582","source_of_creation":"Agoda","reservation_created_date":"2020-05-02 19:16:11","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 807","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"104.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":"3090956","reservation_id":"94400","confirmation_number":"BP12594418989","room_stay_from":"2020-05-03","room_stay_to":"2020-05-06","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"85.87,85.87,85.87","nightly_discount":"0,0,0","subtotal":"257.61","grand_total":"291.10","paid_amount":"291.10","room_type_id":"299","product_id":"1134","siteminder_id":"AGO-317633894","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":"100615","customer_id":"100615","source_of_creation":"Agoda","reservation_created_date":"2020-05-03 23:46:09","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"85.87","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3090824","reservation_id":"94347","confirmation_number":"BP12563136275","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"129.00","nightly_discount":"0.00","subtotal":"129.00","grand_total":"145.77","paid_amount":"145.77","room_type_id":"289","product_id":"1123","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100308","customer_id":"100308","source_of_creation":"FE","reservation_created_date":"2020-05-02 18:05:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090677","reservation_id":"94154","confirmation_number":"BP12571412855","room_stay_from":"2020-05-02","room_stay_to":"2020-05-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,99.00,99.00","nightly_discount":"0.00,0.00,11.88","subtotal":"327.00","grand_total":"356.09","paid_amount":"356.09","room_type_id":"295","product_id":"1128","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":"100402","customer_id":"100402","source_of_creation":"FE","reservation_created_date":"2020-04-25 23:29:28","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":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3090967","reservation_id":"94362","confirmation_number":"BP12536970932","room_stay_from":"2020-05-03","room_stay_to":"2020-05-07","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"516.00","grand_total":"583.08","paid_amount":"583.08","room_type_id":"297","product_id":"1132","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"100585","customer_id":"100585","source_of_creation":"PMS","reservation_created_date":"2020-05-02 21:31:47","canceled_nights_data":"","product_name":"BP Deluxe Two Bedroom Suite 2Q, 1SS 826","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090905","reservation_id":"92054","confirmation_number":"BP12578243247","room_stay_from":"2020-10-10","room_stay_to":"2020-10-15","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,94.00,94.00,94.00,94.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"490.00","grand_total":"553.70","paid_amount":"224.87","room_type_id":"293","product_id":"1124","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"84844","customer_id":"84844","source_of_creation":"PMS","reservation_created_date":"2020-02-16 17:48:04","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3090826","reservation_id":"94347","confirmation_number":"PB12210286805","room_confirmation_number":"BP12563136275","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"100308","product_attribute_values":"extra_person# .00","reservation_created_date":"2020-05-03 16:24:55","reservation_modified_date_time":"2020-05-03 16:24:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100308","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090657","reservation_id":"94362","confirmation_number":"BP12243792006","room_confirmation_number":"BP12536970932","room_stay_from":"2020-05-03","room_stay_to":"2020-05-07","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"100585","product_attribute_values":"extra_person# ","reservation_created_date":"2020-05-02 22:37:05","reservation_modified_date_time":"2020-05-02 22:37:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100585","canceled_nights_data":"","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3090827","reservation_id":"94347","confirmation_number":"BP12250978960","room_confirmation_number":"BP12563136275","room_stay_from":"2020-05-03","room_stay_to":"2020-05-04","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":"100308","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 18:05:14","reservation_modified_date_time":"2020-05-03 16:24:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100308","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090678","reservation_id":"94154","confirmation_number":"BP12293994837","room_confirmation_number":"BP12571412855","room_stay_from":"2020-05-02","room_stay_to":"2020-05-05","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":"100402","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-04-25 23:29:28","reservation_modified_date_time":"2020-05-02 23:18:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100402","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090899","reservation_id":"94355","confirmation_number":"BP12265199200","room_confirmation_number":"BP12537495419","room_stay_from":"2020-05-02","room_stay_to":"2020-05-05","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":"100582","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-02 19:16:11","reservation_modified_date_time":"2020-05-03 20:15:37","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100582","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090957","reservation_id":"94400","confirmation_number":"BP12266350277","room_confirmation_number":"BP12594418989","room_stay_from":"2020-05-03","room_stay_to":"2020-05-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"100615","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2020-05-03 23:46:09","reservation_modified_date_time":"2020-05-03 23:46:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100615","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090969","reservation_id":"94362","confirmation_number":"BP12241614071","room_confirmation_number":"BP12536970932","room_stay_from":"2020-05-03","room_stay_to":"2020-05-07","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":"100585","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-05-02 21:31:47","reservation_modified_date_time":"2020-05-04 00:23:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"100585","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3090906","reservation_id":"92054","confirmation_number":"BP12273510009","room_confirmation_number":"BP12578243247","room_stay_from":"2020-10-10","room_stay_to":"2020-10-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"84844","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2020-02-16 17:48:04","reservation_modified_date_time":"2020-05-03 20:28:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"84844","canceled_nights_data":"","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3090643","reservation_id":"94362","confirmation_number":"BP12227616766","room_confirmation_number":"BP12536970932","room_stay_from":"2020-05-03","room_stay_to":"2020-05-07","room_stay_status":"Active","nightly_price":"30.00,30.00,30.00,30.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-02 21:31:47","reservation_modified_date_time":"2020-05-02 21:31:47","customer_id":"100585","parentCustTravId":"100585","customer_traveller_id":"100585","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"30.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3090968","reservation_id":"94362","confirmation_number":"BP12238924138","room_confirmation_number":"BP12536970932","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":"28.25","paid_amount":"28.25","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-05-04 00:13:29","reservation_modified_date_time":"2020-05-04 00:23:18","customer_id":"100585","parentCustTravId":"100585","customer_traveller_id":"100585","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}