{"hotel_id":"122","sub_hotel_id":0,"room_type":"hotel","date":"2021-09-20","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":24,"holdBlockRooms":{"hold_room_count":"","hold_room_bookings":[],"block_room_count":"1106","block_room_bookings":[{"confirmation_number":"PB12225124166","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","bundle_room":"0","product_id":"1106"}],"bundle_block_count":"","bundle_block_bookings":[]},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3295250","reservation_id":"120230","confirmation_number":"BP12529517840","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.61,168.21,168.21,155.61,155.61","nightly_discount":"0,0,0,0,0","subtotal":"803.25","grand_total":"907.68","paid_amount":"907.68","room_type_id":"302","product_id":"1138","siteminder_id":"BDC-2647541310","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":"127495","customer_id":"127495","source_of_creation":"Booking.com","reservation_created_date":"2021-07-27 23:48:08","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"162.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"155.61","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5314756","reservation_id":"120233","confirmation_number":"BV12431442855","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"124.78,135.31,135.31,124.78,124.78","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"644.96","grand_total":"728.81","paid_amount":"728.81","room_type_id":"305","product_id":"1222","siteminder_id":"BDC-2720018353","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122153","customer_id":"122153","source_of_creation":"Booking.com","reservation_created_date":"2021-07-28 00:37:23","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"380.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"124.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5314759","reservation_id":"120233","confirmation_number":"BV12480665875","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"83.72,94.25,94.25,83.72,83.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"439.66","grand_total":"496.82","paid_amount":"496.82","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-2720018353","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122153","customer_id":"122153","source_of_creation":"Booking.com","reservation_created_date":"2021-07-28 00:37:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"380.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"83.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315241","reservation_id":"117417","confirmation_number":"PB12390736200","room_stay_from":"2021-09-18","room_stay_to":"2021-09-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"99.81,88.12,88.12,88.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"364.17","grand_total":"411.51","paid_amount":"411.51","room_type_id":"289","product_id":"1100","siteminder_id":"BDC-2305901244","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"160.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130953","customer_id":"130953","source_of_creation":"Booking.com","reservation_created_date":"2021-06-16 16:49:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"181.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"88.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315443","reservation_id":"120233","confirmation_number":"BV12410380411","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"91.62,102.15,102.15,91.62,91.62","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"479.16","grand_total":"541.45","paid_amount":"541.45","room_type_id":"303","product_id":"1140","siteminder_id":"BDC-2720018353","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122153","customer_id":"122153","source_of_creation":"Booking.com","reservation_created_date":"2021-07-28 00:37:18","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"380.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"91.62","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315633","reservation_id":"118847","confirmation_number":"PB12385687621","room_stay_from":"2021-09-19","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.97,137.97,137.97,137.97,137.97","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"689.85","grand_total":"779.53","paid_amount":"779.53","room_type_id":"289","product_id":"1123","siteminder_id":"BDC-2448117502","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":"56581","customer_id":"56581","source_of_creation":"Booking.com","reservation_created_date":"2021-07-07 13:56:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"137.97","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315891","reservation_id":"123339","confirmation_number":"PB12360216037","room_stay_from":"2021-09-20","room_stay_to":"2021-09-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"104.49,104.49","nightly_discount":"0,0","subtotal":"208.98","grand_total":"236.15","paid_amount":"236.15","room_type_id":"289","product_id":"1101","siteminder_id":"BDC-3242430469","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":"131078","customer_id":"131078","source_of_creation":"Booking.com","reservation_created_date":"2021-09-20 06:24:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"40.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"104.49","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315962","reservation_id":"123297","confirmation_number":"PB12397134844","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.14","nightly_discount":"0","subtotal":"106.14","grand_total":"119.94","paid_amount":"119.94","room_type_id":"289","product_id":"1111","siteminder_id":"BDC-3666488326","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":"131085","customer_id":"131085","source_of_creation":"Booking.com","reservation_created_date":"2021-09-19 15:39:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"18.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"106.14","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":"5316008","reservation_id":"117417","confirmation_number":"PB12398677582","room_stay_from":"2021-09-18","room_stay_to":"2021-09-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.81,118.12,118.12,118.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"484.17","grand_total":"547.11","paid_amount":"547.11","room_type_id":"289","product_id":"1103","siteminder_id":"BDC-2305901244","collect_which":"hotel_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":"130953","customer_id":"130953","source_of_creation":"Booking.com","reservation_created_date":"2021-06-16 16:49:15","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"181.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"118.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5313535","reservation_id":"119303","confirmation_number":"BP12565987447","room_stay_from":"2021-09-15","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.60,70.60,79.48,79.48,70.60,70.60","nightly_discount":"0,0,0,0,0,0","subtotal":"441.36","grand_total":"498.74","paid_amount":"498.74","room_type_id":"298","product_id":"1133","siteminder_id":"EXP-1800762448","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":"130764","customer_id":"130764","source_of_creation":"Expedia","reservation_created_date":"2021-07-14 13:20:12","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":"70.60","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":"5315521","reservation_id":"118251","confirmation_number":"PB12385192112","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.30,153.30","nightly_discount":"0,0","subtotal":"306.60","grand_total":"346.46","paid_amount":"346.46","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1792574586","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":"131038","customer_id":"131038","source_of_creation":"Expedia","reservation_created_date":"2021-06-28 18:10:12","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":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"153.30","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":"5316022","reservation_id":"123374","confirmation_number":"BV12442732287","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.49","nightly_discount":"0","subtotal":"77.49","grand_total":"87.56","paid_amount":"87.56","room_type_id":"304","product_id":"1219","siteminder_id":"EXP-1832602334","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":"131094","customer_id":"131094","source_of_creation":"Expedia","reservation_created_date":"2021-09-20 21:19:10","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":null,"sub_hotel_id":"124","currentDayPrice":"77.49","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5316032","reservation_id":"123373","confirmation_number":"BV12412229714","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"71.53","nightly_discount":"0","subtotal":"71.53","grand_total":"80.83","paid_amount":"80.83","room_type_id":"304","product_id":"1220","siteminder_id":"EXP-1832592764","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":"131097","customer_id":"131097","source_of_creation":"Expedia","reservation_created_date":"2021-09-20 20:59:11","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"71.53","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"5316128","reservation_id":"123369","confirmation_number":"BP12557263795","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.24","nightly_discount":"0","subtotal":"67.24","grand_total":"75.98","paid_amount":"75.98","room_type_id":"294","product_id":"1126","siteminder_id":"HTN-174235573-DXP2TR","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":"131118","customer_id":"131118","source_of_creation":"HotelTonight","reservation_created_date":"2021-09-20 19:46:11","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 806","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","currentDayPrice":"67.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5315404","reservation_id":"123286","confirmation_number":"BP12579486578","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"72.83,72.83","nightly_discount":"0.00,0.00","subtotal":"145.66","grand_total":"164.60","paid_amount":"164.60","room_type_id":"289","product_id":"1096","siteminder_id":"GAM-R2815182944","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":"131022","customer_id":"131022","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-19 13:09:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"72.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":"5315552","reservation_id":"122384","confirmation_number":"BP12547579842","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.14,75.14","nightly_discount":"0,0","subtotal":"150.28","grand_total":"169.82","paid_amount":"169.82","room_type_id":"295","product_id":"1128","siteminder_id":"GAM-R2777112560","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":"131042","customer_id":"131042","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-02 01:40:13","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"75.14","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":"5315772","reservation_id":"123344","confirmation_number":"PB12343820497","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.75","nightly_discount":"0","subtotal":"94.75","grand_total":"107.07","paid_amount":"107.07","room_type_id":"289","product_id":"1102","siteminder_id":"GAM-R2817365459","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":"130912","customer_id":"130912","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-20 14:39:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"94.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315814","reservation_id":"123172","confirmation_number":"BP12584443438","room_stay_from":"2021-09-20","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.03,67.03,67.03,67.03","nightly_discount":"0,0,0,0","subtotal":"268.12","grand_total":"302.98","paid_amount":"302.98","room_type_id":"293","product_id":"1124","siteminder_id":"GAM-R2810263355","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":"131069","customer_id":"131069","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-16 23:13:09","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","currentDayPrice":"67.03","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315989","reservation_id":"123065","confirmation_number":"BP12576215830","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.35","nightly_discount":"0","subtotal":"87.35","grand_total":"98.70","paid_amount":"98.70","room_type_id":"299","product_id":"1134","siteminder_id":"GAM-R2806024323","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":"130744","customer_id":"130744","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-15 03:34:08","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":null,"sub_hotel_id":"125","currentDayPrice":"87.35","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":"5315999","reservation_id":"123367","confirmation_number":"BP12530293501","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.10","nightly_discount":"0","subtotal":"64.10","grand_total":"72.44","paid_amount":"72.44","room_type_id":"294","product_id":"1125","siteminder_id":"GAM-R2818148427","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":"131088","customer_id":"131088","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-20 19:41:09","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":null,"sub_hotel_id":"125","currentDayPrice":"64.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":"5316108","reservation_id":"123387","confirmation_number":"BV12473178746","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"72.18","nightly_discount":"0","subtotal":"72.18","grand_total":"81.56","paid_amount":"81.56","room_type_id":"308","product_id":"1225","siteminder_id":"GAM-R2818940589","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":"131111","customer_id":"131111","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-21 01:00:14","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"72.18","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"5315102","reservation_id":"123285","confirmation_number":"BV12494680867","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.60","nightly_discount":"0","subtotal":"77.60","grand_total":"101.25","paid_amount":"101.25","room_type_id":"307","product_id":"1224","siteminder_id":"ABB-HMJBHEXDRX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"77.60","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131005","customer_id":"131005","source_of_creation":"Airbnb","reservation_created_date":"2021-09-19 12:54:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"10.85","commision_charges":"2.40","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"77.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[{"room_stay_id":"3282169","reservation_id":"119133","confirmation_number":"BP12533335440","room_stay_from":"2021-09-14","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.00,93.00,93.00,113.00,113.00,93.00,93.00,93.00,93.00,93.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"970.00","grand_total":"1096.10","paid_amount":"1096.10","room_type_id":"295","product_id":"1129","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":"126251","customer_id":"126251","source_of_creation":"FE","reservation_created_date":"2021-07-11 18:56:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","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":"93.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5313146","reservation_id":"115863","confirmation_number":"PB12360453945","room_stay_from":"2021-09-14","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,120.00,120.00,140.00,140.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,42.23","subtotal":"880.00","grand_total":"946.68","paid_amount":"946.68","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":"54747","customer_id":"54747","source_of_creation":"FE","reservation_created_date":"2021-05-25 17:15:43","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":"120.00","currentDayDiscount":"42.23","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315228","reservation_id":"117506","confirmation_number":"PB12348741017","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00,130.00,150.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"800.00","grand_total":"904.00","paid_amount":"904.00","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":"124468","customer_id":"124468","source_of_creation":"FE","reservation_created_date":"2021-06-17 21:17:03","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":"130.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5312986","reservation_id":"119501","confirmation_number":"PB12361050085","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,169.00,169.00,149.00,149.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"785.00","grand_total":"887.05","paid_amount":"887.05","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126655","customer_id":"126655","source_of_creation":"PMS","reservation_created_date":"2021-07-17 15:18:40","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"149.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5314099","reservation_id":"84692","confirmation_number":"PB12350144146","room_stay_from":"2021-09-16","room_stay_to":"2021-09-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.00,124.00,124.00,124.00,124.00,124.00,124.00,124.00,124.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,55.00","subtotal":"1116.00","grand_total":"1198.93","paid_amount":"1198.93","room_type_id":"289","product_id":"1098","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"31302","customer_id":"31302","source_of_creation":"PMS","reservation_created_date":"2019-09-25 19:26:52","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"124.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5314492","reservation_id":"117963","confirmation_number":"PB12384633035","room_stay_from":"2021-09-17","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,120.00,120.00,120.00,120.00,120.00,140.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,56.40","subtotal":"1160.00","grand_total":"1247.07","paid_amount":"1247.07","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":"36411","customer_id":"36411","source_of_creation":"PMS","reservation_created_date":"2021-06-24 12:27:06","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","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":"5314494","reservation_id":"117963","confirmation_number":"PB12351323223","room_stay_from":"2021-09-17","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,120.00,120.00,120.00,120.00,120.00,140.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,56.40","subtotal":"1160.00","grand_total":"1247.07","paid_amount":"1247.07","room_type_id":"289","product_id":"1109","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"36411","customer_id":"36411","source_of_creation":"PMS","reservation_created_date":"2021-06-24 12:27:06","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","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":"5314545","reservation_id":"119514","confirmation_number":"PB12373721075","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"158.00,158.00,138.00,138.00,138.00,138.00,138.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,46.60","subtotal":"1006.00","grand_total":"1084.12","paid_amount":"1084.12","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"56188","customer_id":"56188","source_of_creation":"PMS","reservation_created_date":"2021-07-17 16:53:51","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"138.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5314569","reservation_id":"100532","confirmation_number":"PB12363274350","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"140.00,140.00,120.00,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,48.19","subtotal":"880.00","grand_total":"939.95","paid_amount":"939.95","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"36512","customer_id":"36512","source_of_creation":"PMS","reservation_created_date":"2020-09-18 15:16:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"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":"5314847","reservation_id":"118362","confirmation_number":"PB12375888661","room_stay_from":"2021-09-20","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,149.00,149.00,169.00,169.00,149.00,149.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1133.00","grand_total":"1280.29","paid_amount":"1280.29","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":"125379","customer_id":"125379","source_of_creation":"PMS","reservation_created_date":"2021-06-30 00:08:23","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":"199.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315158","reservation_id":"100534","confirmation_number":"PB12324170496","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"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,61.59","subtotal":"1342.00","grand_total":"1446.86","paid_amount":"1446.86","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90237","customer_id":"90237","source_of_creation":"PMS","reservation_created_date":"2020-09-18 15:20:34","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":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"186.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315257","reservation_id":"123296","confirmation_number":"PB12368455723","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.09,129.09","nightly_discount":"0.00,0.00","subtotal":"251.18","grand_total":"283.83","paid_amount":"283.83","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":"131013","customer_id":"131013","source_of_creation":"PMS","reservation_created_date":"2021-09-19 15:37:24","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":"129.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":"5315421","reservation_id":"100931","confirmation_number":"PB12383993339","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"25.85,0.00,0.00,0.00,0.00,0.00","subtotal":"534.00","grand_total":"574.21","paid_amount":"574.21","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":"27863","customer_id":"27863","source_of_creation":"PMS","reservation_created_date":"2020-09-28 18:41:16","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":null,"sub_hotel_id":"123","group_rooms":null,"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":"5315427","reservation_id":"100926","confirmation_number":"PB12330901468","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,25.85","subtotal":"534.00","grand_total":"574.21","paid_amount":"574.21","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"27794","customer_id":"27794","source_of_creation":"PMS","reservation_created_date":"2020-09-28 17:41:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"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":"5315438","reservation_id":"100929","confirmation_number":"PB12335422408","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"25.85,0.00,0.00,0.00,0.00,0.00","subtotal":"534.00","grand_total":"574.21","paid_amount":"574.21","room_type_id":"289","product_id":"1110","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":"27824","customer_id":"27824","source_of_creation":"PMS","reservation_created_date":"2020-09-28 18:22:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","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":"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":"5315469","reservation_id":"114440","confirmation_number":"PB12389734431","room_stay_from":"2021-09-19","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,120.00,120.00,120.00,120.00,140.00,140.00","nightly_discount":"0.00,42.23,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"946.68","paid_amount":"946.68","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":"48470","customer_id":"48470","source_of_creation":"PMS","reservation_created_date":"2021-05-03 19:59:52","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","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"42.23","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315673","reservation_id":"116878","confirmation_number":"PB12345538933","room_stay_from":"2021-09-19","room_stay_to":"2021-09-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.00,186.00,186.00,186.00,186.00,206.00,206.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.00,0.00,101.60","subtotal":"2086.00","grand_total":"2242.37","paid_amount":"2242.37","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":"44420","customer_id":"44420","source_of_creation":"PMS","reservation_created_date":"2021-06-09 15:19:44","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":"186.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315716","reservation_id":"123300","confirmation_number":"PB12352553469","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.00,82.00","nightly_discount":"0.00,0","subtotal":"164.00","grand_total":"185.32","paid_amount":"185.32","room_type_id":"286","product_id":"1086","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":"131016","customer_id":"131016","source_of_creation":"PMS","reservation_created_date":"2021-09-19 16:05:48","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"82.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315811","reservation_id":"100928","confirmation_number":"PB12323878464","room_stay_from":"2021-09-20","room_stay_to":"2021-09-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,20.08,0.00,0.00,0.00","subtotal":"445.00","grand_total":"480.16","paid_amount":"480.16","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":"87885","customer_id":"87885","source_of_creation":"PMS","reservation_created_date":"2020-09-28 18:03:01","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","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":"5315942","reservation_id":"123360","confirmation_number":"PB12362519918","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.76","nightly_discount":"0.00","subtotal":"118.76","grand_total":"134.20","paid_amount":"134.20","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":"131082","customer_id":"131082","source_of_creation":"PMS","reservation_created_date":"2021-09-20 18:16:24","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":"118.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315945","reservation_id":"110292","confirmation_number":"PB12315212631","room_stay_from":"2021-09-20","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.00,201.00,201.00,201.00","nightly_discount":"0.00,32.55,0.00,0.00","subtotal":"804.00","grand_total":"871.74","paid_amount":"871.74","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":"116811","customer_id":"116811","source_of_creation":"PMS","reservation_created_date":"2021-03-14 19:06:46","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","currentDayPrice":"201.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5316024","reservation_id":"123375","confirmation_number":"PB12337941357","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.76","nightly_discount":"0.00","subtotal":"118.76","grand_total":"134.20","paid_amount":"134.20","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":"131095","customer_id":"131095","source_of_creation":"PMS","reservation_created_date":"2021-09-20 21:32:49","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","currentDayPrice":"118.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5316038","reservation_id":"123378","confirmation_number":"PB12367910727","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.76","nightly_discount":"6.86","subtotal":"118.76","grand_total":"126.44","paid_amount":"126.44","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":"131098","customer_id":"131098","source_of_creation":"PMS","reservation_created_date":"2021-09-20 22:28:08","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":"118.76","currentDayDiscount":"6.86","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5316054","reservation_id":"120122","confirmation_number":"BV12449503417","room_stay_from":"2021-09-20","room_stay_to":"2021-09-24","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","nightly_discount":"0.00,0.00,0.00,39.41","subtotal":"572.00","grand_total":"601.83","paid_amount":"601.83","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"127375","customer_id":"127375","source_of_creation":"PMS","reservation_created_date":"2021-07-26 18:39:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","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":"5316066","reservation_id":"123342","confirmation_number":"BV12491680992","room_stay_from":"2021-09-20","room_stay_to":"2021-09-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.53,128.07","nightly_discount":"0.00,0.00","subtotal":"273.60","grand_total":"309.17","paid_amount":"309.17","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124276","customer_id":"124276","source_of_creation":"PMS","reservation_created_date":"2021-09-20 13:14:38","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"145.53","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5316118","reservation_id":"123393","confirmation_number":"BV12421451063","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"85.00","nightly_discount":"0.00","subtotal":"85.00","grand_total":"96.05","paid_amount":"96.05","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131115","customer_id":"131115","source_of_creation":"PMS","reservation_created_date":"2021-09-21 02:02:57","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"85.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315893","reservation_id":"121832","confirmation_number":"BV12458356001","room_stay_from":"2021-10-28","room_stay_to":"2021-10-31","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"143.00,163.00,163.00","nightly_discount":"0.00,0.00,0.00","subtotal":"469.00","grand_total":"529.97","paid_amount":"161.59","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"72194","customer_id":"72194","source_of_creation":"PMS","reservation_created_date":"2021-08-24 12:52:34","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315910","reservation_id":"92374","confirmation_number":"PB12379734466","room_stay_from":"2022-02-22","room_stay_to":"2022-03-03","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.00,171.00,171.00,171.00,171.00,171.00,171.00,171.00,171.00","nightly_discount":"0.00,0.00,0.00,0,0,0,0,0,0","subtotal":"1539.00","grand_total":"1739.07","paid_amount":"200.00","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":"23575","customer_id":"23575","source_of_creation":"PMS","reservation_created_date":"2020-02-22 19:22:53","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","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[{"room_stay_id":"3140301","reservation_id":"84126","confirmation_number":"PB12318376756","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"534.00","grand_total":"603.42","paid_amount":"100.00","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"32420","customer_id":"32420","source_of_creation":"PMS","reservation_created_date":"2019-09-15 14:02:46","service_canceled_date_time":"2021-09-21 00:51:38","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"room_dates_changed","total_paid_amount":"100.00","sub_hotel_id":"123","deltaChange":-0.5,"changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3137756","reservation_id":"100532","confirmation_number":"PB12247700804","room_confirmation_number":"PB12363274350","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","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":"36512","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-09-18 15:16:28","reservation_modified_date_time":"2020-09-18 15:16:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36512","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":"5314357","reservation_id":"120233","confirmation_number":"BV12269898204","room_confirmation_number":"BV12410380411","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"122153","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-07-29 17:53:11","reservation_modified_date_time":"2021-09-17 15:12:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"5314360","reservation_id":"120233","confirmation_number":"BV12260710378","room_confirmation_number":"BV12431442855","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"122153","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-07-29 17:53:14","reservation_modified_date_time":"2021-09-17 15:12:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"124","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":"5314363","reservation_id":"120233","confirmation_number":"BV12225355049","room_confirmation_number":"BV12480665875","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"122153","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-07-29 17:53:08","reservation_modified_date_time":"2021-09-17 15:12:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"5314706","reservation_id":"117417","confirmation_number":"PB12284348670","room_confirmation_number":"PB12390736200","room_stay_from":"2021-09-18","room_stay_to":"2021-09-22","room_stay_status":"Active","nightly_price":"40,40,40,40","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"130953","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-06-16 18:04:10","reservation_modified_date_time":"2021-09-18 14:25:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130953","canceled_nights_data":"","posAmt_airbnb_taxpaid":"160.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":"5315754","reservation_id":"123325","confirmation_number":"BV12295469244","room_confirmation_number":"BV12492503228","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"131047","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-09-19 22:52:37","reservation_modified_date_time":"2021-09-19 22:52:53","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131047","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":"5315889","reservation_id":"123339","confirmation_number":"PB12276210849","room_confirmation_number":"PB12360216037","room_stay_from":"2021-09-20","room_stay_to":"2021-09-22","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"131078","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-09-20 06:24:13","reservation_modified_date_time":"2021-09-20 17:37:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131078","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.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":"3282170","reservation_id":"119133","confirmation_number":"BP12216067559","room_confirmation_number":"BP12533335440","room_stay_from":"2021-09-14","room_stay_to":"2021-09-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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":"126251","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-11 18:56:11","reservation_modified_date_time":"2021-07-11 18:56:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126251","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":"3295251","reservation_id":"120230","confirmation_number":"BP12240526015","room_confirmation_number":"BP12529517840","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"127495","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-27 23:48:08","reservation_modified_date_time":"2021-08-02 21:30:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127495","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.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"}]},{"room_stay_id":"5312987","reservation_id":"119501","confirmation_number":"PB12255087664","room_confirmation_number":"PB12361050085","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","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":"126655","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-17 15:18:40","reservation_modified_date_time":"2021-09-14 13:53:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126655","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":"5313147","reservation_id":"115863","confirmation_number":"PB12247535593","room_confirmation_number":"PB12360453945","room_stay_from":"2021-09-14","room_stay_to":"2021-09-21","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":"54747","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-05-25 17:15:43","reservation_modified_date_time":"2021-09-14 16:24:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"54747","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":"5313534","reservation_id":"119303","confirmation_number":"BP12224041060","room_confirmation_number":"BP12565987447","room_stay_from":"2021-09-15","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"130764","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-14 13:20:12","reservation_modified_date_time":"2021-09-15 15:48:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130764","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":"5314100","reservation_id":"84692","confirmation_number":"PB12261220297","room_confirmation_number":"PB12350144146","room_stay_from":"2021-09-16","room_stay_to":"2021-09-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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":"31302","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-25 19:26:52","reservation_modified_date_time":"2021-09-16 19:04:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"31302","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":"5314493","reservation_id":"117963","confirmation_number":"PB12258573344","room_confirmation_number":"PB12384633035","room_stay_from":"2021-09-17","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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":"36411","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-06-24 12:27:06","reservation_modified_date_time":"2021-09-17 21:04:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36411","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":"5314495","reservation_id":"117963","confirmation_number":"PB12285032856","room_confirmation_number":"PB12351323223","room_stay_from":"2021-09-17","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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":"36411","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-06-24 12:27:06","reservation_modified_date_time":"2021-09-17 21:04:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36411","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":"5314546","reservation_id":"119514","confirmation_number":"PB12251536820","room_confirmation_number":"PB12373721075","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","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":"56188","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-17 16:53:51","reservation_modified_date_time":"2021-09-17 22:56:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56188","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":"5314570","reservation_id":"100532","confirmation_number":"PB12254007719","room_confirmation_number":"PB12363274350","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","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":"36512","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-18 15:16:28","reservation_modified_date_time":"2021-09-17 23:53:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36512","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":"5314758","reservation_id":"120233","confirmation_number":"BV12272814686","room_confirmation_number":"BV12431442855","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"62.98","product_id":"1781","service_quantity":"1","customer_traveller_id":"127499","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-28 00:37:23","reservation_modified_date_time":"2021-09-18 15:03:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"5314761","reservation_id":"120233","confirmation_number":"BV12212394206","room_confirmation_number":"BV12480665875","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"62.98","product_id":"1781","service_quantity":"1","customer_traveller_id":"122153","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-28 00:37:12","reservation_modified_date_time":"2021-09-18 15:03:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"5314848","reservation_id":"118362","confirmation_number":"PB12250242386","room_confirmation_number":"PB12375888661","room_stay_from":"2021-09-20","room_stay_to":"2021-09-27","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":"125379","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-06-30 00:08:23","reservation_modified_date_time":"2021-09-18 17:30:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125379","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":"5315103","reservation_id":"123285","confirmation_number":"BV12230886404","room_confirmation_number":"BV12494680867","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131005","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-19 12:54:12","reservation_modified_date_time":"2021-09-19 12:54:12","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131005","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","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":"5315160","reservation_id":"100534","confirmation_number":"PB12238639092","room_confirmation_number":"PB12324170496","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","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":"74.91","product_id":"1781","service_quantity":"1","customer_traveller_id":"90237","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-18 15:20:34","reservation_modified_date_time":"2021-09-19 14:27:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90237","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":"5315229","reservation_id":"117506","confirmation_number":"PB12275115826","room_confirmation_number":"PB12348741017","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"124468","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-06-17 21:17:04","reservation_modified_date_time":"2021-09-19 15:17:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124468","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":"5315243","reservation_id":"117417","confirmation_number":"PB12270188218","room_confirmation_number":"PB12390736200","room_stay_from":"2021-09-18","room_stay_to":"2021-09-22","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"130953","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-06-16 16:49:10","reservation_modified_date_time":"2021-09-19 15:26:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130953","canceled_nights_data":"","posAmt_airbnb_taxpaid":"160.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":"5315258","reservation_id":"123296","confirmation_number":"PB12296037336","room_confirmation_number":"PB12368455723","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","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":"131013","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-19 15:37:24","reservation_modified_date_time":"2021-09-19 15:41:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131013","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":"5315406","reservation_id":"123286","confirmation_number":"BP12298394478","room_confirmation_number":"BP12579486578","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","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":"131022","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-19 13:09:11","reservation_modified_date_time":"2021-09-19 17:00:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131022","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":"5315422","reservation_id":"100931","confirmation_number":"PB12277670217","room_confirmation_number":"PB12383993339","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"27863","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-28 18:41:16","reservation_modified_date_time":"2021-09-19 17:24:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27863","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":"5315428","reservation_id":"100926","confirmation_number":"PB12263019778","room_confirmation_number":"PB12330901468","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"27794","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-28 17:41:21","reservation_modified_date_time":"2021-09-19 17:28:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27794","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":"5315439","reservation_id":"100929","confirmation_number":"PB12255773683","room_confirmation_number":"PB12335422408","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"27824","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-28 18:22:09","reservation_modified_date_time":"2021-09-19 17:38:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27824","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":"5315445","reservation_id":"120233","confirmation_number":"BV12236518209","room_confirmation_number":"BV12410380411","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"127499","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-28 00:37:18","reservation_modified_date_time":"2021-09-19 17:40:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"5315470","reservation_id":"114440","confirmation_number":"PB12277826531","room_confirmation_number":"PB12389734431","room_stay_from":"2021-09-19","room_stay_to":"2021-09-26","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":"48470","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-05-03 19:59:52","reservation_modified_date_time":"2021-09-19 18:09:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"48470","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":"5315520","reservation_id":"118251","confirmation_number":"PB12278633110","room_confirmation_number":"PB12385192112","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","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":"131038","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-06-28 18:10:12","reservation_modified_date_time":"2021-09-19 20:36:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131038","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":"5315551","reservation_id":"122384","confirmation_number":"BP12241418921","room_confirmation_number":"BP12547579842","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","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":"131042","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-02 01:40:13","reservation_modified_date_time":"2021-09-19 21:28:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131042","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":"5315635","reservation_id":"118847","confirmation_number":"PB12246516698","room_confirmation_number":"PB12385687621","room_stay_from":"2021-09-19","room_stay_to":"2021-09-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"72.98","product_id":"1781","service_quantity":"1","customer_traveller_id":"56581","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-07 13:56:37","reservation_modified_date_time":"2021-09-19 23:52:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56581","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":"5315674","reservation_id":"116878","confirmation_number":"PB12288967794","room_confirmation_number":"PB12345538933","room_stay_from":"2021-09-19","room_stay_to":"2021-09-30","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":"44420","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-06-09 15:19:44","reservation_modified_date_time":"2021-09-20 01:00:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44420","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":"5315717","reservation_id":"123300","confirmation_number":"PB12236283709","room_confirmation_number":"PB12352553469","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","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":"131016","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-19 16:05:48","reservation_modified_date_time":"2021-09-20 12:47:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131016","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":"5315773","reservation_id":"123344","confirmation_number":"PB12275326890","room_confirmation_number":"PB12343820497","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"130912","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-20 14:39:12","reservation_modified_date_time":"2021-09-20 14:57:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130912","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":"5315812","reservation_id":"100928","confirmation_number":"PB12265063460","room_confirmation_number":"PB12323878464","room_stay_from":"2021-09-20","room_stay_to":"2021-09-25","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":"87885","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-28 18:03:01","reservation_modified_date_time":"2021-09-20 15:48:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87885","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":"5315813","reservation_id":"123172","confirmation_number":"BP12229319067","room_confirmation_number":"BP12584443438","room_stay_from":"2021-09-20","room_stay_to":"2021-09-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"131069","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-16 23:13:09","reservation_modified_date_time":"2021-09-20 15:54:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131069","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":"5315890","reservation_id":"123339","confirmation_number":"PB12237655522","room_confirmation_number":"PB12360216037","room_stay_from":"2021-09-20","room_stay_to":"2021-09-22","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":"131078","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-20 06:24:13","reservation_modified_date_time":"2021-09-20 17:37:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131078","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.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":"5315943","reservation_id":"123360","confirmation_number":"PB12221462269","room_confirmation_number":"PB12362519918","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131082","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-20 18:16:24","reservation_modified_date_time":"2021-09-20 18:16:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131082","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":"5315944","reservation_id":"110292","confirmation_number":"PB12218471731","room_confirmation_number":"PB12315212631","room_stay_from":"2021-09-20","room_stay_to":"2021-09-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"116811","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-03-14 19:06:46","reservation_modified_date_time":"2021-09-20 18:24:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116811","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":"5315961","reservation_id":"123297","confirmation_number":"PB12296042476","room_confirmation_number":"PB12397134844","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131085","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-19 15:39:11","reservation_modified_date_time":"2021-09-20 18:33:01","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131085","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":"5315988","reservation_id":"123065","confirmation_number":"BP12251177104","room_confirmation_number":"BP12576215830","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"130744","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-15 03:34:08","reservation_modified_date_time":"2021-09-20 19:47:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130744","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":"5315998","reservation_id":"123367","confirmation_number":"BP12292646674","room_confirmation_number":"BP12530293501","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"131088","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-20 19:41:09","reservation_modified_date_time":"2021-09-20 20:09:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131088","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":"5316010","reservation_id":"117417","confirmation_number":"PB12269731888","room_confirmation_number":"PB12398677582","room_stay_from":"2021-09-18","room_stay_to":"2021-09-22","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"130953","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-06-16 16:49:15","reservation_modified_date_time":"2021-09-20 20:32:52","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130953","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":"5316023","reservation_id":"123374","confirmation_number":"BV12212680303","room_confirmation_number":"BV12442732287","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131094","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-20 21:19:10","reservation_modified_date_time":"2021-09-20 21:19:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131094","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":"5316025","reservation_id":"123375","confirmation_number":"PB12233638246","room_confirmation_number":"PB12337941357","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131095","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-20 21:32:49","reservation_modified_date_time":"2021-09-20 21:32:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131095","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":"5316031","reservation_id":"123373","confirmation_number":"BV12242874681","room_confirmation_number":"BV12412229714","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131097","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-20 20:59:11","reservation_modified_date_time":"2021-09-20 22:11:45","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131097","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":"5316039","reservation_id":"123378","confirmation_number":"PB12230282542","room_confirmation_number":"PB12367910727","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131098","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-20 22:28:08","reservation_modified_date_time":"2021-09-20 22:29:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131098","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":"5316055","reservation_id":"120122","confirmation_number":"BV12251264626","room_confirmation_number":"BV12449503417","room_stay_from":"2021-09-20","room_stay_to":"2021-09-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"127375","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-26 18:39:12","reservation_modified_date_time":"2021-09-20 23:41:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127375","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":"5316063","reservation_id":"123325","confirmation_number":"BV12234858004","room_confirmation_number":"BV12492503228","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,12.00","nightly_discount":"0.00,0.00","subtotal":"32.00","grand_total":"36.16","paid_amount":"36.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"131047","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-19 21:31:11","reservation_modified_date_time":"2021-09-20 23:55:58","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131047","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","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":"5316067","reservation_id":"123342","confirmation_number":"BV12244727401","room_confirmation_number":"BV12491680992","room_stay_from":"2021-09-20","room_stay_to":"2021-09-22","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":"124276","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-20 13:14:38","reservation_modified_date_time":"2021-09-21 00:11:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124276","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":"5316107","reservation_id":"123387","confirmation_number":"BV12281186369","room_confirmation_number":"BV12473178746","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131111","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-21 01:00:14","reservation_modified_date_time":"2021-09-21 01:33:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131111","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":"5316119","reservation_id":"123393","confirmation_number":"BV12259069904","room_confirmation_number":"BV12421451063","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131115","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-21 02:02:57","reservation_modified_date_time":"2021-09-21 02:02:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131115","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":"5316127","reservation_id":"123369","confirmation_number":"BP12247946376","room_confirmation_number":"BP12557263795","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131118","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-20 19:46:11","reservation_modified_date_time":"2021-09-21 02:30:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131118","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":"5315894","reservation_id":"121832","confirmation_number":"BV12286447176","room_confirmation_number":"BV12458356001","room_stay_from":"2021-10-28","room_stay_to":"2021-10-31","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":"129354","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-24 12:52:34","reservation_modified_date_time":"2021-09-20 17:39:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72194","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315911","reservation_id":"92374","confirmation_number":"PB12285958246","room_confirmation_number":"PB12379734466","room_stay_from":"2022-02-22","room_stay_to":"2022-03-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","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23575","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-22 19:22:53","reservation_modified_date_time":"2021-09-20 17:55:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23575","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"3140302","reservation_id":"84126","confirmation_number":"PB12234334995","room_confirmation_number":"PB12318376756","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Canceled","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-15 14:02:46","reservation_modified_date_time":"2020-09-28 18:57:10","customer_id":"32420","parentCustTravId":"32420","customer_traveller_id":"32420","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-21 00:51:38","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#12","parentRoomStayFrom":"2021-09-19","sub_hotel_id":"123","deltaChange":-12,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5315745","reservation_id":"123311","confirmation_number":"PB12240450701","room_confirmation_number":"PB12347072423","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":"22.60","paid_amount":"22.60","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-20 14:32:27","reservation_modified_date_time":"2021-09-20 14:32:27","customer_id":"131024","parentCustTravId":"131024","customer_traveller_id":"131024","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-09-19","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5315960","reservation_id":"123297","confirmation_number":"PB12297083639","room_confirmation_number":"PB12397134844","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-09-20 18:09:15","reservation_modified_date_time":"2021-09-20 18:33:01","customer_id":"131085","parentCustTravId":"131085","customer_traveller_id":"131085","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-09-20","sub_hotel_id":"123","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":"5316035","reservation_id":"123377","confirmation_number":"PB12281337973","room_confirmation_number":"PB12389747712","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-09-20 22:27:55","reservation_modified_date_time":"2021-09-20 22:27:55","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":"5314525","reservation_id":"118725","confirmation_number":"PB12263321656","room_confirmation_number":"PB12374834234","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":"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-09-17 22:05:14","reservation_modified_date_time":"2021-09-17 22:05:14","customer_id":"125802","parentCustTravId":"125802","customer_traveller_id":"125802","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-09-20 20:13:24","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-09-17","sub_hotel_id":"123","deltaChange":-37.4,"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":[],"_taxable":[{"room_stay_id":"5316062","reservation_id":"123325","confirmation_number":"BV12492503228","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"115.43,104.35","nightly_discount":"0.00,5.73","subtotal":"219.78","grand_total":"262.05","paid_amount":"262.05","room_type_id":"309","product_id":"1226","siteminder_id":"","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"115.43","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131047","customer_id":"131047","source_of_creation":"Airbnb","reservation_created_date":"2021-09-19 21:31:11","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"16.14","commision_charges":"3.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"104.35","currentDayDiscount":"5.73","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"}]}]},"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":14,"holdBlockRooms":{"hold_room_count":"","block_room_count":"1106","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":[{"confirmation_number":"PB12225124166","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","bundle_room":"0","product_id":"1106"}],"bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5315241","reservation_id":"117417","confirmation_number":"PB12390736200","room_stay_from":"2021-09-18","room_stay_to":"2021-09-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"4","nightly_price":"99.81,88.12,88.12,88.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"364.17","grand_total":"411.51","paid_amount":"411.51","room_type_id":"289","product_id":"1100","siteminder_id":"BDC-2305901244","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"160.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"130953","customer_id":"130953","source_of_creation":"Booking.com","reservation_created_date":"2021-06-16 16:49:10","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 112","ota_service_fee_amount":"0","commision_charges":"181.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"88.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315633","reservation_id":"118847","confirmation_number":"PB12385687621","room_stay_from":"2021-09-19","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"137.97,137.97,137.97,137.97,137.97","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"689.85","grand_total":"779.53","paid_amount":"779.53","room_type_id":"289","product_id":"1123","siteminder_id":"BDC-2448117502","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":"56581","customer_id":"56581","source_of_creation":"Booking.com","reservation_created_date":"2021-07-07 13:56:37","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 104","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"137.97","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315891","reservation_id":"123339","confirmation_number":"PB12360216037","room_stay_from":"2021-09-20","room_stay_to":"2021-09-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"104.49,104.49","nightly_discount":"0,0","subtotal":"208.98","grand_total":"236.15","paid_amount":"236.15","room_type_id":"289","product_id":"1101","siteminder_id":"BDC-3242430469","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":"131078","customer_id":"131078","source_of_creation":"Booking.com","reservation_created_date":"2021-09-20 06:24:13","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 114","ota_service_fee_amount":"0","commision_charges":"40.35","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"104.49","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315962","reservation_id":"123297","confirmation_number":"PB12397134844","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"106.14","nightly_discount":"0","subtotal":"106.14","grand_total":"119.94","paid_amount":"119.94","room_type_id":"289","product_id":"1111","siteminder_id":"BDC-3666488326","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":"131085","customer_id":"131085","source_of_creation":"Booking.com","reservation_created_date":"2021-09-19 15:39:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 211","ota_service_fee_amount":"0","commision_charges":"18.92","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"106.14","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":"5316008","reservation_id":"117417","confirmation_number":"PB12398677582","room_stay_from":"2021-09-18","room_stay_to":"2021-09-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"129.81,118.12,118.12,118.12","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"484.17","grand_total":"547.11","paid_amount":"547.11","room_type_id":"289","product_id":"1103","siteminder_id":"BDC-2305901244","collect_which":"hotel_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":"130953","customer_id":"130953","source_of_creation":"Booking.com","reservation_created_date":"2021-06-16 16:49:15","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 118","ota_service_fee_amount":"0","commision_charges":"181.28","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","currentDayPrice":"118.12","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5315521","reservation_id":"118251","confirmation_number":"PB12385192112","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"153.30,153.30","nightly_discount":"0,0","subtotal":"306.60","grand_total":"346.46","paid_amount":"346.46","room_type_id":"285","product_id":"1085","siteminder_id":"EXP-1792574586","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":"131038","customer_id":"131038","source_of_creation":"Expedia","reservation_created_date":"2021-06-28 18:10:12","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":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"153.30","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5315404","reservation_id":"123286","confirmation_number":"BP12579486578","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"72.83,72.83","nightly_discount":"0.00,0.00","subtotal":"145.66","grand_total":"164.60","paid_amount":"164.60","room_type_id":"289","product_id":"1096","siteminder_id":"GAM-R2815182944","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":"131022","customer_id":"131022","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-19 13:09:11","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 108","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"72.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":"5315772","reservation_id":"123344","confirmation_number":"PB12343820497","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"94.75","nightly_discount":"0","subtotal":"94.75","grand_total":"107.07","paid_amount":"107.07","room_type_id":"289","product_id":"1102","siteminder_id":"GAM-R2817365459","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":"130912","customer_id":"130912","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-20 14:39:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 115","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","currentDayPrice":"94.75","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"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":"5313146","reservation_id":"115863","confirmation_number":"PB12360453945","room_stay_from":"2021-09-14","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,120.00,120.00,140.00,140.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,42.23","subtotal":"880.00","grand_total":"946.68","paid_amount":"946.68","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":"54747","customer_id":"54747","source_of_creation":"FE","reservation_created_date":"2021-05-25 17:15:43","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":"120.00","currentDayDiscount":"42.23","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315228","reservation_id":"117506","confirmation_number":"PB12348741017","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"130.00,130.00,130.00,130.00,130.00,150.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"800.00","grand_total":"904.00","paid_amount":"904.00","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":"124468","customer_id":"124468","source_of_creation":"FE","reservation_created_date":"2021-06-17 21:17:03","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":"130.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5312986","reservation_id":"119501","confirmation_number":"PB12361050085","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"149.00,169.00,169.00,149.00,149.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"785.00","grand_total":"887.05","paid_amount":"887.05","room_type_id":"291","product_id":"1117","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"126655","customer_id":"126655","source_of_creation":"PMS","reservation_created_date":"2021-07-17 15:18:40","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 210","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"149.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5314099","reservation_id":"84692","confirmation_number":"PB12350144146","room_stay_from":"2021-09-16","room_stay_to":"2021-09-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"124.00,124.00,124.00,124.00,124.00,124.00,124.00,124.00,124.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,55.00","subtotal":"1116.00","grand_total":"1198.93","paid_amount":"1198.93","room_type_id":"289","product_id":"1098","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"31302","customer_id":"31302","source_of_creation":"PMS","reservation_created_date":"2019-09-25 19:26:52","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 110","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"124.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5314492","reservation_id":"117963","confirmation_number":"PB12384633035","room_stay_from":"2021-09-17","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,120.00,120.00,120.00,120.00,120.00,140.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,56.40","subtotal":"1160.00","grand_total":"1247.07","paid_amount":"1247.07","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":"36411","customer_id":"36411","source_of_creation":"PMS","reservation_created_date":"2021-06-24 12:27:06","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","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":"5314494","reservation_id":"117963","confirmation_number":"PB12351323223","room_stay_from":"2021-09-17","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"140.00,140.00,120.00,120.00,120.00,120.00,120.00,140.00,140.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,56.40","subtotal":"1160.00","grand_total":"1247.07","paid_amount":"1247.07","room_type_id":"289","product_id":"1109","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"36411","customer_id":"36411","source_of_creation":"PMS","reservation_created_date":"2021-06-24 12:27:06","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","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":"5314545","reservation_id":"119514","confirmation_number":"PB12373721075","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"158.00,158.00,138.00,138.00,138.00,138.00,138.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,46.60","subtotal":"1006.00","grand_total":"1084.12","paid_amount":"1084.12","room_type_id":"291","product_id":"1119","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"56188","customer_id":"56188","source_of_creation":"PMS","reservation_created_date":"2021-07-17 16:53:51","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 2Q, 1SS 214","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"138.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5314569","reservation_id":"100532","confirmation_number":"PB12363274350","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"140.00,140.00,120.00,120.00,120.00,120.00,120.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,48.19","subtotal":"880.00","grand_total":"939.95","paid_amount":"939.95","room_type_id":"289","product_id":"1093","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"36512","customer_id":"36512","source_of_creation":"PMS","reservation_created_date":"2020-09-18 15:16:28","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 105","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"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":"5314847","reservation_id":"118362","confirmation_number":"PB12375888661","room_stay_from":"2021-09-20","room_stay_to":"2021-09-27","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"199.00,149.00,149.00,169.00,169.00,149.00,149.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"1133.00","grand_total":"1280.29","paid_amount":"1280.29","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":"125379","customer_id":"125379","source_of_creation":"PMS","reservation_created_date":"2021-06-30 00:08:23","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":"199.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315158","reservation_id":"100534","confirmation_number":"PB12324170496","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"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,61.59","subtotal":"1342.00","grand_total":"1446.86","paid_amount":"1446.86","room_type_id":"287","product_id":"1087","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"90237","customer_id":"90237","source_of_creation":"PMS","reservation_created_date":"2020-09-18 15:20:34","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":null,"sub_hotel_id":"123","group_rooms":null,"currentDayPrice":"186.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315257","reservation_id":"123296","confirmation_number":"PB12368455723","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"122.09,129.09","nightly_discount":"0.00,0.00","subtotal":"251.18","grand_total":"283.83","paid_amount":"283.83","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":"131013","customer_id":"131013","source_of_creation":"PMS","reservation_created_date":"2021-09-19 15:37:24","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":"129.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":"5315421","reservation_id":"100931","confirmation_number":"PB12383993339","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"25.85,0.00,0.00,0.00,0.00,0.00","subtotal":"534.00","grand_total":"574.21","paid_amount":"574.21","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":"27863","customer_id":"27863","source_of_creation":"PMS","reservation_created_date":"2020-09-28 18:41:16","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":null,"sub_hotel_id":"123","group_rooms":null,"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":"5315427","reservation_id":"100926","confirmation_number":"PB12330901468","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,25.85","subtotal":"534.00","grand_total":"574.21","paid_amount":"574.21","room_type_id":"289","product_id":"1112","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"27794","customer_id":"27794","source_of_creation":"PMS","reservation_created_date":"2020-09-28 17:41:21","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 215","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"123","group_rooms":null,"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":"5315438","reservation_id":"100929","confirmation_number":"PB12335422408","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"25.85,0.00,0.00,0.00,0.00,0.00","subtotal":"534.00","grand_total":"574.21","paid_amount":"574.21","room_type_id":"289","product_id":"1110","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":"27824","customer_id":"27824","source_of_creation":"PMS","reservation_created_date":"2020-09-28 18:22:09","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 209","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":"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":"5315469","reservation_id":"114440","confirmation_number":"PB12389734431","room_stay_from":"2021-09-19","room_stay_to":"2021-09-26","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"120.00,120.00,120.00,120.00,120.00,140.00,140.00","nightly_discount":"0.00,42.23,0.00,0.00,0.00,0.00,0.00","subtotal":"880.00","grand_total":"946.68","paid_amount":"946.68","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":"48470","customer_id":"48470","source_of_creation":"PMS","reservation_created_date":"2021-05-03 19:59:52","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","group_rooms":null,"currentDayPrice":"120.00","currentDayDiscount":"42.23","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315673","reservation_id":"116878","confirmation_number":"PB12345538933","room_stay_from":"2021-09-19","room_stay_to":"2021-09-30","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"186.00,186.00,186.00,186.00,186.00,206.00,206.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.00,0.00,101.60","subtotal":"2086.00","grand_total":"2242.37","paid_amount":"2242.37","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":"44420","customer_id":"44420","source_of_creation":"PMS","reservation_created_date":"2021-06-09 15:19:44","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":"186.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315716","reservation_id":"123300","confirmation_number":"PB12352553469","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"82.00,82.00","nightly_discount":"0.00,0","subtotal":"164.00","grand_total":"185.32","paid_amount":"185.32","room_type_id":"286","product_id":"1086","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":"131016","customer_id":"131016","source_of_creation":"PMS","reservation_created_date":"2021-09-19 16:05:48","canceled_nights_data":"","product_name":"PB Superior Gulf View Suite 1K 202","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","changedComment":"To date changed","deltaChange":"0.00","currentDayPrice":"82.00","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315811","reservation_id":"100928","confirmation_number":"PB12323878464","room_stay_from":"2021-09-20","room_stay_to":"2021-09-25","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,20.08,0.00,0.00,0.00","subtotal":"445.00","grand_total":"480.16","paid_amount":"480.16","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":"87885","customer_id":"87885","source_of_creation":"PMS","reservation_created_date":"2020-09-28 18:03:01","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","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":"5315942","reservation_id":"123360","confirmation_number":"PB12362519918","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.76","nightly_discount":"0.00","subtotal":"118.76","grand_total":"134.20","paid_amount":"134.20","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":"131082","customer_id":"131082","source_of_creation":"PMS","reservation_created_date":"2021-09-20 18:16:24","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":"118.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315945","reservation_id":"110292","confirmation_number":"PB12315212631","room_stay_from":"2021-09-20","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"201.00,201.00,201.00,201.00","nightly_discount":"0.00,32.55,0.00,0.00","subtotal":"804.00","grand_total":"871.74","paid_amount":"871.74","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":"116811","customer_id":"116811","source_of_creation":"PMS","reservation_created_date":"2021-03-14 19:06:46","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","currentDayPrice":"201.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5316024","reservation_id":"123375","confirmation_number":"PB12337941357","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.76","nightly_discount":"0.00","subtotal":"118.76","grand_total":"134.20","paid_amount":"134.20","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":"131095","customer_id":"131095","source_of_creation":"PMS","reservation_created_date":"2021-09-20 21:32:49","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","currentDayPrice":"118.76","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5316038","reservation_id":"123378","confirmation_number":"PB12367910727","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"118.76","nightly_discount":"6.86","subtotal":"118.76","grand_total":"126.44","paid_amount":"126.44","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":"131098","customer_id":"131098","source_of_creation":"PMS","reservation_created_date":"2021-09-20 22:28:08","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":"118.76","currentDayDiscount":"6.86","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5316054","reservation_id":"120122","confirmation_number":"BV12449503417","room_stay_from":"2021-09-20","room_stay_to":"2021-09-24","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","nightly_discount":"0.00,0.00,0.00,39.41","subtotal":"572.00","grand_total":"601.83","paid_amount":"601.83","room_type_id":"289","product_id":"1104","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"127375","customer_id":"127375","source_of_creation":"PMS","reservation_created_date":"2021-07-26 18:39:12","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 119","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"123","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"}]}],"pms_non_taxable":[{"room_stay_id":"3140301","reservation_id":"84126","confirmation_number":"PB12318376756","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Canceled","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"89.00,89.00,89.00,89.00,89.00,89.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"534.00","grand_total":"603.42","paid_amount":"100.00","room_type_id":"289","product_id":"1097","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"32420","customer_id":"32420","source_of_creation":"PMS","reservation_created_date":"2019-09-15 14:02:46","service_canceled_date_time":"2021-09-21 00:51:38","canceled_nights_data":"","product_name":"PB Deluxe Efficiency Suite 2Q, 1SS 109","ota_service_fee_amount":"0","commision_charges":"0.00","reservation_status_type":"room_dates_changed","total_paid_amount":"100.00","sub_hotel_id":"123","deltaChange":-0.5,"changedComment":"reservation is canceled but amt paid","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":true,"taxes":[]}],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"3137756","reservation_id":"100532","confirmation_number":"PB12247700804","room_confirmation_number":"PB12363274350","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","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":"36512","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2020-09-18 15:16:28","reservation_modified_date_time":"2020-09-18 15:16:28","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36512","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":"5314706","reservation_id":"117417","confirmation_number":"PB12284348670","room_confirmation_number":"PB12390736200","room_stay_from":"2021-09-18","room_stay_to":"2021-09-22","room_stay_status":"Active","nightly_price":"40,40,40,40","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"160.00","grand_total":"180.80","paid_amount":"180.80","product_id":"1780","service_quantity":"1","customer_traveller_id":"130953","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-06-16 18:04:10","reservation_modified_date_time":"2021-09-18 14:25:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130953","canceled_nights_data":"","posAmt_airbnb_taxpaid":"160.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":"5315889","reservation_id":"123339","confirmation_number":"PB12276210849","room_confirmation_number":"PB12360216037","room_stay_from":"2021-09-20","room_stay_to":"2021-09-22","room_stay_status":"Active","nightly_price":"10,10","nightly_discount":"0.00,0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"22.60","product_id":"1780","service_quantity":"1","customer_traveller_id":"131078","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-09-20 06:24:13","reservation_modified_date_time":"2021-09-20 17:37:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131078","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.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":"5312987","reservation_id":"119501","confirmation_number":"PB12255087664","room_confirmation_number":"PB12361050085","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","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":"126655","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-17 15:18:40","reservation_modified_date_time":"2021-09-14 13:53:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126655","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":"5313147","reservation_id":"115863","confirmation_number":"PB12247535593","room_confirmation_number":"PB12360453945","room_stay_from":"2021-09-14","room_stay_to":"2021-09-21","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":"54747","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-05-25 17:15:43","reservation_modified_date_time":"2021-09-14 16:24:45","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"54747","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":"5314100","reservation_id":"84692","confirmation_number":"PB12261220297","room_confirmation_number":"PB12350144146","room_stay_from":"2021-09-16","room_stay_to":"2021-09-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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":"31302","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2019-09-25 19:26:52","reservation_modified_date_time":"2021-09-16 19:04:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"31302","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":"5314493","reservation_id":"117963","confirmation_number":"PB12258573344","room_confirmation_number":"PB12384633035","room_stay_from":"2021-09-17","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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":"36411","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-06-24 12:27:06","reservation_modified_date_time":"2021-09-17 21:04:17","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36411","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":"5314495","reservation_id":"117963","confirmation_number":"PB12285032856","room_confirmation_number":"PB12351323223","room_stay_from":"2021-09-17","room_stay_to":"2021-09-26","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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":"36411","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-06-24 12:27:06","reservation_modified_date_time":"2021-09-17 21:04:52","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36411","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":"5314546","reservation_id":"119514","confirmation_number":"PB12251536820","room_confirmation_number":"PB12373721075","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","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":"56188","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-17 16:53:51","reservation_modified_date_time":"2021-09-17 22:56:21","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56188","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":"5314570","reservation_id":"100532","confirmation_number":"PB12254007719","room_confirmation_number":"PB12363274350","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","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":"36512","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-18 15:16:28","reservation_modified_date_time":"2021-09-17 23:53:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"36512","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":"5314848","reservation_id":"118362","confirmation_number":"PB12250242386","room_confirmation_number":"PB12375888661","room_stay_from":"2021-09-20","room_stay_to":"2021-09-27","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":"125379","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-06-30 00:08:23","reservation_modified_date_time":"2021-09-18 17:30:25","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"125379","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":"5315160","reservation_id":"100534","confirmation_number":"PB12238639092","room_confirmation_number":"PB12324170496","room_stay_from":"2021-09-17","room_stay_to":"2021-09-24","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":"74.91","product_id":"1781","service_quantity":"1","customer_traveller_id":"90237","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-18 15:20:34","reservation_modified_date_time":"2021-09-19 14:27:12","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"90237","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":"5315229","reservation_id":"117506","confirmation_number":"PB12275115826","room_confirmation_number":"PB12348741017","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"124468","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-06-17 21:17:04","reservation_modified_date_time":"2021-09-19 15:17:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124468","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":"5315243","reservation_id":"117417","confirmation_number":"PB12270188218","room_confirmation_number":"PB12390736200","room_stay_from":"2021-09-18","room_stay_to":"2021-09-22","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"130953","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-06-16 16:49:10","reservation_modified_date_time":"2021-09-19 15:26:26","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130953","canceled_nights_data":"","posAmt_airbnb_taxpaid":"160.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":"5315258","reservation_id":"123296","confirmation_number":"PB12296037336","room_confirmation_number":"PB12368455723","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","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":"131013","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-19 15:37:24","reservation_modified_date_time":"2021-09-19 15:41:18","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131013","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":"5315406","reservation_id":"123286","confirmation_number":"BP12298394478","room_confirmation_number":"BP12579486578","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","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":"131022","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-19 13:09:11","reservation_modified_date_time":"2021-09-19 17:00:14","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131022","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":"5315422","reservation_id":"100931","confirmation_number":"PB12277670217","room_confirmation_number":"PB12383993339","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"27863","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-28 18:41:16","reservation_modified_date_time":"2021-09-19 17:24:05","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27863","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":"5315428","reservation_id":"100926","confirmation_number":"PB12263019778","room_confirmation_number":"PB12330901468","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"27794","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-28 17:41:21","reservation_modified_date_time":"2021-09-19 17:28:10","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27794","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":"5315439","reservation_id":"100929","confirmation_number":"PB12255773683","room_confirmation_number":"PB12335422408","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"81.36","product_id":"1781","service_quantity":"1","customer_traveller_id":"27824","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-28 18:22:09","reservation_modified_date_time":"2021-09-19 17:38:54","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"27824","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":"5315470","reservation_id":"114440","confirmation_number":"PB12277826531","room_confirmation_number":"PB12389734431","room_stay_from":"2021-09-19","room_stay_to":"2021-09-26","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":"48470","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-05-03 19:59:52","reservation_modified_date_time":"2021-09-19 18:09:56","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"48470","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":"5315520","reservation_id":"118251","confirmation_number":"PB12278633110","room_confirmation_number":"PB12385192112","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","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":"131038","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-06-28 18:10:12","reservation_modified_date_time":"2021-09-19 20:36:07","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131038","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":"5315635","reservation_id":"118847","confirmation_number":"PB12246516698","room_confirmation_number":"PB12385687621","room_stay_from":"2021-09-19","room_stay_to":"2021-09-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"72.98","product_id":"1781","service_quantity":"1","customer_traveller_id":"56581","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-07 13:56:37","reservation_modified_date_time":"2021-09-19 23:52:34","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"56581","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":"5315674","reservation_id":"116878","confirmation_number":"PB12288967794","room_confirmation_number":"PB12345538933","room_stay_from":"2021-09-19","room_stay_to":"2021-09-30","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":"44420","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-06-09 15:19:44","reservation_modified_date_time":"2021-09-20 01:00:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"44420","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":"5315717","reservation_id":"123300","confirmation_number":"PB12236283709","room_confirmation_number":"PB12352553469","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","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":"131016","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-19 16:05:48","reservation_modified_date_time":"2021-09-20 12:47:13","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131016","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":"5315773","reservation_id":"123344","confirmation_number":"PB12275326890","room_confirmation_number":"PB12343820497","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"130912","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-20 14:39:12","reservation_modified_date_time":"2021-09-20 14:57:55","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130912","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":"5315812","reservation_id":"100928","confirmation_number":"PB12265063460","room_confirmation_number":"PB12323878464","room_stay_from":"2021-09-20","room_stay_to":"2021-09-25","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":"87885","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-09-28 18:03:01","reservation_modified_date_time":"2021-09-20 15:48:19","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"87885","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":"5315890","reservation_id":"123339","confirmation_number":"PB12237655522","room_confirmation_number":"PB12360216037","room_stay_from":"2021-09-20","room_stay_to":"2021-09-22","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":"131078","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-20 06:24:13","reservation_modified_date_time":"2021-09-20 17:37:20","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131078","canceled_nights_data":"","posAmt_airbnb_taxpaid":"20.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":"5315943","reservation_id":"123360","confirmation_number":"PB12221462269","room_confirmation_number":"PB12362519918","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131082","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-20 18:16:24","reservation_modified_date_time":"2021-09-20 18:16:24","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131082","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":"5315944","reservation_id":"110292","confirmation_number":"PB12218471731","room_confirmation_number":"PB12315212631","room_stay_from":"2021-09-20","room_stay_to":"2021-09-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"116811","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-03-14 19:06:46","reservation_modified_date_time":"2021-09-20 18:24:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"116811","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":"5315961","reservation_id":"123297","confirmation_number":"PB12296042476","room_confirmation_number":"PB12397134844","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131085","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-19 15:39:11","reservation_modified_date_time":"2021-09-20 18:33:01","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131085","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":"5316010","reservation_id":"117417","confirmation_number":"PB12269731888","room_confirmation_number":"PB12398677582","room_stay_from":"2021-09-18","room_stay_to":"2021-09-22","room_stay_status":"Active","nightly_price":"20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"130953","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-06-16 16:49:15","reservation_modified_date_time":"2021-09-20 20:32:52","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130953","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":"5316025","reservation_id":"123375","confirmation_number":"PB12233638246","room_confirmation_number":"PB12337941357","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131095","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-20 21:32:49","reservation_modified_date_time":"2021-09-20 21:32:49","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131095","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":"5316039","reservation_id":"123378","confirmation_number":"PB12230282542","room_confirmation_number":"PB12367910727","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131098","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-20 22:28:08","reservation_modified_date_time":"2021-09-20 22:29:58","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131098","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":"5316055","reservation_id":"120122","confirmation_number":"BV12251264626","room_confirmation_number":"BV12449503417","room_stay_from":"2021-09-20","room_stay_to":"2021-09-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"48.00","grand_total":"54.24","paid_amount":"54.24","product_id":"1781","service_quantity":"1","customer_traveller_id":"127375","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-26 18:39:12","reservation_modified_date_time":"2021-09-20 23:41:02","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127375","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":"3140302","reservation_id":"84126","confirmation_number":"PB12234334995","room_confirmation_number":"PB12318376756","room_stay_from":"2021-09-19","room_stay_to":"2021-09-25","room_stay_status":"Canceled","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"72.00","grand_total":"81.36","paid_amount":"0.00","product_id":"1781","service_quantity":"1","product_name":"Resort Fee","parentTypeOfRes":"reservation","reservation_created_date":"2019-09-15 14:02:46","reservation_modified_date_time":"2020-09-28 18:57:10","customer_id":"32420","parentCustTravId":"32420","customer_traveller_id":"32420","static_pos_type":null,"product_is_timebound":"1","tax_exempt_status":"0","traveller_tax_exempt":"0","product_discount":"0.00","service_canceled_date_time":"2021-09-21 00:51:38","canceled_nights_data":"","product_attribute_values":"resort_fee#&#flat_rate#&#12","parentRoomStayFrom":"2021-09-19","sub_hotel_id":"123","deltaChange":-12,"changedComment":"reservation is canceled","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[{"room_stay_id":"5315745","reservation_id":"123311","confirmation_number":"PB12240450701","room_confirmation_number":"PB12347072423","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":"22.60","paid_amount":"22.60","product_id":"1141","service_quantity":"1","product_name":"1 hour extra, Late C\/O","parentTypeOfRes":"reservation","reservation_created_date":"2021-09-20 14:32:27","reservation_modified_date_time":"2021-09-20 14:32:27","customer_id":"131024","parentCustTravId":"131024","customer_traveller_id":"131024","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-09-19","sub_hotel_id":"123","currentDayPrice":"20.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"alcoholicDrinks":false,"taxes":[{"tax_id":"97","tax_name":"Lodging Tax","tax_percentage":"13.00"}]},{"room_stay_id":"5315960","reservation_id":"123297","confirmation_number":"PB12297083639","room_confirmation_number":"PB12397134844","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-09-20 18:09:15","reservation_modified_date_time":"2021-09-20 18:33:01","customer_id":"131085","parentCustTravId":"131085","customer_traveller_id":"131085","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-09-20","sub_hotel_id":"123","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":"5316035","reservation_id":"123377","confirmation_number":"PB12281337973","room_confirmation_number":"PB12389747712","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-09-20 22:27:55","reservation_modified_date_time":"2021-09-20 22:27:55","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":"5314525","reservation_id":"118725","confirmation_number":"PB12263321656","room_confirmation_number":"PB12374834234","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":"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-09-17 22:05:14","reservation_modified_date_time":"2021-09-17 22:05:14","customer_id":"125802","parentCustTravId":"125802","customer_traveller_id":"125802","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-09-20 20:13:24","canceled_nights_data":"","product_attribute_values":null,"parentRoomStayFrom":"2021-09-17","sub_hotel_id":"123","deltaChange":-37.4,"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":[],"_taxable":[]}},"124":{"total_rooms_exist":"1139,1140,1218,1219,1220,1221,1222,1223,1224,1225,1226","departureCount":5,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"5314756","reservation_id":"120233","confirmation_number":"BV12431442855","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"2","nightly_price":"124.78,135.31,135.31,124.78,124.78","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"644.96","grand_total":"728.81","paid_amount":"728.81","room_type_id":"305","product_id":"1222","siteminder_id":"BDC-2720018353","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"50.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122153","customer_id":"122153","source_of_creation":"Booking.com","reservation_created_date":"2021-07-28 00:37:23","canceled_nights_data":"","product_name":"BV Superior Efficiency Suite 2D, 1SS 711","ota_service_fee_amount":"0","commision_charges":"380.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"124.78","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5314759","reservation_id":"120233","confirmation_number":"BV12480665875","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"2","nightly_price":"83.72,94.25,94.25,83.72,83.72","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"439.66","grand_total":"496.82","paid_amount":"496.82","room_type_id":"303","product_id":"1139","siteminder_id":"BDC-2720018353","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122153","customer_id":"122153","source_of_creation":"Booking.com","reservation_created_date":"2021-07-28 00:37:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 712","ota_service_fee_amount":"0","commision_charges":"380.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"83.72","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315443","reservation_id":"120233","confirmation_number":"BV12410380411","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"3","room_stay_child_count":"1","nightly_price":"91.62,102.15,102.15,91.62,91.62","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"479.16","grand_total":"541.45","paid_amount":"541.45","room_type_id":"303","product_id":"1140","siteminder_id":"BDC-2720018353","collect_which":"hotel_collect","posAmt_airbnb_taxpaid":"100.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"122153","customer_id":"122153","source_of_creation":"Booking.com","reservation_created_date":"2021-07-28 00:37:18","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D, 1SS 713","ota_service_fee_amount":"0","commision_charges":"380.50","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"91.62","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5316022","reservation_id":"123374","confirmation_number":"BV12442732287","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.49","nightly_discount":"0","subtotal":"77.49","grand_total":"87.56","paid_amount":"87.56","room_type_id":"304","product_id":"1219","siteminder_id":"EXP-1832602334","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":"131094","customer_id":"131094","source_of_creation":"Expedia","reservation_created_date":"2021-09-20 21:19:10","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":null,"sub_hotel_id":"124","currentDayPrice":"77.49","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5316032","reservation_id":"123373","confirmation_number":"BV12412229714","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"71.53","nightly_discount":"0","subtotal":"71.53","grand_total":"80.83","paid_amount":"80.83","room_type_id":"304","product_id":"1220","siteminder_id":"EXP-1832592764","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":"131097","customer_id":"131097","source_of_creation":"Expedia","reservation_created_date":"2021-09-20 20:59:11","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 723","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"71.53","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5316108","reservation_id":"123387","confirmation_number":"BV12473178746","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"72.18","nightly_discount":"0","subtotal":"72.18","grand_total":"81.56","paid_amount":"81.56","room_type_id":"308","product_id":"1225","siteminder_id":"GAM-R2818940589","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":"131111","customer_id":"131111","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-21 01:00:14","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 2D, 1SS 717","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","currentDayPrice":"72.18","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"gam_non_taxable":[],"zoo_taxable":[],"zoo_non_taxable":[],"abb_taxable":[{"room_stay_id":"5315102","reservation_id":"123285","confirmation_number":"BV12494680867","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"77.60","nightly_discount":"0","subtotal":"77.60","grand_total":"101.25","paid_amount":"101.25","room_type_id":"307","product_id":"1224","siteminder_id":"ABB-HMJBHEXDRX","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"77.60","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131005","customer_id":"131005","source_of_creation":"Airbnb","reservation_created_date":"2021-09-19 12:54:12","canceled_nights_data":"","product_name":"BV Deluxe Efficiency Suite 2D 714","ota_service_fee_amount":"10.85","commision_charges":"2.40","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"124","group_rooms":null,"currentDayPrice":"77.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00","abb_tax_paid_pms":"0.00","abb_tax_paid_sm":"6.00"}]}],"abb_non_taxable":[],"hwr_taxable":[],"hwr_non_taxable":[],"gcc_taxable":[],"gcc_non_taxable":[],"ago_taxable":[],"ago_non_taxable":[],"fe_taxable":[],"fe_non_taxable":[],"pms_taxable":[{"room_stay_id":"5316066","reservation_id":"123342","confirmation_number":"BV12491680992","room_stay_from":"2021-09-20","room_stay_to":"2021-09-22","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"145.53,128.07","nightly_discount":"0.00,0.00","subtotal":"273.60","grand_total":"309.17","paid_amount":"309.17","room_type_id":"306","product_id":"1223","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"124276","customer_id":"124276","source_of_creation":"PMS","reservation_created_date":"2021-09-20 13:14:38","canceled_nights_data":"","product_name":"BV Penthouse with Balcony Suite 1K, 2SS 722","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"145.53","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5316118","reservation_id":"123393","confirmation_number":"BV12421451063","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"85.00","nightly_discount":"0.00","subtotal":"85.00","grand_total":"96.05","paid_amount":"96.05","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131115","customer_id":"131115","source_of_creation":"PMS","reservation_created_date":"2021-09-21 02:02:57","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"85.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315893","reservation_id":"121832","confirmation_number":"BV12458356001","room_stay_from":"2021-10-28","room_stay_to":"2021-10-31","room_stay_status":"Active","room_stay_guest_count":"1","room_stay_child_count":"0","nightly_price":"143.00,163.00,163.00","nightly_discount":"0.00,0.00,0.00","subtotal":"469.00","grand_total":"529.97","paid_amount":"161.59","room_type_id":"304","product_id":"1221","siteminder_id":"","collect_which":"","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"0.00","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"72194","customer_id":"72194","source_of_creation":"PMS","reservation_created_date":"2021-08-24 12:52:34","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q 724","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[{"room_stay_id":"5314357","reservation_id":"120233","confirmation_number":"BV12269898204","room_confirmation_number":"BV12410380411","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"122153","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-07-29 17:53:11","reservation_modified_date_time":"2021-09-17 15:12:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"5314360","reservation_id":"120233","confirmation_number":"BV12260710378","room_confirmation_number":"BV12431442855","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"10,10,10,10,10","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"50.00","grand_total":"56.50","paid_amount":"56.50","product_id":"1780","service_quantity":"1","customer_traveller_id":"122153","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-07-29 17:53:14","reservation_modified_date_time":"2021-09-17 15:12:28","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.00","sub_hotel_id":"124","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":"5314363","reservation_id":"120233","confirmation_number":"BV12225355049","room_confirmation_number":"BV12480665875","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"122153","product_attribute_values":"extra_person#&#10","reservation_created_date":"2021-07-29 17:53:08","reservation_modified_date_time":"2021-09-17 15:12:30","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"5315754","reservation_id":"123325","confirmation_number":"BV12295469244","room_confirmation_number":"BV12492503228","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"0.00,0.00","nightly_discount":"0.00,0.00","subtotal":"0.00","grand_total":"0.00","paid_amount":"0.00","product_id":"1780","service_quantity":"1","customer_traveller_id":"131047","product_attribute_values":"extra_person#&#10.00","reservation_created_date":"2021-09-19 22:52:37","reservation_modified_date_time":"2021-09-19 22:52:53","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131047","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"}]}],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"5314758","reservation_id":"120233","confirmation_number":"BV12272814686","room_confirmation_number":"BV12431442855","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"62.98","product_id":"1781","service_quantity":"1","customer_traveller_id":"127499","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-28 00:37:23","reservation_modified_date_time":"2021-09-18 15:03:02","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"50.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":"5314761","reservation_id":"120233","confirmation_number":"BV12212394206","room_confirmation_number":"BV12480665875","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"62.98","product_id":"1781","service_quantity":"1","customer_traveller_id":"122153","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-28 00:37:12","reservation_modified_date_time":"2021-09-18 15:03:12","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"5315103","reservation_id":"123285","confirmation_number":"BV12230886404","room_confirmation_number":"BV12494680867","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131005","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-19 12:54:12","reservation_modified_date_time":"2021-09-19 12:54:12","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131005","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","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":"5315445","reservation_id":"120233","confirmation_number":"BV12236518209","room_confirmation_number":"BV12410380411","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"127499","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-28 00:37:18","reservation_modified_date_time":"2021-09-19 17:40:19","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"122153","canceled_nights_data":"","posAmt_airbnb_taxpaid":"100.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":"5316023","reservation_id":"123374","confirmation_number":"BV12212680303","room_confirmation_number":"BV12442732287","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131094","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-20 21:19:10","reservation_modified_date_time":"2021-09-20 21:19:10","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131094","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":"5316031","reservation_id":"123373","confirmation_number":"BV12242874681","room_confirmation_number":"BV12412229714","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131097","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-20 20:59:11","reservation_modified_date_time":"2021-09-20 22:11:45","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131097","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":"5316063","reservation_id":"123325","confirmation_number":"BV12234858004","room_confirmation_number":"BV12492503228","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,12.00","nightly_discount":"0.00,0.00","subtotal":"32.00","grand_total":"36.16","paid_amount":"36.16","product_id":"1781","service_quantity":"1","customer_traveller_id":"131047","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-19 21:31:11","reservation_modified_date_time":"2021-09-20 23:55:58","collect_which":"airbnb_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131047","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","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":"5316067","reservation_id":"123342","confirmation_number":"BV12244727401","room_confirmation_number":"BV12491680992","room_stay_from":"2021-09-20","room_stay_to":"2021-09-22","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":"124276","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-20 13:14:38","reservation_modified_date_time":"2021-09-21 00:11:43","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"124276","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":"5316107","reservation_id":"123387","confirmation_number":"BV12281186369","room_confirmation_number":"BV12473178746","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131111","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-21 01:00:14","reservation_modified_date_time":"2021-09-21 01:33:12","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131111","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":"5316119","reservation_id":"123393","confirmation_number":"BV12259069904","room_confirmation_number":"BV12421451063","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131115","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-09-21 02:02:57","reservation_modified_date_time":"2021-09-21 02:02:57","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131115","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":"5315894","reservation_id":"121832","confirmation_number":"BV12286447176","room_confirmation_number":"BV12458356001","room_stay_from":"2021-10-28","room_stay_to":"2021-10-31","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":"129354","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-08-24 12:52:34","reservation_modified_date_time":"2021-09-20 17:39:53","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"72194","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"124","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[],"_taxable":[{"room_stay_id":"5316062","reservation_id":"123325","confirmation_number":"BV12492503228","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"1","nightly_price":"115.43,104.35","nightly_discount":"0.00,5.73","subtotal":"219.78","grand_total":"262.05","paid_amount":"262.05","room_type_id":"309","product_id":"1226","siteminder_id":"","collect_which":"airbnb_collect","posAmt_airbnb_taxpaid":"0.00","roomAmt_airbnb_taxpaid":"115.43","negotiated_rate_resv":"0","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_traveller_id":"131047","customer_id":"131047","source_of_creation":"Airbnb","reservation_created_date":"2021-09-19 21:31:11","canceled_nights_data":"","product_name":"BV Bay Front with Balcony Suite 1Q, 1SS 721","ota_service_fee_amount":"16.14","commision_charges":"3.57","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":"","sub_hotel_id":"124","currentDayPrice":"104.35","currentDayDiscount":"5.73","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"}]}]}},"125":{"total_rooms_exist":"1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138","departureCount":5,"holdBlockRooms":{"hold_room_count":"","block_room_count":"","bundle_block_count":"","hold_room_bookings":[],"block_room_bookings":"","bundle_block_bookings":""},"resvInfo":{"bdc_taxable":[{"room_stay_id":"3295250","reservation_id":"120230","confirmation_number":"BP12529517840","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"155.61,168.21,168.21,155.61,155.61","nightly_discount":"0,0,0,0,0","subtotal":"803.25","grand_total":"907.68","paid_amount":"907.68","room_type_id":"302","product_id":"1138","siteminder_id":"BDC-2647541310","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":"127495","customer_id":"127495","source_of_creation":"Booking.com","reservation_created_date":"2021-07-27 23:48:08","canceled_nights_data":"","product_name":"BP Deluxe One Bedroom Suite 2Q, 2SS 821","ota_service_fee_amount":"0","commision_charges":"162.60","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"155.61","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"bdc_non_taxable":[],"exp_taxable":[{"room_stay_id":"5313535","reservation_id":"119303","confirmation_number":"BP12565987447","room_stay_from":"2021-09-15","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"70.60,70.60,79.48,79.48,70.60,70.60","nightly_discount":"0,0,0,0,0,0","subtotal":"441.36","grand_total":"498.74","paid_amount":"498.74","room_type_id":"298","product_id":"1133","siteminder_id":"EXP-1800762448","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":"130764","customer_id":"130764","source_of_creation":"Expedia","reservation_created_date":"2021-07-14 13:20:12","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":"70.60","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"exp_non_taxable":[],"htn_taxable":[{"room_stay_id":"5316128","reservation_id":"123369","confirmation_number":"BP12557263795","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.24","nightly_discount":"0","subtotal":"67.24","grand_total":"75.98","paid_amount":"75.98","room_type_id":"294","product_id":"1126","siteminder_id":"HTN-174235573-DXP2TR","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":"131118","customer_id":"131118","source_of_creation":"HotelTonight","reservation_created_date":"2021-09-20 19:46:11","canceled_nights_data":"","product_name":"BP One Bedroom Suite: 1Q, 1SS 806","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","currentDayPrice":"67.24","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"htn_non_taxable":[],"pcl_taxable":[],"pcl_non_taxable":[],"gam_taxable":[{"room_stay_id":"5315552","reservation_id":"122384","confirmation_number":"BP12547579842","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"75.14,75.14","nightly_discount":"0,0","subtotal":"150.28","grand_total":"169.82","paid_amount":"169.82","room_type_id":"295","product_id":"1128","siteminder_id":"GAM-R2777112560","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":"131042","customer_id":"131042","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-02 01:40:13","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 801","ota_service_fee_amount":"0","commision_charges":"0.00","resv_is_no_show":"0","is_bundle":"0","migrated_id":"","promotion_code":null,"sub_hotel_id":"125","group_rooms":null,"currentDayPrice":"75.14","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":"5315814","reservation_id":"123172","confirmation_number":"BP12584443438","room_stay_from":"2021-09-20","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"67.03,67.03,67.03,67.03","nightly_discount":"0,0,0,0","subtotal":"268.12","grand_total":"302.98","paid_amount":"302.98","room_type_id":"293","product_id":"1124","siteminder_id":"GAM-R2810263355","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":"131069","customer_id":"131069","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-16 23:13:09","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","currentDayPrice":"67.03","currentDayDiscount":"0","productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]},{"room_stay_id":"5315989","reservation_id":"123065","confirmation_number":"BP12576215830","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"87.35","nightly_discount":"0","subtotal":"87.35","grand_total":"98.70","paid_amount":"98.70","room_type_id":"299","product_id":"1134","siteminder_id":"GAM-R2806024323","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":"130744","customer_id":"130744","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-15 03:34:08","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":null,"sub_hotel_id":"125","currentDayPrice":"87.35","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":"5315999","reservation_id":"123367","confirmation_number":"BP12530293501","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"64.10","nightly_discount":"0","subtotal":"64.10","grand_total":"72.44","paid_amount":"72.44","room_type_id":"294","product_id":"1125","siteminder_id":"GAM-R2818148427","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":"131088","customer_id":"131088","source_of_creation":"Getaroom.com","reservation_created_date":"2021-09-20 19:41:09","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":null,"sub_hotel_id":"125","currentDayPrice":"64.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"}]}],"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":"3282169","reservation_id":"119133","confirmation_number":"BP12533335440","room_stay_from":"2021-09-14","room_stay_to":"2021-09-24","room_stay_status":"Checked-In","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"93.00,93.00,93.00,113.00,113.00,93.00,93.00,93.00,93.00,93.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"970.00","grand_total":"1096.10","paid_amount":"1096.10","room_type_id":"295","product_id":"1129","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":"126251","customer_id":"126251","source_of_creation":"FE","reservation_created_date":"2021-07-11 18:56:11","canceled_nights_data":"","product_name":"BP Deluxe Efficiency Suite 1Q, 1SS 802","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":"93.00","currentDayDiscount":"0.00","productIsTaxExempt":false,"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":"5315910","reservation_id":"92374","confirmation_number":"PB12379734466","room_stay_from":"2022-02-22","room_stay_to":"2022-03-03","room_stay_status":"Active","room_stay_guest_count":"2","room_stay_child_count":"0","nightly_price":"171.00,171.00,171.00,171.00,171.00,171.00,171.00,171.00,171.00","nightly_discount":"0.00,0.00,0.00,0,0,0,0,0,0","subtotal":"1539.00","grand_total":"1739.07","paid_amount":"200.00","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":"23575","customer_id":"23575","source_of_creation":"PMS","reservation_created_date":"2020-02-22 19:22:53","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","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"pms_non_taxable":[],"negotiated_taxable":[],"negotiated_non_taxable":[],"migrated_taxable":[],"migrated_non_taxable":[],"extra_person_taxable":[],"extra_person_non_taxable":[],"resort_fee_taxable":[{"room_stay_id":"3282170","reservation_id":"119133","confirmation_number":"BP12216067559","room_confirmation_number":"BP12533335440","room_stay_from":"2021-09-14","room_stay_to":"2021-09-24","room_stay_status":"Active","nightly_price":"12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00,12.00","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":"126251","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2021-07-11 18:56:11","reservation_modified_date_time":"2021-07-11 18:56:11","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"126251","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":"3295251","reservation_id":"120230","confirmation_number":"BP12240526015","room_confirmation_number":"BP12529517840","room_stay_from":"2021-09-16","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20,20,20,20,20","nightly_discount":"0.00,0.00,0.00,0.00,0.00","subtotal":"100.00","grand_total":"113.00","paid_amount":"113.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"127495","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-27 23:48:08","reservation_modified_date_time":"2021-08-02 21:30:11","collect_which":"hotel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"127495","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.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"}]},{"room_stay_id":"5313534","reservation_id":"119303","confirmation_number":"BP12224041060","room_confirmation_number":"BP12565987447","room_stay_from":"2021-09-15","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00,0.00,0.00","subtotal":"120.00","grand_total":"135.60","paid_amount":"135.60","product_id":"1781","service_quantity":"1","customer_traveller_id":"130764","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-07-14 13:20:12","reservation_modified_date_time":"2021-09-15 15:48:31","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130764","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":"5315551","reservation_id":"122384","confirmation_number":"BP12241418921","room_confirmation_number":"BP12547579842","room_stay_from":"2021-09-19","room_stay_to":"2021-09-21","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":"131042","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-02 01:40:13","reservation_modified_date_time":"2021-09-19 21:28:06","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131042","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":"5315813","reservation_id":"123172","confirmation_number":"BP12229319067","room_confirmation_number":"BP12584443438","room_stay_from":"2021-09-20","room_stay_to":"2021-09-24","room_stay_status":"Active","nightly_price":"20.00,20.00,20.00,20.00","nightly_discount":"0.00,0.00,0.00,0.00","subtotal":"80.00","grand_total":"90.40","paid_amount":"90.40","product_id":"1781","service_quantity":"1","customer_traveller_id":"131069","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-16 23:13:09","reservation_modified_date_time":"2021-09-20 15:54:38","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131069","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":"5315988","reservation_id":"123065","confirmation_number":"BP12251177104","room_confirmation_number":"BP12576215830","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"130744","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-15 03:34:08","reservation_modified_date_time":"2021-09-20 19:47:28","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"130744","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":"5315998","reservation_id":"123367","confirmation_number":"BP12292646674","room_confirmation_number":"BP12530293501","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","room_stay_status":"Active","nightly_price":"20.00","nightly_discount":"0.00","subtotal":"20.00","grand_total":"22.60","paid_amount":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"131088","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-20 19:41:09","reservation_modified_date_time":"2021-09-20 20:09:57","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131088","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":"5316127","reservation_id":"123369","confirmation_number":"BP12247946376","room_confirmation_number":"BP12557263795","room_stay_from":"2021-09-20","room_stay_to":"2021-09-21","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":"131118","product_attribute_values":"resort_fee#&#flat_rate#&#20","reservation_created_date":"2021-09-20 19:46:11","reservation_modified_date_time":"2021-09-21 02:30:25","collect_which":"channel_collect","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"131118","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":"5315911","reservation_id":"92374","confirmation_number":"PB12285958246","room_confirmation_number":"PB12379734466","room_stay_from":"2022-02-22","room_stay_to":"2022-03-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","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":"0.00","product_id":"1781","service_quantity":"1","customer_traveller_id":"23575","product_attribute_values":"resort_fee#&#flat_rate#&#12","reservation_created_date":"2020-02-22 19:22:53","reservation_modified_date_time":"2021-09-20 17:55:55","collect_which":"","tax_exempt_status":"0","traveller_tax_exempt":"0","customer_id":"23575","canceled_nights_data":"","posAmt_airbnb_taxpaid":"0.00","sub_hotel_id":"125","changedComment":"both dates changed","deltaChange":"0.00","currentDayPrice":0,"currentDayDiscount":0,"productIsTaxExempt":false,"taxes":[{"tax_id":"98","tax_name":"Sales Tax","tax_percentage":"7.00"},{"tax_id":"129","tax_name":"Tourist Development Tax","tax_percentage":"6.00"}]}],"resort_fee_non_taxable":[],"gift_shop_taxable":[],"gift_shop_non_taxable":[],"bar_taxable":[],"bar_non_taxable":[],"restaurant_taxable":[],"restaurant_non_taxable":[],"_taxable":[]}}}