{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-04-04","total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":5,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"","block_room_bookings":[],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3085836","reservation_id":"93674","confirmation_number":"BV12420012592","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"118.20","nightly_discount":"0","subtotal":"118.20","grand_total":"133.56","paid_amount":"0.00","room_type_id":"287","product_id":"1090","siteminder_id":"BDC-3308300056","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":"99901","customer_id":"99901","source_of_creation":"Booking.com","reservation_created_date":"2020-04-01 02:35:08","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"24.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"118.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3085807","reservation_id":"93673","confirmation_number":"PB12364739206","room_stay_from":"2020-04-01","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.57,101.57,111.49,111.49","nightly_discount":"0,0,0,0","subtotal":"426.12","grand_total":"481.52","paid_amount":"481.52","room_type_id":"287","product_id":"1088","siteminder_id":"EXP-1659893374","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":"99907","customer_id":"99907","source_of_creation":"Expedia","reservation_created_date":"2020-03-31 23:25:04","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":"111.49","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":"3085891","reservation_id":"93679","confirmation_number":"PB12379828833","room_stay_from":"2020-04-03","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.04,90.04","nightly_discount":"0,0","subtotal":"180.08","grand_total":"203.49","paid_amount":"203.49","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1659965430","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":"99906","customer_id":"99906","source_of_creation":"Expedia","reservation_created_date":"2020-04-01 20:50:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.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"}]},{"room_stay_id":"3086094","reservation_id":"93656","confirmation_number":"PB12325140768","room_stay_from":"2020-03-30","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.67,93.67,85.16,85.16,97.25,97.25","nightly_discount":"0,0,0,0,0,0","subtotal":"552.16","grand_total":"623.94","paid_amount":"623.94","room_type_id":"289","product_id":"1101","siteminder_id":"EXP-1659709621","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":"99895","customer_id":"99895","source_of_creation":"Expedia","reservation_created_date":"2020-03-29 19:55:10","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"97.25","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":"3086125","reservation_id":"93699","confirmation_number":"PB12358853082","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"94.64,83.9","nightly_discount":"0,0","subtotal":"178.54","grand_total":"201.75","paid_amount":"201.75","room_type_id":"289","product_id":"1098","siteminder_id":"EXP-1660198865","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":"99926","customer_id":"99926","source_of_creation":"Expedia","reservation_created_date":"2020-04-04 18:10:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"32.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.64","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086135","reservation_id":"93700","confirmation_number":"PB12356586701","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.97,85.40","nightly_discount":"0,0","subtotal":"182.37","grand_total":"206.08","paid_amount":"206.08","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1660207272","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":"99928","customer_id":"99928","source_of_creation":"Expedia","reservation_created_date":"2020-04-04 20:35:08","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":"96.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3086131","reservation_id":"93701","confirmation_number":"BV12468626328","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"114.83","nightly_discount":"0","subtotal":"114.83","grand_total":"155.92","paid_amount":"155.92","room_type_id":"291","product_id":"1118","siteminder_id":"ABB-HMDRHZ5D8J","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"114.83","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99927","customer_id":"99927","source_of_creation":"Airbnb","reservation_created_date":"2020-04-04 21:47:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"18.85","commision_charges":"4.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.83","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":[],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3085883","reservation_id":"93667","confirmation_number":"PB12385116363","room_stay_from":"2020-04-03","room_stay_to":"2020-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.96,116.96,96.44","nightly_discount":"0,0,0","subtotal":"330.36","grand_total":"373.31","paid_amount":"373.31","room_type_id":"288","product_id":"1092","siteminder_id":"GCC-0004500043-064","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":"99832","customer_id":"99832","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-03-31 16:03:09","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"116.96","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3086091","reservation_id":"93682","confirmation_number":"BV12416349640","room_stay_from":"2020-04-03","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"98.64,98.64","nightly_discount":"0.00,0.00","subtotal":"197.28","grand_total":"222.93","paid_amount":"222.93","room_type_id":"291","product_id":"1116","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99909","customer_id":"99909","source_of_creation":"FE","reservation_created_date":"2020-04-02 13:25:33","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"98.64","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[{"room_stay_id":"3026953","reservation_id":"85409","confirmation_number":"PB12352123875","room_stay_from":"2020-04-04","room_stay_to":"2020-04-11","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"1","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":"416.97","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":"92552","customer_id":"92552","source_of_creation":"FE","reservation_created_date":"2019-10-10 16:28:59","service_canceled_date_time":"2020-03-18 01:05:43","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3085591","reservation_id":"93620","confirmation_number":"PB12358431438","room_stay_from":"2020-03-31","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.00,69.00,69.00,69.00,69.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"345.00","grand_total":"389.85","paid_amount":"389.85","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":"99845","customer_id":"99845","source_of_creation":"PMS","reservation_created_date":"2020-03-27 18:11:17","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":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085887","reservation_id":"93684","confirmation_number":"PB12310276085","room_stay_from":"2020-04-02","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00","nightly_discount":"0.00,0.00,0.00","subtotal":"285.00","grand_total":"322.05","paid_amount":"322.05","room_type_id":"291","product_id":"1115","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99911","customer_id":"99911","source_of_creation":"PMS","reservation_created_date":"2020-04-02 14:45:18","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086034","reservation_id":"93691","confirmation_number":"PB12323356334","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.00","nightly_discount":"0.00","subtotal":"147.00","grand_total":"166.11","paid_amount":"166.11","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99916","customer_id":"99916","source_of_creation":"PMS","reservation_created_date":"2020-04-03 14:41:24","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":"147.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085804","reservation_id":"93532","confirmation_number":"PB12362048535","room_stay_from":"2020-03-20","room_stay_to":"2020-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"170.00,170.00,170.00,145.00,145.00,145.00,99.00,99.00,99.00,99.00,99.00,99.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1984.00","grand_total":"2241.92","paid_amount":"2241.92","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99766","customer_id":"99766","source_of_creation":"PMS","reservation_created_date":"2020-03-19 21:58: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":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086096","reservation_id":"93696","confirmation_number":"PB12343917025","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.00,109.00","nightly_discount":"0.00,0.00","subtotal":"218.00","grand_total":"246.34","paid_amount":"246.34","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"PMS","reservation_created_date":"2020-04-04 13:19:21","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":"109.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086044","reservation_id":"93637","confirmation_number":"PB12394572506","room_stay_from":"2020-03-29","room_stay_to":"2020-04-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1089.00","grand_total":"1230.57","paid_amount":"1230.57","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99869","customer_id":"99869","source_of_creation":"PMS","reservation_created_date":"2020-03-28 15:45:22","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086141","reservation_id":"93643","confirmation_number":"PB12392926566","room_stay_from":"2020-04-04","room_stay_to":"2020-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"108.43,108.43,108.43,108.43,108.43,108.43","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"650.58","grand_total":"735.15","paid_amount":"735.15","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99875","customer_id":"99875","source_of_creation":"PMS","reservation_created_date":"2020-03-28 19:04:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":"108.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086082","reservation_id":"92380","confirmation_number":"BP12593858961","room_stay_from":"2020-04-04","room_stay_to":"2020-04-11","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.00,197.00,197.00,171.00,197.00,171.00,197.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1327.00","grand_total":"1499.51","paid_amount":"222.61","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98666","customer_id":"98666","source_of_creation":"PMS","reservation_created_date":"2020-02-22 21:18:07","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":"197.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086100","reservation_id":"93660","confirmation_number":"PB12342187525","room_stay_from":"2020-04-04","room_stay_to":"2020-04-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,32.58,5.00","subtotal":"658.00","grand_total":"701.08","paid_amount":"701.08","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99889","customer_id":"99889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 18:08:07","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":"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"}]},{"room_stay_id":"3086108","reservation_id":"93659","confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,69.26,5.00","subtotal":"1316.00","grand_total":"1403.16","paid_amount":"1403.16","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76889","customer_id":"76889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 17:57:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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"}]}],"pms_non_taxable":[{"room_stay_id":"3019361","reservation_id":"84108","confirmation_number":"BP12523699650","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"124.30","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":"91621","customer_id":"91621","source_of_creation":"PMS","reservation_created_date":"2019-09-15 00:03:03","service_canceled_date_time":"2020-03-24 15:49:39","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3033309","reservation_id":"86392","confirmation_number":"PB12390063280","room_stay_from":"2020-04-04","room_stay_to":"2020-04-10","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"200.00","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93154","customer_id":"93154","source_of_creation":"PMS","reservation_created_date":"2019-10-29 01:21:11","service_canceled_date_time":"2020-03-18 21:29:45","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3035472","reservation_id":"86724","confirmation_number":"PB12315466148","room_stay_from":"2020-04-04","room_stay_to":"2020-04-09","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"242.95","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":"45793","customer_id":"45793","source_of_creation":"PMS","reservation_created_date":"2019-11-05 22:52:18","service_canceled_date_time":"2020-03-25 18:37:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3067818","reservation_id":"86392","confirmation_number":"PB12374493617","room_stay_from":"2020-04-04","room_stay_to":"2020-04-10","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"200.00","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93154","customer_id":"93154","source_of_creation":"PMS","reservation_created_date":"2019-10-29 01:21:11","service_canceled_date_time":"2020-03-18 21:29:54","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","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":"3086132","reservation_id":"93701","confirmation_number":"BV12231606208","room_confirmation_number":"BV12468626328","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"20.00","paid_amount":"20.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"99927","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-04 21:49:47","reservation_modified_date_time":"2020-04-04 21:49:47","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99927","canceled_nights_data":"","currentDayPrice":"20","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":"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"}]},{"room_stay_id":"3086126","reservation_id":"93699","confirmation_number":"PB12279438142","room_confirmation_number":"PB12358853082","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"99926","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-04 20:49:24","reservation_modified_date_time":"2020-04-04 20:49:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99926","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":"3086143","reservation_id":"93643","confirmation_number":"PB12269069105","room_confirmation_number":"PB12392926566","room_stay_from":"2020-04-04","room_stay_to":"2020-04-10","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"99875","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-04 22:33:58","reservation_modified_date_time":"2020-04-04 22:33:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99875","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3085592","reservation_id":"93620","confirmation_number":"PB12276647784","room_confirmation_number":"PB12358431438","room_stay_from":"2020-03-31","room_stay_to":"2020-04-05","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":"99845","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-27 18:11:17","reservation_modified_date_time":"2020-03-31 13:07:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99845","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":"3085806","reservation_id":"93673","confirmation_number":"PB12236066983","room_confirmation_number":"PB12364739206","room_stay_from":"2020-04-01","room_stay_to":"2020-04-05","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":"99907","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-31 23:25:04","reservation_modified_date_time":"2020-04-01 21:39:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99907","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":"3085837","reservation_id":"93674","confirmation_number":"BV12248992335","room_confirmation_number":"BV12420012592","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"99901","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-01 02:35:08","reservation_modified_date_time":"2020-04-02 13:35:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99901","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":"3085888","reservation_id":"93684","confirmation_number":"PB12298225323","room_confirmation_number":"PB12310276085","room_stay_from":"2020-04-02","room_stay_to":"2020-04-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"99911","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-02 14:45:18","reservation_modified_date_time":"2020-04-02 15:37:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99911","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":"3085892","reservation_id":"93679","confirmation_number":"PB12214749448","room_confirmation_number":"PB12379828833","room_stay_from":"2020-04-03","room_stay_to":"2020-04-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"99906","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-01 20:50:08","reservation_modified_date_time":"2020-04-02 16:32:46","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99906","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":"3086035","reservation_id":"93691","confirmation_number":"PB12270358007","room_confirmation_number":"PB12323356334","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","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":"99916","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-03 14:41:24","reservation_modified_date_time":"2020-04-03 14:41:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99916","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":"3086092","reservation_id":"93682","confirmation_number":"BV12276358811","room_confirmation_number":"BV12416349640","room_stay_from":"2020-04-03","room_stay_to":"2020-04-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"99909","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-02 13:25:33","reservation_modified_date_time":"2020-04-04 13:25:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99909","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":"3086095","reservation_id":"93656","confirmation_number":"PB12227758269","room_confirmation_number":"PB12325140768","room_stay_from":"2020-03-30","room_stay_to":"2020-04-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"99895","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-29 19:55:10","reservation_modified_date_time":"2020-04-04 14:02:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99895","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086133","reservation_id":"93701","confirmation_number":"BV12224461244","room_confirmation_number":"BV12468626328","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","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":"99927","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-04 21:47:09","reservation_modified_date_time":"2020-04-04 21:49:47","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99927","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":"3085805","reservation_id":"93532","confirmation_number":"PB12235989805","room_confirmation_number":"PB12362048535","room_stay_from":"2020-03-20","room_stay_to":"2020-04-06","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","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","subtotal":"204.00","grand_total":"230.52","paid_amount":"230.52","product_id":"1781","service_quantity":"1","customer_traveller_id":"99766","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 21:58:10","reservation_modified_date_time":"2020-04-01 20:54:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99766","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":"3085884","reservation_id":"93667","confirmation_number":"PB12244642666","room_confirmation_number":"PB12385116363","room_stay_from":"2020-04-03","room_stay_to":"2020-04-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"99832","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-31 16:03:09","reservation_modified_date_time":"2020-04-02 15:09:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99832","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":"3086097","reservation_id":"93696","confirmation_number":"PB12298147413","room_confirmation_number":"PB12343917025","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"47798","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-04 13:19:21","reservation_modified_date_time":"2020-04-04 14:07:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086127","reservation_id":"93699","confirmation_number":"PB12269163005","room_confirmation_number":"PB12358853082","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"99926","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-04 18:10:07","reservation_modified_date_time":"2020-04-04 20:49:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99926","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":"3086134","reservation_id":"93700","confirmation_number":"PB12227808509","room_confirmation_number":"PB12356586701","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"99928","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-04 20:35:08","reservation_modified_date_time":"2020-04-04 22:00:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99928","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":"3086045","reservation_id":"93637","confirmation_number":"PB12243625342","room_confirmation_number":"PB12394572506","room_stay_from":"2020-03-29","room_stay_to":"2020-04-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"99869","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-28 15:45:22","reservation_modified_date_time":"2020-04-03 16:59:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99869","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":"3086144","reservation_id":"93643","confirmation_number":"PB12239750743","room_confirmation_number":"PB12392926566","room_stay_from":"2020-04-04","room_stay_to":"2020-04-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"99875","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-28 19:04:12","reservation_modified_date_time":"2020-04-04 22:34:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99875","canceled_nights_data":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086083","reservation_id":"92380","confirmation_number":"BP12279471323","room_confirmation_number":"BP12593858961","room_stay_from":"2020-04-04","room_stay_to":"2020-04-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"98666","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-22 21:18:07","reservation_modified_date_time":"2020-04-03 21:33:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98666","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":"3086101","reservation_id":"93660","confirmation_number":"PB12281158795","room_confirmation_number":"PB12342187525","room_stay_from":"2020-04-04","room_stay_to":"2020-04-11","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":"99889","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-30 18:08:07","reservation_modified_date_time":"2020-04-04 15:17:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99889","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":"3086109","reservation_id":"93659","confirmation_number":"PB12259744424","room_confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-04-18","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","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","subtotal":"168.00","grand_total":"189.84","paid_amount":"189.84","product_id":"1781","service_quantity":"1","customer_traveller_id":"76889","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-30 17:57:33","reservation_modified_date_time":"2020-04-04 16:33:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76889","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3086086","reservation_id":"93682","confirmation_number":"PB12247203717","room_confirmation_number":"BV12416349640","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1192","service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-04 13:10:31","reservation_modified_date_time":"2020-04-04 13:10:31","customer_id":"99909","parentCustTravId":"99909","customer_traveller_id":"99909","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3086088","reservation_id":"93682","confirmation_number":"PB12274904875","room_confirmation_number":"BV12416349640","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.21","grand_total":"4.50","paid_amount":"4.50","product_id":"1144","service_quantity":"1","product_name":"Aloe Lotion\/ Gel","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-04 13:10:31","reservation_modified_date_time":"2020-04-04 13:10:31","customer_id":"99909","parentCustTravId":"99909","customer_traveller_id":"99909","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"4.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3086093","reservation_id":"93682","confirmation_number":"PB12250057463","room_confirmation_number":"BV12416349640","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-04 13:10:31","reservation_modified_date_time":"2020-04-04 13:25:22","customer_id":"99909","parentCustTravId":"99909","customer_traveller_id":"99909","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3086114","reservation_id":"93656","confirmation_number":"PB12271612692","room_confirmation_number":"PB12325140768","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"18.69","grand_total":"20.00","paid_amount":"20.00","product_id":"1201","service_quantity":"1","product_name":"Sunglasses - 2 pairs","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-04 20:30:04","reservation_modified_date_time":"2020-04-04 20:30:04","customer_id":"99895","parentCustTravId":"99895","customer_traveller_id":"99895","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"18.69","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3086103","reservation_id":"93697","confirmation_number":"PB12224469489","room_confirmation_number":"PB12382754485","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.21","grand_total":"4.50","paid_amount":"4.50","product_id":null,"service_quantity":"1","product_name":"Aloe Lotion\/ Gel","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-04 16:27:23","reservation_modified_date_time":"2020-04-04 16:27:23","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":"4.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120","departureCount":5,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3085807","reservation_id":"93673","confirmation_number":"PB12364739206","room_stay_from":"2020-04-01","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"101.57,101.57,111.49,111.49","nightly_discount":"0,0,0,0","subtotal":"426.12","grand_total":"481.52","paid_amount":"481.52","room_type_id":"287","product_id":"1088","siteminder_id":"EXP-1659893374","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":"99907","customer_id":"99907","source_of_creation":"Expedia","reservation_created_date":"2020-03-31 23:25:04","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":"111.49","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":"3085891","reservation_id":"93679","confirmation_number":"PB12379828833","room_stay_from":"2020-04-03","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.04,90.04","nightly_discount":"0,0","subtotal":"180.08","grand_total":"203.49","paid_amount":"203.49","room_type_id":"286","product_id":"1086","siteminder_id":"EXP-1659965430","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":"99906","customer_id":"99906","source_of_creation":"Expedia","reservation_created_date":"2020-04-01 20:50:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.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"}]},{"room_stay_id":"3086094","reservation_id":"93656","confirmation_number":"PB12325140768","room_stay_from":"2020-03-30","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.67,93.67,85.16,85.16,97.25,97.25","nightly_discount":"0,0,0,0,0,0","subtotal":"552.16","grand_total":"623.94","paid_amount":"623.94","room_type_id":"289","product_id":"1101","siteminder_id":"EXP-1659709621","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":"99895","customer_id":"99895","source_of_creation":"Expedia","reservation_created_date":"2020-03-29 19:55:10","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":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"97.25","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":"3086125","reservation_id":"93699","confirmation_number":"PB12358853082","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"94.64,83.9","nightly_discount":"0,0","subtotal":"178.54","grand_total":"201.75","paid_amount":"201.75","room_type_id":"289","product_id":"1098","siteminder_id":"EXP-1660198865","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":"99926","customer_id":"99926","source_of_creation":"Expedia","reservation_created_date":"2020-04-04 18:10:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"32.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"94.64","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086135","reservation_id":"93700","confirmation_number":"PB12356586701","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.97,85.40","nightly_discount":"0,0","subtotal":"182.37","grand_total":"206.08","paid_amount":"206.08","room_type_id":"285","product_id":"1083","siteminder_id":"EXP-1660207272","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":"99928","customer_id":"99928","source_of_creation":"Expedia","reservation_created_date":"2020-04-04 20:35:08","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":"96.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"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3085883","reservation_id":"93667","confirmation_number":"PB12385116363","room_stay_from":"2020-04-03","room_stay_to":"2020-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"116.96,116.96,96.44","nightly_discount":"0,0,0","subtotal":"330.36","grand_total":"373.31","paid_amount":"373.31","room_type_id":"288","product_id":"1092","siteminder_id":"GCC-0004500043-064","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":"99832","customer_id":"99832","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-03-31 16:03:09","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"116.96","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_non_taxable":[{"room_stay_id":"3026953","reservation_id":"85409","confirmation_number":"PB12352123875","room_stay_from":"2020-04-04","room_stay_to":"2020-04-11","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"1","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":"416.97","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":"92552","customer_id":"92552","source_of_creation":"FE","reservation_created_date":"2019-10-10 16:28:59","service_canceled_date_time":"2020-03-18 01:05:43","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"pms_taxable":[{"room_stay_id":"3085591","reservation_id":"93620","confirmation_number":"PB12358431438","room_stay_from":"2020-03-31","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"69.00,69.00,69.00,69.00,69.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"345.00","grand_total":"389.85","paid_amount":"389.85","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":"99845","customer_id":"99845","source_of_creation":"PMS","reservation_created_date":"2020-03-27 18:11:17","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":"69.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085887","reservation_id":"93684","confirmation_number":"PB12310276085","room_stay_from":"2020-04-02","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"95.00,95.00,95.00","nightly_discount":"0.00,0.00,0.00","subtotal":"285.00","grand_total":"322.05","paid_amount":"322.05","room_type_id":"291","product_id":"1115","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99911","customer_id":"99911","source_of_creation":"PMS","reservation_created_date":"2020-04-02 14:45:18","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 206","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"95.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086034","reservation_id":"93691","confirmation_number":"PB12323356334","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.00","nightly_discount":"0.00","subtotal":"147.00","grand_total":"166.11","paid_amount":"166.11","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99916","customer_id":"99916","source_of_creation":"PMS","reservation_created_date":"2020-04-03 14:41:24","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":"147.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085804","reservation_id":"93532","confirmation_number":"PB12362048535","room_stay_from":"2020-03-20","room_stay_to":"2020-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"170.00,170.00,170.00,145.00,145.00,145.00,99.00,99.00,99.00,99.00,99.00,99.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1984.00","grand_total":"2241.92","paid_amount":"2241.92","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99766","customer_id":"99766","source_of_creation":"PMS","reservation_created_date":"2020-03-19 21:58: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":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086096","reservation_id":"93696","confirmation_number":"PB12343917025","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"109.00,109.00","nightly_discount":"0.00,0.00","subtotal":"218.00","grand_total":"246.34","paid_amount":"246.34","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"47798","customer_id":"47798","source_of_creation":"PMS","reservation_created_date":"2020-04-04 13:19:21","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":"109.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086044","reservation_id":"93637","confirmation_number":"PB12394572506","room_stay_from":"2020-03-29","room_stay_to":"2020-04-09","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1089.00","grand_total":"1230.57","paid_amount":"1230.57","room_type_id":"287","product_id":"1089","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99869","customer_id":"99869","source_of_creation":"PMS","reservation_created_date":"2020-03-28 15:45:22","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086141","reservation_id":"93643","confirmation_number":"PB12392926566","room_stay_from":"2020-04-04","room_stay_to":"2020-04-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"108.43,108.43,108.43,108.43,108.43,108.43","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"650.58","grand_total":"735.15","paid_amount":"735.15","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99875","customer_id":"99875","source_of_creation":"PMS","reservation_created_date":"2020-03-28 19:04:12","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":"108.43","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086100","reservation_id":"93660","confirmation_number":"PB12342187525","room_stay_from":"2020-04-04","room_stay_to":"2020-04-11","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,32.58,5.00","subtotal":"658.00","grand_total":"701.08","paid_amount":"701.08","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99889","customer_id":"99889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 18:08:07","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":"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"}]},{"room_stay_id":"3086108","reservation_id":"93659","confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-04-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00,94.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,69.26,5.00","subtotal":"1316.00","grand_total":"1403.16","paid_amount":"1403.16","room_type_id":"289","product_id":"1102","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"76889","customer_id":"76889","source_of_creation":"PMS","reservation_created_date":"2020-03-30 17:57:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"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"}]}],"pms_non_taxable":[{"room_stay_id":"3033309","reservation_id":"86392","confirmation_number":"PB12390063280","room_stay_from":"2020-04-04","room_stay_to":"2020-04-10","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"200.00","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93154","customer_id":"93154","source_of_creation":"PMS","reservation_created_date":"2019-10-29 01:21:11","service_canceled_date_time":"2020-03-18 21:29:45","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3035472","reservation_id":"86724","confirmation_number":"PB12315466148","room_stay_from":"2020-04-04","room_stay_to":"2020-04-09","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"242.95","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":"45793","customer_id":"45793","source_of_creation":"PMS","reservation_created_date":"2019-11-05 22:52:18","service_canceled_date_time":"2020-03-25 18:37:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]},{"room_stay_id":"3067818","reservation_id":"86392","confirmation_number":"PB12374493617","room_stay_from":"2020-04-04","room_stay_to":"2020-04-10","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"200.00","room_type_id":"289","product_id":"1096","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"93154","customer_id":"93154","source_of_creation":"PMS","reservation_created_date":"2019-10-29 01:21:11","service_canceled_date_time":"2020-03-18 21:29:54","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","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":"3086126","reservation_id":"93699","confirmation_number":"PB12279438142","room_confirmation_number":"PB12358853082","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"99926","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-04 20:49:24","reservation_modified_date_time":"2020-04-04 20:49:24","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99926","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":"3086143","reservation_id":"93643","confirmation_number":"PB12269069105","room_confirmation_number":"PB12392926566","room_stay_from":"2020-04-04","room_stay_to":"2020-04-10","room_stay_status":"Active","nightly_price":"10,10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"99875","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-04 22:33:58","reservation_modified_date_time":"2020-04-04 22:33:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99875","canceled_nights_data":"","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3085592","reservation_id":"93620","confirmation_number":"PB12276647784","room_confirmation_number":"PB12358431438","room_stay_from":"2020-03-31","room_stay_to":"2020-04-05","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":"99845","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-27 18:11:17","reservation_modified_date_time":"2020-03-31 13:07:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99845","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":"3085806","reservation_id":"93673","confirmation_number":"PB12236066983","room_confirmation_number":"PB12364739206","room_stay_from":"2020-04-01","room_stay_to":"2020-04-05","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":"99907","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-31 23:25:04","reservation_modified_date_time":"2020-04-01 21:39:16","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99907","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":"3085888","reservation_id":"93684","confirmation_number":"PB12298225323","room_confirmation_number":"PB12310276085","room_stay_from":"2020-04-02","room_stay_to":"2020-04-05","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"99911","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-02 14:45:18","reservation_modified_date_time":"2020-04-02 15:37:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99911","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":"3085892","reservation_id":"93679","confirmation_number":"PB12214749448","room_confirmation_number":"PB12379828833","room_stay_from":"2020-04-03","room_stay_to":"2020-04-05","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"99906","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-01 20:50:08","reservation_modified_date_time":"2020-04-02 16:32:46","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99906","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":"3086035","reservation_id":"93691","confirmation_number":"PB12270358007","room_confirmation_number":"PB12323356334","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","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":"99916","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-03 14:41:24","reservation_modified_date_time":"2020-04-03 14:41:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99916","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":"3086095","reservation_id":"93656","confirmation_number":"PB12227758269","room_confirmation_number":"PB12325140768","room_stay_from":"2020-03-30","room_stay_to":"2020-04-05","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"99895","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-29 19:55:10","reservation_modified_date_time":"2020-04-04 14:02:56","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99895","canceled_nights_data":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3085805","reservation_id":"93532","confirmation_number":"PB12235989805","room_confirmation_number":"PB12362048535","room_stay_from":"2020-03-20","room_stay_to":"2020-04-06","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","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","subtotal":"204.00","grand_total":"230.52","paid_amount":"230.52","product_id":"1781","service_quantity":"1","customer_traveller_id":"99766","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-19 21:58:10","reservation_modified_date_time":"2020-04-01 20:54:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99766","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":"3085884","reservation_id":"93667","confirmation_number":"PB12244642666","room_confirmation_number":"PB12385116363","room_stay_from":"2020-04-03","room_stay_to":"2020-04-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"99832","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-03-31 16:03:09","reservation_modified_date_time":"2020-04-02 15:09:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99832","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":"3086097","reservation_id":"93696","confirmation_number":"PB12298147413","room_confirmation_number":"PB12343917025","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"47798","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-04 13:19:21","reservation_modified_date_time":"2020-04-04 14:07:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"47798","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086127","reservation_id":"93699","confirmation_number":"PB12269163005","room_confirmation_number":"PB12358853082","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"99926","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-04 18:10:07","reservation_modified_date_time":"2020-04-04 20:49:26","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99926","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":"3086134","reservation_id":"93700","confirmation_number":"PB12227808509","room_confirmation_number":"PB12356586701","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"99928","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-04 20:35:08","reservation_modified_date_time":"2020-04-04 22:00:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99928","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":"3086045","reservation_id":"93637","confirmation_number":"PB12243625342","room_confirmation_number":"PB12394572506","room_stay_from":"2020-03-29","room_stay_to":"2020-04-09","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"99869","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-28 15:45:22","reservation_modified_date_time":"2020-04-03 16:59:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99869","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":"3086144","reservation_id":"93643","confirmation_number":"PB12239750743","room_confirmation_number":"PB12392926566","room_stay_from":"2020-04-04","room_stay_to":"2020-04-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"99875","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-28 19:04:12","reservation_modified_date_time":"2020-04-04 22:34:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99875","canceled_nights_data":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3086101","reservation_id":"93660","confirmation_number":"PB12281158795","room_confirmation_number":"PB12342187525","room_stay_from":"2020-04-04","room_stay_to":"2020-04-11","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":"99889","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-30 18:08:07","reservation_modified_date_time":"2020-04-04 15:17:39","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99889","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":"3086109","reservation_id":"93659","confirmation_number":"PB12259744424","room_confirmation_number":"PB12380038432","room_stay_from":"2020-04-04","room_stay_to":"2020-04-18","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","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","subtotal":"168.00","grand_total":"189.84","paid_amount":"189.84","product_id":"1781","service_quantity":"1","customer_traveller_id":"76889","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-03-30 17:57:33","reservation_modified_date_time":"2020-04-04 16:33:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"76889","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3086114","reservation_id":"93656","confirmation_number":"PB12271612692","room_confirmation_number":"PB12325140768","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"18.69","grand_total":"20.00","paid_amount":"20.00","product_id":"1201","service_quantity":"1","product_name":"Sunglasses - 2 pairs","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-04 20:30:04","reservation_modified_date_time":"2020-04-04 20:30:04","customer_id":"99895","parentCustTravId":"99895","customer_traveller_id":"99895","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"18.69","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3086103","reservation_id":"93697","confirmation_number":"PB12224469489","room_confirmation_number":"PB12382754485","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.21","grand_total":"4.50","paid_amount":"4.50","product_id":null,"service_quantity":"1","product_name":"Aloe Lotion\/ Gel","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-04 16:27:23","reservation_modified_date_time":"2020-04-04 16:27:23","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":"4.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":0,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3085836","reservation_id":"93674","confirmation_number":"BV12420012592","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"118.20","nightly_discount":"0","subtotal":"118.20","grand_total":"133.56","paid_amount":"0.00","room_type_id":"287","product_id":"1090","siteminder_id":"BDC-3308300056","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":"99901","customer_id":"99901","source_of_creation":"Booking.com","reservation_created_date":"2020-04-01 02:35:08","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"24.88","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"118.20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"3086131","reservation_id":"93701","confirmation_number":"BV12468626328","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"114.83","nightly_discount":"0","subtotal":"114.83","grand_total":"155.92","paid_amount":"155.92","room_type_id":"291","product_id":"1118","siteminder_id":"ABB-HMDRHZ5D8J","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"114.83","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99927","customer_id":"99927","source_of_creation":"Airbnb","reservation_created_date":"2020-04-04 21:47:09","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"18.85","commision_charges":"4.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.83","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":[],"hwr_non_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3086091","reservation_id":"93682","confirmation_number":"BV12416349640","room_stay_from":"2020-04-03","room_stay_to":"2020-04-05","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"98.64,98.64","nightly_discount":"0.00,0.00","subtotal":"197.28","grand_total":"222.93","paid_amount":"222.93","room_type_id":"291","product_id":"1116","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"99909","customer_id":"99909","source_of_creation":"FE","reservation_created_date":"2020-04-02 13:25:33","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"98.64","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3086132","reservation_id":"93701","confirmation_number":"BV12231606208","room_confirmation_number":"BV12468626328","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"20.00","paid_amount":"20.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"99927","product_attribute_values":"extra_person#&#10","reservation_created_date":"2020-04-04 21:49:47","reservation_modified_date_time":"2020-04-04 21:49:47","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99927","canceled_nights_data":"","currentDayPrice":"20","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":"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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3085837","reservation_id":"93674","confirmation_number":"BV12248992335","room_confirmation_number":"BV12420012592","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"99901","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-01 02:35:08","reservation_modified_date_time":"2020-04-02 13:35:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99901","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":"3086092","reservation_id":"93682","confirmation_number":"BV12276358811","room_confirmation_number":"BV12416349640","room_stay_from":"2020-04-03","room_stay_to":"2020-04-05","room_stay_status":"Active","nightly_price":"12.00,12.00","nightly_discount":"0.00,0.00","subtotal":"24.00","grand_total":"27.12","paid_amount":"27.12","product_id":"1781","service_quantity":"1","customer_traveller_id":"99909","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-04-02 13:25:33","reservation_modified_date_time":"2020-04-04 13:25:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99909","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":"3086133","reservation_id":"93701","confirmation_number":"BV12224461244","room_confirmation_number":"BV12468626328","room_stay_from":"2020-04-04","room_stay_to":"2020-04-05","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":"99927","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-04-04 21:47:09","reservation_modified_date_time":"2020-04-04 21:49:47","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"99927","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3086086","reservation_id":"93682","confirmation_number":"PB12247203717","room_confirmation_number":"BV12416349640","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1192","service_quantity":"1","product_name":"Resort Fee Person","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-04 13:10:31","reservation_modified_date_time":"2020-04-04 13:10:31","customer_id":"99909","parentCustTravId":"99909","customer_traveller_id":"99909","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3086088","reservation_id":"93682","confirmation_number":"PB12274904875","room_confirmation_number":"BV12416349640","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"4.21","grand_total":"4.50","paid_amount":"4.50","product_id":"1144","service_quantity":"1","product_name":"Aloe Lotion\/ Gel","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-04 13:10:31","reservation_modified_date_time":"2020-04-04 13:10:31","customer_id":"99909","parentCustTravId":"99909","customer_traveller_id":"99909","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"4.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3086093","reservation_id":"93682","confirmation_number":"PB12250057463","room_confirmation_number":"BV12416349640","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-04-04 13:10:31","reservation_modified_date_time":"2020-04-04 13:25:22","customer_id":"99909","parentCustTravId":"99909","customer_traveller_id":"99909","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":0,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_non_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"pms_taxable":[{"room_stay_id":"3086082","reservation_id":"92380","confirmation_number":"BP12593858961","room_stay_from":"2020-04-04","room_stay_to":"2020-04-11","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"197.00,197.00,197.00,171.00,197.00,171.00,197.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1327.00","grand_total":"1499.51","paid_amount":"222.61","room_type_id":"289","product_id":"1100","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"98666","customer_id":"98666","source_of_creation":"PMS","reservation_created_date":"2020-02-22 21:18:07","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":"197.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3019361","reservation_id":"84108","confirmation_number":"BP12523699650","room_stay_from":"2020-04-04","room_stay_to":"2020-04-06","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"124.30","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":"91621","customer_id":"91621","source_of_creation":"PMS","reservation_created_date":"2019-09-15 00:03:03","service_canceled_date_time":"2020-03-24 15:49:39","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"0.00","deltaChange":"0.00","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_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3086083","reservation_id":"92380","confirmation_number":"BP12279471323","room_confirmation_number":"BP12593858961","room_stay_from":"2020-04-04","room_stay_to":"2020-04-11","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"84.00","grand_total":"94.92","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"98666","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-22 21:18:07","reservation_modified_date_time":"2020-04-03 21:33:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"98666","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}