{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2020-01-22","total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1123,1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":16,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1140","block_room_bookings":[{"confirmation_number":"BV12279318287","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3060208","reservation_id":"90308","confirmation_number":"PB12310412113","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.64,131.41","nightly_discount":"0,0","subtotal":"244.05","grand_total":"275.77","paid_amount":"275.77","room_type_id":"289","product_id":"1095","siteminder_id":"BDC-3406172486","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":"96364","customer_id":"96364","source_of_creation":"Booking.com","reservation_created_date":"2020-01-21 14:36:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"42.61","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.41","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3060452","reservation_id":"90337","confirmation_number":"BP12575017040","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.65,83.59","nightly_discount":"0,0","subtotal":"155.24","grand_total":"175.42","paid_amount":"175.42","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-3335781139","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":"96387","customer_id":"96387","source_of_creation":"Booking.com","reservation_created_date":"2020-01-22 01:56:11","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"35.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"83.59","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3053342","reservation_id":"89202","confirmation_number":"PB12329434252","room_stay_from":"2020-01-13","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"98.30,89.36,89.36,89.36,163.22,163.22,164.13,89.36,89.36,89.36,89.36,117.32,117.32","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1449.03","grand_total":"1637.40","paid_amount":"1637.40","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3506136409","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":"95950","customer_id":"95950","source_of_creation":"Booking.com","reservation_created_date":"2020-01-03 03:26:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"217.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.36","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":"3050678","reservation_id":"88717","confirmation_number":"BP12587673305","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"68.17","nightly_discount":"0","subtotal":"68.17","grand_total":"77.03","paid_amount":"77.03","room_type_id":"298","product_id":"1133","siteminder_id":"EXP-1612748263","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":"96465","customer_id":"96465","source_of_creation":"Expedia","reservation_created_date":"2019-12-26 16:57:05","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"68.17","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":"3053368","reservation_id":"89206","confirmation_number":"PB12359653428","room_stay_from":"2020-01-19","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.34,91.65,91.65,91.65","nightly_discount":"0,0,0,0","subtotal":"443.29","grand_total":"500.92","paid_amount":"500.92","room_type_id":"292","product_id":"1120","siteminder_id":"EXP-1616494733","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":"95233","customer_id":"95233","source_of_creation":"Expedia","reservation_created_date":"2020-01-03 04:07:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.65","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":"3056535","reservation_id":"89743","confirmation_number":"PB12389396006","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"111.17","nightly_discount":"0","subtotal":"111.17","grand_total":"125.62","paid_amount":"125.62","room_type_id":"285","product_id":"1084","siteminder_id":"EXP-1620960223","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":"96440","customer_id":"96440","source_of_creation":"Expedia","reservation_created_date":"2020-01-11 04:13:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.17","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":"3059792","reservation_id":"87273","confirmation_number":"BV12411156288","room_stay_from":"2020-01-20","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.29,105.29,105.29","nightly_discount":"0,0,0","subtotal":"315.87","grand_total":"356.93","paid_amount":"356.93","room_type_id":"304","product_id":"1221","siteminder_id":"EXP-1600296719","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":"79611","customer_id":"79611","source_of_creation":"Expedia","reservation_created_date":"2020-01-20 01:23:18","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.29","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":"3060520","reservation_id":"90352","confirmation_number":"BV12476800165","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.13","nightly_discount":"0","subtotal":"78.13","grand_total":"88.29","paid_amount":"88.29","room_type_id":"307","product_id":"1224","siteminder_id":"EXP-1627732373","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":"96435","customer_id":"96435","source_of_creation":"Expedia","reservation_created_date":"2020-01-22 16:18:10","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.13","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":"3059804","reservation_id":"90238","confirmation_number":"BV12485585025","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.87,89.87","nightly_discount":"0,0","subtotal":"179.74","grand_total":"203.10","paid_amount":"203.10","room_type_id":"309","product_id":"1226","siteminder_id":"EXP-1626090137","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":"96414","customer_id":"96414","source_of_creation":"Expedia","reservation_created_date":"2020-01-20 03:33:05","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.87","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3049946","reservation_id":"88643","confirmation_number":"PB12394892013","room_stay_from":"2020-01-14","room_stay_to":"2020-01-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"83.56,83.56,83.56,89.80,89.80,83.56,83.56,83.56,83.56,83.56,89.80","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0","subtotal":"937.88","grand_total":"1059.80","paid_amount":"1059.80","room_type_id":"291","product_id":"1115","siteminder_id":"EXP-1611974558","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":"95996","customer_id":"95996","source_of_creation":"Expedia","reservation_created_date":"2019-12-24 14:37:11","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":"83.56","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":"3051717","reservation_id":"88908","confirmation_number":"PB12360643130","room_stay_from":"2020-01-18","room_stay_to":"2020-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.66,110.31,83.56,83.56,83.56,83.56,98.78","nightly_discount":"0,0,0,0,0,0,0","subtotal":"651.99","grand_total":"736.75","paid_amount":"736.75","room_type_id":"291","product_id":"1119","siteminder_id":"EXP-1614301002","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":"96230","customer_id":"96230","source_of_creation":"Expedia","reservation_created_date":"2019-12-29 18:47:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"83.56","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":"3061672","reservation_id":"84515","confirmation_number":"PB12350761510","room_stay_from":"2020-01-18","room_stay_to":"2020-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.00,174.00,174.00,174.00,174.00,174.00,186.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1242.00","grand_total":"1403.46","paid_amount":"1403.46","room_type_id":"288","product_id":"1091","siteminder_id":"EXP-1347145868","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"70.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96209","customer_id":"96209","source_of_creation":"Expedia","reservation_created_date":"2019-09-22 01:17:11","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"174.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3049824","reservation_id":"88621","confirmation_number":"PB12331663880","room_stay_from":"2020-01-21","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.29,99.29,99.29,107.74,107.74","nightly_discount":"0,0,0,0,0","subtotal":"513.35","grand_total":"580.08","paid_amount":"580.08","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1611689858","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":"96687","customer_id":"96687","source_of_creation":"Expedia","reservation_created_date":"2019-12-23 20:52: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":"99.29","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":"3050605","reservation_id":"88708","confirmation_number":"PB12319001217","room_stay_from":"2020-01-22","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.97,67.97,74.21,74.21","nightly_discount":"0,0,0,0","subtotal":"284.36","grand_total":"321.33","paid_amount":"321.33","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1612495862","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":"96686","customer_id":"96686","source_of_creation":"Expedia","reservation_created_date":"2019-12-26 01:37:09","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.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"}]},{"room_stay_id":"3046079","reservation_id":"88163","confirmation_number":"PB12330441358","room_stay_from":"2020-01-22","room_stay_to":"2020-01-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.75,189.75,200.41,200.41,189.75,189.75","nightly_discount":"0,0,0,0,0,0","subtotal":"1159.82","grand_total":"1310.60","paid_amount":"1310.60","room_type_id":"287","product_id":"1088","siteminder_id":"EXP-1606240235","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":"96412","customer_id":"96412","source_of_creation":"Expedia","reservation_created_date":"2019-12-11 15:52:09","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":"189.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3061305","reservation_id":"89313","confirmation_number":"PB12317880856","room_stay_from":"2020-01-20","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.42,81.42,81.42,81.42","nightly_discount":"0,0,0,0","subtotal":"325.68","grand_total":"368.02","paid_amount":"802.83","room_type_id":"289","product_id":"1105","siteminder_id":"GAM-R1817586256","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":"96367","customer_id":"96367","source_of_creation":"Getaroom.com","reservation_created_date":"2020-01-04 16:15:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"81.42","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":"3060200","reservation_id":"88976","confirmation_number":"PB12391619290","room_stay_from":"2020-01-22","room_stay_to":"2020-01-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.52,67.52,80.59,80.59,74.28,67.52,67.52","nightly_discount":"0,0,0,0,0,0,0","subtotal":"505.54","grand_total":"571.26","paid_amount":"571.26","room_type_id":"289","product_id":"1097","siteminder_id":"GAM-R1809969875","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":"95060","customer_id":"95060","source_of_creation":"Getaroom.com","reservation_created_date":"2019-12-30 18:22:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.52","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3060315","reservation_id":"90320","confirmation_number":"BP12579283786","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"59.19,59.19","nightly_discount":"0,0","subtotal":"118.38","grand_total":"133.77","paid_amount":"133.77","room_type_id":"289","product_id":"1099","siteminder_id":"HWR-301676555","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":"96372","customer_id":"96372","source_of_creation":"Hotwire","reservation_created_date":"2020-01-21 19:39:10","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":"59.19","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":"3060444","reservation_id":"90331","confirmation_number":"BP12511629374","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"59.19,59.18","nightly_discount":"0.00,0.00","subtotal":"118.37","grand_total":"133.76","paid_amount":"133.76","room_type_id":"295","product_id":"1128","siteminder_id":"HWR-301680658","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":"96382","customer_id":"96382","source_of_creation":"Hotwire","reservation_created_date":"2020-01-21 23:30:09","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"59.18","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3059814","reservation_id":"90242","confirmation_number":"BV12456725089","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.23,100.23","nightly_discount":"0,0","subtotal":"200.46","grand_total":"226.52","paid_amount":"226.52","room_type_id":"303","product_id":"1139","siteminder_id":"GCC-0005300057-a6c","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96294","customer_id":"96294","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-01-20 13:37:07","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.23","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3054963","reservation_id":"89488","confirmation_number":"PB12366402386","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.34,93.34","nightly_discount":"0,0","subtotal":"186.68","grand_total":"210.95","paid_amount":"210.95","room_type_id":"291","product_id":"1116","siteminder_id":"AGO-301334802","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":"96437","customer_id":"96437","source_of_creation":"Agoda","reservation_created_date":"2020-01-07 02:03:07","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":"93.34","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3051545","reservation_id":"88869","confirmation_number":"BP12525949679","room_stay_from":"2020-01-16","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"66.01,67.98,67.98,67.95,66.01,66.01,66.01,66.01,79.15,79.15","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"692.26","grand_total":"782.26","paid_amount":"782.26","room_type_id":"295","product_id":"1129","siteminder_id":"AGO-299503918","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96126","customer_id":"96126","source_of_creation":"Agoda","reservation_created_date":"2019-12-28 23:39:08","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"66.01","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":"3052068","reservation_id":"88968","confirmation_number":"BP12590386482","room_stay_from":"2020-01-16","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"72.09,73.68,73.68,74.23,72.09,72.09,72.09,72.09,85.88,85.88","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"753.80","grand_total":"851.80","paid_amount":"851.80","room_type_id":"294","product_id":"1125","siteminder_id":"AGO-299825274","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95052","customer_id":"95052","source_of_creation":"Agoda","reservation_created_date":"2019-12-30 17:03:07","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"72.09","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3043647","reservation_id":"87793","confirmation_number":"PB12391240598","room_stay_from":"2020-01-22","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00,210.00,230.00,230.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"994.40","paid_amount":"994.40","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":"94234","customer_id":"94234","source_of_creation":"FE","reservation_created_date":"2019-12-03 02:29:05","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":"210.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3051487","reservation_id":"88856","confirmation_number":"BV12485699294","room_stay_from":"2020-01-22","room_stay_to":"2020-01-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.00,91.00,114.40,114.40,91.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"501.80","grand_total":"567.04","paid_amount":"567.04","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94985","customer_id":"94985","source_of_creation":"FE","reservation_created_date":"2019-12-28 20:28:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3060799","reservation_id":"90062","confirmation_number":"BV12449460806","room_stay_from":"2020-01-28","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.00,109.45,97.13","nightly_discount":"0.00,0.00,0.00","subtotal":"349.58","grand_total":"395.02","paid_amount":"395.02","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96093","customer_id":"96093","source_of_creation":"FE","reservation_created_date":"2020-01-16 03:52:55","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3060512","reservation_id":"88156","confirmation_number":"PB12348244508","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00","nightly_discount":"0.00","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","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":"96102","customer_id":"96102","source_of_creation":"PMS","reservation_created_date":"2019-12-11 14:12:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"150.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056085","reservation_id":"85249","confirmation_number":"BP12548475728","room_stay_from":"2020-01-09","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.00,144.00,144.00,144.00,164.00,164.00,144.00,144.00,144.00,144.00,144.00,164.00,164.00,144.00,144.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,132.41,0.00","subtotal":"2240.00","grand_total":"2381.58","paid_amount":"2381.58","room_type_id":"296","product_id":"1131","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"33409","customer_id":"33409","source_of_creation":"PMS","reservation_created_date":"2019-10-07 13:41:48","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3059703","reservation_id":"90214","confirmation_number":"BP12513238998","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00","nightly_discount":"0.00,0.00","subtotal":"178.00","grand_total":"201.14","paid_amount":"201.14","room_type_id":"299","product_id":"1134","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":"96265","customer_id":"96265","source_of_creation":"PMS","reservation_created_date":"2020-01-19 19:59:20","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","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":"3060518","reservation_id":"90351","confirmation_number":"PB12395197958","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"127.70,127.70","nightly_discount":"0.00,0.00","subtotal":"255.40","grand_total":"288.60","paid_amount":"288.60","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":"94747","customer_id":"94747","source_of_creation":"PMS","reservation_created_date":"2020-01-22 15:52:19","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"127.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3060525","reservation_id":"88839","confirmation_number":"PB12371566257","room_stay_from":"2020-01-19","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.35,90.35,90.35,90.35,90.35","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"451.75","grand_total":"510.48","paid_amount":"496.92","room_type_id":"289","product_id":"1106","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":"29842","customer_id":"29842","source_of_creation":"PMS","reservation_created_date":"2019-12-28 16:23:49","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","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":"90.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3057018","reservation_id":"88784","confirmation_number":"PB12392353571","room_stay_from":"2020-01-11","room_stay_to":"2020-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.20,83.20,83.20,83.20,83.20,83.20,96.20,96.20,83.20,83.20,83.20,83.20,83.20,83.20","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":"1203.80","grand_total":"1360.30","paid_amount":"1360.30","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"58706","customer_id":"58706","source_of_creation":"PMS","reservation_created_date":"2019-12-27 17:52:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"83.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":"2926412","reservation_id":"67725","confirmation_number":"PB12380073576","room_stay_from":"2020-01-16","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.13,162.13,162.13,162.13,162.13,162.13,162.13,162.13,162.13,162.13","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1621.30","grand_total":"1832.07","paid_amount":"1832.07","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":"61502","customer_id":"61502","source_of_creation":"PMS","reservation_created_date":"2019-01-24 20:14:19","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":"162.13","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055282","reservation_id":"88979","confirmation_number":"PB12313663545","room_stay_from":"2020-01-22","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.00,86.00,86.00,86.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"344.00","grand_total":"388.72","paid_amount":"388.72","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":"95063","customer_id":"95063","source_of_creation":"PMS","reservation_created_date":"2019-12-30 19:36:15","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":"86.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3059475","reservation_id":"89416","confirmation_number":"BP12538247846","room_stay_from":"2020-01-18","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.93,109.21,83.85,98.85,98.85,98.85,172.19,172.19","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,46.73,0.00","subtotal":"974.92","grand_total":"1048.85","paid_amount":"1048.85","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"37586","customer_id":"37586","source_of_creation":"PMS","reservation_created_date":"2020-01-05 21:23:39","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"98.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056276","reservation_id":"89708","confirmation_number":"PB12398691456","room_stay_from":"2020-01-21","room_stay_to":"2020-01-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.61,124.61,124.61,213.00,188.85,110.51,100.46","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"986.65","grand_total":"1114.92","paid_amount":"1114.92","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95505","customer_id":"95505","source_of_creation":"PMS","reservation_created_date":"2020-01-10 17:44:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.61","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3060308","reservation_id":"87060","confirmation_number":"PB12332177735","room_stay_from":"2020-01-21","room_stay_to":"2020-01-28","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"110.00,110.00,110.00,110.00,110.00,110.00,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,37.19,0.00","subtotal":"770.00","grand_total":"828.08","paid_amount":"828.08","room_type_id":"289","product_id":"1109","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89847","customer_id":"89847","source_of_creation":"PMS","reservation_created_date":"2019-11-12 18:32:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008157","reservation_id":"76634","confirmation_number":"BV12419997012","room_stay_from":"2020-01-22","room_stay_to":"2020-01-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,149.00,149.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"943.00","grand_total":"1065.59","paid_amount":"1065.59","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"66880","customer_id":"66880","source_of_creation":"PMS","reservation_created_date":"2019-05-16 22:54:09","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008159","reservation_id":"76634","confirmation_number":"BV12439591329","room_stay_from":"2020-01-22","room_stay_to":"2020-01-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,149.00,149.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"943.00","grand_total":"1065.59","paid_amount":"1065.59","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"66880","customer_id":"66880","source_of_creation":"PMS","reservation_created_date":"2019-05-16 22:54:09","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3061066","reservation_id":"90281","confirmation_number":"PB12323284534","room_stay_from":"2020-01-20","room_stay_to":"2020-01-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1050.00","grand_total":"1186.50","paid_amount":"1186.50","room_type_id":"289","product_id":"1098","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96545","customer_id":"96545","source_of_creation":"PMS","reservation_created_date":"2020-01-20 21:45:40","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3059773","reservation_id":"67943","confirmation_number":"PB12399848605","room_stay_from":"2020-01-19","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,199.00,199.00,199.00,199.00,199.00,199.00,199.00,199.00,199.00,199.00,199.00","nightly_discount":"0.00,109.36,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2388.00","grand_total":"2574.86","paid_amount":"2574.87","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"56101","customer_id":"56101","source_of_creation":"PMS","reservation_created_date":"2019-01-27 17:12:48","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"199.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2932109","reservation_id":"68769","confirmation_number":"BV12487057372","room_stay_from":"2020-01-15","room_stay_to":"2020-02-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2736.00","grand_total":"3091.68","paid_amount":"3091.68","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"34656","customer_id":"34656","source_of_creation":"PMS","reservation_created_date":"2019-02-06 18:46:33","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055088","reservation_id":"69585","confirmation_number":"BP12549690899","room_stay_from":"2020-01-07","room_stay_to":"2020-02-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00","nightly_discount":"100.00,100.00,100.00,10.18,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"6380.00","grand_total":"6858.90","paid_amount":"6858.90","room_type_id":"302","product_id":"1138","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"46530","customer_id":"46530","source_of_creation":"PMS","reservation_created_date":"2019-02-16 16:13:23","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"145.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3073594","reservation_id":"69560","confirmation_number":"PB12379957713","room_stay_from":"2020-01-16","room_stay_to":"2020-03-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00","nightly_discount":"0.00,0.00,0.00,0.23,62.00,118.00,118.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"6018.00","grand_total":"6463.34","paid_amount":"6463.34","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23037","customer_id":"23037","source_of_creation":"PMS","reservation_created_date":"2019-02-16 01:30:33","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":"118.00","currentDayDiscount":"118.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3073901","reservation_id":"69563","confirmation_number":"PB12323204176","room_stay_from":"2020-01-10","room_stay_to":"2020-03-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00","nightly_discount":"135.00,135.00,121.86,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"7695.00","grand_total":"8252.55","paid_amount":"8252.55","room_type_id":"289","product_id":"1121","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":"55161","customer_id":"55161","source_of_creation":"PMS","reservation_created_date":"2019-02-16 01:39:43","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"135.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2938851","reservation_id":"70051","confirmation_number":"BV12471710295","room_stay_from":"2020-01-19","room_stay_to":"2020-03-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"7427.00","grand_total":"8392.51","paid_amount":"8392.51","room_type_id":"305","product_id":"1222","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":"46265","customer_id":"46265","source_of_creation":"PMS","reservation_created_date":"2019-02-22 18:13:15","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056006","reservation_id":"69773","confirmation_number":"BV12434890851","room_stay_from":"2020-01-08","room_stay_to":"2020-03-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,60.62,166.04,166.04,166.04","subtotal":"10958.64","grand_total":"11751.88","paid_amount":"11751.88","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24672","customer_id":"24672","source_of_creation":"PMS","reservation_created_date":"2019-02-18 22:04:05","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"166.04","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082907","reservation_id":"67475","confirmation_number":"BP12551251808","room_stay_from":"2020-01-18","room_stay_to":"2020-03-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,95.75,95.75,95.75,95.75","subtotal":"6900.00","grand_total":"7364.21","paid_amount":"7364.21","room_type_id":"301","product_id":"1137","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":"26029","customer_id":"26029","source_of_creation":"PMS","reservation_created_date":"2019-01-21 18:47:47","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"115.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3060707","reservation_id":"89227","confirmation_number":"PB12332085801","room_stay_from":"2020-03-10","room_stay_to":"2020-03-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"218.00,218.00,218.00,294.80,294.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1243.60","grand_total":"1405.27","paid_amount":"1405.27","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95254","customer_id":"95254","source_of_creation":"PMS","reservation_created_date":"2020-01-03 16:11:43","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3060709","reservation_id":"89227","confirmation_number":"PB12355965055","room_stay_from":"2020-03-10","room_stay_to":"2020-03-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"218.00,218.00,218.00,294.80,294.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1243.60","grand_total":"1405.27","paid_amount":"1405.27","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95254","customer_id":"95254","source_of_creation":"PMS","reservation_created_date":"2020-01-03 16:11:43","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"3056988","reservation_id":"89223","confirmation_number":"PB12357170705","room_stay_from":"2020-01-22","room_stay_to":"2020-01-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.35,90.35,125.06,125.06,99.39","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"530.21","grand_total":"530.21","paid_amount":"522.41","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"95251","customer_id":"95251","source_of_creation":"PMS","reservation_created_date":"2020-01-03 14:37:57","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.35","currentDayDiscount":"0.00","productIsTaxExempt":true,"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":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3050679","reservation_id":"88717","confirmation_number":"BP12277281514","room_confirmation_number":"BP12587673305","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","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":"96465","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-26 16:57:05","reservation_modified_date_time":"2019-12-26 16:57:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96465","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":"3053369","reservation_id":"89206","confirmation_number":"PB12252257828","room_confirmation_number":"PB12359653428","room_stay_from":"2020-01-19","room_stay_to":"2020-01-23","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":"95233","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-03 04:07:09","reservation_modified_date_time":"2020-01-03 04:07:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95233","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":"3056536","reservation_id":"89743","confirmation_number":"PB12282116112","room_confirmation_number":"PB12389396006","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","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":"96440","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-11 04:13:08","reservation_modified_date_time":"2020-01-11 04:13:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96440","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":"3059793","reservation_id":"87273","confirmation_number":"BV12270833758","room_confirmation_number":"BV12411156288","room_stay_from":"2020-01-20","room_stay_to":"2020-01-23","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79611","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-20 01:23:18","reservation_modified_date_time":"2020-01-20 01:23:18","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79611","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":"3060209","reservation_id":"90308","confirmation_number":"PB12270648774","room_confirmation_number":"PB12310412113","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","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":"96364","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-21 14:36:11","reservation_modified_date_time":"2020-01-21 14:36:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96364","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":"3060316","reservation_id":"90320","confirmation_number":"BP12298506548","room_confirmation_number":"BP12579283786","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","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":"96372","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-21 19:39:10","reservation_modified_date_time":"2020-01-21 19:39:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96372","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":"3060445","reservation_id":"90331","confirmation_number":"BP12210309383","room_confirmation_number":"BP12511629374","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","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":"96382","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-21 23:30:09","reservation_modified_date_time":"2020-01-22 01:11:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96382","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":"3060453","reservation_id":"90337","confirmation_number":"BP12284261543","room_confirmation_number":"BP12575017040","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","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":"96387","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-22 01:56:11","reservation_modified_date_time":"2020-01-22 01:56:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96387","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":"3060513","reservation_id":"88156","confirmation_number":"PB12229209069","room_confirmation_number":"PB12348244508","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","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":"96102","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-11 14:12:28","reservation_modified_date_time":"2020-01-16 13:24:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96102","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":"3060521","reservation_id":"90352","confirmation_number":"BV12226738424","room_confirmation_number":"BV12476800165","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","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":"96435","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-22 16:18:10","reservation_modified_date_time":"2020-01-22 16:18:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96435","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":"3054964","reservation_id":"89488","confirmation_number":"PB12288817341","room_confirmation_number":"PB12366402386","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","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":"96437","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-07 02:03:07","reservation_modified_date_time":"2020-01-07 02:03:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96437","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":"3056086","reservation_id":"85249","confirmation_number":"BP12268512018","room_confirmation_number":"BP12548475728","room_stay_from":"2020-01-09","room_stay_to":"2020-01-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"33409","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-07 13:41:48","reservation_modified_date_time":"2020-01-09 22:21:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"33409","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":"3059704","reservation_id":"90214","confirmation_number":"BP12215319714","room_confirmation_number":"BP12513238998","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","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":"96265","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-19 19:59:20","reservation_modified_date_time":"2020-01-19 19:59:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96265","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":"3059805","reservation_id":"90238","confirmation_number":"BV12244014413","room_confirmation_number":"BV12485585025","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","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":"96414","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-20 03:33:05","reservation_modified_date_time":"2020-01-20 03:33:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96414","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":"3059815","reservation_id":"90242","confirmation_number":"BV12253366302","room_confirmation_number":"BV12456725089","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","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":"96294","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-20 13:37:07","reservation_modified_date_time":"2020-01-20 13:37:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96294","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":"3060519","reservation_id":"90351","confirmation_number":"PB12236105663","room_confirmation_number":"PB12395197958","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","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":"94747","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-22 15:52:19","reservation_modified_date_time":"2020-01-22 15:52:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94747","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":"3060526","reservation_id":"88839","confirmation_number":"PB12214462117","room_confirmation_number":"PB12371566257","room_stay_from":"2020-01-19","room_stay_to":"2020-01-24","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":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"29842","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-28 16:23:49","reservation_modified_date_time":"2019-12-28 16:23:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"29842","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":"3061306","reservation_id":"89313","confirmation_number":"PB12266595266","room_confirmation_number":"PB12317880856","room_stay_from":"2020-01-20","room_stay_to":"2020-01-24","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":"180.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"96367","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-04 16:15:09","reservation_modified_date_time":"2020-01-04 16:15:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96367","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":"3049947","reservation_id":"88643","confirmation_number":"PB12244546328","room_confirmation_number":"PB12394892013","room_stay_from":"2020-01-14","room_stay_to":"2020-01-25","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0,0,0,0,0,0,0,0","subtotal":"220.00","grand_total":"248.60","paid_amount":"248.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"95996","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-24 14:37:11","reservation_modified_date_time":"2019-12-24 14:37:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95996","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3051718","reservation_id":"88908","confirmation_number":"PB12222084755","room_confirmation_number":"PB12360643130","room_stay_from":"2020-01-18","room_stay_to":"2020-01-25","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"96230","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-29 18:47:11","reservation_modified_date_time":"2019-12-29 18:47:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96230","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":"3057019","reservation_id":"88784","confirmation_number":"PB12276756880","room_confirmation_number":"PB12392353571","room_stay_from":"2020-01-11","room_stay_to":"2020-01-25","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":"58706","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-27 17:52:28","reservation_modified_date_time":"2019-12-27 17:52:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58706","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":"3061674","reservation_id":"84515","confirmation_number":"PB12241798263","room_confirmation_number":"PB12350761510","room_stay_from":"2020-01-18","room_stay_to":"2020-01-25","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"96209","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-22 01:17:11","reservation_modified_date_time":"2020-01-25 19:31:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96209","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":"2926413","reservation_id":"67725","confirmation_number":"PB12251039380","room_confirmation_number":"PB12380073576","room_stay_from":"2020-01-16","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"61502","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-24 20:14:19","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"61502","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":"3043648","reservation_id":"87793","confirmation_number":"PB12229826827","room_confirmation_number":"PB12391240598","room_stay_from":"2020-01-22","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"94234","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-03 02:29:05","reservation_modified_date_time":"2019-12-03 02:29:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94234","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":"3049825","reservation_id":"88621","confirmation_number":"PB12242765076","room_confirmation_number":"PB12331663880","room_stay_from":"2020-01-21","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"96687","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-23 20:52:10","reservation_modified_date_time":"2019-12-23 20:52:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96687","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":"3050606","reservation_id":"88708","confirmation_number":"PB12255244588","room_confirmation_number":"PB12319001217","room_stay_from":"2020-01-22","room_stay_to":"2020-01-26","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":"96686","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-26 01:37:09","reservation_modified_date_time":"2019-12-26 01:37:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96686","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":"3051547","reservation_id":"88869","confirmation_number":"BP12263885085","room_confirmation_number":"BP12525949679","room_stay_from":"2020-01-16","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"96126","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-28 23:39:08","reservation_modified_date_time":"2019-12-28 23:39:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96126","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":"3052070","reservation_id":"88968","confirmation_number":"BP12217771701","room_confirmation_number":"BP12590386482","room_stay_from":"2020-01-16","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"95052","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-30 17:03:07","reservation_modified_date_time":"2019-12-30 17:03:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95052","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":"3053343","reservation_id":"89202","confirmation_number":"PB12225092008","room_confirmation_number":"PB12329434252","room_stay_from":"2020-01-13","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0","subtotal":"260.00","grand_total":"293.80","paid_amount":"293.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95950","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-03 03:26:06","reservation_modified_date_time":"2020-01-03 03:26:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95950","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055283","reservation_id":"88979","confirmation_number":"PB12288507393","room_confirmation_number":"PB12313663545","room_stay_from":"2020-01-22","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"95063","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-30 19:36:15","reservation_modified_date_time":"2019-12-30 19:36:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95063","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":"3059476","reservation_id":"89416","confirmation_number":"BP12216605208","room_confirmation_number":"BP12538247846","room_stay_from":"2020-01-18","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"37586","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-05 21:23:39","reservation_modified_date_time":"2020-01-18 21:56:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"37586","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3051488","reservation_id":"88856","confirmation_number":"BV12219177455","room_confirmation_number":"BV12485699294","room_stay_from":"2020-01-22","room_stay_to":"2020-01-27","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":"94985","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-28 20:28:10","reservation_modified_date_time":"2019-12-28 20:28:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94985","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":"3046080","reservation_id":"88163","confirmation_number":"PB12297529008","room_confirmation_number":"PB12330441358","room_stay_from":"2020-01-22","room_stay_to":"2020-01-28","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":"96412","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-11 15:52:09","reservation_modified_date_time":"2019-12-11 15:52:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96412","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":"3056277","reservation_id":"89708","confirmation_number":"PB12262208006","room_confirmation_number":"PB12398691456","room_stay_from":"2020-01-21","room_stay_to":"2020-01-28","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":"95505","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-10 17:44:17","reservation_modified_date_time":"2020-01-10 17:44:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95505","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":"3060309","reservation_id":"87060","confirmation_number":"PB12242542416","room_confirmation_number":"PB12332177735","room_stay_from":"2020-01-21","room_stay_to":"2020-01-28","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":"89847","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-12 18:32:55","reservation_modified_date_time":"2020-01-21 20:50:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89847","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":"3008158","reservation_id":"76634","confirmation_number":"BV12246207648","room_confirmation_number":"BV12419997012","room_stay_from":"2020-01-22","room_stay_to":"2020-01-29","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":"66880","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-16 22:54:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66880","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":"3008160","reservation_id":"76634","confirmation_number":"BV12277195294","room_confirmation_number":"BV12439591329","room_stay_from":"2020-01-22","room_stay_to":"2020-01-29","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":"66880","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-16 22:54:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66880","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":"3060201","reservation_id":"88976","confirmation_number":"PB12248537718","room_confirmation_number":"PB12391619290","room_stay_from":"2020-01-22","room_stay_to":"2020-01-29","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"95060","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-30 18:22:08","reservation_modified_date_time":"2019-12-30 18:22:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95060","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":"3061067","reservation_id":"90281","confirmation_number":"PB12243148815","room_confirmation_number":"PB12323284534","room_stay_from":"2020-01-20","room_stay_to":"2020-01-30","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"96545","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-20 21:45:40","reservation_modified_date_time":"2020-01-23 18:38:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96545","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3059774","reservation_id":"67943","confirmation_number":"PB12255339342","room_confirmation_number":"PB12399848605","room_stay_from":"2020-01-19","room_stay_to":"2020-01-31","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"56101","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-27 17:12:48","reservation_modified_date_time":"2020-01-19 23:27:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56101","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2932110","reservation_id":"68769","confirmation_number":"BV12285029013","room_confirmation_number":"BV12487057372","room_stay_from":"2020-01-15","room_stay_to":"2020-02-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"288.00","grand_total":"325.44","paid_amount":"325.44","product_id":"1781","service_quantity":"1","customer_traveller_id":"34656","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-06 18:46:33","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"34656","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":"3055089","reservation_id":"69585","confirmation_number":"BP12283624317","room_confirmation_number":"BP12549690899","room_stay_from":"2020-01-07","room_stay_to":"2020-02-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"46530","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-16 16:13:23","reservation_modified_date_time":"2020-01-07 19:35:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"46530","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3073595","reservation_id":"69560","confirmation_number":"PB12280777443","room_confirmation_number":"PB12379957713","room_stay_from":"2020-01-16","room_stay_to":"2020-03-07","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23037","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-16 01:30:33","reservation_modified_date_time":"2020-02-24 17:14:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23037","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3073902","reservation_id":"69563","confirmation_number":"PB12286550383","room_confirmation_number":"PB12323204176","room_stay_from":"2020-01-10","room_stay_to":"2020-03-07","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"55161","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-16 01:39:43","reservation_modified_date_time":"2020-02-25 02:47:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"55161","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2938852","reservation_id":"70051","confirmation_number":"BV12258117083","room_confirmation_number":"BV12471710295","room_stay_from":"2020-01-19","room_stay_to":"2020-03-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"46265","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-22 18:13:15","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"46265","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056007","reservation_id":"69773","confirmation_number":"BV12212358815","room_confirmation_number":"BV12434890851","room_stay_from":"2020-01-08","room_stay_to":"2020-03-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24672","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-18 22:04:05","reservation_modified_date_time":"2020-01-09 21:11:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24672","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082908","reservation_id":"67475","confirmation_number":"BP12294852803","room_confirmation_number":"BP12551251808","room_stay_from":"2020-01-18","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"26029","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-21 18:47:47","reservation_modified_date_time":"2020-03-17 13:31:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26029","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3056989","reservation_id":"89223","confirmation_number":"PB12233657153","room_confirmation_number":"PB12357170705","room_stay_from":"2020-01-22","room_stay_to":"2020-01-27","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":"60.00","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95251","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-03 14:37:57","reservation_modified_date_time":"2020-01-03 14:37:57","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"95251","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gift_shop_taxable":[{"room_stay_id":"2936334","reservation_id":"69585","confirmation_number":"BP12214447507","room_confirmation_number":"BP12549690899","room_stay_from":"2020-01-04","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-16 16:13:23","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"46530","parentCustTravId":"46530","customer_traveller_id":"46530","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3056034","reservation_id":"85249","confirmation_number":"BP12238920508","room_confirmation_number":"BP12548475728","room_stay_from":"2020-01-09","room_stay_to":"2020-01-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"375.00","grand_total":"423.75","paid_amount":"423.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-09 22:16:26","reservation_modified_date_time":"2020-01-09 22:16:26","customer_id":"33409","parentCustTravId":"33409","customer_traveller_id":"33409","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3060814","reservation_id":"90238","confirmation_number":"BV12241963979","room_confirmation_number":"BV12485585025","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-23 03:06:33","reservation_modified_date_time":"2020-01-23 03:06:33","customer_id":"96414","parentCustTravId":"96414","customer_traveller_id":"96414","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1123","departureCount":8,"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":"3060208","reservation_id":"90308","confirmation_number":"PB12310412113","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"112.64,131.41","nightly_discount":"0,0","subtotal":"244.05","grand_total":"275.77","paid_amount":"275.77","room_type_id":"289","product_id":"1095","siteminder_id":"BDC-3406172486","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":"96364","customer_id":"96364","source_of_creation":"Booking.com","reservation_created_date":"2020-01-21 14:36:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"42.61","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"131.41","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3053342","reservation_id":"89202","confirmation_number":"PB12329434252","room_stay_from":"2020-01-13","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"98.30,89.36,89.36,89.36,163.22,163.22,164.13,89.36,89.36,89.36,89.36,117.32,117.32","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0,0,0","subtotal":"1449.03","grand_total":"1637.40","paid_amount":"1637.40","room_type_id":"289","product_id":"1094","siteminder_id":"BDC-3506136409","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":"95950","customer_id":"95950","source_of_creation":"Booking.com","reservation_created_date":"2020-01-03 03:26:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"217.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.36","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":"3053368","reservation_id":"89206","confirmation_number":"PB12359653428","room_stay_from":"2020-01-19","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"168.34,91.65,91.65,91.65","nightly_discount":"0,0,0,0","subtotal":"443.29","grand_total":"500.92","paid_amount":"500.92","room_type_id":"292","product_id":"1120","siteminder_id":"EXP-1616494733","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":"95233","customer_id":"95233","source_of_creation":"Expedia","reservation_created_date":"2020-01-03 04:07:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS  218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.65","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":"3056535","reservation_id":"89743","confirmation_number":"PB12389396006","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"111.17","nightly_discount":"0","subtotal":"111.17","grand_total":"125.62","paid_amount":"125.62","room_type_id":"285","product_id":"1084","siteminder_id":"EXP-1620960223","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":"96440","customer_id":"96440","source_of_creation":"Expedia","reservation_created_date":"2020-01-11 04:13:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"111.17","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":"3049946","reservation_id":"88643","confirmation_number":"PB12394892013","room_stay_from":"2020-01-14","room_stay_to":"2020-01-25","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"83.56,83.56,83.56,89.80,89.80,83.56,83.56,83.56,83.56,83.56,89.80","nightly_discount":"0,0,0,0,0,0,0,0,0,0,0","subtotal":"937.88","grand_total":"1059.80","paid_amount":"1059.80","room_type_id":"291","product_id":"1115","siteminder_id":"EXP-1611974558","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":"95996","customer_id":"95996","source_of_creation":"Expedia","reservation_created_date":"2019-12-24 14:37:11","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":"83.56","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":"3051717","reservation_id":"88908","confirmation_number":"PB12360643130","room_stay_from":"2020-01-18","room_stay_to":"2020-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.66,110.31,83.56,83.56,83.56,83.56,98.78","nightly_discount":"0,0,0,0,0,0,0","subtotal":"651.99","grand_total":"736.75","paid_amount":"736.75","room_type_id":"291","product_id":"1119","siteminder_id":"EXP-1614301002","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":"96230","customer_id":"96230","source_of_creation":"Expedia","reservation_created_date":"2019-12-29 18:47:11","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"83.56","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":"3061672","reservation_id":"84515","confirmation_number":"PB12350761510","room_stay_from":"2020-01-18","room_stay_to":"2020-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.00,174.00,174.00,174.00,174.00,174.00,186.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1242.00","grand_total":"1403.46","paid_amount":"1403.46","room_type_id":"288","product_id":"1091","siteminder_id":"EXP-1347145868","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"70.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96209","customer_id":"96209","source_of_creation":"Expedia","reservation_created_date":"2019-09-22 01:17:11","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"174.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3049824","reservation_id":"88621","confirmation_number":"PB12331663880","room_stay_from":"2020-01-21","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.29,99.29,99.29,107.74,107.74","nightly_discount":"0,0,0,0,0","subtotal":"513.35","grand_total":"580.08","paid_amount":"580.08","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1611689858","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":"96687","customer_id":"96687","source_of_creation":"Expedia","reservation_created_date":"2019-12-23 20:52: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":"99.29","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":"3050605","reservation_id":"88708","confirmation_number":"PB12319001217","room_stay_from":"2020-01-22","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.97,67.97,74.21,74.21","nightly_discount":"0,0,0,0","subtotal":"284.36","grand_total":"321.33","paid_amount":"321.33","room_type_id":"290","product_id":"1113","siteminder_id":"EXP-1612495862","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":"96686","customer_id":"96686","source_of_creation":"Expedia","reservation_created_date":"2019-12-26 01:37:09","canceled_nights_data":"","product_name":"PB Roadside Efficiency Suite 1Q 123","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.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"}]},{"room_stay_id":"3046079","reservation_id":"88163","confirmation_number":"PB12330441358","room_stay_from":"2020-01-22","room_stay_to":"2020-01-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"189.75,189.75,200.41,200.41,189.75,189.75","nightly_discount":"0,0,0,0,0,0","subtotal":"1159.82","grand_total":"1310.60","paid_amount":"1310.60","room_type_id":"287","product_id":"1088","siteminder_id":"EXP-1606240235","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":"96412","customer_id":"96412","source_of_creation":"Expedia","reservation_created_date":"2019-12-11 15:52:09","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":"189.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3061305","reservation_id":"89313","confirmation_number":"PB12317880856","room_stay_from":"2020-01-20","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.42,81.42,81.42,81.42","nightly_discount":"0,0,0,0","subtotal":"325.68","grand_total":"368.02","paid_amount":"802.83","room_type_id":"289","product_id":"1105","siteminder_id":"GAM-R1817586256","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":"96367","customer_id":"96367","source_of_creation":"Getaroom.com","reservation_created_date":"2020-01-04 16:15:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"81.42","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":"3060200","reservation_id":"88976","confirmation_number":"PB12391619290","room_stay_from":"2020-01-22","room_stay_to":"2020-01-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.52,67.52,80.59,80.59,74.28,67.52,67.52","nightly_discount":"0,0,0,0,0,0,0","subtotal":"505.54","grand_total":"571.26","paid_amount":"571.26","room_type_id":"289","product_id":"1097","siteminder_id":"GAM-R1809969875","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":"95060","customer_id":"95060","source_of_creation":"Getaroom.com","reservation_created_date":"2019-12-30 18:22:08","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"67.52","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3054963","reservation_id":"89488","confirmation_number":"PB12366402386","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.34,93.34","nightly_discount":"0,0","subtotal":"186.68","grand_total":"210.95","paid_amount":"210.95","room_type_id":"291","product_id":"1116","siteminder_id":"AGO-301334802","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":"96437","customer_id":"96437","source_of_creation":"Agoda","reservation_created_date":"2020-01-07 02:03:07","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":"93.34","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3043647","reservation_id":"87793","confirmation_number":"PB12391240598","room_stay_from":"2020-01-22","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00,210.00,230.00,230.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"994.40","paid_amount":"994.40","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":"94234","customer_id":"94234","source_of_creation":"FE","reservation_created_date":"2019-12-03 02:29:05","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":"210.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3060512","reservation_id":"88156","confirmation_number":"PB12348244508","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"150.00","nightly_discount":"0.00","subtotal":"150.00","grand_total":"169.50","paid_amount":"169.50","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":"96102","customer_id":"96102","source_of_creation":"PMS","reservation_created_date":"2019-12-11 14:12:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"150.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3060518","reservation_id":"90351","confirmation_number":"PB12395197958","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"127.70,127.70","nightly_discount":"0.00,0.00","subtotal":"255.40","grand_total":"288.60","paid_amount":"288.60","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":"94747","customer_id":"94747","source_of_creation":"PMS","reservation_created_date":"2020-01-22 15:52:19","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"127.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3060525","reservation_id":"88839","confirmation_number":"PB12371566257","room_stay_from":"2020-01-19","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.35,90.35,90.35,90.35,90.35","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"451.75","grand_total":"510.48","paid_amount":"496.92","room_type_id":"289","product_id":"1106","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":"29842","customer_id":"29842","source_of_creation":"PMS","reservation_created_date":"2019-12-28 16:23:49","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 121","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":"90.35","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3057018","reservation_id":"88784","confirmation_number":"PB12392353571","room_stay_from":"2020-01-11","room_stay_to":"2020-01-25","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"96.20,83.20,83.20,83.20,83.20,83.20,96.20,96.20,83.20,83.20,83.20,83.20,83.20,83.20","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":"1203.80","grand_total":"1360.30","paid_amount":"1360.30","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"58706","customer_id":"58706","source_of_creation":"PMS","reservation_created_date":"2019-12-27 17:52:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"83.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":"2926412","reservation_id":"67725","confirmation_number":"PB12380073576","room_stay_from":"2020-01-16","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"162.13,162.13,162.13,162.13,162.13,162.13,162.13,162.13,162.13,162.13","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1621.30","grand_total":"1832.07","paid_amount":"1832.07","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":"61502","customer_id":"61502","source_of_creation":"PMS","reservation_created_date":"2019-01-24 20:14:19","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":"162.13","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055282","reservation_id":"88979","confirmation_number":"PB12313663545","room_stay_from":"2020-01-22","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"86.00,86.00,86.00,86.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"344.00","grand_total":"388.72","paid_amount":"388.72","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":"95063","customer_id":"95063","source_of_creation":"PMS","reservation_created_date":"2019-12-30 19:36:15","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":"86.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056276","reservation_id":"89708","confirmation_number":"PB12398691456","room_stay_from":"2020-01-21","room_stay_to":"2020-01-28","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.61,124.61,124.61,213.00,188.85,110.51,100.46","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"986.65","grand_total":"1114.92","paid_amount":"1114.92","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95505","customer_id":"95505","source_of_creation":"PMS","reservation_created_date":"2020-01-10 17:44:17","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"124.61","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3060308","reservation_id":"87060","confirmation_number":"PB12332177735","room_stay_from":"2020-01-21","room_stay_to":"2020-01-28","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"110.00,110.00,110.00,110.00,110.00,110.00,110.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,37.19,0.00","subtotal":"770.00","grand_total":"828.08","paid_amount":"828.08","room_type_id":"289","product_id":"1109","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"89847","customer_id":"89847","source_of_creation":"PMS","reservation_created_date":"2019-11-12 18:32:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"110.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3061066","reservation_id":"90281","confirmation_number":"PB12323284534","room_stay_from":"2020-01-20","room_stay_to":"2020-01-30","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00,105.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1050.00","grand_total":"1186.50","paid_amount":"1186.50","room_type_id":"289","product_id":"1098","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96545","customer_id":"96545","source_of_creation":"PMS","reservation_created_date":"2020-01-20 21:45:40","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3059773","reservation_id":"67943","confirmation_number":"PB12399848605","room_stay_from":"2020-01-19","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,199.00,199.00,199.00,199.00,199.00,199.00,199.00,199.00,199.00,199.00,199.00","nightly_discount":"0.00,109.36,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2388.00","grand_total":"2574.86","paid_amount":"2574.87","room_type_id":"287","product_id":"1090","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"56101","customer_id":"56101","source_of_creation":"PMS","reservation_created_date":"2019-01-27 17:12:48","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"199.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3073594","reservation_id":"69560","confirmation_number":"PB12379957713","room_stay_from":"2020-01-16","room_stay_to":"2020-03-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00,118.00","nightly_discount":"0.00,0.00,0.00,0.23,62.00,118.00,118.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"6018.00","grand_total":"6463.34","paid_amount":"6463.34","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"23037","customer_id":"23037","source_of_creation":"PMS","reservation_created_date":"2019-02-16 01:30:33","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":"118.00","currentDayDiscount":"118.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3073901","reservation_id":"69563","confirmation_number":"PB12323204176","room_stay_from":"2020-01-10","room_stay_to":"2020-03-07","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00,135.00","nightly_discount":"135.00,135.00,121.86,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"7695.00","grand_total":"8252.55","paid_amount":"8252.55","room_type_id":"289","product_id":"1121","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":"55161","customer_id":"55161","source_of_creation":"PMS","reservation_created_date":"2019-02-16 01:39:43","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"135.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3060707","reservation_id":"89227","confirmation_number":"PB12332085801","room_stay_from":"2020-03-10","room_stay_to":"2020-03-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"218.00,218.00,218.00,294.80,294.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1243.60","grand_total":"1405.27","paid_amount":"1405.27","room_type_id":"285","product_id":"1083","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95254","customer_id":"95254","source_of_creation":"PMS","reservation_created_date":"2020-01-03 16:11:43","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3060709","reservation_id":"89227","confirmation_number":"PB12355965055","room_stay_from":"2020-03-10","room_stay_to":"2020-03-15","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"218.00,218.00,218.00,294.80,294.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1243.60","grand_total":"1405.27","paid_amount":"1405.27","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95254","customer_id":"95254","source_of_creation":"PMS","reservation_created_date":"2020-01-03 16:11:43","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"3056988","reservation_id":"89223","confirmation_number":"PB12357170705","room_stay_from":"2020-01-22","room_stay_to":"2020-01-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.35,90.35,125.06,125.06,99.39","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"530.21","grand_total":"530.21","paid_amount":"522.41","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_traveller_id":"95251","customer_id":"95251","source_of_creation":"PMS","reservation_created_date":"2020-01-03 14:37:57","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"90.35","currentDayDiscount":"0.00","productIsTaxExempt":true,"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":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3053369","reservation_id":"89206","confirmation_number":"PB12252257828","room_confirmation_number":"PB12359653428","room_stay_from":"2020-01-19","room_stay_to":"2020-01-23","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":"95233","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-03 04:07:09","reservation_modified_date_time":"2020-01-03 04:07:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95233","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":"3056536","reservation_id":"89743","confirmation_number":"PB12282116112","room_confirmation_number":"PB12389396006","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","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":"96440","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-11 04:13:08","reservation_modified_date_time":"2020-01-11 04:13:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96440","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":"3060209","reservation_id":"90308","confirmation_number":"PB12270648774","room_confirmation_number":"PB12310412113","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","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":"96364","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-21 14:36:11","reservation_modified_date_time":"2020-01-21 14:36:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96364","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":"3060513","reservation_id":"88156","confirmation_number":"PB12229209069","room_confirmation_number":"PB12348244508","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","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":"96102","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-11 14:12:28","reservation_modified_date_time":"2020-01-16 13:24:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96102","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":"3054964","reservation_id":"89488","confirmation_number":"PB12288817341","room_confirmation_number":"PB12366402386","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","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":"96437","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-07 02:03:07","reservation_modified_date_time":"2020-01-07 02:03:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96437","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":"3060519","reservation_id":"90351","confirmation_number":"PB12236105663","room_confirmation_number":"PB12395197958","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","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":"94747","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-22 15:52:19","reservation_modified_date_time":"2020-01-22 15:52:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94747","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":"3060526","reservation_id":"88839","confirmation_number":"PB12214462117","room_confirmation_number":"PB12371566257","room_stay_from":"2020-01-19","room_stay_to":"2020-01-24","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":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"29842","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-28 16:23:49","reservation_modified_date_time":"2019-12-28 16:23:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"29842","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":"3061306","reservation_id":"89313","confirmation_number":"PB12266595266","room_confirmation_number":"PB12317880856","room_stay_from":"2020-01-20","room_stay_to":"2020-01-24","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":"180.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"96367","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-04 16:15:09","reservation_modified_date_time":"2020-01-04 16:15:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96367","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":"3049947","reservation_id":"88643","confirmation_number":"PB12244546328","room_confirmation_number":"PB12394892013","room_stay_from":"2020-01-14","room_stay_to":"2020-01-25","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0,0,0,0,0,0,0,0","subtotal":"220.00","grand_total":"248.60","paid_amount":"248.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"95996","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-24 14:37:11","reservation_modified_date_time":"2019-12-24 14:37:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95996","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3051718","reservation_id":"88908","confirmation_number":"PB12222084755","room_confirmation_number":"PB12360643130","room_stay_from":"2020-01-18","room_stay_to":"2020-01-25","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"96230","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-29 18:47:11","reservation_modified_date_time":"2019-12-29 18:47:11","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96230","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":"3057019","reservation_id":"88784","confirmation_number":"PB12276756880","room_confirmation_number":"PB12392353571","room_stay_from":"2020-01-11","room_stay_to":"2020-01-25","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":"58706","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-27 17:52:28","reservation_modified_date_time":"2019-12-27 17:52:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"58706","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":"3061674","reservation_id":"84515","confirmation_number":"PB12241798263","room_confirmation_number":"PB12350761510","room_stay_from":"2020-01-18","room_stay_to":"2020-01-25","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"96209","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-09-22 01:17:11","reservation_modified_date_time":"2020-01-25 19:31:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96209","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":"2926413","reservation_id":"67725","confirmation_number":"PB12251039380","room_confirmation_number":"PB12380073576","room_stay_from":"2020-01-16","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"61502","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-24 20:14:19","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"61502","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":"3043648","reservation_id":"87793","confirmation_number":"PB12229826827","room_confirmation_number":"PB12391240598","room_stay_from":"2020-01-22","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"94234","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-03 02:29:05","reservation_modified_date_time":"2019-12-03 02:29:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94234","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":"3049825","reservation_id":"88621","confirmation_number":"PB12242765076","room_confirmation_number":"PB12331663880","room_stay_from":"2020-01-21","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"96687","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-23 20:52:10","reservation_modified_date_time":"2019-12-23 20:52:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96687","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":"3050606","reservation_id":"88708","confirmation_number":"PB12255244588","room_confirmation_number":"PB12319001217","room_stay_from":"2020-01-22","room_stay_to":"2020-01-26","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":"96686","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-26 01:37:09","reservation_modified_date_time":"2019-12-26 01:37:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96686","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":"3053343","reservation_id":"89202","confirmation_number":"PB12225092008","room_confirmation_number":"PB12329434252","room_stay_from":"2020-01-13","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0,0,0,0,0,0,0,0","subtotal":"260.00","grand_total":"293.80","paid_amount":"293.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95950","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-03 03:26:06","reservation_modified_date_time":"2020-01-03 03:26:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95950","canceled_nights_data":"","currentDayPrice":"20.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055283","reservation_id":"88979","confirmation_number":"PB12288507393","room_confirmation_number":"PB12313663545","room_stay_from":"2020-01-22","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"95063","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-30 19:36:15","reservation_modified_date_time":"2019-12-30 19:36:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95063","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":"3046080","reservation_id":"88163","confirmation_number":"PB12297529008","room_confirmation_number":"PB12330441358","room_stay_from":"2020-01-22","room_stay_to":"2020-01-28","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":"96412","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-11 15:52:09","reservation_modified_date_time":"2019-12-11 15:52:09","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96412","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":"3056277","reservation_id":"89708","confirmation_number":"PB12262208006","room_confirmation_number":"PB12398691456","room_stay_from":"2020-01-21","room_stay_to":"2020-01-28","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":"95505","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-10 17:44:17","reservation_modified_date_time":"2020-01-10 17:44:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95505","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":"3060309","reservation_id":"87060","confirmation_number":"PB12242542416","room_confirmation_number":"PB12332177735","room_stay_from":"2020-01-21","room_stay_to":"2020-01-28","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":"89847","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-11-12 18:32:55","reservation_modified_date_time":"2020-01-21 20:50:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"89847","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":"3060201","reservation_id":"88976","confirmation_number":"PB12248537718","room_confirmation_number":"PB12391619290","room_stay_from":"2020-01-22","room_stay_to":"2020-01-29","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"95060","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-30 18:22:08","reservation_modified_date_time":"2019-12-30 18:22:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95060","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":"3061067","reservation_id":"90281","confirmation_number":"PB12243148815","room_confirmation_number":"PB12323284534","room_stay_from":"2020-01-20","room_stay_to":"2020-01-30","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"96545","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-20 21:45:40","reservation_modified_date_time":"2020-01-23 18:38:41","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96545","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3059774","reservation_id":"67943","confirmation_number":"PB12255339342","room_confirmation_number":"PB12399848605","room_stay_from":"2020-01-19","room_stay_to":"2020-01-31","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"56101","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-27 17:12:48","reservation_modified_date_time":"2020-01-19 23:27:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56101","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3073595","reservation_id":"69560","confirmation_number":"PB12280777443","room_confirmation_number":"PB12379957713","room_stay_from":"2020-01-16","room_stay_to":"2020-03-07","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23037","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-16 01:30:33","reservation_modified_date_time":"2020-02-24 17:14:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23037","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3073902","reservation_id":"69563","confirmation_number":"PB12286550383","room_confirmation_number":"PB12323204176","room_stay_from":"2020-01-10","room_stay_to":"2020-03-07","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"55161","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-16 01:39:43","reservation_modified_date_time":"2020-02-25 02:47:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"55161","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[{"room_stay_id":"3056989","reservation_id":"89223","confirmation_number":"PB12233657153","room_confirmation_number":"PB12357170705","room_stay_from":"2020-01-22","room_stay_to":"2020-01-27","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":"60.00","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"95251","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-03 14:37:57","reservation_modified_date_time":"2020-01-03 14:37:57","collect_which":"","tax_exempt_status":"1","traveller_tax_exempt":"1","customer_id":"95251","canceled_nights_data":"","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":true,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.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":3,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1140","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BV12279318287","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3059792","reservation_id":"87273","confirmation_number":"BV12411156288","room_stay_from":"2020-01-20","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"105.29,105.29,105.29","nightly_discount":"0,0,0","subtotal":"315.87","grand_total":"356.93","paid_amount":"356.93","room_type_id":"304","product_id":"1221","siteminder_id":"EXP-1600296719","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":"79611","customer_id":"79611","source_of_creation":"Expedia","reservation_created_date":"2020-01-20 01:23:18","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"105.29","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":"3060520","reservation_id":"90352","confirmation_number":"BV12476800165","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"78.13","nightly_discount":"0","subtotal":"78.13","grand_total":"88.29","paid_amount":"88.29","room_type_id":"307","product_id":"1224","siteminder_id":"EXP-1627732373","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":"96435","customer_id":"96435","source_of_creation":"Expedia","reservation_created_date":"2020-01-22 16:18:10","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"78.13","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":"3059804","reservation_id":"90238","confirmation_number":"BV12485585025","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.87,89.87","nightly_discount":"0,0","subtotal":"179.74","grand_total":"203.10","paid_amount":"203.10","room_type_id":"309","product_id":"1226","siteminder_id":"EXP-1626090137","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":"96414","customer_id":"96414","source_of_creation":"Expedia","reservation_created_date":"2020-01-20 03:33:05","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"89.87","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3059814","reservation_id":"90242","confirmation_number":"BV12456725089","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.23,100.23","nightly_discount":"0,0","subtotal":"200.46","grand_total":"226.52","paid_amount":"226.52","room_type_id":"303","product_id":"1139","siteminder_id":"GCC-0005300057-a6c","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96294","customer_id":"96294","source_of_creation":"GuestCentric Systems","reservation_created_date":"2020-01-20 13:37:07","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"100.23","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gcc_non_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3051487","reservation_id":"88856","confirmation_number":"BV12485699294","room_stay_from":"2020-01-22","room_stay_to":"2020-01-27","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.00,91.00,114.40,114.40,91.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"501.80","grand_total":"567.04","paid_amount":"567.04","room_type_id":"304","product_id":"1220","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"94985","customer_id":"94985","source_of_creation":"FE","reservation_created_date":"2019-12-28 20:28:10","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"91.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3060799","reservation_id":"90062","confirmation_number":"BV12449460806","room_stay_from":"2020-01-28","room_stay_to":"2020-01-31","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.00,109.45,97.13","nightly_discount":"0.00,0.00,0.00","subtotal":"349.58","grand_total":"395.02","paid_amount":"395.02","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96093","customer_id":"96093","source_of_creation":"FE","reservation_created_date":"2020-01-16 03:52:55","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","changedComment":"From date changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3008157","reservation_id":"76634","confirmation_number":"BV12419997012","room_stay_from":"2020-01-22","room_stay_to":"2020-01-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,149.00,149.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"943.00","grand_total":"1065.59","paid_amount":"1065.59","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"66880","customer_id":"66880","source_of_creation":"PMS","reservation_created_date":"2019-05-16 22:54:09","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3008159","reservation_id":"76634","confirmation_number":"BV12439591329","room_stay_from":"2020-01-22","room_stay_to":"2020-01-29","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00,149.00,149.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"943.00","grand_total":"1065.59","paid_amount":"1065.59","room_type_id":"308","product_id":"1225","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"66880","customer_id":"66880","source_of_creation":"PMS","reservation_created_date":"2019-05-16 22:54:09","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"129.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2932109","reservation_id":"68769","confirmation_number":"BV12487057372","room_stay_from":"2020-01-15","room_stay_to":"2020-02-08","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"2736.00","grand_total":"3091.68","paid_amount":"3091.68","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"34656","customer_id":"34656","source_of_creation":"PMS","reservation_created_date":"2019-02-06 18:46:33","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"2938851","reservation_id":"70051","confirmation_number":"BV12471710295","room_stay_from":"2020-01-19","room_stay_to":"2020-03-13","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,114.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"7427.00","grand_total":"8392.51","paid_amount":"8392.51","room_type_id":"305","product_id":"1222","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":"46265","customer_id":"46265","source_of_creation":"PMS","reservation_created_date":"2019-02-22 18:13:15","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"114.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056006","reservation_id":"69773","confirmation_number":"BV12434890851","room_stay_from":"2020-01-08","room_stay_to":"2020-03-14","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04,166.04","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,60.62,166.04,166.04,166.04","subtotal":"10958.64","grand_total":"11751.88","paid_amount":"11751.88","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"24672","customer_id":"24672","source_of_creation":"PMS","reservation_created_date":"2019-02-18 22:04:05","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"166.04","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3059793","reservation_id":"87273","confirmation_number":"BV12270833758","room_confirmation_number":"BV12411156288","room_stay_from":"2020-01-20","room_stay_to":"2020-01-23","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"79611","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-20 01:23:18","reservation_modified_date_time":"2020-01-20 01:23:18","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"79611","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":"3060521","reservation_id":"90352","confirmation_number":"BV12226738424","room_confirmation_number":"BV12476800165","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","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":"96435","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-22 16:18:10","reservation_modified_date_time":"2020-01-22 16:18:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96435","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":"3059805","reservation_id":"90238","confirmation_number":"BV12244014413","room_confirmation_number":"BV12485585025","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","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":"96414","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-20 03:33:05","reservation_modified_date_time":"2020-01-20 03:33:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96414","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":"3059815","reservation_id":"90242","confirmation_number":"BV12253366302","room_confirmation_number":"BV12456725089","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","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":"96294","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-20 13:37:07","reservation_modified_date_time":"2020-01-20 13:37:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96294","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":"3051488","reservation_id":"88856","confirmation_number":"BV12219177455","room_confirmation_number":"BV12485699294","room_stay_from":"2020-01-22","room_stay_to":"2020-01-27","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":"94985","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-12-28 20:28:10","reservation_modified_date_time":"2019-12-28 20:28:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"94985","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":"3008158","reservation_id":"76634","confirmation_number":"BV12246207648","room_confirmation_number":"BV12419997012","room_stay_from":"2020-01-22","room_stay_to":"2020-01-29","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":"66880","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-16 22:54:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66880","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":"3008160","reservation_id":"76634","confirmation_number":"BV12277195294","room_confirmation_number":"BV12439591329","room_stay_from":"2020-01-22","room_stay_to":"2020-01-29","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":"66880","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-05-16 22:54:09","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"66880","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":"2932110","reservation_id":"68769","confirmation_number":"BV12285029013","room_confirmation_number":"BV12487057372","room_stay_from":"2020-01-15","room_stay_to":"2020-02-08","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"288.00","grand_total":"325.44","paid_amount":"325.44","product_id":"1781","service_quantity":"1","customer_traveller_id":"34656","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-06 18:46:33","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"34656","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":"2938852","reservation_id":"70051","confirmation_number":"BV12258117083","room_confirmation_number":"BV12471710295","room_stay_from":"2020-01-19","room_stay_to":"2020-03-13","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"46265","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-22 18:13:15","reservation_modified_date_time":"0000-00-00 00:00:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"46265","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3056007","reservation_id":"69773","confirmation_number":"BV12212358815","room_confirmation_number":"BV12434890851","room_stay_from":"2020-01-08","room_stay_to":"2020-03-14","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"24672","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-18 22:04:05","reservation_modified_date_time":"2020-01-09 21:11:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"24672","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gift_shop_taxable":[{"room_stay_id":"3060814","reservation_id":"90238","confirmation_number":"BV12241963979","room_confirmation_number":"BV12485585025","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-23 03:06:33","reservation_modified_date_time":"2020-01-23 03:06:33","customer_id":"96414","parentCustTravId":"96414","customer_traveller_id":"96414","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":5,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3060452","reservation_id":"90337","confirmation_number":"BP12575017040","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"71.65,83.59","nightly_discount":"0,0","subtotal":"155.24","grand_total":"175.42","paid_amount":"175.42","room_type_id":"293","product_id":"1124","siteminder_id":"BDC-3335781139","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":"96387","customer_id":"96387","source_of_creation":"Booking.com","reservation_created_date":"2020-01-22 01:56:11","canceled_nights_data":"","product_name":"BP Standard Room 2D 108","ota_service_fee_amount":"0","commision_charges":"35.14","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"83.59","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"3050678","reservation_id":"88717","confirmation_number":"BP12587673305","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"68.17","nightly_discount":"0","subtotal":"68.17","grand_total":"77.03","paid_amount":"77.03","room_type_id":"298","product_id":"1133","siteminder_id":"EXP-1612748263","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":"96465","customer_id":"96465","source_of_creation":"Expedia","reservation_created_date":"2019-12-26 16:57:05","canceled_nights_data":"","product_name":"BP Standard Room 1Q 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"68.17","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_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[{"room_stay_id":"3060315","reservation_id":"90320","confirmation_number":"BP12579283786","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"59.19,59.19","nightly_discount":"0,0","subtotal":"118.38","grand_total":"133.77","paid_amount":"133.77","room_type_id":"289","product_id":"1099","siteminder_id":"HWR-301676555","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":"96372","customer_id":"96372","source_of_creation":"Hotwire","reservation_created_date":"2020-01-21 19:39:10","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":"59.19","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":"3060444","reservation_id":"90331","confirmation_number":"BP12511629374","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","room_stay_status":"Closed","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"59.19,59.18","nightly_discount":"0.00,0.00","subtotal":"118.37","grand_total":"133.76","paid_amount":"133.76","room_type_id":"295","product_id":"1128","siteminder_id":"HWR-301680658","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":"96382","customer_id":"96382","source_of_creation":"Hotwire","reservation_created_date":"2020-01-21 23:30:09","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"59.18","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"hwr_non_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3051545","reservation_id":"88869","confirmation_number":"BP12525949679","room_stay_from":"2020-01-16","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"66.01,67.98,67.98,67.95,66.01,66.01,66.01,66.01,79.15,79.15","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"692.26","grand_total":"782.26","paid_amount":"782.26","room_type_id":"295","product_id":"1129","siteminder_id":"AGO-299503918","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"96126","customer_id":"96126","source_of_creation":"Agoda","reservation_created_date":"2019-12-28 23:39:08","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"66.01","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":"3052068","reservation_id":"88968","confirmation_number":"BP12590386482","room_stay_from":"2020-01-16","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"4","room_stay_child_count":"0","nightly_price":"72.09,73.68,73.68,74.23,72.09,72.09,72.09,72.09,85.88,85.88","nightly_discount":"0,0,0,0,0,0,0,0,0,0","subtotal":"753.80","grand_total":"851.80","paid_amount":"851.80","room_type_id":"294","product_id":"1125","siteminder_id":"AGO-299825274","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"200.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"95052","customer_id":"95052","source_of_creation":"Agoda","reservation_created_date":"2019-12-30 17:03:07","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"72.09","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3056085","reservation_id":"85249","confirmation_number":"BP12548475728","room_stay_from":"2020-01-09","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"144.00,144.00,144.00,144.00,164.00,164.00,144.00,144.00,144.00,144.00,144.00,164.00,164.00,144.00,144.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,132.41,0.00","subtotal":"2240.00","grand_total":"2381.58","paid_amount":"2381.58","room_type_id":"296","product_id":"1131","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"33409","customer_id":"33409","source_of_creation":"PMS","reservation_created_date":"2019-10-07 13:41:48","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"144.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3059703","reservation_id":"90214","confirmation_number":"BP12513238998","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00","nightly_discount":"0.00,0.00","subtotal":"178.00","grand_total":"201.14","paid_amount":"201.14","room_type_id":"299","product_id":"1134","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":"96265","customer_id":"96265","source_of_creation":"PMS","reservation_created_date":"2020-01-19 19:59:20","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 215","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":"3059475","reservation_id":"89416","confirmation_number":"BP12538247846","room_stay_from":"2020-01-18","room_stay_to":"2020-01-26","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.93,109.21,83.85,98.85,98.85,98.85,172.19,172.19","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,46.73,0.00","subtotal":"974.92","grand_total":"1048.85","paid_amount":"1048.85","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"37586","customer_id":"37586","source_of_creation":"PMS","reservation_created_date":"2020-01-05 21:23:39","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 205","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"98.85","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055088","reservation_id":"69585","confirmation_number":"BP12549690899","room_stay_from":"2020-01-07","room_stay_to":"2020-02-20","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00,145.00","nightly_discount":"100.00,100.00,100.00,10.18,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,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":"6380.00","grand_total":"6858.90","paid_amount":"6858.90","room_type_id":"302","product_id":"1138","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"46530","customer_id":"46530","source_of_creation":"PMS","reservation_created_date":"2019-02-16 16:13:23","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"145.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082907","reservation_id":"67475","confirmation_number":"BP12551251808","room_stay_from":"2020-01-18","room_stay_to":"2020-03-18","room_stay_status":"Closed","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00,115.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,95.75,95.75,95.75,95.75","subtotal":"6900.00","grand_total":"7364.21","paid_amount":"7364.21","room_type_id":"301","product_id":"1137","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":"26029","customer_id":"26029","source_of_creation":"PMS","reservation_created_date":"2019-01-21 18:47:47","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 1Q, 2SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","currentDayPrice":"115.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3050679","reservation_id":"88717","confirmation_number":"BP12277281514","room_confirmation_number":"BP12587673305","room_stay_from":"2020-01-22","room_stay_to":"2020-01-23","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":"96465","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-26 16:57:05","reservation_modified_date_time":"2019-12-26 16:57:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96465","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":"3060316","reservation_id":"90320","confirmation_number":"BP12298506548","room_confirmation_number":"BP12579283786","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","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":"96372","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-21 19:39:10","reservation_modified_date_time":"2020-01-21 19:39:10","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96372","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":"3060445","reservation_id":"90331","confirmation_number":"BP12210309383","room_confirmation_number":"BP12511629374","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","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":"96382","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-21 23:30:09","reservation_modified_date_time":"2020-01-22 01:11:06","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96382","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":"3060453","reservation_id":"90337","confirmation_number":"BP12284261543","room_confirmation_number":"BP12575017040","room_stay_from":"2020-01-21","room_stay_to":"2020-01-23","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":"96387","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-01-22 01:56:11","reservation_modified_date_time":"2020-01-22 01:56:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96387","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":"3056086","reservation_id":"85249","confirmation_number":"BP12268512018","room_confirmation_number":"BP12548475728","room_stay_from":"2020-01-09","room_stay_to":"2020-01-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"180.00","grand_total":"203.40","paid_amount":"203.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"33409","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-10-07 13:41:48","reservation_modified_date_time":"2020-01-09 22:21:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"33409","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":"3059704","reservation_id":"90214","confirmation_number":"BP12215319714","room_confirmation_number":"BP12513238998","room_stay_from":"2020-01-22","room_stay_to":"2020-01-24","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":"96265","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-19 19:59:20","reservation_modified_date_time":"2020-01-19 19:59:20","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96265","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":"3051547","reservation_id":"88869","confirmation_number":"BP12263885085","room_confirmation_number":"BP12525949679","room_stay_from":"2020-01-16","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"96126","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-28 23:39:08","reservation_modified_date_time":"2019-12-28 23:39:08","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"96126","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":"3052070","reservation_id":"88968","confirmation_number":"BP12217771701","room_confirmation_number":"BP12590386482","room_stay_from":"2020-01-16","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"200.00","grand_total":"226.00","paid_amount":"226.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"95052","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2019-12-30 17:03:07","reservation_modified_date_time":"2019-12-30 17:03:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"95052","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":"3059476","reservation_id":"89416","confirmation_number":"BP12216605208","room_confirmation_number":"BP12538247846","room_stay_from":"2020-01-18","room_stay_to":"2020-01-26","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"37586","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-05 21:23:39","reservation_modified_date_time":"2020-01-18 21:56:04","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"37586","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3055089","reservation_id":"69585","confirmation_number":"BP12283624317","room_confirmation_number":"BP12549690899","room_stay_from":"2020-01-07","room_stay_to":"2020-02-20","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"46530","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-02-16 16:13:23","reservation_modified_date_time":"2020-01-07 19:35:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"46530","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3082908","reservation_id":"67475","confirmation_number":"BP12294852803","room_confirmation_number":"BP12551251808","room_stay_from":"2020-01-18","room_stay_to":"2020-03-18","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"26029","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-01-21 18:47:47","reservation_modified_date_time":"2020-03-17 13:31:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"26029","canceled_nights_data":"","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gift_shop_taxable":[{"room_stay_id":"2936334","reservation_id":"69585","confirmation_number":"BP12214447507","room_confirmation_number":"BP12549690899","room_stay_from":"2020-01-04","room_stay_to":"2020-02-22","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2019-02-16 16:13:23","reservation_modified_date_time":"0000-00-00 00:00:00","customer_id":"46530","parentCustTravId":"46530","customer_traveller_id":"46530","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3056034","reservation_id":"85249","confirmation_number":"BP12238920508","room_confirmation_number":"BP12548475728","room_stay_from":"2020-01-09","room_stay_to":"2020-01-24","room_stay_status":"Active","nightly_price":"25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00,25.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"375.00","grand_total":"423.75","paid_amount":"423.75","product_id":"1215","service_quantity":"1","product_name":"Traveling with Pet","parentTypeOfRes":"reservation","reservation_created_date":"2020-01-09 22:16:26","reservation_modified_date_time":"2020-01-09 22:16:26","customer_id":"33409","parentCustTravId":"33409","customer_traveller_id":"33409","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}