{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2021-01-13","total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":12,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1126,1137,1138,1132,1131,1104","block_room_bookings":[{"confirmation_number":"BP12247304091","room_stay_from":"2021-01-13","room_stay_to":"2021-01-14","bundle_room":"0"},{"confirmation_number":"BP12228743539","room_stay_from":"2021-01-13","room_stay_to":"2021-01-14","bundle_room":"0"},{"confirmation_number":"BP12226285648","room_stay_from":"2021-01-13","room_stay_to":"2021-01-14","bundle_room":"0"},{"confirmation_number":"BP12251608311","room_stay_from":"2021-01-13","room_stay_to":"2021-01-14","bundle_room":"0"},{"confirmation_number":"BP12224251323","room_stay_from":"2021-01-13","room_stay_to":"2021-01-14","bundle_room":"0"},{"confirmation_number":"PB12210454164","room_stay_from":"2021-01-12","room_stay_to":"2021-01-15","bundle_room":"0"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3175195","reservation_id":"104471","confirmation_number":"BV12435886616","room_stay_from":"2021-01-06","room_stay_to":"2021-01-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"75.15,75.15,85.85,85.85,75.15,75.15,75.15,75.15","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"622.60","grand_total":"703.54","paid_amount":"703.54","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-2705929551","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111226","customer_id":"111226","source_of_creation":"Booking.com","reservation_created_date":"2020-12-31 17:11:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"155.27","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"75.15","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":[],"exp_non_taxable":[{"room_stay_id":"3178578","reservation_id":"103929","confirmation_number":"PB12365765583","room_stay_from":"2021-01-04","room_stay_to":"2021-01-07","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.25,176.25,176.25","nightly_discount":"0,0,0","subtotal":"528.75","grand_total":"597.49","paid_amount":"0.00","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1723658395","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":"110245","customer_id":"110245","source_of_creation":"Expedia","reservation_created_date":"2020-12-17 23:16:16","service_canceled_date_time":"2021-01-13 19:31:25","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"canceled resv amount refunded","total_paid_amount":"0.00","deltaChange":"0.00","changedComment":"resv paid or refunded after cancel","currentDayPrice":0,"currentDayDiscount":0,"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"}]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3178081","reservation_id":"104591","confirmation_number":"BP12550463246","room_stay_from":"2021-01-13","room_stay_to":"2021-01-19","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.03,67.03,75.47,75.47,67.03,67.03","nightly_discount":"0,0,0,0,0,0","subtotal":"419.06","grand_total":"473.53","paid_amount":"473.53","room_type_id":"300","product_id":"1135","siteminder_id":"GAM-R2266317965","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":"111610","customer_id":"111610","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-02 18:26:12","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 805","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"67.03","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178582","reservation_id":"104373","confirmation_number":"PB12335484385","room_stay_from":"2021-01-13","room_stay_to":"2021-01-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.90,83.90,88.11,88.11,83.90,83.90,83.90,83.90","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"679.62","grand_total":"767.97","paid_amount":"767.97","room_type_id":"289","product_id":"1108","siteminder_id":"GAM-R2261067163","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":"32503","customer_id":"32503","source_of_creation":"Getaroom.com","reservation_created_date":"2020-12-29 16:30:10","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":"","promotion_code":"","currentDayPrice":"83.90","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3178689","reservation_id":"105263","confirmation_number":"PB12398441940","room_stay_from":"2021-01-13","room_stay_to":"2021-01-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.55,141.55,141.55","nightly_discount":"0,0,0","subtotal":"424.65","grand_total":"479.86","paid_amount":"479.86","room_type_id":"291","product_id":"1119","siteminder_id":"GCC-1106400117-064","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111647","customer_id":"111647","source_of_creation":"GuestCentric Systems","reservation_created_date":"2021-01-13 08:24:13","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","currentDayPrice":"141.55","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":"3177699","reservation_id":"105172","confirmation_number":"BV12427694483","room_stay_from":"2021-01-11","room_stay_to":"2021-01-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.10,108.10,108.10","nightly_discount":"0,0,0","subtotal":"324.30","grand_total":"366.46","paid_amount":"366.46","room_type_id":"309","product_id":"1226","siteminder_id":"AGO-365004226","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":"111571","customer_id":"111571","source_of_creation":"Agoda","reservation_created_date":"2021-01-11 16:08:14","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":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"108.10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178728","reservation_id":"105291","confirmation_number":"PB12338481877","room_stay_from":"2021-01-13","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"134.46,134.46","nightly_discount":"0.00,0.00","subtotal":"268.92","grand_total":"303.88","paid_amount":"303.88","room_type_id":"291","product_id":"1115","siteminder_id":"AGO-365428346","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111695","customer_id":"111695","source_of_creation":"Agoda","reservation_created_date":"2021-01-13 22:14:09","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":"","promotion_code":null,"currentDayPrice":"134.46","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178285","reservation_id":"104896","confirmation_number":"PB12355351079","room_stay_from":"2021-01-12","room_stay_to":"2021-01-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.30,100.30,100.30,105.34,105.34","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"511.58","grand_total":"578.08","paid_amount":"578.08","room_type_id":"289","product_id":"1109","siteminder_id":"AGO-364113110","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111634","customer_id":"111634","source_of_creation":"Agoda","reservation_created_date":"2021-01-06 22:20:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"100.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3177845","reservation_id":"103704","confirmation_number":"PB12349619011","room_stay_from":"2021-01-11","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00,23.25","subtotal":"556.00","grand_total":"602.01","paid_amount":"602.01","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":"109955","customer_id":"109955","source_of_creation":"FE","reservation_created_date":"2020-12-11 00:52:27","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3177101","reservation_id":"102544","confirmation_number":"BV12480439730","room_stay_from":"2021-01-10","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"90.00,90.00,90.00,90.00,90.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"450.00","grand_total":"508.50","paid_amount":"508.50","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":"108700","customer_id":"108700","source_of_creation":"PMS","reservation_created_date":"2020-11-11 17:56:34","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"90.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177387","reservation_id":"105151","confirmation_number":"BV12455266204","room_stay_from":"2021-01-10","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"495.00","grand_total":"559.35","paid_amount":"559.35","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":"111534","customer_id":"111534","source_of_creation":"PMS","reservation_created_date":"2021-01-11 03:35:05","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178105","reservation_id":"105193","confirmation_number":"PB12390391269","room_stay_from":"2021-01-12","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,19.55,0.00","subtotal":"357.00","grand_total":"381.32","paid_amount":"381.32","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":"111569","customer_id":"111569","source_of_creation":"PMS","reservation_created_date":"2021-01-11 22:08:50","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"119.00","currentDayDiscount":"19.55","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178372","reservation_id":"105267","confirmation_number":"PB12316306933","room_stay_from":"2021-01-13","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,199.00","nightly_discount":"0.00,0.00","subtotal":"398.00","grand_total":"449.74","paid_amount":"449.74","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111652","customer_id":"111652","source_of_creation":"PMS","reservation_created_date":"2021-01-13 14:18:50","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"3178457","reservation_id":"105197","confirmation_number":"BP12555071860","room_stay_from":"2021-01-11","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"85.00,85.00,85.00,85.00","nightly_discount":"0.00,0.00,0,0","subtotal":"340.00","grand_total":"384.20","paid_amount":"384.20","room_type_id":"294","product_id":"1125","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":"110343","customer_id":"110343","source_of_creation":"PMS","reservation_created_date":"2021-01-11 23:48:23","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"85.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":"3178684","reservation_id":"104878","confirmation_number":"BP12594143409","room_stay_from":"2021-01-12","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","room_type_id":"315","product_id":"1230","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":"111232","customer_id":"111232","source_of_creation":"PMS","reservation_created_date":"2021-01-06 19:36:54","canceled_nights_data":"","product_name":"BP Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"3177851","reservation_id":"97410","confirmation_number":"PB12323864250","room_stay_from":"2021-01-11","room_stay_to":"2021-01-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00,230.00,230.00,230.00,230.00,230.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,61.00","subtotal":"1360.00","grand_total":"1467.87","paid_amount":"1467.87","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":"103492","customer_id":"103492","source_of_creation":"PMS","reservation_created_date":"2020-07-05 14:39:38","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"230.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3172578","reservation_id":"89484","confirmation_number":"PB12343358805","room_stay_from":"2020-12-30","room_stay_to":"2021-01-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.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,135.75","subtotal":"2793.00","grand_total":"3002.70","paid_amount":"3002.70","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":"69129","customer_id":"69129","source_of_creation":"PMS","reservation_created_date":"2020-01-07 01:53:17","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"147.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3175795","reservation_id":"104427","confirmation_number":"PB12391367287","room_stay_from":"2021-01-07","room_stay_to":"2021-01-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,139.00,139.00,119.00,119.00,119.00,119.00,119.00,139.00,139.00,119.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.00","subtotal":"1389.00","grand_total":"1490.47","paid_amount":"1490.47","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"25658","customer_id":"25658","source_of_creation":"PMS","reservation_created_date":"2020-12-30 15:28:59","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177676","reservation_id":"105189","confirmation_number":"BP12573685586","room_stay_from":"2021-01-11","room_stay_to":"2021-01-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.00,90.00,90.00,90.00,105.00,105.00,90.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,35.00","subtotal":"660.00","grand_total":"706.25","paid_amount":"706.25","room_type_id":"295","product_id":"1128","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111565","customer_id":"111565","source_of_creation":"PMS","reservation_created_date":"2021-01-11 20:53:05","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"90.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3175258","reservation_id":"102045","confirmation_number":"PB12313088012","room_stay_from":"2021-01-06","room_stay_to":"2021-01-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.00,148.00,128.00,128.00,128.00,128.00,128.00,148.00,148.00,128.00,128.00,128.00,128.00,128.00,128.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,101.60","subtotal":"2000.00","grand_total":"2145.19","paid_amount":"2145.19","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108164","customer_id":"108164","source_of_creation":"PMS","reservation_created_date":"2020-10-28 19:17:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"148.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178461","reservation_id":"104883","confirmation_number":"PB12326562603","room_stay_from":"2021-01-12","room_stay_to":"2021-01-13","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"30.51","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111237","customer_id":"111237","source_of_creation":"PMS","reservation_created_date":"2021-01-06 20:02:25","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"3178596","reservation_id":"91591","confirmation_number":"PB12374480147","room_stay_from":"2021-02-14","room_stay_to":"2021-02-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"158.00,158.00,158.00,158.00,158.00,158.00,158.00,158.00,158.00,158.00,158.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1738.00","grand_total":"1963.94","paid_amount":"178.54","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":"56258","customer_id":"56258","source_of_creation":"PMS","reservation_created_date":"2020-02-08 18:02:42","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":"","promotion_code":"","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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3178726","reservation_id":"105291","confirmation_number":"PB12233425770","room_confirmation_number":"PB12338481877","room_stay_from":"2021-01-13","room_stay_to":"2021-01-15","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"111695","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-01-14 02:39:14","reservation_modified_date_time":"2021-01-14 02:43:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111695","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177629","reservation_id":"104173","confirmation_number":"PB12239684757","room_confirmation_number":"PB12338946037","room_stay_from":"2021-01-11","room_stay_to":"2021-01-13","room_stay_status":"Canceled","nightly_price":"20,20","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-11 19:46:25","reservation_modified_date_time":"2021-01-11 19:51:35","customer_id":"111561","parentCustTravId":"111561","customer_traveller_id":"111561","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-01-13 14:34:18","canceled_nights_data":"","product_attribute_values":"extra_person#&#10.00","parentRoomStayFrom":"2021-01-11","deltaChange":-40,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3175197","reservation_id":"104471","confirmation_number":"BV12266831259","room_confirmation_number":"BV12435886616","room_stay_from":"2021-01-06","room_stay_to":"2021-01-14","room_stay_status":"Active","nightly_price":"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","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"111226","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-12-31 17:11:12","reservation_modified_date_time":"2021-01-06 20:08:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111226","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.00","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177698","reservation_id":"105172","confirmation_number":"BV12264236572","room_confirmation_number":"BV12427694483","room_stay_from":"2021-01-11","room_stay_to":"2021-01-14","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":"111571","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-01-11 16:08:14","reservation_modified_date_time":"2021-01-11 23:00:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111571","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177102","reservation_id":"102544","confirmation_number":"BV12238880009","room_confirmation_number":"BV12480439730","room_stay_from":"2021-01-10","room_stay_to":"2021-01-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"108700","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-11 17:56:34","reservation_modified_date_time":"2021-01-10 15:45:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108700","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177388","reservation_id":"105151","confirmation_number":"BV12267242919","room_confirmation_number":"BV12455266204","room_stay_from":"2021-01-10","room_stay_to":"2021-01-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"111534","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-11 03:35:05","reservation_modified_date_time":"2021-01-11 03:35:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111534","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177846","reservation_id":"103704","confirmation_number":"PB12218404762","room_confirmation_number":"PB12349619011","room_stay_from":"2021-01-11","room_stay_to":"2021-01-15","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":"109955","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-12-11 00:52:27","reservation_modified_date_time":"2021-01-12 02:26:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109955","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178106","reservation_id":"105193","confirmation_number":"PB12290358056","room_confirmation_number":"PB12390391269","room_stay_from":"2021-01-12","room_stay_to":"2021-01-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"111569","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-11 22:08:50","reservation_modified_date_time":"2021-01-12 18:01:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111569","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178373","reservation_id":"105267","confirmation_number":"PB12288658286","room_confirmation_number":"PB12316306933","room_stay_from":"2021-01-13","room_stay_to":"2021-01-15","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":"111653","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-13 14:18:50","reservation_modified_date_time":"2021-01-13 14:18:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111652","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178458","reservation_id":"105197","confirmation_number":"BP12256029231","room_confirmation_number":"BP12555071860","room_stay_from":"2021-01-11","room_stay_to":"2021-01-15","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":"110343","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-11 23:48:23","reservation_modified_date_time":"2021-01-13 15:47:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110343","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178685","reservation_id":"104878","confirmation_number":"BP12257711731","room_confirmation_number":"BP12594143409","room_stay_from":"2021-01-12","room_stay_to":"2021-01-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"111232","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-06 19:36:54","reservation_modified_date_time":"2021-01-13 22:36:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111232","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178727","reservation_id":"105291","confirmation_number":"PB12276405951","room_confirmation_number":"PB12338481877","room_stay_from":"2021-01-13","room_stay_to":"2021-01-15","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"111695","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-01-13 22:14:09","reservation_modified_date_time":"2021-01-14 02:43:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111695","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178690","reservation_id":"105263","confirmation_number":"PB12276543708","room_confirmation_number":"PB12398441940","room_stay_from":"2021-01-13","room_stay_to":"2021-01-16","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"111647","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-01-13 08:24:13","reservation_modified_date_time":"2021-01-13 23:50:27","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111647","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177852","reservation_id":"97410","confirmation_number":"PB12254694145","room_confirmation_number":"PB12323864250","room_stay_from":"2021-01-11","room_stay_to":"2021-01-17","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"103492","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-07-05 14:39:38","reservation_modified_date_time":"2021-01-12 02:44:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103492","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178284","reservation_id":"104896","confirmation_number":"PB12259157508","room_confirmation_number":"PB12355351079","room_stay_from":"2021-01-12","room_stay_to":"2021-01-17","room_stay_status":"Active","nightly_price":"20,20,20,20,20","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":"111634","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-01-06 22:20:07","reservation_modified_date_time":"2021-01-13 02:00:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111634","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3172580","reservation_id":"89484","confirmation_number":"PB12250641004","room_confirmation_number":"PB12343358805","room_stay_from":"2020-12-30","room_stay_to":"2021-01-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"228.00","grand_total":"257.64","paid_amount":"217.62","product_id":"1781","service_quantity":"1","customer_traveller_id":"69129","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-07 01:53:17","reservation_modified_date_time":"2021-01-01 18:52:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"69129","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3175796","reservation_id":"104427","confirmation_number":"PB12294794950","room_confirmation_number":"PB12391367287","room_stay_from":"2021-01-07","room_stay_to":"2021-01-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"25658","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-12-30 15:28:59","reservation_modified_date_time":"2021-01-07 22:17:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"25658","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177677","reservation_id":"105189","confirmation_number":"BP12289437064","room_confirmation_number":"BP12573685586","room_stay_from":"2021-01-11","room_stay_to":"2021-01-18","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":"111565","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-11 20:53:05","reservation_modified_date_time":"2021-01-11 20:55:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111565","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178080","reservation_id":"104591","confirmation_number":"BP12236802458","room_confirmation_number":"BP12550463246","room_stay_from":"2021-01-13","room_stay_to":"2021-01-19","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"111610","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-01-02 18:26:12","reservation_modified_date_time":"2021-01-12 16:43:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111610","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3175259","reservation_id":"102045","confirmation_number":"PB12272342374","room_confirmation_number":"PB12313088012","room_stay_from":"2021-01-06","room_stay_to":"2021-01-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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":"108164","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-10-28 19:17:12","reservation_modified_date_time":"2021-01-06 22:15:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108164","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178581","reservation_id":"104373","confirmation_number":"PB12232737305","room_confirmation_number":"PB12335484385","room_stay_from":"2021-01-13","room_stay_to":"2021-01-21","room_stay_status":"Active","nightly_price":"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","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"32503","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-12-29 16:30:10","reservation_modified_date_time":"2021-01-13 19:57:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"32503","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178462","reservation_id":"104883","confirmation_number":"PB12265795579","room_confirmation_number":"PB12326562603","room_stay_from":"2021-01-12","room_stay_to":"2021-01-13","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"111237","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-06 20:02:25","reservation_modified_date_time":"2021-01-13 16:03:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111237","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3178597","reservation_id":"91591","confirmation_number":"PB12223875256","room_confirmation_number":"PB12374480147","room_stay_from":"2021-02-14","room_stay_to":"2021-02-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0","subtotal":"132.00","grand_total":"149.16","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"56258","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-08 18:02:42","reservation_modified_date_time":"2021-01-13 20:39:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56258","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3070489","reservation_id":"92065","confirmation_number":"BP12225933307","room_confirmation_number":"BP12518723757","room_stay_from":"2021-01-09","room_stay_to":"2021-02-27","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":"2020-02-16 21:19:09","reservation_modified_date_time":"2020-02-16 21:19:09","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","parentRoomStayFrom":"2022-01-08","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":"3178478","reservation_id":"101903","confirmation_number":"BV12246112563","room_confirmation_number":"BP12523026118","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.00","grand_total":"24.86","paid_amount":"0.00","product_id":"1212","service_quantity":"2","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-13 16:28:58","reservation_modified_date_time":"2021-01-13 16:28:58","customer_id":"108021","parentCustTravId":"108021","customer_traveller_id":"108021","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-02-16","currentDayPrice":"22.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3178739","reservation_id":"105232","confirmation_number":"PB12221703336","room_confirmation_number":"PB12349528063","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"45.00","grand_total":"355.95","paid_amount":"0.00","product_id":"1212","service_quantity":"7","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-14 03:26:08","reservation_modified_date_time":"2021-01-14 03:26:08","customer_id":"96961","parentCustTravId":"96961","customer_traveller_id":"96961","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-03-30","currentDayPrice":"315.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3178482","reservation_id":"105274","confirmation_number":"PB12246762985","room_confirmation_number":"PB12374983069","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"37.38","grand_total":"40.00","paid_amount":"40.00","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-13 16:40:23","reservation_modified_date_time":"2021-01-13 16:40:23","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","currentDayPrice":"37.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3177525","reservation_id":"104596","confirmation_number":"PB12248383133","room_confirmation_number":"PB12317686265","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-11 17:02:31","reservation_modified_date_time":"2021-01-11 17:02:31","customer_id":"110944","parentCustTravId":"110944","customer_traveller_id":"110944","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-01-13 15:19:43","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-01-10","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3177572","reservation_id":"104974","confirmation_number":"BP12296494287","room_confirmation_number":"BP12535040176","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-11 18:28:25","reservation_modified_date_time":"2021-01-11 18:28:25","customer_id":"111523","parentCustTravId":"111523","customer_traveller_id":"111523","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-01-13 15:10:47","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-01-10","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]},"123":{"total_rooms_exist":"1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1121,1123,1113,1114,1115,1116,1117,1118,1119,1120","departureCount":9,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1104","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12210454164","room_stay_from":"2021-01-12","room_stay_to":"2021-01-15","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[{"room_stay_id":"3178578","reservation_id":"103929","confirmation_number":"PB12365765583","room_stay_from":"2021-01-04","room_stay_to":"2021-01-07","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.25,176.25,176.25","nightly_discount":"0,0,0","subtotal":"528.75","grand_total":"597.49","paid_amount":"0.00","room_type_id":"289","product_id":"1096","siteminder_id":"EXP-1723658395","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":"110245","customer_id":"110245","source_of_creation":"Expedia","reservation_created_date":"2020-12-17 23:16:16","service_canceled_date_time":"2021-01-13 19:31:25","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"canceled resv amount refunded","total_paid_amount":"0.00","deltaChange":"0.00","changedComment":"resv paid or refunded after cancel","currentDayPrice":0,"currentDayDiscount":0,"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"}]}],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3178582","reservation_id":"104373","confirmation_number":"PB12335484385","room_stay_from":"2021-01-13","room_stay_to":"2021-01-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"83.90,83.90,88.11,88.11,83.90,83.90,83.90,83.90","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"679.62","grand_total":"767.97","paid_amount":"767.97","room_type_id":"289","product_id":"1108","siteminder_id":"GAM-R2261067163","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":"32503","customer_id":"32503","source_of_creation":"Getaroom.com","reservation_created_date":"2020-12-29 16:30:10","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":"","promotion_code":"","currentDayPrice":"83.90","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[{"room_stay_id":"3178689","reservation_id":"105263","confirmation_number":"PB12398441940","room_stay_from":"2021-01-13","room_stay_to":"2021-01-16","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"141.55,141.55,141.55","nightly_discount":"0,0,0","subtotal":"424.65","grand_total":"479.86","paid_amount":"479.86","room_type_id":"291","product_id":"1119","siteminder_id":"GCC-1106400117-064","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111647","customer_id":"111647","source_of_creation":"GuestCentric Systems","reservation_created_date":"2021-01-13 08:24:13","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","currentDayPrice":"141.55","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":"3178728","reservation_id":"105291","confirmation_number":"PB12338481877","room_stay_from":"2021-01-13","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"134.46,134.46","nightly_discount":"0.00,0.00","subtotal":"268.92","grand_total":"303.88","paid_amount":"303.88","room_type_id":"291","product_id":"1115","siteminder_id":"AGO-365428346","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111695","customer_id":"111695","source_of_creation":"Agoda","reservation_created_date":"2021-01-13 22:14:09","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":"","promotion_code":null,"currentDayPrice":"134.46","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178285","reservation_id":"104896","confirmation_number":"PB12355351079","room_stay_from":"2021-01-12","room_stay_to":"2021-01-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"100.30,100.30,100.30,105.34,105.34","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"511.58","grand_total":"578.08","paid_amount":"578.08","room_type_id":"289","product_id":"1109","siteminder_id":"AGO-364113110","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111634","customer_id":"111634","source_of_creation":"Agoda","reservation_created_date":"2021-01-06 22:20:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 207","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"100.30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3177845","reservation_id":"103704","confirmation_number":"PB12349619011","room_stay_from":"2021-01-11","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"139.00,139.00,139.00,139.00","nightly_discount":"0.00,0.00,0.00,23.25","subtotal":"556.00","grand_total":"602.01","paid_amount":"602.01","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":"109955","customer_id":"109955","source_of_creation":"FE","reservation_created_date":"2020-12-11 00:52:27","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":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"139.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3178105","reservation_id":"105193","confirmation_number":"PB12390391269","room_stay_from":"2021-01-12","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,119.00,119.00","nightly_discount":"0.00,19.55,0.00","subtotal":"357.00","grand_total":"381.32","paid_amount":"381.32","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":"111569","customer_id":"111569","source_of_creation":"PMS","reservation_created_date":"2021-01-11 22:08:50","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 101","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"119.00","currentDayDiscount":"19.55","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178372","reservation_id":"105267","confirmation_number":"PB12316306933","room_stay_from":"2021-01-13","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,199.00","nightly_discount":"0.00,0.00","subtotal":"398.00","grand_total":"449.74","paid_amount":"449.74","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111652","customer_id":"111652","source_of_creation":"PMS","reservation_created_date":"2021-01-13 14:18:50","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 116","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"3177851","reservation_id":"97410","confirmation_number":"PB12323864250","room_stay_from":"2021-01-11","room_stay_to":"2021-01-17","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"210.00,230.00,230.00,230.00,230.00,230.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,61.00","subtotal":"1360.00","grand_total":"1467.87","paid_amount":"1467.87","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":"103492","customer_id":"103492","source_of_creation":"PMS","reservation_created_date":"2020-07-05 14:39:38","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 216","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"230.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3172578","reservation_id":"89484","confirmation_number":"PB12343358805","room_stay_from":"2020-12-30","room_stay_to":"2021-01-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.00,147.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,135.75","subtotal":"2793.00","grand_total":"3002.70","paid_amount":"3002.70","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":"69129","customer_id":"69129","source_of_creation":"PMS","reservation_created_date":"2020-01-07 01:53:17","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 217","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"147.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3175795","reservation_id":"104427","confirmation_number":"PB12391367287","room_stay_from":"2021-01-07","room_stay_to":"2021-01-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"119.00,139.00,139.00,119.00,119.00,119.00,119.00,119.00,139.00,139.00,119.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,70.00","subtotal":"1389.00","grand_total":"1490.47","paid_amount":"1490.47","room_type_id":"289","product_id":"1095","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"25658","customer_id":"25658","source_of_creation":"PMS","reservation_created_date":"2020-12-30 15:28:59","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 107","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"119.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3175258","reservation_id":"102045","confirmation_number":"PB12313088012","room_stay_from":"2021-01-06","room_stay_to":"2021-01-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"148.00,148.00,128.00,128.00,128.00,128.00,128.00,148.00,148.00,128.00,128.00,128.00,128.00,128.00,128.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,101.60","subtotal":"2000.00","grand_total":"2145.19","paid_amount":"2145.19","room_type_id":"289","product_id":"1099","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"108164","customer_id":"108164","source_of_creation":"PMS","reservation_created_date":"2020-10-28 19:17:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 111","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"148.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178461","reservation_id":"104883","confirmation_number":"PB12326562603","room_stay_from":"2021-01-12","room_stay_to":"2021-01-13","room_stay_status":"Checked-Out","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00","nightly_discount":"0.00","subtotal":"99.00","grand_total":"111.87","paid_amount":"30.51","room_type_id":"289","product_id":"1094","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111237","customer_id":"111237","source_of_creation":"PMS","reservation_created_date":"2021-01-06 20:02:25","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"3178596","reservation_id":"91591","confirmation_number":"PB12374480147","room_stay_from":"2021-02-14","room_stay_to":"2021-02-25","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"158.00,158.00,158.00,158.00,158.00,158.00,158.00,158.00,158.00,158.00,158.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1738.00","grand_total":"1963.94","paid_amount":"178.54","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":"56258","customer_id":"56258","source_of_creation":"PMS","reservation_created_date":"2020-02-08 18:02:42","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":"","promotion_code":"","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"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3178726","reservation_id":"105291","confirmation_number":"PB12233425770","room_confirmation_number":"PB12338481877","room_stay_from":"2021-01-13","room_stay_to":"2021-01-15","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"111695","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-01-14 02:39:14","reservation_modified_date_time":"2021-01-14 02:43:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111695","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177629","reservation_id":"104173","confirmation_number":"PB12239684757","room_confirmation_number":"PB12338946037","room_stay_from":"2021-01-11","room_stay_to":"2021-01-13","room_stay_status":"Canceled","nightly_price":"20,20","nightly_discount":"0,0","subtotal":"40.00","grand_total":"45.20","paid_amount":"0.00","product_id":"1780","service_quantity":"1","product_name":"Extra Person","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-11 19:46:25","reservation_modified_date_time":"2021-01-11 19:51:35","customer_id":"111561","parentCustTravId":"111561","customer_traveller_id":"111561","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-01-13 14:34:18","canceled_nights_data":"","product_attribute_values":"extra_person#&#10.00","parentRoomStayFrom":"2021-01-11","deltaChange":-40,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3177846","reservation_id":"103704","confirmation_number":"PB12218404762","room_confirmation_number":"PB12349619011","room_stay_from":"2021-01-11","room_stay_to":"2021-01-15","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":"109955","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-12-11 00:52:27","reservation_modified_date_time":"2021-01-12 02:26:00","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"109955","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178106","reservation_id":"105193","confirmation_number":"PB12290358056","room_confirmation_number":"PB12390391269","room_stay_from":"2021-01-12","room_stay_to":"2021-01-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"111569","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-11 22:08:50","reservation_modified_date_time":"2021-01-12 18:01:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111569","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178373","reservation_id":"105267","confirmation_number":"PB12288658286","room_confirmation_number":"PB12316306933","room_stay_from":"2021-01-13","room_stay_to":"2021-01-15","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":"111653","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-13 14:18:50","reservation_modified_date_time":"2021-01-13 14:18:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111652","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178727","reservation_id":"105291","confirmation_number":"PB12276405951","room_confirmation_number":"PB12338481877","room_stay_from":"2021-01-13","room_stay_to":"2021-01-15","room_stay_status":"Active","nightly_price":"20,20","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"111695","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-01-13 22:14:09","reservation_modified_date_time":"2021-01-14 02:43:54","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111695","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178690","reservation_id":"105263","confirmation_number":"PB12276543708","room_confirmation_number":"PB12398441940","room_stay_from":"2021-01-13","room_stay_to":"2021-01-16","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"111647","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-01-13 08:24:13","reservation_modified_date_time":"2021-01-13 23:50:27","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111647","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177852","reservation_id":"97410","confirmation_number":"PB12254694145","room_confirmation_number":"PB12323864250","room_stay_from":"2021-01-11","room_stay_to":"2021-01-17","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"103492","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-07-05 14:39:38","reservation_modified_date_time":"2021-01-12 02:44:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"103492","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178284","reservation_id":"104896","confirmation_number":"PB12259157508","room_confirmation_number":"PB12355351079","room_stay_from":"2021-01-12","room_stay_to":"2021-01-17","room_stay_status":"Active","nightly_price":"20,20,20,20,20","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":"111634","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-01-06 22:20:07","reservation_modified_date_time":"2021-01-13 02:00:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111634","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.00","currentDayPrice":"20","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3172580","reservation_id":"89484","confirmation_number":"PB12250641004","room_confirmation_number":"PB12343358805","room_stay_from":"2020-12-30","room_stay_to":"2021-01-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"228.00","grand_total":"257.64","paid_amount":"217.62","product_id":"1781","service_quantity":"1","customer_traveller_id":"69129","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-01-07 01:53:17","reservation_modified_date_time":"2021-01-01 18:52:37","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"69129","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3175796","reservation_id":"104427","confirmation_number":"PB12294794950","room_confirmation_number":"PB12391367287","room_stay_from":"2021-01-07","room_stay_to":"2021-01-18","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"132.00","grand_total":"149.16","paid_amount":"149.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"25658","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-12-30 15:28:59","reservation_modified_date_time":"2021-01-07 22:17:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"25658","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3175259","reservation_id":"102045","confirmation_number":"PB12272342374","room_confirmation_number":"PB12313088012","room_stay_from":"2021-01-06","room_stay_to":"2021-01-21","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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":"108164","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-10-28 19:17:12","reservation_modified_date_time":"2021-01-06 22:15:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108164","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178581","reservation_id":"104373","confirmation_number":"PB12232737305","room_confirmation_number":"PB12335484385","room_stay_from":"2021-01-13","room_stay_to":"2021-01-21","room_stay_status":"Active","nightly_price":"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","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"32503","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-12-29 16:30:10","reservation_modified_date_time":"2021-01-13 19:57:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"32503","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178462","reservation_id":"104883","confirmation_number":"PB12265795579","room_confirmation_number":"PB12326562603","room_stay_from":"2021-01-12","room_stay_to":"2021-01-13","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"94.92","product_id":"1781","service_quantity":"1","customer_traveller_id":"111237","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-06 20:02:25","reservation_modified_date_time":"2021-01-13 16:03:50","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111237","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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":"3178597","reservation_id":"91591","confirmation_number":"PB12223875256","room_confirmation_number":"PB12374480147","room_stay_from":"2021-02-14","room_stay_to":"2021-02-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","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0","subtotal":"132.00","grand_total":"149.16","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"56258","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-08 18:02:42","reservation_modified_date_time":"2021-01-13 20:39:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56258","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3178739","reservation_id":"105232","confirmation_number":"PB12221703336","room_confirmation_number":"PB12349528063","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"45.00","grand_total":"355.95","paid_amount":"0.00","product_id":"1212","service_quantity":"7","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-14 03:26:08","reservation_modified_date_time":"2021-01-14 03:26:08","customer_id":"96961","parentCustTravId":"96961","customer_traveller_id":"96961","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-03-30","currentDayPrice":"315.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3178482","reservation_id":"105274","confirmation_number":"PB12246762985","room_confirmation_number":"PB12374983069","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"37.38","grand_total":"40.00","paid_amount":"40.00","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-13 16:40:23","reservation_modified_date_time":"2021-01-13 16:40:23","customer_id":"22674","parentCustTravId":"0","customer_traveller_id":"0","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"parentRoomStayFrom":"1970-01-01","currentDayPrice":"37.38","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"3177525","reservation_id":"104596","confirmation_number":"PB12248383133","room_confirmation_number":"PB12317686265","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-11 17:02:31","reservation_modified_date_time":"2021-01-11 17:02:31","customer_id":"110944","parentCustTravId":"110944","customer_traveller_id":"110944","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-01-13 15:19:43","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-01-10","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"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":2,"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":"3175195","reservation_id":"104471","confirmation_number":"BV12435886616","room_stay_from":"2021-01-06","room_stay_to":"2021-01-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"75.15,75.15,85.85,85.85,75.15,75.15,75.15,75.15","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"622.60","grand_total":"703.54","paid_amount":"703.54","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-2705929551","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"80.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111226","customer_id":"111226","source_of_creation":"Booking.com","reservation_created_date":"2020-12-31 17:11:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"155.27","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"75.15","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":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[{"room_stay_id":"3177699","reservation_id":"105172","confirmation_number":"BV12427694483","room_stay_from":"2021-01-11","room_stay_to":"2021-01-14","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"108.10,108.10,108.10","nightly_discount":"0,0,0","subtotal":"324.30","grand_total":"366.46","paid_amount":"366.46","room_type_id":"309","product_id":"1226","siteminder_id":"AGO-365004226","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":"111571","customer_id":"111571","source_of_creation":"Agoda","reservation_created_date":"2021-01-11 16:08:14","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":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"108.10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3177101","reservation_id":"102544","confirmation_number":"BV12480439730","room_stay_from":"2021-01-10","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"90.00,90.00,90.00,90.00,90.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"450.00","grand_total":"508.50","paid_amount":"508.50","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":"108700","customer_id":"108700","source_of_creation":"PMS","reservation_created_date":"2020-11-11 17:56:34","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"90.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177387","reservation_id":"105151","confirmation_number":"BV12455266204","room_stay_from":"2021-01-10","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"99.00,99.00,99.00,99.00,99.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"495.00","grand_total":"559.35","paid_amount":"559.35","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":"111534","customer_id":"111534","source_of_creation":"PMS","reservation_created_date":"2021-01-11 03:35:05","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"99.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3175197","reservation_id":"104471","confirmation_number":"BV12266831259","room_confirmation_number":"BV12435886616","room_stay_from":"2021-01-06","room_stay_to":"2021-01-14","room_stay_status":"Active","nightly_price":"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","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"111226","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2020-12-31 17:11:12","reservation_modified_date_time":"2021-01-06 20:08:38","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111226","canceled_nights_data":"","posAmt_airbnb_taxpaid":"80.00","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177698","reservation_id":"105172","confirmation_number":"BV12264236572","room_confirmation_number":"BV12427694483","room_stay_from":"2021-01-11","room_stay_to":"2021-01-14","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":"111571","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-01-11 16:08:14","reservation_modified_date_time":"2021-01-11 23:00:20","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111571","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177102","reservation_id":"102544","confirmation_number":"BV12238880009","room_confirmation_number":"BV12480439730","room_stay_from":"2021-01-10","room_stay_to":"2021-01-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"108700","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-11-11 17:56:34","reservation_modified_date_time":"2021-01-10 15:45:40","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108700","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177388","reservation_id":"105151","confirmation_number":"BV12267242919","room_confirmation_number":"BV12455266204","room_stay_from":"2021-01-10","room_stay_to":"2021-01-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1781","service_quantity":"1","customer_traveller_id":"111534","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-11 03:35:05","reservation_modified_date_time":"2021-01-11 03:35:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111534","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":1,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1126,1137,1138,1132,1131","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"BP12247304091","room_stay_from":"2021-01-13","room_stay_to":"2021-01-14","bundle_room":"0"},{"confirmation_number":"BP12228743539","room_stay_from":"2021-01-13","room_stay_to":"2021-01-14","bundle_room":"0"},{"confirmation_number":"BP12226285648","room_stay_from":"2021-01-13","room_stay_to":"2021-01-14","bundle_room":"0"},{"confirmation_number":"BP12251608311","room_stay_from":"2021-01-13","room_stay_to":"2021-01-14","bundle_room":"0"},{"confirmation_number":"BP12224251323","room_stay_from":"2021-01-13","room_stay_to":"2021-01-14","bundle_room":"0"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"3178081","reservation_id":"104591","confirmation_number":"BP12550463246","room_stay_from":"2021-01-13","room_stay_to":"2021-01-19","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.03,67.03,75.47,75.47,67.03,67.03","nightly_discount":"0,0,0,0,0,0","subtotal":"419.06","grand_total":"473.53","paid_amount":"473.53","room_type_id":"300","product_id":"1135","siteminder_id":"GAM-R2266317965","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":"111610","customer_id":"111610","source_of_creation":"Getaroom.com","reservation_created_date":"2021-01-02 18:26:12","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 1SS 805","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"67.03","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"3178457","reservation_id":"105197","confirmation_number":"BP12555071860","room_stay_from":"2021-01-11","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"85.00,85.00,85.00,85.00","nightly_discount":"0.00,0.00,0,0","subtotal":"340.00","grand_total":"384.20","paid_amount":"384.20","room_type_id":"294","product_id":"1125","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":"110343","customer_id":"110343","source_of_creation":"PMS","reservation_created_date":"2021-01-11 23:48:23","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 803","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"85.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":"3178684","reservation_id":"104878","confirmation_number":"BP12594143409","room_stay_from":"2021-01-12","room_stay_to":"2021-01-15","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.00,129.00,129.00","nightly_discount":"0.00,0.00,0.00","subtotal":"387.00","grand_total":"437.31","paid_amount":"437.31","room_type_id":"315","product_id":"1230","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":"111232","customer_id":"111232","source_of_creation":"PMS","reservation_created_date":"2021-01-06 19:36:54","canceled_nights_data":"","product_name":"BP Walk","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","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":"3177676","reservation_id":"105189","confirmation_number":"BP12573685586","room_stay_from":"2021-01-11","room_stay_to":"2021-01-18","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"90.00,90.00,90.00,90.00,105.00,105.00,90.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,35.00","subtotal":"660.00","grand_total":"706.25","paid_amount":"706.25","room_type_id":"295","product_id":"1128","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"111565","customer_id":"111565","source_of_creation":"PMS","reservation_created_date":"2021-01-11 20:53:05","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"90.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3178458","reservation_id":"105197","confirmation_number":"BP12256029231","room_confirmation_number":"BP12555071860","room_stay_from":"2021-01-11","room_stay_to":"2021-01-15","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":"110343","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-11 23:48:23","reservation_modified_date_time":"2021-01-13 15:47:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"110343","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178685","reservation_id":"104878","confirmation_number":"BP12257711731","room_confirmation_number":"BP12594143409","room_stay_from":"2021-01-12","room_stay_to":"2021-01-15","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"40.68","product_id":"1781","service_quantity":"1","customer_traveller_id":"111232","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-06 19:36:54","reservation_modified_date_time":"2021-01-13 22:36:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111232","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3177677","reservation_id":"105189","confirmation_number":"BP12289437064","room_confirmation_number":"BP12573685586","room_stay_from":"2021-01-11","room_stay_to":"2021-01-18","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":"111565","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-01-11 20:53:05","reservation_modified_date_time":"2021-01-11 20:55:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111565","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3178080","reservation_id":"104591","confirmation_number":"BP12236802458","room_confirmation_number":"BP12550463246","room_stay_from":"2021-01-13","room_stay_to":"2021-01-19","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"111610","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-01-02 18:26:12","reservation_modified_date_time":"2021-01-12 16:43:50","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111610","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"3070489","reservation_id":"92065","confirmation_number":"BP12225933307","room_confirmation_number":"BP12518723757","room_stay_from":"2021-01-09","room_stay_to":"2021-02-27","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":"2020-02-16 21:19:09","reservation_modified_date_time":"2020-02-16 21:19:09","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","parentRoomStayFrom":"2022-01-08","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":"3178478","reservation_id":"101903","confirmation_number":"BV12246112563","room_confirmation_number":"BP12523026118","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.00","grand_total":"24.86","paid_amount":"0.00","product_id":"1212","service_quantity":"2","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-13 16:28:58","reservation_modified_date_time":"2021-01-13 16:28:58","customer_id":"108021","parentCustTravId":"108021","customer_traveller_id":"108021","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-02-16","currentDayPrice":"22.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"3177572","reservation_id":"104974","confirmation_number":"BP12296494287","room_confirmation_number":"BP12535040176","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Canceled","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"20.00","paid_amount":"0.00","product_id":"2010","service_quantity":"2","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-01-11 18:28:25","reservation_modified_date_time":"2021-01-11 18:28:25","customer_id":"111523","parentCustTravId":"111523","customer_traveller_id":"111523","static_pos_type":null,"product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-01-13 15:10:47","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-01-10","deltaChange":-18.7,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}}}