{"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,1113,1114,1115,1116,1117,1118,1119,1120,1121,1123","departureCount":12,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3013677","reservation_id":"83203","confirmation_number":"PB12332855627","room_stay_from":"2019-11-28","room_stay_to":"2019-12-07","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"62.54,70.99,70.99,62.54,62.54,62.54,62.54,62.54,70.99","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"588.21","grand_total":"664.67","paid_amount":"664.67","room_type_id":"289","product_id":"1107","siteminder_id":"EXP-1329075429","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"70.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90601","customer_id":"90601","source_of_creation":"Expedia","reservation_created_date":"2019-08-25 15:17:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.54","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":"3019169","reservation_id":"83224","confirmation_number":"PB12341551363","room_stay_from":"2019-12-02","room_stay_to":"2019-12-05","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"71.81,71.81,71.81","nightly_discount":"0,0,0","subtotal":"215.43","grand_total":"243.44","paid_amount":"243.44","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1329317182","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90617","customer_id":"90617","source_of_creation":"Expedia","reservation_created_date":"2019-08-25 23:57:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.81","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3026452","reservation_id":"83760","confirmation_number":"PB12382978139","room_stay_from":"2019-11-29","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"72.48,72.48,63.53,63.53","nightly_discount":"0,0,0,0","subtotal":"272.02","grand_total":"307.38","paid_amount":"307.38","room_type_id":"289","product_id":"1103","siteminder_id":"EXP-1338034106","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":"91117","customer_id":"91117","source_of_creation":"Expedia","reservation_created_date":"2019-09-08 00:41:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"63.53","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3031270","reservation_id":"84703","confirmation_number":"PB12363137062","room_stay_from":"2019-11-28","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.98,85.54,85.54,74.98,74.98","nightly_discount":"0,0,0,0,0","subtotal":"396.02","grand_total":"447.50","paid_amount":"447.50","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1349752866","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":"92024","customer_id":"92024","source_of_creation":"Expedia","reservation_created_date":"2019-09-26 00:36:10","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":"","currentDayPrice":"74.98","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3034451","reservation_id":"86582","confirmation_number":"PB12343987981","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.61","nightly_discount":"0","subtotal":"66.61","grand_total":"75.27","paid_amount":"75.27","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1373020099","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":"93296","customer_id":"93296","source_of_creation":"Expedia","reservation_created_date":"2019-11-02 15:44:10","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":"66.61","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":"3035207","reservation_id":"86694","confirmation_number":"PB12350103105","room_stay_from":"2019-11-30","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"116.2,86.22,86.22","nightly_discount":"0,0,0","subtotal":"288.64","grand_total":"326.16","paid_amount":"326.16","room_type_id":"289","product_id":"1098","siteminder_id":"EXP-1374535639","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93371","customer_id":"93371","source_of_creation":"Expedia","reservation_created_date":"2019-11-05 05:10:06","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":"","currentDayPrice":"86.22","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":"3040140","reservation_id":"87369","confirmation_number":"PB12399807962","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"76.11","nightly_discount":"0","subtotal":"76.11","grand_total":"86.01","paid_amount":"86.01","room_type_id":"289","product_id":"1104","siteminder_id":"EXP-1383841137","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93919","customer_id":"93919","source_of_creation":"Expedia","reservation_created_date":"2019-11-21 03:23:05","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":"76.11","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":"3041298","reservation_id":"87489","confirmation_number":"PB12354904723","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.73,71.73","nightly_discount":"0,0","subtotal":"143.46","grand_total":"162.11","paid_amount":"162.11","room_type_id":"289","product_id":"1093","siteminder_id":"EXP-1385178057","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":"94016","customer_id":"94016","source_of_creation":"Expedia","reservation_created_date":"2019-11-25 01:03:05","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":"71.73","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":"3043411","reservation_id":"82087","confirmation_number":"PB12383768921","room_stay_from":"2019-12-01","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"59.94,59.94,59.94,59.94,59.94","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"299.70","grand_total":"338.66","paid_amount":"338.66","room_type_id":"289","product_id":"1094","siteminder_id":"EXP-1315659015","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89846","customer_id":"89846","source_of_creation":"Expedia","reservation_created_date":"2019-08-05 20:07:11","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":"59.94","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3044281","reservation_id":"78400","confirmation_number":"PB12382859506","room_stay_from":"2019-11-30","room_stay_to":"2019-12-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.64,42.90,42.90,42.90,42.90,42.90,49.64","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"313.78","grand_total":"354.57","paid_amount":"354.57","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1274800229","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":"87470","customer_id":"87470","source_of_creation":"Expedia","reservation_created_date":"2019-06-10 08:28:07","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"42.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3030284","reservation_id":"85940","confirmation_number":"PB12363615570","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"45.18,45.18","nightly_discount":"0,0","subtotal":"90.36","grand_total":"102.11","paid_amount":"102.11","room_type_id":"292","product_id":"1120","siteminder_id":"HTN-104697643-3J4D9Q","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":"92864","customer_id":"92864","source_of_creation":"HotelTonight","reservation_created_date":"2019-10-19 17:19:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"45.18","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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3037507","reservation_id":"87039","confirmation_number":"PB12368915996","room_stay_from":"2019-12-02","room_stay_to":"2019-12-05","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"93.12,93.12,93.12","nightly_discount":"0,0,0","subtotal":"279.36","grand_total":"364.49","paid_amount":"364.49","room_type_id":"291","product_id":"1115","siteminder_id":"ABB-HMAH2ETRTD","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"279.36","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93631","customer_id":"93631","source_of_creation":"Airbnb","reservation_created_date":"2019-11-12 05:02:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"39.05","commision_charges":"8.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"93.12","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3040720","reservation_id":"87120","confirmation_number":"PB12321823881","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"58.22","nightly_discount":"0","subtotal":"58.22","grand_total":"65.79","paid_amount":"65.79","room_type_id":"289","product_id":"1121","siteminder_id":"AGO-291249774","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93699","customer_id":"93699","source_of_creation":"Agoda","reservation_created_date":"2019-11-14 01:46:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"58.22","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":"3040725","reservation_id":"85361","confirmation_number":"PB12373314327","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"73.68","nightly_discount":"0","subtotal":"73.68","grand_total":"83.26","paid_amount":"83.26","room_type_id":"289","product_id":"1099","siteminder_id":"AGO-252568459","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92510","customer_id":"92510","source_of_creation":"Agoda","reservation_created_date":"2019-10-09 21:15:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.68","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":"3043435","reservation_id":"87738","confirmation_number":"PB12368879648","room_stay_from":"2019-12-02","room_stay_to":"2019-12-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.04,113.04,113.04","nightly_discount":"0,0,0","subtotal":"339.12","grand_total":"383.21","paid_amount":"383.21","room_type_id":"287","product_id":"1087","siteminder_id":"AGO-294436154","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":"94185","customer_id":"94185","source_of_creation":"Agoda","reservation_created_date":"2019-12-01 22:07:06","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":"113.04","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":"3031819","reservation_id":"86125","confirmation_number":"PB12362093485","room_stay_from":"2019-12-02","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"100.00,100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"400.00","grand_total":"452.00","paid_amount":"452.00","room_type_id":"288","product_id":"1091","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":"92986","customer_id":"92986","source_of_creation":"FE","reservation_created_date":"2019-10-23 15:29:45","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"2989177","reservation_id":"78852","confirmation_number":"PB12318182402","room_stay_from":"2019-12-01","room_stay_to":"2019-12-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"68.80,68.80,68.80,68.80,68.80,84.80,84.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"513.60","grand_total":"580.37","paid_amount":"580.37","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":"87795","customer_id":"87795","source_of_creation":"PMS","reservation_created_date":"2019-06-17 18:21:39","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"68.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029161","reservation_id":"85740","confirmation_number":"PB12330974731","room_stay_from":"2019-11-30","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.48,74.40,74.40,74.40,74.40,74.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"480.48","grand_total":"542.94","paid_amount":"542.94","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":"92762","customer_id":"92762","source_of_creation":"PMS","reservation_created_date":"2019-10-16 20:13:13","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":"","currentDayPrice":"74.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3040723","reservation_id":"85526","confirmation_number":"PB12398276301","room_stay_from":"2019-12-02","room_stay_to":"2019-12-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.90,74.90","nightly_discount":"0.00,0.00","subtotal":"149.80","grand_total":"169.28","paid_amount":"169.28","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92605","customer_id":"92605","source_of_creation":"PMS","reservation_created_date":"2019-10-12 14:29:04","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3042098","reservation_id":"73943","confirmation_number":"PB12378677631","room_stay_from":"2019-11-27","room_stay_to":"2019-12-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.00,170.00,190.00,190.00,139.00,139.00,139.00,139.00,139.00,159.00,159.00,139.00,139.00,139.00,139.00,139.00,159.00,159.00,139.00,139.00,139.00,139.00,139.00,159.00,159.00,139.00,139.00,139.00,139.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,85.64,139.00","subtotal":"4315.00","grand_total":"4622.11","paid_amount":"4622.11","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"26350","customer_id":"26350","source_of_creation":"PMS","reservation_created_date":"2019-04-03 17:40:38","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3042100","reservation_id":"87577","confirmation_number":"PB12364899071","room_stay_from":"2019-12-02","room_stay_to":"2019-12-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.00,80.00","nightly_discount":"0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","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":"94084","customer_id":"94084","source_of_creation":"PMS","reservation_created_date":"2019-11-28 00:52:44","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":"80.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043191","reservation_id":"77131","confirmation_number":"PB12319800396","room_stay_from":"2019-11-30","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.40,74.40,74.40,74.40,74.40,74.40","nightly_discount":"19.80,0.00,0.00,0.00,0.00,0.00","subtotal":"462.40","grand_total":"500.14","paid_amount":"500.14","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"34185","customer_id":"34185","source_of_creation":"PMS","reservation_created_date":"2019-05-22 21:04:51","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":"74.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043625","reservation_id":"87786","confirmation_number":"PB12367943197","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.80","nightly_discount":"0.00","subtotal":"96.80","grand_total":"109.39","paid_amount":"109.39","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94227","customer_id":"94227","source_of_creation":"PMS","reservation_created_date":"2019-12-02 22:22:24","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043658","reservation_id":"87781","confirmation_number":"PB12338701168","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.79","nightly_discount":"0.00","subtotal":"96.79","grand_total":"109.38","paid_amount":"109.38","room_type_id":"291","product_id":"1114","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"70580","customer_id":"70580","source_of_creation":"PMS","reservation_created_date":"2019-12-02 19:48:12","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":"96.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3044301","reservation_id":"61846","confirmation_number":"PB12391957014","room_stay_from":"2019-10-28","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00","nightly_discount":"79.80,79.80,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,83.00,83.00,83.00,83.00,83.00","subtotal":"3705.00","grand_total":"3537.35","paid_amount":"3537.35","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":"23454","customer_id":"23454","source_of_creation":"PMS","reservation_created_date":"2018-11-30 00:04:47","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":"95.00","currentDayDiscount":"83.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3045122","reservation_id":"84171","confirmation_number":"PB12310411466","room_stay_from":"2019-12-02","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.65,48.65,48.65,48.64","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"194.59","grand_total":"219.89","paid_amount":"219.89","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":"91664","customer_id":"91664","source_of_creation":"PMS","reservation_created_date":"2019-09-15 23:17:10","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":"48.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3013678","reservation_id":"83203","confirmation_number":"PB12248751103","room_confirmation_number":"PB12332855627","room_stay_from":"2019-11-28","room_stay_to":"2019-12-07","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1780","service_quantity":"1","customer_traveller_id":"90601","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-08-25 15:17:13","reservation_modified_date_time":"2019-08-25 15:17:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90601","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"}]},{"room_stay_id":"3019170","reservation_id":"83224","confirmation_number":"PB12265802538","room_confirmation_number":"PB12341551363","room_stay_from":"2019-12-02","room_stay_to":"2019-12-05","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"90617","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-09-14 16:11:59","reservation_modified_date_time":"2019-09-14 16:11:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90617","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":"3031820","reservation_id":"86125","confirmation_number":"PB12229193844","room_confirmation_number":"PB12362093485","room_stay_from":"2019-12-02","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0,0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"92986","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-10-23 17:09:59","reservation_modified_date_time":"2019-10-23 17:09:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92986","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"}]},{"room_stay_id":"3035208","reservation_id":"86694","confirmation_number":"PB12281125077","room_confirmation_number":"PB12350103105","room_stay_from":"2019-11-30","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"93371","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-11-05 05:10:06","reservation_modified_date_time":"2019-11-05 05:10:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93371","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"}]},{"room_stay_id":"3040141","reservation_id":"87369","confirmation_number":"PB12254122120","room_confirmation_number":"PB12399807962","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"40","nightly_discount":"0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"93919","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-11-21 03:23:05","reservation_modified_date_time":"2019-11-21 03:23:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93919","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3040721","reservation_id":"87120","confirmation_number":"PB12211294961","room_confirmation_number":"PB12321823881","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"93699","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-11-23 15:58:08","reservation_modified_date_time":"2019-11-23 15:58:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93699","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"}]},{"room_stay_id":"3040726","reservation_id":"85361","confirmation_number":"PB12261644393","room_confirmation_number":"PB12373314327","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"92510","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-11-23 16:04:35","reservation_modified_date_time":"2019-11-23 16:04:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92510","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2989178","reservation_id":"78852","confirmation_number":"PB12219433659","room_confirmation_number":"PB12318182402","room_stay_from":"2019-12-01","room_stay_to":"2019-12-08","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":"87795","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-17 18:21:39","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87795","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":"3013679","reservation_id":"83203","confirmation_number":"PB12244847104","room_confirmation_number":"PB12332855627","room_stay_from":"2019-11-28","room_stay_to":"2019-12-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"90601","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-25 15:17:13","reservation_modified_date_time":"2019-08-25 15:17:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90601","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":"3019171","reservation_id":"83224","confirmation_number":"PB12255317444","room_confirmation_number":"PB12341551363","room_stay_from":"2019-12-02","room_stay_to":"2019-12-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":"90617","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-25 23:57:06","reservation_modified_date_time":"2019-08-25 23:57:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90617","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":"3026453","reservation_id":"83760","confirmation_number":"PB12247073638","room_confirmation_number":"PB12382978139","room_stay_from":"2019-11-29","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"91117","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-08 00:41:10","reservation_modified_date_time":"2019-09-08 00:41:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91117","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":"3029162","reservation_id":"85740","confirmation_number":"PB12285584212","room_confirmation_number":"PB12330974731","room_stay_from":"2019-11-30","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"92762","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-16 20:13:13","reservation_modified_date_time":"2019-10-16 20:13:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92762","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":"3030285","reservation_id":"85940","confirmation_number":"PB12216500364","room_confirmation_number":"PB12363615570","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","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":"92864","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-19 17:19:09","reservation_modified_date_time":"2019-10-19 17:19:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92864","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":"3031271","reservation_id":"84703","confirmation_number":"PB12236450818","room_confirmation_number":"PB12363137062","room_stay_from":"2019-11-28","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0,0,0","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92024","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-26 00:36:10","reservation_modified_date_time":"2019-09-26 00:36:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92024","canceled_nights_data":"","currentDayPrice":"20.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":"3031821","reservation_id":"86125","confirmation_number":"PB12241903499","room_confirmation_number":"PB12362093485","room_stay_from":"2019-12-02","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"92986","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-23 15:29:45","reservation_modified_date_time":"2019-10-23 15:29:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92986","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":"3034452","reservation_id":"86582","confirmation_number":"PB12219592405","room_confirmation_number":"PB12343987981","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"93296","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-02 15:44:10","reservation_modified_date_time":"2019-11-02 15:44:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93296","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":"3035209","reservation_id":"86694","confirmation_number":"PB12229084763","room_confirmation_number":"PB12350103105","room_stay_from":"2019-11-30","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"93371","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-05 05:10:06","reservation_modified_date_time":"2019-11-05 05:10:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93371","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":"3037508","reservation_id":"87039","confirmation_number":"PB12238547401","room_confirmation_number":"PB12368915996","room_stay_from":"2019-12-02","room_stay_to":"2019-12-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":"93631","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-12 05:02:10","reservation_modified_date_time":"2019-11-12 05:02:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93631","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3040142","reservation_id":"87369","confirmation_number":"PB12271174181","room_confirmation_number":"PB12399807962","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"93919","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-21 03:23:05","reservation_modified_date_time":"2019-11-21 03:23:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93919","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":"3040722","reservation_id":"87120","confirmation_number":"PB12275429728","room_confirmation_number":"PB12321823881","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"93699","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-14 01:46:09","reservation_modified_date_time":"2019-11-14 01:46:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93699","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":"3040724","reservation_id":"85526","confirmation_number":"PB12249501960","room_confirmation_number":"PB12398276301","room_stay_from":"2019-12-02","room_stay_to":"2019-12-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":"92605","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-12 14:29:04","reservation_modified_date_time":"2019-10-12 14:29:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92605","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":"3040727","reservation_id":"85361","confirmation_number":"PB12276534080","room_confirmation_number":"PB12373314327","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"92510","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-09 21:15:09","reservation_modified_date_time":"2019-10-09 21:15:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92510","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":"3041299","reservation_id":"87489","confirmation_number":"PB12235662329","room_confirmation_number":"PB12354904723","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","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":"94016","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-25 01:03:05","reservation_modified_date_time":"2019-11-25 01:03:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94016","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":"3042099","reservation_id":"73943","confirmation_number":"PB12239672735","room_confirmation_number":"PB12378677631","room_stay_from":"2019-11-27","room_stay_to":"2019-12-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"348.00","grand_total":"393.24","paid_amount":"393.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"26350","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-03 17:40:38","reservation_modified_date_time":"2019-11-28 00:33:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26350","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":"3042101","reservation_id":"87577","confirmation_number":"PB12247841766","room_confirmation_number":"PB12364899071","room_stay_from":"2019-12-02","room_stay_to":"2019-12-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":"94084","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-28 00:52:44","reservation_modified_date_time":"2019-11-28 00:52:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94084","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":"3043192","reservation_id":"77131","confirmation_number":"PB12228151905","room_confirmation_number":"PB12319800396","room_stay_from":"2019-11-30","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"34185","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-22 21:04:51","reservation_modified_date_time":"2019-12-01 00:06:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"34185","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":"3043414","reservation_id":"82087","confirmation_number":"PB12221962485","room_confirmation_number":"PB12383768921","room_stay_from":"2019-12-01","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89846","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-05 20:07:11","reservation_modified_date_time":"2019-12-01 20:18:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89846","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":"3043436","reservation_id":"87738","confirmation_number":"PB12237718319","room_confirmation_number":"PB12368879648","room_stay_from":"2019-12-02","room_stay_to":"2019-12-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":"94185","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-01 22:07:06","reservation_modified_date_time":"2019-12-01 22:07:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94185","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":"3043626","reservation_id":"87786","confirmation_number":"PB12286840770","room_confirmation_number":"PB12367943197","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","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":"94227","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-02 22:22:24","reservation_modified_date_time":"2019-12-02 22:22:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94227","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":"3043659","reservation_id":"87781","confirmation_number":"PB12261457045","room_confirmation_number":"PB12338701168","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","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":"70580","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-02 19:48:12","reservation_modified_date_time":"2019-12-02 19:48:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70580","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":"3044282","reservation_id":"78400","confirmation_number":"PB12276435391","room_confirmation_number":"PB12382859506","room_stay_from":"2019-11-30","room_stay_to":"2019-12-07","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"87470","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-10 08:28:07","reservation_modified_date_time":"2019-12-05 15:11:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87470","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":"3044302","reservation_id":"61846","confirmation_number":"PB12312856665","room_confirmation_number":"PB12391957014","room_stay_from":"2019-10-28","room_stay_to":"2019-12-06","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,0.00,0.00,0.00,0.00,0.00,0.00,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,0.00,0.00,0.00,0.00,0.00,0.00,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":"23454","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-30 00:04:47","reservation_modified_date_time":"2019-12-05 15:30:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23454","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":"3045123","reservation_id":"84171","confirmation_number":"PB12272992740","room_confirmation_number":"PB12310411466","room_stay_from":"2019-12-02","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"91664","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-15 23:17:10","reservation_modified_date_time":"2019-12-07 18:32:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91664","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3043644","reservation_id":"87791","confirmation_number":"PB12215999454","room_confirmation_number":"PB12367721695","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":"2019-12-03 02:07:01","reservation_modified_date_time":"2019-12-03 02:07:01","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":"3010138","reservation_id":"82578","confirmation_number":"PB12287218366","room_confirmation_number":"PB12348584720","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-13 16:38:24","reservation_modified_date_time":"2019-08-13 16:38:24","customer_id":"90173","parentCustTravId":"90173","customer_traveller_id":"90173","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-12-02 13:36:53","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-40,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee 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":4,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3031657","reservation_id":"81663","confirmation_number":"BV12461284792","room_stay_from":"2019-11-30","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.31,67.54,67.54","nightly_discount":"0,0,0","subtotal":"227.39","grand_total":"256.95","paid_amount":"256.95","room_type_id":"308","product_id":"1225","siteminder_id":"EXP-1310627501","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":"89536","customer_id":"89536","source_of_creation":"Expedia","reservation_created_date":"2019-07-29 17:47:09","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"49.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.54","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3028998","reservation_id":"85726","confirmation_number":"BV12428684881","room_stay_from":"2019-12-02","room_stay_to":"2019-12-05","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.76,76.76,76.76","nightly_discount":"0,0,0","subtotal":"230.28","grand_total":"260.22","paid_amount":"0.00","room_type_id":"304","product_id":"1219","siteminder_id":"GCC-0001900037-a6c","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":"92751","customer_id":"92751","source_of_creation":"GuestCentric Systems","reservation_created_date":"2019-10-16 16:46:13","service_canceled_date_time":"","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":0,"changedComment":"","currentDayPrice":76.76,"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"}]}],"gcc_non_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3033748","reservation_id":"86487","confirmation_number":"BV12460124495","room_stay_from":"2019-12-02","room_stay_to":"2019-12-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.20,75.20,75.20,75.20,91.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"392.00","grand_total":"442.96","paid_amount":"442.96","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93231","customer_id":"93231","source_of_creation":"FE","reservation_created_date":"2019-10-31 14:59:35","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.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":"3038662","reservation_id":"87187","confirmation_number":"BV12499499341","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.80,80.80","nightly_discount":"0.00,0.00","subtotal":"161.60","grand_total":"182.61","paid_amount":"182.61","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":"93756","customer_id":"93756","source_of_creation":"FE","reservation_created_date":"2019-11-15 16:28:45","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":"80.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043490","reservation_id":"83988","confirmation_number":"BV12459674359","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.20,67.20","nightly_discount":"0.00,4.48,0.00","subtotal":"134.40","grand_total":"146.81","paid_amount":"146.81","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":"34245","customer_id":"34245","source_of_creation":"FE","reservation_created_date":"2019-09-12 19:35:17","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":"67.20","currentDayDiscount":"4.48","productIsTaxExempt":false,"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":"3043053","reservation_id":"67614","confirmation_number":"BV12465243213","room_stay_from":"2019-11-30","room_stay_to":"2019-12-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,65.00,65.00,65.00,65.00,65.00,115.00,115.00,65.00,65.00,65.00,65.00,65.00,115.00,115.00,65.00,65.00,65.00,65.00,65.00,115.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,101.82,0.00","subtotal":"1665.00","grand_total":"1766.39","paid_amount":"1766.39","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"78455","customer_id":"78455","source_of_creation":"PMS","reservation_created_date":"2019-01-23 16:31:15","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"65.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043089","reservation_id":"64834","confirmation_number":"BV12425095275","room_stay_from":"2019-12-01","room_stay_to":"2019-12-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.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,89.51,0.00","subtotal":"1905.00","grand_total":"2051.50","paid_amount":"2051.51","room_type_id":"309","product_id":"1226","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24275","customer_id":"24275","source_of_creation":"PMS","reservation_created_date":"2018-12-30 19:33:16","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":"127.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3045069","reservation_id":"78547","confirmation_number":"BV12479949766","room_stay_from":"2019-11-29","room_stay_to":"2019-12-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"52.17,52.17,41.59,41.59,41.59,41.61","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"270.72","grand_total":"305.91","paid_amount":"305.91","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":"82871","customer_id":"82871","source_of_creation":"PMS","reservation_created_date":"2019-06-12 19:32:32","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":"41.59","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3031658","reservation_id":"81663","confirmation_number":"BV12222054436","room_confirmation_number":"BV12461284792","room_stay_from":"2019-11-30","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"89536","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-29 17:47:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89536","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":"3033749","reservation_id":"86487","confirmation_number":"BV12296737912","room_confirmation_number":"BV12460124495","room_stay_from":"2019-12-02","room_stay_to":"2019-12-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"93231","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-31 14:59:35","reservation_modified_date_time":"2019-10-31 14:59:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93231","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":"3038663","reservation_id":"87187","confirmation_number":"BV12268083074","room_confirmation_number":"BV12499499341","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"93756","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-15 16:28:45","reservation_modified_date_time":"2019-11-15 16:28:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93756","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":"3043054","reservation_id":"67614","confirmation_number":"BV12299561518","room_confirmation_number":"BV12465243213","room_stay_from":"2019-11-30","room_stay_to":"2019-12-21","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","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":"252.00","grand_total":"284.76","paid_amount":"284.76","product_id":"1781","service_quantity":"1","customer_traveller_id":"78455","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-23 16:31:15","reservation_modified_date_time":"2019-11-30 16:40:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78455","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":"3043090","reservation_id":"64834","confirmation_number":"BV12253198519","room_confirmation_number":"BV12425095275","room_stay_from":"2019-12-01","room_stay_to":"2019-12-16","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","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":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24275","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-30 19:33:16","reservation_modified_date_time":"2019-11-30 19:16:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24275","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":"3043491","reservation_id":"83988","confirmation_number":"BV12241884525","room_confirmation_number":"BV12459674359","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"34245","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-12 19:35:17","reservation_modified_date_time":"2019-12-02 01:24:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"34245","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":"3028999","reservation_id":"85726","confirmation_number":"BV12223846144","room_confirmation_number":"BV12428684881","room_stay_from":"2019-12-02","room_stay_to":"2019-12-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":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-16 16:46:13","reservation_modified_date_time":"2019-10-16 16:46:13","customer_id":"92751","parentCustTravId":"92751","customer_traveller_id":"92751","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#20","deltaChange":0,"changedComment":"","currentDayPrice":12,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_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":3,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_non_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[{"room_stay_id":"3043433","reservation_id":"82244","confirmation_number":"BP12579693750","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00","nightly_discount":"0.00,0.00","subtotal":"188.00","grand_total":"212.44","paid_amount":"212.44","room_type_id":"301","product_id":"1136","siteminder_id":"ZOO-5384-3907-8153","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":"89959","customer_id":"89959","source_of_creation":"Travelzoo","reservation_created_date":"2019-08-08 11:35:10","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3042203","reservation_id":"87601","confirmation_number":"BP12540646685","room_stay_from":"2019-12-02","room_stay_to":"2019-12-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"54.97,54.97","nightly_discount":"0,0","subtotal":"109.94","grand_total":"124.24","paid_amount":"124.24","room_type_id":"295","product_id":"1129","siteminder_id":"HWR-301341577","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":"94102","customer_id":"94102","source_of_creation":"Hotwire","reservation_created_date":"2019-11-28 19:15:10","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"54.97","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3015407","reservation_id":"83452","confirmation_number":"BP12584193156","room_stay_from":"2019-11-30","room_stay_to":"2019-12-07","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"68.80,52.80,52.80,52.80,52.80,52.80,68.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"401.60","grand_total":"453.81","paid_amount":"453.81","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":"90777","customer_id":"90777","source_of_creation":"FE","reservation_created_date":"2019-08-30 21:17:40","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"52.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3042410","reservation_id":"87627","confirmation_number":"BP12531704726","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.60,61.60","nightly_discount":"0.00,0.00","subtotal":"123.20","grand_total":"139.21","paid_amount":"139.21","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94121","customer_id":"94121","source_of_creation":"FE","reservation_created_date":"2019-11-29 16:33:06","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"61.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043250","reservation_id":"85169","confirmation_number":"BP12569647087","room_stay_from":"2019-11-30","room_stay_to":"2019-12-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"109.60,93.60,93.60,93.60","nightly_discount":"0.00,16.41,0.00,0.00","subtotal":"390.40","grand_total":"422.61","paid_amount":"422.61","room_type_id":"300","product_id":"1135","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":"92371","customer_id":"92371","source_of_creation":"FE","reservation_created_date":"2019-10-05 23:40:05","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"93.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043620","reservation_id":"84759","confirmation_number":"BP12541684024","room_stay_from":"2019-11-30","room_stay_to":"2019-12-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.60,93.60,93.60,93.60","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"390.40","grand_total":"441.15","paid_amount":"441.15","room_type_id":"296","product_id":"1131","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":"92066","customer_id":"92066","source_of_creation":"FE","reservation_created_date":"2019-09-27 02:24:35","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","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":"93.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3049320","reservation_id":"85673","confirmation_number":"BP12567696548","room_stay_from":"2019-12-01","room_stay_to":"2019-12-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.93,48.93,48.93,48.93,48.93,55.09,55.09,48.92","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"403.75","grand_total":"456.24","paid_amount":"456.24","room_type_id":"294","product_id":"1127","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":"92706","customer_id":"92706","source_of_creation":"PMS","reservation_created_date":"2019-10-15 01:25:51","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"2966214","reservation_id":"74833","confirmation_number":"BP12597077710","room_stay_from":"2019-12-02","room_stay_to":"2019-12-14","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.00,108.00,108.00,108.00,128.00,128.00,108.00,108.00,108.00,108.00,108.00,128.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","subtotal":"1356.00","grand_total":"1532.28","paid_amount":"122.04","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":"78981","customer_id":"78981","source_of_creation":"PMS","reservation_created_date":"2019-04-16 16:53:08","service_canceled_date_time":"2019-12-01 13:30:15","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"122.04","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3025525","reservation_id":"85169","confirmation_number":"BP12230808225","room_confirmation_number":"BP12569647087","room_stay_from":"2019-11-30","room_stay_to":"2019-12-04","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"92371","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-10-05 23:40:05","reservation_modified_date_time":"2019-10-05 23:40:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92371","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3015408","reservation_id":"83452","confirmation_number":"BP12238192992","room_confirmation_number":"BP12584193156","room_stay_from":"2019-11-30","room_stay_to":"2019-12-07","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":"90777","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-30 21:17:40","reservation_modified_date_time":"2019-08-30 21:17:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90777","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":"3042204","reservation_id":"87601","confirmation_number":"BP12223069398","room_confirmation_number":"BP12540646685","room_stay_from":"2019-12-02","room_stay_to":"2019-12-04","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":"94102","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-28 19:15:10","reservation_modified_date_time":"2019-11-28 19:15:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94102","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":"3042411","reservation_id":"87627","confirmation_number":"BP12238267583","room_confirmation_number":"BP12531704726","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"94121","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-29 16:33:06","reservation_modified_date_time":"2019-11-29 16:33:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94121","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":"3043251","reservation_id":"85169","confirmation_number":"BP12248159657","room_confirmation_number":"BP12569647087","room_stay_from":"2019-11-30","room_stay_to":"2019-12-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":"92371","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-05 23:40:05","reservation_modified_date_time":"2019-12-01 03:55:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92371","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":"3043434","reservation_id":"82244","confirmation_number":"BP12229017310","room_confirmation_number":"BP12579693750","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","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":"89959","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-08 11:35:10","reservation_modified_date_time":"2019-12-01 21:53:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89959","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":"3043621","reservation_id":"84759","confirmation_number":"BP12211106348","room_confirmation_number":"BP12541684024","room_stay_from":"2019-11-30","room_stay_to":"2019-12-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":"92066","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-27 02:24:35","reservation_modified_date_time":"2019-09-27 02:24:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92066","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":"3049321","reservation_id":"85673","confirmation_number":"BP12261674379","room_confirmation_number":"BP12567696548","room_stay_from":"2019-12-01","room_stay_to":"2019-12-09","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92706","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-15 01:25:51","reservation_modified_date_time":"2019-12-21 22:16:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92706","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"}]}],"resort_fee_non_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2019-12-02","total_rooms_exist":66,"departureCount":19,"holdBlockRooms":{"hold_room_count":"0","hold_room_bookings":[],"block_room_count":"0","block_room_bookings":[],"bundle_block_count":"0","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3013677","reservation_id":"83203","confirmation_number":"PB12332855627","room_stay_from":"2019-11-28","room_stay_to":"2019-12-07","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"62.54,70.99,70.99,62.54,62.54,62.54,62.54,62.54,70.99","nightly_discount":"0,0,0,0,0,0,0,0,0","subtotal":"588.21","grand_total":"664.67","paid_amount":"664.67","room_type_id":"289","product_id":"1107","siteminder_id":"EXP-1329075429","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"70.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90601","customer_id":"90601","source_of_creation":"Expedia","reservation_created_date":"2019-08-25 15:17:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"62.54","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":"3019169","reservation_id":"83224","confirmation_number":"PB12341551363","room_stay_from":"2019-12-02","room_stay_to":"2019-12-05","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"71.81,71.81,71.81","nightly_discount":"0,0,0","subtotal":"215.43","grand_total":"243.44","paid_amount":"243.44","room_type_id":"289","product_id":"1100","siteminder_id":"EXP-1329317182","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90617","customer_id":"90617","source_of_creation":"Expedia","reservation_created_date":"2019-08-25 23:57:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"71.81","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3026452","reservation_id":"83760","confirmation_number":"PB12382978139","room_stay_from":"2019-11-29","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"72.48,72.48,63.53,63.53","nightly_discount":"0,0,0,0","subtotal":"272.02","grand_total":"307.38","paid_amount":"307.38","room_type_id":"289","product_id":"1103","siteminder_id":"EXP-1338034106","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":"91117","customer_id":"91117","source_of_creation":"Expedia","reservation_created_date":"2019-09-08 00:41:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"63.53","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3031270","reservation_id":"84703","confirmation_number":"PB12363137062","room_stay_from":"2019-11-28","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.98,85.54,85.54,74.98,74.98","nightly_discount":"0,0,0,0,0","subtotal":"396.02","grand_total":"447.50","paid_amount":"447.50","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1349752866","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":"92024","customer_id":"92024","source_of_creation":"Expedia","reservation_created_date":"2019-09-26 00:36:10","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":"","currentDayPrice":"74.98","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3031657","reservation_id":"81663","confirmation_number":"BV12461284792","room_stay_from":"2019-11-30","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"92.31,67.54,67.54","nightly_discount":"0,0,0","subtotal":"227.39","grand_total":"256.95","paid_amount":"256.95","room_type_id":"308","product_id":"1225","siteminder_id":"EXP-1310627501","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":"89536","customer_id":"89536","source_of_creation":"Expedia","reservation_created_date":"2019-07-29 17:47:09","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"49.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.54","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":"3034451","reservation_id":"86582","confirmation_number":"PB12343987981","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"66.61","nightly_discount":"0","subtotal":"66.61","grand_total":"75.27","paid_amount":"75.27","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1373020099","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":"93296","customer_id":"93296","source_of_creation":"Expedia","reservation_created_date":"2019-11-02 15:44:10","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":"66.61","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":"3035207","reservation_id":"86694","confirmation_number":"PB12350103105","room_stay_from":"2019-11-30","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"116.2,86.22,86.22","nightly_discount":"0,0,0","subtotal":"288.64","grand_total":"326.16","paid_amount":"326.16","room_type_id":"289","product_id":"1098","siteminder_id":"EXP-1374535639","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93371","customer_id":"93371","source_of_creation":"Expedia","reservation_created_date":"2019-11-05 05:10:06","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":"","currentDayPrice":"86.22","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":"3040140","reservation_id":"87369","confirmation_number":"PB12399807962","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"3","nightly_price":"76.11","nightly_discount":"0","subtotal":"76.11","grand_total":"86.01","paid_amount":"86.01","room_type_id":"289","product_id":"1104","siteminder_id":"EXP-1383841137","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93919","customer_id":"93919","source_of_creation":"Expedia","reservation_created_date":"2019-11-21 03:23:05","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":"76.11","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":"3041298","reservation_id":"87489","confirmation_number":"PB12354904723","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.73,71.73","nightly_discount":"0,0","subtotal":"143.46","grand_total":"162.11","paid_amount":"162.11","room_type_id":"289","product_id":"1093","siteminder_id":"EXP-1385178057","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":"94016","customer_id":"94016","source_of_creation":"Expedia","reservation_created_date":"2019-11-25 01:03:05","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":"71.73","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":"3043411","reservation_id":"82087","confirmation_number":"PB12383768921","room_stay_from":"2019-12-01","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"59.94,59.94,59.94,59.94,59.94","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"299.70","grand_total":"338.66","paid_amount":"338.66","room_type_id":"289","product_id":"1094","siteminder_id":"EXP-1315659015","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89846","customer_id":"89846","source_of_creation":"Expedia","reservation_created_date":"2019-08-05 20:07:11","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":"59.94","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3044281","reservation_id":"78400","confirmation_number":"PB12382859506","room_stay_from":"2019-11-30","room_stay_to":"2019-12-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"49.64,42.90,42.90,42.90,42.90,42.90,49.64","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"313.78","grand_total":"354.57","paid_amount":"354.57","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1274800229","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":"87470","customer_id":"87470","source_of_creation":"Expedia","reservation_created_date":"2019-06-10 08:28:07","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"42.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"3030284","reservation_id":"85940","confirmation_number":"PB12363615570","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"45.18,45.18","nightly_discount":"0,0","subtotal":"90.36","grand_total":"102.11","paid_amount":"102.11","room_type_id":"292","product_id":"1120","siteminder_id":"HTN-104697643-3J4D9Q","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":"92864","customer_id":"92864","source_of_creation":"HotelTonight","reservation_created_date":"2019-10-19 17:19:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"45.18","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"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[{"room_stay_id":"3043433","reservation_id":"82244","confirmation_number":"BP12579693750","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00","nightly_discount":"0.00,0.00","subtotal":"188.00","grand_total":"212.44","paid_amount":"212.44","room_type_id":"301","product_id":"1136","siteminder_id":"ZOO-5384-3907-8153","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":"89959","customer_id":"89959","source_of_creation":"Travelzoo","reservation_created_date":"2019-08-08 11:35:10","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3037507","reservation_id":"87039","confirmation_number":"PB12368915996","room_stay_from":"2019-12-02","room_stay_to":"2019-12-05","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"93.12,93.12,93.12","nightly_discount":"0,0,0","subtotal":"279.36","grand_total":"364.49","paid_amount":"364.49","room_type_id":"291","product_id":"1115","siteminder_id":"ABB-HMAH2ETRTD","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"279.36","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93631","customer_id":"93631","source_of_creation":"Airbnb","reservation_created_date":"2019-11-12 05:02:10","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"39.05","commision_charges":"8.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"93.12","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3042203","reservation_id":"87601","confirmation_number":"BP12540646685","room_stay_from":"2019-12-02","room_stay_to":"2019-12-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"54.97,54.97","nightly_discount":"0,0","subtotal":"109.94","grand_total":"124.24","paid_amount":"124.24","room_type_id":"295","product_id":"1129","siteminder_id":"HWR-301341577","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":"94102","customer_id":"94102","source_of_creation":"Hotwire","reservation_created_date":"2019-11-28 19:15:10","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"54.97","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3028998","reservation_id":"85726","confirmation_number":"BV12428684881","room_stay_from":"2019-12-02","room_stay_to":"2019-12-05","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"76.76,76.76,76.76","nightly_discount":"0,0,0","subtotal":"230.28","grand_total":"260.22","paid_amount":"0.00","room_type_id":"304","product_id":"1219","siteminder_id":"GCC-0001900037-a6c","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":"92751","customer_id":"92751","source_of_creation":"GuestCentric Systems","reservation_created_date":"2019-10-16 16:46:13","service_canceled_date_time":"","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":0,"changedComment":"","currentDayPrice":76.76,"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"}]}],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3040720","reservation_id":"87120","confirmation_number":"PB12321823881","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"58.22","nightly_discount":"0","subtotal":"58.22","grand_total":"65.79","paid_amount":"65.79","room_type_id":"289","product_id":"1121","siteminder_id":"AGO-291249774","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93699","customer_id":"93699","source_of_creation":"Agoda","reservation_created_date":"2019-11-14 01:46:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"58.22","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":"3040725","reservation_id":"85361","confirmation_number":"PB12373314327","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"73.68","nightly_discount":"0","subtotal":"73.68","grand_total":"83.26","paid_amount":"83.26","room_type_id":"289","product_id":"1099","siteminder_id":"AGO-252568459","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92510","customer_id":"92510","source_of_creation":"Agoda","reservation_created_date":"2019-10-09 21:15:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"73.68","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":"3043435","reservation_id":"87738","confirmation_number":"PB12368879648","room_stay_from":"2019-12-02","room_stay_to":"2019-12-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"113.04,113.04,113.04","nightly_discount":"0,0,0","subtotal":"339.12","grand_total":"383.21","paid_amount":"383.21","room_type_id":"287","product_id":"1087","siteminder_id":"AGO-294436154","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":"94185","customer_id":"94185","source_of_creation":"Agoda","reservation_created_date":"2019-12-01 22:07:06","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":"113.04","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":"3015407","reservation_id":"83452","confirmation_number":"BP12584193156","room_stay_from":"2019-11-30","room_stay_to":"2019-12-07","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"68.80,52.80,52.80,52.80,52.80,52.80,68.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"401.60","grand_total":"453.81","paid_amount":"453.81","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":"90777","customer_id":"90777","source_of_creation":"FE","reservation_created_date":"2019-08-30 21:17:40","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"52.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3031819","reservation_id":"86125","confirmation_number":"PB12362093485","room_stay_from":"2019-12-02","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"100.00,100.00,100.00,100.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"400.00","grand_total":"452.00","paid_amount":"452.00","room_type_id":"288","product_id":"1091","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":"92986","customer_id":"92986","source_of_creation":"FE","reservation_created_date":"2019-10-23 15:29:45","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3033748","reservation_id":"86487","confirmation_number":"BV12460124495","room_stay_from":"2019-12-02","room_stay_to":"2019-12-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.20,75.20,75.20,75.20,91.20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"392.00","grand_total":"442.96","paid_amount":"442.96","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93231","customer_id":"93231","source_of_creation":"FE","reservation_created_date":"2019-10-31 14:59:35","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"75.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":"3038662","reservation_id":"87187","confirmation_number":"BV12499499341","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.80,80.80","nightly_discount":"0.00,0.00","subtotal":"161.60","grand_total":"182.61","paid_amount":"182.61","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":"93756","customer_id":"93756","source_of_creation":"FE","reservation_created_date":"2019-11-15 16:28:45","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":"80.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3042410","reservation_id":"87627","confirmation_number":"BP12531704726","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"61.60,61.60","nightly_discount":"0.00,0.00","subtotal":"123.20","grand_total":"139.21","paid_amount":"139.21","room_type_id":"298","product_id":"1133","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94121","customer_id":"94121","source_of_creation":"FE","reservation_created_date":"2019-11-29 16:33:06","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"61.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043250","reservation_id":"85169","confirmation_number":"BP12569647087","room_stay_from":"2019-11-30","room_stay_to":"2019-12-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"109.60,93.60,93.60,93.60","nightly_discount":"0.00,16.41,0.00,0.00","subtotal":"390.40","grand_total":"422.61","paid_amount":"422.61","room_type_id":"300","product_id":"1135","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":"92371","customer_id":"92371","source_of_creation":"FE","reservation_created_date":"2019-10-05 23:40:05","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"93.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043490","reservation_id":"83988","confirmation_number":"BV12459674359","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.20,67.20","nightly_discount":"0.00,4.48,0.00","subtotal":"134.40","grand_total":"146.81","paid_amount":"146.81","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":"34245","customer_id":"34245","source_of_creation":"FE","reservation_created_date":"2019-09-12 19:35:17","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":"67.20","currentDayDiscount":"4.48","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043620","reservation_id":"84759","confirmation_number":"BP12541684024","room_stay_from":"2019-11-30","room_stay_to":"2019-12-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.60,93.60,93.60,93.60","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"390.40","grand_total":"441.15","paid_amount":"441.15","room_type_id":"296","product_id":"1131","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":"92066","customer_id":"92066","source_of_creation":"FE","reservation_created_date":"2019-09-27 02:24:35","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","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":"93.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"2989177","reservation_id":"78852","confirmation_number":"PB12318182402","room_stay_from":"2019-12-01","room_stay_to":"2019-12-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"68.80,68.80,68.80,68.80,68.80,84.80,84.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"513.60","grand_total":"580.37","paid_amount":"580.37","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":"87795","customer_id":"87795","source_of_creation":"PMS","reservation_created_date":"2019-06-17 18:21:39","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"68.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3029161","reservation_id":"85740","confirmation_number":"PB12330974731","room_stay_from":"2019-11-30","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.48,74.40,74.40,74.40,74.40,74.40","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"480.48","grand_total":"542.94","paid_amount":"542.94","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":"92762","customer_id":"92762","source_of_creation":"PMS","reservation_created_date":"2019-10-16 20:13:13","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":"","currentDayPrice":"74.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3040723","reservation_id":"85526","confirmation_number":"PB12398276301","room_stay_from":"2019-12-02","room_stay_to":"2019-12-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"74.90,74.90","nightly_discount":"0.00,0.00","subtotal":"149.80","grand_total":"169.28","paid_amount":"169.28","room_type_id":"289","product_id":"1111","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92605","customer_id":"92605","source_of_creation":"PMS","reservation_created_date":"2019-10-12 14:29:04","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"74.90","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3042098","reservation_id":"73943","confirmation_number":"PB12378677631","room_stay_from":"2019-11-27","room_stay_to":"2019-12-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"170.00,170.00,190.00,190.00,139.00,139.00,139.00,139.00,139.00,159.00,159.00,139.00,139.00,139.00,139.00,139.00,159.00,159.00,139.00,139.00,139.00,139.00,139.00,159.00,159.00,139.00,139.00,139.00,139.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,85.64,139.00","subtotal":"4315.00","grand_total":"4622.11","paid_amount":"4622.11","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"26350","customer_id":"26350","source_of_creation":"PMS","reservation_created_date":"2019-04-03 17:40:38","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3042100","reservation_id":"87577","confirmation_number":"PB12364899071","room_stay_from":"2019-12-02","room_stay_to":"2019-12-04","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"80.00,80.00","nightly_discount":"0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","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":"94084","customer_id":"94084","source_of_creation":"PMS","reservation_created_date":"2019-11-28 00:52:44","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":"80.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043053","reservation_id":"67614","confirmation_number":"BV12465243213","room_stay_from":"2019-11-30","room_stay_to":"2019-12-21","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,65.00,65.00,65.00,65.00,65.00,115.00,115.00,65.00,65.00,65.00,65.00,65.00,115.00,115.00,65.00,65.00,65.00,65.00,65.00,115.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,101.82,0.00","subtotal":"1665.00","grand_total":"1766.39","paid_amount":"1766.39","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"78455","customer_id":"78455","source_of_creation":"PMS","reservation_created_date":"2019-01-23 16:31:15","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"65.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043089","reservation_id":"64834","confirmation_number":"BV12425095275","room_stay_from":"2019-12-01","room_stay_to":"2019-12-16","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.00,127.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,89.51,0.00","subtotal":"1905.00","grand_total":"2051.50","paid_amount":"2051.51","room_type_id":"309","product_id":"1226","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":null,"negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24275","customer_id":"24275","source_of_creation":"PMS","reservation_created_date":"2018-12-30 19:33:16","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":"127.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043191","reservation_id":"77131","confirmation_number":"PB12319800396","room_stay_from":"2019-11-30","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.40,74.40,74.40,74.40,74.40,74.40","nightly_discount":"19.80,0.00,0.00,0.00,0.00,0.00","subtotal":"462.40","grand_total":"500.14","paid_amount":"500.14","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"34185","customer_id":"34185","source_of_creation":"PMS","reservation_created_date":"2019-05-22 21:04:51","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":"74.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043625","reservation_id":"87786","confirmation_number":"PB12367943197","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.80","nightly_discount":"0.00","subtotal":"96.80","grand_total":"109.39","paid_amount":"109.39","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94227","customer_id":"94227","source_of_creation":"PMS","reservation_created_date":"2019-12-02 22:22:24","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"96.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3043658","reservation_id":"87781","confirmation_number":"PB12338701168","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.79","nightly_discount":"0.00","subtotal":"96.79","grand_total":"109.38","paid_amount":"109.38","room_type_id":"291","product_id":"1114","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"70580","customer_id":"70580","source_of_creation":"PMS","reservation_created_date":"2019-12-02 19:48:12","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":"96.79","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3044301","reservation_id":"61846","confirmation_number":"PB12391957014","room_stay_from":"2019-10-28","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00,95.00","nightly_discount":"79.80,79.80,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,83.00,83.00,83.00,83.00,83.00","subtotal":"3705.00","grand_total":"3537.35","paid_amount":"3537.35","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":"23454","customer_id":"23454","source_of_creation":"PMS","reservation_created_date":"2018-11-30 00:04:47","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":"95.00","currentDayDiscount":"83.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3045069","reservation_id":"78547","confirmation_number":"BV12479949766","room_stay_from":"2019-11-29","room_stay_to":"2019-12-05","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"52.17,52.17,41.59,41.59,41.59,41.61","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"270.72","grand_total":"305.91","paid_amount":"305.91","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":"82871","customer_id":"82871","source_of_creation":"PMS","reservation_created_date":"2019-06-12 19:32:32","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":"41.59","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3045122","reservation_id":"84171","confirmation_number":"PB12310411466","room_stay_from":"2019-12-02","room_stay_to":"2019-12-06","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.65,48.65,48.65,48.64","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"194.59","grand_total":"219.89","paid_amount":"219.89","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":"91664","customer_id":"91664","source_of_creation":"PMS","reservation_created_date":"2019-09-15 23:17:10","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":"48.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3049320","reservation_id":"85673","confirmation_number":"BP12567696548","room_stay_from":"2019-12-01","room_stay_to":"2019-12-09","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"48.93,48.93,48.93,48.93,48.93,55.09,55.09,48.92","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"403.75","grand_total":"456.24","paid_amount":"456.24","room_type_id":"294","product_id":"1127","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":"92706","customer_id":"92706","source_of_creation":"PMS","reservation_created_date":"2019-10-15 01:25:51","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"48.93","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"2966214","reservation_id":"74833","confirmation_number":"BP12597077710","room_stay_from":"2019-12-02","room_stay_to":"2019-12-14","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.00,108.00,108.00,108.00,128.00,128.00,108.00,108.00,108.00,108.00,108.00,128.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","subtotal":"1356.00","grand_total":"1532.28","paid_amount":"122.04","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":"78981","customer_id":"78981","source_of_creation":"PMS","reservation_created_date":"2019-04-16 16:53:08","service_canceled_date_time":"2019-12-01 13:30:15","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"122.04","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3013678","reservation_id":"83203","confirmation_number":"PB12248751103","room_confirmation_number":"PB12332855627","room_stay_from":"2019-11-28","room_stay_to":"2019-12-07","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0","subtotal":"90.00","grand_total":"101.70","paid_amount":"101.70","product_id":"1780","service_quantity":"1","customer_traveller_id":"90601","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-08-25 15:17:13","reservation_modified_date_time":"2019-08-25 15:17:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90601","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"}]},{"room_stay_id":"3019170","reservation_id":"83224","confirmation_number":"PB12265802538","room_confirmation_number":"PB12341551363","room_stay_from":"2019-12-02","room_stay_to":"2019-12-05","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"90617","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-09-14 16:11:59","reservation_modified_date_time":"2019-09-14 16:11:59","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90617","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":"3025525","reservation_id":"85169","confirmation_number":"BP12230808225","room_confirmation_number":"BP12569647087","room_stay_from":"2019-11-30","room_stay_to":"2019-12-04","room_stay_status":"Active","nightly_price":"10.00,10.00,10.00,10.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"92371","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-10-05 23:40:05","reservation_modified_date_time":"2019-10-05 23:40:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92371","canceled_nights_data":"","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3031820","reservation_id":"86125","confirmation_number":"PB12229193844","room_confirmation_number":"PB12362093485","room_stay_from":"2019-12-02","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"10,10,10,10","nightly_discount":"0.00,0,0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"92986","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-10-23 17:09:59","reservation_modified_date_time":"2019-10-23 17:09:59","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92986","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"}]},{"room_stay_id":"3035208","reservation_id":"86694","confirmation_number":"PB12281125077","room_confirmation_number":"PB12350103105","room_stay_from":"2019-11-30","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"10,10,10","nightly_discount":"0.00,0.00,0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"93371","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-11-05 05:10:06","reservation_modified_date_time":"2019-11-05 05:10:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93371","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"}]},{"room_stay_id":"3040141","reservation_id":"87369","confirmation_number":"PB12254122120","room_confirmation_number":"PB12399807962","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"40","nightly_discount":"0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"93919","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2019-11-21 03:23:05","reservation_modified_date_time":"2019-11-21 03:23:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93919","canceled_nights_data":"","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3040721","reservation_id":"87120","confirmation_number":"PB12211294961","room_confirmation_number":"PB12321823881","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"93699","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-11-23 15:58:08","reservation_modified_date_time":"2019-11-23 15:58:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93699","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"}]},{"room_stay_id":"3040726","reservation_id":"85361","confirmation_number":"PB12261644393","room_confirmation_number":"PB12373314327","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"92510","product_attribute_values":"extra_person#&#10","reservation_created_date":"2019-11-23 16:04:35","reservation_modified_date_time":"2019-11-23 16:04:35","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92510","canceled_nights_data":"","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"2989178","reservation_id":"78852","confirmation_number":"PB12219433659","room_confirmation_number":"PB12318182402","room_stay_from":"2019-12-01","room_stay_to":"2019-12-08","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":"87795","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-06-17 18:21:39","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87795","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":"3013679","reservation_id":"83203","confirmation_number":"PB12244847104","room_confirmation_number":"PB12332855627","room_stay_from":"2019-11-28","room_stay_to":"2019-12-07","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"90601","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-25 15:17:13","reservation_modified_date_time":"2019-08-25 15:17:13","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90601","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":"3015408","reservation_id":"83452","confirmation_number":"BP12238192992","room_confirmation_number":"BP12584193156","room_stay_from":"2019-11-30","room_stay_to":"2019-12-07","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":"90777","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-08-30 21:17:40","reservation_modified_date_time":"2019-08-30 21:17:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90777","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":"3019171","reservation_id":"83224","confirmation_number":"PB12255317444","room_confirmation_number":"PB12341551363","room_stay_from":"2019-12-02","room_stay_to":"2019-12-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":"90617","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-25 23:57:06","reservation_modified_date_time":"2019-08-25 23:57:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90617","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":"3026453","reservation_id":"83760","confirmation_number":"PB12247073638","room_confirmation_number":"PB12382978139","room_stay_from":"2019-11-29","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"91117","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-08 00:41:10","reservation_modified_date_time":"2019-09-08 00:41:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91117","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":"3029162","reservation_id":"85740","confirmation_number":"PB12285584212","room_confirmation_number":"PB12330974731","room_stay_from":"2019-11-30","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"92762","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-16 20:13:13","reservation_modified_date_time":"2019-10-16 20:13:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92762","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":"3030285","reservation_id":"85940","confirmation_number":"PB12216500364","room_confirmation_number":"PB12363615570","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","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":"92864","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-19 17:19:09","reservation_modified_date_time":"2019-10-19 17:19:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92864","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":"3031271","reservation_id":"84703","confirmation_number":"PB12236450818","room_confirmation_number":"PB12363137062","room_stay_from":"2019-11-28","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0,0,0","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92024","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-26 00:36:10","reservation_modified_date_time":"2019-09-26 00:36:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92024","canceled_nights_data":"","currentDayPrice":"20.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":"3031658","reservation_id":"81663","confirmation_number":"BV12222054436","room_confirmation_number":"BV12461284792","room_stay_from":"2019-11-30","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"89536","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-07-29 17:47:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89536","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":"3031821","reservation_id":"86125","confirmation_number":"PB12241903499","room_confirmation_number":"PB12362093485","room_stay_from":"2019-12-02","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"92986","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-23 15:29:45","reservation_modified_date_time":"2019-10-23 15:29:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92986","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":"3033749","reservation_id":"86487","confirmation_number":"BV12296737912","room_confirmation_number":"BV12460124495","room_stay_from":"2019-12-02","room_stay_to":"2019-12-07","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"93231","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-31 14:59:35","reservation_modified_date_time":"2019-10-31 14:59:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93231","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":"3034452","reservation_id":"86582","confirmation_number":"PB12219592405","room_confirmation_number":"PB12343987981","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"93296","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-02 15:44:10","reservation_modified_date_time":"2019-11-02 15:44:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93296","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":"3035209","reservation_id":"86694","confirmation_number":"PB12229084763","room_confirmation_number":"PB12350103105","room_stay_from":"2019-11-30","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"93371","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-05 05:10:06","reservation_modified_date_time":"2019-11-05 05:10:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93371","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":"3037508","reservation_id":"87039","confirmation_number":"PB12238547401","room_confirmation_number":"PB12368915996","room_stay_from":"2019-12-02","room_stay_to":"2019-12-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":"93631","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-12 05:02:10","reservation_modified_date_time":"2019-11-12 05:02:10","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93631","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"3038663","reservation_id":"87187","confirmation_number":"BV12268083074","room_confirmation_number":"BV12499499341","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"93756","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-15 16:28:45","reservation_modified_date_time":"2019-11-15 16:28:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93756","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":"3040142","reservation_id":"87369","confirmation_number":"PB12271174181","room_confirmation_number":"PB12399807962","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"93919","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-21 03:23:05","reservation_modified_date_time":"2019-11-21 03:23:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93919","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":"3040722","reservation_id":"87120","confirmation_number":"PB12275429728","room_confirmation_number":"PB12321823881","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"93699","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-14 01:46:09","reservation_modified_date_time":"2019-11-14 01:46:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"93699","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":"3040724","reservation_id":"85526","confirmation_number":"PB12249501960","room_confirmation_number":"PB12398276301","room_stay_from":"2019-12-02","room_stay_to":"2019-12-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":"92605","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-12 14:29:04","reservation_modified_date_time":"2019-10-12 14:29:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92605","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":"3040727","reservation_id":"85361","confirmation_number":"PB12276534080","room_confirmation_number":"PB12373314327","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"92510","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-10-09 21:15:09","reservation_modified_date_time":"2019-10-09 21:15:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92510","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":"3041299","reservation_id":"87489","confirmation_number":"PB12235662329","room_confirmation_number":"PB12354904723","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","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":"94016","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-25 01:03:05","reservation_modified_date_time":"2019-11-25 01:03:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94016","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":"3042099","reservation_id":"73943","confirmation_number":"PB12239672735","room_confirmation_number":"PB12378677631","room_stay_from":"2019-11-27","room_stay_to":"2019-12-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"348.00","grand_total":"393.24","paid_amount":"393.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"26350","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-04-03 17:40:38","reservation_modified_date_time":"2019-11-28 00:33:33","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26350","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":"3042101","reservation_id":"87577","confirmation_number":"PB12247841766","room_confirmation_number":"PB12364899071","room_stay_from":"2019-12-02","room_stay_to":"2019-12-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":"94084","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-28 00:52:44","reservation_modified_date_time":"2019-11-28 00:52:44","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94084","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":"3042204","reservation_id":"87601","confirmation_number":"BP12223069398","room_confirmation_number":"BP12540646685","room_stay_from":"2019-12-02","room_stay_to":"2019-12-04","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":"94102","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-11-28 19:15:10","reservation_modified_date_time":"2019-11-28 19:15:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94102","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":"3042411","reservation_id":"87627","confirmation_number":"BP12238267583","room_confirmation_number":"BP12531704726","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"94121","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-29 16:33:06","reservation_modified_date_time":"2019-11-29 16:33:06","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94121","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":"3043054","reservation_id":"67614","confirmation_number":"BV12299561518","room_confirmation_number":"BV12465243213","room_stay_from":"2019-11-30","room_stay_to":"2019-12-21","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","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":"252.00","grand_total":"284.76","paid_amount":"284.76","product_id":"1781","service_quantity":"1","customer_traveller_id":"78455","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-23 16:31:15","reservation_modified_date_time":"2019-11-30 16:40:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"78455","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":"3043090","reservation_id":"64834","confirmation_number":"BV12253198519","room_confirmation_number":"BV12425095275","room_stay_from":"2019-12-01","room_stay_to":"2019-12-16","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","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":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24275","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-12-30 19:33:16","reservation_modified_date_time":"2019-11-30 19:16:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24275","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":"3043192","reservation_id":"77131","confirmation_number":"PB12228151905","room_confirmation_number":"PB12319800396","room_stay_from":"2019-11-30","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"34185","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-22 21:04:51","reservation_modified_date_time":"2019-12-01 00:06:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"34185","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":"3043251","reservation_id":"85169","confirmation_number":"BP12248159657","room_confirmation_number":"BP12569647087","room_stay_from":"2019-11-30","room_stay_to":"2019-12-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":"92371","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-05 23:40:05","reservation_modified_date_time":"2019-12-01 03:55:48","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92371","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":"3043414","reservation_id":"82087","confirmation_number":"PB12221962485","room_confirmation_number":"PB12383768921","room_stay_from":"2019-12-01","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"89846","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-05 20:07:11","reservation_modified_date_time":"2019-12-01 20:18:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89846","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":"3043434","reservation_id":"82244","confirmation_number":"BP12229017310","room_confirmation_number":"BP12579693750","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","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":"89959","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-08-08 11:35:10","reservation_modified_date_time":"2019-12-01 21:53:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89959","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":"3043436","reservation_id":"87738","confirmation_number":"PB12237718319","room_confirmation_number":"PB12368879648","room_stay_from":"2019-12-02","room_stay_to":"2019-12-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":"94185","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-01 22:07:06","reservation_modified_date_time":"2019-12-01 22:07:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94185","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":"3043491","reservation_id":"83988","confirmation_number":"BV12241884525","room_confirmation_number":"BV12459674359","room_stay_from":"2019-12-01","room_stay_to":"2019-12-03","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"34245","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-12 19:35:17","reservation_modified_date_time":"2019-12-02 01:24:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"34245","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":"3043621","reservation_id":"84759","confirmation_number":"BP12211106348","room_confirmation_number":"BP12541684024","room_stay_from":"2019-11-30","room_stay_to":"2019-12-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":"92066","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-27 02:24:35","reservation_modified_date_time":"2019-09-27 02:24:35","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92066","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":"3043626","reservation_id":"87786","confirmation_number":"PB12286840770","room_confirmation_number":"PB12367943197","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","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":"94227","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-02 22:22:24","reservation_modified_date_time":"2019-12-02 22:22:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94227","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":"3043659","reservation_id":"87781","confirmation_number":"PB12261457045","room_confirmation_number":"PB12338701168","room_stay_from":"2019-12-02","room_stay_to":"2019-12-03","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":"70580","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-02 19:48:12","reservation_modified_date_time":"2019-12-02 19:48:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"70580","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":"3044282","reservation_id":"78400","confirmation_number":"PB12276435391","room_confirmation_number":"PB12382859506","room_stay_from":"2019-11-30","room_stay_to":"2019-12-07","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"87470","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-06-10 08:28:07","reservation_modified_date_time":"2019-12-05 15:11:00","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87470","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":"3044302","reservation_id":"61846","confirmation_number":"PB12312856665","room_confirmation_number":"PB12391957014","room_stay_from":"2019-10-28","room_stay_to":"2019-12-06","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,0.00,0.00,0.00,0.00,0.00,0.00,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,0.00,0.00,0.00,0.00,0.00,0.00,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":"23454","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2018-11-30 00:04:47","reservation_modified_date_time":"2019-12-05 15:30:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23454","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":"3045123","reservation_id":"84171","confirmation_number":"PB12272992740","room_confirmation_number":"PB12310411466","room_stay_from":"2019-12-02","room_stay_to":"2019-12-06","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00","nightly_discount":"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":"91664","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-15 23:17:10","reservation_modified_date_time":"2019-12-07 18:32:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"91664","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":"3049321","reservation_id":"85673","confirmation_number":"BP12261674379","room_confirmation_number":"BP12567696548","room_stay_from":"2019-12-01","room_stay_to":"2019-12-09","room_stay_status":"Active","nightly_price":"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","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"92706","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-15 01:25:51","reservation_modified_date_time":"2019-12-21 22:16:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92706","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":"3028999","reservation_id":"85726","confirmation_number":"BV12223846144","room_confirmation_number":"BV12428684881","room_stay_from":"2019-12-02","room_stay_to":"2019-12-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":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-10-16 16:46:13","reservation_modified_date_time":"2019-10-16 16:46:13","customer_id":"92751","parentCustTravId":"92751","customer_traveller_id":"92751","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#20","deltaChange":0,"changedComment":"","currentDayPrice":12,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3043644","reservation_id":"87791","confirmation_number":"PB12215999454","room_confirmation_number":"PB12367721695","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":"2019-12-03 02:07:01","reservation_modified_date_time":"2019-12-03 02:07:01","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":"3010138","reservation_id":"82578","confirmation_number":"PB12287218366","room_confirmation_number":"PB12348584720","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1217","service_quantity":"2","product_name":"Resort fee daily","parentTypeOfRes":"reservation","reservation_created_date":"2019-08-13 16:38:24","reservation_modified_date_time":"2019-08-13 16:38:24","customer_id":"90173","parentCustTravId":"90173","customer_traveller_id":"90173","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2019-12-02 13:36:53","canceled_nights_data":"","product_attribute_values":null,"deltaChange":-40,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"115","tax_name":"Resort Fee tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}