{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2021-10-31","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":28,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1096,1101","block_room_bookings":[{"confirmation_number":"PB12270645200","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","bundle_room":"0","product_id":"1096"},{"confirmation_number":"PB12233600565","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","bundle_room":"0","product_id":"1101"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5329032","reservation_id":"117259","confirmation_number":"PB12371776976","room_stay_from":"2021-10-26","room_stay_to":"2021-11-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.55,166.55,166.55,181.76,181.76,166.55,128.12,128.12","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1285.96","grand_total":"1453.14","paid_amount":"1453.14","room_type_id":"289","product_id":"1104","siteminder_id":"BDC-3761353822","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":"108088","customer_id":"108088","source_of_creation":"Booking.com","reservation_created_date":"2021-06-14 18:54:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"216.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"166.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"}]},{"room_stay_id":"5329969","reservation_id":"123548","confirmation_number":"PB12373608192","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.17,161.42","nightly_discount":"0,0","subtotal":"337.59","grand_total":"381.48","paid_amount":"381.48","room_type_id":"289","product_id":"1123","siteminder_id":"BDC-2177071278","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":"133021","customer_id":"133021","source_of_creation":"Booking.com","reservation_created_date":"2021-09-23 18:53:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"56.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"161.42","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5329974","reservation_id":"119735","confirmation_number":"BV12414204005","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.72,161.34","nightly_discount":"0,0","subtotal":"339.06","grand_total":"383.13","paid_amount":"383.13","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-2266062220","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":"133023","customer_id":"133023","source_of_creation":"Booking.com","reservation_created_date":"2021-07-20 19:26:11","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"68.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"161.34","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330123","reservation_id":"124876","confirmation_number":"PB12336362808","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"173.65","nightly_discount":"0.00","subtotal":"173.65","grand_total":"196.23","paid_amount":"196.23","room_type_id":"291","product_id":"1119","siteminder_id":"BDC-2207454222","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133011","customer_id":"133011","source_of_creation":"Booking.com","reservation_created_date":"2021-10-29 17:27:22","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"32.05","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"173.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330133","reservation_id":"124714","confirmation_number":"PB12350700622","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"164.46","nightly_discount":"0","subtotal":"164.46","grand_total":"185.84","paid_amount":"185.84","room_type_id":"289","product_id":"1093","siteminder_id":"BDC-3075054209","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133052","customer_id":"133052","source_of_creation":"Booking.com","reservation_created_date":"2021-10-23 17:52:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"29.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"164.46","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":"5330202","reservation_id":"124932","confirmation_number":"BP12537922514","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.74","nightly_discount":"0.00","subtotal":"75.74","grand_total":"85.58","paid_amount":"85.58","room_type_id":"296","product_id":"1131","siteminder_id":"BDC-2701963419","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124625","customer_id":"124625","source_of_creation":"Booking.com","reservation_created_date":"2021-10-31 20:47:08","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"17.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","currentDayPrice":"75.74","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330227","reservation_id":"124939","confirmation_number":"BV12425444405","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.38","nightly_discount":"0","subtotal":"107.38","grand_total":"121.34","paid_amount":"121.34","room_type_id":"304","product_id":"1220","siteminder_id":"BDC-3267602597","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133070","customer_id":"133070","source_of_creation":"Booking.com","reservation_created_date":"2021-11-01 00:45:39","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"22.93","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"107.38","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":"5330246","reservation_id":"124941","confirmation_number":"BP12523649220","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"142.18","nightly_discount":"0.00","subtotal":"142.18","grand_total":"160.66","paid_amount":"160.66","room_type_id":"302","product_id":"1138","siteminder_id":"BDC-3267675657","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133077","customer_id":"133077","source_of_creation":"Booking.com","reservation_created_date":"2021-11-01 00:46:47","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"29.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"142.18","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"5329848","reservation_id":"124885","confirmation_number":"PB12395174096","room_stay_from":"2021-10-29","room_stay_to":"2021-11-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.24,169.24,123.44,160.48,160.48,160.48","nightly_discount":"0,0,0,0,0,0","subtotal":"943.36","grand_total":"1066.00","paid_amount":"1066.00","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1850633479","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"28108","customer_id":"28108","source_of_creation":"Expedia","reservation_created_date":"2021-10-29 21:20:27","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"123.44","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":"5329894","reservation_id":"123059","confirmation_number":"BP12582725783","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"182.90,182.90,164.70","nightly_discount":"0.00,0.00,0.00","subtotal":"530.50","grand_total":"599.47","paid_amount":"599.47","room_type_id":"288","product_id":"1092","siteminder_id":"EXP-1830012839","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132725","customer_id":"132725","source_of_creation":"Expedia","reservation_created_date":"2021-09-15 02:09:11","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"164.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330017","reservation_id":"124598","confirmation_number":"PB12393647558","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.74,112.17","nightly_discount":"0,0","subtotal":"276.91","grand_total":"312.90","paid_amount":"312.90","room_type_id":"289","product_id":"1111","siteminder_id":"EXP-1845616313","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":"133030","customer_id":"133030","source_of_creation":"Expedia","reservation_created_date":"2021-10-19 00:11:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"112.17","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330035","reservation_id":"124535","confirmation_number":"PB12317698764","room_stay_from":"2021-10-30","room_stay_to":"2021-11-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"168.86,113.3,149.61,149.61,149.61,149.61,178.91","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1059.51","grand_total":"1197.25","paid_amount":"1197.25","room_type_id":"289","product_id":"1102","siteminder_id":"EXP-1844806031","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"140.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133035","customer_id":"133035","source_of_creation":"Expedia","reservation_created_date":"2021-10-17 04:30:11","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":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"113.3","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":"5330069","reservation_id":"124915","confirmation_number":"PB12369531464","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.15,115.55","nightly_discount":"0,0","subtotal":"275.70","grand_total":"311.54","paid_amount":"311.54","room_type_id":"289","product_id":"1103","siteminder_id":"EXP-1851069389","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133042","customer_id":"133042","source_of_creation":"Expedia","reservation_created_date":"2021-10-31 00:55:49","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"115.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"}]},{"room_stay_id":"5330141","reservation_id":"124900","confirmation_number":"BP12599530439","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.80","nightly_discount":"0","subtotal":"62.80","grand_total":"70.97","paid_amount":"70.97","room_type_id":"289","product_id":"1109","siteminder_id":"EXP-1850875804","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133053","customer_id":"133053","source_of_creation":"Expedia","reservation_created_date":"2021-10-30 14:47:25","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":"","sub_hotel_id":"123","currentDayPrice":"62.80","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":"5330161","reservation_id":"124888","confirmation_number":"PB12353029622","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.80","nightly_discount":"0.00","subtotal":"123.80","grand_total":"139.90","paid_amount":"139.90","room_type_id":"287","product_id":"1087","siteminder_id":"EXP-1850660716","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133059","customer_id":"133059","source_of_creation":"Expedia","reservation_created_date":"2021-10-29 22:32:01","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":"","sub_hotel_id":"123","currentDayPrice":"123.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5329816","reservation_id":"124337","confirmation_number":"BP12511194811","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.51,126.51,91.36","nightly_discount":"0,0,0","subtotal":"344.38","grand_total":"389.15","paid_amount":"389.15","room_type_id":"293","product_id":"1124","siteminder_id":"GAM-R2860815224","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":"132998","customer_id":"132998","source_of_creation":"Getaroom.com","reservation_created_date":"2021-10-10 10:23:11","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"91.36","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330049","reservation_id":"124679","confirmation_number":"BP12534138218","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.51,84.05","nightly_discount":"0,0","subtotal":"210.56","grand_total":"237.93","paid_amount":"237.93","room_type_id":"298","product_id":"1133","siteminder_id":"GAM-R2888499489","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":"133037","customer_id":"133037","source_of_creation":"Getaroom.com","reservation_created_date":"2021-10-22 07:46:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","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":"125","group_rooms":null,"currentDayPrice":"84.05","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":[{"room_stay_id":"5329642","reservation_id":"124853","confirmation_number":"BV12477609547","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"193.03,193.03,193.03","nightly_discount":"0.00,0.00,0.00","subtotal":"579.09","grand_total":"758.89","paid_amount":"758.89","room_type_id":"306","product_id":"1223","siteminder_id":"ABB-HMXHR8JAJQ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"579.09","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132997","customer_id":"132997","source_of_creation":"Airbnb","reservation_created_date":"2021-10-28 18:30:29","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"84.28","commision_charges":"17.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"193.03","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"5321450","reservation_id":"123801","confirmation_number":"BV12490761757","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"253.50,261.99","nightly_discount":"0.00,0.00","subtotal":"515.49","grand_total":"582.50","paid_amount":"582.50","room_type_id":"288","product_id":"1091","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107726","customer_id":"107726","source_of_creation":"FE","reservation_created_date":"2021-09-28 01:34:51","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"261.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5322595","reservation_id":"124070","confirmation_number":"PB12381444906","room_stay_from":"2021-10-30","room_stay_to":"2021-11-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.30,261.30,339.69","nightly_discount":"0.00,0.00,0.00","subtotal":"888.29","grand_total":"1003.77","paid_amount":"1003.77","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131966","customer_id":"131966","source_of_creation":"FE","reservation_created_date":"2021-10-03 13:59:40","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"261.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"}]},{"room_stay_id":"5328301","reservation_id":"123735","confirmation_number":"PB12318515922","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"219.70,219.70,193.70","nightly_discount":"0.00,0.00,0.00","subtotal":"633.10","grand_total":"715.41","paid_amount":"715.41","room_type_id":"291","product_id":"1116","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131508","customer_id":"131508","source_of_creation":"FE","reservation_created_date":"2021-09-27 02:46:54","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"193.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5328831","reservation_id":"123507","confirmation_number":"PB12349329942","room_stay_from":"2021-10-25","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"156.00,156.00,156.00,156.00,182.00,182.00,156.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,54.30","subtotal":"1144.00","grand_total":"1231.36","paid_amount":"1231.36","room_type_id":"289","product_id":"1105","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":"131241","customer_id":"131241","source_of_creation":"FE","reservation_created_date":"2021-09-22 22:10:25","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"156.00","currentDayDiscount":"54.30","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5329674","reservation_id":"124277","confirmation_number":"PB12320521944","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"270.23,270.23,193.70","nightly_discount":"0.00,0.00,0.00","subtotal":"734.16","grand_total":"829.60","paid_amount":"829.60","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":"132210","customer_id":"132210","source_of_creation":"FE","reservation_created_date":"2021-10-07 23:13:52","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":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"193.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5329797","reservation_id":"124417","confirmation_number":"PB12354247880","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"255.84,182.00","nightly_discount":"0.00,0.00","subtotal":"437.84","grand_total":"494.76","paid_amount":"494.76","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":"132380","customer_id":"132380","source_of_creation":"FE","reservation_created_date":"2021-10-13 01:58:06","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":"182.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5329823","reservation_id":"124896","confirmation_number":"BV12456293045","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.83","nightly_discount":"0.00","subtotal":"91.83","grand_total":"103.77","paid_amount":"103.77","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133004","customer_id":"133004","source_of_creation":"FE","reservation_created_date":"2021-10-30 05:02:47","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"91.83","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330100","reservation_id":"124909","confirmation_number":"PB12313788799","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.66,89.00","nightly_discount":"0.00,0.00","subtotal":"238.66","grand_total":"269.69","paid_amount":"269.69","room_type_id":"289","product_id":"1107","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":"133020","customer_id":"133020","source_of_creation":"FE","reservation_created_date":"2021-10-30 18:57:52","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330162","reservation_id":"124930","confirmation_number":"PB12334603781","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"98.21","nightly_discount":"0.00","subtotal":"98.21","grand_total":"110.97","paid_amount":"110.97","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133060","customer_id":"133060","source_of_creation":"FE","reservation_created_date":"2021-10-31 19:23:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"98.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330175","reservation_id":"124639","confirmation_number":"PB12366946595","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.84,167.44","nightly_discount":"0.00,0.00","subtotal":"423.28","grand_total":"478.31","paid_amount":"478.31","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":"34584","customer_id":"34584","source_of_creation":"FE","reservation_created_date":"2021-10-20 15:52:19","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","currentDayPrice":"167.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3216396","reservation_id":"105927","confirmation_number":"PB12373510255","room_stay_from":"2021-10-28","room_stay_to":"2021-11-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.00,186.00,206.00,206.00,186.00,186.00,186.00,186.00,186.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"1714.00","grand_total":"1936.82","paid_amount":"1936.82","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":"111721","customer_id":"111721","source_of_creation":"PMS","reservation_created_date":"2021-01-23 15:26:42","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":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"206.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315785","reservation_id":"122895","confirmation_number":"PB12340796678","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"195.00,195.00,169.00","nightly_discount":"0.00,0.00,0.00","subtotal":"559.00","grand_total":"631.67","paid_amount":"631.67","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":"123116","customer_id":"123116","source_of_creation":"PMS","reservation_created_date":"2021-09-11 22:19:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"169.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5322528","reservation_id":"122804","confirmation_number":"PB12348075673","room_stay_from":"2021-10-29","room_stay_to":"2021-11-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"219.70,219.70,193.70,251.81,251.81","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1136.72","grand_total":"1284.49","paid_amount":"1284.49","room_type_id":"291","product_id":"1118","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92095","customer_id":"92095","source_of_creation":"PMS","reservation_created_date":"2021-09-09 18:06:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"193.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5328295","reservation_id":"124715","confirmation_number":"PB12345779369","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.85,239.85,155.48","nightly_discount":"0.00,0.00,0.00","subtotal":"635.18","grand_total":"717.75","paid_amount":"717.75","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132753","customer_id":"132753","source_of_creation":"PMS","reservation_created_date":"2021-10-23 18:12:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"155.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5328319","reservation_id":"111676","confirmation_number":"PB12367668880","room_stay_from":"2021-10-23","room_stay_to":"2021-11-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,120.00,120.00,120.00,120.00,120.00,140.00,140.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,68.60","subtotal":"1380.00","grand_total":"1481.88","paid_amount":"1481.88","room_type_id":"289","product_id":"1121","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118233","customer_id":"118233","source_of_creation":"PMS","reservation_created_date":"2021-03-30 13:44:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5328891","reservation_id":"109801","confirmation_number":"PB12346734517","room_stay_from":"2021-10-26","room_stay_to":"2021-11-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.00,143.00,143.00,143.00,143.00,143.00,143.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,54.26","subtotal":"1001.00","grand_total":"1069.81","paid_amount":"1069.82","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":"44906","customer_id":"44906","source_of_creation":"PMS","reservation_created_date":"2021-10-26 14:04:32","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":"143.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5329592","reservation_id":"124859","confirmation_number":"BP12564549722","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.03","nightly_discount":"0.00","subtotal":"84.03","grand_total":"94.95","paid_amount":"94.95","room_type_id":"299","product_id":"1134","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132965","customer_id":"132965","source_of_creation":"PMS","reservation_created_date":"2021-10-28 21:55:23","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"84.03","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330059","reservation_id":"118520","confirmation_number":"BV12445084744","room_stay_from":"2021-10-31","room_stay_to":"2021-11-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.60,132.00,132.00,132.00,132.00,152.00,152.00,132.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1135.60","grand_total":"1283.23","paid_amount":"1283.23","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"36678","customer_id":"36678","source_of_creation":"PMS","reservation_created_date":"2021-07-02 14:09:27","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"171.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330102","reservation_id":"124923","confirmation_number":"BP12589665353","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.09","nightly_discount":"0.00","subtotal":"81.09","grand_total":"91.64","paid_amount":"91.64","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":"133026","customer_id":"133026","source_of_creation":"PMS","reservation_created_date":"2021-10-31 14:51:36","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":"","sub_hotel_id":"125","currentDayPrice":"81.09","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330172","reservation_id":"124904","confirmation_number":"PB12313036506","room_stay_from":"2021-10-31","room_stay_to":"2021-11-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"98.21,127.66","nightly_discount":"0.00,7.40","subtotal":"225.87","grand_total":"246.87","paid_amount":"246.87","room_type_id":"292","product_id":"1120","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":"133014","customer_id":"133014","source_of_creation":"PMS","reservation_created_date":"2021-10-30 17:46:54","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"98.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330181","reservation_id":"124776","confirmation_number":"PB12365229491","room_stay_from":"2021-10-31","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.52,186.58,186.58,186.58,186.58,236.60,236.60,202.80,202.80,202.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,97.40","subtotal":"1971.44","grand_total":"2117.66","paid_amount":"2117.66","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132844","customer_id":"132844","source_of_creation":"PMS","reservation_created_date":"2021-10-26 00:59:06","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":"","sub_hotel_id":"123","currentDayPrice":"143.52","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330207","reservation_id":"124936","confirmation_number":"BV12411971771","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.01","nightly_discount":"0.00","subtotal":"62.01","grand_total":"70.07","paid_amount":"70.07","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133067","customer_id":"133067","source_of_creation":"PMS","reservation_created_date":"2021-10-31 23:10:32","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"62.01","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5315786","reservation_id":"122895","confirmation_number":"PB12286692538","room_confirmation_number":"PB12340796678","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"123116","product_attribute_values":"extra_person# ","reservation_created_date":"2021-09-20 15:02:15","reservation_modified_date_time":"2021-09-20 15:02:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123116","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5321448","reservation_id":"123801","confirmation_number":"BV12264084691","room_confirmation_number":"BV12490761757","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"40,40","nightly_discount":"0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"107726","product_attribute_values":"extra_person# ","reservation_created_date":"2021-10-01 20:21:25","reservation_modified_date_time":"2021-10-01 20:24:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107726","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5328302","reservation_id":"123735","confirmation_number":"PB12214393811","room_confirmation_number":"PB12318515922","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"40.68","product_id":"1780","service_quantity":"1","customer_traveller_id":"131508","product_attribute_values":"extra_person# ","reservation_created_date":"2021-10-23 18:18:14","reservation_modified_date_time":"2021-10-23 18:18:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131508","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5329686","reservation_id":"123059","confirmation_number":"BP12240362019","room_confirmation_number":"BP12582725783","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"132725","product_attribute_values":"extra_person# ","reservation_created_date":"2021-10-29 17:56:47","reservation_modified_date_time":"2021-10-29 17:56:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132725","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","sub_hotel_id":"123","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":"5329798","reservation_id":"124417","confirmation_number":"PB12266487691","room_confirmation_number":"PB12354247880","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"132380","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-10-29 23:38:08","reservation_modified_date_time":"2021-10-29 23:38:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132380","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330033","reservation_id":"124535","confirmation_number":"PB12297460333","room_confirmation_number":"PB12317698764","room_stay_from":"2021-10-30","room_stay_to":"2021-11-06","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"133035","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-10-17 04:30:11","reservation_modified_date_time":"2021-10-30 22:40:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133035","canceled_nights_data":"","posAmt_airbnb_taxpaid":"140.00","sub_hotel_id":"123","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":"5330124","reservation_id":"124876","confirmation_number":"PB12275587684","room_confirmation_number":"PB12336362808","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"133011","product_attribute_values":"extra_person# ","reservation_created_date":"2021-10-31 16:44:14","reservation_modified_date_time":"2021-10-31 16:44:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133011","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330131","reservation_id":"124714","confirmation_number":"PB12248099082","room_confirmation_number":"PB12350700622","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"133052","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-10-23 17:52:20","reservation_modified_date_time":"2021-10-31 17:08:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133052","canceled_nights_data":"","posAmt_airbnb_taxpaid":"10.00","sub_hotel_id":"123","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":"5330247","reservation_id":"124941","confirmation_number":"BP12243291052","room_confirmation_number":"BP12523649220","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"10.00","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"133077","product_attribute_values":"extra_person# ","reservation_created_date":"2021-11-01 02:22:37","reservation_modified_date_time":"2021-11-01 02:22:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133077","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"125","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3216397","reservation_id":"105927","confirmation_number":"PB12235146923","room_confirmation_number":"PB12373510255","room_stay_from":"2021-10-28","room_stay_to":"2021-11-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"111721","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-01-23 15:26:42","reservation_modified_date_time":"2021-03-16 14:46:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111721","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5315787","reservation_id":"122895","confirmation_number":"PB12276169268","room_confirmation_number":"PB12340796678","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","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":"123116","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-11 22:19:21","reservation_modified_date_time":"2021-09-20 15:02:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123116","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5321449","reservation_id":"123801","confirmation_number":"BV12293453873","room_confirmation_number":"BV12490761757","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","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":"107726","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-28 01:34:51","reservation_modified_date_time":"2021-10-01 20:24:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107726","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5322529","reservation_id":"122804","confirmation_number":"PB12242893704","room_confirmation_number":"PB12348075673","room_stay_from":"2021-10-29","room_stay_to":"2021-11-03","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":"92095","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-09 18:06:08","reservation_modified_date_time":"2021-10-03 02:23:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92095","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5322596","reservation_id":"124070","confirmation_number":"PB12236135884","room_confirmation_number":"PB12381444906","room_stay_from":"2021-10-30","room_stay_to":"2021-11-02","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":"131966","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-03 13:59:40","reservation_modified_date_time":"2021-10-03 14:12:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131966","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5328296","reservation_id":"124715","confirmation_number":"PB12212469384","room_confirmation_number":"PB12345779369","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","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":"132753","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-23 18:12:55","reservation_modified_date_time":"2021-10-23 18:12:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132753","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5328303","reservation_id":"123735","confirmation_number":"PB12256920536","room_confirmation_number":"PB12318515922","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"131508","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-27 02:46:54","reservation_modified_date_time":"2021-10-23 18:18:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131508","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5328320","reservation_id":"111676","confirmation_number":"PB12222915147","room_confirmation_number":"PB12367668880","room_stay_from":"2021-10-23","room_stay_to":"2021-11-03","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":"118233","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-03-30 13:44:33","reservation_modified_date_time":"2021-10-23 19:13:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118233","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5328832","reservation_id":"123507","confirmation_number":"PB12291135264","room_confirmation_number":"PB12349329942","room_stay_from":"2021-10-25","room_stay_to":"2021-11-01","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":"131241","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-22 22:10:25","reservation_modified_date_time":"2021-10-26 13:26:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131241","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5328892","reservation_id":"109801","confirmation_number":"PB12213745321","room_confirmation_number":"PB12346734517","room_stay_from":"2021-10-26","room_stay_to":"2021-11-02","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":"44906","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-26 14:04:32","reservation_modified_date_time":"2021-10-26 15:15:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44906","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5329031","reservation_id":"117259","confirmation_number":"PB12219604617","room_confirmation_number":"PB12371776976","room_stay_from":"2021-10-26","room_stay_to":"2021-11-03","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":"108088","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-14 18:54:11","reservation_modified_date_time":"2021-10-26 20:46:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108088","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5329591","reservation_id":"124859","confirmation_number":"BP12288522464","room_confirmation_number":"BP12564549722","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"132965","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-28 21:55:23","reservation_modified_date_time":"2021-10-29 15:13:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132965","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5329643","reservation_id":"124853","confirmation_number":"BV12262498845","room_confirmation_number":"BV12477609547","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"132997","product_attribute_values":"resort_fee# ","reservation_created_date":"2021-10-28 18:30:29","reservation_modified_date_time":"2021-10-29 16:51:43","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132997","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"5329675","reservation_id":"124277","confirmation_number":"PB12256481651","room_confirmation_number":"PB12320521944","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","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":"132210","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-07 23:13:52","reservation_modified_date_time":"2021-10-29 17:34:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132210","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5329799","reservation_id":"124417","confirmation_number":"PB12251478781","room_confirmation_number":"PB12354247880","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","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":"132380","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-13 01:58:06","reservation_modified_date_time":"2021-10-29 23:38:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132380","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5329815","reservation_id":"124337","confirmation_number":"BP12277376144","room_confirmation_number":"BP12511194811","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","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":"132998","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-10 10:23:11","reservation_modified_date_time":"2021-10-30 03:09:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132998","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5329824","reservation_id":"124896","confirmation_number":"BV12253318458","room_confirmation_number":"BV12456293045","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"133004","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-30 05:02:47","reservation_modified_date_time":"2021-10-30 05:02:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133004","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5329847","reservation_id":"124885","confirmation_number":"PB12277337431","room_confirmation_number":"PB12395174096","room_stay_from":"2021-10-29","room_stay_to":"2021-11-04","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"28108","product_attribute_values":"resort_fee# ","reservation_created_date":"2021-10-29 21:20:27","reservation_modified_date_time":"2021-10-30 13:25:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28108","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"123","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":"5329896","reservation_id":"123059","confirmation_number":"BP12224259132","room_confirmation_number":"BP12582725783","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","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":"27.78","product_id":"1781","service_quantity":"1","customer_traveller_id":"132725","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-15 02:09:11","reservation_modified_date_time":"2021-10-30 15:05:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132725","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","sub_hotel_id":"123","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":"5329968","reservation_id":"123548","confirmation_number":"PB12269263676","room_confirmation_number":"PB12373608192","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133021","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-23 18:53:11","reservation_modified_date_time":"2021-10-30 19:00:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133021","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5329973","reservation_id":"119735","confirmation_number":"BV12225683523","room_confirmation_number":"BV12414204005","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133023","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-20 19:26:11","reservation_modified_date_time":"2021-10-30 19:18:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133023","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5330018","reservation_id":"124598","confirmation_number":"PB12291144009","room_confirmation_number":"PB12393647558","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133030","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-19 00:11:06","reservation_modified_date_time":"2021-10-30 21:08:18","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133030","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330034","reservation_id":"124535","confirmation_number":"PB12299061064","room_confirmation_number":"PB12317698764","room_stay_from":"2021-10-30","room_stay_to":"2021-11-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133035","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-17 04:30:11","reservation_modified_date_time":"2021-10-30 22:40:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133035","canceled_nights_data":"","posAmt_airbnb_taxpaid":"140.00","sub_hotel_id":"123","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":"5330048","reservation_id":"124679","confirmation_number":"BP12214132798","room_confirmation_number":"BP12534138218","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133037","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-22 07:46:10","reservation_modified_date_time":"2021-10-30 23:56:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133037","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5330060","reservation_id":"118520","confirmation_number":"BV12256644606","room_confirmation_number":"BV12445084744","room_stay_from":"2021-10-31","room_stay_to":"2021-11-08","room_stay_status":"Active","nightly_price":"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","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"36678","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-07-02 14:09:27","reservation_modified_date_time":"2021-10-31 01:03:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36678","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5330068","reservation_id":"124915","confirmation_number":"PB12222452388","room_confirmation_number":"PB12369531464","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","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":"133042","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-31 00:55:49","reservation_modified_date_time":"2021-10-31 02:37:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133042","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","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":"5330101","reservation_id":"124909","confirmation_number":"PB12210459545","room_confirmation_number":"PB12313788799","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","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":"133020","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-30 18:57:52","reservation_modified_date_time":"2021-10-31 14:45:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133020","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330103","reservation_id":"124923","confirmation_number":"BP12238981291","room_confirmation_number":"BP12589665353","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"133026","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-31 14:51:36","reservation_modified_date_time":"2021-10-31 14:51:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133026","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5330125","reservation_id":"124876","confirmation_number":"PB12230028263","room_confirmation_number":"PB12336362808","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"24.44","nightly_discount":"0.00","subtotal":"24.44","grand_total":"27.62","paid_amount":"27.62","product_id":"1781","service_quantity":"1","customer_traveller_id":"133011","product_attribute_values":"resort_fee# ","reservation_created_date":"2021-10-29 17:27:22","reservation_modified_date_time":"2021-10-31 16:44:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133011","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","currentDayPrice":"24.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330132","reservation_id":"124714","confirmation_number":"PB12235100853","room_confirmation_number":"PB12350700622","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133052","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-23 17:52:20","reservation_modified_date_time":"2021-10-31 17:08:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133052","canceled_nights_data":"","posAmt_airbnb_taxpaid":"10.00","sub_hotel_id":"123","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":"5330139","reservation_id":"124900","confirmation_number":"BP12263628108","room_confirmation_number":"BP12599530439","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133053","product_attribute_values":"resort_fee# ","reservation_created_date":"2021-10-30 14:47:25","reservation_modified_date_time":"2021-10-31 18:25:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133053","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"123","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":"5330160","reservation_id":"124888","confirmation_number":"PB12287488545","room_confirmation_number":"PB12353029622","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"14.86","nightly_discount":"0.00","subtotal":"14.86","grand_total":"16.79","paid_amount":"16.79","product_id":"1781","service_quantity":"1","customer_traveller_id":"133059","product_attribute_values":"resort_fee# ","reservation_created_date":"2021-10-29 22:32:01","reservation_modified_date_time":"2021-10-31 19:19:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133059","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"123","currentDayPrice":"14.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330163","reservation_id":"124930","confirmation_number":"PB12256531892","room_confirmation_number":"PB12334603781","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"133060","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-31 19:23:07","reservation_modified_date_time":"2021-10-31 19:23:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133060","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330173","reservation_id":"124904","confirmation_number":"PB12239357098","room_confirmation_number":"PB12313036506","room_stay_from":"2021-10-31","room_stay_to":"2021-11-02","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.11","product_id":"1781","service_quantity":"1","customer_traveller_id":"133014","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-30 17:46:54","reservation_modified_date_time":"2021-10-31 20:03:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133014","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330177","reservation_id":"124639","confirmation_number":"PB12283962041","room_confirmation_number":"PB12366946595","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","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":"34584","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-20 15:52:19","reservation_modified_date_time":"2021-10-31 20:15:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"34584","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330182","reservation_id":"124776","confirmation_number":"PB12214057848","room_confirmation_number":"PB12365229491","room_stay_from":"2021-10-31","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"132844","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-26 00:59:06","reservation_modified_date_time":"2021-10-31 20:37:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132844","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330201","reservation_id":"124932","confirmation_number":"BP12259571297","room_confirmation_number":"BP12537922514","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"124625","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-31 20:47:08","reservation_modified_date_time":"2021-10-31 21:16:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124625","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"125","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":"5330208","reservation_id":"124936","confirmation_number":"BV12287535858","room_confirmation_number":"BV12411971771","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"133067","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-31 23:10:32","reservation_modified_date_time":"2021-10-31 23:10:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133067","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5330226","reservation_id":"124939","confirmation_number":"BV12243246302","room_confirmation_number":"BV12425444405","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"133070","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-01 00:45:39","reservation_modified_date_time":"2021-11-01 00:49:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133070","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"124","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":"5330248","reservation_id":"124941","confirmation_number":"BP12280496892","room_confirmation_number":"BP12523649220","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133077","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-01 00:46:47","reservation_modified_date_time":"2021-11-01 02:22:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133077","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"125","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5330082","reservation_id":"124806","confirmation_number":"BV12220328950","room_confirmation_number":"BV12417477554","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1141","service_quantity":"2","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 13:00:12","reservation_modified_date_time":"2021-10-31 13:00:12","customer_id":"133017","parentCustTravId":"133017","customer_traveller_id":"133017","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-10-30","sub_hotel_id":"124","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330088","reservation_id":"124922","confirmation_number":"BP12263368271","room_confirmation_number":"BP12558043110","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":"101.70","paid_amount":"0.00","product_id":"2109","service_quantity":"2","product_name":"Boat Slip Docking","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 14:06:22","reservation_modified_date_time":"2021-10-31 14:06:22","customer_id":"133047","parentCustTravId":"133047","customer_traveller_id":"133047","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-11-02","sub_hotel_id":"125","currentDayPrice":"90.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330089","reservation_id":"124922","confirmation_number":"BP12298319881","room_confirmation_number":"BP12558043110","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.50","paid_amount":"0.00","product_id":"2108","service_quantity":"2","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 14:06:22","reservation_modified_date_time":"2021-10-31 14:06:22","customer_id":"133047","parentCustTravId":"133047","customer_traveller_id":"133047","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-11-02","sub_hotel_id":"125","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330094","reservation_id":"124070","confirmation_number":"PB12247708730","room_confirmation_number":"PB12381444906","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 14:24:40","reservation_modified_date_time":"2021-10-31 14:24:40","customer_id":"131966","parentCustTravId":"131966","customer_traveller_id":"131966","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-10-30","sub_hotel_id":"123","currentDayPrice":"37.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330126","reservation_id":"124876","confirmation_number":"PB12245295168","room_confirmation_number":"PB12336362808","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"42.06","grand_total":"45.00","paid_amount":"45.00","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 16:46:13","reservation_modified_date_time":"2021-10-31 16:46:13","customer_id":"133011","parentCustTravId":"133011","customer_traveller_id":"133011","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-10-31","sub_hotel_id":"123","currentDayPrice":"42.06","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330140","reservation_id":"124900","confirmation_number":"PB12273748363","room_confirmation_number":"BP12599530439","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 18:23:21","reservation_modified_date_time":"2021-10-31 18:25:19","customer_id":"133053","parentCustTravId":"133053","customer_traveller_id":"133053","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-10-31","sub_hotel_id":"123","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330146","reservation_id":"124885","confirmation_number":"PB12226657288","room_confirmation_number":"PB12395174096","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"18.69","grand_total":"20.00","paid_amount":"20.00","product_id":"1201","service_quantity":"1","product_name":"Sunglasses - 2 pairs","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 18:54:33","reservation_modified_date_time":"2021-10-31 18:54:33","customer_id":"28108","parentCustTravId":"28108","customer_traveller_id":"28108","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-10-29","sub_hotel_id":"123","currentDayPrice":"18.69","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330147","reservation_id":"124885","confirmation_number":"PB12221611985","room_confirmation_number":"PB12395174096","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 18:56:07","reservation_modified_date_time":"2021-10-31 18:56:07","customer_id":"28108","parentCustTravId":"28108","customer_traveller_id":"28108","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-10-29","sub_hotel_id":"123","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330158","reservation_id":"124888","confirmation_number":"PB12226480847","room_confirmation_number":"PB12353029622","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 19:16:12","reservation_modified_date_time":"2021-10-31 19:19:05","customer_id":"133059","parentCustTravId":"133059","customer_traveller_id":"133059","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-10-31","sub_hotel_id":"123","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330159","reservation_id":"124888","confirmation_number":"PB12239877398","room_confirmation_number":"PB12353029622","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 19:17:47","reservation_modified_date_time":"2021-10-31 19:19:05","customer_id":"133059","parentCustTravId":"133059","customer_traveller_id":"133059","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-10-31","sub_hotel_id":"123","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330164","reservation_id":"124876","confirmation_number":"PB12286618881","room_confirmation_number":"PB12336362808","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"50.00","paid_amount":"0.00","product_id":"2010","service_quantity":"5","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 19:29:16","reservation_modified_date_time":"2021-10-31 19:29:16","customer_id":"133011","parentCustTravId":"133011","customer_traveller_id":"133011","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-10-31","sub_hotel_id":"123","currentDayPrice":"46.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330176","reservation_id":"124639","confirmation_number":"PB12256670240","room_confirmation_number":"PB12366946595","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 20:15:03","reservation_modified_date_time":"2021-10-31 20:15:10","customer_id":"34584","parentCustTravId":"34584","customer_traveller_id":"34584","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-10-30","sub_hotel_id":"123","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":"5330178","reservation_id":"123735","confirmation_number":"PB12242222279","room_confirmation_number":"PB12318515922","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","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-10-31 20:31:20","reservation_modified_date_time":"2021-10-31 20:31:20","customer_id":"131508","parentCustTravId":"131508","customer_traveller_id":"131508","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-10-29","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330200","reservation_id":"124932","confirmation_number":"BP12238358692","room_confirmation_number":"BP12537922514","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"15.00","grand_total":"16.95","paid_amount":"16.95","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 21:14:38","reservation_modified_date_time":"2021-10-31 21:16:54","customer_id":"124625","parentCustTravId":"124625","customer_traveller_id":"124625","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-10-31","sub_hotel_id":"125","currentDayPrice":"15.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330204","reservation_id":"124909","confirmation_number":"PB12228021597","room_confirmation_number":"PB12313788799","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","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-10-31 22:20:59","reservation_modified_date_time":"2021-10-31 22:20:59","customer_id":"133020","parentCustTravId":"133020","customer_traveller_id":"133020","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-10-30","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330213","reservation_id":"124547","confirmation_number":"BP12224129015","room_confirmation_number":"BP12575788760","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"135.60","paid_amount":"0.00","product_id":"1212","service_quantity":"3","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 23:54:14","reservation_modified_date_time":"2021-10-31 23:54:14","customer_id":"132534","parentCustTravId":"132534","customer_traveller_id":"132534","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-11-01","sub_hotel_id":"125","currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330236","reservation_id":"124941","confirmation_number":"BP12287620374","room_confirmation_number":"BP12523649220","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"42.06","grand_total":"45.00","paid_amount":"45.00","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-01 02:16:08","reservation_modified_date_time":"2021-11-01 02:16:08","customer_id":"133077","parentCustTravId":"133077","customer_traveller_id":"133077","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-10-31","sub_hotel_id":"125","currentDayPrice":"42.06","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330184","reservation_id":"124931","confirmation_number":"PB12224395091","room_confirmation_number":"PB12317878932","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 20:45:26","reservation_modified_date_time":"2021-10-31 20:45:26","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","sub_hotel_id":"123","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5329237","reservation_id":"123841","confirmation_number":"PB12232205425","room_confirmation_number":"PB12346485727","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-10-27 20:29:52","reservation_modified_date_time":"2021-10-27 20:29:52","customer_id":"117427","parentCustTravId":"117427","customer_traveller_id":"117427","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-10-31 15:00:42","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-10-27","sub_hotel_id":"123","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":"5329324","reservation_id":"122192","confirmation_number":"PB12292865205","room_confirmation_number":"PB12382363318","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":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-28 14:21:08","reservation_modified_date_time":"2021-10-28 14:21:08","customer_id":"132875","parentCustTravId":"132875","customer_traveller_id":"132875","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-10-31 19:49:51","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-10-27","sub_hotel_id":"123","deltaChange":-28.05,"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":"5329977","reservation_id":"124886","confirmation_number":"BP12217368914","room_confirmation_number":"BP12548016582","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":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-30 19:20:05","reservation_modified_date_time":"2021-10-30 19:23:25","customer_id":"133024","parentCustTravId":"133024","customer_traveller_id":"133024","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-10-31 14:38:01","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-10-30","sub_hotel_id":"125","deltaChange":-9.35,"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":"5329988","reservation_id":"124895","confirmation_number":"PB12283794867","room_confirmation_number":"PB12393540966","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":"50.00","paid_amount":"0.00","product_id":"2010","service_quantity":"5","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-30 19:40:14","reservation_modified_date_time":"2021-10-30 19:40:14","customer_id":"133022","parentCustTravId":"133022","customer_traveller_id":"133022","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-10-31 12:39:32","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-10-30","sub_hotel_id":"123","deltaChange":-46.75,"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":12,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1096,1101","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12270645200","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","bundle_room":"0","product_id":"1096"},{"confirmation_number":"PB12233600565","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","bundle_room":"0","product_id":"1101"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5329032","reservation_id":"117259","confirmation_number":"PB12371776976","room_stay_from":"2021-10-26","room_stay_to":"2021-11-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"166.55,166.55,166.55,181.76,181.76,166.55,128.12,128.12","nightly_discount":"0,0,0,0,0,0,0,0","subtotal":"1285.96","grand_total":"1453.14","paid_amount":"1453.14","room_type_id":"289","product_id":"1104","siteminder_id":"BDC-3761353822","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":"108088","customer_id":"108088","source_of_creation":"Booking.com","reservation_created_date":"2021-06-14 18:54:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"216.89","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"166.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"}]},{"room_stay_id":"5329969","reservation_id":"123548","confirmation_number":"PB12373608192","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"176.17,161.42","nightly_discount":"0,0","subtotal":"337.59","grand_total":"381.48","paid_amount":"381.48","room_type_id":"289","product_id":"1123","siteminder_id":"BDC-2177071278","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":"133021","customer_id":"133021","source_of_creation":"Booking.com","reservation_created_date":"2021-09-23 18:53:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"56.64","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"161.42","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330123","reservation_id":"124876","confirmation_number":"PB12336362808","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"5","room_stay_child_count":"0","nightly_price":"173.65","nightly_discount":"0.00","subtotal":"173.65","grand_total":"196.23","paid_amount":"196.23","room_type_id":"291","product_id":"1119","siteminder_id":"BDC-2207454222","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"30.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133011","customer_id":"133011","source_of_creation":"Booking.com","reservation_created_date":"2021-10-29 17:27:22","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"32.05","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"173.65","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330133","reservation_id":"124714","confirmation_number":"PB12350700622","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"164.46","nightly_discount":"0","subtotal":"164.46","grand_total":"185.84","paid_amount":"185.84","room_type_id":"289","product_id":"1093","siteminder_id":"BDC-3075054209","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"10.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133052","customer_id":"133052","source_of_creation":"Booking.com","reservation_created_date":"2021-10-23 17:52:20","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"29.17","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"164.46","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"5329848","reservation_id":"124885","confirmation_number":"PB12395174096","room_stay_from":"2021-10-29","room_stay_to":"2021-11-04","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"169.24,169.24,123.44,160.48,160.48,160.48","nightly_discount":"0,0,0,0,0,0","subtotal":"943.36","grand_total":"1066.00","paid_amount":"1066.00","room_type_id":"291","product_id":"1114","siteminder_id":"EXP-1850633479","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"120.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"28108","customer_id":"28108","source_of_creation":"Expedia","reservation_created_date":"2021-10-29 21:20:27","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 204","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"123.44","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":"5329894","reservation_id":"123059","confirmation_number":"BP12582725783","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"182.90,182.90,164.70","nightly_discount":"0.00,0.00,0.00","subtotal":"530.50","grand_total":"599.47","paid_amount":"599.47","room_type_id":"288","product_id":"1092","siteminder_id":"EXP-1830012839","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"60.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132725","customer_id":"132725","source_of_creation":"Expedia","reservation_created_date":"2021-09-15 02:09:11","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 222","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"164.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330017","reservation_id":"124598","confirmation_number":"PB12393647558","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"164.74,112.17","nightly_discount":"0,0","subtotal":"276.91","grand_total":"312.90","paid_amount":"312.90","room_type_id":"289","product_id":"1111","siteminder_id":"EXP-1845616313","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":"133030","customer_id":"133030","source_of_creation":"Expedia","reservation_created_date":"2021-10-19 00:11:06","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"112.17","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330035","reservation_id":"124535","confirmation_number":"PB12317698764","room_stay_from":"2021-10-30","room_stay_to":"2021-11-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"168.86,113.3,149.61,149.61,149.61,149.61,178.91","nightly_discount":"0,0,0,0,0,0,0","subtotal":"1059.51","grand_total":"1197.25","paid_amount":"1197.25","room_type_id":"289","product_id":"1102","siteminder_id":"EXP-1844806031","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"140.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133035","customer_id":"133035","source_of_creation":"Expedia","reservation_created_date":"2021-10-17 04:30:11","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":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"113.3","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":"5330069","reservation_id":"124915","confirmation_number":"PB12369531464","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"160.15,115.55","nightly_discount":"0,0","subtotal":"275.70","grand_total":"311.54","paid_amount":"311.54","room_type_id":"289","product_id":"1103","siteminder_id":"EXP-1851069389","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"40.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133042","customer_id":"133042","source_of_creation":"Expedia","reservation_created_date":"2021-10-31 00:55:49","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"115.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"}]},{"room_stay_id":"5330141","reservation_id":"124900","confirmation_number":"BP12599530439","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.80","nightly_discount":"0","subtotal":"62.80","grand_total":"70.97","paid_amount":"70.97","room_type_id":"289","product_id":"1109","siteminder_id":"EXP-1850875804","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133053","customer_id":"133053","source_of_creation":"Expedia","reservation_created_date":"2021-10-30 14:47:25","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":"","sub_hotel_id":"123","currentDayPrice":"62.80","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":"5330161","reservation_id":"124888","confirmation_number":"PB12353029622","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"123.80","nightly_discount":"0.00","subtotal":"123.80","grand_total":"139.90","paid_amount":"139.90","room_type_id":"287","product_id":"1087","siteminder_id":"EXP-1850660716","collect_which":"channel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133059","customer_id":"133059","source_of_creation":"Expedia","reservation_created_date":"2021-10-29 22:32:01","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":"","sub_hotel_id":"123","currentDayPrice":"123.80","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"5321450","reservation_id":"123801","confirmation_number":"BV12490761757","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"6","room_stay_child_count":"0","nightly_price":"253.50,261.99","nightly_discount":"0.00,0.00","subtotal":"515.49","grand_total":"582.50","paid_amount":"582.50","room_type_id":"288","product_id":"1091","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"107726","customer_id":"107726","source_of_creation":"FE","reservation_created_date":"2021-09-28 01:34:51","canceled_nights_data":"","product_name":"PB Deluxe One Bedroom Suite 2Q, 1SS 220","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"261.99","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5322595","reservation_id":"124070","confirmation_number":"PB12381444906","room_stay_from":"2021-10-30","room_stay_to":"2021-11-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"287.30,261.30,339.69","nightly_discount":"0.00,0.00,0.00","subtotal":"888.29","grand_total":"1003.77","paid_amount":"1003.77","room_type_id":"287","product_id":"1088","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131966","customer_id":"131966","source_of_creation":"FE","reservation_created_date":"2021-10-03 13:59:40","canceled_nights_data":"","product_name":"PB Gulf Front with Balcony Suite 1K, 1SS 117","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"261.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"}]},{"room_stay_id":"5328301","reservation_id":"123735","confirmation_number":"PB12318515922","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"219.70,219.70,193.70","nightly_discount":"0.00,0.00,0.00","subtotal":"633.10","grand_total":"715.41","paid_amount":"715.41","room_type_id":"291","product_id":"1116","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131508","customer_id":"131508","source_of_creation":"FE","reservation_created_date":"2021-09-27 02:46:54","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 208","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"193.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5328831","reservation_id":"123507","confirmation_number":"PB12349329942","room_stay_from":"2021-10-25","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"156.00,156.00,156.00,156.00,182.00,182.00,156.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,54.30","subtotal":"1144.00","grand_total":"1231.36","paid_amount":"1231.36","room_type_id":"289","product_id":"1105","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":"131241","customer_id":"131241","source_of_creation":"FE","reservation_created_date":"2021-09-22 22:10:25","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 120","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"156.00","currentDayDiscount":"54.30","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5329674","reservation_id":"124277","confirmation_number":"PB12320521944","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"270.23,270.23,193.70","nightly_discount":"0.00,0.00,0.00","subtotal":"734.16","grand_total":"829.60","paid_amount":"829.60","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":"132210","customer_id":"132210","source_of_creation":"FE","reservation_created_date":"2021-10-07 23:13:52","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":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"193.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5329797","reservation_id":"124417","confirmation_number":"PB12354247880","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"0","nightly_price":"255.84,182.00","nightly_discount":"0.00,0.00","subtotal":"437.84","grand_total":"494.76","paid_amount":"494.76","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":"132380","customer_id":"132380","source_of_creation":"FE","reservation_created_date":"2021-10-13 01:58:06","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":"182.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330100","reservation_id":"124909","confirmation_number":"PB12313788799","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.66,89.00","nightly_discount":"0.00,0.00","subtotal":"238.66","grand_total":"269.69","paid_amount":"269.69","room_type_id":"289","product_id":"1107","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":"133020","customer_id":"133020","source_of_creation":"FE","reservation_created_date":"2021-10-30 18:57:52","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 203","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"89.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330162","reservation_id":"124930","confirmation_number":"PB12334603781","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"98.21","nightly_discount":"0.00","subtotal":"98.21","grand_total":"110.97","paid_amount":"110.97","room_type_id":"285","product_id":"1085","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133060","customer_id":"133060","source_of_creation":"FE","reservation_created_date":"2021-10-31 19:23:07","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 201","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"98.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330175","reservation_id":"124639","confirmation_number":"PB12366946595","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"255.84,167.44","nightly_discount":"0.00,0.00","subtotal":"423.28","grand_total":"478.31","paid_amount":"478.31","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":"34584","customer_id":"34584","source_of_creation":"FE","reservation_created_date":"2021-10-20 15:52:19","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","currentDayPrice":"167.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"3216396","reservation_id":"105927","confirmation_number":"PB12373510255","room_stay_from":"2021-10-28","room_stay_to":"2021-11-06","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.00,186.00,206.00,206.00,186.00,186.00,186.00,186.00,186.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0","subtotal":"1714.00","grand_total":"1936.82","paid_amount":"1936.82","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":"111721","customer_id":"111721","source_of_creation":"PMS","reservation_created_date":"2021-01-23 15:26:42","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":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"206.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315785","reservation_id":"122895","confirmation_number":"PB12340796678","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"195.00,195.00,169.00","nightly_discount":"0.00,0.00,0.00","subtotal":"559.00","grand_total":"631.67","paid_amount":"631.67","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":"123116","customer_id":"123116","source_of_creation":"PMS","reservation_created_date":"2021-09-11 22:19:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 106","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"169.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5322528","reservation_id":"122804","confirmation_number":"PB12348075673","room_stay_from":"2021-10-29","room_stay_to":"2021-11-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"219.70,219.70,193.70,251.81,251.81","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"1136.72","grand_total":"1284.49","paid_amount":"1284.49","room_type_id":"291","product_id":"1118","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"92095","customer_id":"92095","source_of_creation":"PMS","reservation_created_date":"2021-09-09 18:06:08","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 212","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"193.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5328295","reservation_id":"124715","confirmation_number":"PB12345779369","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"239.85,239.85,155.48","nightly_discount":"0.00,0.00,0.00","subtotal":"635.18","grand_total":"717.75","paid_amount":"717.75","room_type_id":"285","product_id":"1084","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132753","customer_id":"132753","source_of_creation":"PMS","reservation_created_date":"2021-10-23 18:12:55","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K 102","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"155.48","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5328319","reservation_id":"111676","confirmation_number":"PB12367668880","room_stay_from":"2021-10-23","room_stay_to":"2021-11-03","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,120.00,120.00,120.00,120.00,120.00,140.00,140.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,68.60","subtotal":"1380.00","grand_total":"1481.88","paid_amount":"1481.88","room_type_id":"289","product_id":"1121","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"118233","customer_id":"118233","source_of_creation":"PMS","reservation_created_date":"2021-03-30 13:44:33","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 103","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5328891","reservation_id":"109801","confirmation_number":"PB12346734517","room_stay_from":"2021-10-26","room_stay_to":"2021-11-02","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.00,143.00,143.00,143.00,143.00,143.00,143.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,54.26","subtotal":"1001.00","grand_total":"1069.81","paid_amount":"1069.82","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":"44906","customer_id":"44906","source_of_creation":"PMS","reservation_created_date":"2021-10-26 14:04:32","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":"143.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330172","reservation_id":"124904","confirmation_number":"PB12313036506","room_stay_from":"2021-10-31","room_stay_to":"2021-11-02","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"1","nightly_price":"98.21,127.66","nightly_discount":"0.00,7.40","subtotal":"225.87","grand_total":"246.87","paid_amount":"246.87","room_type_id":"292","product_id":"1120","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":"133014","customer_id":"133014","source_of_creation":"PMS","reservation_created_date":"2021-10-30 17:46:54","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 1K, 1SS 218","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"98.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330181","reservation_id":"124776","confirmation_number":"PB12365229491","room_stay_from":"2021-10-31","room_stay_to":"2021-11-10","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"143.52,186.58,186.58,186.58,186.58,236.60,236.60,202.80,202.80,202.80","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,97.40","subtotal":"1971.44","grand_total":"2117.66","paid_amount":"2117.66","room_type_id":"289","product_id":"1108","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132844","customer_id":"132844","source_of_creation":"PMS","reservation_created_date":"2021-10-26 00:59:06","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":"","sub_hotel_id":"123","currentDayPrice":"143.52","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5315786","reservation_id":"122895","confirmation_number":"PB12286692538","room_confirmation_number":"PB12340796678","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"123116","product_attribute_values":"extra_person# ","reservation_created_date":"2021-09-20 15:02:15","reservation_modified_date_time":"2021-09-20 15:02:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123116","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5321448","reservation_id":"123801","confirmation_number":"BV12264084691","room_confirmation_number":"BV12490761757","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"40,40","nightly_discount":"0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1780","service_quantity":"1","customer_traveller_id":"107726","product_attribute_values":"extra_person# ","reservation_created_date":"2021-10-01 20:21:25","reservation_modified_date_time":"2021-10-01 20:24:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107726","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"40","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5328302","reservation_id":"123735","confirmation_number":"PB12214393811","room_confirmation_number":"PB12318515922","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0,0,0","subtotal":"60.00","grand_total":"67.80","paid_amount":"40.68","product_id":"1780","service_quantity":"1","customer_traveller_id":"131508","product_attribute_values":"extra_person# ","reservation_created_date":"2021-10-23 18:18:14","reservation_modified_date_time":"2021-10-23 18:18:14","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131508","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"20","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5329686","reservation_id":"123059","confirmation_number":"BP12240362019","room_confirmation_number":"BP12582725783","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20,20,20","nightly_discount":"0.00,0.00,0.00","subtotal":"60.00","grand_total":"67.80","paid_amount":"67.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"132725","product_attribute_values":"extra_person# ","reservation_created_date":"2021-10-29 17:56:47","reservation_modified_date_time":"2021-10-29 17:56:47","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132725","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","sub_hotel_id":"123","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":"5329798","reservation_id":"124417","confirmation_number":"PB12266487691","room_confirmation_number":"PB12354247880","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0,0","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"132380","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-10-29 23:38:08","reservation_modified_date_time":"2021-10-29 23:38:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132380","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"10","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330033","reservation_id":"124535","confirmation_number":"PB12297460333","room_confirmation_number":"PB12317698764","room_stay_from":"2021-10-30","room_stay_to":"2021-11-06","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1780","service_quantity":"1","customer_traveller_id":"133035","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-10-17 04:30:11","reservation_modified_date_time":"2021-10-30 22:40:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133035","canceled_nights_data":"","posAmt_airbnb_taxpaid":"140.00","sub_hotel_id":"123","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":"5330124","reservation_id":"124876","confirmation_number":"PB12275587684","room_confirmation_number":"PB12336362808","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"30","nightly_discount":"0.00","subtotal":"30.00","grand_total":"33.90","paid_amount":"33.90","product_id":"1780","service_quantity":"1","customer_traveller_id":"133011","product_attribute_values":"extra_person# ","reservation_created_date":"2021-10-31 16:44:14","reservation_modified_date_time":"2021-10-31 16:44:14","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133011","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","currentDayPrice":"30","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330131","reservation_id":"124714","confirmation_number":"PB12248099082","room_confirmation_number":"PB12350700622","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"10","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"133052","product_attribute_values":"extra_person# .00","reservation_created_date":"2021-10-23 17:52:20","reservation_modified_date_time":"2021-10-31 17:08:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133052","canceled_nights_data":"","posAmt_airbnb_taxpaid":"10.00","sub_hotel_id":"123","currentDayPrice":"10","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3216397","reservation_id":"105927","confirmation_number":"PB12235146923","room_confirmation_number":"PB12373510255","room_stay_from":"2021-10-28","room_stay_to":"2021-11-06","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"108.00","grand_total":"122.04","paid_amount":"122.04","product_id":"1781","service_quantity":"1","customer_traveller_id":"111721","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-01-23 15:26:42","reservation_modified_date_time":"2021-03-16 14:46:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"111721","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5315787","reservation_id":"122895","confirmation_number":"PB12276169268","room_confirmation_number":"PB12340796678","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","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":"123116","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-11 22:19:21","reservation_modified_date_time":"2021-09-20 15:02:16","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"123116","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5321449","reservation_id":"123801","confirmation_number":"BV12293453873","room_confirmation_number":"BV12490761757","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","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":"107726","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-28 01:34:51","reservation_modified_date_time":"2021-10-01 20:24:22","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"107726","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5322529","reservation_id":"122804","confirmation_number":"PB12242893704","room_confirmation_number":"PB12348075673","room_stay_from":"2021-10-29","room_stay_to":"2021-11-03","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":"92095","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-09 18:06:08","reservation_modified_date_time":"2021-10-03 02:23:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"92095","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5322596","reservation_id":"124070","confirmation_number":"PB12236135884","room_confirmation_number":"PB12381444906","room_stay_from":"2021-10-30","room_stay_to":"2021-11-02","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":"131966","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-03 13:59:40","reservation_modified_date_time":"2021-10-03 14:12:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131966","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5328296","reservation_id":"124715","confirmation_number":"PB12212469384","room_confirmation_number":"PB12345779369","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","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":"132753","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-23 18:12:55","reservation_modified_date_time":"2021-10-23 18:12:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132753","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5328303","reservation_id":"123735","confirmation_number":"PB12256920536","room_confirmation_number":"PB12318515922","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00","subtotal":"36.00","grand_total":"40.68","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"131508","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-27 02:46:54","reservation_modified_date_time":"2021-10-23 18:18:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131508","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5328320","reservation_id":"111676","confirmation_number":"PB12222915147","room_confirmation_number":"PB12367668880","room_stay_from":"2021-10-23","room_stay_to":"2021-11-03","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":"118233","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-03-30 13:44:33","reservation_modified_date_time":"2021-10-23 19:13:46","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"118233","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5328832","reservation_id":"123507","confirmation_number":"PB12291135264","room_confirmation_number":"PB12349329942","room_stay_from":"2021-10-25","room_stay_to":"2021-11-01","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":"131241","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-09-22 22:10:25","reservation_modified_date_time":"2021-10-26 13:26:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131241","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5328892","reservation_id":"109801","confirmation_number":"PB12213745321","room_confirmation_number":"PB12346734517","room_stay_from":"2021-10-26","room_stay_to":"2021-11-02","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":"44906","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-26 14:04:32","reservation_modified_date_time":"2021-10-26 15:15:51","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44906","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5329031","reservation_id":"117259","confirmation_number":"PB12219604617","room_confirmation_number":"PB12371776976","room_stay_from":"2021-10-26","room_stay_to":"2021-11-03","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":"108088","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-06-14 18:54:11","reservation_modified_date_time":"2021-10-26 20:46:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"108088","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5329675","reservation_id":"124277","confirmation_number":"PB12256481651","room_confirmation_number":"PB12320521944","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","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":"132210","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-07 23:13:52","reservation_modified_date_time":"2021-10-29 17:34:01","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132210","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5329799","reservation_id":"124417","confirmation_number":"PB12251478781","room_confirmation_number":"PB12354247880","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","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":"132380","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-13 01:58:06","reservation_modified_date_time":"2021-10-29 23:38:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132380","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5329847","reservation_id":"124885","confirmation_number":"PB12277337431","room_confirmation_number":"PB12395174096","room_stay_from":"2021-10-29","room_stay_to":"2021-11-04","room_stay_status":"Active","nightly_price":"20,20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"28108","product_attribute_values":"resort_fee# ","reservation_created_date":"2021-10-29 21:20:27","reservation_modified_date_time":"2021-10-30 13:25:49","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"28108","canceled_nights_data":"","posAmt_airbnb_taxpaid":"120.00","sub_hotel_id":"123","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":"5329896","reservation_id":"123059","confirmation_number":"BP12224259132","room_confirmation_number":"BP12582725783","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","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":"27.78","product_id":"1781","service_quantity":"1","customer_traveller_id":"132725","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-15 02:09:11","reservation_modified_date_time":"2021-10-30 15:05:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132725","canceled_nights_data":"","posAmt_airbnb_taxpaid":"60.00","sub_hotel_id":"123","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":"5329968","reservation_id":"123548","confirmation_number":"PB12269263676","room_confirmation_number":"PB12373608192","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133021","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-09-23 18:53:11","reservation_modified_date_time":"2021-10-30 19:00:09","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133021","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330018","reservation_id":"124598","confirmation_number":"PB12291144009","room_confirmation_number":"PB12393647558","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133030","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-19 00:11:06","reservation_modified_date_time":"2021-10-30 21:08:18","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133030","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330034","reservation_id":"124535","confirmation_number":"PB12299061064","room_confirmation_number":"PB12317698764","room_stay_from":"2021-10-30","room_stay_to":"2021-11-06","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"140.00","grand_total":"158.20","paid_amount":"158.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133035","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-17 04:30:11","reservation_modified_date_time":"2021-10-30 22:40:07","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133035","canceled_nights_data":"","posAmt_airbnb_taxpaid":"140.00","sub_hotel_id":"123","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":"5330068","reservation_id":"124915","confirmation_number":"PB12222452388","room_confirmation_number":"PB12369531464","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","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":"133042","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-31 00:55:49","reservation_modified_date_time":"2021-10-31 02:37:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133042","canceled_nights_data":"","posAmt_airbnb_taxpaid":"40.00","sub_hotel_id":"123","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":"5330101","reservation_id":"124909","confirmation_number":"PB12210459545","room_confirmation_number":"PB12313788799","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","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":"133020","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-30 18:57:52","reservation_modified_date_time":"2021-10-31 14:45:03","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133020","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330125","reservation_id":"124876","confirmation_number":"PB12230028263","room_confirmation_number":"PB12336362808","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"24.44","nightly_discount":"0.00","subtotal":"24.44","grand_total":"27.62","paid_amount":"27.62","product_id":"1781","service_quantity":"1","customer_traveller_id":"133011","product_attribute_values":"resort_fee# ","reservation_created_date":"2021-10-29 17:27:22","reservation_modified_date_time":"2021-10-31 16:44:15","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133011","canceled_nights_data":"","posAmt_airbnb_taxpaid":"30.00","sub_hotel_id":"123","currentDayPrice":"24.44","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330132","reservation_id":"124714","confirmation_number":"PB12235100853","room_confirmation_number":"PB12350700622","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133052","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-23 17:52:20","reservation_modified_date_time":"2021-10-31 17:08:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133052","canceled_nights_data":"","posAmt_airbnb_taxpaid":"10.00","sub_hotel_id":"123","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":"5330139","reservation_id":"124900","confirmation_number":"BP12263628108","room_confirmation_number":"BP12599530439","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133053","product_attribute_values":"resort_fee# ","reservation_created_date":"2021-10-30 14:47:25","reservation_modified_date_time":"2021-10-31 18:25:19","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133053","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"123","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":"5330160","reservation_id":"124888","confirmation_number":"PB12287488545","room_confirmation_number":"PB12353029622","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"14.86","nightly_discount":"0.00","subtotal":"14.86","grand_total":"16.79","paid_amount":"16.79","product_id":"1781","service_quantity":"1","customer_traveller_id":"133059","product_attribute_values":"resort_fee# ","reservation_created_date":"2021-10-29 22:32:01","reservation_modified_date_time":"2021-10-31 19:19:05","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133059","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"123","currentDayPrice":"14.86","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330163","reservation_id":"124930","confirmation_number":"PB12256531892","room_confirmation_number":"PB12334603781","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"133060","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-31 19:23:07","reservation_modified_date_time":"2021-10-31 19:23:07","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133060","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330173","reservation_id":"124904","confirmation_number":"PB12239357098","room_confirmation_number":"PB12313036506","room_stay_from":"2021-10-31","room_stay_to":"2021-11-02","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.11","product_id":"1781","service_quantity":"1","customer_traveller_id":"133014","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-30 17:46:54","reservation_modified_date_time":"2021-10-31 20:03:08","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133014","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330177","reservation_id":"124639","confirmation_number":"PB12283962041","room_confirmation_number":"PB12366946595","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","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":"34584","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-20 15:52:19","reservation_modified_date_time":"2021-10-31 20:15:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"34584","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","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":"5330182","reservation_id":"124776","confirmation_number":"PB12214057848","room_confirmation_number":"PB12365229491","room_stay_from":"2021-10-31","room_stay_to":"2021-11-10","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"132844","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-26 00:59:06","reservation_modified_date_time":"2021-10-31 20:37:09","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132844","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"123","currentDayPrice":"12.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5330094","reservation_id":"124070","confirmation_number":"PB12247708730","room_confirmation_number":"PB12381444906","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"40.00","paid_amount":"0.00","product_id":"2010","service_quantity":"4","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 14:24:40","reservation_modified_date_time":"2021-10-31 14:24:40","customer_id":"131966","parentCustTravId":"131966","customer_traveller_id":"131966","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-10-30","sub_hotel_id":"123","currentDayPrice":"37.40","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330126","reservation_id":"124876","confirmation_number":"PB12245295168","room_confirmation_number":"PB12336362808","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"42.06","grand_total":"45.00","paid_amount":"45.00","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 16:46:13","reservation_modified_date_time":"2021-10-31 16:46:13","customer_id":"133011","parentCustTravId":"133011","customer_traveller_id":"133011","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-10-31","sub_hotel_id":"123","currentDayPrice":"42.06","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330140","reservation_id":"124900","confirmation_number":"PB12273748363","room_confirmation_number":"BP12599530439","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"28.25","paid_amount":"28.25","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 18:23:21","reservation_modified_date_time":"2021-10-31 18:25:19","customer_id":"133053","parentCustTravId":"133053","customer_traveller_id":"133053","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-10-31","sub_hotel_id":"123","currentDayPrice":"25.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330146","reservation_id":"124885","confirmation_number":"PB12226657288","room_confirmation_number":"PB12395174096","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"18.69","grand_total":"20.00","paid_amount":"20.00","product_id":"1201","service_quantity":"1","product_name":"Sunglasses - 2 pairs","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 18:54:33","reservation_modified_date_time":"2021-10-31 18:54:33","customer_id":"28108","parentCustTravId":"28108","customer_traveller_id":"28108","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-10-29","sub_hotel_id":"123","currentDayPrice":"18.69","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330147","reservation_id":"124885","confirmation_number":"PB12221611985","room_confirmation_number":"PB12395174096","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 18:56:07","reservation_modified_date_time":"2021-10-31 18:56:07","customer_id":"28108","parentCustTravId":"28108","customer_traveller_id":"28108","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-10-29","sub_hotel_id":"123","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330158","reservation_id":"124888","confirmation_number":"PB12226480847","room_confirmation_number":"PB12353029622","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 19:16:12","reservation_modified_date_time":"2021-10-31 19:19:05","customer_id":"133059","parentCustTravId":"133059","customer_traveller_id":"133059","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-10-31","sub_hotel_id":"123","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330159","reservation_id":"124888","confirmation_number":"PB12239877398","room_confirmation_number":"PB12353029622","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 19:17:47","reservation_modified_date_time":"2021-10-31 19:19:05","customer_id":"133059","parentCustTravId":"133059","customer_traveller_id":"133059","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-10-31","sub_hotel_id":"123","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330164","reservation_id":"124876","confirmation_number":"PB12286618881","room_confirmation_number":"PB12336362808","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"9.35","grand_total":"50.00","paid_amount":"0.00","product_id":"2010","service_quantity":"5","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 19:29:16","reservation_modified_date_time":"2021-10-31 19:29:16","customer_id":"133011","parentCustTravId":"133011","customer_traveller_id":"133011","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-10-31","sub_hotel_id":"123","currentDayPrice":"46.75","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330176","reservation_id":"124639","confirmation_number":"PB12256670240","room_confirmation_number":"PB12366946595","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 20:15:03","reservation_modified_date_time":"2021-10-31 20:15:10","customer_id":"34584","parentCustTravId":"34584","customer_traveller_id":"34584","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-10-30","sub_hotel_id":"123","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":"5330178","reservation_id":"123735","confirmation_number":"PB12242222279","room_confirmation_number":"PB12318515922","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","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-10-31 20:31:20","reservation_modified_date_time":"2021-10-31 20:31:20","customer_id":"131508","parentCustTravId":"131508","customer_traveller_id":"131508","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-10-29","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330204","reservation_id":"124909","confirmation_number":"PB12228021597","room_confirmation_number":"PB12313788799","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","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-10-31 22:20:59","reservation_modified_date_time":"2021-10-31 22:20:59","customer_id":"133020","parentCustTravId":"133020","customer_traveller_id":"133020","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-10-30","sub_hotel_id":"123","currentDayPrice":"18.70","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5330184","reservation_id":"124931","confirmation_number":"PB12224395091","room_confirmation_number":"PB12317878932","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"11.21","grand_total":"11.99","paid_amount":"11.99","product_id":"1200","service_quantity":"1","product_name":"Sunglasses - 1 pair","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 20:45:26","reservation_modified_date_time":"2021-10-31 20:45:26","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","sub_hotel_id":"123","currentDayPrice":"11.21","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5329237","reservation_id":"123841","confirmation_number":"PB12232205425","room_confirmation_number":"PB12346485727","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-10-27 20:29:52","reservation_modified_date_time":"2021-10-27 20:29:52","customer_id":"117427","parentCustTravId":"117427","customer_traveller_id":"117427","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-10-31 15:00:42","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-10-27","sub_hotel_id":"123","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":"5329324","reservation_id":"122192","confirmation_number":"PB12292865205","room_confirmation_number":"PB12382363318","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":"30.00","paid_amount":"0.00","product_id":"2010","service_quantity":"3","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-28 14:21:08","reservation_modified_date_time":"2021-10-28 14:21:08","customer_id":"132875","parentCustTravId":"132875","customer_traveller_id":"132875","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-10-31 19:49:51","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-10-27","sub_hotel_id":"123","deltaChange":-28.05,"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":"5329988","reservation_id":"124895","confirmation_number":"PB12283794867","room_confirmation_number":"PB12393540966","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":"50.00","paid_amount":"0.00","product_id":"2010","service_quantity":"5","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-30 19:40:14","reservation_modified_date_time":"2021-10-30 19:40:14","customer_id":"133022","parentCustTravId":"133022","customer_traveller_id":"133022","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-10-31 12:39:32","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-10-30","sub_hotel_id":"123","deltaChange":-46.75,"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":9,"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":"5329974","reservation_id":"119735","confirmation_number":"BV12414204005","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"177.72,161.34","nightly_discount":"0,0","subtotal":"339.06","grand_total":"383.13","paid_amount":"383.13","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-2266062220","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":"133023","customer_id":"133023","source_of_creation":"Booking.com","reservation_created_date":"2021-07-20 19:26:11","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"68.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"161.34","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330227","reservation_id":"124939","confirmation_number":"BV12425444405","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"107.38","nightly_discount":"0","subtotal":"107.38","grand_total":"121.34","paid_amount":"121.34","room_type_id":"304","product_id":"1220","siteminder_id":"BDC-3267602597","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133070","customer_id":"133070","source_of_creation":"Booking.com","reservation_created_date":"2021-11-01 00:45:39","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"22.93","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"107.38","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":[{"room_stay_id":"5329642","reservation_id":"124853","confirmation_number":"BV12477609547","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"193.03,193.03,193.03","nightly_discount":"0.00,0.00,0.00","subtotal":"579.09","grand_total":"758.89","paid_amount":"758.89","room_type_id":"306","product_id":"1223","siteminder_id":"ABB-HMXHR8JAJQ","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"579.09","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132997","customer_id":"132997","source_of_creation":"Airbnb","reservation_created_date":"2021-10-28 18:30:29","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"84.28","commision_charges":"17.91","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"193.03","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"5329823","reservation_id":"124896","confirmation_number":"BV12456293045","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"91.83","nightly_discount":"0.00","subtotal":"91.83","grand_total":"103.77","paid_amount":"103.77","room_type_id":"304","product_id":"1218","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133004","customer_id":"133004","source_of_creation":"FE","reservation_created_date":"2021-10-30 05:02:47","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 715","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"91.83","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5330059","reservation_id":"118520","confirmation_number":"BV12445084744","room_stay_from":"2021-10-31","room_stay_to":"2021-11-08","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.60,132.00,132.00,132.00,132.00,152.00,152.00,132.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1135.60","grand_total":"1283.23","paid_amount":"1283.23","room_type_id":"304","product_id":"1219","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"36678","customer_id":"36678","source_of_creation":"PMS","reservation_created_date":"2021-07-02 14:09:27","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 716","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"171.60","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330207","reservation_id":"124936","confirmation_number":"BV12411971771","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"62.01","nightly_discount":"0.00","subtotal":"62.01","grand_total":"70.07","paid_amount":"70.07","room_type_id":"307","product_id":"1224","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133067","customer_id":"133067","source_of_creation":"PMS","reservation_created_date":"2021-10-31 23:10:32","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"62.01","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5329643","reservation_id":"124853","confirmation_number":"BV12262498845","room_confirmation_number":"BV12477609547","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"0.00,0.00,0.00","nightly_discount":"0.00,0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"132997","product_attribute_values":"resort_fee# ","reservation_created_date":"2021-10-28 18:30:29","reservation_modified_date_time":"2021-10-29 16:51:43","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132997","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","currentDayPrice":"0.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"0.00"}]},{"room_stay_id":"5329824","reservation_id":"124896","confirmation_number":"BV12253318458","room_confirmation_number":"BV12456293045","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"133004","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-30 05:02:47","reservation_modified_date_time":"2021-10-30 05:02:47","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133004","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5329973","reservation_id":"119735","confirmation_number":"BV12225683523","room_confirmation_number":"BV12414204005","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133023","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-07-20 19:26:11","reservation_modified_date_time":"2021-10-30 19:18:08","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133023","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5330060","reservation_id":"118520","confirmation_number":"BV12256644606","room_confirmation_number":"BV12445084744","room_stay_from":"2021-10-31","room_stay_to":"2021-11-08","room_stay_status":"Active","nightly_price":"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","subtotal":"96.00","grand_total":"108.48","paid_amount":"108.48","product_id":"1781","service_quantity":"1","customer_traveller_id":"36678","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-07-02 14:09:27","reservation_modified_date_time":"2021-10-31 01:03:15","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36678","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5330208","reservation_id":"124936","confirmation_number":"BV12287535858","room_confirmation_number":"BV12411971771","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"133067","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-31 23:10:32","reservation_modified_date_time":"2021-10-31 23:10:32","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133067","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","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":"5330226","reservation_id":"124939","confirmation_number":"BV12243246302","room_confirmation_number":"BV12425444405","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"133070","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-01 00:45:39","reservation_modified_date_time":"2021-11-01 00:49:50","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133070","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"124","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5330082","reservation_id":"124806","confirmation_number":"BV12220328950","room_confirmation_number":"BV12417477554","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"20.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1141","service_quantity":"2","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 13:00:12","reservation_modified_date_time":"2021-10-31 13:00:12","customer_id":"133017","parentCustTravId":"133017","customer_traveller_id":"133017","static_pos_type":"latecheckoutfee","product_is_timebound":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","product_attribute_values":null,"is_tip_product":"0","parentRoomStayFrom":"2021-10-30","sub_hotel_id":"124","currentDayPrice":"40.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]}],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":7,"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":"5330202","reservation_id":"124932","confirmation_number":"BP12537922514","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.74","nightly_discount":"0.00","subtotal":"75.74","grand_total":"85.58","paid_amount":"85.58","room_type_id":"296","product_id":"1131","siteminder_id":"BDC-2701963419","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124625","customer_id":"124625","source_of_creation":"Booking.com","reservation_created_date":"2021-10-31 20:47:08","canceled_nights_data":"","product_name":"BP Waterfront One Bedroom Suite 1Q, 1SS 809","ota_service_fee_amount":"0","commision_charges":"17.23","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","currentDayPrice":"75.74","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330246","reservation_id":"124941","confirmation_number":"BP12523649220","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"142.18","nightly_discount":"0.00","subtotal":"142.18","grand_total":"160.66","paid_amount":"160.66","room_type_id":"302","product_id":"1138","siteminder_id":"BDC-3267675657","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"20.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"133077","customer_id":"133077","source_of_creation":"Booking.com","reservation_created_date":"2021-11-01 00:46:47","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"29.19","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","currentDayPrice":"142.18","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5329816","reservation_id":"124337","confirmation_number":"BP12511194811","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.51,126.51,91.36","nightly_discount":"0,0,0","subtotal":"344.38","grand_total":"389.15","paid_amount":"389.15","room_type_id":"293","product_id":"1124","siteminder_id":"GAM-R2860815224","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":"132998","customer_id":"132998","source_of_creation":"Getaroom.com","reservation_created_date":"2021-10-10 10:23:11","canceled_nights_data":"","product_name":"BP Standard Room 2D 808","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"91.36","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330049","reservation_id":"124679","confirmation_number":"BP12534138218","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"126.51,84.05","nightly_discount":"0,0","subtotal":"210.56","grand_total":"237.93","paid_amount":"237.93","room_type_id":"298","product_id":"1133","siteminder_id":"GAM-R2888499489","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":"133037","customer_id":"133037","source_of_creation":"Getaroom.com","reservation_created_date":"2021-10-22 07:46:10","canceled_nights_data":"","product_name":"BP Standard Room 1Q 810","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":"125","group_rooms":null,"currentDayPrice":"84.05","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":"5329592","reservation_id":"124859","confirmation_number":"BP12564549722","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"84.03","nightly_discount":"0.00","subtotal":"84.03","grand_total":"94.95","paid_amount":"94.95","room_type_id":"299","product_id":"1134","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"132965","customer_id":"132965","source_of_creation":"PMS","reservation_created_date":"2021-10-28 21:55:23","canceled_nights_data":"","product_name":"BP Standard Room 1Q, 1SS 825","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"84.03","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5330102","reservation_id":"124923","confirmation_number":"BP12589665353","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"81.09","nightly_discount":"0.00","subtotal":"81.09","grand_total":"91.64","paid_amount":"91.64","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":"133026","customer_id":"133026","source_of_creation":"PMS","reservation_created_date":"2021-10-31 14:51:36","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":"","sub_hotel_id":"125","currentDayPrice":"81.09","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5330247","reservation_id":"124941","confirmation_number":"BP12243291052","room_confirmation_number":"BP12523649220","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"10.00","nightly_discount":"0.00","subtotal":"10.00","grand_total":"11.30","paid_amount":"11.30","product_id":"1780","service_quantity":"1","customer_traveller_id":"133077","product_attribute_values":"extra_person# ","reservation_created_date":"2021-11-01 02:22:37","reservation_modified_date_time":"2021-11-01 02:22:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133077","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"125","currentDayPrice":"10.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"5329591","reservation_id":"124859","confirmation_number":"BP12288522464","room_confirmation_number":"BP12564549722","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"132965","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-28 21:55:23","reservation_modified_date_time":"2021-10-29 15:13:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132965","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5329815","reservation_id":"124337","confirmation_number":"BP12277376144","room_confirmation_number":"BP12511194811","room_stay_from":"2021-10-29","room_stay_to":"2021-11-01","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":"132998","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-10 10:23:11","reservation_modified_date_time":"2021-10-30 03:09:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"132998","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5330048","reservation_id":"124679","confirmation_number":"BP12214132798","room_confirmation_number":"BP12534138218","room_stay_from":"2021-10-30","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20.00,20.00","nightly_discount":"0.00,0.00","subtotal":"40.00","grand_total":"45.20","paid_amount":"45.20","product_id":"1781","service_quantity":"1","customer_traveller_id":"133037","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-22 07:46:10","reservation_modified_date_time":"2021-10-30 23:56:52","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133037","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5330103","reservation_id":"124923","confirmation_number":"BP12238981291","room_confirmation_number":"BP12589665353","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"12.00","nightly_discount":"0.00","subtotal":"12.00","grand_total":"13.56","paid_amount":"13.56","product_id":"1781","service_quantity":"1","customer_traveller_id":"133026","product_attribute_values":"resort_fee#&#flat_rate# ","reservation_created_date":"2021-10-31 14:51:36","reservation_modified_date_time":"2021-10-31 14:51:36","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133026","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","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":"5330201","reservation_id":"124932","confirmation_number":"BP12259571297","room_confirmation_number":"BP12537922514","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"124625","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-10-31 20:47:08","reservation_modified_date_time":"2021-10-31 21:16:54","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124625","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"125","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":"5330248","reservation_id":"124941","confirmation_number":"BP12280496892","room_confirmation_number":"BP12523649220","room_stay_from":"2021-10-31","room_stay_to":"2021-11-01","room_stay_status":"Active","nightly_price":"20","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"133077","product_attribute_values":"resort_fee#&#flat_rate#","reservation_created_date":"2021-11-01 00:46:47","reservation_modified_date_time":"2021-11-01 02:22:45","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"133077","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.00","sub_hotel_id":"125","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"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5330088","reservation_id":"124922","confirmation_number":"BP12263368271","room_confirmation_number":"BP12558043110","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":"101.70","paid_amount":"0.00","product_id":"2109","service_quantity":"2","product_name":"Boat Slip Docking","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 14:06:22","reservation_modified_date_time":"2021-10-31 14:06:22","customer_id":"133047","parentCustTravId":"133047","customer_traveller_id":"133047","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-11-02","sub_hotel_id":"125","currentDayPrice":"90.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330089","reservation_id":"124922","confirmation_number":"BP12298319881","room_confirmation_number":"BP12558043110","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"25.00","grand_total":"56.50","paid_amount":"0.00","product_id":"2108","service_quantity":"2","product_name":"Boat Trailer","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 14:06:22","reservation_modified_date_time":"2021-10-31 14:06:22","customer_id":"133047","parentCustTravId":"133047","customer_traveller_id":"133047","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-11-02","sub_hotel_id":"125","currentDayPrice":"50.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330200","reservation_id":"124932","confirmation_number":"BP12238358692","room_confirmation_number":"BP12537922514","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"15.00","grand_total":"16.95","paid_amount":"16.95","product_id":"1212","service_quantity":"1","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 21:14:38","reservation_modified_date_time":"2021-10-31 21:16:54","customer_id":"124625","parentCustTravId":"124625","customer_traveller_id":"124625","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-10-31","sub_hotel_id":"125","currentDayPrice":"15.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330213","reservation_id":"124547","confirmation_number":"BP12224129015","room_confirmation_number":"BP12575788760","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"40.00","grand_total":"135.60","paid_amount":"0.00","product_id":"1212","service_quantity":"3","product_name":"Upgrade Room","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-31 23:54:14","reservation_modified_date_time":"2021-10-31 23:54:14","customer_id":"132534","parentCustTravId":"132534","customer_traveller_id":"132534","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-11-01","sub_hotel_id":"125","currentDayPrice":"120.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5330236","reservation_id":"124941","confirmation_number":"BP12287620374","room_confirmation_number":"BP12523649220","room_stay_from":"0000-00-00","room_stay_to":"0000-00-00","room_stay_status":"Active","nightly_price":"","nightly_discount":"","subtotal":"42.06","grand_total":"45.00","paid_amount":"45.00","product_id":"1156","service_quantity":"1","product_name":"Extra Car","parentTypeOfRes":"reservation","reservation_created_date":"2021-11-01 02:16:08","reservation_modified_date_time":"2021-11-01 02:16:08","customer_id":"133077","parentCustTravId":"133077","customer_traveller_id":"133077","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-10-31","sub_hotel_id":"125","currentDayPrice":"42.06","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"}]},{"room_stay_id":"5329977","reservation_id":"124886","confirmation_number":"BP12217368914","room_confirmation_number":"BP12548016582","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":"10.00","paid_amount":"0.00","product_id":"2010","service_quantity":"1","product_name":"10.00 Pool \/ Beach Towel","parentTypeOfRes":"reservation","reservation_created_date":"2021-10-30 19:20:05","reservation_modified_date_time":"2021-10-30 19:23:25","customer_id":"133024","parentCustTravId":"133024","customer_traveller_id":"133024","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-10-31 14:38:01","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-10-30","sub_hotel_id":"125","deltaChange":-9.35,"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":[]}}}